The TSIMMIS Approach to Mediation: Data Models and Languages
Journal of Intelligent Information Systems - Special issue: next generation information technologies and systems
The object constraint language: precise modeling with UML
The object constraint language: precise modeling with UML
Data integration: a theoretical perspective
Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Common Warehouse Metamodel Developer's Guide
Common Warehouse Metamodel Developer's Guide
Multidimensional Modeling with UML Package Diagrams
ER '02 Proceedings of the 21st International Conference on Conceptual Modeling
IBM Systems Journal
Integrating heterogeneous data warehouses using XML technologies
Journal of Information Science
Reducing the cost of accessing relations in incremental view maintenance
Decision Support Systems
A UML profile for multidimensional modeling in data warehouses
Data & Knowledge Engineering - Special issue: ER 2003
Combining schema and instance information for integrating heterogeneous data sources
Data & Knowledge Engineering
A UML-based data warehouse design method
Decision Support Systems
Developing secure data warehouses with a UML extension
Information Systems
From Federated Databases to a Federated Data Warehouse System
HICSS '08 Proceedings of the Proceedings of the 41st Annual Hawaii International Conference on System Sciences
Two approaches to the integration of heterogeneous data warehouses
Distributed and Parallel Databases
Cheetah: a high performance, custom data warehouse on top of MapReduce
Proceedings of the VLDB Endowment
ER'11 Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions
Analysing multi-dimensional data across autonomous data warehouses
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
OLAP query reformulation in peer-to-peer data warehousing
Information Systems
Automating the schema matching process for heterogeneous data warehouses
DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery
Proceedings of the 21st ACM international conference on Information and knowledge management
Hi-index | 0.00 |
Extending analytical decision making beyond the boundaries of a single organization is a key challenge of modern Business Intelligence systems. Federated Data Warehouses (FDWs) are an important cornerstone to this end, offering new opportunities for business collaboration and similar scenarios. The FedDW approach provides such a federated architecture with a mediated multidimensional schema over autonomous data marts---with advantages for both, OLAP users and data warehouse administrators. Users comfortably access the global mediated schema with traditional OLAP applications while administrators retain full schema and data management autonomy. Although the underlying concepts are mature, comprehensive design tools for FDWs remain an open issue. To tackle the challenge, this paper presents FedDW Global Schema Architect (GSA), a visual design tool for federations of autonomous ROLAP data marts. FedDW integrates data marts at the schema level which avoids the laborious and error-prone physical DW integration. GSA manages all metadata--the global mediated schema, the import schemas, and the semantic mappings repairing multidimensional heterogeneity among the data marts--within one and the same tool. Its implementation employs the extension mechanisms of Eclipse and is based on the UML and CWM (Common Warehouse Metamodel) standards. Thus, the tool is extensible, intuitive for its users, and supports DW platforms of multiple vendors.