Support
Piotr Kononow
Articles by Piotr Kononow
Products and News
Dataedo 9.1 - Document Data Lakes and build Data Community
Metadata Management
Are you confused when trying to work with databases?
So, you have access to the database. But do you really have access to the data? You can query all the tables but what if...
Products and News
Dataedo 9.0: Documentation of MongoDB, Teradata and Vertica databases
Products and News
Dataedo named a 2020 Gartner Peer Insights Customers' Choice for Metadata Management Solutions
![How Database Documentation Helped Database Development at RedBook Solutions [Video Testimonial]](https://dataedo.com/asset/img/banners/blog/jay_michael_redbook.png)
Products and News
How Database Documentation Helped Database Development at RedBook Solutions [Video Testimonial]
![Business Glossaries - The What, the Why, and the How [Webinar + Presentation + Article]](https://dataedo.com/asset/img/banners/blog/business_glossary_george.png)
Metadata Management
Business Glossaries - The What, the Why, and the How [Webinar + Presentation + Article]
Metadata Tools
6 Different Tools You Can Use to Create ER Diagram (ERD) for Existing Database
List of different categories of tools that you can use to create an ER diagram of your existing database to visualise it...
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...
Metadata Tools
5 Different Types of Tools You Can Use to Create a Data Dictionary
Accessing company data held in databases is becoming critical, organizations are looking for tools that will allow them...
Metadata Management
Business Glossary vs Data Glossary vs Data Dictionary
Data Dictioanary, Data Glossary and Business Glossary, are they the same?
Database Design & Metadata
Do You Really Need a Huge ER Diagram for the Entire Database with ALL the Tables?
Many people trying to visualize database want to create a complete diagram with all the tables in the entire database. I...
Database Design & Metadata
You Don't Need an ER Diagram to Understand Your Database
ERDs are great for visualizing databases but are not suitable as the documentation in itself. Why and what is? Find out.
Metadata Management
Why Your Analytics & BI Need a Business Glossary? Real Life Examples by Industry
Industry examples how lack of common terminology (Business Glossary) harms reporting and analytics. Examples in Utilitie...
Products and News
Dataedo 7.5: Sensitive Data Discovery and Classification
Dataedo 7.5 Enterprise now allows you to easily discover and classify sensitive data in your databases.
Metadata Management
Business Glossary Anatomy - Elements of Typical Business Glossary Tools
Elements of typical Business Glossary implementations and tools.
Metadata Tools
Dataedo vs Popular Data Modeling Tools
A comparison of Dataedo to popular data modeling tools.
Products and News
Build and Share Business Glossary with Dataedo
You can now easily build Business Glossary linked with Data Dictionary and share it in interactive HTML pages.
Products and News
Dataedo 7.4: Build Business Glossary
Dataedo 7.4 adds important data governance and metadata management feature - Business Glossary.
Products and News
Dataedo 7.3: ODBC, Copying Descriptions, Column View and More
Dataedo 7.3 extends support for databases vastly through generic ODBC connection, adds option to copy documentation to o...
Products and News
Dataedo 7.2: Schema Change Tracking, Custom Field Types, Suggestions and More
Dataedo 7.2 brings new amazing database documentation features.
Products and News
Dataedo 7.1: New Data Sources, Manual Tables and More
Dataedo 7.1 is a new generation of powerful database documentation tool. See what it can do now.
Metadata Management
What is Personal Data Under GDPR - Definitions and Examples
GDPR is a great challenge for all companies that process EU citizens' data. This article defines what personal data is u...
Products and News
Dataedo 6.1: Custom Field Search, One-One FKs, User-Defined Dependencies
Dataedo 6.1 adds more flexibility around definition of the database metadata and improves search.
Database Design & Metadata
Lack of Comments Makes Database Documentation Useless
Too often, developers produce database documentation containing just a schema information - table and column names, with...
Database Design & Metadata
How to Check if Your Database Has Comments
Most popular database engines provide option to provide descriptions for schema elements. This article shows how to chec...
Products and News
Dataedo 6 is out: New Quality of Database Documentation
Long awaited Dataedo 6.0 is finally here.
Products and News
Multiple Dataedo Database Documentation Repositories
A few scenarios how you can leverage Dataedo repositories to manage documentation in complex database systems.
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...
Products and News
Dataedo 6.0 beta: Custom Fields, Cross-DB and Much More!
We are proud to announce the release of beta of our ground breaking Dataedo 6.
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...
Database Design & Metadata
What You Can Comment In Oracle Database
Overview of capabilities of commenting objects in Oracle database.
Database Design & Metadata
Captain Obvious' Guide to Column Descriptions - Data Dictionary Best Practices
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)
Database Design & Metadata
Don't Most Databases Have Foreign Key Constraints? [Research data + Poll]
Results of my research of existence of foreign key constraints in 40 example databases.
Application Metadata
Major Applications Do Not Use Foreign Key Constraints In Their Databases (Oracle, Microsoft, SAP)
My research revealed that most major ERP and CRM applications do not use foreign key constraints in their databases.
Database Design & Metadata
Why It Is More Important to Document Database Than Application Code
The differences between documenting database schema and application code.
Database Design & Metadata
Who do You Document Databases For
There are many people and roles that need to understand the data model and could make use of a documentation. This artic...
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.
Database Design & Metadata
How to Document Stored Procedures and Functions in Database
A compilation of best practices documenting stored procedures and functions in relational databases.
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.
Database Design & Metadata
2 Common SQL Join Traps (with Test Queries)
There are 2 very common traps (with serious consequences) you can easily fall into while joining tables in an SQL query....
Metadata Tools
8 Different Types of Tools You Can Use to Document your Database
This article presents 8 different types of tools you can use to create a documentation of your existing databases.
Application Metadata
4 Functions and Shapes of Data Dictionary by the Example of a CRM Implementation
Data dictionaries is data modeling or documentation artifact that can be created in various scenarios and can have diffe...
Database Design & Metadata
8 Good Occasions to Start Documenting Your Databases
It's never too late to start documenting your databases. Regardless of the stage in it's life-cycle or your knowledge, w...
Metadata Tools
Redgate SQL Doc vs Dataedo - Documenting Existing Databases
A comparison between two database documentation tools - Dataedo and Redgate SQL Doc.
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.
Products and News
Data Dictionary with Dataedo Part 2: Add More Metadata
Part two of tutorials on creating Data Dictionaries with Dataedo.
Database Design & Metadata
6 Useful Oracle Data Dictionary Queries Every DBA Should Have
List of handy SQL queries to the Oracle database data dictionary
Products and News
Dataedo 5.2: Dependencies, Command Line, Custom Branding and More
Dataedo 5.2 is out. See what's new.
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.
Database Design & Metadata
10 Ways Data Dictionary Increases Software Developers Productivity
Any software development project that has uses some kind of database needs a Data Dictionary. Learn why.
Database Design & Metadata
13 Reasons Why Databases Don't Get Documented
Subjective list of reasons why databases don't get documented in your team or organization.
Metadata Management
Why It's Hard to Find Data And Why You Need a Map: Data Dictionary
See on a sample manufacturing company how many data a single gathers and how complex its application environment is.
Products and News
Create a Data Dictionary with Dataedo
Tutorial on creating Data Dictionaries with Dataedo.
Metadata Management
Why Should Your Organization Open Its Databases
Learn what it means that databases are closed, why it is most likely so in your organization and why and how you should...
Products and News
Dataedo 5.1: Advanced ERDs
Dataedo 5.1 is out. See what's new.
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...
Products and News
Dataedo 5: MySQL, ERDs and more
Finally, Dataedo 5.0 is here.
Database Design & Metadata
Is Lack of Database Documentation a Global Problem for Software Developers?
See what polls tell us about software developers' struggles in the area of databases.
Metadata Management
Logical vs Physical Data Dictionary
What is the difference between logical and physical Data Dictionary.
Products and News
Dataedo 4.1 has been released – see what’s new
Dataedo 4.1 release notes.