The Concept of Data Model Pattern Based on Fully Communication Oriented Information Modeling (FCO-IM)

Fazat Nur Azizah, Benhard Sitohang, Guido P. Bakema, Oerip S. Santoso


Just as in many areas of software engineering, patterns have been used in  data modeling  to  create high quality  data  models.  We  provide  a  concept  of data  model  pattern  based  on  Fully  Communication  Oriented  Information Modeling  (FCO-IM),  a  fact  oriented  data  modeling  method.  A  data  model pattern is  defined  as  the relation  between  context, problem,  an d  solution.  This definition is adopted from the concept of pattern by Christopher Alexander. We define the concept of Information Grammar for Pattern (IG P) in the solution part of  a  pattern,  which  works  as  a  template  to  create  a  data  model.  The  IG P  also shows how a pattern can relate to other patterns. The data model pattern concept is then used to describe 15 data model patterns, organized into 4 categories. A case study on geographical location is provided to show the use of the concept in a real case.

Full Text:



Simsion, G. & Witt, G., Data Modeling Essentials, Third Edition, Morgan Kaufmann Publishers, 2005.

Hay, D.C., Data Model Patterns: A Convention of Thought, Dorset House Publishing, New York, 1996.

Silverston, L., The Data Model Resource Book, Revised Edition, (1&2), John Wiley & Sons Inc., 2001.

Coad, P., North D. & Mayfield, M., Object Models: Strategies, Patterns, and Applications, Prentice Hall, 1997.

Fowler, M., Analysis Patterns Reusable Object Models, Addison Wesley, 1996.

Nicola, J., Mayfield, M. & Abney, M., Streamlined Object Modeling: Patterns, Rules, and Implementation, Prentice Hall, 2001.

Bakema, G., Zwart, J. P. & Lek, H. van der, Fully Communication Oriented Information Modeling (FCO-IM), HAN University, 2002.

Azizah, F.N. & Bakema, G., Data Modeling Patterns using Fully Communication Oriented Information Modeling (FCO-IM), ORM Workshop 2006 (part of OnTheMove Federated Conferences and Workshops 2006), working papers, Montpellier, France, 2006.

Azizah, F.N., Bakema G.P., Sitohang, B. & Santoso, O.S., Generic Data Model Patterns using Fully Communication Oriented Information Modeling (FCO-IM), International Journal on Electrical Engineering and Informatics, (1), 2009.

Azizah, F.N., Bakema G.P., Sitohang, B. & Santoso, O.S., Information Grammar for Patterns (IGP) for Pattern Language of Data Model Patterns Based on Fully Communication Oriented Information Modeling (FCO-IM), 2010 ORM Workshop (part of 2010 OnTheMove Federated Conferences and Workshops), working papers, Crete, Greece, 2010.

Alexander, C., The Timeless Way of Building, Oxford University Press, USA, 1979.

Silberschatz A., Korth H.F. & Sudarshan S., Database System Concepts, Fourth Edition, McGraw Hill, 2002.

Appleton, B, Pattern and Software: Essential Concepts and Terminology,,(19/04/2006).

Liem, I. & Azizah, F. N., Metadata Approach in Modeling Multi Structured Data Collection Using Object Oriented Concepts, proceeding in International Conference on Networking and Information Technology (ICNIT) 2010, June 2010, Manila, Philippines.



  • There are currently no refbacks.

Contact Information:

ITB Journal Publisher, LPPM – ITB, 

Center for Research and Community Services (CRCS) Building Floor 7th, 
Jl. Ganesha No. 10 Bandung 40132, Indonesia,

Tel. +62-22-86010080,

Fax.: +62-22-86010051;