mô hình dữ liệu từng bước, và thảo luận các vấn đề triển khai và vấn đề Bạn có thể gặp Cùng bạn cách để tạo một môi trường kinh doanh thông minh bền vững và duy trì. Đến cuối cuốn sách, bạn nên Be đủ điều kiện để bắt đầu Xây dựng môi trường BI của bạn Vũ trang với thiết kế tốt nhất có thể cho kho dữ liệu kỹ thuật của bạn. | Introduction 27 data model step by step and discuss deployment issues and problems you may encounter along the way to creating a sustainable and maintainable business intelligence environment. By the end of the book you should be fully qualified to begin constructing your BI environment armed with the best design techniques possible for your data warehouse. CHAPTER . . 2 Fundamental Relational Concepts Every data-modeling technique has its own set of terms definitions and techniques. This vernacular permits us to understand complex and difficult concepts and to use them to design complex databases. This book applies relational data-modeling techniques for developing the data warehouse data model. To that end this chapter introduces the terms and terminology of relational data modeling. It then continues with an overview of normalization techniques and the rules for the different normalization levels for example first second and third normal form and the purpose for each. Sample data models will be given showing the progression of normalization. The chapter ends with a discussion of normalization of the data model and the associated benefits. Before we get into the various types of data models we use in creating a data warehouse it is necessary to first understand why a data model is important and the various types of data models you will create in developing your BI environment. Why Do You Need a Data Model A model is an abstraction or representation of a subject that looks or behaves like all or part of the original. Examples include a concept car and a model of a .
