All Blog Posts

BCS Professional Graduate Diploma in IT Study Materials & Resources -
Advanced Database Management Systems

Advanced Database Management Systems

10.00 AM Thursday / August 14, 2014

Database management systems are standard tools that enable the storage and retrieval of data within modern information systems. Units introducing database concepts are now an accepted part of most computer science courses. These introductory units tend to concentrate on the use of relational database systems. This advanced module, in contrast, deals with implementation aspects of relational systems and tests the candidates’ knowledge of the current enhancements to relational database systems, object oriented database and XML database systems

Aims

  • Compare and contrast emerging architectures for database management systems
  • Understand the manner in which relational systems are implemented and the implications of the techniques of implementation for database performance
  • Appreciate the impact of emerging database standards on the facilities which future database management systems will provide

Prior Knowledge Expected

  • Candidates are expected to be familiar with the materials covered in the Certificate syllabuses and the Diploma Database Systems syllabus

What You will be Studying

THE RELATIONAL MODEL OF DATA

  • Theoretical concepts
  • Relational model conformity and Integrity

RELATIONAL DATABASE MANAGEMENT SYSTEMS IMPLEMENTATION TECHNIQUES

  • Advanced SQL programming
  • Query optimization
  • Concurrency control and Transaction management
  • Database performance tuning
  • Distributed relational systems and Data Replication
  • Security considerations

EMERGING DATABASE MANAGEMENT SYSTEM TECHNOLOGIES

  • Object oriented, deductive, spatial, temporal and constraint database management systems
  • New database applications and environments: e.g. Data Warehousing; Multimedia;
  • Mobility; Multidatabases; Native XML databases (NXD), Internet

DATABASE RELATED STANDARDS

  • SQL standards, SQL 1999, SQL:2003
  • Object Data Management Group (ODMG) version 3.0 standard
  • Standards for interoperability and integration e.g. Web Services, SOAP
  • XML related specifications, e.g. XQuery, XPath.

Books to Refer

  • Date C. J., An Introduction to Database Systems, Addison-Wesley Longman (8th Ed), 2003, ISBN: 0321189566
  • Catell, R.G.G., Barry, D.K., Berler, M., et al, The Object Data Standard: ODMG 3.0, Morgan Kaufmann, 2000, ISBN: 1558606475
  • Silberschatz A., Korth H., and Sudarshan S., Database System Concepts, McGraw-Hill (5th Ed), 2006, ISBN: 0072958863
  • Charles F. Goldfarb, Paul Prescod, The XML Handbook, Prentice Hall, (5th ed), 2004, ISBN: 0-13-049765-7

Get More Information About BCS Professional Graduate Diploma in IT

    Copyright © 2015 PACE Institute. All Rights Reserved. Website Design, Development & Hosting by eBEYONDS