Advance Database Management Course outline - University of Sargodha

Course Title: Advance Database Management
Course Code: CS-4444
Course Structure: Lectures: 3 / Labs: 0
Credit Hours: 3

Prerequisite: CS-3450 (Database Systems)

Course Objectives:

The students will learn about the salient features of various types of databases, transaction
management, data warehousing and data mining

Course Syllabus:

PL/SQL Basics.Programmatic SQL - Embedded SQL, Dynamic SQL, and ODBC Standard.
Transaction processing and concurrency control. Object-based databases and XML Object-based
databases.Data warehousing.Data Warehousing Design.OLAP and Data Mining On-line
Analytical Processing.Database Security.PL/SQL Security.

Course Outline:

1.      PL/SQL - Introduction To PL/SQL - Declare, Begin Statements, Variables, Control
Structure, PL/SQL Transactions - Savepoint, Cursor, PL/SQL Database Objects -
Procedures, Functions, Packages, Triggers. Programmatic SQL - Embedded SQL,
Dynamic SQL, And ODBC Standard.

2.      Transaction Processing And Concurrency Control Definition Of Transaction And ACID
Properties. Transaction Processing - Transaction-Processing Monitors, Transactional
Workflows, Main-Memory Databases, Real-Time Transaction Systems, Long-Duration
Transactions, Transaction Management In Multi-Databases. Concurrency Control -
Locks, Optimistic Concurrency Control (Backward and Forward Validations),
Timestamping Concurrency Control.

3.      Object-Based Databases And Xml Object-Based Databases - Complex Data Types,
Structured Types and Inheritance In SQL, Table Inheritance, Array and Multiset Types in
SQL, Objectidentity and Reference Types in SQL, Implementing O-R Features,
Persistent

4.      Programming Languages, OO Vs OR. XML - Structure of XML, Document Schema,
Querying and Transformation, API In XML, XML Applications.

5.      Data Warehousing: Introduction To Data Warehousing - Concepts, Benefits and
Problems, DW Architecture - Operational Data, Load Manager, Meta Data, DW Data
Flows - Inflow, Upflow, Meta Flow, DW Tools and Technologies - Extraction,
Cleansing and Transformation Tools, DW DBMS, Admin and Management Tools, Data
Marts - Reasons And Issues, Data Warehousing Using Oracle.

6.      Data Warehousing Design - Designing, Dimensionality Modeling, Design Methodology,
DW Deign Using Oracle.

7.      OLAP And Data Mining On-Line Analytical Processing - OLAP Benchmarks,
Applications, Benefits, Tools, Categories, Extensions To SQL, Data Mining -
Introduction, Techniques, Predictive Modeling, Tools. Data Mining Algorithms -
Apriori, Decision Tree, K-Means, Bayesian Classifier.

8.      Database Security: Security and Integrity Threats, Defence Mechanisms, Statistical
Database Auditing & Control. Security Issue Based On Granting/Revoking of Privileges,
Introduction to Statistical Database Security. PL/SQL Security - Locks - Implicit
Locking, Types And Levels of Locks, Explicit Locking, Oracles' Named Exception
Handlers.

Textbook(s):

1.     Database System Concepts by A. Silberschatz, H. Korth and S. Sudarshan, McGraw-Hill
Science/Engineering/Math; 6^th Edition (January 27, 2010). ISBN-10: 0073523321

2.      Database Systems - A Practical Approach to Design, Implementation and Management
by Thomas Connolly and Carolyn Begg, 5^th Edition, ISBN-10: 0321601106.

3.      SQL, PL/SQL - The Programming Language of ORACLE by Ivan Bayross, Third
Revised Edition, BPB Publication.ISBN-10: 8176560723

Reference Material:

•         Data Mining - Concepts and Techniques by Jiawei Han and Micheline Kamber, Morgan
Kaufmann; 3^rd Edition (July 6, 2011). ISBN-10: 0123814790

•         Handbook of Database Security- Application and Trends by M. Gertz, and S. Jajodia,
2008, Springer.

•         Handbook of Database Security: Applications and Trends by Michael Gertz (Editor) and
Sushil Jajodia (Editor), Springer; Softcover reprint of hardcover 1^st Edition (November
4, 2010). ISBN-10: 1441943056

Note: This content is obtained from official documents of University of Sargodha and applied on BS Computer Science for Main Campus, Sub Campuses, and Affiliated Colleges.