Q

Methods of depicting a data model

My client is asking for a data model. I know that a data model can be a complex design showing data that is need and the relationship (logical/physical). What other methtods are there of depicting a data model? Can it be done by creating a diagram? I need to help my client define what they are looking for/expect.

A data model is a "road map" that describes the data objects in a schema. It shows what tables are in the schema, some information about the columns in those tables, and some information about the relationships between the tables. There are several graphic representations for data models.

IDE1FX is one of the most mature, and certainly most full featured graphical data model representations. IDE1FX is part of a family of graphic models for all kinds of program and process information. There are two common levels of display used by IDE1FX: the logical model which concentrates on getting the tables and columns correctly enumerated and the "high level" relationships between tables defined, and the physical model which delves more deeply into how the tables and relationships are actually implemented using a particular database engine.

"Crows foot" is another data modeling notation. It can be used by many of the popular data modeling tools.

Many of the high-end development environments include a data modeling tool. Microsoft's Visual Studio Enterprise and Rational's Rose come right to my mind. I've been surprised by the number of developers and consultants that have these tools, but don't realize it!

If you don't already have one, be prepared for "sticker shock" when you check out database modeling tools. Computer Associate's ErWin is the granddaddy of data modeling tools, and Sybase's PowerDesigner is well respected too. Microsoft's Visio Professional is one of the lowest cost data modeling tools that I'd recommend, at around US$500 MSRP (note that it will NOT generate scripts for you, but it will reverse engineer and model nicely).

For More Information


This was first published in September 2002
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close