O'Reilly logo

Designing a Data Warehouse: Supporting Customer Relationship Management by Chris Todman

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 A. Wine Club Temporal Classifications

This appendix contains a more complete list of the all the components of the Wine Club and the values for retrospection that have been assigned. Each component is classified by its type, which will be one of the following:

  1. Behavior

  2. Circumstances

  3. Dimension

  4. Relationship

The reason contains the business rationale for the choice as to whether the component has been assigned true, false or permanent retrospection.

Component Name Type Retrospection Reason
Color Dim Permanent The colors are assumed to exist forever.
Time Dim Permanent The days, once entered, will exist forever. Each year, a new “years-worth” of dates will be added but their existence, thereafter, is permanent.
Hobby Circ Permanent The hobby ...

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