Download
data warehouse n.
Skip this Video
Loading SlideShow in 5 Seconds..
Data Warehouse PowerPoint Presentation
Download Presentation
Data Warehouse

Data Warehouse

121 Vues Download Presentation
Télécharger la présentation

Data Warehouse

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Data Warehouse Additional Notes

  2. Transient vs Periodic Data Exercise – Sales Data on 28/11/2013

  3. Transactions • On 29/11/2013- These transactions were executed • Item 002 changed it sales number to 47 • Item 004 was deleted • On 30/11/2013 - These transactions were executed • Item 001 increased sales to 69 • Item 005 was added – Item name: Chips, quantity sold: 57

  4. Produce the transient table for 29/11/2013 Final transient table for 29/11/2013 • On 29/11/2013- These transactions were executed • Item 002 changed it sales number to 47 • Item 004 was deleted

  5. Produce the periodic table for 29/11/2013 • On 29/11/2013- These transactions were executed • Item 002 changed it sales number to 47 • Item 004 was deleted C = Create/Copied D= Deleted U = Updated

  6. Produce the transient table for 30/11/2013 • On 30/11/2013 - These transactions were executed • Item 001 increased sales to 69 • Item 005 was added – Item name: Chips, quantity sold: 57

  7. Produce the periodic table for 30/11/2013 • On 30/11/2013 - These transactions were executed • Item 001 increased sales to 69 • Item 005 was added – Item name: Chips, quantity sold: 57

  8. Consider this scenario and come out with a star schema • ABC Shoes Store would like to have statistics on their shoes over certain period of time according to shoes quantity_sold, units_sold and color_sold. • These are the related tables involved: • Product: Product_Code, Description, Color, Size • Period: Period_Code, Year, Quarter, MOnth, Day • Store: Store_Code, Store_Name, City, Telephone, Manager • Produce a fact table for this star schema. • Hint: Fact table must consist of Primary Key and if exist – the foreign key. Next the fact table must also include all the analysis/statistics/information that the company would like to process

  9. ABC Technologies would like to have statistics on their shoes over certain period of time according to shoes quantity_sold, units_sold and color_sold Statistics Product_Code Store_Code Period_Code Quantity_sold Unit_sold Color_sold