CDDQ Open Data Quality Repository

Overview:

The Open Conformed Dimensions of Data Quality Repository is a complete ANSI SQL data model based on the CDDQ standard which enables organizations to store data quality rules categorized by the CDDQ dimensions and underlying concepts. It comes with CC-BY licensed dimensions, underlying concepts, data quality rules and data quality metric examples that speed up your organization's DQ implementations, facilitate standardization of DQ measurement in the industry and provide a baseline for data quality education at colleges and universities across the globe.

Register to Download Data Model

What's Included:

SchemaTablesCodeData
DQ Repository

 9 Tables:

  • CDDQ Underlying Concepts (1)
  • Rules Related (3)
  • Visualization Related (4)
  • Other (1)
ANSI SQL DDL for creating all tables

ANSI SQL DML for inserting sample CDDQ rules and metrics

Organizations expected to add proprietary DQ rules and metrics in their own implementations

ABC Company Demo Data

 7 Tables (likely to change):

  • Sample transactional data (3)
  • Sample reference data (4)
ANSI SQL DDL for creating all tablesANSI SQL DML for inserting sample organizational data for ABC company that operations both B-to-B and B-to-C sales of products (either physical items or intangible services)

 

Project File Names:

  1. Truncate ABC Company Tables.sql
  2. CDDQ Warehouse\ABC Company DDL.sql
  3. CDDQ Warehouse\ABC Company DML.sql
  4. ABC Company SQL query of invoices and line items.sql
  5. CDDQ Warehouse\ABC Company.xlsx
  6. ABC_INVOICE and ABC_LINE_ITEM.xlsx
  7. DQ Model.xlsx

Register to Download Data Model