Try OpenEdge Now
skip to main content
Guide for New Developers
Configuring OpenEdge : Understanding the RDBMS architecture : Physical Database
 

Physical Database

A physical database is a refinement of the logical database design. In this phase, you examine how the user will access the database, and refine the database design by answering questions like:
*What data will I commonly use?
*Which columns in the table should I index based on data access?
*Where should I build in flexibility and allow for growth?
*Should I denormalize the database to improve performance? A database is typically denormalized at this stage to meet performance requirements.