logo for information-management-architect.com
leftimage for information-management-architect.com

Database Development Software

Need an information management database development software checklist?

What is database development?

Successful data warehouse development is a process that commencesDatabae Development Software with a series of data models.
  • Conceptual data model  is created at the information management strategy stage.  It contains key entities and relationships and presents a high level look at all of the entities within an organization.
  • Enterprise data model is an entity relationship diagram which builds on the conceptual data model and adds additional details;
  • Logical data modelis a fully attributed entity relationship diagram (ERD), which shows each entity, its relationship to other entitles and specifies the applicable business rules;
  • Dimensional model, represents facts and dimensions, which are required to store dimension data in an efficient manner for reporting and analysis purposes; and
  • Physical data model, is the final representation of the relational database design structures that will be generated from the model. It contains the detailed specifications for the database design and, in a model driven environment, the modeling tool will generate the data definition language (DDL) that is used to create the database structure.
What is database development software?

Database development software includes:
  • Data modeling tools; and
  • Database development tools.
What are data modeling tools?

Data modeling tools are used by data modelers and data architects to create:
  • Logical data models; and
  • Physical data models.
These tools should be capable of producing data definition language (DDL) required to generate:
  • Databases;
  • Tablespaces;
  • Files;
  • Instances;
  • Tables, columns and datatypes;
  • Constraints;
  • Partitions;
  • Indexes; and
  • Views.
These tools should also be capable of:
  • Comparing one model with another model and synchronizing the models as needed;
  • Comparing a physical model with a database and synchronizing the model to ensure it matches the database structures;
  • Comparing a physical model with a database and generating the DDL required to synchronize the database structure with the model; and
  • Comparing a physical data model with a physical database and generating the DDL and data manipulation language (DML) required to maintain data in the database e.g. the data model tool might generate DDL to create temporary table structures, DML to move data to the temporary structures, and DDL to drop the old tables and rename to temporary tables to replace the tables that were dropped.
What are database development tools?

Database development tools are used by developers and database administrators to help develop SQL and other queries.

These tools provide similar capabilities to data modeling tools e.g.
  • Producing data definition language (DDL) required to generate the data base; and
  • Comparing data structures and creating DDL/DML required to synchronize data structures.
They are also used by developers to look at the data structures, query and examine data for analysis purposes and create and test SQL statements.

Database development tools do not usually include data modeling capabilities.

What are common data modeling tools?

The following tools are commonly used for logical and physical data modeling:
  • Oracle Designer;
  • AllFusion ERwin Data Modeler;
  • Sybase PowerDesigner; and
  • Embarcadero ER/Studio.
What are common database development tools?

The following tools are commonly used for database development work:
  • Quest Software
    • Toad for Oracle Database Tools
    • Toad for SQL Server Development & Administration
    • Toad for DB2 Administration Tool
    • Toad for MySQL Developer Tools
  • Embarcadero DBArtisan
Summary...

Database development software includes:
  • Data modeling tools; and
  • Database development tools.
These tools help data modelers and database developers create and optimize database structures and should be considered a critical resource for any information management project.


footer for Information management page