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

METADATA TOOLS

At the last count, there are three basic kinds of metadata:

Business semantic metadata. This is the kind of metadata that describes, in precise business terms, what each element of data actually means. Recall the discussion “What is a sale?” The business semantic metadata will define a sale as being, for instance:

The quantity and total order value of an order for a single product by a customer, before discount

The description should leave no room for ambiguity. It must be possible to define every entity, relationship, and attribute in the system.

Transformational metadata. This describes all the properties of the data element and includes:

  • Source system from which the element was extracted

  • Frequency of extraction

  • Changes that have ...

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