Channel

Channel Sponsored by

Data modeling is the process of designing and validating a database that will be used to meet a business challenge. Data modelers use terms and symbols to identify and represent all of the data objects needed for a business operation to function.

Data models document entities (the persons, places and things [product, warehouse, partner etc.] an organization encounters in the course of business); the relationships of entities (e.g. employee WORKS in warehouse, MANAGES product and SHIPS to partner); and the attributes of entities (description, order number, address, account balance etc.).

There are three common types of data models. Conceptual data models define and describe business concepts at a high level for stakeholders addressing a business challenge. Logical data models are more detailed and describe entities, attributes and relationships in business terms. Physical data models define database objects, schema and the actual columns and tables of data that will be created in the database.

Like the blueprint of a building, a data model is the design specification for a database. Data modeling can be helped by off the shelf data models that can be adapted to a specific use. But data architects warn that without proper time and attention to "design before you build," organizations face inaccurate reporting, incorrect data, costly remediation and difficulty in meeting new user requirements.

Federated Data Models Can Accelerate Data Integration

Traditional approaches to data integration alone are no match for today’s increasingly complex information environments and accelerated business pace

Creating a Successful High-Level Data Model

The ten steps for completing the high-level data model

10 Easy Steps to Evaluate Data Modeling Tools

How do you sort through all of the conflicting messages to choose the tool that is right for you?

How High-Level Data Modeling Fits with Other Data Initiatives

A brief overview of the hot topics in data management and discussion of how a high-level data model can help with siloed projects or programs

Is Notation Important?

A picture is worth a thousand words, as they say, and it is important that the layout and formatting of your high-level data model is intuitive and easy to understand

• More Articles

The Qualified Data Modeler

Building a data model that is correct from a business perspective takes more than structural modeling skills

How Long Will the Modeling Take?

Design challengers share techniques to estimate the modeling portion of projects

Who Owns the Data Model?

Does the business, the development team, the individual developer, the application manager, database administrator, own the model?

Real Definitions versus Nominal Definitions in Data Management

Concepts, rather than words, are important to data modelers

Data Modeling in the Cloud

Will the cloud make our data management jobs easier or harder?

• More Columns

Combining Data Profiling and Data Modeling for Better Data Quality

Metadata Management for Enterprise Applications

By Neil Buchwalter

How Data Warehousing Challenges Can Be Resolved Through Modelling

Market-Leading Data-Modeling Tools

Modeling Unstructured Data: An Independent Perspective

• More White Papers

Data Modeling for the Business: A Handbook for Aligning the Business with IT using High-Level Data Models

By Steve Hoberman, Donna Burbank and Chris Bradley

Information Modeling and Relational Databases

By Terry Halpin, Tony Morgan

Data Modeling Fundamentals: A Practical Guide for IT Professionals

By Paulraj Ponniah

• More Books

• Database Design and Modeling: Getting it Right the First Time
  In the world of databases, “getting it right” is a phrase filled with ambiguity, for who can say what “right” truly is? Frankly, it’s a lot easier to spot “bad” or “not right” database schemas than it is to confirm that a database schema is “right”. While schema design is the foundation of a well-performing database, you are missing opportunities if schema design doesn’t also take database performance, administration and backup/recovery into consideration.
• Demonstrating the ROI of Data Discovery
  Data Discovery and Profiling is a relatively new data management technique that uses tools to identify all data sources throughout the organization and unearth the meaning of the information itself. As with any new paradigm, today’s budget holders and decision makers must first be educated on data discovery and profiling and then shown the value it can bring to the organization through a clear return on investment (ROI) analysis.
• Creating Enterprise Data Standards with CA ERwin Modeling
  Join this webcast to see how CA ERwin Modeling solutions can help you create reusable enterprise standards. Topics include:
  - Leveraging Naming Standards and Domains
  - Using ERwin Model Templates
  - Defining Data Type Standards
  - Sharing Standards using CA ERwin Model Manager
  - Reporting to Stakeholders using Crystal Reports
  
• The Return on Investment (ROI) of Data Modeling
  Data modeling is a time-proven method for understanding data, its interrelationships and its rules. Data management professionals have long understood the value of data modeling. However, business professionals often don’t understand the value of data modeling. So how can you demonstrate to business management the return on investment (ROI) of data modeling? Read this white paper and find out.

• Find Data Modeling products & services on Information Management Marketplace

Articles from this Site

• $100 Million Solution: Basel III Leading to "Massive System Upgrades"
• Pentaho Revs Data Integration
• Models Getting a Little Long in the Tooth
• Stanford To Open High-Security Data Center For Census Research
• HP, Microsoft in $250 Million Partnership
• More Articles from this Site

---

White Papers

• Market-Leading Data-Modeling Tools
• How Data Warehousing Challenges Can Be Resolved Through Modelling
• Tightening the Alignment Between Business and IT through Modeling
• Combining Data Profiling and Data Modeling for Better Data Quality
• Modeling Unstructured Data: An Independent Perspective
• More White Papers

---

Web Seminars

• The Learning Curve: BI and DW Data Modeling
• The Learning Curve: Conceptual Data Modeling
• Creating a Safer, Smarter Pharmaceutical Supply Chain
• Streamlining the Business of Healthcare Through Effective Information Delivery
• Clinical Analytics and the Unified Electronic Health Record
• More Web Seminars

---

eLearning

• The Data Model Scorecard
• More eLearning

---

Books

• Data Modeling for the Business: A Handbook for Aligning the Business with IT using High-Level Data Models
• Information Modeling and Relational Databases
• Data Modeling Fundamentals: A Practical Guide for IT Professionals
• Arc Marine: GIS for a Blue Planet
• Data Modeling Theory and Practice
• More Books