Title :
Automatic construction of multidimensional schema from OLAP requirements
Author :
Nabli, Ahlem ; Feki, Jammel ; Gargouri, Faiez
Author_Institution :
Faculte des Sci. Economiques, Gestion de Sfax, Tunisia
Abstract :
Summary form only given. The manual design of data warehouse and data mart schemes can be a tedious, error-prone, and time-consuming task. In addition, it is a highly complex engineering task that calls for methodological support. This paper lays the grounds for an automatic generation approach of multidimensional schemes. It first defines a tabular format for OLAP requirements. Secondly, it presents a set of algebraic operators used to transform automatically the OLAP requirements, specified in the tabular format, to data mart modelled either as star or constellation schemes. Our approach is illustrated with an example.
Keywords :
data mining; data warehouses; OLAP requirements; algebraic operators; automatic construction; automatic generation approach; data mart; data warehouse; multidimensional schema; tabular format; Data models; Data systems; Data warehouses; Databases; Delta modulation; Design methodology; Electronic mail; Information systems; Multidimensional systems; Software tools;
Conference_Titel :
Computer Systems and Applications, 2005. The 3rd ACS/IEEE International Conference on
Print_ISBN :
0-7803-8735-X
DOI :
10.1109/AICCSA.2005.1387025
