Browse > Article
http://dx.doi.org/10.3745/KIPSTD.2002.9D.6.971

Design and implementation of a Web-based OLAP metadata interchange system  

Lee, In-Gi (이화여자대학교 과학기술대학원 컴퓨터학과)
Lee, Min-Soo (이화여자대학교 컴퓨터학과)
Yong, Hwan-Seung (이화여자대학교 컴퓨터학과)
Publication Information
The KIPS Transactions:PartD / v.9D, no.6, 2002 , pp. 971-980 More about this Journal
Abstract
As the importance of knowledge management is being recognized, there is a significant amount of increase for interest in data warehousing. On-Line Analytical Processing (OLAP) systems can effectively make use of data warehouses. Although there are many commercial OLAP products, they have been developed without any kind of standard resulting in poor data exchange and difficulty in interfacing among the OLAP products. In this paper we propose an OLAP metadata interchange model that can be used among different OLAP products and have implemented an OLAP metadata interchange system that can interchange the cubes created from the metadata. XML is used for the OLAP metadata model and the user interface is Web-based, which makes it easier to interchange metadata among different OLAP products. Users can experience the different analysis environments of different products without the need to learn the complex cube creation process for each product. By extending this research to design a common query language that can be used among OLAP products, OLAP products should be able to more easily talk to one another.
Keywords
OLAP; XML; Metadata; Interchange;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 Meta Data Coalition, Open Information Model Version 1.0, http://www.mdcinfo.com/, August, 1999
2 Microsoft, OLE DB for OLAP 2.0 Beta Specification, http://www.microsoft.com/data/oledb/olap/spec/
3 Tomas Stohr, Robert Muller, Erhard Rahm, 'An Integrative and Uniform Model for Metadata Management in Data Warehouse,' Proceeding of the International Workshop on Design and Management of Data Warehouses, 1999
4 David Marco, 'Meta Data Moves Mainstream,' Enterprise Warehousing Solutions, 1998
5 'Putting Metadata to Work in the Warehouse,' http://www.cai.com/products/platinum/wp/wp_meta.htm
6 Developing Effective Decision Support Objects (DSO) Solutions with Microsoft SQL Server 2000 Analysis Services, http://msdn.microsoft.com/library/techart/dsosql.htm
7 Vitorio Viarengo, 'eXcelon XML Data Server Technical Overview,' Object Exchange 98, Object Design User Conference, 1998
8 E. Thomsen, OLAP Solution, John Wiley &Sons. 1997
9 조재희, 박성진, OLAP Technology, Sigma Consulting Group, 1999
10 Philip A. Bernstein, Brain Harry, Paul Sanders, 'The Microsoft Repository,' Proceeding of the 23rd VLDB Conference, Athens Greece, 1997
11 OLAP Council, MDAPI specification version 2.0, http://www.olapcouncil.org/
12 Oracle, Oracle Express Server 6.3.2.1 Documentation, http://technet.oracle.com/software/products/exp_server/software_index.htm
13 Cheng Hsu, Mhamed Bouziane, Laurie Rattner, Lester Yee, 'Information Resources Management in Heterogeneous, Distributed Environments : Metadatabase Approach,' IEEE Transaction on Software Engineering(Forthcoming), 1991   DOI   ScienceOn
14 Panos Vassiliadis, Timos Sellis, 'A Survey on Logical Models for OLAP Databases,' Technical Report, accepted for publication at SIGMOD
15 J. C. Mamou, T. Milo, 'XML repository and Active Views Demonstration,' Proceeding of the 25th VLDB Conference, Edinburgh, Scotland, pp.742-745, 1999
16 Daniela Florescu, Donald Kossmann, 'A Performance Evaluation of Alternative Mapping Schemes for Storing XML Data in a Relational Database,' INRIA Technical Report, No.3680, May, 1999
17 Pilot Software, Introducing Pilot Desktop & Pilot Designer, 1998