Articles in category: Database Design & Metadata
Learn how to build relationships, design semantic models, and document Power BI data models. See how Dataedo adds govern...
In this article I will give you a brief overview of 3 basic data modeling techniques - ER Diagrams, UML Class Diagrams a...
Many people trying to visualize database want to create a complete diagram with all the tables in the entire database. I...
5 tips on how you can start improving your databases so that everyone that has to work with it will be productive.
ERDs are great for visualizing databases but are not suitable as the documentation in itself. Why and what is? Find out.
Extended Properties are cool feature of SQL Server but are they suitable for documentation of schema. See pros and cons....
Too often, developers produce database documentation containing just a schema information - table and column names, with...
Most popular database engines provide option to provide descriptions for schema elements. This article shows how to chec...
I believe you have seen a lot of confusing table and column names and wondered who made them. Here I'm considering the r...
Databases should but many don't have foreign key constraints. Does your database have them? To what extent? Here is a me...
Overview of capabilities of commenting objects in Oracle database.
We assigned best of us - Captain Obvious - to document columns in one of our tables. We want to pass on to yo you what w...
![Don't Most Databases Have Foreign Key Constraints? [Research data + Poll]](https://dataedo.com/asset/img/banners/blog/dbs_dont_have_fks.png?2)
Results of my research of existence of foreign key constraints in 40 example databases.
List of SQL queries for SQL Server system catalog / data dictionary handy for any DBA.
The differences between documenting database schema and application code.
There are many people and roles that need to understand the data model and could make use of a documentation. This artic...
A compilation of reasons why databases don't have defined foreign keys.
A compilation of best practices documenting stored procedures and functions in relational databases.
There are 2 very common traps (with serious consequences) you can easily fall into while joining tables in an SQL query....
It's never too late to start documenting your databases. Regardless of the stage in it's life-cycle or your knowledge, w...
List of handy SQL queries to the Oracle database data dictionary
Any software development project that has uses some kind of database needs a Data Dictionary. Learn why.
Subjective list of reasons why databases don't get documented in your team or organization.
See what polls tell us about software developers' struggles in the area of databases.
Support
