Patent Document ID: 9418127
Application ID: 14227526
Patent Status: 1

Claim One:
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, 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 designing a mapping relation between the business domain model and the data warehouse model synchronously comprises designing a mapping between metadata in the at least one dimension table and object elements in the at least one object.