4State-transition model profiling examines lifecycle of state-dependent objects and provides actual information about the order and characteristics of states and actions. It helps build or validate state-transition models. Introduction to state-transition modeling The objects that go through a sequence of states in the course of their life cycle as a result of various events are

Timeline profiling looks for patterns in historical data (such as temporal distribution of the data, patterns of values for different time periods, etc…). Timeline profiling Profiling techniques discussed thus far provide key input to data mapping and quality assessment decisions. Specifically, we can identify databases, entities, and attributes containing desired data and understand their meaning.

Analyzing profiling results Data profiles provide tremendous volumes of metadata and our success in ensuring data quality is directly proportional to our ability to process and understand this information and make appropriate conclusions. One approach is to manually go through profiles, one at a time, and skip through the basics while focusing on anything unusual

Mining basic statistics Attribute profiling produces large volumes of information. As a minimum it can be used as a source of reference information during data mapping, quality assessment, and cleansing. It can also be used to systematically update data catalogues. However, the main purpose is to gain knowledge of various unexpected data abnormalities. We must

Attribute profiling examines values of individual data attributes and provides information about frequencies and distributions of their values. It helps to identify meaning and allowed values for an attribute. Attribute profiling basics Attribute profiling examines the values of individual data attributes and produces three categories of metadata for each attribute: basic aggregate statistics, frequent values,

Relationship profiling is an exercise in identifying entity keys and relationships as well as counting occurrences for each relationship in the data model. It is necessary to validate existing relational data models or build them when none are available. Definition of relationship profiling Relational data model describes high-level logical data structure using standard concepts, such

Subject profiling examines subjects in different tables or on different systems and helps to find where the information about each subject is stored. Subject profiling by data source Subject profiling examines subjects in different databases and helps to find where the information about each subject is stored. The objective is to understand which sources can


Enjoy this website? Please spread the word :)