Migração de banco de dados Oracle para PostgreSQL.

Preparação do ambiente operacional. Processo de migração do SGBD. Otimização de desempenho do PostgreSQL. Criação e restauração de cópias de segurança.

Funções analíticas da linguagem Sql do Oracle.

Funções analíticas do oracle. Função RANK. Função DENSE_RANK. Função RATIO_REPORT. Funções LAG e LEAD.

Oracle Discoverer: guia do usuário.

Administration editon. Objetos e operações de uma área de negócios. Discoverer plus. Exportando folhas com o discoverer. Enviando folhas atráves de correio. eletrônico

Projeto físico de Data Warehouse no Oracle: um estudo de caso.

Este trabalho visa compartilhar a experiência no projeto físico de um DW desenvolvido pela Embrapa Informática Agropecuária utilizando o SGBD Oracle. São apresentadas algumas características do Oracle que favorecem a manutenção e o desempenho de consultas a um DW em geral, utilizando como exemplo o DW específico.

An Omniscient Scheduling Oracle for Systems with Harmonic Periods

Most real-time scheduling problems are known to be NP-complete. To enable accurate comparison between the schedules of heuristic algorithms and the optimal schedule, we introduce an omniscient oracle. This oracle provides schedules for periodic task sets with harmonic periods and variable resource requirements. Three different job value functions are described and implemented. Each corresponds to a different system goal. The oracle is used to examine the performance of different on-line schedulers under varying loads, including overload. We have compared the oracle against Rate Monotonic Scheduling, Statistical Rate Monotonic Scheduling, and Slack Stealing Job Admission Control Scheduling. Consistently, the oracle provides an upper bound on performance for the metric under consideration.

Salted fish products from the Coptic monastery at Bawit, Egypt: evidence from the bones and texts

Fish bone assemblages are described that were recently discovered in the storage area of two rooms, dated to the 7th century AD, from the monastery of Bawit, Egypt. The species composition, the reconstructed sizes of the fish and the find contexts show that this material represents pickled fish (salsamenta). This product was made in one case of medium-sized Clarias catfish, whereas another assemblage, found inside an amphora, consisted of small-sized fish, mainly cyprinids and alestiids. The latter product was stored in a Late Roman Amphora 5/6 of Palestinian origin, traditionally considered as a container for wine. The amphora was clearly re-used since the fish found in it are Nilotic species which excludes that the salsamenta came from outside Egypt. A few additional finds of fish inside amphorae were available, but due to the low number of bones it was unclear if salted fish products were stored in them. Textual information provided by ostraca and papyri from the same site shows that the monks exerted fishing activities themselves and also suggests that the production of pickled fish took place locally. One of the two Nilotic fish taxa (Labeo) that is specifically mentioned by written evidence is the most common ingredient found in the amphora with abundant fish remains. The paper ends with a brief summary of other faunal evidence for salted fish products from monastic and other historic sites in Egypt.