Cover Image

Foundations of data quality management /

Bibliographic Details
Main Author: Fan, Wenfei
Other Authors: Geerts, Floris
Format: eBook
Language:English
Published: San Rafael, Calif. (1537 Fourth Street, San Rafael, CA 94901 USA) : Morgan & Claypool, [2012]
Series:Synthesis lectures on data management ; #30.
Subjects:
Databases > Quality control.
Database management.
COMPUTERS / Programming Languages / SQL.
data quality
data consistency
data deduplication
data accuracy
information completeness
data currency
data dependencies
dependency discovery
rule validation
error detection
data repairing
master data
certain fixes
Electronic books.
Online Access:Connect to the full text of this electronic book
Connect to the full text of this electronic book
Table of Contents:
  • 1. Data quality: an overview
  • 1.1 Data quality management
  • 1.2 Central issues of data quality
  • 1.2.1 Data consistency
  • 1.2.2 Data deduplication
  • 1.2.3 Data accuracy
  • 1.2.4 Information completeness
  • 1.2.5 Data currency
  • 1.2.6 Interactions between data quality issues
  • 1.3 Improving data quality using rules
  • 1.4 Background
  • Bibliographic notes
  • 2. Conditional dependencies
  • 2.1 Conditional dependencies
  • 2.1.1 Conditional functional dependencies
  • 2.1.2 Conditional inclusion dependencies
  • 2.2 Static analyses of conditional dependencies
  • 2.2.1 Satisfiability
  • 2.2.2 Implication
  • 2.2.3 Finite axiomatizability
  • 2.2.4 Dependency propagation
  • Bibliographic notes
  • 3. Cleaning data with conditional dependencies
  • 3.1 Discovering conditional dependencies
  • 3.1.1 The CFD discovery problem
  • 3.1.2 Discovering constant CFDs
  • 3.1.3 Discovering general CFDs
  • 3.2 Error detection
  • 3.2.1 Checking a single CFD with SQL
  • 3.2.2 Validating multiple CFDs
  • 3.3 Data repairing
  • 3.3.1 The data repairing problem
  • 3.3.2 Repairing violations of CFDs and CINDs
  • Bibliographic notes
  • 4. Data deduplication
  • 4.1 Data deduplication: an overview
  • 4.2 Matching dependencies
  • 4.3 Reasoning about matching dependencies
  • 4.4 Relative keys for record matching
  • 4.5 Matching dependencies for data repairing
  • Bibliographic notes
  • 5. Information completeness
  • 5.1 Relative information completeness
  • 5.1.1 Partially closed databases
  • 5.1.2 A model for relative information completeness
  • 5.1.3 Relative completeness and data consistency
  • 5.2 Determining relative completeness
  • 5.3 Representation systems for possible worlds
  • 5.4 Capturing missing tuples and missing values
  • 5.5 The complexity of fundamental problems
  • Bibliographic notes
  • 6. Data currency
  • 6.1 Data currency: an overview
  • 6.2 A data currency model
  • 6.3 Reasoning about data currency
  • 6.4 Incorporating copy functions
  • 6.4.1 The data currency model revisited
  • 6.4.2 Currency preserving copy functions
  • 6.5 Determining currency preservation
  • Bibliographic notes
  • 7. Interactions between data quality issues
  • 7.1 Finding certain fixes
  • 7.1.1 Certain fixes: an introduction
  • 7.1.2 Editing rules
  • 7.1.3 Certain fixes and certain regions
  • 7.1.4 A framework for finding certain fixes
  • 7.1.5 Fundamental problems for certain fixes
  • 7.2 Unifying data repairing and record matching
  • 7.2.1 Interaction of CFDs and MDs: an introduction
  • 7.2.2 The data cleaning problem and cleaning rules
  • 7.2.3 A framework for data cleaning
  • 7.2.4 Static analyses of data cleaning with CFDs and MDs
  • 7.3 Resolving conflicts
  • 7.3.1 Conflict resolution: an overview
  • 7.3.2 A model for conflict resolution
  • 7.3.3 A framework for conflict resolution
  • 7.3.4 Fundamental problems for conflict resolution
  • 7.4 Putting things together
  • Bibliographic notes
  • List of symbols
  • Bibliography
  • Authors' biographies.