Constructing Data Warehouses With Metadata-Driven Generic Operators, and More

This book takes two effectiveness challenges in the Data Warehousing field in focus. The first and the primary one is a practical challenge. With the approach introduced in this book, Data Warehouse construction should become substantially cheaper, faster, and safer than it is today. The key for this effectiveness is the striking compactness of the approach. The second and the secondary one is a conceptual challenge. With the concise discussions around several fundamental concepts, thinking and discussing in this field should become more effective than it is nowadays. This book covers all major areas of Data Warehouse construction. It is introduced by a Data Warehouse definition and its context, four classifications, five categories of fifteen requirements, and a review of two methodologies and three constructional approaches. Along a sophisticated reference architecture, plenty of design issues, twenty-one design recommendations, eight practice recommendations, seven design principles, twenty-seven generic algorithms and techniques, twelve metadata-driven generic operators, seven working procedures, four paradigmatic foundations, and the paradigm principle itself are presented systematically. There are thirty-five easy-to-do constructional exercises included in the book. If you have completed them during the reading, you have laid the fundament of a sophisticated Data Warehouse before you close the book. Last but not least, the approach has already been realized in the real business world and verified with excellent results.