DocumentCode :
2618061
Title :
A data warehouse logical design method based on the alignment with business processes
Author :
Simonin, Jacques ; Bigaret, Sébastien ; Gourmelen, Julie
Author_Institution :
Telecom Bretagne, Lab.-STICC, Inst. Telecom, Brest, France
fYear :
2012
fDate :
16-18 May 2012
Firstpage :
1
Lastpage :
12
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.
Keywords :
business data processing; data warehouses; pattern classification; business process instance life-cycle; data categorization; data model alignment; data pattern; enterprise databases; epidemiological databases; medical research; rule-based data warehouse logical design method; Data models; Data warehouses; Databases; Design methodology; Organizations; Unified modeling language;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Research Challenges in Information Science (RCIS), 2012 Sixth International Conference on
Conference_Location :
Valencia
ISSN :
2151-1349
Print_ISBN :
978-1-4577-1936-3
Electronic_ISBN :
2151-1349
Type :
conf
DOI :
10.1109/RCIS.2012.6240442
Filename :
6240442
Link To Document :
بازگشت