A data warehouse logical design method based on the alignment with business processes

Abstract

The design of a data warehouse from the databases of the enterprise is a very important feature to specify the strategy of this enterprise. The strategy is indeed deduced from the enterprise results stored in its databases. The business processes of the enterprise have moreover to be consistent with this strategy. We propose then a rule-based data warehouse design method. The rules target first a data model alignment with respect to the business processes model. The other rules are featured by a data pattern proposing a solution for the data warehouse design in relation to the categorization of the data. The pattern is compliant with the life-cycle of a business process instance. This pattern is moreover relevant for the specification of the queries concerning the data warehouse. This data warehouse design method based on rules is experimented from two epidemiological databases building up for medical research.