Method and system for designing business domain model, data warehouse model and mapping therebetween synchronously

A system for designing a business domain model, a data warehouse model and a mapping therebetween synchronously, comprising:

• a business domain model design unit, adapted to design a business domain model based on business logic;
• a data warehouse model design unit, adapted to design a data warehouse model based on a structure of a data cube in a data warehouse;
• a mapping design unit, adapted to design a mapping between the business domain model and the data warehouse model when the data warehouse model is being designed;
• an analysis unit, adapted to analyze the business domain model, the data warehouse model and the mapping therebetween based on a predetermined syntax rule;
• and
• an automatic generation unit, adapted to automatically generate 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,
• wherein the business domain model comprises at least one object, each of the at least one object comprising at least one object element;
• the data warehouse model comprises one fact table and at least one dimension table;
• the fact table comprises metric values and a foreign key which points to the at least one dimension table;
• each of the at least one dimension table comprises metadata of a dimension in the data cube;
• and the mapping design unit is adapted to design a mapping between metadata in the at least one dimension table and object elements in the at least one object.