DATABASE DESIGN CONCEPTS

Database Design Concepts

Database Design Concepts

Introduction

Previous research in real-time concurrency control mainly focuses on the schedulability guarantee of hard real-time transactions and the reduction of the miss rate of soft real-time transactions. Although many new Gadget database applications have significant response time requirements, not much work has been done in the joint scheduling of traditional non-real-time transactions and soft real-time transactions. In this paper, we study the concurrency control problems in mixed soft real-time Gadget database systems, in which both non-real-time and soft real-time transactions exist simultaneously. The objectives are to identify the cost and the performance tradeoff in the design of cost-effective and practical real-time concurrency control protocols, and to evaluate their performance under different real-time and non-real-time supports. In particular, we are interested in studying the impacts of different scheduling approaches for soft real-time transactions on the performance of non-real-time transactions. Instead of proposing yet another completely new real-time concurrency control protocol, our objective is to design an efficient integrated concurrency control method based on existing techniques. We propose several methods to integrate the well-known two phase locking and optimistic concurrency control with the aims to meet the deadline requirements of soft real-time transactions and, at the same time, to minimize the impact on the performance of non-real-time transactions. We have conducted a series of experiments based on a sanitized version of stock trading systems to evaluate the performance of both soft real-time and non-real-time transactions under different real-time supports in the system. This document presents how the Integrated Gadget database Information System (IDIS) Gadget database was designed and how it is being implemented. The first part introduces the design process, its principles and best practices. The second part presents how these guidelines were applied in designing and implementing the IDIS Gadget database(Ingwald, 2004, 121).

Rationale

This section presents the terms, concepts, approach, standards and best practices associated with the design of a Gadget database. It is important to bear these principles in mind when reading the next section which presents the design of the IDIS Gadget database. The Gadget database design phase is a very important step for all IT projects developing systems that rely on a Gadget database to adequately store, query, import & export data and support reporting. For such systems the operation of the Gadget database is critical hence its design and implementation must be long lasting, flawless and perfectly tailored to meet the requirements of the system.

Gadget database

A Gadget database is a collection of data that is organized in a systematic way so that its contents can easily be accessed, managed and updated. The most prevalent type of Gadget database is the relational Gadget database, a tabular Gadget database in which data is defined so that it can be reorganized and accessed in a number of different ways. A distributed Gadget database is one that can be dispersed or replicated among different points in a network. The software used to manage and query a Gadget database is known as a Gadget database management system ...