Data warehouse design solutions
Data warehouse design solutions
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
The data webhouse toolkit: building the web-enabled data warehouse
The data webhouse toolkit: building the web-enabled data warehouse
Data warehouse design from XML sources
Proceedings of the 4th ACM international workshop on Data warehousing and OLAP
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Temporal Entity-Relationship Models-A Survey
IEEE Transactions on Knowledge and Data Engineering
A Logical Approach to Multidimensional Databases
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
Extending the E/R Model for the Multidimensional Paradigm
ER '98 Proceedings of the Workshops on Data Warehousing and Data Mining: Advances in Database Technologies
A Comparison of Data Warehouse Development Methodologies Case Study of the Process Warehouse
DEXA '02 Proceedings of the 13th International Conference on Database and Expert Systems Applications
Conceptual Design of Data Warehouses from E/R Schema
HICSS '98 Proceedings of the Thirty-First Annual Hawaii International Conference on System Sciences-Volume 7 - Volume 7
Relational Modeling and Data Warehouse Design
Relational Modeling and Data Warehouse Design
An analysis of structural validity in entity-relationship modeling
Data & Knowledge Engineering
Dimensional modeling: identifying, classifying & applying patterns
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Goal-oriented requirement analysis for data warehouse design
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Triple-driven data modeling methodology in data warehousing: a case study
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
A UML-based data warehouse design method
Decision Support Systems
An efficient and grain preservation mapping algorithm: from ER diagram to multidimensional model
ISSADS'05 Proceedings of the 5th international conference on Advanced Distributed Systems
SAMSTAR: An Automatic Tool for Generating Star Schemas from an Entity-Relationship Diagram
ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
Discovering functional dependencies for multidimensional design
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Automatic validation of requirements to support multidimensional design
Data & Knowledge Engineering
A framework for multidimensional design of data warehouses from ontologies
Data & Knowledge Engineering
Using ontologies to discover fact IDs
DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
A model-driven heuristic approach for detecting multidimensional facts in relational data sources
DaWaK'10 Proceedings of the 12th international conference on Data warehousing and knowledge discovery
Extending the dimensional templates approach to integrate complex multidimensional design concepts
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
Multidimensional database design from document-centric XML documents
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
GEM: requirement-driven generation of ETL and multidimensional conceptual designs
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
A comprehensive framework on multidimensional modeling
ER'11 Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions
Modeling slowly changing dimensions in ORM
OTM'11 Proceedings of the 2011th Confederated international conference on On the move to meaningful internet systems
Requirement-driven creation and deployment of multidimensional and ETL designs
ER'12 Proceedings of the 2012 international conference on Advances in Conceptual Modeling
| Hi-index | 0.00 |
The star schema is widely accepted as the de facto data model for data warehouse design. A popular approach for developing a star schema is to develop it from an entity-relationship diagram with some heuristics. Most of the existing approaches analyze the semantics of an ERD to generate a star schema. In this paper, we present the SAMSTAR method, which semi-automatically generates star schemas from an ERD by analyzing its semantics as well as structure. The novel features of SAMSTAR are (1) the use of the notion of Connection Topology Value (CTV) in identifying the candidates of facts and dimensions and (2) the use of Annotated Dimensional Design Patterns (A_DDP) as well as WordNet to extend the list of dimensions. We illustrate our method by applying it to the examples from existing literature. We prove that the outputs of our method are a superset of those of the existing methods. The SAMSTAR method simplifies the work of experienced designers and gives a smooth head-start to novices.