Advanced Database System
24CSE674 · S6 · 4 credits
Official KTU 2024 syllabus subject — study with practice, PYQs and AI tools.
Have an exam tomorrow?
Get a high-yield attack plan focused on maximum marks per minute. Zero fluff, strict PYQ priority, active recall, and trap avoidance.
Strategy: High-yield concepts + PYQs + weak areas
Why:Foundation module
Why:High exam relevance
Why:Core module
Why:Applied concepts
Why:Standard exam coverage
Module 01Distributed Databases (5 hrs)expand
Distributed Database concepts, Distributed Databases vs. Conventional Databases, Types of Distributed Database systems, Distributed Database Architectures, Data Fragmentation, Replication and Allocation techniques for distributed database design, Distributed Catalog Management.
Module 02Query Processing and Optimization (7 hrs)expand
Complex SQL Queries, Query Processing Algorithms – Query Optimization Techniques, Transaction Management- Transaction Processing Concepts, Concurrency Control, Deadlocks, Recovery Techniques.
Module 03Database Security (7 hrs)expand
Introduction to Database Security Issues-Types of Security, Control Measures, Database Security and the DBA, Access Control, User Accounts, and Database Audits, Discretionary Access Control, Mandatory Access control (Role based only), SQL Injection, Challenges of database security.
Module 04Multimedia Databases (6 hrs)expand
Multimedia Databases- Data Formats, Continuous Media Data, Similarity Based Retrieval, Mobile Data Management- Mobile Computing Architecture, Data Management Issues, Location Based Services, Peer to Peer Systems and Applications, Application Platforms.
Module 05Emerging trends in Database management (8 hrs)expand
Big Data – Motivation, Sources and Uses of Big Data, Querying Big Data, Big Data Storage Systems- Distributed File Systems, Sharding, Key Value Storage Systems, Blockchain Databases-Overview, Blockchain Properties, Simple Blockchain Transactions, Data Management in a Blockchain, Emerging Applications. Textbooks 1. R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, 5/e, Pearson Education/Addison Wesley, 2011 2. Patrick O'Neil , Elizabeth O'Neil , “Database: Principles, Programming and Performance”,2/e, Morgan Kaufmann, 2011 3. Thomas Cannolly and Carolyn Begg, “Database Systems, A Practical Approach to Design, Implementation and Management”, 3/e, Pearson Education, 2010. 4. Henry F Korth, Abraham Silberschatz, S. Sudharshan, “Database System Concepts”, 5/e, Tata McGraw Hill, 2006
Exam-focused notes are optional context — Continue Learning above works even without them.
Notes for this subject aren't written yet
Continue Learning above adapts to this subject anyway — it teaches from your active syllabus.