Dealing with complexity: an introduction to the theory & applications of systemsscience
Dealing with complexity: an introduction to the theory & applications of systemsscience
OLAP and statistical databases: similarities and differences
PODS '97 Proceedings of the sixteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
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
Database abstractions: aggregation and generalization
ACM Transactions on Database Systems (TODS)
Automatically generating OLAP schemata from conceptual graphical models
Proceedings of the 3rd ACM international workshop on Data warehousing and OLAP
A foundation for capturing and querying complex multidimensional data
Information Systems - Data warehousing
Fundamentals of Database Systems
Fundamentals of Database Systems
A Taxonomy of Indexing Schemes for Parallel Database Systems
Distributed and Parallel Databases
Information Sciences—Applications: An International Journal
Reasoning about Summarizability in Heterogeneous Multidimensional Schemas
ICDT '01 Proceedings of the 8th International Conference on Database Theory
What can Hierarchies do for Data Warehouses?
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Normal Forms for Multidimensional Databases
SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
Dimension Hierarchies Design from UML Generalizations and Aggregations
ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
Why is the snowflake schema a good data warehouse design?
Information Systems
Reconsidering Multi-Dimensional schemas
ACM SIGMOD Record
Global parallel index for multi-processors database systems
Information Sciences: an International Journal
Performance analysis of "Groupby-After-Join" query processing in parallel database systems
Information Sciences—Informatics and Computer Science: An International Journal
Applied Microsoft Analysis Services 2005: And Microsoft Business Intelligence Platform
Applied Microsoft Analysis Services 2005: And Microsoft Business Intelligence Platform
Capturing summarizability with integrity constraints in OLAP
ACM Transactions on Database Systems (TODS)
Database Management Systems
Denormalization strategies for data retrieval from data warehouses
Decision Support Systems
Hierarchies in a multidimensional model: from conceptual modeling to logical representation
Data & Knowledge Engineering - Special issue: WIDM 2004
Processing star queries on hierarchically-clustered fact tables
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications (Data-Centric Systems and Applications)
High Performance Parallel Database Processing and Grid Databases
High Performance Parallel Database Processing and Grid Databases
Database Principles and Design
Database Principles and Design
Effective data warehouse for information delivery: a literature survey and classification
International Journal of Networking and Virtual Organisations
Hi-index | 0.00 |
Two of the most data model in Data Warehouse (DW) and advanced database includes star and snowflake schema, which play pivotal roles in the underlying performance. Today, DW queries comprise a group of aggregations and joining operations. As a result, snowflake schema does not seem to be an adequate option since several relations must combine to provide answers for queries that involve aggregation. In spite of its widespread application and undeniable advantages, snowflaking technique has certain theoretical and practical demerits. This paper proposes Hierarchical Degenerate Snowflake (HDS) as an alternative logical data model to achieve DW structure to improve the query performance.