O'Reilly logo

Data Resource Design by Michael Brackett

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix C

FIVE-TIER FIVE-SCHEMA CONCEPT

The Five-Tier Five-Schema Concept evolved over several years. That evolution and the meaning of the schema in the Five-Tier Five-Schema Concept are described below. The discussion is not a complete text on data resource design and modeling, nor a complete text on data normalization and data denormalization. However, it is an all-inclusive overview of the development of the Five-Tier Five-Schema Concept and its inclusion within the Common Data Architecture.

The Five-Schema Concept

A schema is simply a data structure. When databases first became prominent, two schemas were identified—the internal schema and the external schema, as shown in Figure C.1. The internal schema was the structure of the data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required