Federated database systems for managing distributed, heterogeneous, and autonomous databases
ACM Computing Surveys (CSUR) - Special issue on heterogeneous databases
Understanding the new SQL: a complete guide
Understanding the new SQL: a complete guide
An overview of the object protocol model (OPM) and the OPM data management tools
Information Systems - Special issue: databases: their creation, management and utilization
Research problems in data warehousing
CIKM '95 Proceedings of the fourth international conference on Information and knowledge management
The TSIMMIS Approach to Mediation: Data Models and Languages
Journal of Intelligent Information Systems - Special issue: next generation information technologies and systems
The object database standard: ODMG 2.0
The object database standard: ODMG 2.0
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
An overview and classification of mediated query systems
ACM SIGMOD Record
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
SQL standardization: the next steps
ACM SIGMOD Record
A survey of logical models for OLAP databases
ACM SIGMOD Record
Extending OLAP querying to external object databases
Proceedings of the ninth international conference on Information and knowledge management
Multiparadigm Programming in Leda
Multiparadigm Programming in Leda
A foundation for capturing and querying complex multidimensional data
Information Systems - Data warehousing
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals
Data Mining and Knowledge Discovery
Federated databases and systems: part I --- a tutorial on their data sharing
The VLDB Journal — The International Journal on Very Large Data Bases
Federated databases and systems: part II --- a tutorial on their resource consolidation
The VLDB Journal — The International Journal on Very Large Data Bases
Modelling Large Scale OLAP Scenarios
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
XML Data and Object Databases: A Perfect Couple?
Proceedings of the 17th International Conference on Data Engineering
nD-SQL: A Multi-Dimensional Language for Interoperability and OLAP
VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
Extending Practical Pre-Aggregation in On-Line Analytical Processing
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
What can Hierarchies do for Data Warehouses?
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Striving towards Near Real-Time Data Integration for Data Warehouses
DaWaK 2000 Proceedings of the 4th International Conference on Data Warehousing and Knowledge Discovery
STORM: A Statistical Object Representation Model
Proceedings of the 5th International Conference SSDBM on Statistical and Scientific Database Management
Summarizability in OLAP and Statistical Data Bases
SSDBM '97 Proceedings of the Ninth International Conference on Scientific and Statistical Database Management
Querying XML Sources Using an Ontology-Based Mediator
On the Move to Meaningful Internet Systems, 2002 - DOA/CoopIS/ODBASE 2002 Confederated International Conferences DOA, CoopIS and ODBASE 2002
A Pragmatic Approach to Conceptual Modeling of OLAP Security
ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
Querying Multidimensional Databases
DBLP-6 Proceedings of the 6th International Workshop on Database Programming Languages
OLAP++: Powerful and Easy-to-Use Federations of OLAP and Object Databases
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
M(DM): An Open Framework for Interoperation of Multimodel Multidatabase Systems
Proceedings of the Eighth International Conference on Data Engineering
Maintaining Data Cubes under Dimension Updates
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Proposal of a logical model for statistical data base
SSDBM'83 Proceedings of the 2nd international workshop on Proceedings of the Second International Workshop on Statistical Database Management
YAM2: a multidimensional conceptual model extending UML
Information Systems
A UML profile for multidimensional modeling in data warehouses
Data & Knowledge Engineering - Special issue: ER 2003
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 Data Warehouses with Web Data: A Survey
IEEE Transactions on Knowledge and Data Engineering
Meshing Streaming Updates with Persistent Data in an Active Data Warehouse
IEEE Transactions on Knowledge and Data Engineering
Integrating XML data in the TARGIT OLAP system
International Journal of Web Engineering and Technology
RiTE: Providing On-Demand Data for Right-Time Data Warehousing
ICDE '08 Proceedings of the 2008 IEEE 24th International Conference on Data Engineering
OLAP operators for complex object data cubes
ADBIS'10 Proceedings of the 14th east European conference on Advances in databases and information systems
Combining objects with rules to represent aggregation knowledge in data warehouse and OLAP systems
Data & Knowledge Engineering
Scalable test data generation from multidimensional models
Proceedings of the ACM SIGSOFT 20th International Symposium on the Foundations of Software Engineering
Hi-index | 0.00 |
On-line analytical processing (OLAP) systems based on a dimensional view of data have found widespread use in business applications and are being used increasingly in non-standard applications. These systems provide good performance and ease-of-use. However, the complex structures and relationships inherent in data in non-standard applications are not accommodated well by OLAP systems. In contrast, object database systems are built to handle such complexity, but do not support OLAP-type querying well. This paper presents the concepts and techniques underlying a flexible, ''multi-model'' federated system that enables OLAP users to exploit simultaneously the features of OLAP and object systems. The system allows data to be handled using the most appropriate data model and technology: OLAP systems for dimensional data and object database systems for more complex, general data. This allows data analysis on the OLAP data to be significantly enriched by the use of additional object data. Additionally, physical integration of the OLAP and the object data can be avoided. As a vehicle for demonstrating the capabilities of the system, a prototypical OLAP language is defined and extended to naturally support queries that involve data in object databases. The language permits selection criteria that reference object data, queries that return combinations of OLAP and object data, and queries that group dimensional data according to object data. The system is designed to be aggregation-safe, in the sense that it exploits the aggregation semantics of the data to prevent incorrect or meaningless query results. These capabilities may also be integrated into existing languages. It is shown how to integrate relational and XML data using the technology. A prototype implementation of the system is reported, along with performance measurements that show that the approach is a viable alternative to a physically integrated data warehouse.