|
Interest in data modelers currently slowly translating into
daily use, leading market research companies are unable to
regularly track the use of data modelers separately from the
broader category of analysis and design.
Typically, logical data models are the heart of any database
design. A logical model should contain all the specifications
for entities, attributes, business rules, and data relationships.
For it to work professionally and effortlessly a product must
capture all this information. A physical model
should contain every detail that the database needs to create
an effective data definition like the data types of the columns,
which columns can contain nulls, whether a column has a default
and what that default is, and so on.
Some can output a report to a word processor format. A good
physical model has editing tools which allow you to modify,
allow you complete control over our view of the physical model,
supplies graphical editing tools, generates indexes based
on defined search keys, has ease-of-use features which minimize
the entry of redundant information, contains extensive details
about the specific attributes of the tables and columns.
Other good features within a good product
include, products with the ability to complete all the diagrams
and reports without a problem, complete all tests and offer
a user-friendly environment, allow diagrams and reports on
segments of the physical data model and supplied canned reports,
offer a powerful set of capabilities, and have easy-to-use
graphical tools, a drag-and-drop setup feature, and canned
reports.
Products which allow one to save reports in a word processor
format, lets you customize the report formats, let one control
which database to target, generates easy to use scripts, offers
point and click methods for selecting the target back end
and starting the process, lets one view and modify scripts
with graphical tools and lets one print scripts to hard copy
or a file, are considered excellent.
Copyright
© 2005 Database Design Information. Send comments here. |
 |
