DeZign for Databases

What is DeZign for Databases?

Data modeling for database professionals.

Visualize database structures to understand your database, create new databases, or reverse engineer existing databases to modify, document, analyze, and optimize.

Robust, easy-to-use data modeling tool

DeZign for Databases is an intuitive data modeling tool for developers and DBAs that can help you model, create, and maintain databases. The software uses entity relationship diagrams (ERDs, data models) to graphically design databases and automatically generates the most popular databases.

DeZign for Databases provides a sophisticated visual data modeling environment for database development that greatly facilitates the database development process. The tool reduces database development failures and improves your productivity. You can view database structures to understand your database, create new databases, or reverse engineer existing databases to modify, document, analyze, and optimize.

The tool is extremely easy to use. Whether you're a beginner or a database modeling expert, you'll find your way into the tool very easily. DeZign for Databases provides all the features you expect from a professional database modeling and design tool.

Visual Modeling database

Entity relationship diagram. DeZign for Databases uses entity relationship diagrams (ERDs) to graphically design databases. In your diagram, you can create a visual design using entities, relationships, subcategories, group boxes, and text blocks. Entity symbols are used to define database table structures, including details about columns (attributes), primary, null, unique keys, foreign keys, domains, verification constraints. Relationships are plotted between entities and can include a name, abbreviation, description, and cardinalities (zero, one, many). The diagram editor UI fully supports the drag-and-drop feature of entities, relationships, subcategories, group boxes, and text blocks.

Industry-standard design notations. You can draw your entity relationship diagram (ERD) based on the data modeling notations defined by IDEF1X or Crow's Foot (Information Engineering).

Multiple views. The software will display model information at various levels. These views can be used at various stages of model development, or they can be used to convey model information in the abstract or at different depths of detail.

Pan and zoom window. Quickly navigate large diagrams with the Pan and Zoom window. This window provides a panoramic view of your diagrams.

ER modeling. DeZign for Databases supports ER modeling techniques. Some advanced features, such as N:M relationships (many-to-many relationships) and subcategories (inheritance), are also supported. "DeZign for Databases" will take care of translating the ER (design of your database) diagram into the physical database.

Advanced and Reverse Engineering

Advanced engineering. DeZign for Databases can generate databases directly from your data models (ER diagrams). For SQL databases, the SQL DDL scripts to create your database will be generated. For non-SQL databases, the physical files in the database will be generated directly. You can control what will be generated. Generate individual parts of your model. Generate tables, foreign keys, indexes, domains, sequences, procedures, triggers, and visualizations.

Reverse engineering. Derive a graphical data model from existing databases, for relational platforms and big data. You can import an existing database by connecting directly to the database or importing a SQL DDL script. Your full database will be imported, including tables, foreign keys, sequences, triggers, procedures, and visualizations. While reverse engineering, the software analyzes the database to find relationships not expressly defined in the database.

Database/model synchronization

Our data modeling product offers two-way comparison and synchronization functionality for all synchronization use cases: database model, script model, model to model, model script, model script, model model, model to model. Changes can be moved from model to database or database to model. With comparison options, you can control what will be seen as a difference.

Model-oriented collaboration

If you need to develop large models with many modelers, you may prefer to store your model in a repository (server-based) database. The Datanamic Repository is a central repository database for storing your data models. With the Datanamic Repository, more than one user can work on the same data model. You can connect to the Datanamic Repository with the DeZign for Databases Expert Edition.

Model maintenance

Diagram management. DeZign for Databases increases its modeling power with subdiagrams. A project is a set of one or more subdiagrams that contains the specification of an entire data model. You can divide a large or complex model into smaller, easier-to-maintain subdiagrams.

Objectbrowser. Instead of presenting a model image in the traditional way of the diagram window, Object Search provides an organized and orderly view of the model and its contents. You can create, navigate, and modify a model in object browser.

Marking. Organize the objects in your project into meaningful groups with labels. That way, you can quickly and easily filter and report the data that is of interest to you.

Communicating

DeZign for Databases provides flexible, customizable reporting and printing capabilities.

HTML, MS Word and PDF reports. You can generate HTML, MS Word, and PDF formatted reports to make it easier to deploy design information. Multiple reports with different levels of detail can be generated. Optionally, diagrams can be inserted as an image.

Export diagram as image. The diagram itself can be printed or exported as a png, bitmap, jpeg-image, gif-image, or windows metafile.

Best database projects

Model validation. You can validate a template for errors at any time during the design process. During validation, the tool verifies that the elements in your data model are correct and complete.

Automatic foreign key migration. Our data modeling tool supports the level of logical and physical data from a single specification obtained using automatic foreign key migration at design time.

A modification to a property of a relationship or a primary key will automatically affect foreign keys.

Domains. Domains are user-defined reusable types or "attribute templates" that promote consistent domain definitions. You build a domain by specifying a name, data type, default value, and validation rules. You can then reuse them in your data model by applying them to attributes.

Attribute packages. Attribute packs are predefined reusable attribute sets that promote consistent attribute definitions. You can share attribute packages between models/data projects.

Name templates. The name template editor allows you to create naming rules for entities, relationships, and constraints that can be reused in the template.

Supported databases

DeZign for Databases supports more than 15 databases, including Oracle, MySQL, MS SQL Server, MS Access, DB2, Azure SQL, and PostgreSQL. A complete list of supported databases can be found in the supported databases overview.

System requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD / SSD: 50 GB of free space on the main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit

Resolution: 1024×768