EDMIS: Metadata interchange system for OLAP

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

Abstract

The management of enterprise-wide information requires that metadata should be shared and globally accessible by all the heterogeneous products found in today's information technology environment. OLAP metadata includes various information about objects and the relationships among them in an OLAP system. OLAP tools are provided by different vendors and run on different hardware and software platforms. But there still is no standard for a logical OLAP model. To use OLAP tools efficiently, users need to be able to move metadata between tools or between tools and a repository. In this paper, we have designed a metadata interchange model that can be shared among OLAP systems and have implemented a prototype called EDMIS as the OLAP metadata interchange system. The OLAP metadata interchange model that we propose in this paper is designed using XML DTDs. This model lists typical mismatches among the data models of commercial OLAP tools and proposes methods to overcome these differences. The OLAP metadata interchange system enables users to browse and search OLAP metadata on the Web. In addition, if a user wants to use the metadata in another OLAP system, the implemented system can automatically create new cubes using metadata in the repository. In order to validate the usefulness of the proposed system, we have used OLAP products such as MS SQL Server Analysis Services, Pilot DSS and Oracle Express.

Original languageEnglish
Title of host publicationEurAsia-ICT 2002
Subtitle of host publicationInformation and Communication Technology - First EurAsian Conference, Proceedings
EditorsHassan Shafazand, A. Min Tjoa, Hassan Shafazand
PublisherSpringer Verlag
Pages297-305
Number of pages9
ISBN (Print)3540000283, 9783540000280
DOIs
StatePublished - 2002
Event1st EurAsian Conference on Advances in Information and Communication Technology, EurAsia-ICT 2002 - Shiraz, Iran, Islamic Republic of
Duration: 29 Oct 200231 Oct 2002

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume2510 LNCS
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Conference

Conference1st EurAsian Conference on Advances in Information and Communication Technology, EurAsia-ICT 2002
Country/TerritoryIran, Islamic Republic of
CityShiraz
Period29/10/0231/10/02

Fingerprint

Dive into the research topics of 'EDMIS: Metadata interchange system for OLAP'. Together they form a unique fingerprint.

Cite this