Physical data modeling
Once we have the logical data models, we are ready to create physical data models. This is the stage where you convert the logical data models into a database design for a specific RDBMS (short for Rational Database Management System), such as MySQL or PostgreSQL, or a NoSQL database, such as MongoDB. An important consideration during physical data modeling is performance. Most of the database systems support tools such as indexing, clustering, partitioning, and data compression to archive performance improvement without compromising the logical data model design. We will also discuss indexing in this book. But we will not discuss clustering, portioning, or data compression. They are beyond the scope of this book. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access