Practical Guidelines for Supertype and Subtype Modeling - High-Performance Web Databases: Design, Development, and Deployment - page 331

T

HE LOGICAL DATA MODEL IS TRANSFORMED INTO THE PHYSICAL DATA

,

DESIGN WHICH IS THEN IMPLEMENTED UNDER A SPECIFIC DATABASE TECH-

.

NOLOGY Significant database performance improvements can be gained

by manipulating the physical database design. Application performance
can be optimized using a number of extensions and components, such as
indexes, triggers, and stored procedures against the database. Techniques,
such as transactional analysis, provide an opportunity to denormalize or
modify the physical implementation of a database design. Opportunities to
improve database performance also exist at the application, architecture,
and operations levels. This section contains the following chapters.

Chapter 21, “Physical Database Design,” shows how to use transactional
analysis, anticipated workload, and a relationship schema to construct a
physical database. This chapter also examines methods of fine-tuning the
physical database design to improve application performance.

Chapters 22 and 23 demonstrate how to transform a logical data design
into a physical, distributed database. This includes a discussion of manage-
ment and implementation issues commonly encountered during this
transformation process.

Chapter 24, “Relational Database Design Using Semantic Objects,”
provides an approach for building a physical database design based on
available semantic objects.

Chapter 25, “Component Design for Relational Databases,” describes a
twist on relational-to-object impedance matching, which can also be
referred to as a data-component approach. This involves leveraging the
advantages of having a component take responsibility for updating data,
while providing relevant inquiry functions. This results in improved appli-
cation performance.

Chapter 26, “Designing Relational Databases,” shows how to transform a
data model into a relational database. This chapter provides a method-
ology that examines how to transform every logical construct to a physical
implementation.