CDDP key terms
CDDP · Get comfortable with the vocabulary.
- Data Governance
- Related: Data Stewardship, Data Lineage, Data Ethics
The system of decision rights and accountabilities over data assets, defining who may take which actions, under what rules, and how compliance is monitored across the organization.
- Data Stewardship
- Related: Data Governance, Data Owner, Data Quality Dimensions
The operational practice of assigning named individuals to care for specific data domains, resolving quality issues, approving definitions, and enforcing governance policies day to day.
- Data Owner
- Related: Data Stewardship, Data Classification, Role-Based Access Control
An accountable role with authority to approve access, classify sensitivity, and accept risk for a defined data domain or asset, usually at a senior management level.
- Data Ethics
- Related: Data Governance, Data Privacy, Data Bias
The principles guiding fair, transparent, and responsible use of data, including consent, harm avoidance, bias mitigation, and accountability for algorithmic decisions affecting people.
- Data Bias
- Related: Data Ethics, Data Quality Dimensions, Data Profiling
Systematic error or unfair skew in collected data or model outputs that disadvantages groups, often arising from sampling, historical inequity, labeling choices, or proxy variables.
- Data Classification
- Related: Data Owner, Data Privacy, Data Retention Policy
The process of assigning data to sensitivity tiers such as public, internal, confidential, or restricted, so that handling, access, and retention controls match the risk involved.
- Data Retention Policy
- Related: Data Classification, Data Privacy, Data Lifecycle Management
Documented rules specifying how long each data category is kept, where it resides, and how it is destroyed, balancing legal obligations, business needs, and privacy minimization.
- Data Lifecycle Management
- Related: Data Retention Policy, Data Lineage, Data Governance
The coordinated set of practices covering creation, storage, use, sharing, archiving, and deletion of data, ensuring each stage has defined controls and ownership.
- Conceptual Data Model
- Related: Logical Data Model, Physical Data Model, Entity-Relationship Diagram
A technology-independent diagram of major business entities and their relationships, used to agree on scope and meaning before physical design begins.
- Logical Data Model
- Related: Conceptual Data Model, Physical Data Model, Normalization
A refined model specifying entities, attributes, keys, and relationships without committing to a particular database product, bridging business concepts and physical implementation.
- Physical Data Model
- Related: Logical Data Model, Normalization, Star Schema
The implementation-level design of tables, columns, indexes, partitions, and constraints tuned for a specific database engine and workload.
- Normalization
- Related: Denormalization, Logical Data Model, Entity-Relationship Diagram
Structuring relational tables to reduce redundancy and update anomalies by organizing attributes into progressively stricter normal forms based on functional dependencies.
- Denormalization
- Related: Normalization, Star Schema, Data Warehouse
Deliberately introducing redundancy or precomputed values into a schema to speed reads and simplify queries, accepting extra storage and update complexity.
- Star Schema
- Related: Snowflake Schema, Data Warehouse, Denormalization
A dimensional model with a central fact table of measures linked to surrounding dimension tables, optimized for analytical queries and business-friendly navigation.
- Snowflake Schema
- Related: Star Schema, Normalization, Data Warehouse
A dimensional model in which dimension tables are normalized into related sub-dimensions, reducing redundancy at the cost of more joins in analytical queries.
- Entity-Relationship Diagram
- Related: Conceptual Data Model, Logical Data Model, Normalization
A visual notation showing entities, their attributes, and the cardinality of relationships between them, commonly used to communicate data model designs.
- ETL
- Related: ELT, Data Pipeline, Data Integration
Extract, transform, load: a pipeline pattern that pulls data from sources, applies cleansing and business rules, then writes results into a target store.
- ELT
- Related: ETL, Data Lakehouse, Data Pipeline
Extract, load, transform: a pattern that loads raw data into a target platform first and performs transformations there, leveraging scalable warehouse or lakehouse compute.
- Data Pipeline
- Related: ETL, Data Integration, Data Lineage
An automated sequence of steps that moves and transforms data between systems, including scheduling, error handling, monitoring, and dependency management.
- Data Integration
- Related: ETL, Data Virtualization, Master Data Management
Combining data from multiple sources into a consistent view, using patterns such as consolidation, federation, or propagation to serve analytical and operational needs.
- Data Virtualization
- Related: Data Integration, Data Federation, Data Lakehouse
A technique that presents a unified query layer over disparate sources without physically copying the data, trading some performance for freshness and reduced duplication.
- Data Lakehouse
- Related: Data Lake, Data Warehouse, ELT
An architecture combining cheap object storage and open table formats with warehouse-style transactions, schema enforcement, and governance to support both analytics and machine learning.
- Data Warehouse
- Related: Data Mart, Star Schema, Data Lakehouse
A centralized repository optimized for analytical querying, holding integrated, time-variant, subject-oriented data loaded from operational systems through controlled pipelines.
- Data Mart
- Related: Data Warehouse, Star Schema, Data Lakehouse
A subset of a warehouse scoped to one business area or team, providing focused, pre-shaped data for reporting with simpler access controls.
- Data Lake
- Related: Data Lakehouse, Data Warehouse, Data Swamp
A large store holding raw and refined data in native formats on cheap storage, typically schema-on-read, serving diverse analytical and machine-learning workloads.
- Data Quality Dimensions
- Related: Data Profiling, Data Cleansing, Data Stewardship
Measurable characteristics used to assess fitness for use, commonly accuracy, completeness, consistency, timeliness, uniqueness, and validity.
- Data Profiling
- Related: Data Quality Dimensions, Data Cleansing, Data Lineage
Statistical examination of datasets to reveal structure, value distributions, null rates, key candidates, and anomalies, forming a baseline for quality rules and modeling decisions.
- Data Cleansing
- Related: Data Quality Dimensions, Data Profiling, Master Data Management
Correcting or standardizing invalid, duplicate, incomplete, or malformed records so that data meets agreed quality rules before use in analysis or operations.
- Master Data Management
- Related: Reference Data, Data Cleansing, Data Integration
The discipline and tooling for creating authoritative, shared records of core entities such as customers, products, and suppliers, and synchronizing them across systems.
- Reference Data
- Related: Master Data Management, Data Cleansing, Data Classification
Controlled code sets and lookup values, such as country codes or currency lists, that classify and constrain other data and must be consistent enterprise-wide.
- Data Lineage
- Related: Data Pipeline, Data Governance, Data Profiling
A recorded trace of where data came from, how it was transformed, and where it flows, supporting impact analysis, debugging, audit, and regulatory evidence.
- Descriptive Statistics
- Related: Inferential Statistics, Data Visualization, Correlation
Summary measures that characterize a dataset, including central tendency, dispersion, frequency, and shape, used to understand distributions before deeper analysis.
- Inferential Statistics
- Related: Descriptive Statistics, Statistical Significance, Sampling Bias
Methods that use sample data to draw conclusions about a wider population, including confidence intervals, hypothesis tests, and estimates of uncertainty.
- Statistical Significance
- Related: Inferential Statistics, Correlation, Sampling Bias
A result unlikely to have occurred by chance under a stated null hypothesis, conventionally judged against a chosen probability threshold such as 0.05.
- Correlation
- Related: Descriptive Statistics, Statistical Significance, Data Visualization
A measure of the strength and direction of association between two variables, ranging from minus one to one, which does not by itself establish causation.
- Sampling Bias
- Related: Inferential Statistics, Data Bias, Statistical Significance
Distortion arising when the selected sample is not representative of the target population, causing estimates and conclusions to systematically misstate reality.
- Data Visualization
- Related: Dashboard Design, Descriptive Statistics, Data Storytelling
Encoding quantitative and categorical information into visual forms such as charts and maps so patterns, comparisons, and outliers can be perceived quickly and accurately.
- Dashboard Design
- Related: Data Visualization, Data Storytelling, KPI
The practice of arranging metrics, filters, and supporting visuals on a single screen so a defined audience can monitor performance and act without extraneous clutter.
- KPI
- Related: Dashboard Design, Data Storytelling, Data Quality Dimensions
A key performance indicator: a small set of measures tied to strategic objectives, with agreed definitions, targets, and owners used to judge progress.
- Data Storytelling
- Related: Data Visualization, Dashboard Design, KPI
Combining visuals, narrative, and context to guide an audience from evidence to a recommended decision, emphasizing clarity of message over decorative presentation.
- Data Privacy
- Related: Data Classification, Data Masking, Data Ethics
Protecting personal information through lawful collection, purpose limitation, consent, minimization, and honoring individual rights such as access and erasure.
- Data Masking
- Related: Data Privacy, Tokenization, Role-Based Access Control
Replacing sensitive values with realistic substitutes or redactions so non-production users and analysts can work without seeing identifiable or confidential content.
- Tokenization
- Related: Data Masking, Data Privacy, Encryption at Rest
Substituting a sensitive value with a non-sensitive token mapped through a protected vault, reducing exposure while allowing authorized re-identification when required.
- Role-Based Access Control
- Related: Data Masking, Data Owner, Data Classification
Granting permissions according to job roles rather than individuals, simplifying administration and enforcing least privilege across systems and datasets.
- Encryption at Rest
- Related: Tokenization, Data Privacy, Data Classification
Protecting stored data by encoding it with cryptographic keys so that stolen disks, backups, or storage volumes remain unreadable without authorized key access.
- Cloud Data Platform
- Related: Data Lakehouse, Data Warehouse, Data Pipeline
Managed, elastically scalable services for storage, compute, and analytics delivered over the internet, billed by consumption and configured through provider controls.
- Data Fabric
- Related: Data Virtualization, Data Lineage, Data Lakehouse
An architecture using metadata, virtualization, and automated integration to connect distributed data sources into a coherent, governed access layer.
- Data Mesh
- Related: Data Fabric, Data Governance, Data Lakehouse
A socio-technical approach decentralizing analytical data ownership to domain teams who publish governed, discoverable data products against shared platform standards.
- Streaming Data
- Related: Data Pipeline, Cloud Data Platform, Data Integration
Continuously produced event records processed incrementally as they arrive, enabling near-real-time monitoring and reactions rather than periodic batch loads.