Constructing data warehouses based on operational metadata-driven builder pattern

At present methods for constructing data warehouses are almost “case-to-case” pattern. This study illustrates the “case-to-case” pattern for ETL process in the course of the data warehouse construction with an example and shows that its biggest shortcoming is lower efficiency. The “builder pattern” is one of design patterns in the area of software engineering. A method, called “operational metadata-driven builder pattern” for constructing data warehouses is put forward by this study, which takes generic knowledge and object-specific knowledge apart from each other. To design and develop ETL process of data warehouse based on this method can eliminate the unnecessary repetitive operations under the “case-to-case” pattern.