Implementing data cubes efficiently
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
An overview of data warehousing and OLAP technology
ACM SIGMOD Record
Benchmark Handbook: For Database and Transaction Processing Systems
Benchmark Handbook: For Database and Transaction Processing Systems
Planning and Designing the Data Warehouse
Planning and Designing the Data Warehouse
Algorithms for Materialized View Design in Data Warehousing Environment
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Denormalization Effects on Performance of RDBMS
HICSS '01 Proceedings of the 34th Annual Hawaii International Conference on System Sciences ( HICSS-34)-Volume 3 - Volume 3
Query optimization by semantic reasoning
Query optimization by semantic reasoning
Improving database performances in a changing environment with uncertain and dynamic information demand: an intelligent database system approach
Theory, Volume 1, Queueing Systems
Theory, Volume 1, Queueing Systems
A simulation-based approach for dynamic process management at web service platforms
Computers and Industrial Engineering
An optimal workload-based data allocation approach for multidisk databases
Data & Knowledge Engineering
A simulation-based approach for dynamic process management at web service platforms
Computers and Industrial Engineering
Hi-index | 0.00 |
We summarize the problem tackled here in the following way: Given a modern database application environment, how can we identify and select the database structure that provides robust performance across changing query patterns and arrival rate conditions? We demonstrate the importance of investigating the underlying relationships and then utilize this information in formulating robust structures. Our work is pre-theory in the philosophy of science sense. That is, the careful identification and observation of relationships will subsequently be utilized in formulating a testable theory of the development of robust database structures under dynamic query patterns and arrival rates. Our first step in providing a database design or "structure selection" method is to determine potential good performers among different database structures. These potential good performers are selected and analyzed across arrays of query patterns. The next step is to identify database structures that are robust structures, that is good performers across the different types of query patterns and arrival rate levels. The presentation includes illustrations of the determination of actual query pattern processing times and the use of these times within a queuing analysis. In fact, for the database layout analyzed, application of our methods demonstrates the existence of such robust database structures.