Database Systems

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. 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 Most modern-day organizations have a need to record data relevant to their everyday activities and many choose to organise and store some of this information in an electronic database. Database Systems provides an essential introduction to modern database technology and the development of database systems. This new edition has been fully updated to include new developments in the field, and features new chapters on: e-business, database development process, requirements for databases, and distributed processing. In addition, a wealth of new examples and exercises have been added to each chapter to make the book more practically useful to students, and full lecturer support will be available online.