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 ...
Get Designing a Data Warehouse: Supporting Customer Relationship Management 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.
