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:
| Schema | Tables | Code | Data |
| DQ Repository | 8 Tables:
| 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):
| ANSI SQL DDL for creating all tables | 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) |
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.
- Summary DQ Repository data model (only includes the tables names and keys with relationships as shown above)
- Detailed DQ Repository data model (includes list of all columns in each table, the keys with relationships and sample data for each table)
- Detailed ABC Company data model (includes list of all columns in each table, the keys with relationships for each table)