Designing an Object–Relational Data Warehousing
نویسندگان
چکیده
In this paper we present a research project aiming at the design and development of an Object–Relational Data Warehousing System (ORDAWA). The project is conducted in co–operation of Institute for Informatics–Systems, Klagenfurt University, and Institute of Computing Science, Poznań University of Technology. Important goals of the project are to develop techniques for the integration and consolidation of different external data sources in an object/relational data warehouse, the construction and maintenance of materialized relational as well as object–oriented views, index structures, query transformations and optimizations, and techniques of data mining.
منابع مشابه
Designing and Implementing an Object Relational Data Warehousing System
In this paper we present some of the results achieved while realizing an international research project aiming at the design and development of an Object–Relational Data Warehousing System (ORDAWA). Important goals of the project are to develop techniques for the integration and consolidation of different external data sources in an object–relational data warehouse, the construction and mainten...
متن کاملImplementation of Object Oriented Data Warehousing using a Narrower Compassed Data Model in Oracle 10g
A data warehouse (DW) is a database used for reporting Paper describes Object Oriented Data Warehousing using a narrower compassed data model. The data is offloaded from the operational systems for reporting. The data may pass through an operational data store for additional operations before it is used in the Data warehousing for reporting. An Object Oriented Data Warehouse system includes a d...
متن کاملObject-Oriented Data Modeling and Warehousing to Support Urban Design
All over the world, local authorities are moving towards managing and storing urban data in digital form. But the data storage devices used are heterogeneous and typically include relational database management systems (DBMS), GIS and CAD files. As a result, data are present in different locations on different platforms and under different schemas. This poses a problem for software applications...
متن کاملOn Three Major Holes in Data Warehousing Today
During the past several years, many enterprises have created data warehouses (and data marts) in order to run applications. Data warehousing technologies used have been primarily extract-transform-load (ETL) tools, database modeling and design tools, and relational database (RDB) systems. There are three major holes in data warehousing today. These include inadequate attention to dirty data, in...
متن کاملIncremental Maintenance of Object-Oriented Views in a Warehousing Environment
Data warehousing is an approach to data integration in which integrated information is stored in a data warehouse for direct querying and analysis. To provide fast access, a data warehouse stores materialized views defined over data from its data sources. As a result, a data warehouse needs to be maintained to keep its contents consistent with the contents of its data sources. Incremental maint...
متن کامل