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.
Author(s): Paul Beynon-Davies
Edition: 3rd
Publisher: Palgrave
Year: 2003
Language: English
Pages: 616
CONTENTS......Page 6
PREFACE TO THE THIRD EDITION......Page 10
PART 1 FUNDAMENTALS......Page 16
CHAPTER 1 DATABASE SYSTEMS AS ABSTRACT MACHINES......Page 18
CHAPTER 2 DATA AND INFORMATION......Page 34
CHAPTER 3 DATABASE, DBMS AND DATA MODEL......Page 45
CHAPTER 4 DATABASE SYSTEMS, ICT SYSTEMS AND INFORMATION SYSTEMS......Page 63
CHAPTER 5 DATABASE SYSTEMS AND ELECTRONIC BUSINESS......Page 77
CHAPTER 6 DATA MANAGEMENT LAYER......Page 91
PART 2 DATA MODELS......Page 102
CHAPTER 7 RELATIONAL DATA MODEL......Page 104
CHAPTER 8 OBJECT-ORIENTED DATA MODEL......Page 128
CHAPTER 9 DEDUCTIVE DATA MODEL......Page 140
CHAPTER 10 POST-RELATIONAL DATA MODEL......Page 158
PART 3 DATABASE MANAGEMENT SYSTEMS (DBMS) – INTERFACE......Page 170
CHAPTER 11 SQL – DATA DEFINITION......Page 172
CHAPTER 12 SQL – DATA INTEGRITY......Page 183
CHAPTER 13 SQL – DATA MANIPULATION......Page 192
PART 4 DATABASE DEVELOPMENT......Page 208
CHAPTER 14 DATABASE DEVELOPMENT PROCESS......Page 210
CHAPTER 15 REQUIREMENTS ELICITATION......Page 223
CHAPTER 16 ENTITY–RELATIONSHIP DIAGRAMMING......Page 234
CHAPTER 17 OBJECT MODELLING......Page 261
CHAPTER 18 NORMALISATION......Page 284
CHAPTER 19 PHYSICAL DATABASE DESIGN......Page 307
CHAPTER 20 DATABASE IMPLEMENTATION......Page 324
PART 5 PLANNING AND ADMINISTRATION OF DATABASE SYSTEMS......Page 336
CHAPTER 21 STRATEGIC DATA PLANNING......Page 338
CHAPTER 23 DATA ADMINISTRATION......Page 349
PART 6 DATABASE MANAGEMENT SYSTEMS (DBMS) –TOOLKIT......Page 370
CHAPTER 24 DBMS-TOOLKIT – END-USER TOOLS......Page 372
CHAPTER 25 DBMS-TOOLKIT – APPLICATION DEVELOPMENT TOOLS......Page 380
CHAPTER 26 DBMS-TOOLKIT – DATABASE ADMINISTRATION TOOLS......Page 390
PART 7 DATABASE MANAGEMENT SYSTEMS – KERNEL......Page 396
CHAPTER 27 DATA ORGANISATION......Page 398
CHAPTER 28 ACCESS MECHANISMS......Page 410
CHAPTER 29 TRANSACTION MANAGEMENT......Page 418
CHAPTER 30 OTHER KERNEL FUNCTIONS......Page 433
PART 8 DATABASE MANAGEMENT SYSTEMS – STANDARDS AND COMMERCIAL SYSTEMS......Page 440
CHAPTER 31 POST-RELATIONAL DBMS – SQL3......Page 442
CHAPTER 32 OBJECT-ORIENTED DBMS – ODMG OBJECT MODEL......Page 451
CHAPTER 33 MICROSOFT ACCESS......Page 461
CHAPTER 34 ORACLE......Page 472
CHAPTER 35 O2 DBMS......Page 482
PART 9 TRENDS IN DATABASE TECHNOLOGY......Page 490
CHAPTER 36 DISTRIBUTED PROCESSING......Page 492
CHAPTER 37 DISTRIBUTED DATA......Page 501
CHAPTER 38 PARALLEL DATABASES......Page 513
CHAPTER 39 COMPLEX DATA......Page 527
PART 10 APPLICATIONS OF DATABASE SYSTEMS......Page 540
CHAPTER 40 DATA WAREHOUSING......Page 542
CHAPTER 41 ON-LINE ANALYTICAL PROCESSING......Page 554
CHAPTER 42 DATA MINING......Page 562
CHAPTER 43 DATABASES AND THE WEB......Page 569
BIBLIOGRAPHY......Page 582
GLOSSARY AND INDEX......Page 587
