14 Schema Transformations

Abstract

This chapter discusses the following topics: conceptual schema equivalence and optimization; predicate specialization and generalization; nesting, coreference and flattening; schema transformations; normalization; denormalization and low-level optimization; reengineering; data migration; query transformation.

Keywords

Conceptual schema equivalence; Schema optimization; Specialization; Generalization; Schema transformation; Normalization; Denormalization; Reengineering; Data migration; Query transformation

Get Information Modeling and Relational Databases, 3rd 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.