|
Data administrators who develop and manage
enterprise, business-critical, and client/server databases
in multiple environments may want to choose a software package
which consists of the business modeling tool, a design environment
in which you create, modify, or capture data structures; and
programs which integrates the modeling and database design
capabilities of the report module.
One who is in need of client/server database
design and business process re-engineering software solutions
may want a package with features which lets developers edit
objects directly in the diagram windows, that automatically
adjusts relationship lines whenever an attached entity is
moved; one with enhanced printing capabilities, and forward-
a and reverse-engineering.
One, whom needs to create high-performance databases,
should choose a package which can generate query objects,
extended attributes, enable a single user to reverse-engineer,
and design, and maintain databases. One in need of server/client
tools should choose a product with a great deal of compatibility,
one with a graphical design window for drawing entity-relationship
diagrams and a species of repository that not only can store
database components, automation to jump to associated text
documents, and reporting features.
There are many different features and packages available
to suit one’s professional needs. If you need to present
development environment preferences, you
can request a go-to function which may bring you to any entity
in the model requested. There are features which allow one
to create a model in one sheet or multiple sheets, the ability
to define one’s relationship between subjects, create
a logical model based on business rules, specify entities,
attributes, and relationships, the ability to view logical
model definitions through logical model diagram or definition
forms, depth control of the information displayed in the diagram,
the ability to select form types, and the ability to divide
a logical model diagram into pages.
If one is looking for flexible reporting functions,
one may choose a package that allows you to create an unlimited
number of custom reports and lets you view and print all of
the diagrams and reports you want. Choose features which allow
you to save custom reports for the future and with reports
that can easily be generated to word processor files then
printed. Choose a product with plenty of editing tools to
assist you.
Combining two models makes it easier to design a
database. Some products have both a logical and physical
model in one. This will eliminate the need to generate a physical
model. Some products allow you to set up a target server and
referential integrity default anytime during the model development,
others will automatically convert the current model to fit
the new target server and defaults, lets you choose to preserve
or overwrite changes, lets you view the physical model through
the model diagram or model definition forms, allows one to
view and to modify the Data Definition Language (DDL) scripts,
creates a DDL that can be viewed, edited, and saved, gives
one full control of data type conversion, and selects a table
in the physical model which can be created in the DDL files.
Some products have easy-to-use schema generating tools, helpful
script editors, and correctable schema scripts, allows one
to select the database structure items that needed to be created
by the schema script, such as tables, primary keys, foreign
keys, and indexes. When one wants is in maintenance
stages, get features which are able to choose which
primary or foreign keys you want to reverse and allows you
control over the reverse data types in the database schema
then reverse the physical model back to the logical model.
Some maintenance features allows one to
display a report which shows how many tables and columns are
reversed during the process; automatically lay out a reversed
model, and successfully reverse table definitions and the
relationships among them, and automatically adjust table columns
after the relationships among tables are changed. Other features
include the ability to create a physical data model based
on the reversed information, handle the evolution of a data
model when changes to the logical and physical models are
made, lets one preserve the modifications made to the current
physical made, and allows one to archive data models. The
options are nearly everlasting.
Copyright
© 2005 Database Design Information. Send comments here. |
 |
