Syllabus Advanced Database Management System - (BE05016031) Total Credits = TH/30 Assessment Pattern and Marks Total Marks Theory Tutorial / Practical ESE (E) PA (M) PA (I) PBL (I) ESE (V) 03 70 30 20 30 50 200 Unit No. Content 1 Database Architecture : Introduction to Client-Server Database Models : Overview of client-server architecture, including two-tier and three-tier client-server database models., Concurrency Control Techniques : Study of concurrency control mechanisms, including lock-based protocols, lock granting methods, and the two-phase locking protocol, Introduction to Parallel Databases : Concepts of parallel database systems, parallel database system architecture, types of parallelism, and parallel database implementation strategies, Introduction to Distributed Databases : Fundamentals of distributed database systems, distributed database architecture, advantages of distributed databases, and issues and challenges associated with distributed database systems. (Chapter - 1) 2 Object-Based Databases and XML : Overview of Object-Based Databases, Complex Data Types, Structured Types and Inheritance in SQL, Table Inheritance, Array and Multiset Types in SQL, Object Identity (OI) and Reference Types in SQL, XML : Introduction and Structure of XML Data, XML Document Schema, XPath, XQuery (FLWOR Expressions), Joins, Nested Queries, Aggregate Functions, and User-Defined Functions. (Chapter - 2) 3 Advanced Database Techniques : Structured Vs Unstructured Data, NoSQL Database Concepts : Types of NoSQL databases, NoSQL data modeling, advantages of NoSQL databases, and comparison between SQL and NoSQL database systems, NoSQL Using MongoDB : Introduction to MongoDB, MongoDB Shell, MongoDB Client, basic operations, basic data types, arrays, and embedded documents, Querying with MongoDB: find() function, projection of fields, query criteria, OR queries, and type-specific querying, Aggregation Concepts : Introduction to aggregation pipeline, aggregation using MapReduce, and single-purpose aggregation operations. (Chapter - 3) 4 Advance transaction Processing : Basics of transaction and ACID properties, Transaction processing monitors - architecture, transactional workflows, workflow architectures, Recovery of workflow, Real-time transaction systems, Long duration transactions, Implementation issues-nesting, compensating, concurrency. (Chapter - 4) 5 Modern developments in database technologies : Introduction to Data Mining Techniques : Data mining technology and its relationship with data warehousing, association rules, classification, clustering, and applications of data mining, Introduction to Business Intelligence : Features, frameworks, and types and approaches for machine learning, Introduction to Multimedia Databases, Mobile Databases, and Digital Databases. (Chapter - 5)
