14.7. Denormalization and Low Level Optimization
Applying the conceptual optimization procedure followed by the Rmap procedure ensures a redundancy-free relational schema that should be reasonably efficient. To test the performance of this logical schema, it should be implemented as an internal schema on the target DBMS, using a realistic population. At this stage, indexes should normally be created for all primary and foreign keys, as well as any other columns that play a significant role in focused queries.
For large tables, indexes can dramatically improve performance since they can normally be loaded, in part or whole, into main memory and their entries are sorted into structures that permit fast retrieval (e.g., binary trees). At times, ...
Get Information Modeling and Relational Databases, 2nd Edition 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.
