Inès GAM Dr. Camille SALINESI Centre de Recherche en Informatique Université Paris1 – Panthéon Sorbonne 1
A Requirement-driven Approach for Designing Data Warehouses RE/WS RE/WS Strategies RE/DW Strategies cu_DW systems 2
Transactional System Decisional System Users Operational agents Decision maker Thousands Hundreds Design Operationally oriented Subject oriented Relatively static Change Data For a « certain » period historized Detailed Aggregated Updated Recalculated Treatments Simple requests Complex requests Repetitive Varying Accessed tuples dozens/hundreds Thousands Data Bases MB/GB GB/TB 3
4 Informations CADWA approach Schiefer, Böhnlein, Paim, High level requirements winter, Prakash, Mazon Meta Data Fragments Reusable DW Strategies Decisions
•Goal modelling •Decomposition guidelines Elicitation Business Plans DW model DW model Fragments Adaptation • Indicator Integration identification guidelines • Library of reusable requirements and model • Abstraction rules fragments DW model • Data compliance • Mapping guidelines Fragments guidelines • Modelling guidelines 5
Adjust price position, especially in the hypermarkets in France. Improve growth and profitability of international business. Rationalize business portfolio Strengthen financial position 6
- Requirement Elicitation Phase - Elicit Requirements Adaptation Integration adapting System requirements Input: - Informal DW user requirements Output: OBP OBP OBP OBP - Organization Business plan (OBP) Define OBP - Decision-maker macro business plan (MaBP) - Decision-maker micro business plan (MiBP) Distribute OBP MaBP MaBP MaBP among users - Action Plan (AP) Sub activities: - Elicitate objectives MiBP MiBP MiBP Define MiBP - Define OBP - Distribute OBP among users AP AP AP Operationalize actions - Define MiBP - Operationalize actions Plans according to high level requirements Elicitate Requirements guidelines 7
- Requirements Elicitation phase : Design of business plans - Elicit Requirements S Demk I k Démarrer S0: Demarrer,I k , S Demk , S ki S1: I i ,I j ,S ij1 I j S2: I i ,I j , S ij2 Input: S ij1 S3: I i , I i , S ii - Informal DW user requirements I i S4: I k ,I i ,S ki S jTer Output: S5: I j ,Terminer,S jTer S ij2 - Organization Business plan (OBP) S ii Terminer - Decision-maker macro business plan (MaBP) - Decision-maker micro business plan (MiBP) - Action Plan (AP) – A map is a labelled directed graph – An intention (goals to achieve or maintain) as nodes Sub activities: – A strategy is an edge - Elicitate objectives –A section is a triplet < Ii , Ij, Sij > where Ii is the source - Define OBP intention, Ij the target intention and Sij the strategy to attain - Distribute OBP among users when Ii has been achieved. - Define MiBP - Operationalize actions Elicitate Requirements guidelines 8
By reducing cost product (1) Start a Adjust price b By increasing the number of customers position (2) By reducing the net indebtedness (2) (1) B y s e l l i n g n o n s t r a t e g i c a n d n o n p r o f i t a b l e b u s i n e s s Decision-maker macro business plan B y i m p r o v e m e n t o f f i n a n c i a l r a t i o s (3) Improve profitability of International c Business Organization Business Plans 9
(1) By increasing investment in pricing Strengthen price image Start (2) a By improving in France communications b (1) (2) By proposing promotions By reducing prices (3) (1) Win By mastering costs Attract more By proposing non- (1) By increasing market customers food products the franchise c (2) share e (1) By increasing multi (1) Accelerate format business By completeness growth in the By completeness period (3) 2006/2008 f (1) By creating new square d Stop meters of sales floor area (1) By completeness By completeness Decision-maker micro business plan 10
Start Start a a – AI1 : Sell verb 40% more quantity childcare products object in French b (1) (1) By proposing promotions By proposing promotions hypermarkets location during the Christmas period time . (2) By reducing prices c – AI2 : Reduce verb products returns object in hypermarkets location after the (3) Attract more Attract more By mastering costs promotion periods time . customers customers – AI3 : Reduce verb products returns object from market segment 4 source to c stores destination on after the promotion periods time . Action Plan ? – AI4 : Sell verb 20.000 items quantity of product SKU D-042-0000073465-3 –Define effective action intention plan object in convenience stores location on weekend days time with promotional –Define action intention plan according to: conditions means . –Verb <Target> [<Parameter>]* – AI5 : Push verb the gross sales result of baby wipes object with promotions on <wipe+diaper> packages means . – AI6 : Propose verb special sales result to families beneficiary . Action intention Plan 11
- Design Phase - Design DW Fragment Model Input: - Reusable DM model fragments Output: - DW model fragment (DwMf) Map Rules Date Dimension Date Dimension Date Dim Date Dim ension ension Date Key Date Key Date Date Store Dimension Store Dimension D D ate Key ate Key Date of week Date of week Sub activities: Store Key Store Key Month Month Store Number Store Number D D ate ate Sales Facts Sales Facts Year Year Store Dim Store Dim ension ension Name Name Date Key Date Key Address Address D D ate of w ate of w eek eek Product Key Product Key Product Dimension Product Dimension * Rules City City Store Key Store Key Store Key Store Key State State Product Key Product Key Gross sales in Euro Gross sales in Euro M M onth onth Zip Zip Product Attributes Product Attributes SKU Number SKU Number Store Num Store Num ber ber District District Sales Facts Sales Facts Brand Description Brand Description Y Y ear ear Region Region Category Description Category Description N N am am e e Date Dimension Date Dimension - Extract modeling indications D D ate Key ate Key Date Key Date Key Date Date A A ddress ddress Store Dimension Store Dimension Date of week Date of week Product Key Product Key Store Key Store Key Product D Product D im im ension ension Month Month Store Number Store Number Sales Facts Sales Facts C C ity ity Year Year Name Name Date Key Date Key Store Key Store Key Address Address Product Key Product Key Product Key Product Key Product Dimension Product Dimension State State City City Store Key Store Key Product Key Product Key G G ross sales in Euro ross sales in Euro State State Product A Product A ttributes ttributes Gross sales in Euro Gross sales in Euro Product Attributes Product Attributes Zip Zip Zip Zip District District SKU Number SKU Number H MAP2* SKU Num SKU Num ber ber Region Region Brand Description Brand Description Category Description Category Description - Select reusable DM D D istrict istrict Brand D Brand D escription escription R R egion egion Date Dimension Date Dimension Category Description Category Description Date Key Date Key Store Dimension Store Dimension Date Date Store Key Store Key Date of week Date of week Month Month Store Number Store Number Sales Facts Sales Facts Name Name Year Year Date Key Date Key Address Address Product Key Product Key Product Dimension Product Dimension City City Store Key Store Key State State Product Key Product Key - Propose DwMf Gross sales in Euro Gross sales in Euro Product Attributes Product Attributes Zip Zip District District SKU Number SKU Number Brand Description Brand Description Region Region Category Description Category Description - Adapt DM DW Fragment according to high level requirements Design DW Fragment model guidelines 12
Recommend
More recommend
