All resources
Blog ArticlesUse Cases & ExamplesGuides & ResourcesDashboard TemplatesCase StudiesVideosPodcastWebinarsTestimonialsGlossary

Glossary

0-9

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

NORMALIZE Function
REGEXP_EXTRACT_ALL
REGEXP_INSTR Function
INSTR Function
STRPOS Function
CONTAINS_SUBSTR Function
REVERSE Function
INITCAP Function
REPEAT Function
RPAD Function
LPAD Function
RTRIM Function
LTRIM Function
TRIM Function
Scalability in Data Modeling
Data Integrity
Data Redundancy
Query Performance
Query Complexity
Grain (in Fact Table)
Slowly Changing Dimensions
Outrigger Dimension
Step Dimension
Swappable Dimension
Shrunken Dimension
Fact Constellation Schema
Operational Data Store (ODS)
OLAP Cube
Data Mart Architecture
Data Vault Schema
Data Source Schema
Subject-Oriented Design
Hybrid Data Mart
Independent Data Mart
Dependent Data Mart
Invalid Geometry
ML.RECOMMENDATIONS
SRID Mismatch
ST_DISTANCE
ST_UNION
CTE Query Optimization Techniques
Recursive Iteration Limit
Step-by-Step CTE Debugging
CTE vs Temporary Table
Common Table Expression (CTE)
Nested CTE
ACID Compliance
OLAP in Data Modeling
Multi-CTE Query
Recursive CTE
Data Modeling Best Practices
Logical to Physical Model Transformation
Data Mart (in OWOX Reports)
Data Modeling Stages
REGEXP_REPLACE Function
Static Schema in Views
Read-Only Views
Feature Preprocessing
Clustering in Views
Jensen-Shannon Divergence
Partitioned Views
Qualified Table Reference
Data Drift
Wasserstein Distance
ML.TFDV_VALIDATE
ML.TFDV_DESCRIBE
Data Skew
Fact Table
ML.VALIDATE_DATA_DRIFT
Entity-Relationship Modeling (ERM)
Granularity
OLAP System
Data Model Types
Surrogate Key
Open Source ETL Tools
Attribute Hierarchy
ETL Tools
Enterprise ETL Tools
Dimension Table
Data Modeling Techniques
Data Modeling Process
Cloud ETL Tools
Pre-Calculated Reporting Table
BigQuery Data Source
Partitioned Tables in BigQuery
DROP MATERIALIZED VIEW (BigQuery)
ALTER MATERIALIZED VIEW (BigQuery)
CREATE MATERIALIZED VIEW (BigQuery)
SQL Query Editor in BigQuery
ML.FORECAST
ML.PREDICT
ML.EVALUATE
Abstraction (in Data Modeling)
Polymorphism (in Data Modeling)
Encapsulation (in Data Modeling)
Class (in Data Modeling)
Method (in Data Modeling)
Object Query Language (OQL)
Object-Oriented Database Management System (OODBMS)
Object-Oriented Data Model (OODM)
Time Travel in Data Lakehouse
Schema-on-Read
GA4 Export Data in BigQuery
Data Modeling Mistakes
Data Lakehouse
CREATE MODEL (BigQuery ML)
BigQuery ML
Array Fields
BigQuery Connector
Application-Aware Modeling
Self Service Analytics
Self Service BI Tools
Qualitative Research
Sampling Techniques
Looker
SQL Injection
Role-Based Access Control (RBAC)
Data Security Cost Considerations
Data Security Governance
Data Security Standards
Data Analyst
Data Privacy Governance
Data Privacy for Snowflake
Data Privacy for BigQuery
Data Privacy for dbt
Data Anomaly Detection
Data Analysis Tools
Business Intelligence Dashboards
AI-Powered Data Modeling
Warehousing Solutions
Data Masking
Data Graph
Data Exploration
Data Driven Decision Making
Data Anonymization
Stored Procedure
Visual Representation (in Data Modeling)
View Management
Version Control for Databases
T-SQL (Transact-SQL)
System Stored Procedure
Standard Views
Stakeholder Validation (in Modeling)
SQL Mesh
SQL Logic
SQL Generation
SQL Function
Snowflake Schema
Semi-Structured Data Model
Schema Visualization
Schema Reporting
Schema Comparison
Reverse ETL
Reverse Engineering (Databases)
Relational Database
Relational Database Design
Real-Time Collaboration
Real Time Data Processing
Query Efficiency
Query Tuning
Precompiled SQL
Query Parameter Support
Parameterized Query
Parameterization
Normalization Rules
Non-Identified Relationship
Multi-step Transformation
Modern Data Catalog Tools
Model Iteration (in Data Modeling)
Model Documentation Analytics
Materialized View
Identified Relationship
IDE Integration
High-Level Data Design
Governance Strategies
Star Schema
Governance Framework in Data Management
GitOps for Database Management
Forward Engineering
Foreign Key
Execution Plan
Execute Permission
Enterprise Conceptual Data Model
Dynamic SQL
Drag-and-Drop Interface
Derived Model
Derived Attribute
Decentralized Data Team
Data Modeling Granularity
Data Modeling Conventions
Data Modeling Documentation
Data Model Versioning
Data Model Partitioning
Data Model Optimization
Data Layer
Database Schema Lineage
Database Schema Diagram
Database Logic
Database Diagram Tool
Data Transformation Tools
Data Transformation Frameworks
Data Team Culture
Data Streaming
Data Replication
Data Quality for Snowflake
Data Quality for dbt
Data Profiling for Snowflake
Data Profiling for Redshift
Data Modeling Tool
Conceptual Data Modeling Tool
Collaborative Diagramming
CLR Stored Procedure
Caller's Rights vs. Owner's Rights
Bind Variables
Data Duplication
Data Architecture Diagram
Crow’s Foot Notation
Conceptual Model in DBMS
Conceptual Diagram
DataOps
Data Teams
Data Stakeholders
Data Retention Policies
Scalable Infrastructure
Data Quality Checks
Orchestration Tools
Data Practices
Metadata Standards
Data Orchestration Tools
Data Model Integrity
Data Mart Layer
Data Management Best Practices
Data Lineage for Redshift
Data Lineage for dbt
Data Lineage for Databricks
Data Lineage for BigQuery
Data Latency
Data Ingestion
BigQuery Views
Data Infrastructure
Data Governance Framework
Data Governance for Snowflake
Data Governance for Redshift
Data Governance for Databricks
Data Governance for BigQuery
Data Federation
Data Enrichment
Data Documentation for Redshift
Data Documentation for dbt
Data Dictionary for BigQuery
Data Discovery for Databricks
Data Discovery for BigQuery
Data Dictionary for Redshift
Data Democratization
Data Documentation for BigQuery
Data Cost Optimization
Data Cleansing
Data Catalog
Data Catalog for Snowflake
Data Catalog for dbt
Data Catalog for Databricks
Weak Entity
Data Catalog For BigQuery
Data Catalog for Redshift
Cost-Effective Data Management Strategies
Conceptual Data Model
Centralized Data Team
Business Rules in Data Models
Associative Entity
View
Temporal Data
Subschema
Physical Data Model
Persistent Data
One-to-One Relationship (1-1)
Recursive Relationship
Recursive Data Model
Quality Assurance
Degenerate Dimension
Database Schema
Data Model Abstraction
Bridge Table
Anchor Modeling
Logical Data Model
JOIN Key
Dimensional Fact Model
One-to-Many Relationship (1-N)
Many-to-Many Relationship (N-N)
Data Orchestration
Entity
Composite Key
Cardinality
Relationships
Attribute
Object
ELT Process
Metadata Extractor
Data Mesh
DevSecOps
Data Encryption
Oops! Something went wrong while submitting the form...
By submitting this form I agree with Terms of service and Privacy policy.