Posts by
Redgate Data Modeler
In this article, I will try to compare two database modelers: Vertabelo and Sea Quail Database Diagram Tool. Here is a matrix of each tool’s key features and functionality. Read more
Vertabelo internally stores your model in an XML format. You can download the XML file and use it to extract some information by using a script. Let’s take a look at the structure of this XML file. Read more
Sometimes you don't want the reverse engineering tool to extract all of the tables in your database. For example, the database may contain technical tables which are logically are not part of the model. This is when the -regexp option comes in handy.
Read more
The Vertabelo journey continues … We now have almost 10,000 users and the number of Vertabelo advocates keeps growing strong.
Vertabelo users come from over 100 countries and speak various languages. What unites them?
The relational database. Read more
UML is popular for its notations. We all know that UML is for visualizing, specifying, and documenting the components of software and non software systems. What's more, UML has many types of diagrams which are divided into two categories. Some types represent structural information, others general types of behavior. Among these, there is one... Read more
Arrow notation has become one of the less recognized notations in entity relationships diagrams in recent years. Let's discuss its elements. Read more
IDEF1X is a method for designing relational databases with a syntax that supports constructs in developing conceptual schema. Not everyone knows that this notation has an interesting history. Indeed, the need for semantic data models was first recognized by the U.S. Air Force in the mid-1970s. Let's take a closer look at the syntax. Read more
Continuing our trip through different ERD notations, let's review the Chen ERD notation.
Peter Chen, who developed entity-relationship modeling and published his work in 1976, was one of the pioneers of using the entity relationship concepts in software and information system modeling and design. The Chen ERD notation is still used and is considered... Read more
When looking at different kinds of ERD notations, it is hard not to come across Barker's ERD notation, which is commonly used to describe data for Oracle. Richard Barker and his coworkers developed this ERD notation while working at the British consulting firm CACI around 1981, and when Barker joined Oracle, his notation was... Read more
An entity relationship diagram (ERD) is a diagram that defines the structure of database instances. Choosing which notation to use is typically left up to personal preference or conventions. Here, you can find some useful information about each notation. Read more
Redgate Data Modeler