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.bitstream/CNPTIA/10202/1/doc35.pdfAcesso em: 28 maio 2008

Carregando dados na arquitetura data warehousing - armazém de dados de frutas.

Data warehouse / Data Mart. Arquiteturas. O processo ETT (Extração, Transformação e carga de dados).bitstream/CNPTIA/9176/1/COMNICADOTEC3_0.pdfAcesso em: 29 maio 2008

Dampak Peningkatan Efisiensi Bank Syariah melalui Rancangan Model Enterprise Data Warehouse (Edw) untuk Kebutuhan Konversi Data Menjadi Format Xbrl

Bank Indonesia (BI) sebagai Bank Sentral mempunyai tugas untuk melakukan pengawasanterhadap Bank Komersil di Indonesia. Pengawasan BI tersebut melekat kepad a Bank KomersilKonvensional dan Syariah atau Unit Usaha Syariah. Sistem pelaporan ini diwajibkan oleh BankIndonesia dengan mengeluarkan ketentuan dan Surat Edaran (SE). Aplikasi Laporan ini sekarangsedang dilakukan enhancement menjadi LBUS Basel 2 dengan bentuk format data XBRL.Perubahan Sistem Pelaporan LBUS ini sangat signifikan sekali Perubahannya terutama Perubahankonten dan bisnis rule. Dari sisi teknikal ada Perubahan format data dari textfile menjadi formatXBRL. Bank Muamalat Indonesia (BMI) salah satu bank komersial Syariah harus melakukanpengembangan sistem pelaporan LBUS Basel 2 XBRL. BMI akan membangun Enterprise DataWarehouse dan Software untuk melakukan Konversi data menjadi format XBRL. Aplikasi tersebutdiharapkan akan dapat mengurangi biaya lisensi tahunan yang cukup besar. Aplikasi ini dirancangterintegrasi antara EDW dengan Mapper data untuk merubah konversi data menjadi Format XBRL,didalam satu lingkungan Extract Transformation Loading ETL, SSIS SQL Server 2012.Implementasi rancangan ini dapat meningkatkan efektif dan efisiensi terhadap pengurangan biaya,jumlah karyawan disetiap cabang tidak diperlukan sebab sudah tersentralisasi dikantor pusat. Dapatmengurangi masa pelaporan hari yang sangat signifikan. Mengurangi biaya lisensi dan biayahardware yang tinggi dari dampak solusi rancangan sistem konversi XBRL ini. Solusi ini dapatmenghemat 90% biaya pengembangan sistem dari nilai implementasi sistem lisensi

X-Databases - The Integration of XML into Enterprise Database Management Systems

An examination of how the eXtensible Markup Language (XML) and database management systems (DBMS) fit together, and current approaches to providing database technologies that support XML. Analysis of how XML is being deployed in four classes of XML Database (X-Database) applications provides a basis for understanding the direction of X-Database technology and associated standards. In a simple implementation, an XML Document Type Definition (DTD) is mapped to relational structures, and XML data are stored in a DBMS (Oracle8i). Sample queries are presented to retrieve XML from the database. A middleware tool (XSQL Java Servlet) is used to transform query results into records on a Web page. The results demonstrate that relational databases require data to be rigidly mapped to relational structures. The paper concludes by exploring future challenges to integrating XML and DTDs with X-Databases, which establishes the need for a more "native" integration approach

Implantação do armazém de dados da fruticultura no Ministério da Agricultura, Pecuária e Abastecimento.

Infra-estrutura de Software necessária. Implantando o armazém de dados da fruticultura: criando e configurando usuários e atribuição; importando o arquivo exportado com o esquema do Armazém de Dados da Fruticultura; renovando os sumários do Armazém de Dados da Fruticultura.bitstream/CNPTIA/9201/1/INSTRTECNICAS8int.pdfAcesso em: 30 maio 2008

Implantação do Armazém de Dados da Fruticultura: versão 1.2.

Novidades e diferenças da versão 1.2. Requisitos de software. Implantando o armazém de dados da floticultura. Importando o aquivo com o esquema de banco de dados.bitstream/CNPTIA/10055/1/doc30.pdfAcesso em: 29 maio 2008

Análise da produção brasileira de frutas a partir do armazém de dados da fruticultura.

Armazém de dados da fruticultura. Integração dos dados de produção de frutas. Análise da produção brasileira de frutas.bitstream/CNPTIA/9872/1/comuntec18_0.pd

Analysis, design and implementation of a web database with Oracle 8i

This thesis represents a model of web-database analysis, design and implementation. An electronic bulletin board for the Naval Postgraduate School is implemented for demonstration. The model includes Oracle8i DBMS as the database, Java (Java Server Pages, Java Script Enterprise Java Beans, Java Servlets) as the programming language. Apache HTTP Server v.1.3 Tomcat v.1.2 is used as the Web server and JSP engine. Windows NT4.O served as the OS environment From the technical aspect, Database Management Systems, Web-Database Architectures, Server Extension Programs, Oracle8i as well as several other software and hardware components are reviewed, and some are recommended.http://archive.org/details/analysisdesignnd109451081

Cadastral Information System for M.I. Wushishi Housing Estate.

This study presents the possibilities for efficient implementation of a Cadastral Information System for M. I. Wushishi Estate in a GIS environment. Logical and Physical models for the Cadastral Information System were built and utilized in the creation of the Cadastral Information System using an Entity relationship model. Keywords: Cadastral, Information System, Estat