Chapter 8. Implementing the Physical Aspects of the Database

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