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

Chapter 6

DATA KEYS

Data keys ensure uniqueness and provide navigation.

Data resource design continues with the development of proper data structures. The description of proper data structures begins with a description of the proper designation and use of data keys. Data keys are a critical topic in data resource design and deserves a separate chapter. The proper designation and use of data keys helps achieve data resource reality.

Chapter 6 describes the concept of data keys, primary keys, foreign keys, secondary keys, and data integration keys. Numerous examples are provided for the proper designation of data keys. The next four chapters describe data relations, data normalization, data denormalization, and time and change, all of which ...

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