Feedback About wiseGEEK Login
What is Data Modeling?
Article Details
  • Written By: David White
  • Edited By: Niki Foster
  • Last Modified Date: 26 January 2012
  • Copyright Protected:
    2003-2012
    Conjecture Corporation
Free Widgets for your Site/Blog
 more...

Despite its name, data modeling has nothing to do with getting data all dolled up and ready for a night on the town. Or does it? Actually, that description might not be too far off.

Data modeling is a way to structure and organize data so it can be used easily by databases. Unstructured data can be found in word processing documents, email messages, audio or video files, and design programs. Data modeling doesn't want these "ugly" data; rather, data modeling wants data that is all made up in a nice, neat package for processing by a database. So in a way, data modeling is concerned with how the data looks.

Data modeling is routinely used in conjunction with a database management system. Data that has been modeled and made ready for this system can be identified in various ways, such as according to what they represent or how they relate to other data. The idea is to make data as presentable as possible, so analysis and integration can be done with as little effort as necessary.

We can also think of data modeling as instructions for building a database. Concentrate on the word model, and you'll get what we're going after here. To make a "pretty" database, you will want to follow a model as a means toward your desired end.

For example, if you want to analyze how many people in a given congressional district voted in the last election, you will naturally want to include a column for which party each person voted for. That kind of analysis will be valuable to members of all political parties, and it is the kind of detail that you can build into the database from the ground up, instructing the database management system to include that column of information in the resulting database. If you wanted to analyze that information specifically but didn't include a column for it in your database, you'd spend lots of time collating the data — effort that would not be necessary if you had followed the data model in the first place. Data modeling is therefore a very important skill to implement when building databases.

Related Videos

Discuss this Article

anon114818
Post 11
Two thumbs up. Very concise and clear. - ajrosal
anon102068
Post 10
Excellent definition of data modeling. thank you very much.
anon95001
Post 9
this is a good definition. thank you very much. anyone who has no idea what this is can understand easily without confusion.
Related Topics
anon87244
Post 8
the definition of data modeling is very good for a beginner and gives a very good idea of knowing what is data modeling. Thank you very much.

anon85658
Post 7
Very simple and easy to understand.
anon83936
Post 6
really helpful in designing specs for my project. It's easy to understand for a beginner like me.
Related Topics
anon64781
Post 5
very helpful! best way to explain a beginner.

thank you so much.

anon62052
Post 4
A neat explanation for beginners. Data Modeling 101. Thanks!
anon59999
Post 3
Very simple and very clear explanation of data modeling.
Related Topics
anon56826
Post 2
In a very efficient manner I got the idea about data modeling.
anon33185
Post 1
This is the simplest and most effective definition of data modeling. It's very nice for a beginner.

Post your comments

Post Anonymously

please enter the following code:

Login

username
password
forgot password?
or connect with facebook

Register

username
password
confirm
email