Skip to content

Data Modeling II: Standard Data Model & Examples – SS2 Data Processing Lesson Note (First Term)

Lesson note at a glance

Class
SS2
Subject
Data Processing
Term
First Term
Reading time
4 min
Start of this note, 6 of 8
Take this term’s notes offline
Reading here is free. Download all 8 SS2 Data Processing First term notes as PDF to print and Word to edit.
Download all three terms, ₦2,000
Instant download. Secure payment by Paystack. Card, bank transfer, USSD or OPay. Payment stuck? WhatsApp us.

A standard data model, also called an industry standard data model (ISDM), is a data model that is widely used in an industry and shared among competitors to some degree.

Behavioural objectives

  1. State the importance of a data model.
  2. Define a standard data model.
  3. Name the industries where the most effective standard models have been developed.
  4. Explain why standard data models make information sharing easier.
  5. Give examples of standard data models.
Advertisement

What is a data model?

A data model is a diagram or set of rules that shows how data is structured, organised and related in a database.

  • Structure: it shows the items of data to be stored, such as student name, class and admission number.
  • Relationships: it shows how the items link, for example how a student links to a class.
  • Rules: it sets limits on the data, for example that an admission number must be unique.
  • Use: the structure is later built in a database management system (DBMS).

Why is a data model important?

A data model is important because it gives everyone involved in a database project one clear picture of the data.

  • Communication tool: it helps designers, programmers and end-users to interact and communicate.
  • Removes bias: it stops one party from forcing its own view of which data matters most.
  • Better understanding: a well-developed model improves understanding of the organisation the database is designed for.
  • Structure and organisation: it arranges data into structures that a DBMS can hold.
  • Decision making: organisations mostly use the resulting database to support decisions.
  • Constraints: it places limits, openly or implicitly, on the data stored in the structure.

What is a standard data model?

A standard data model is a data model that is widely applied in some industries and shared among competitors to some degree.

  • Shared: different organisations in the same industry use the same model.
  • Agreed: it carries a common vocabulary and agreed formats.
  • Defined by: standard bodies, database vendors or operating system vendors.

Who defines standard data models?

  • Standard bodies: organisations such as ISO that publish agreed standards.
  • Database vendors: companies that make database software.
  • Operating system vendors: companies that make operating systems.

In which industries have the most effective standard models been developed?

The most effective standard data models have been developed in four industries: banking, insurance, pharmaceutical and automotive.

Advertisement
  • Banking: customer records, such as account details, must be gathered and kept carefully.
  • Insurance: customer information is gathered and protected under strict rules.
  • Pharmaceutical: strict standards protect customer safety.
  • Automotive: just-in-time manufacturing needs parts and orders to be exchanged exactly on time.

Why did these industries develop strong standards?

  • Customer information gathering: data must be collected in a set way.
  • Customer privacy: personal data must be protected.
  • Customer safety: errors in data can harm people.
  • Just-in-time manufacturing: suppliers and makers must share exact data quickly.

Why do standard data models make information sharing easier?

Standard data models make information sharing easier and faster because organisations already agree on how data is described and exchanged.

  • Standard vocabulary: all parties use the same names for the same things.
  • Pre-negotiated semantics: the meaning of each data item is agreed in advance.
  • Agreed format: data is laid out in the same way by sender and receiver.
  • Quality standards: exchanged data must meet an agreed level of quality.
  • Less time: organisations do not need to negotiate terms each time they share data.

What is the difference between a standard and a non-standard data model?

A standard data model is shared by many organisations in an industry and defined by an outside body or vendor.

A non-standard (own) data model is designed by one organisation for its own use only.

Point Standard data model Own data model
Users Many organisations in an industry One organisation
Defined by Standard bodies or vendors The organisation itself
Vocabulary Shared and agreed Decided internally
Information sharing Easier and faster Needs extra agreement

What are examples of standard data models?

Three common examples of standard data models are ISO 10303, ISO 15926 and the IDEAS Group model.

  1. ISO 10303: an ISO standard for the computer-interpretable representation and exchange of product manufacturing information.
  2. ISO 15926: a standard for data integration, sharing, exchange and hand-over between computer systems.
  3. IDEAS Group: the International Defence Enterprise Architecture Specification for exchange Group. Its deliverable is a data exchange format for military Enterprise Architecture.

Evaluation

  1. What is a standard data model?
  2. Name the four industries in which the most effective standard models have been developed.
  3. Give two reasons why a data model is important.
  4. Why do standard data models make information sharing easier?
  5. What is ISO 10303 used for?

Assignment

List the three examples of standard data models given in this lesson and state in one sentence what each one is used for.

This term's Data Processing topics

SS2 First Term · 8 topics

  1. Database Management System I
  2. Database Management System II: How to Create Database
  3. Data Model
  4. Data Model II: Types of Data Modelling
  5. Data Modeling
  6. Data Modeling II: Standard Data Model & Examples
  7. Normalization
  8. Entity-Relationship Models
Advertisement

Lesson Notes for Other Classes

Print it or edit it in Word

Every note is free to read online. A PDF or Word copy of one subject costs ₦1,000 for one term, or ₦2,000 for all three terms.

Sign in first, then choose your class and subject at checkout.