Federated database systems for managing distributed, heterogeneous, and autonomous databases
ACM Computing Surveys (CSUR) - Special issue on heterogeneous databases
OLAP solutions: building multidimensional information systems
OLAP solutions: building multidimensional information systems
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
WSQ/DSQ: a practical approach for combined querying of databases and the Web
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
Extending OLAP querying to external object databases
Proceedings of the ninth international conference on Information and knowledge management
A foundation for capturing and querying complex multidimensional data
Information Systems - Data warehousing
A powerful and SQL-compatible data model and query language for OLAP
ADC '02 Proceedings of the 13th Australasian database conference - Volume 5
Professional SQL Server 2000 Data Warehousing with Analysis Services
Professional SQL Server 2000 Data Warehousing with Analysis Services
Optimizing Queries Across Diverse Data Sources
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Hash Joins and Hash Teams in Microsoft SQL Server
VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
nD-SQL: A Multi-Dimensional Language for Interoperability and OLAP
VLDB '98 Proceedings of the 24rd 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
Cost Modeling and Estimation for OLAP-XML Federations
DaWaK 2000 Proceedings of the 4th International Conference on Data Warehousing and Knowledge Discovery
Summarizability in OLAP and Statistical Data Bases
SSDBM '97 Proceedings of the Ninth International Conference on Scientific and Statistical Database Management
SSDBM '02 Proceedings of the 14th International Conference on Scientific and Statistical Database Management
Maintaining Data Cubes under Dimension Updates
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Integrating XML Data in the TARGITOLAP System
ICDE '04 Proceedings of the 20th International Conference on Data Engineering
Evaluating XML-extended OLAP queries based on a physical algebra
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Exploiting versions for on-line data warehouse maintenance in MOLAP servers
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Integrating XML Data in the TARGITOLAP System
ICDE '04 Proceedings of the 20th International Conference on Data Engineering
Data & Knowledge Engineering
On-demand multidimensional data integration: toward a semantic foundation for cloud intelligence
The Journal of Supercomputing
| Hi-index | 0.00 |
This paper presents the results of industrial work on the logical integration of Online Analytical Processing (OLAP) and eXtensible Markup Language (XML) data sources, carried out in cooperation between TARGIT, a Danish OLAP client vendor, and Aalborg University. A prototype has been developed that allows XML data stored outside the OLAP system to be used as dimensions and measures in the OLAP system in the same way as ordinary dimensions and measures. This provides a powerful and flexible way to handle unexpected or short-term data requirements as well as rapidly changing data. Compared to earlier work, this paper presents several major extensions that resulted from TARGIT'S requirements. These include the ability to use XML data as measures, as well as a novel multigranular data model and query language that formalises and extends the TARGIT data model and query language. Experiments indicate that our approach is often a feasible alternative to physical integration.