Using perspective schema and a reference model to design the ETL process

Dissertação apresentada para a obtenção do Grau de Doutor em Informática

Visões das gerências da auditoriainterna da Petrobras sobre a sua estratégia de atuação em facedas práticas de mercado e da nova modelagem organizacional da companhia

The purpose of this study is to identify the strategic vision of the Internal Audit Department of Petrel Brasileiro S.A. PETROBRAS, in comparison with the audit function's proposals and practices in competitive organizations and their reality. It also aims at the verification of the possible solutions, within Petrobras itself, so as to constantly add value to the business and to the shareholders. With this in mind, a research was carried out, contemplating the conceptual proposals and market practices related to auditing and to the current diagnosis and the organizational model of Petrobras, so as to choose elements for comparison and analysis of such vision. The results of this research pointed in the direction of questioning the organizational value of the internal audit action, concluding that it will only be possible to continuously attain such value by means of a permanent coordination with the organization's strategic level. This is especially true if the audit action participates effectively in the process of Corporate Governance, in defining the risks, the internal control system and the measurement of corporate performance, as related to the development of the strategic plan. However, any action along these lines is still heavily impacted and limited by several aspects of culture and relationship of the organizational power as well as by the beliefs of the organization and of the body of auditors. The involvement of the auditors as employees was also considered relevant in the auditing process, by means of the participation of the audited entities in self assessment2. This procedure is still not sufficiently guaranteed by successful experiments in major organizations, considering that there is not a clear demonstration of the effective benefits of adopting this practice, as ompared to the central control, seldom shared but strongly monitored by integrated information systems. Finally, this research points to the need to renew the concept of the formation and role of the auditors in modern competitive organizations, in the face of information technology and of automation of the instrument controls of the business. Therefore, one may conclude that the trend will be toward an action aiming at the revision of formal internal control matrixes, as they are established in such systems. On the other hand, the majority of audit human resources will be increasingly deployed to the evaluation of risk and control, as related to relevant events of a more abstract nature, as in the case of those connected with the uncontrollable factors of the external environment.

Modelagem da perda esperada: uma alternativa para tratar o efeito da correlação entre a PD e LGD

Com a relevância que o mercado de crédito vem ganhando na economia o presente trabalho se propôs a fazer uma revisão conceitual do risco de crédito. Tendo a perda esperada como o principal componente do risco de crédito, o trabalho se aprofundou nesse tema propondo uma maneira nova para o cálculo da mesma. Da maneira que ela é modelada usualmente pressupoem que os parâmetros de PD e LGD são independentes. Alguns autores questionam essa pressuposição e que, se essa dependência não for levada em conta os cálculos de perda esperada e o capital que deveria ser alocado estarão incorretos. Uma alternativa para tratar a correlação é modelar os dois componentes conjuntamente, ao comparar os resultados do modelo usual com o modelo conjunto conclui-se que o erro da estimativa de perda esperada do modelo conjunto foi menor. Não se pode afirmar que o menor erro na estimativa de perda se deve a correlação entre a PD e LGD, porém ao modelar os parâmetros conjuntamente, retira-se essa forte pressuposição.

Uma técnica para modelagem de cenários consistentes na previsão da demanda por energia elétrica

As técnicas qualitativas disponiveis para a modelagem de cenários têm sido reconhecidas pela extrema limitação, evidenciada no principio das atividades do processo, como a fase inicial de concepção. As principais restrições têm sido: • inexistência de uma ferramenta que teste a consistência estrutural interna do modelo, ou pela utilização de relações econômicas com fundamentação teórica mas sem interface perfeita com o ambiente, ou pela adoção de variações binárias para testes de validação; • fixação "a priori" dos possíveis cenários, geralmente classificados sob três adjetivos - otimista, mais provável e pessimista - enviesados exatamente pelos atributos das pessoas que fornecem esta informação. o trabalho trata da utilização de uma ferramenta para a interação entre uma técnica que auxilia a geração de modelos, suportada pela lógica relacional com variações a quatro valores e expectativas fundamentadas no conhecimento do decisor acerca do mundo real. Tem em vista a construção de um sistema qualitativo de previsão exploratória, no qual os cenários são obtidos por procedimento essencialmente intuitivo e descritivos, para a demanda regional por eletricidade. Este tipo de abordagem - apresentada por J. Gershuny - visa principalmente ao fornecimento de suporte metodológico para a consistência dos cenários gerados qualitativamente. Desenvolvimento e estruturação do modelo são realizados em etapas, partindo-se de uma relação simples e prosseguindo com a inclusão de variáveis e efeitos que melhoram a explicação do modelo. o trabalho apresenta um conjunto de relações para a demanda regional de eletricidade nos principais setores de consumo residencial, comercial e industrial bem como os cenários resultantes das variações mais prováveis das suas componentes exógenas. Ao final conclui-se que esta técnica é útil em modelos que: • incluem variáveis sociais relevantes e de dificil mensuração; • acreditam na importância da consistência externa entre os resultados gerados pelo modelo e aqueles esperados para a tomada de decisões; • atribuem ao decisor a responsabilidade de compreender a fundamentação da estrutura conceitual do modelo. Adotado este procedimento, o autor aqui recomenda que o modelo seja validado através de um procedimento iterativo de ajustes com a participação do decisor. As técnicas quantitativas poderão ser adotadas em seguida, tendo o modelo como elemento de consistência.

Uma modelagem de indicadores de desempenho para instituições de ensino superior no Brasil na abordagem do balanced scorecard: um estudo com instituições privadas

This Master of Science Thesis deals with a BSC modeling for higher education institution focusing on private institution in the Brazilian context. It‟s accomplished a literature review in order to understand the BSC and its application to for profit and non for profit organizations and as a main result it is proposed a BSC conceptual model with a new perspective (Government) and a change in the hierarchy of the main BSC perspective equaling financial to customer/society. Taking the national higher education assessment system of Education Ministry indicators a model is deployed and the relations between the indicators are measured with the Pearson correlation coefficient. As a result a model emerges with sound relations of indicators but a improvement in the financial indicators is needed

Obtenção de Propriedades Físico-Químicas de Misturas de Hidrocarbonetos em Baixa e Alta Pressão Visando a Caracterização e a Modelagem

The composition of petroleum may change from well to well and its resulting characteristics influence significantly the refine products. Therefore, it is important to characterize the oil in order to know its properties and send it adequately for processing. Since petroleum is a multicomponent mixture, the use of synthetic mixtures that are representative of oil fractions provides a better understand of the real mixture behavior. One way for characterization is usually obtained through correlation of physico-chemical properties of easy measurement, such as density, specific gravity, viscosity, and refractive index. In this work new measurements were obtained for density, specific gravity, viscosity, and refractive index of the following binary mixtures: n-heptane + hexadecane, cyclohexane + hexadecane, and benzene + hexadecane. These measurements were accomplished at low pressure and temperatures in the range 288.15 K to 310.95 K. These data were applied in the development of a new method of oil characterization. Furthermore, a series of measurements of density at high pressure and temperature of the binary mixture cyclohexane + n-hexadecane were performed. The ranges of pressure and temperature were 6.895 to 62.053 MPa and 318.15 to 413.15 K, respectively. Based on these experimental data of compressed liquid mixtures, a thermodynamic modeling was proposed using the Peng-Robinson equation of state (EOS). The EOS was modified with scaling of volume and a relatively reduced number of parameters were employed. The results were satisfactory demonstrating accuracy not only for density data, but also for isobaric thermal expansion and isothermal compressibility coefficients. This thesis aims to contribute in a scientific manner to the technological problem of refining heavy fractions of oil. This problem was treated in two steps, i.e., characterization and search of the processes that can produce streams with economical interest, such as solvent extraction at high pressure and temperature. In order to determine phase equilibrium data in these conditions, conceptual projects of two new experimental apparatus were developed. These devices consist of cells of variable volume together with a analytical static device. Therefore, this thesis contributed with the subject of characterization of hydrocarbons mixtures and with development of equilibrium cells operating at high pressure and temperature. These contributions are focused on the technological problem of refining heavy oil fractions

Modelagem léxico-ontológica do domínio patrimônio cultural de São Luís do Maranhão

Coordenação de Aperfeiçoamento de Pessoal de Nível Superior (CAPES)

Modelagem conceitual DILAM: princípios descritivos de arquivos, bibliotecas e museus para o recurso imagético digital

Pós-graduação em Ciência da Informação - FFC

O ensino de estrutura da matéria na disciplina de física: uma análise de estruturas conceituais para a modelagem do currículo

Pós-graduação em Educação para a Ciência - FC

Gamificação: modelagem de conteúdos para programas e aplicativos educativos no ambiente da TV digital interativa

With the deployment of Digital TV in Brazil, there is a need to foment the development and production of interactive audiovisual quality content, especially for programs that present educational messages from the entertainment concept - defined as Edutertainment. The objective of this study is to propose application of the gamification as a link of communication to encourage and modify user behavior, through a narrative that encourages intrinsic motivation for learning and entertainment in this media. This paper points out that there are few models of screenplays for applications production, particularly educational, with simultaneous interactive applications for television flow or complementary programming content offered. For this reason, a special attention is given to the screenplay, by virtue of inserting in its construction, the elements that make up the mechanics and dynamics of games. As a result, is shown the entry "Gamification-iDTV", which defines these two scenarios, as well as the development of a modeling methodology of a content and process, supported by conceptual maps, wireframes and roadmaps, substantiating the conception and elaboration of screenplay's prototype with elements of gamification for educational programs and its interaction applications.

Aplicação da modelagem no estudo da teoria cinética dos gases

In this term paper is studied the use of models and analogies and it's influences in the study of chemistry, for learning and understanding of concepts related to the kinetic theory of gases. It was developed an activity with students of high school second year, enrolled in a State school, in the city of Bauru-SP. It was built and developed a model using the mechanical vertical model scheme, based on the proposal of Professor Luiz Ferraz Netto, for the teaching of the kinetic theory of gases. It was applied a questionary to evaluate the effect of the model in the classroom, and the analysis of data was done in descriptive qualitative way. It was verified that the methodology favored the development of conceptual understanding, demonstrating significant results on the theme of learning

Modelagem matemática e simulação numérica do resfriamento rápido de morango com ar forçado

This work approaches the forced air cooling of strawberry by numerical simulation. The mathematical model that was used describes the process of heat transfer, based on the Fourier's law, in spherical coordinates and simplified to describe the one-dimensional process. For the resolution of the equation expressed for the mathematical model, an algorithm was developed based on the explicit scheme of the numerical method of the finite differences and implemented in the scientific computation program MATLAB 6.1. The validation of the mathematical model was made by the comparison between theoretical and experimental data, where strawberries had been cooled with forced air. The results showed to be possible the determination of the convective heat transfer coefficient by fitting the numerical and experimental data. The methodology of the numerical simulations was showed like a promising tool in the support of the decision to use or to develop equipment in the area of cooling process with forced air of spherical fruits.

Modelagem dos processos de remoção sulfato e dióxido de enxofre presente no particulado em diferentes localidades da região metropolitana de São Paulo

This article deals with the scavenging processes modeling of the particulate sulfate and the gas sulfur dioxide, emphasizing the synoptic conditions at different sampling sites in order to verify the domination of the in-cloud or below-cloud scavenging processes in the Metropolitan Area of São Paulo (RMSP). Three sampling sites were chosen: GV (Granja Viana) at RMSP surroundings, IAG-USP and Mackenzie (RMSP center). Basing on synoptic conditions, it was chosen a group of events where the numerical modeling, a simple scavenging model, was used. These synoptic conditions were usually convective cloud storms, which are usual at RMSP. The results show that the in-cloud processes were dominant (80%) for sulfate/sulfur dioxide scavenging processes, with below-cloud process indicating around 20% of the total. Clearly convective events, with total rainfall higher than 20 mm, are better modeled than the stratiform events, with correlation coefficient of 0.92. There is also a clear association with events presenting higher rainfall amount and the ratio between modeled and observed data set with correlation coefficient of 0.63. Additionally, the suburb sampling site, GV, as expected due to the pollution source distance, presents in general smaller amount of rainwater sulfate (modeled and observed) than the center sampling site, Mackenzie, where the characterization event explains partially the rainfall concentration differences.

Scavenging processes of atmospheric particulate matter: a numerical modeling of case studies

Below cloud scavenging processes have been investigated considering a numerical simulation, local atmospheric conditions and particulate matter (PM) concentrations, at different sites in Germany. The below cloud scavenging model has been coupled with bulk particulate matter counter TSI (Trust Portacounter dataset, consisting of the variability prediction of the particulate air concentrations during chosen rain events. The TSI samples and meteorological parameters were obtained during three winter Campaigns: at Deuselbach, March 1994, consisting in three different events; Sylt, April 1994 and; Freiburg, March 1995. The results show a good agreement between modeled and observed air concentrations, emphasizing the quality of the conceptual model used in the below cloud scavenging numerical modeling. The results between modeled and observed data have also presented high square Pearson coefficient correlations over 0.7 and significant, except the Freiburg Campaign event. The differences between numerical simulations and observed dataset are explained by the wind direction changes and, perhaps, the absence of advection mass terms inside the modeling. These results validate previous works based on the same conceptual model.

Brasil e brasileiros: notas sobre modelagem de significados políticos na crise do Antigo Regime português na América

Partindo da análise do significado político de Brasil e de brasileiro em documentos escritos por colonos em meados dos setecentos, o artigo aponta para a importância analítica do caráter desviante de variantes americanas da matriz societária portuguesa de tipo Ancien Régime. Trabalhando com os conceitos de memória e experiência, sustenta-se nele a idéia de que, por se tornarem assimétricas, as estruturas nacionais portuguesas dos dois hemisférios também se tornaram irredutíveis a um mesmo enquadramento constitucional quando da instauração da conjuntura revolucionária do final dos anos vinte do século XIX.