Inclusion Dependencies

Inclusion Dependencies

Laura C. Rivero (Universidad Nacional del Centro de la Provincia de Buenos Aires, Argentina), Jorge H. Doorn (Universidad Nacional de la Plata, Argentina) and Viviana E. Ferraggine (Universidad Nacional del Centro de la Provincia de Buenos Aires, Argentina)
DOI: 10.4018/978-1-878289-88-9.ch011
OnDemand PDF Download:


The evaluation of conceptual schemes of actual databases may result in the discovery of inclusion dependencies. An inclusion dependency is defined as the existence of attributes in a table whose values must be a subset of the values of attributes in another table. When the latter set conforms a key for its table, the inclusion dependency is key-based. Key-based inclusion dependencies are fully enforced by most current database systems. On the contrary, if the second set is not the key of the relation, the inclusion dependency is non-key-based. This kind of inclusion dependency is completely disregarded by actual systems, obliging the users to manage them via special-case code or triggers. This implies an excessive effort to maintain integrity and develop applications, among other inconveniences. The chapter goal is to give a heuristics to redesign the conceptual schema. This is based on the identification of hidden business rules and the conversion of non-key inclusion dependencies into key-based ones.

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