Design And Implementation Of The Modeling Tool Of Multidimensional Data

Data Warehouse (DW) technique is one of the most popular computer research hotspots in 1990' s. It fulfills the increasing need for analytical processing and information retrieval.And the DW systems benefit for both enterprises and customs.The user tools in the DW systems, which are used for retrieving information in warehouse, is mainly analyzed and researched. They include On-line Analytical Processing (OLAP), multidimensional analysis, report tools, chart tools and so on.This text has proposed and designed the system structure based on three layers of OLAP tools of the relation, have analysed every layers of functions and the division of every module . Designed and realized the multidimensional data modeling tool in OLAP tool at the same time , include the data source management, dimension management and the management of multidimensional theme based on star schema etc.This text propose and realize the defination of structure of metadata in multidimensional data modeling, realize the record of metadata making use of XML. Multidimensional modeling adopt XML as standard of metadata exchanging among the OLAP tool, thus realize the integrates and mutualing of each function component.During the process of analysing and researching, this text has analysed the visit methods of relation data, multidimensional data and XML data in Delphi; And through the course of OLAP multidimensional modeling , have explained how to make use of these methods and principles to realize OLAP multidimensional data modeling tool of the data warehouse system.