Database Development Software
Need an information management database development software checklist?
What is database development?
Successful data warehouse development is a process that commences 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 model, is 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.
|
