Use data modeling to create a conceptual model, or graphical representation, of data and business processes. Data modeling optimizes the way that information is stored and used within an organization. The data model is essentially a framework for the development of any new application. There are several methods of data modeling and many data modeling applications available.

Before creating a database for your data, create a data model. Data modeling will help you to avoid a sprawling database that becomes cumbersome over time. Having a framework from which to build will save time and prevent headaches in the future.

The following will help you find the data modeling information you need:

1. Download free data modeling software to perform basic functions.

2. Purchase a data modeling software package when you need advanced functions.

3. Hire a data modeling provider to model your data for you.

Action Steps
The best contacts and resources to help you get it done

Use free data modeling software for basic functions and to learn the process

Freely available data modeling programs are a good way to learn the ins and outs of basic data modeling. Many of the programs are open source, and you can customize them if you know how to write code.

I recommend: ArgoUML is a free open source data modeling tool. The product is available for download or can be run as a Java web application. DBDesigner is a visual database design system that merges database design, modeling, creation and maintenance into a single program. This product is good for anyone who works in MySQL.

Buy a professional software package from a data modeling provider

Data modeling software packages offer powerful data modeling tools. These packages are ideal for any company with programming and data modeling experience. Professional software packages typically come with customer service for those times when you run into a problem, which is an advantage over free programs.

I recommend: Toad Data Modeler is a comprehensive program for all who need to create and maintain database structures. Download a trial version to try it out before purchasing. Database Design Studio Professional offers a range of modeling tools, including reverse and forward engineering. A lite version that does not include the reverse engineering function is available for a lower price.

Find data modeling consultants to get assistance with your modeling project

Data modeling consultants will help you organize your data if your company does not have the capacity to undertake a project on its own. In addition to modeling your data, consultants can train you and your employees to properly manage databases.

I recommend: Intelligent Solutions offers data modeling consulting and education services. This firm will work as a mentor for your organization to ensure that all employees are properly trained to manage the system. DM Stat-1 Consulting offers a range of data modeling and mining consulting services.

Tips & Tactics

Helpful advice for making the most of this Guide

• •  Before you start data modeling, list the various categories of data you have and the relationships in which you are interested. Data modeling uses a standard set of symbols to represent defined data groups and then establishes relationships between them. Keep a key of symbols at your side during your modeling project to avoid frustration.