Object-oriented data warehouse design: building a star schema
Object-oriented data warehouse design: building a star schema
Relational Modeling and Data Warehouse Design
Relational Modeling and Data Warehouse Design
Similarity Flooding: A Versatile Graph Matching Algorithm and Its Application to Schema Matching
ICDE '02 Proceedings of the 18th International Conference on Data Engineering
A Data Warehouse Conceptual Data Model
SSDBM '04 Proceedings of the 16th International Conference on Scientific and Statistical Database Management
Industrial-strength schema matching
ACM SIGMOD Record
Clio grows up: from research prototype to industrial tool
Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Relational.OWL: a data and schema representation format based on OWL
APCCM '05 Proceedings of the 2nd Asia-Pacific conference on Conceptual modelling - Volume 43
YAM2: a multidimensional conceptual model extending UML
Information Systems
A UML profile for multidimensional modeling in data warehouses
Data & Knowledge Engineering - Special issue: ER 2003
A grain preservation translation algorithm: From ER diagram to multidimensional model
Information Sciences: an International Journal
COMA: a system for flexible combination of schema matching approaches
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Two approaches to the integration of heterogeneous data warehouses
Distributed and Parallel Databases
A conceptual model for multidimensional data
APCCM '08 Proceedings of the fifth Asia-Pacific conference on Conceptual Modelling - Volume 79
Inferring aggregation hierarchies for integration of data marts
DEXA'10 Proceedings of the 21st international conference on Database and expert systems applications: Part II
| Hi-index | 0.00 |
Star schemas describe the structure and properties of multidimensional sources such as data marts and data warehouses. They have a simple structure and a predictable topology. We propose Star-Mod a representation of Star schema model described in UML and infer its instances from relational schemas. StarMod includes a comprehensive set of properties specific to multidimensional data with a view to its application in matching Star schemas. This paper demonstrates that in comparison to using the relational model, the quality of matching between Star schemas is improved if they are described using a more precise model such as StarMod, even if these Star properties are inferred from the relational schema. We demonstrate that StarMod can be also effective for matching arbitrary non-Star relational schemas.