Title :
Model-Driven development method of the virtual data warehouse
Author_Institution :
Innovative Manuf. Eng. Syst. Competence Centre (IMECC), Tallinn, Estonia
Abstract :
The hypothesis of this work is that information systems development is possible with lower TCO (Total Cost of Ownership), if OLAP (On-Line Analytical Processing) data model is developed together with OLTP (On-Line Transaction Processing) data model and if those two models are in relation to each other. By using Model-Driven (MDA) development methods, that kind of combined model makes possible to deploy virtual data warehouse solution with automatically generated ETL (Extract, Transform, Load) business logic. The result of this work is the database meta-model, which stores OLAP and OLTP data models and relations between them. Composed method is base for the virtual data warehouse to provide same kind of functionality like classic and static OLAP dimensional database does.
Keywords :
business data processing; data mining; data models; data warehouses; enterprise resource planning; management information systems; meta data; transaction processing; OLAP data model; business logic; database metamodel; information system development; model driven development; online analytical processing; online transaction processing; total cost of ownership; virtual data warehouse; Analytical models; Business; Data models; Data warehouses; Databases; Erbium; Unified modeling language;
Conference_Titel :
Electronics Conference (BEC), 2010 12th Biennial Baltic
Conference_Location :
Tallinn
Print_ISBN :
978-1-4244-7356-4
Electronic_ISBN :
1736-3705
DOI :
10.1109/BEC.2010.5631007