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

ANSI SQL Entities Included:

  • DDL for creating tables
  • DML for loading tables
SchemaTablesDescription
DQ Repository

 9 Table Types:

  • CDDQ Underlying Concepts (1)
  • Rules Related (4)
  • Visualization Related (3)
  • DQ History (1)

DDL and DML Build and Load Files:

  1. DQ Model DDL to Create table structures.sql
  2. FUTURE: DQ Model DML to load with ABC Data related DQ Rules and sample results.

Data:

Sample data corresponding to the ABC fictitious company using CDDQ rules and metrics.

Organizations are expected to add their own DQ rules and metrics in their own implementations leveraging the examples for all 37 Underlying Concepts of the CDDQ.

Documentation: DQ Model.xlsx

  • All Tables (9 tabs)
  • Technical metadata (1 tab)
ABC Company Demo Data

 9 Table Types:

  • Sample transactional data (3)
  • Sample reference data (4)
  • Sample master data (1)
  • Sample external data file loaded into stage table (1)

DDL and DML Build and Load Files:

  1. DML- Data Insert- ABC Company.sql
  2. DML- Delete Table Contents- Truncate ABC Company Tables.sql
  3. DDL Structure Creation- ABC Company.sql

Data:

ANSI 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)

Documentation: ABC Company.xlsx (12 tabs)

  • All Data Tables (9 tabs)
  • Technical metadata (1 tab)
  • Known data errors for teaching and illustrations in Open DQ Repository Model
    1. Errors in ABC Tables
    2. Errors in POS file/table (external file)
Open DQ Repository Data Model

 

What do you get when you register?

Registered users have access to the Miro Board where all changes to the data models are stored as Entity Relationship Diagrams.

  1. Summary DQ Repository data model (only includes the tables names and keys with relationships as shown above)
  2. Detailed DQ Repository data model (includes list of all columns in each table, the keys with relationships and sample data for each table)
  3. Detailed ABC Company data model (includes list of all columns in each table, the keys with relationships for each table)
  4. Access to Box.com folder with all ANSI SQL DDL and DML buid and load files needed for both schemas (see list of scripts in the table above)

Register to Download Data Model

 

Would you like a hands-on 1-3 day course on how to use the Conformed Dimensions and implement the new Open Data Quality Repository? Bring DQMatters onsite for custom training like the DQ Jumpstart and more. Contact us at sales@dqmatters.com.