METHOD AND SYSTEM FOR DESIGNING BUSINESS DOMAIN MODEL, DATA WAREHOUSE MODEL AND MAPPING THEREBETWEEN SYNCHRONOUSLY

摘要

Method and system for designing a business domain model, a Data Warehouse (DW) model and a mapping therebetween synchronously are provided. The method includes: designing a business domain model based on business logic; designing a DW model based on a structure of a data cube in a DW and designing a mapping between the business domain model and the DW model synchronously; analyzing the business domain model, the DW model and the mapping therebetween based on a predetermined syntax rule; and generating a transactional database corresponding to the business domain model, a DW database corresponding to the DW model, and a mapping between data in the transactional database and in the DW database automatically and synchronously. The system includes a business domain model design unit, a DW model design unit, a mapping design unit, an analysis unit and an automatic generation unit. Mappings are designed more easily, efficiently and accurately.

主权项

1. A method for designing a business domain model, a data warehouse model and a mapping therebetween synchronously, comprising:
designing a business domain model based on business logic; designing a data warehouse model based on a structure of a data cube in a data warehouse and designing a mapping relation between the business domain model and the data warehouse model synchronously; analyzing the business domain model, the data warehouse model and the mapping therebetween based on a predetermined syntax rule; and generating a transactional database corresponding to the business domain model, a data warehouse database corresponding to the data warehouse model, and a mapping between data in the transactional database and data in the data warehouse database automatically and synchronously.