Federated database systems for managing distributed, heterogeneous, and autonomous databases
ACM Computing Surveys (CSUR) - Special issue on heterogeneous databases
A cost model for path expressions in object-oriented queries
Journal of Database Management
OLAP solutions: building multidimensional information systems
OLAP solutions: building multidimensional information systems
Extending OLAP querying to external object databases
Proceedings of the ninth international conference on Information and knowledge management
Fundamentals of Database Systems
Fundamentals of Database Systems
Query optimization for OLAP-XML federations
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Cost Models DO Matter: Providing Cost Information for Diverse Data Sources in a Federated System
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Query Optimization in a Heterogeneous DBMS
VLDB '92 Proceedings of the 18th International Conference on Very Large Data Bases
The Fittest Survives: An Adaptive Approach to Query Optimization
VLDB '95 Proceedings of the 21th International Conference on Very Large Data Bases
Calibrating the Query Optimizer Cost Model of IRO-DB, an Object-Oriented Federated Database System
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
SSDBM '02 Proceedings of the 14th International Conference on Scientific and Statistical Database Management
Leveraging Mediator Cost Models with Heterogeneous Data Sources
ICDE '98 Proceedings of the Fourteenth International Conference on Data Engineering
Developing Cost Models with Qualitative Variables for Dynamic Multidatabase Environments
ICDE '00 Proceedings of the 16th International Conference on Data Engineering
Query optimization for OLAP-XML federations
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
Evaluating XML-extended OLAP queries based on a physical algebra
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Integrating XML data in the TARGIT OLAP system
International Journal of Web Engineering and Technology
On-demand multidimensional data integration: toward a semantic foundation for cloud intelligence
The Journal of Supercomputing
| Hi-index | 0.00 |
The ever-changing data requirements of today's dynamic businesses are not handled well by current OLAP systems. Physical integration of data into OLAP systems is a time-consuming process, making logical federations the better choice in many cases. The increasing use of XML suggests that the required data will often be available in XML format. Thus, federations of OLAP and XML databases will be very attractive in many situations. In an efficient implementation of OLAP-XML federations, cost-based optimization is a must, creating a need for an effective cost model for OLAP-XML federations.In this paper we present a cost model for OLAP-XML federations, and outline techniques for estimating the cost model parameters in a federated OLAP-XML environment. The paper also outlines the cost models for the OLAP and XML components in the federation on which the federation cost model is built. The cost model has been used as the basis for effective cost-based query optimization in OLAP-XML federations. Experiments show that the cost model is precise enough to make a substantial difference in the query optimization process.