On view support in object-oriented database systems
Modern database systems
A schema integration facility using object-oriented data model
Object-oriented multidatabase systems
An overview of data warehousing and OLAP technology
ACM SIGMOD Record
Object-relational database systems (tutorial): principles, products and challenges
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
A formal model of views for object-oriented database systems
Theory and Practice of Object Systems
Query processing over object views of relational data
The VLDB Journal — The International Journal on Very Large Data Bases
Partitioning schemes for object oriented databases
RIDE '95 Proceedings of the 5th International Workshop on Research Issues in Data Engineering-Distributed Object Management (RIDE-DOM'95)
Vertical class partitioning and complex object retrieval in object oriented databases
Vertical class partitioning and complex object retrieval in object oriented databases
Modeling the Behavior of OLAP Applications Using an UML Compilant Approach
ADVIS '00 Proceedings of the First International Conference on Advances in Information Systems
A Temporal Object-Oriented Data Warehouse Model
DEXA '00 Proceedings of the 11th International Conference on Database and Expert Systems Applications
A Framework for the Classification and Description of Multidimensional Data Models
DEXA '01 Proceedings of the 12th International Conference on Database and Expert Systems Applications
A three-layered XML view model: a practical approach
ER'05 Proceedings of the 24th international conference on Conceptual Modeling
| Hi-index | 0.00 |
The conventional star schema model of Data Warehouse (DW) has its limitations due to the nature of the relational data model. Firstly, this model cannot represent the semantics and operations of multi-dimensional data adequately. Due to the hidden semantics, it is difficult to efficiently address the problems of view design. Secondly, as we move up to higher levels of summary data (multiple complex aggregations), SQL queries do not portray the intuition needed to facilitate buildingand supporting efficient execution of complex queries on complex data. In light of these issues, we propose the Object-Relational View (ORV) design for DWs. Using Object-Oriented (O-O) methodology, we can explicitly represent the semantics and reuse view (class) definitions based on the ISA hierarchy and the class composition hierarchies, thereby resulting in a more efficient view mechanism. Part of the design involves providing a translation mechanism from the star/snowflake schema to an O-O representation. This is done by flattening the fact-dimension schema and converting it to a class-composition hierarchy in an O-O framework. Vertically partitioning this O-O schema further increases the efficiency of query execution by reducing disk access. We then build a Structural Join Index Hierarchy (SJIH) on this partitioned schema to facilitate complex object retrieval and avoid using a sequence of expensive pointer chasing (or join) operations.