Understanding the new SQL: a complete guide
Understanding the new SQL: a complete guide
The TSIMMIS Approach to Mediation: Data Models and Languages
Journal of Intelligent Information Systems - Special issue: next generation information technologies and systems
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
Storing semistructured data with STORED
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Microsoft OLAP solutions
The object data standard: ODMG 3.0
The object data standard: ODMG 3.0
Comparative analysis of five XML query languages
ACM SIGMOD Record
Extending OLAP querying to external object databases
Proceedings of the ninth international conference on Information and knowledge management
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals
Data Mining and Knowledge Discovery
ICDT '97 Proceedings of the 6th International Conference on Database Theory
Extending Practical Pre-Aggregation in On-Line Analytical Processing
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Relational Databases for Querying XML Documents: Limitations and Opportunities
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
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
Quilt: An XML Query Language for Heterogeneous Data Sources
Selected papers from the Third International Workshop WebDB 2000 on The World Wide Web and Databases
Declarative specification of Web sites with S
The VLDB Journal — The International Journal on Very Large Data Bases
Constructing an OLAP cube from distributed XML data
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
Converting XML DTDs to UML diagrams for conceptual data integration
Data & Knowledge Engineering - Special issue: Data integration over the Web
Integrating heterogeneous data warehouses using XML technologies
Journal of Information Science
A high performance integrated web data warehousing
Cluster Computing
Ix-cubes: iceberg cubes for data warehousing and olap on xml data
Proceedings of the sixteenth ACM conference on Conference on information and knowledge management
Two approaches to the integration of heterogeneous data warehouses
Distributed and Parallel Databases
Expressing OLAP operators with the TAX XML algebra
DataX '08 Proceedings of the 2008 EDBT workshop on Database technologies for handling XML information on the web
A relational data harmonization approach to XML
Journal of Information Science
A secure multiparty computation privacy preserving OLAP framework over distributed XML data
Proceedings of the 2010 ACM Symposium on Applied Computing
Finding an application-appropriate model for XML data warehouses
Information Systems
OLAP operators for complex object data cubes
ADBIS'10 Proceedings of the 14th east European conference on Advances in databases and information systems
Journal of Computer and System Sciences
XML-OLAP: a multidimensional analysis framework for XML warehouses
DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery
Design and development of a tool for integrating heterogeneous data warehouses
DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery
Integrating XML sources into a data warehouse
DEECS'06 Proceedings of the Second international conference on Data Engineering Issues in E-Commerce and Services
An ETL process for OLAP using RDF/OWL ontologies
Journal on Data Semantics XIII
Proceedings of the 17th International Database Engineering & Applications Symposium
Hi-index | 0.00 |
On-Line Analytical Processing (OLAP) enables analysts to gain insight about data through fast and interactive access to a variety of possible views on information, organized in a dimensional model. The demand for data integration is rapidly becoming larger as more and more information sources appear in modern enterprises. In the data warehousing approach, selected information is extracted in advance and stored in a repository, yielding good query performance. However, in many situations a logical (rather than physical) integration of data is preferable. Previous web-based data integration efforts have focused almost exclusively on the logical level of data models, creating a need for techniques focused on the conceptual level. Also, previous integration techniques for web-based data have not addressed the special needs of OLAP tools such as handling dimensions with hierarchies. Extensible Markup Language (XML) is fast becoming the new standard for data representation and exchange on the World Wide Web. The rapid emergence of XML data on the web, e.g., business-to-business (B2B) e-commerce, is making it necessary for OLAP and other data analysis tools to handle XML data as well as traditional data formats.Based on a real-world case study, this paper presents an approach to specification of OLAP DBs based on web data. Unlike previous work, this approach takes special OLAP issues such as dimension hierarchies and correct aggregation of data into account. Also, the approach works on the conceptual level, using Unified Modeling Language (UML) as a basis for so-called UML snowflake diagrams that precisely capture the multidimensional structure of the data. An integration architecture that allows the logical integration of XML and relational data sources for use by OLAP tools is also presented.