Data Warehousing Special (12)-Data classification model

First, the data classification model

II. Definition of data classification

2. Metadata (metadata, Reference dataMaster dataEnterprise Structure Data,Transaction Activity data)
4. Reference Data ( ),
6. Master Data ( ),
8. Enterprise Structure data ( )
10. Trading activity data ( )
12. Transaction Audit Data ( Transaction Audit Data )

Metadata: Data, usually when we design a table, most attribute fields are metadata. For example, gender, nationality, birth province, etc. This is the closest data to the natural sense.

Reference data: The range of possible values for metadata, and the data dictionary we refer to when designing a table is often the reference data. For example, gender can only be male and female, male and female is quoted data. The country's citation data is the world's 100 multiple countries and regions;

Master data: Some of the most important entities in our database design are collections of metadata and reference data instances. dmreview columnist Jane Griffin ... ' record system ' Information required to record business transactions and to assess the performance of these entities. "

Enterprise Structured data: The data entities required in the enterprise business , which may be a collection of multiple master data. Structured data from different industries can vary greatly.

Trading activity data: data generated by activity between master data. For example, the customer buys the product transaction record is the transaction activity data, the factory produces the product, the production record is also the transaction activity data.

Transaction Audit Data: All our activities on the data are recorded through the transaction audit data. For example, we operate on customer information modifications, additions and deletions to transactions, which are required to be documented in many key systems (such as banks) in order to be compliant with the corresponding regulatory requirements (e.g. Basel II, Sarbanes-Oxley Act).

Data Warehousing Special (12)-Data classification model