OLAP 메타 데이터 기반 정규화를 이용한 스키마 변환에 관한 연구

Abstract

XML(Extensible Markup Language) is rapidly emerging as a standard format of data representation and exchange on the World Wide Web. Designed combination model of OLAP(On-Line Analytical Processing) Meta data basic element represent DTD(Document Type Definition) into XML. Representing the DTD using the combination model designed by OLAP meta data basic element. In order to store DTD within the XML into RDB (Relational DataBase), we take advantage of the existing research about the shared inlining technology, and "*" node of transformation cardinality operator to overcome the drawbacks of null value in the generated table. In the paper, we present a basic element combination of OLAP meta data represent DTD combination model. Because the existing research expressed fault when we do the conversion from DTD to RDB, in order to overcome that drawback we replenish, propose common structure extraction using inlining normalization technic of cardinality operator graph. In the paper, through normalization of cardinality operator graph proposed, number of the generated tables have been decreased, so an Shard Inlining technic about null value of problem has been solved successfully.