The structures entity-relationship model (SERM)
Angewandte Informatik
Building the data warehouse (2nd ed.)
Building the data warehouse (2nd ed.)
The data warehouse toolkit: practical techniques for building dimensional data warehouses
The data warehouse toolkit: practical techniques for building dimensional data warehouses
A dimensional modeling manifesto
DBMS - Special issue on data warehousing
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
Data Warehousing in the Real World: A Practical Guide for Building Decision Support Systems
Data Warehousing in the Real World: A Practical Guide for Building Decision Support Systems
Physical Database Design for Data Warehouses
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Statistical Databases: Characteristics, Problems, and some Solutions
VLDB '82 Proceedings of the 8th International Conference on Very Large Data Bases
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
Normalising OLAP cubes for controlling sparsity
Data & Knowledge Engineering
Mapping conceptual to logical models for ETL processes
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Designing ETL processes using semantic web technologies
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
A grain preservation translation algorithm: From ER diagram to multidimensional model
Information Sciences: an International Journal
An adaptive approach to schema classification for data warehouse modeling
Journal of Computer Science and Technology
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
A method for the mapping of conceptual designs to logical blueprints for ETL processes
Decision Support Systems
Design and implementation of a national data warehouse
AIKED'06 Proceedings of the 5th WSEAS International Conference on Artificial Intelligence, Knowledge Engineering and Data Bases
Railway data warehousing system for booking data analysis
ICCOMP'05 Proceedings of the 9th WSEAS International Conference on Computers
Adaptive Web SitesA Knowledge Extraction from Web Data Approach
Proceedings of the 2008 conference on Adaptive Web Sites: A Knowledge Extraction from Web Data Approach
ER'07 Proceedings of the 26th international conference on Conceptual modeling
A framework for multidimensional design of data warehouses from ontologies
Data & Knowledge Engineering
A methodology and tool for conceptual designing a data warehouse from ontology-based sources
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
Data warehouse development with EPC
DNCOCO'06 Proceedings of the 5th WSEAS international conference on Data networks, communications and computers
Efficiency and effectiveness of data warehousing: a case study
SMO'05 Proceedings of the 5th WSEAS international conference on Simulation, modelling and optimization
MDA compliant approach for data mart schemas generation
MEDI'11 Proceedings of the First international conference on Model and data engineering
A comprehensive framework on multidimensional modeling
ER'11 Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions
Multidimensional design by examples
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Requirements specification and conceptual modeling for spatial data warehouses
OTM'06 Proceedings of the 2006 international conference on On the Move to Meaningful Internet Systems: AWeSOMe, CAMS, COMINF, IS, KSinBIT, MIOS-CIAO, MONET - Volume Part II
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
Hi-index | 0.00 |
In recent years the construction of large scale data schemes for operational systems has been the major problem of conceptual data modeling for business needs. Multidimensional data structures used for decision support applications in data warehouses have rather different requirements to data modeling techniques. In case of operational systems the data models are created from application specific requirements. The data models in data warehouses base on the analytical requirements of the users. Furthermore, the development of data warehouse structures implicates the consideration of user-defined information requirements as well as the underlying operational source systems. In this paper we show that the conceptual data models of the underlying operational information systems can support the construction of multidimensional structures. We would like to point out that the special features of the Structured Entity Relationship Model (SERM) are not only useful for the development of big operational systems but can also help with the derivation of data warehouse structures. The SERM is an extension of the conventional Entity Relationship Model (ERM) and the conceptual basis of the data modeling technique used by the SAP Corporation. To illustrate the usefulness of this approach we explain the derivation of the warehouse structures from the conceptual data model of a flight reservation system.