Physical Database Design
Once a logical design for the database has been completed, physical database design can begin. This phase is the process of turning a specification and its logical model into an implementation. For example, once we know that we need employee and department entities in our database, we can then choose to implement two tables physically. That sounds easy—of course entities correspond to tables! But there are more to databases than tables. Not all of the database requirements for an application can be captured by data modeling. For example, other types of objects, such as views and indexes, can be instrumental in simplifying access and encouraging efficient execution.
In this section, we'll review tables as well as several ...
Get Building Scalable and High-Performance Java™ Web Applications Using J2EE™ Technology 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.
