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
 

Tips for Mastering Data Modeling

By Exforsys | on April 24, 2007 |
Data Modeling

Tips for Mastering Data Modeling

Data modeling refers to the process where by 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 to manage vast amounts of 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.

Data models are highly flexible structures that can be employed to meet a variety of ends. In same ways, the process of data modeling can be compared to class modeling, the difference being that whereas in class modeling, classes are identified, in data modeling, types are identified.

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.

Below, you will find some useful tips for building effective data models.

-When you’re naming the entities, aim for clarity and cohesion. Make sure the name is a clear representation of the thing. By using normal English (or Spanish, whatever language you’re working in), you eliminate a lot of confusion in advance. It is also to keep in mind who you’re designing the model for, i.e. your audience. Therefore the entity names should be universally recognizable by all. Steer clear of acronyms, table names, and abbreviations. Accompany each entity name with a concise, clear definition in the dictionary.

-If you have not had time to analyze an identified entity, be sure to state that in the dictionary. Try to come back to it as soon as possible. You should strive to identify all possibly relationships.

-Each time an entity occurs, it should be marked with the use of a sub-type. Each entity’s occurrence should only appear in that singular sub-type. Never use a sub-type where an example would function better. Using a sub-type implies that it has relationships that distinguish it from others and that the division of entities into sub-types is a stable form of organizing the data.



-Weak relationship names should be avoided at all costs. You don’t need to use statements like related to; the fact that it is a relationship makes this point pretty clear. A gerund can be employed if need be, but only as a last resort. In general, concreteness should always be striven for, so that the client may easily correct it if it is not 100% accurate.

-The drawing should be organized in a way so that it will be attractive visually. Always give equal weight to both sides of the diagram. White spaces should be left with discretion. Make sure different elements are not crowded together unless they absolutely have to be.

-The overall model should be broken into different topics. That way, each diagram only concerns at most two subjects. The drawings should be organized in a way that each one represents a whole “logical horizon.”

– If you are building a model for publication, laying it out in “portrait” is a lot better. But if it’s just for the screen, choose “landscape” form – it is a lot more efficient. Whatever you choose, make sure it is used consistently throughout all the diagrams.

« « Physical Data Models
JavaScript Features » »

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
  • 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
  • Role of Data Modeling within Enterprise Management

    May 3, 2007 - 0 Comment
  • Data Modeling Overview

    May 4, 2007 - 0 Comment
  • Data Modeling Introduction

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

    June 20, 2007 - 0 Comment
  • Data Modeling Introduction

    June 19, 2007 - 0 Comment
  • Data Modeling Overview

    May 4, 2007 - 0 Comment
  • Role of Data Modeling within Enterprise Management

    May 3, 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
  • Data Modeling Overview
  • Role of Data Modeling within Enterprise Management
  • 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