A methodological framework for data warehouse design
Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
An object oriented approach to multidimensional database conceptual modeling (OOMD)
Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
starER: a conceptual model for data warehouse design
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Automatically generating OLAP schemata from conceptual graphical models
Proceedings of the 3rd ACM international workshop on Data warehousing and OLAP
Designing data marts for data warehouses
ACM Transactions on Software Engineering and Methodology (TOSEM)
Constructing OLAP cubes based on queries
Proceedings of the 4th ACM international workshop on Data warehousing and OLAP
On aggregation issues in spatial data management
ADC '02 Proceedings of the 13th Australasian database conference - Volume 5
A novel three-level architecture for large data warehouses
Journal of Systems Architecture: the EUROMICRO Journal
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
On Schema Evolution in Multidimensional Databases
DaWaK '99 Proceedings of the First International Conference on Data Warehousing and Knowledge Discovery
Functional Dependencies in Controlling Sparsity of OLAP Cubes
DaWaK 2000 Proceedings of the Second International Conference on Data Warehousing and Knowledge Discovery
On Making Data Warehouses Active
DaWaK 2000 Proceedings of the Second International Conference on Data Warehousing and Knowledge Discovery
Supporting Dimension Updates in an OLAP Server
CAiSE '02 Proceedings of the 14th International Conference on Advanced Information Systems Engineering
QFD Matrix for Incremental Construction of a Warehouse via Data Marts
FoMLaDO/DEMM 2000 Selected papers from the 9th International Workshop on Foundations of Models and Languages for Data and Objects, Database Schema Evolution and Meta-Modeling
Benefits of an Object-Oriented Multidimensional Data Model
Proceedings of the International Symposium on Objects and Databases
E/R Based Scenario Modeling for Rapid Prototyping of Web Information Services
ER '99 Proceedings of the Workshops on Evolution and Change in Data Management, Reverse Engineering in Information Systems, and the World Wide Web and Conceptual Modeling
Dimension Hierarchies Design from UML Generalizations and Aggregations
ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
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
A Model and a Toolkit for Supporting Incremental Data Warehouse Construction
DEXA '02 Proceedings of the 13th International Conference on Database and Expert Systems Applications
Why is the snowflake schema a good data warehouse design?
Information Systems
A methodology for datawarehouse design: conceptual modeling
Data warehousing and web engineering
Context-sensitive mobile database summarisation
ACSC '03 Proceedings of the 26th Australasian computer science conference - Volume 16
Multidimensional normal forms for data warehouse design
Information Systems
Conceptual multidimensional models
Multidimensional databases
Normalising OLAP cubes for controlling sparsity
Data & Knowledge Engineering
Specification of management views in information warehouse projects
Information Systems
Supporting dimension updates in an OLAP server
Information Systems - Special issue: The 14th international conference on advanced information systems engineering (CAiSE*02)
An analysis of additivity in OLAP systems
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
EDOC '05 Proceedings of the Ninth IEEE International EDOC Enterprise Computing Conference
YAM2: a multidimensional conceptual model extending UML
Information Systems
A methodological framework for conceptual data warehouse design
Proceedings of the 43rd annual Southeast regional conference - Volume 1
A high performance integrated web data warehousing
Cluster Computing
A grain preservation translation algorithm: From ER diagram to multidimensional model
Information Sciences: an International Journal
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
A user-driven data warehouse evolution approach for concurrent personalized analysis needs
Integrated Computer-Aided Engineering
Data warehouse architecture for GIS applications
Proceedings of the 10th International Conference on Information Integration and Web-based Applications & Services
Data governance strategy: a key issue in building Enterprise Data Warehouse
Proceedings of the 11th International Conference on Information Integration and Web-based Applications & Services
Extraction and exploitation of intensional knowledge from heterogeneous information sources: semi-automatic approaches and tools
A systematic approach for transformation of ER schema to dimensional schema
Proceedings of the 7th International Conference on Frontiers of Information Technology
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
MDA compliant approach for data mart schemas generation
MEDI'11 Proceedings of the First international conference on Model and data engineering
Hybrid methodology for data warehouse conceptual design by UML schemas
Information and Software Technology
A multiversion-based multidimensional model
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Warehousing dynamic XML documents
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Extending UML 2 activity diagrams with business intelligence objects
DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery
A strategy for maintaining client-based web warehouse
HSI'05 Proceedings of the 3rd international conference on Human Society@Internet: web and Communication Technologies and Internet-Related Social Issues
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
X-warehousing: an XML-based approach for warehousing complex data
ADBIS'06 Proceedings of the 10th East European conference on Advances in Databases and Information Systems
Integrating XML sources into a data warehouse
DEECS'06 Proceedings of the Second international conference on Data Engineering Issues in E-Commerce and Services
Differentiated multiple aggregations in multidimensional databases
DaWaK'12 Proceedings of the 14th international conference on Data Warehousing and Knowledge Discovery
Hi-index | 0.00 |
Data warehousing systems enable enterprise managers to acquire and integrate information from heterogeneous sources and to query very large databases efficiently. Building a data warehouse requires adopting design and implementation techniques completely different from those underlying information systems. In this paper we present a graphical conceptual model for data warehouses, called Dimensional Fact model, and propose a semi-automated methodology to build it from the pre-existing Entity/Relationship schemes describing a database. Our conceptual model consists of tree-structured fact schemes whose basic elements are facts, attributes, dimensions and hierarchies; other features which may be represented on fact schemes are the additivity of fact attributes along dimensions, the optionality of dimension attributes and the existence of non-dimension attributes. Compatible fact schemes may be overlapped in order to relate and compare data. Fact schemes may be integrated with information of the conjectured workload, expressed in terms of query patterns, to be used as the input of a design phase whose output are the logical and physical schemes of the data warehouse.