≡ Menu

Database Modeling and Design, Fifth Edition: Logical Design

Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs.

Data Modeling Made Simple

Data Modeling Made Simple will provide the business or IT professional with a practical working knowledge of data modeling concepts and best practices. This book is written in a conversational style that encourages you to read it from start to finish and master these ten objectives.Know when a data model is needed and which type of data model is most effective for each situation Read a data model of any size and complexity with the same confidence as reading a book.

Learn dimensional modeling basics to advanced.

Data Modeling by far the most important task of Business Intelligence/Data Warehousing projects based on approach. You can either follow Kimball approach or Inmonn approach. As per Kimball, dimensional data model are best suited for data warehousing due to amount of data, simplicity and ease and performance of the SQL queries on dimensional schema.

Dimensional data modeling requires modelers to know the business process, how business works, data needs etc. However technical aspect of data modeling requires modeler to know the best practices of data modeling, process, ways to handle various business scenarios in data model. Without the correct data model future requirement of data from data warehouse may not fulfilled.