An Object-Relational Data Warehouse Modelig for Complex Data

@inproceedings{Lin2006AnOD,
  title={An Object-Relational Data Warehouse Modelig for Complex Data},
  author={Wen-Yang Lin and Chin-Ang Wu and Chuan-Chun Wu},
  booktitle={JCIS},
  year={2006}
}
A data warehouse is an essential component to the decision support system. The traditional data warehouse provides only numeric and character data analysis. But as information technologies progress, complex data such as semi-structured and unstructured data become vastly used. Developing new data warehouse technologies to accommodate the demand of integrating complex data is important. In this paper, we propose a data model for the complex data warehouse. This model incorporates the well-known… 

Figures from this paper

A Temporal Data Warehouse Conceptual Modelling and Its Transformation into Temporal Object Relational Model

TLDR
This paper has focused on the creation of a conceptual model for designing a temporal object-relational data warehouse based on UML technology and EER (Enhanced entity-relationship) model that allows easily realizing and transforming the conceptual model into a logical design schema.

Extending the OLAP Technology to Handle Non-Conventional and Complex Data

TLDR
The aim of this thesis is to fundamentally extend the functionality of the widely adopted OLAP framework in order to adequately handle usage scenarios not supported by the standard setting and propose a set of corresponding conceptual-to-logical mappings and transformation techniques for ensuring correct aggregation.

References

SHOWING 1-10 OF 17 REFERENCES

From enterprise models to dimensional models: a methodology for data warehouse and data mart design

TLDR
A method for developing dimensional models from traditional Entity Relationship models, which can be used to design data warehouses and data marts based on enterprise data models is described.

Star/Snow-Flake Schema Driven Object-Relational Data Warehouse - Design and Query Processing Strategies

TLDR
The Object-Relational View (ORV) design for DWs is proposed, which 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.

An Object Oriented Multidimensional Data Model for OLAP

TLDR
This paper first proposes a conceptual multidimensional data model, which is able to represent and capture natural hierarchical relationships among members within a dimension as well as the relationships between dimension members and measure data values, and uses UML (Unified Modeling Language) to model it in the context of object oriented databases.

Designing Data Warehouses with OO Conceptual Models

TLDR
This approach introduces a set of minimal constraints and extensions to UML 1 for representing multidimensional modeling properties for these applications and believes that this innovative approach provides a theoretical foundation for the use of OO databases and object-relational databases in data warehouses, MDB, and OLAP applications.

Designing Data Warehouses with OO Conceptual Models

The authors propose an approach that provides a theoretical foundation for the use of object-oriented databases and object-relational databases in data warehouse, multidimensional database, and onl...

Conceptual Database Design: An Entity-Relationship Approach

TLDR
This chapter discusses Conceptual Design, Logical Design, and Design Tools for Database Design, as well as Joint Data and Functional Analysis, and Improving the Quality of a Database Schema.

Digital Government Security Infrastructure Design Challenges

The authors propose an approach that provides a theoretical foundation for the use of object-oriented databases and object-relational databases in data warehouse, multidimensional database, and

Data warehousing fundamentals : a comprehensive guide for IT professionals

TLDR
This book discusses the design and management of data Warehousing, and the role of metadata in this process.

Multidimensional Database Technology

TLDR
Multidimensional database technology will increasingly be applied where analysis results are fed directly into other systems, thereby eliminating humans from the loop, when coupled with the need for continuous updates.

An Alternative Relational OLAP Modeling Approach

TLDR
This paper discusses the problem of locally valid dimensional attributes in a classification hierarchy of a typical OLAP scenario and sketches two alternative modeling approaches resulting in practical solutions and a seamless extension of the traditional star and snowflake schema approach.