Building the data warehouse (2nd ed.)
Building the data warehouse (2nd ed.)
A methodological framework for data warehouse design
Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
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
Summarizability in OLAP and Statistical Data Bases
SSDBM '97 Proceedings of the Ninth International Conference on Scientific and Statistical Database Management
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
Understanding facts in a multidimensional object-oriented model
Proceedings of the 4th ACM international workshop on Data warehousing and OLAP
On relationships offering new drill-across possibilities
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
Conceptual modeling for ETL processes
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
WAIM '00 Proceedings of the First International Conference on Web-Age Information Management
Information Sources Registration at a Subject Mediator as Compositional Development
ADBIS '01 Proceedings of the 5th East European Conference on Advances in Databases and Information Systems
Modeling the Behavior of OLAP Applications Using an UML Compilant Approach
ADVIS '00 Proceedings of the First International Conference on Advances in Information Systems
Handling Conceptual Multidimensional Models Using XML through DTDs
BNCOD 19 Proceedings of the 19th British National Conference on Databases: Advances in Databases
A Web-Oriented Approach to Manage Multidimensional Models through XML Schemas and XSLT
EDBT '02 Proceedings of the Worshops XMLDM, MDDE, and YRWS on XML-Based Data Management and Multimedia Engineering-Revised Papers
Benefits of an Object-Oriented Multidimensional Data Model
Proceedings of the International Symposium on Objects and Databases
Extending the UML for Multidimensional Modeling
UML '02 Proceedings of the 5th International Conference on The Unified Modeling Language
Multidimensional Modeling with UML Package Diagrams
ER '02 Proceedings of the 21st International Conference on Conceptual Modeling
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
Specification of management views in information warehouse projects
Information Systems
Implementing operations to navigate semantic star schemas
DOLAP '03 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP
Using AutoMed metadata in data warehousing environments
DOLAP '03 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP
An analysis of additivity in OLAP systems
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Representing spatiality in a conceptual multidimensional model
Proceedings of the 12th annual ACM international workshop on Geographic information systems
Applying MDA to the development of data warehouses
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
YAM2: a multidimensional conceptual model extending UML
Information Systems
Hierarchies in a multidimensional model: from conceptual modeling to logical representation
Data & Knowledge Engineering - Special issue: WIDM 2004
A UML profile for multidimensional modeling in data warehouses
Data & Knowledge Engineering - Special issue: ER 2003
Access control and audit model for the multidimensional modeling of data warehouses
Decision Support Systems
A UML-based data warehouse design method
Decision Support Systems
Developing secure data warehouses with a UML extension
Information Systems
Metrics for data warehouse conceptual models understandability
Information and Software Technology
A grain preservation translation algorithm: From ER diagram to multidimensional model
Information Sciences: an International Journal
Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms
Data & Knowledge Engineering
An MDA approach for the development of data warehouses
Decision Support Systems
A conceptual model for multidimensional data
APCCM '08 Proceedings of the fifth Asia-Pacific conference on Conceptual Modelling - Volume 79
Model-Driven Development for Enabling the Feadback from Warehouses and OLAP to Operational Systems
Proceedings of the 2007 conference on Databases and Information Systems IV: Selected Papers from the Seventh International Baltic Conference DB&IS'2006
Defining ETL worfklows using BPMN and BPEL
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Model driven development of secure XML data warehouses: a case study
Proceedings of the 2010 EDBT/ICDT Workshops
Model driven data warehouse using MDA and 2TUP
Journal of Computational Methods in Sciences and Engineering - Special Supplement Issue in Section A and B: Selected Papers from the ISCA International Conference on Software Engineering and Data Engineering, 2009
Logic programming for data warehouse conceptual schema validation
DaWaK'10 Proceedings of the 12th international conference on Data warehousing and knowledge discovery
Improving the development of data warehouses by enriching dimension hierarchies with WordNet
ODBIS'05/06 Proceedings of the First and Second VLDB conference on Ontologies-based databases and information systems
The variety engineering method: analyzing and designing information flows in organizations
Information Systems and e-Business Management
On the requirements for user-centric spatial data warehousing and SOLAP
DASFAA'11 Proceedings of the 16th international conference on Database systems for advanced applications
Reference model and perspective schemata inference for enterprise data integration
INAP'09 Proceedings of the 18th international conference on Applications of declarative programming and knowledge management
A data warehouse engineering process
ADVIS'04 Proceedings of the Third international conference on Advances in Information Systems
Hypergraph-based multidimensional data modeling towards on-demand business analysis
Proceedings of the 13th International Conference on Information Integration and Web-based Applications and Services
Applying transformations to model driven data warehouses
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Building the data warehouse of frequent itemsets in the DWFIST approach
ISMIS'05 Proceedings of the 15th international conference on Foundations of Intelligent Systems
Spatial hierarchies and topological relationships in the spatial MultiDimER model
BNCOD'05 Proceedings of the 22nd British National conference on Databases: enterprise, Skills and Innovation
A practical application of our MDD approach for modeling secure XML data warehouses
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
A taxonomy of inaccurate summaries and their management in OLAP systems
ER'05 Proceedings of the 24th international conference on Conceptual Modeling
ER'06 Proceedings of the 25th international conference on Conceptual Modeling
Using UML packages for designing secure data warehouses
ICCSA'06 Proceedings of the 2006 international conference on Computational Science and Its Applications - Volume Part III
Modeling data warehouse schema evolution over extended hierarchy semantics
Journal on Data Semantics XIII
A model driven process for spatial data sources and spatial data warehouses reconcilation
ICCSA'10 Proceedings of the 2010 international conference on Computational Science and Its Applications - Volume Part I
Evaluation of approaches for designing secure data warehouse
Proceedings of the International Conference on Advances in Computing, Communications and Informatics
ER'12 Proceedings of the 2012 international conference on Advances in Conceptual Modeling
Discovering diverse association rules from multidimensional schema
Expert Systems with Applications: An International Journal
Hi-index | 0.00 |
Modeling data warehouses is a complex task focusing, very often, into internal structures and implementation issues. In this paper we argue that, in order to accurately reflect the users requirements into an error-free, understandable, and easily extendable data warehouse schema, special attention should be paid at the conceptual modeling phase. Based on a real mortgage business warehouse environment, we present a set of user modeling requirements and we discuss the involved concepts. Understanding the semantics of these concepts, allow us to build a conceptual model—namely, the starER model—for their efficient handling. More specifically, the starER model combines the star structure, which is dominant in data warehouses, with the semantically rich constructs of the ER model; special types of relationships have been further added to support hierarchies. We present an evaluation of the starER model as well as a comparison of the proposed model with other existing models, pointing out differences and similarities. Examples from a mortgage data warehouse environment, in which starER is tested, reveal the ease of understanding of the model, as well as the efficiency in representing complex information at the semantic level.