Database Systems

Paul Beynon-Davies1-4039-1601-2, 9781403916013

The main aim of this work is to provide one readable text of essential core material for most higher education and commercial courses on database systems. The book was developed from the author’s experiences of running a number of academic and commercial courses on database technology for more than seven years. The text is organised into a number of parts. The introductory chapters set the scene for the core of the text. First, the key features of a database system are described. Then some key concepts are defined. Part one explores a number of contemporary architectures for database systems. Because of its current dominance, particular emphasis is given to the relational data model. Part two provides a description of the major elements of a contemporary relational database management system: interface, kernel and toolkit. The issue of distributed database systems is also addressed. The part concludes by reviewing two existing DBMS: one relational; the other object-oriented. Part three presents a discussion of the major techniques utilised in the design and implementation of database systems. The issue of administering data in organisations is also considered. Part four considers new applications for databases. It consists of three chapters which look at areas that have a significant effect on the functionality of database systems: the issue of parallelism (contributed by Professor Frank Sumner), the issue of embedded ‘intelligence’ and handling complex data.

---

Table of contents :
Team-kB……Page 1
Contents……Page 6
FUNDAMENTALS……Page 16
1 Database Systems as Abstract Machines……Page 18
2 Data and Information……Page 34
3 Database, DBMS and Data Model……Page 45
4 Database Systems, ICT Systems and Information Systems……Page 63
5 Database Systems and Electronic Business……Page 77
6 Data Management Layer……Page 91
DATA MODELS……Page 102
7 Relational Data Model……Page 104
8 Object-Oriented Data Model……Page 128
9 Deductive Data Model……Page 140
10 Post-Relational Data Model……Page 158
DATABASE MANAGEMENT SYSTEMS ( DBMS) – INTERFACE……Page 170
11 SQL – Data Definition……Page 172
12 SQL – Data Integrity……Page 183
13 SQL – Data Manipulation……Page 192
DATABASE DEVELOPMENT……Page 208
14 Database Development Process……Page 210
15 Requirements Elicitation……Page 223
16 Entity–Relationship Diagramming……Page 234
17 Object Modelling……Page 261
18 Normalisation……Page 284
19 Physical Database Design……Page 307
20 Database Implementation……Page 324
PLANNING AND ADMINISTRATION OF DATABASE SYSTEMS……Page 336
21 Strategic Data Planning……Page 338
22 Data Administration……Page 349
23 Database Administration……Page 358
DATABASE MANAGEMENT SYSTEMS ( DBMS) – TOOLKIT……Page 370
24 DBMS-Toolkit – End-User Tools……Page 372
25 DBMS-Toolkit – Application Development Tools……Page 380
26 DBMS-Toolkit – Database Administration Tools……Page 390
DATABASE MANAGEMENT SYSTEMS – KERNEL……Page 396
27 Data Organisation……Page 398
28 Access Mechanisms……Page 410
29 Transaction Management……Page 418
30 Other Kernel Functions……Page 433
DATABASE MANAGEMENT SYSTEMS – STANDARDS AND COMMERCIAL SYSTEMS……Page 440
31 Post-Relational DBMS – SQL3……Page 442
32 Object-Oriented DBMS – ODMG Object Model……Page 451
33 Microsoft Access……Page 461
34 ORACLE……Page 472
35 O2 DBMS……Page 482
TRENDS IN DATABASE TECHNOLOGY……Page 490
36 Distributed Processing……Page 492
37 Distributed Data……Page 501
38 Parallel Databases……Page 513
39 Complex Data……Page 527
APPLICATIONS OF DATABASE SYSTEMS……Page 540
40 Data Warehousing……Page 542
41 On-Line Analytical Processing……Page 554
42 Data Mining……Page 562
43 Databases and the Web……Page 569
BIBLIOGRAPHY……Page 582
GLOSSARY AND INDEX……Page 587