SCPS331 – Database and Information Management II

Introduction to Client/Server systems and Object-Oriented database models. Transaction Management, concurrency control and performance tuning. Distributed Database Management; Data Warehouse : DSS architecture, OLAP and star schemas; Database connectivity and Web development 

On completion of this module the learner should be able to:

• Understand client/server architecture; 
• Understand OO principles: objects, OID, messages, protocols, inheritance, object schemas including instance representations. 
• Describe a transaction according to its properties. 
• Understand concurrency control with respect to the three anomalies: lost update, uncommitted data and inconsistent retrieval.
•  Describe locking-, time stamping- and optimistic methods and recovery management. -understand performance-tuning concepts, SQL processing by DBMS, and introduction to DBMS tuning for optimal performance.
•  Describe the components of a DDBMS, data- and process distribution and 154 data fragmentation. Introduction to the concepts of data warehousing.
•  To understand the different connectivity types and Web to database middleware.