INTECoM: An Integrated Approach to the Specification and Design of Information Requirements

INTECoM: An Integrated Approach to the Specification and Design of Information Requirements

Clare Atkins (Massey University, New Zealand)
DOI: 10.4018/978-1-878289-88-9.ch010
OnDemand PDF Download:


An important contributor to the success of any complex database development is the comprehensive and accurate capture and recording of the users’ information requirements. Indeed, both the technical and economic success of the system under development is likely to rest largely on the quality of the data structure design and the information requirement analysis on which it is based. The data models, which represent the results of the analysis and design activities necessary to achieve this quality outcome, are therefore critical components of the database development process. Nevertheless, research suggests that this modeling is not always done well and in some cases is not done at all (e.g., Hitchman, 1995). However, implicit in the creation of a database is the design of a data model, and thus the only optional feature is the level of formality that has been followed in its development (Simsion, 1994). Since the publication of Chen’s (1976) original description of an Entity-relationship (E-R) model, a significant amount of academic research into data modeling has concentrated on providing ever richer, more complex and more formal models with which to better represent reality (Hirschheim, Klein & Lyytinen, 1995). In addition, researchers and practitioners have also recognized the importance of data models as a means of communication. However, little attention has been given to examining the appropriateness of various modeling techniques to the very different requirements of the analysis and design activities that they support, although matching tools to activities would seem to be an essential prerequisite for success. The INTECoM framework, described in this chapter, was developed to emphasize and better serve the differing nature of these activities, and also to improve access for all users to both the process and the outcome of data modeling. The framework was initially instantiated with two widely used data modeling techniques, the NIAM-CSDP (Natural Language Information Analysis-Conceptual Schema Design Procedure) and the Entity-Relationship (E-R) approach. This instantiation was chosen primarily because the two techniques represent significantly different ways of working (Bronts, Brouwer, Martens & Proper, 1995) towards the construction of a relational database. This is not to suggest that other instantiations are not possible or desirable, particularly where the target DBMS is of a different paradigm.

Complete Chapter List

Search this Book:
Table of Contents
Chapter 1
Ronald Maier
This chapter presents a concept for the evaluation of data modeling which is based on existing theoretical approaches and three empirical studies... Sample PDF
Organizational Concepts and Measures for the Evaluation of Data Modeling
Chapter 2
John A. Hoxmeier
Databases are a critical element of virtually all conventional and e-business applications. How does an organization know if the information derived... Sample PDF
Dimensions of Database Quality
Chapter 3
Coral Calero, Mario Piattini, Marcela Genero
Software engineers have been proposing large quantities of metrics for software products, processes and resources (Fenton and Pfleeger, 1997;... Sample PDF
Metrics for Controlling Database Complexity
Chapter 4
Anirban Bhaumik, Deepti Dixit, Roberto Galnares, Aparna Krishna, Michael Bieber, Vincent Oria, Firas Alljalad
The general goal of our research is to automatically generate links and other hypermedia-related services to analytical applications, such as... Sample PDF
Integrating Hypermedia Functionality into Database Applications
Chapter 5
M. Mehdi Owrang O.
Current database technology involves processing a large volume of data in order to discover new knowledge. The high volume of data makes the... Sample PDF
Optimization of the Knowledge Discovery Process in very Large Databases
Chapter 6
Ladjel Bellatreche, Kamalakar Karlapalem, Mukesh Mohania
Information is one of the most valuable assets of an organization, and when used properly can assist intelligent decision-making that can... Sample PDF
Some Issues in Design of Data Warehousing Systems
Chapter 7
Manoj K. Singh, Mahesh S. Raisinghani
The concept and philosophy behind supply chain management is to integrate and optimize business processes across all partners in the entire... Sample PDF
Data Mining for Supply Chain Management in Complex Networks: Concepts, Methodology and Application
Chapter 8
Ido Millet
Relational databases and the current SQL standard are poorly suited to retrieval of hierarchical data. After demonstrating the problem, this chapter... Sample PDF
Accommodating Hierarchies in Relational Databases
Chapter 9
Esperenza Marcos, Paloma Caceres
In spite of the fact that relational databases still hold the first place in the market, object-oriented databases are becoming, each day, more... Sample PDF
Object-Oriented Database Design
Chapter 10
Clare Atkins
An important contributor to the success of any complex database development is the comprehensive and accurate capture and recording of the users’... Sample PDF
INTECoM: An Integrated Approach to the Specification and Design of Information Requirements
Chapter 11
Inclusion Dependencies  (pages 261-278)
Laura C. Rivero, Jorge H. Doorn, Viviana E. Ferraggine
The evaluation of conceptual schemes of actual databases may result in the discovery of inclusion dependencies. An inclusion dependency is defined... Sample PDF
Inclusion Dependencies
Chapter 12
Cheryl L. Dunn, Severin V. Grabiski
In the past several years, huge investments have been made in enterprise resource planning (ERP) systems and related applications. While the... Sample PDF
Semantically Modeled Databases in Integrated Enterprise Information Systems
Chapter 13
Mohammod Dadashzadeh
One of the most important promises of the relational data model has been that it frees the decision maker, the manager, from the necessity of... Sample PDF
Set Comparison Queries in SQL
Chapter 14
Suk-Chung Yoon
The contribution of our approach is that we develop a framework for processing and answering queries flexibly by applying data mining techniques. In... Sample PDF
Toward a Framework for Advanced Query Processing
Chapter 15
Eduardo Fernandez-Medina Paton, Mario G. Piattini
Rapid technological advances in communications, transport, banking, manufacturing, medicine and other fields are demanding more sophisticated... Sample PDF
Security in Database Systems: State of the Art
Chapter 16
David J. Paper, James A. Rodger, Parag C. Pendharkar
In order to meet the medical management challenges presented by increasing global crises, the U.S. military must find ways to more effectively... Sample PDF
A Case Study of the Military Utility of Telemedicine
About the Authors