The Orange Report ISO TR9007 (1982 - 1987) Grandparent of the Business Rules Approach and SBVR Part 1 - History of the ISO TC97/SC5/WG3 Working Group

Joost J.  Van Griethuysen
Joost J. Van Griethuysen Member, Board of the Dutch SBVR Foundation Read Author Bio || Read All Articles by Joost J. Van Griethuysen

Abstract

The ISO Orange Report TR 9007Concepts and Terminology for the Conceptual Schema and the Information Base is a widely acclaimed early publication that recognized the importance of formalizing semantics of information:  To understand the information needs of an enterprise we need models of the enterprise, the things and affairs it must know about, and the parts of the enterprise involved in information exchanges.  This column is the first in a series giving some of the history of the Orange Report and summarizing its basic subjects.  In this instalment the author introduces the Orange Report, laying the background with a little prehistory.

Figure 1.  The Orange Report, one of the ancestors — in daily life one normally has several.

A Little Prehistory

As in all archeological and historical research, only fragments of the true story are uncovered or presented.  In this paper it will not be different.  Therefore if anyone feels unhappy about not being mentioned or about someone else not being given proper recognition, I apologize and invite her or him to contribute to the reporting of our history.

In The Netherlands some early applications of Interpreted Predicate Logic to specify and implement a system to control an enterprise unit — a business — were the control of a railway bridge, the body maker in a tin can production line, a paper mill that produced paper rolls for journals, and a testing line of bi-metal temperature switches.  That was in 1966 and 1967.  The inspiration came from the teaching of logic by the Dutch mathematician and logician Freudenthal, the practical opportunity from Philips who produced in those days a "predecessor" of a chip that contained a logical switching circuit — the Norbit.

A next step in The Netherlands followed in 1969 at Philips Electrologica — the later Philips Data Systems — where the problems and possibilities of large information storage and retrieval systems were studied.  Here, inspired by a paper of Langefors,[LANG1966] we initiated the idea of separating the functionality of information — what we now call the semantics — from the logical form — the logical data base — and the physical implementation in the computer storage means — the physical data base.  The role and support of Herman Schweigman and Gerard Verstraten in this should certainly be acknowledged.

A first attempt was made to apply predicate logic to describe the functionality, but the computer programmers preferred to translate it directly into software using the SPL programming language (a Philips Electrologica improvement on PL1).  The practical results lead up to PHOLAS, the Philips Database Management System that around 1971–1972 was the first implementation of the ANSI/SPARC Three Schemata Approach "avant la lettre."  Within Philips Data System we spoke first of the Functional, Logical, and Physical levels, and later of the Information, Data, and Storage levels.

Later, Pholas was taken over by Siemens as their UDSV2 Data Base Management System and used by them and their customers well into the eighties (and perhaps nineties).  It remained in use extensively within Philips, the big computer user.[GRIET1976] [GRIET1977]

Here the research continued into predicate logic as a means to formulate the requirements of a data base system to meet the needs of an enterprise.[GRIET1978]  Training in this approach in various natural languages (indeed:  in Dutch, English, French, Italian, Spanish, and Brazilian Portuguese) was given within Philips all over the world.

In the meantime, in the USA, various developments in the area of data base processing were going on.  Among these, in late 1972, the Standards Planning and Requirements Committee (SPARC) of the American National Standards Committee on Computers and Information Processing (ANSI/X3) established an Ad Hoc Study Group on Data Base Management Systems.  Important members of this group were Charlie Bachman, Don Jardine, and Tom B. Steel Jr.  The group published in 1975 an interim report[ANSI1975] in which the Three Level Architecture with the Conceptual, the External, and the Internal schemata were introduced.

It was Tom Steel himself who later told me that at an early conference of the group a Philips Data Systems representative provided a cross fertilization that inspired the group to this Three Level Architecture and that therefore one of its important roots was in Apeldoorn, The Netherlands.

A Little History — The ISO TC97/SC5/WG3 Working Group

At its meeting in November 1977 the ISO committee on Programming Languages (Sub Committee 5 of Technical Committee 97) resolved to create a Working Group on the aspects of conceptual schemata for Data Base Management Systems.

In the following years (1978–1985) this Working Group, known as ISO TC97/SC5/WG3, held 16 Meetings in which 48 members from 15 countries participated.  They represented various backgrounds in scientific work on mathematics, logics, and information technology, and/or had theoretical and practical experience in enterprise analysis, software engineering, and the application of information systems and data base techniques.  Many of them were well known and often considered leaders in their subjects and therefore were invited to join.  I was invited to join the group because of my Philips PHOLAS background, my other background not being known outside Philips then.

Tom Steel — AT & T, USA — was its first Convener; later Don Jardine — Queen's University, Kingston, Canada — took over.

The group produced in accordance with their charter two reports.

The first and foremost important report is the report Concepts and Terminology for the Conceptual Schema and the Information Base.  A draft form was published in 1981, and the final version was first published in 1982 as ISO TC97/SC5/WG3 N695.  It is known as "The Orange Report"  because of the colour of its cover:  Orange and yellow (the colour of its binding) were in those days the only ISO standardized colours.  The Report was later (in 1987) formally published by ISO as its Technical Report TR 9007.[ISO1982]  Regretfully the orange cover was replaced by the standard ISO document cover.  However it is still best known as The Orange Report.

A second report — ISO TC97/SC21 N 236, with the title Assessment Guidelines for Conceptual Schema Language Proposals — was published in 1985.[ISO1985]  This report contains, as well as a summary of the basic principles and concepts published in the Orange Report, an extensive list of requirements to which any Conceptual Schema Language should adhere.

Copyright ©2008 J J van Griethuysen


Next time, we will examine the seven very fundamental principles that the Working Group developed over the course of their meetings.

References

[ANSI1975]  ANSI/X3/SPARC, Study Group on Data Base Management Systems: Interim Report 75-02-08.  In:   ACM SIGMOD Newsletter, FDT, Vol.7, No. 2, 1975. return to article

[GRIET1976]  J.J. van Griethuysen, J.Peeters, W.Demmenie, H.Bosman, The Structure of a PHOLAS database and its control information.  Internal Philips Publication, 1976. return to article

[GRIET1977]  J.J. van Griethuysen, M.Huits, H.Slavin, Data Structures in CODASYL Databases.  Internal Philips Publication, 1977. return to article

[GRIET1978]  J.J. van Griethuysen, Notation Methods for an Information Model.  Internal Philips Publication, 1978. return to article

[ISO1982]  ISO/TC97/SC5/WG3 (J.J. van Griethuysen, ed.), Concepts and Terminology for the Conceptual Schema and the Information Base, Report No. ISO/TC97/TR9007, International Standards Organization, Central Secretariat, Geneva, Switzerland, 1987 (originally published in 1982). return to article

[ISO1985]  ISO/TC97/SC5/WG3 (J.J. van Griethuysen, M.H. King, eds.), Assessment Guidelines for Conceptual Schema Language Proposals, ISO/TC97/SC21 N 236, ANSI, New York, 1985. return to article

[LANG1966]  B. Langefors, Theoretical Analysis of Information Systems, Student Litteratur, Lund, 1966. return to article

# # #

Standard citation for this article:


citations icon
Joost J. Van Griethuysen , "The Orange Report ISO TR9007 (1982 - 1987) Grandparent of the Business Rules Approach and SBVR Part 1 - History of the ISO TC97/SC5/WG3 Working Group" Business Rules Journal Vol. 10, No. 4, (Apr. 2009)
URL: http://www.brcommunity.com/a2009/b474.html

About our Contributor:


Joost  J. Van Griethuysen
Joost J. Van Griethuysen Member, Board of the Dutch SBVR Foundation

Joost’s first contact with — first generation — computers was in the late fifties, and he became totally fascinated with those electronic devices that could help thinking. After his studies of electronics, mathematics, and logic (then considered a remarkable combination — Computer Science did not yet exist as a subject) he began as an electronics engineer for computer hardware, but soon in the late sixties he changed to software engineering, specializing in information system design and information engineering. He was one of the first to use formal logic as a basis for information engineering and enterprise modelling.

In ISO TC97/SC5/WG3 - Conceptual Schema, he was the editor and as well as a co-author of the ISO Report TR9007 "Concepts and Terminology for the Conceptual Schema and Information Base." Later, he was the first Convener of ISO/IEC JTC1/SC21/WG7 - Open Distributed Processing (ODP). He participated in many other groups on Data Base Technology and Information System Design.

Since his retirement from Philips in the nineties Joost has concentrated particularly on his other profession/passion: Marine Painting. However, he still is very much interested in the subject of conceptual modelling, enterprise modelling, and SBVR. He is member of the Board of the Dutch SBVR Foundation. He is, of course, a member of the Business Rules Community. Joost can be reached at Joost@mmj-atelier.nl.

Read All Articles by Joost J. Van Griethuysen

Online Interactive Training Series

In response to a great many requests, Business Rule Solutions now offers at-a-distance learning options. No travel, no backlogs, no hassles. Same great instructors, but with schedules, content and pricing designed to meet the special needs of busy professionals.