Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

Data Modeling Overview

By Exforsys | on May 4, 2007 |
Data Modeling

Data Modeling Overview

Data modeling refers to the process whereby data is structured and organized. It is a key component in the field of computer science. Once data is structured, it is usually then implemented into what is called a database management system. The main idea behind these systems is to manage vast amounts of both structured and unstructured data.

Unstructured data include documents, word processing, e-mail messages, pictures, and digital video and audio files. Structured data – what is needed to make a data model (via a data model theory) – is found in management systems like relational databases. A data model theory is the formal description of a data model.

The data model serves two main functions. First off, it needs to serve as an accurate representation of the analyst’s understanding of the overall enterprise. This way, the customer will be able to judge rightly whether or not the analyst understood the project. It is the ultimate test to see if the analyst really understands the nature of the business. If a data model is executed properly, then the answer will be quite clear. It should ask the user if it fulfills what he or she desires.

Next, the data model must provide an accurate reflection of the organization’s data. As such, it will provide the best starting point for the design of a database. While the final database design may very well end up looking a lot different than the data model, the data model should always strive to resemble the finished structure. This makes it easier to perform any necessary adjustments along the way. The designer/builder should get the message from the model – this is what you want to build.

Now let’s take a look at the structure of data. This is what the data model describes within the confines of a particular domain and, as it implies, the underlying structure of that specific domain. What this means is that data models actually specify a special “grammar” for the domain’s own private artificial language.

Data models are representations of different entity classes that a company wants to possess information about, containing the specifics behind that information, and the relationship among the differing entities and attributes. The data may be represented in a different fashion on the actual computer system than the way it is described in the data model.

The entities, or types of things, represented in the data model might be tangible entities, but models with entity classes that are so concrete usually change over time. Abstractions are often identified by robust data models. A data model might have an entity class marked “Persons,” which is meant to represent all the people who interact with a company. This abstract entity is more appropriate than ones called “Salesman” or “Boss,” which would specify a special role played by certain people.

In a conceptual data model, the semantics of a particular subject area are what is described. The conceptual data model is basically a collection of assertions about the type of information that is being used by a company. Entity classes are named using natural language, as opposed to technical jargon, and concrete assertions about the subject area benefit from proper naming.

Another way of organizing data involves the use of a database management system. This involves the use of relational tables, columns, classes, and attributes. These models are sometimes called “physical data models,” but in the use of ANSI three schema architecture, it is referred to as “logical.” In this type of architecture, the storage media is described in the physical model – cylinders, tablespaces, tracks, etc. It should be derived from the more conceptual model. There might be slight differences however, for example in the accounting for usage patterns and processing capacity.



Data analysis is a term that has become synonymous with data modeling. Although in truth, the activity seems to have more in common with synthesis than analysis. Synthesis, after all, refers to the process whereby general concepts are inferred from particular instances; in analysis, the opposite happens – particular concepts are identified from more general ones. I guess the professionals call themselves systems analysts because no one can pronounce systems synthesists! All joking aside, data modeling is an important method whereby various data structures of interest are brought together into one cohesive whole, relating different structures into relationships and thereby eliminating redundancies – making everyone’s lives a lot easier!

« « JSP Implicit and Session Objects
JSP Out Object » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Free Training

RSSSubscribe 394 Followers
  • Popular
  • Recent
  • Role of Data Modeling within Enterprise Management

    May 3, 2007 - 0 Comment
  • Data Modeling Introduction

    June 19, 2007 - 0 Comment
  • Connection between Data Model and Data Warehouse

    June 20, 2007 - 0 Comment
  • What is a Data Model

    January 11, 2007 - 0 Comment
  • The History of Data Modeling

    January 11, 2007 - 0 Comment
  • Data Modeling Explained

    January 31, 2007 - 0 Comment
  • Data Warehouse Glossary

    March 3, 2007 - 0 Comment
  • Entity Relationship Model

    April 23, 2007 - 0 Comment
  • Physical Data Models

    April 23, 2007 - 0 Comment
  • Tips for Mastering Data Modeling

    April 24, 2007 - 0 Comment
  • Connection between Data Model and Data Warehouse

    June 20, 2007 - 0 Comment
  • Data Modeling Introduction

    June 19, 2007 - 0 Comment
  • Role of Data Modeling within Enterprise Management

    May 3, 2007 - 0 Comment
  • Tips for Mastering Data Modeling

    April 24, 2007 - 0 Comment
  • Physical Data Models

    April 23, 2007 - 0 Comment
  • Entity Relationship Model

    April 23, 2007 - 0 Comment
  • Data Warehouse Glossary

    March 3, 2007 - 0 Comment
  • Data Modeling Explained

    January 31, 2007 - 0 Comment
  • The History of Data Modeling

    January 11, 2007 - 0 Comment
  • What is a Data Model

    January 11, 2007 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • Connection between Data Model and Data Warehouse
  • Data Modeling Introduction
  • Role of Data Modeling within Enterprise Management
  • Tips for Mastering Data Modeling
  • Physical Data Models

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2023. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptReject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT