Data Model

Articles tagged: Data Model

Data Modeling in Power BI: From Raw Data to a Trusted Model
Database Design & Metadata

Data Modeling in Power BI: From Raw Data to a Trusted Model

Learn how to build relationships, design semantic models, and document Power BI data models. See how Dataedo adds govern...

Michał Trybulec Michał Trybulec 16 min read
3 Basic Data Modeling Techniques - ERD, UML and Data Dictionary
Database Design & Metadata

3 Basic Data Modeling Techniques - ERD, UML and Data Dictionary

In this article I will give you a brief overview of 3 basic data modeling techniques - ER Diagrams, UML Class Diagrams a...

Piotr Kononow Piotr Kononow 4 min read
7 Reasons Why Tables and Columns Have Confusing Names
Database Design & Metadata

7 Reasons Why Tables and Columns Have Confusing Names

I believe you have seen a lot of confusing table and column names and wondered who made them. Here I'm considering the r...

Piotr Kononow Piotr Kononow 4 min read
Test If Your Database Has Foreign Keys Or Is It Full of Loners (Metric + Test Queries)
Database Design & Metadata

Test If Your Database Has Foreign Keys Or Is It Full of Loners (Metric + Test Queries)

Databases should but many don't have foreign key constraints. Does your database have them? To what extent? Here is a me...

Piotr Kononow Piotr Kononow 7 min read
9 reasons why there are no foreign keys constraints in your database (referential integrity checks)
Database Design & Metadata

9 reasons why there are no foreign keys constraints in your database (referential integrity checks)

A compilation of reasons why databases don't have defined foreign keys.

Piotr Kononow Piotr Kononow 6 min read
6 Typical Metadata Fields Stored by Applications
Application Metadata

6 Typical Metadata Fields Stored by Applications

6 most common metadata fields you can find in tables of many packaged and custom applications.

Piotr Kononow Piotr Kononow 5 min read
ER Diagram vs Data Dictionary – Which is Better for Documenting Data Models
Metadata Management

ER Diagram vs Data Dictionary – Which is Better for Documenting Data Models

ER Diagram or Data Dictionary. What they are and which is better for documenting data models.

Piotr Kononow Piotr Kononow 3 min read
Why Is Metadata Necessary to Understand Data - A Mysterious Data Set
Metadata Management

Why Is Metadata Necessary to Understand Data - A Mysterious Data Set

What is metadata in databases and why it's important to be able to find, access and use data.

Piotr Kononow Piotr Kononow 5 min read
Create a Data Dictionary with Dataedo
Products and News

Create a Data Dictionary with Dataedo

Tutorial on creating Data Dictionaries with Dataedo.

Piotr Kononow Piotr Kononow 9 min read
Data Model vs Data Dictionary vs Database Schema vs ERD
Metadata Management

Data Model vs Data Dictionary vs Database Schema vs ERD

Data Model, Data Dictionary, Database Schema, Entity Relationship Diagram. What are all those data related terms? What i...

Piotr Kononow Piotr Kononow 3 min read
Logical vs Physical Data Dictionary
Metadata Management

Logical vs Physical Data Dictionary

What is the difference between logical and physical Data Dictionary.

Piotr Kononow Piotr Kononow 4 min read