1. Introduction. 2. The relational model. 3. Database design using entity relationship modelling. 4. Database design using normalisation. 5. Introduction to SQL. 6. Further SQL. 7. PL/SQL. 8. Query processing and optimisation. 9. Object-oriented and object-relational models. 10. Transaction management and concurrency control. 11. Backup and recovery. 12. Distributed database systems. 13. Web database connectivity. 14. Data warehousing. 15. Physical Database Design. Appendix - The Bus Depots' Database. Further reading. Index.

The success of many organizations depends upon information stored in database management systems. Given the importance of such systems, it is essential that managers with responsibility for IT understand the underlying database management system (DBMS) principles, are aware of the strengths and weaknesses of existing database technology and of likely future developments in the field. This book explores these areas. Students using this book will already have some knowledge of databases and will have completed an introductory course in database systems. This book supports a course aimed at deepening the students' understanding of the technologies covered earlier by introducing other conceptual models which have been proposed to tackle deficiencies of the relational model. It also addresses advanced issues faced in database application development and it aims to familiarise students with the current technological developments and trends. The book covers the following areas: Transaction management Concurrency control Recovery Query Optimisation Distributed Management Systems Object-oriented data models Object-relational database management systems Data warehousing
Les mer
The success of many organizations depends upon information stored in database management systems. This book covers the following areas: Transaction management; Concurrency control; Recovery; Query; Optimisation; Distributed Management Systems; Object-oriented data models; Object-relational database management systems; and Data warehousing.
Les mer
1. Introduction. 2. The relational model. 3. Database design using entity relationship modelling. 4. Database design using normalisation. 5. Introduction to SQL. 6. Further SQL. 7. PL/SQL. 8. Query processing and optimisation. 9. Object-oriented and object-relational models. 10. Transaction management and concurrency control. 11. Backup and recovery. 12. Distributed database systems. 13. Web database connectivity. 14. Data warehousing. 15. Physical Database Design. Appendix - The Bus Depots' Database. Further reading. Index.
Les mer

Produktdetaljer

ISBN
9781408007686
Publisert
2008-09-01
Utgave
2. utgave
Utgiver
Vendor
Cengage Learning EMEA
Vekt
740 gr
Høyde
20 mm
Bredde
188 mm
Dybde
242 mm
Aldersnivå
P, 06
Språk
Product language
Engelsk
Format
Product format
Heftet
Antall sider
392

Forfatter