All Blog Posts
BCS Professional Graduate Diploma in IT Study Materials & Resources -
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