PTV - Pacote de Tempo de Validade para o SGBD Oracle

Embora há muito tempo já se tenha conhecimento da importância da recuperação de informações temporais, não existe um SGBD temporal que tenha sido desenvolvido unicamente para aplicações comerciais, que supra todas as necessidades e abranja todos os aspectos temporais necessários a estas aplicações. O SGBD da Oracle, a partir da versão 8i, possibilita a inserção de características temporais similares às de tempo de transação no BD, através de um pacote de tempo denominado Time Series Cartridge. Entretanto, em muitos casos, a utilização deste cartucho de tempo não é suficiente para que se possa implementar por completo tudo o que foi especificado na modelagem do sistema. A modelagem completa da realidade só é alcançada se forem utilizadas em conjunto as características de tempo de transação e de tempo de validade no banco de dados. Neste trabalho são sugeridos e implementados mecanismos para a inserção e o gerenciamento do tempo de validade no SGBD Oracle. O tempo de validade é administrado através da execução de funções, procedimentos, gatilhos e objetos, organizados em forma de um pacote, de maneira que este possa ser utilizado em conjunto com o Time Series Cartridge.

Avaliação do banco de dissertações e teses da associação brasileira de antropologia: uma análise cienciométrica

VITULLO, Nadia Aurora Vanti. Avaliação do banco de dissertações e teses da Associação Brasileira de Antropologia: uma análise cienciométrica. 2001. 143 f. Dissertaçao (Mestrado) - Curso de Mestrado em Biblioteconomia e Ciência da Informação, Pontifícia Universidade Católica de Campinas, Campinas, 2001.

Sistemas de gerenciamento de bibliotecas: riscos decorrentes do processo de migração de dados

This work aims to analyze risks related to information technology (IT) in procedures related to data migration. This is done considering ALEPH, Integrated Libray System (ILS) that migrated data to the Library Module present in the software called Sistema Integrado de Gestão de Atividades Acadêmicas (SIGAA) at the Zila Mamede Central Library at the Federal University of Rio Grande do Norte (UFRN) in Natal/Brazil. The methodological procedure used was of a qualitative exploratory research with the realization of case study at the referred library in order to better understand this phenomenon. Data collection was able once there was use of a semi-structured interview that was applied with (11) subjects that are employed at the library as well as in the Technology Superintendence at UFRN. In order to examine data Content analysis as well as thematic review process was performed. After data migration the results of the interview were then linked to both analysis units and their system register with category correspondence. The main risks detected were: data destruction; data loss; data bank communication failure; user response delay; data inconsistency and duplicity. These elements point out implication and generate disorders that affect external and internal system users and lead to stress, work duplicity and hassles. Thus, some measures were taken related to risk management such as adequate planning, central management support, and pilot test simulations. For the advantages it has reduced of: risk, occurrence of problems and possible unforeseen costs, and allows achieving organizational objectives, among other. It is inferred therefore that the risks present in data bank conversion in libraries exist and some are predictable, however, it is seen that librarians do not know or ignore and are not very worried in the identification risks in data bank conversion, their acknowledge would minimize or even extinguish them. Another important aspect to consider is the existence of few empirical research that deal specifically with this subject and thus presenting the new of new approaches in order to promote better understanding of the matter in the corporate environment of the information units

Análise de volatilidade, integração de preços e previsibilidade para o mercado brasileiro de camarão

The present paper has the purpose of investigate the dynamics of the volatility structure in the shrimp prices in the Brazilian fish market. Therefore, a description of the initial aspects of the shrimp price series was made. From this information, statistics tests were made and selected univariate models to be price predictors. Then, it was verified the existence of relationship of long-term equilibrium between the Brazilian and American imported shrimp and if, confirmed the relationship, whether or not there is a causal link between these assets, considering that the two countries had presented trade relations over the years. It is presented as an exploratory research of applied nature with quantitative approach. The database was collected through direct contact with the Companhia de Entrepostos e Armazéns Gerais de São Paulo (CEAGESP) and on the official website of American import, National Marine Fisheries Service - National Oceanic and Atmospheric Administration (NMFS- NOAA). The results showed that the great variability in the active price is directly related with the gain and loss of the market agents. The price series presents a strong seasonal and biannual effect. The average structure of price of shrimp in the last 12 years was R$ 11.58 and external factors besides the production and marketing (U.S. antidumping, floods and pathologies) strongly affected the prices. Among the tested models for predicting prices of shrimp, four were selected, which through the prediction methodologies of one step forward of horizon 12, proved to be statistically more robust. It was found that there is weak evidence of long-term equilibrium between the Brazilian and American shrimp, where equivalently, was not found a causal link between them. We concluded that the dynamic pricing of commodity shrimp is strongly influenced by external productive factors and that these phenomena cause seasonal effects in the prices. There is no relationship of long-term stability between the Brazilian and American shrimp prices, but it is known that Brazil imports USA production inputs, which somehow shows some dependence productive. To the market agents, the risk of interferences of the external prices cointegrated to Brazilian is practically inexistent. Through statistical modeling is possible to minimize the risk and uncertainty embedded in the fish market, thus, the sales and marketing strategies for the Brazilian shrimp can be consolidated and widespread

Caracterização batimétrica e fisicooceanográfica do canal de acesso ao porto de Cabedelo/PB: uma análise ambiental ao derrame de óleo

The State of Paraíba is one of the most dynamic states of Brazil, strategically located in the northeast, is notable for the excellent potential for integration of different transportation modes forming the states of Rio Grande do Norte, Pernambuco and Alagoas. The dynamic that occurs with port activity causes changes in the space where it is installed. And the elements of this space are always more than suffering direct or indirect influences as the flow in the port is expanded. Therefore, this region became subject to the accidental spillage of oil, because it presents a heavy traffic of ships of various sizes that can run aground or collide with oil causing accidental events. The study of geomorphological and sedimentological compositions of seafloor becomes important as more is known about the relationships between these parameters and associated fauna, and can identify their preferred habitats. The database background, acoustically collected along the proposed study area, is a wealth of information, which were duly examined, cataloged and made available. Such information can serve as an important tool, providing a geomorphological survey of the sedimentary area studied, and come to subsidize, in a flexible, future decision making. With the study area Port of Cabedelo, Paraíba - Brazil, this research aimed to evaluate the influence of the tidal surface and background in modeling the seabed, including the acquisition of information about the location of submerged rocky bodies and the depth of these bodies may turn out to be natural traps for the trapping of oil in case of leaks, and obtain the relationship between types of bed and the hydrodynamic conditions present in the region. In this context, for this study were collected bathymetric data (depth) and physical oceanographic (height of water column, water temperature, intensity and direction of currents, waves and turbidity), meteorological (rainfall, air temperature, humidity, winds and barometric pressure) of the access channel to the Port of Cabedelo / PB and its basin evolution (where the cruise ships dock), and includes tools of remote sensing (Landsat 7 ETM +, 2001), so that images and the results are integrated into Geographic Information Systems and used in the elaboration of measures aimed at environmental protection areas under the influence of this scale facilities, serving as a grant to prepare a contingency plan in case of oil spills in the region. The main findings highlight the techniques of using hydroacoustic data acquisition together bathymetric surveys of high and low frequency. From there, five were prepared in bathymetric pattern of Directorate of Hydrography and Navigation - DHN, with the depth in meters, on a scale of 1:2500 (Channel and Basin Evolution of Access to Port of Cabedelo), where there is a large extent possible beachrocks that hinder the movement of vessels in the port area, which can cause collisions, running aground and leaking oil. From the scatter diagram of the vectors of currents, it can be seen as the tidal stream and undergoes a channeling effect caused by the bidirectional effect of the tide (ebb and flood) in the basin of the Port of Cabedelo evolution in NW-direction SE and the highest speed of the currents occurs at low tide. The characterization weather for the period from 28/02 to 04/07/2010 values was within the expected average for the region of study. The multidisciplinary integration of products (digital maps and remote sensing images), proved to be efficient for the characterization of underwater geomorphological study area, reaching the aim to discriminate and enhance submerged structures, previously not visible in the images

Especificação e implementação de um modelo assíncrono para replicação, propagação e conciliação de bases de dados distribuídas

This graduate thesis proposes a model to asynchronously replicate heterogeneous databases. This model singularly combines -in a systematic way and in a single project -different concepts, techniques and paradigms related to the areas of database replication and management of heterogeneous databases. One of the main advantages of the replication is to allow applications to continue to process information, during time intervals when they are off the network and to trigger the database synchronization, as soon as the network connection is reestablished. Therefore, the model introduces a communication and update protocol that takes in consideration the environment of asynchronous characteristics used. As part of the work, a tool was developed in Java language, based on the model s premises in order to process, test, simulate and validate the proposed model

Determinação de dados de equilíbrio de fases para sistemas aquosos com eletrólitos

In the present work are established initially the fundamental relationships of thermodynamics that govern the equilibrium between phases, the models used for the description of the behavior non ideal of the liquid and vapor phases in conditions of low pressures. This work seeks the determination of vapor-liquid equilibrium (VLE) data for a series of multicomponents mixtures of saturated aliphatic hydrocarbons, prepared synthetically starting from substances with analytical degree and the development of a new dynamic cell with circulation of the vapor phase. The apparatus and experimental procedures developed are described and applied for the determination of VLE data. VLE isobarics data were obtained through a Fischer s ebulliometer of circulation of both phases, for the systems pentane + dodecane, heptane + dodecane and decane + dodecane. Using the two new dynamic cells especially projected, of easy operation and low cost, with circulation of the vapor phase, data for the systems heptane + decane + dodecane, acetone + water, tween 20 + dodecane, phenol + water and distillation curves of a gasoline without addictive were measured. Compositions of the equilibrium phases were found by densimetry, chromatography, and total organic carbon analyzer. Calibration curves of density versus composition were prepared from synthetic mixtures and the behavior excess volumes were evaluated. The VLE data obtained experimentally for the hydrocarbon and aqueous systems were submitted to the test of thermodynamic consistency, as well as the obtained from the literature data for another binary systems, mainly in the bank DDB (Dortmund Data Bank), where the Gibbs-Duhem equation is used obtaining a satisfactory data base. The results of the thermodynamic consistency tests for the binary and ternary systems were evaluated in terms of deviations for applications such as model development. Later, those groups of data (tested and approved) were used in the KijPoly program for the determination of the binary kij parameters of the cubic equations of state original Peng-Robinson and with the expanded alpha function. These obtained parameters can be applied for simulation of the reservoirs petroleum conditions and of the several distillation processes found in the petrochemistry industry, through simulators. The two designed dynamic cells used equipments of national technology for the determination of VLE data were well succeed, demonstrating efficiency and low cost. Multicomponents systems, mixtures of components of different molecular weights and also diluted solutions may be studied in these developed VLE cells

Determinação de Dados de Equilíbrio Líquido-Vapor para Sistemas Hidrocarbonetos e Desenvolvimento de uma Nova Célula Dinâmica

In the present work are established initially the fundamental relationships of thermodynamics that govern the equilibrium between phases, the models used for the description of the behavior non ideal of the liquid and vapor phases in conditions of low pressures. This work seeks the determination of vapor-liquid equilibrium (VLE) data for a series of multicomponents mixtures of saturated aliphatic hydrocarbons, prepared synthetically starting from substances with analytical degree and the development of a new dynamic cell with circulation of the vapor phase. The apparatus and experimental procedures developed are described and applied for the determination of VLE data. VLE isobarics data were obtained through a Fischer's ebulliometer of circulation of both phases, for the systems pentane + dodecane, heptane + dodecane and decane + dodecane. Using the two new dynamic cells especially projected, of easy operation and low cost, with circulation of the vapor phase, data for the systems heptane + decane + dodecane, acetone + water, tween 20 + dodecane, phenol + water and distillation curves of a gasoline without addictive were measured. Compositions of the equilibrium phases were found by densimetry, chromatography, and total organic carbon analyzer. Calibration curves of density versus composition were prepared from synthetic mixtures and the behavior excess volumes were evaluated. The VLE data obtained experimentally for the hydrocarbon and aqueous systems were submitted to the test of thermodynamic consistency, as well as the obtained from the literature data for another binary systems, mainly in the bank DDB (Dortmund Data Bank), where the Gibbs-Duhem equation is used obtaining a satisfactory data base. The results of the thermodynamic consistency tests for the binary and ternary systems were evaluated in terms of deviations for applications such as model development. Later, those groups of data (tested and approved) were used in the KijPoly program for the determination of the binary kij parameters of the cubic equations of state original Peng-Robinson and with the expanded alpha function. These obtained parameters can be applied for simulation of the reservoirs petroleum conditions and of the several distillation processes found in the petrochemistry industry, through simulators. The two designed dynamic cells used equipments of national technology for the determination Humberto Neves Maia de Oliveira Tese de Doutorado PPGEQ/PRH-ANP 14/UFRN of VLE data were well succeed, demonstrating efficiency and low cost. Multicomponents systems, mixtures of components of different molecular weights and also diluted solutions may be studied in these developed VLE cells

Uso de técnicas de Geoprocessamento e Sensoriamento Remoto no levantamento e integração de dados necessários a gestão ambiental dos campos de extração de óleo e gás do Canto do Amaro e Alto da Pedra no município de Mossoró - RN

The objective of this work is to identify, to chart and to explain the evolution of the soil occupation and the envirionment vulnerability of the areas of Canto do Amaro and Alto da Pedra, in the city of Mossoró-RN, having as base analyzes it multiweather of images of orbital remote sensors, the accomplishment of extensive integrated works of field to a Geographic Information System (GIS). With the use of inserted techniques of it analyzes space inserted in a (GIS), and related with the interpretation and analyzes of products that comes from the Remote Sensoriamento (RS.), make possible resulted significant to reach the objectives of this works. Having as support for the management of the information, the data set gotten of the most varied sources and stored in digital environment, it comes to constitute the geographic data base of this research. The previous knowledge of the spectral behavior of the natural or artificial targets, and the use of algorithms of Processing of Digital images (DIP), it facilitates the interpretation task sufficiently and searchs of new information on the spectral level. Use as background these data, was generated a varied thematic cartography was: Maps of Geology, Geomorfológicals Units soils, Vegetation and Use and Occupation of the soil. The crossing in environment SIG, of the above-mentioned maps, generated the maps of Natural and Vulnerability envirionmental of the petroliferous fields of I Canto do Amaro and Alto da Pedra-RN, working in an ambient centered in the management of waters and solid residuos, as well as the analysis of the spatial data, making possible then a more complex analysis of the studied area

Modelos de sobrevivência com fração de cura e omissão nas covariáveis

In this work we study the survival cure rate model proposed by Yakovlev (1993) that are considered in a competing risk setting. Covariates are introduced for modeling the cure rate and we allow some covariates to have missing values. We consider only the cases by which the missing covariates are categorical and implement the EM algorithm via the method of weights for maximum likelihood estimation. We present a Monte Carlo simulation experiment to compare the properties of the estimators based on this method with those estimators under the complete case scenario. We also evaluate, in this experiment, the impact in the parameter estimates when we increase the proportion of immune and censored individuals among the not immune one. We demonstrate the proposed methodology with a real data set involving the time until the graduation for the undergraduate course of Statistics of the Universidade Federal do Rio Grande do Norte

O comprometimento no trabalho e o significado do trabalho :um estudo com os funcionários do Banco do Nordeste do Brasil S/A

The current study analyses the relation between commitment (focusing on organization, career and syndicate) and the meaning of the work for 123 employees from a bank of mixed economy, crowed in agencies located in the Northeast capitals and also in four capitals out of this region: Belo Horizonte-MG, Brasília-DF, Rio de Janeiro-RJ and São Paulo-SP. It explores the commitment variability in the work of participants, as well as the score combination in foci, generating the commitment patterns, having used as an instrument a questionnaire consisting: a reduced version of OCQ Organizational Commitment Questionnaire (09 items), which measures the organizational commitment; the reduced Gordon s Scale (10 items), which measures the syndicate commitment; and the Blau s Scale, which measures the commitment to the career/occupation. It speculates, likewise, the meaning of work variability to the sample, seeking for the value attributes (what work should be), descriptive attributes (what work is) and its hierarchy, for which the ISMT-Inventário do Significado e Motivação no Trabalho has been applied; the work centrality, for which two specific inquires were used. The answers were registered in data at SPSS-Statically Package for Social for Windows, and from this point the statistical analyses were accomplished. Eight commitments to work patterns and six from the meaning of work were identified (Cluster analyses). The relation between both constructs was confirmed, corroborating other studies

Produção e validação de um indicador de saúde bucal para idosos a partir de dados secundários do SB Brasil 2010

Dentre os vários aspectos da saúde do idoso, a saúde bucal merece atenção especial pelo fato de que, historicamente, nos serviços odontológicos, não se considera esse grupo populacional como prioridade de atenção. Por isso, se faz necessária a produção de um indicador multidimensional capaz de mensurar todas as alterações bucais encontradas em um idoso, facilitando a categorização da saúde bucal como um todo. Tal indicador representará um importante instrumento capaz de elencar prioridades de atenção voltadas à população idosa. Portanto, o estudo em questão propõe a produção e validação de um indicador de saúde bucal a partir dos dados secundários coletados pelo projeto SB Brasil 2010 referente ao grupo etário de 65 a 74 anos. A amostra foi representada pelos 7619 indivíduos do grupo etário de 65 a 74 anos que participaram da pesquisa nas 5 (cinco) regiões do Brasil. Tais indivíduos foram submetidos à avaliação epidemiológica das condições de saúde bucal, a partir dos índices CPO-d, CPI e PIP. Além disso, verificou-se o uso e necessidade de prótese, bem como características sociais, econômicas e demográficas. Uma análise fatorial identificou um número relativamente pequeno de fatores comuns, através da análise de componentes principais. Após a nomenclatura dos fatores, foi realizada a soma dos escores fatoriais por indivíduo. Por último, a dicotomização dessa soma nos forneceu o indicador de saúde bucal proposto. Para esse estudo foram incluídas na análise fatorial 12 variáveis de saúde bucal oriundas do banco de dados do SB Brasil 2010 e, também 3 variáveis socioeconômicas e demográficas. Com base no critério de Kaiser, observa-se que foram retidos cinco fatores que explicaram 70,28% da variância total das variáveis incluídas no modelo. O fator 1 (um) explica sozinho 32,02% dessa variância, o fator 2 (dois) 14,78%, enquanto que os fatores 3 (três), 4 (quatro) e 5 (cinco) explicam 8,90%, 7,89% e 6,68%, respectivamente. Por meio das cargas fatoriais, o fator um foi denominado dente hígido e pouco uso de prótese , o dois doença periodontal presente , o três necessidade de reabilitação , já o quarto e quinto fator foram denominados de cárie e condição social favorável , respectivamente. Para garantir a representatividade do indicador proposto, realizou-se uma segunda análise fatorial em uma subamostra da população de idosos investigados. Por outro lado, a aplicabilidade do indicador produzido foi testada por meio da associação do mesmo com outras variáveis do estudo. Por fim, Cabe ressaltar que, o indicador aqui produzido foi capaz de agregar diver sas informações a respeito da saúde bucal e das condições sociais desses indivíduos, traduzindo assim, diversos dados em uma informação simples, que facilita o olhar dos gestores de saúde sobre as reais necessidades de intervenções em relação à saúde bucal de determinada população

GeOntoQuery - um mecanismo de busca em bancos de dados geográficos baseado em ontologias

Geographic Information System (GIS) are computational tools used to capture, store, consult, manipulate, analyze and print geo-referenced data. A GIS is a multi-disciplinary system that can be used by different communities of users, each one having their own interest and knowledge. This way, different knowledge views about the same reality need to be combined, in such way to attend each community. This work presents a mechanism that allows different community users access the same geographic database without knowing its particular internal structure. We use geographic ontologies to support a common and shared understanding of a specific domain: the coral reefs. Using these ontologies' descriptions that represent the knowledge of the different communities, mechanisms are created to handle with such different concepts. We use equivalent classes mapping, and a semantic layer that interacts with the ontologies and the geographic database, and that gives to the user the answers about his/her queries, independently of the used terms

Potencialidade à degradação na microbacia Riacho Passagem/RN

A degradação dos recursos naturais é talvez o principal problema da região do semiárido brasileiro, e essa degradação é principalmente resultante das perdas de solo, decorrente do processo erosivo. Na busca de melhor conhecer esta problemática vem sendo empregado o processo de modelagem ambiental, cujo objetivo é identificar e propor soluções para a degradação dos solos. Nesse sentido, o trabalho aplica o modelo da Equação Universal de Perda de Solos (EUPS), desenvolvido nos Estados Unidos ao longo da década de 1950, agregado as ferramentas de geoprocessamento, informações de sensoriamento remoto e Sistemas de Informações Geográficas (SIGs). A área de estudo é a Microbacia Riacho Passagem localizada na região oeste do Estado do Rio Grande do Norte, a microbacia tem uma área de 221,7Km² e esta inserida no semiárido, região Nordeste do Brasil. A metodologia utilizada consiste: em agrupar as variáveis da EUPS no ambiente SIG utilizando imagens de satélite, levantamentos bibliográficos e trabalhos de campo. Para determinação das extensões das vertentes foi empregado o Modelo RAMPA, e para adequar a EUPS as condições da área de estudo, foram realizados ajuste através de modelos estatísticos, aperfeiçoando o trabalho e os resultados gerados pelo modelo. Ao fim do processo foi desenvolvida uma pseudo linguagem no aplicativo Linguagem Espacial para Geoprocessamento Algébrico (LEGAL) disponível no software SPRING versão 5.1.2 servindo de suporte para o processamento das informações contidas no banco de dados, base da EUPS. Os resultados demonstram que inicialmente é necessário delimitar com precisão o período seco e chuvoso, informação fundamental para a EUPS, uma vez que o trabalho busca identificar a perda de solo por erosão hídrica. O modelo RAMPA apresentou-se satisfatório e com elevado potencial de aplicação na determinação dos comprimentos de vertentes utilizando imagens de radar. Quanto ao comportamento das extensões de vertentes, na microbacia, o mesmo apresentou uma pequena variação na porção leste, maiores vertentes, área próxima a desembocadura. Após a aplicação do modelo o valor máximo de perda de solo foi 88 ton/ha.ano com núcleos localizados no NEOSSOLOS LITÓLICOS e o mínimo 0,01 ton/ha.ano localizado no domínio dos LATOSSOLOS e NEOSSOLOS FLÚVICOS. A erosão provoca diminuição do perfil de solo, principalmente nos NEOSSOLOS LITÓLICOS, resultando em alteração no balanço hídrico e conseqüentemente aumento da temperatura do solo, podendo desencadear a desertificação. Os resultados e a metodologia do presente trabalho poderão ser aplicados na busca pelo desenvolvimento sustentável, na região do semiárido brasileiro, auxiliando na compreensão do binômio uso do solo e capacidade de suporte do meio natural.