Chapter 8. Implementing the Physical Aspects of the Database
In this chapter we look at how to implement the database. The design of the database creates many artifacts, but they have to be deployed to a database environment and that takes many decisions of a physical nature. We continue with the modeling process and also get down to the database code, or Structured Query Language (SQL), that needs to be generated to create the database. The modeling aspects of the implementation will focus around the storage of the data. The database designers will look at:
Database size
Where the database will reside
Hardware
Software
Partitioning of the data
Properties specific to the DBMS chosen
How the application will communicate with the database
Get UML for Database Design now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
