Modelo de gerenciamento de versões para evolução de Data Warehouses

Sistemas de tomada de decisão baseados em Data Warehouse (DW) estão sendo cada dia mais utilizados por grandes empresas e organizações. O modelo multidimensional de organização dos dados utilizado por estes sistemas, juntamente com as técnicas de processamento analítico on-line (OLAP), permitem análises complexas sobre o histórico dos negócios através de uma simples e intuitiva interface de consulta. Apesar dos DWs armazenarem dados históricos por natureza, as estruturas de organização e classificação destes dados, chamadas de dimensões, não possuem a rigor uma representação temporal, refletindo somente a estrutura corrente. Para um sistema destinado à análise de dados, a falta do histórico das dimensões impossibilita consultas sobre o ambiente real de contextualização dos dados passados. Além disso, as alterações dos esquemas multidimensionais precisam ser assistidas e gerenciadas por um modelo de evolução, de forma a garantir a consistência e integridade do modelo multidimensional sem a perda de informações relevantes. Neste trabalho são apresentadas dezessete operações de alteração de esquema e sete operações de alteração de instâncias para modelos multidimensionais de DW. Um modelo de versões, baseado na associação de intervalos de validade aos esquemas e instâncias, é proposto para o gerenciamento dessas operações. Todo o histórico de definições e de dados do DW é mantido por esse modelo, permitindo análises completas dos dados passados e da evolução do DW. Além de suportar consultas históricas sobre as definições e as instâncias do DW, o modelo também permite a manutenção de mais de um esquema ativo simultaneamente. Isto é, dois ou mais esquemas podem continuar a ter seus dados atualizados periodicamente, permitindo assim que as aplicações possam consultar dados recentes utilizando diferentes versões de esquema.

Central bank balance sheet concerns and credible optimal escape from the Liquidity trap

I show that when a central bank is financially independent from the treasury and has balance sheet concerns, an increase in the size or a change in the composition of the central bank's balance sheet (quantitative easing) can serve as a commitment device in a liquidity trap scenario. In particular, when the short-term interest rate is up against the zero lower bound, an open market operation by the central bank that involves purchases of long-term bonds can help mitigate the deation and a large negative output gap under a discretionary equilibrium. This is because such an open market operation provides an incentive to the central bank to keep interest rates low in future in order to avoid losses in its balance sheet.

Análise comparativa da eficiência operacional entre bancos comerciais operando no Brasil e em economias desenvolvidas, utilizando o modelo não paramétrico de data envelopment analysis

O presente trabalho visa comparar, através do modelo de Data Envelopment Analysis orientado a inputs, a eficiência dos bancos comerciais que atuam em economias desenvolvidas dos países do G10 com a eficiência dos bancos comerciais que atuam no mercado brasileiro. Primeiramente, os bancos são comparados utilizando-se um modelo ‘simples’, que considera somente os resultados das operações de cada banco e não contempla as características econômicas e regulatórias de cada mercado. Na sequência, um modelo ‘completo’ é introduzido, incorporando as características do ambiente de negócios de cada país, além dos resultados de cada banco. Os resultados obtidos evidenciam que as variáveis ambientais exercem grande influência na eficiência da indústria bancária. Os bancos que atuam no Brasil, de forma geral, mostraram-se mais eficientes do que os bancos que atuam nas economias mais desenvolvidas, quando consideramos o impacto das variáveis ambientais na eficiência das instituições.

Análise e extração das expectativas dos agentes de mercado em torno da data do COPOM

Este trabalho explora um importante conceito desenvolvido por Breeden & Litzenberger para extrair informações contidas nas opções de juros no mercado brasileiro (Opção Sobre IDI), no âmbito da Bolsa de Valores, Mercadorias e Futuros de São Paulo (BM&FBOVESPA) dias antes e após a decisão do COPOM sobre a taxa Selic. O método consiste em determinar a distribuição de probabilidade através dos preços das opções sobre IDI, após o cálculo da superfície de volatilidade implícita, utilizando duas técnicas difundidas no mercado: Interpolação Cúbica (Spline Cubic) e Modelo de Black (1976). Serão analisados os quatro primeiros momentos da distribuição: valor esperado, variância, assimetria e curtose, assim como suas respectivas variações.

Gender in international economic development projects: how is gender being institutionalized in the Inter-American Development Bank?

O Banco Interamericano de Desenvolvimento, o Banco Mundial, e outras organizações financiam iniciativas para acelerar o desenvolvimento da região da América Latina e Caribe. Antes do final da década de 80, vários projetos e políticas dessas instituições careciam de considerações ligadas à gênero e foram criticadas por essa falta (Flora, 1998). Em 1987, o BID publicou um documento sobre uma nova política operacional sobre mulheres e desenvolvimento e vem desde então buscando institucionalizar gênero e criar indicadores para medir os impactos relacionados à gênero em seus projetos. O objetivo dessa dissertação é explorar o tema de gênero no contexto do desenvolvimento internacional através de uma análise de como o Banco Interamericano de Desenvolvimento inclui gênero em suas operações. Após uma revisão literária sobre a importância de gênero e de bancos de desenvolvimento, essa dissertação irá analisar de que maneira gênero é incluído nas discussões dos projetos do Banco à nível institucional. A pesquisa será feita através de documentação disponível para o público geral, documentos internos e entrevistas em vídeo com pessoal do BID. Após uma análise dos dados coletados, recomendações para ações futuras serão dadas.

An overview of some historical Brazilian macroeconomic series and some open questions

This paper presents an overview of the Brazilian macroeconomy by analyzing the evolution of some specific time series. The presentation is made through a sequence of graphs. Several remarkable historical points and open questions come up in the data. These include, among others, the drop in output growth as of 1980, the clear shift from investments to government current expenditures which started in the beginning of the 80s, the notable way how money, prices and exchange rate correlate in an environment of permanently high inHation, the historical coexistence of high rates of growth and high rates of inHation, as well as the drastic increase of the velocity of circulation of money between the 70s and the mid-90s. It is also shown that, although net external liabilities have increased substantially in current dollars after the Real Plan, its ratio with respect to exports in 2004 is practically the same as the one existing in 1986; and that residents in Brazil, in average, owed two more months of their final income (GNP) to abroad between 1995-2004 than they did between 1990 and 1994. Variance decompositions show that money has been important to explain prices, but not output (GDP).

What happens after the Central Bank of Brazil increases the target interbank rate by 1%?

In this paper I use Taylor's (2001) model and Vector Auto Regressions to shed some light on the evolution of some key macroeconomic variables after the Central Bank of Brazil, through the COPOM, increases the target interest rate by 1%. From a quantitative perspective, the best estimate from the empírical analysis, obtained with a 1994 : 2 - 2004 : 2 subsample of the data, is that GDP goes through an accumulated decline, over the next four years, around 0.08%. Innovations to interest rates explain around 9.2% of the forecast erro r of GDP.

Export-led recoveries in small open industrialized economies

This paper studies the role of Vertical Specialization-based trade and foreign damand push as elements capable of explaining export-led recoveries in small open industrialized economies. The empirical evidence on export-led recoveries is reviewed. Data supporting the growing importance of vertical specialization for international trade are presented. I compare the performance of two versions of a small open economy model, calibrated to mimic Canadian Business Cycles. The …rst one is based upon Schmitt-Grohe(1998). The second incorporates Vertical- Specialization-based trade. I show that an arti…cial economy featuring Vertical-Specializationbased trade in conjunction with an exogenous AR(2) process for foreign output displays improved impulse responses to a foreign output shock and is able to mimic the contribution of Canadian exports to output growth during economic recoveries.

Factors affecting the technical efficiency of production of the Brazilian banking system : a comparison of four statistical models in the context of data envelopment analysis

This paper uses an output oriented Data Envelopment Analysis (DEA) measure of technical efficiency to assess the technical efficiencies of the Brazilian banking system. Four approaches to estimation are compared in order to assess the significance of factors affecting inefficiency. These are nonparametric Analysis of Covariance, maximum likelihood using a family of exponential distributions, maximum likelihood using a family of truncated normal distributions, and the normal Tobit model. The sole focus of the paper is on a combined measure of output and the data analyzed refers to the year 2001. The factors of interest in the analysis and likely to affect efficiency are bank nature (multiple and commercial), bank type (credit, business, bursary and retail), bank size (large, medium, small and micro), bank control (private and public), bank origin (domestic and foreign), and non-performing loans. The latter is a measure of bank risk. All quantitative variables, including non-performing loans, are measured on a per employee basis. The best fits to the data are provided by the exponential family and the nonparametric Analysis of Covariance. The significance of a factor however varies according to the model fit although it can be said that there is some agreements between the best models. A highly significant association in all models fitted is observed only for nonperforming loans. The nonparametric Analysis of Covariance is more consistent with the inefficiency median responses observed for the qualitative factors. The findings of the analysis reinforce the significant association of the level of bank inefficiency, measured by DEA residuals, with the risk of bank failure.

Bank relationships: effect on the availability and marginal cost of credit for firms in Argentina

The paper provides evidence on what affects at the margin the cost and availability of bank credit for firms in Argentina. We study in particular how banks use different pieces of private and public information to screen firms and overcome informational asymmetries in the credit market. Some private information is transferable, like balance sheet data. Private information generated in relationships is not. To capture the closeness of bank relationships, we resort to the concentration of bank credit and the number of credit lines in a bank. We also consider public information available in the Central de Deudores. The cost of credit is measured using overdrafts, the most expensive line of credit, at the bank that charges the highest rate for overdrafts. We find that the cost of credit is smaller for a firm with a close relationship to the marginal bank. Firms with large assets, a high sales/assets ratio, and a low debt/assets ratio pay a lower interest rate at the margin. A good credit history (no debt arrears and no bounced checks) and collateral also reduce the marginal interest rate. The availability of credit is measured by unused credit lines as a proportion of total liabilities with the main bank. The availability of credit depends positively on a close relationship with the main bank. Large assets, a high return over assets, a high sales/assets ratio, a low debt/assets ratio, a good credit history, and collateral lead to higher credit availability. Our measure of unused credit lines is less ambiguous than traditional measures like leverage, which may indicate financial distress rather than availability of credit.

The trajectory of social housing policy in Brazil: From the National Housing Bank to the Ministry of the Cities

This paper discusses social housing policy in Brazil since the 1990s by analyzing government programs’ institutional arrangements, their sources of revenues and the formatting of related financial systems. The conclusion suggests that all these arrangements have not constituted a comprehensive housing policy with the clear aim of serving to enhance housing conditions in the country. Housing ‘policies’ since the 1990s – as proposed by Fernando Collor de Mello, Itamar Franco, Fernando Henrique Cardoso and ´ Luis Inacio Lula da Silva’s governments (in the latter case, despite much progress towards subsidized investment programs) – have sought to consolidate financial instruments in line with global markets, restructuring the way private interests operate within the system, a necessary however incomplete course of action. Different from rhetoric, this has resulted in failure as the more fundamental social results for the poor have not yet been achieved.

Photosynthesis induction in Eucalyptus urograndis seedlings and cuttings measured by Open Photoacoustics

In this work we study the photosynthetic induction in Eucalyptus urograndis leaves using the Open Photoacoustic Cell Technique. In vivo and in situ measurements were performed in leaves of four months-old E. urograndis seedlings and C041 cuttings previously dark-adapted for at least 10 h. Experimental results for the gas exchange component of the photoacoustic (PA) signal are interpreted considering that a gas uptake component would have a phase angle nearly opposite to that of the oxygen evolution component. Analysis of the photosynthetic induction data shows that seedlings present a net oxygen evolution before cuttings, but cuttings reach a higher steady-state photosynthetic activity.

Diretrizes para conservação da espécie Mimosa Caesalpiniifolia Benth., Macaíba-RN

About 40% of the earth is occupied by tropical and subtropical forests, including 42% of dry forests, where there is Caatinga Bioma, contemplating tree forests and shrubs, with xerophytic characteristics. Study and conservations of Caatinga biologic diversity is one of the greatest challenges of Brazilian science because those are, proportionally, the less studied among natural areas, with most of the scientific effort centered in very few points around the main cities in the area and also because it is the less protected natural Brazilian area. The environmental degradation is constantly increasing and has its rhythm accelerated by the men appropriation to meet or not their own needs. Therefore, species conservation should be based in three principles: the use of natural resources by present generation, waste prevention and use of the natural resources to benefit the majority of the citizens. Among the strategies to species conservation, we can mention the ex situ conservation , in which the conservation of genetic resources may be realized outside of the natural environment in which the species occur, and in situ conservation , or, in other words, in the places where the species occur. In ex situ conservation, the germplasm collections are maintained in the field and/or in laboratories (conservation chambers), and this mainly conserves intraspecific diversity (genetic variance), the ex situ collections are continuously enriched by collection activities, introduction and germplasm interchange; the in situ conservation preserving ecosystems and habitats, maintaining and recovering native population of species of interest. So, the objective of this paper is the search for strategies to the conservation of Mimosa caesalpiniifolia B. (sabiá) using instruments of environmental perception and plant biotechnology, as mechanisms of in situ and ex situ conservation. To environmental perception, were realized open, semi-structured and qualitative interviews. The questions included socioeconomic data and knowledge of Sabiá specie. To plant biotechnology, Sabiá seed collection were realized in different location to formation of a germplasm bank. The specie micropropagation was made from nodal segment of plants from the matrizeiro. About the knowledge of rural populations and the use of Sabiá plant, some preferences occurred from speeches that the plant possesses a firm wood, not attacked by termites, legalized for exploration by the Brazilian environmental organ (IBAMA), and is a native specie. This research found the rural population has knowledge about Sabiá specie and the natural resources are exhausting. The proposal that the rural community brought was the donation of the Sabiá specie seeding initiating on the rain season, in which the seeding would be plated between the lots, in individual plantations. To the formation of a matrix bank, plant biothecnology brought answers favorable to Sabiá specie seeding, with the formation of multiple shoots

HTRIdb: an open-access database for experimentally verified human transcriptional regulation interactions

Fundação de Amparo à Pesquisa do Estado de São Paulo (FAPESP)