Understanding relationships between tables is crucial for querying of a database. Those relationships are often nonobvious as foreign keys are rarely defined in a database schema. Without this information you left with guess work, asking your colleagues, and exposed to errors in your queries.

But it does not have to be that way. Allow Dataedo to extract what foreign keys information is defined in a database and complete the rest in the same format so that you have a complete view of the relationships in your database. No more guessing.

• Discover foreign keys from database constraints
• Define additional relationships manually
• Visualize all relationships with ER Diagrams

A Nodepad for Your Database

Do you know what attribute1 column means? Is it in use? Or how is due_date calculated? Or what does ‘A’ value in status column mean?

Data structures can be confusing and sometimes misleading and Dataedo allows you to explain meaning and purpose of each data element in your database.

• Annotate data elements
• Provide meaningful aliases
• Add additional information in structured format using custom fields

Organize Databases with Subject Areas

Real databases have hundreds or even thousands of tables. It is really hard to find a table with data you need or figure out what is this particular table used for. Dataedo helps you manage this complexity with so called “modules”, which you can think of as folders organizing objects in your database.