We are now in a position to provide a single picture (Figure 1.5) of the various
components of a database system and the connections among them.
The architecture of a database system is greatly influenced by the underlying
computer...
Transaction Management
Often, several operations on the database form a single logical unit of work. An
example is a funds transfer, as in Section 1.2, in which one department account
(say A) is debited and another department account...
Data Storage and Querying
A database system is partitioned into modules that deal with each of the re-
sponsibilities of the overall system. The functional components of a database
system can be broadly divided into the storage manager and the query...
Database Design
Database systems are designed to manage large bodies of information. These large
bodies of information do not exist in isolation. They are part of the operation of
some enterprise whose end product may be information from the...
Relational Databases
A relational database is based on the relational model and uses a collection of
tables to represent both data and the relationships among those data. It also in-
cludes a DML and DDL. In Chapter 2 we present a gentle introduction...
Database Languages
A database system provides a data-definition language to specify the database schema and a data-manipulation language to express database queries and up dates. In practice, the data-definition and data-manipulation...
View of Data
At the logical level, each such record is described by a type definition, as
in the previous code segment, and the interrelationship of these record types is
defined as well. Programmers using a programming language work at...
