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
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
- State the importance of a data model.
- Define a standard data model.
- Name the industries where the most effective standard models have been developed.
- Explain why standard data models make information sharing easier.
- Give examples of standard data models.
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.
- 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.
- ISO 10303: an ISO standard for the computer-interpretable representation and exchange of product manufacturing information.
- ISO 15926: a standard for data integration, sharing, exchange and hand-over between computer systems.
- IDEAS Group: the International Defence Enterprise Architecture Specification for exchange Group. Its deliverable is a data exchange format for military Enterprise Architecture.
Evaluation
- What is a standard data model?
- Name the four industries in which the most effective standard models have been developed.
- Give two reasons why a data model is important.
- Why do standard data models make information sharing easier?
- 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
- Database Management System I
- Database Management System II: How to Create Database
- Data Model
- Data Model II: Types of Data Modelling
- Data Modeling
- Data Modeling II: Standard Data Model & Examples
- Normalization
- Entity-Relationship Models

