Database Systems

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. Front Matter....Pages i-xiv Front Matter....Pages 1-2 Database Systems as Abstract Machines....Pages 3-18 Data and Information....Pages 19-29 Database, Dbms and Data Model....Pages 30-47 Database Systems, ICT Systems and Information Systems....Pages 48-61 Database Systems and Electronic Business....Pages 62-75 Data Management Layer....Pages 76-86 Front Matter....Pages 87-88 Relational Data Model....Pages 89-112 Object-Oriented Data Model....Pages 113-124 Deductive Data Model....Pages 125-142 Post-Relational Data Model....Pages 143-153 Front Matter....Pages 155-156 SQL — Data Definition....Pages 157-167 SQL — Data Integrity....Pages 168-176 SQL — Data Manipulation....Pages 177-191 Front Matter....Pages 193-194 Database Development Process....Pages 195-207 Requirements Elicitation....Pages 208-218 Entity-Relationship Diagramming....Pages 219-245 Object Modelling....Pages 246-268 Normalisation....Pages 269-291 Physical Database Design....Pages 292-308 Database Implementation....Pages 309-320 Front Matter....Pages 321-322 Strategic Data Planning....Pages 323-333 Data Administration....Pages 334-342 Database Administration....Pages 343-354 Front Matter....Pages 355-356 DBMS-Toolkit — End-User Tools....Pages 357-364 DBMS-Toolkit — Application Development Tools....Pages 365-374 DBMS-Toolkit — Database Administration Tools....Pages 375-380 Front Matter....Pages 381-382 Data Organisation....Pages 383-394 Access Mechanisms....Pages 395-402 Transaction Management....Pages 403-417 Other Kernel Functions....Pages 418-424 Front Matter....Pages 425-426 Post-Relational DBMS — SQL3....Pages 427-435 Object-Oriented DBMS — ODMG Object Model....Pages 436-445 Microsoft Access....Pages 446-456 Oracle....Pages 457-466 O2 DBMS....Pages 467-473 Front Matter....Pages 475-476 Distributed Processing....Pages 477-485 Distributed Data....Pages 486-497 Parallel Databases....Pages 498-511 Complex Data....Pages 512-523 Front Matter....Pages 525-526 Data Warehousing....Pages 527-538 Front Matter....Pages 525-526 On-Line Analytical Processing....Pages 539-546 Data Mining....Pages 547-553 Databases and the Web....Pages 554-566 Back Matter....Pages 567-601