DeZign for Databases
Encyclopedia
DeZign for Databases is a database design
and data modeling
tool for multiple database platforms (Oracle
, MySQL
, IBM
DB2, PostgreSQL
, MS SQL Sever, MS Access, ...). It can be used to create, maintain and document new or existing database systems. The tool uses Entity-relationship diagram. Similar tools are Embarcadero ER/Studio
, IBM
Data Architect, Oracle Designer
and Sybase
PowerDesigner
.
. Support for more databases was added in the late nineties. About 20 databases are supported in the 2008 version of the tool.
Database design
Database design is the process of producing a detailed data model of a database. This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a Data Definition Language, which can then be used to create a database...
and data modeling
Data modeling
Data modeling in software engineering is the process of creating a data model for an information system by applying formal data modeling techniques.- Overview :...
tool for multiple database platforms (Oracle
Oracle Database
The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....
, MySQL
MySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
, IBM
IBM
International Business Machines Corporation or IBM is an American multinational technology and consulting corporation headquartered in Armonk, New York, United States. IBM manufactures and sells computer hardware and software, and it offers infrastructure, hosting and consulting services in areas...
DB2, PostgreSQL
PostgreSQL
PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
, MS SQL Sever, MS Access, ...). It can be used to create, maintain and document new or existing database systems. The tool uses Entity-relationship diagram. Similar tools are Embarcadero ER/Studio
ER/Studio
ER/Studio is data architecture and database design software developed by Embarcadero Technologies. It works across multiple database platforms and is used by data architects, data modelers, database administrators and business analysts to create and manage database designs, document and reuse data...
, IBM
IBM
International Business Machines Corporation or IBM is an American multinational technology and consulting corporation headquartered in Armonk, New York, United States. IBM manufactures and sells computer hardware and software, and it offers infrastructure, hosting and consulting services in areas...
Data Architect, Oracle Designer
Oracle Designer
Oracle Designer is Oracle's CASE tool for designing an information system and generating it. After generating the information system one is able to edit the generated code with Oracle Developer Suite-Components of Oracle Designer:Business Process Modelling...
and Sybase
Sybase
Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms....
PowerDesigner
PowerDesigner
PowerDesigner is a collaborative enterprise modelling tool produced by Sybase. PowerDesigner runs under Microsoft Windows as a native application, and runs under Eclipse through a plugin. PowerDesigner supports model-driven architecture software design. PowerDesigner uses the .pdm file...
.
History
DeZign for Databases was created by Heraut Solutions in 1998. Later the company name was changed to Datanamic. DeZign for Databases was the first modeling tool to support MySQLMySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
. Support for more databases was added in the late nineties. About 20 databases are supported in the 2008 version of the tool.
See also
- Computer-aided software engineeringComputer-aided software engineeringComputer-aided software engineering is the scientific application of a set of tools and methods to a software system which is meant to result in high-quality, defect-free, and maintainable software products...
- Relational ModelRelational modelThe relational model for database management is a database model based on first-order predicate logic, first formulated and proposed in 1969 by Edgar F...
- Data modelingData modelingData modeling in software engineering is the process of creating a data model for an information system by applying formal data modeling techniques.- Overview :...
- RDBMS