Data Preprocessing

Anmerkungen:

• Reduce representation of data set.
• Dimension Reduction Numerosity Reduction

Anmerkungen:

• Normalization,data discretization and concept hierarchy generation are forms of Data Transformation.

Anmerkungen:

• Integrating multiple databases,data cubes or files.

Anmerkungen:

• There are many possible reasons for inaccurate data. For example,the age of a person must be enter within 100.

Anmerkungen:

• Believability reflects how much the data are trusted by users.

Anmerkungen:

• Interpretability reflects how easy the data are understood to users.

Anmerkungen:

• To Clean the data by filling in missing values,smoothing noisy data,identifying or removing outliers, and resolving inconsistencies.
• 1. Missing Values. 2. Noisy Data. 3. Data Cleaning as a Process.

1. Missing Values

   Anmerkungen:

   • 1. Ignore the tuple.
   • 2. Fill in the missing value manually.
   • 3. Use a global constant to fill in the missing value.
   • 5. Use the attribute mean or median for all samples belonging to the same class as the given tuple.
   • 6. Use the most probable value to fill in the missing value.
2. Noisy Data

   Anmerkungen:

   • 1. Binning  -> Smoothing by bin means.-> Smoothing by bin medians.-> Smoothing by bin boundaries.
   • 2. Regression -> Linear Regression
3. Data Cleaning as a Process

   Anmerkungen:

   • Rules Used: -> Unique Rule. -> Consecutive Rule. -> Null Rule.
   • Tools Used: -> Data Subscribing Tools. -> Data Auditing Tools. -> Data Migration Tools.

Anmerkungen:

• To integrate multiple databases,data cubes, or files.

1. Redundancy and Correlation Analysis

   Anmerkungen:

   • Redundancy can be detected by Correlation Analysis.
   • 1. Correlation Test for Nominal Data. 2. Correlation Coefficient for Numeric Data. 3. Covariance of Numeric Data.
2. Entity Identification Problem
3. Tuple Duplication

   Anmerkungen:

   • Duplication should also be detected at tuple level.
4. Data Value Conflict Detection and Resolution

   Anmerkungen:

   • Data Integration also involves the detection and resolution of  Data Value Conflicts.

Anmerkungen:

• Normalization, data discretization, and concept hierarchy generation are forms of Data Transformation.

1. Data Transformation Strategies

   Anmerkungen:

   • 1. Smoothing. 2. Attribute Construction. 3. Aggregation. 4. Normalization. 5. Discretization. 6. Concept Hierarchy Generation for nominal data.
2. Data Transformation by Normalization

   Anmerkungen:

   • -> Min-Max Normalization. -> Z- Score Normalization. -> Decimal Scaling.
3. Discretization by Binning

   Anmerkungen:

   • Binning is a top-down splitting technique based on a specified number of bins.
4. Discretization by Histograms

   Anmerkungen:

   • Histogram analysis is an unsupervised discretization technique because it does not use class information.
5. Discretization by Cluster,Decision Tree and Correlation Analyses
6. Concept Hierarchy Generation for Nominal Data

   Anmerkungen:

   • 1. Specification of a partial ordering of attributes explicitly at the schema level by users or experts.
   • 2. Specification of a portion of a hierarchy by explicit data grouping.
   • 3. Specification of set of attributes,but not of their partial ordering.
   • 4. Specification of only a partial set of attributes.

Anmerkungen:

• To obtain the reduced representation of the data set.

1. Data Reduction Strategies

   Anmerkungen:

   • Dimensionality Reduction. Numerosity Reduction.
   • Data Compression. -> Lossless. -> Lossy.
2. Wavelet Transforms

   Anmerkungen:

   • Discrete Wavelet Transform.
3. Principal Components Analysis

   Anmerkungen:

   • Also called Karhunen - Loeve method.
4. Attribute Subset Selection

   Anmerkungen:

   • Reduces the data set size by removing irrelevant or redundant attributes.
   • -> Step Forward Selection. -> Step Backward Elimination. -> Combination of both. -> Decision Tree Induction.
5. Regression and Log - Linear Models

   Anmerkungen:

   • Linear Regression. Multiple Linear Regression. Log-Linear models.
6. Histograms

   Anmerkungen:

   • Use binning to approximate data distributions and are a popular form of data reduction.
   • -> Equal Width. -> Equal Frequency.
7. Clustering

   Anmerkungen:

   • Clustering consider data tuples as objects. Centroid distance is an alternative measure of cluster quality.
8. Sampling

   Anmerkungen:

   • Sampling can be used as a data reduction technique because it allows a large data set to be represented by a much smaller random data sample.