Modelo hotel

Data Modeling by Example – a Tutorial
Elephants, Crocodiles and Data Warehouses

Barry Williams

Page 1

09/06/2012 02:39

Data Modeling by Example – a Tutorial
Elephants, Crocodiles and Data Warehouses

1. Management Summary ..................................................................2 2. The Theory...................................................................................5 3. The Practice ............................................................................... 18 4. The BI Layer .............................................................................. 24 5. What have we Learned ? .............................................................. 28 6. Here’s your Chance ..................................................................... 29 Appendix A : Events 1 to 9 .............................................................. 34 Appendix B : Data Model Review ..................................................... 81 Appendix C : Slideshow ................................................................... 87 Appendix D : Glossary of Terms........................................................ 88

1. Management Summary
1.1 A trip to Malaysia In this Paper we use a trip to Malaysia to discuss an approach to the implementation of a Reference Data Architecture and the design of a Data Warehouse. A Canonical Data Model (CDM) is central to this and we discuss the benefits of using Design Patterns based on a CDM. During the trip, my wife and I stayed in three Hotels, hired a car and visited a number of Tourist Attractions, including an Elephant Sanctuary, a Crocodile Farm and an Underwater World in Langkawi Island in Malaysia. After we returned to England I found myself thinking that the trip would provide a good opportunity to develop an interesting and ‘User-Friendly’ Tutorial on Data Warehouses. The design of the Data Models reflects the scope and the fact that the overall aim is to provide data for Business Intelligence. We