Developing Quality Complex Database Systems: Practices, Techniques and Technologies

Organizational Concepts and Measures for the Evaluation of Data Modeling  (pages 1-27)

This chapter presents a concept for the evaluation of data modeling which is based on existing theoretical approaches and three empirical studies conducted or supervised by the author. The main results of these studies with respect...

Dimensions of Database Quality  (pages 28-47)

Databases are a critical element of virtually all conventional and e-business applications. How does an organization know if the information derived from the database is any good? To ensure a quality database application, should the...

Metrics for Controlling Database Complexity  (pages 48-68)

Software engineers have been proposing large quantities of metrics for software products, processes and resources (Fenton and Pfleeger, 1997; Melton, 1996; Zuse, 1998). Metrics are useful mechanisms in improving the quality of...

Integrating Hypermedia Functionality into Database Applications  (pages 69-99)

The general goal of our research is to automatically generate links and other hypermedia-related services to analytical applications, such as geographic information systems and decision support systems. Using a dynamic hypermedia...

Optimization of the Knowledge Discovery Process in very Large Databases  (pages 100-124)

Current database technology involves processing a large volume of data in order to discover new knowledge. The high volume of data makes the discovery process computationally expensive. In addition, real-world databases tend to be...

Some Issues in Design of Data Warehousing Systems  (pages 125-172)

Information is one of the most valuable assets of an organization, and when used properly can assist intelligent decision-making that can significantly improve the functioning of an organization. Data warehousing is a recent...

Data Mining for Supply Chain Management in Complex Networks: Concepts, Methodology and Application  (pages 173-193)

The concept and philosophy behind supply chain management is to integrate and optimize business processes across all partners in the entire production chain. Since these are not simple supply chains but rather complex networks...

Accommodating Hierarchies in Relational Databases  (pages 194-209)

Relational databases and the current SQL standard are poorly suited to retrieval of hierarchical data. After demonstrating the problem, this chapter describes how two approaches to data denormalization can facilitate hierarchical...

Object-Oriented Database Design  (pages 210-239)

In spite of the fact that relational databases still hold the first place in the market, object-oriented databases are becoming, each day, more widely accepted. Relational databases are suitable for traditional applications...

INTECoM: An Integrated Approach to the Specification and Design of Information Requirements  (pages 240-260)

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...

Inclusion Dependencies  (pages 261-278)

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...

Semantically Modeled Databases in Integrated Enterprise Information Systems  (pages 279-302)

In the past several years, huge investments have been made in enterprise resource planning (ERP) systems and related applications. While the integrated database and data warehouse in such systems provides value, more value could be...

Set Comparison Queries in SQL  (pages 303-316)

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 resorting to an intermediary, the programmer, in retrieving information from the...

Toward a Framework for Advanced Query Processing  (pages 317-330)

The contribution of our approach is that we develop a framework for processing and answering queries flexibly by applying data mining techniques. In addition, we suggest strategies to reduce the computational complexity of the...

Security in Database Systems: State of the Art  (pages 331-349)

Rapid technological advances in communications, transport, banking, manufacturing, medicine and other fields are demanding more sophisticated information requirements in organizations worldwide. As a result, large quantities of data...

A Case Study of the Military Utility of Telemedicine  (pages 350-365)

In order to meet the medical management challenges presented by increasing global crises, the U.S. military must find ways to more effectively manage manpower and time. In response, Joint Medical Operations –Telemedicine (JMO-T) has...