IT605SE-05: Advanced Database Syllabus for IT 6th Sem 2019-20 DBATU (Elective-VI Labs)

Advanced Database detailed syllabus scheme for Information Technology (IT), 2019-20 onwards has been taken from the DBATU official website and presented for the Bachelor of Technology students. For Subject Code, Course Title, Lecutres, Tutorials, Practice, Credits, and other information, do visit full semester subjects post given below.

For 6th Sem Scheme of Information Technology (IT), 2019-20 Onwards, do visit IT 6th Sem Scheme, 2019-20 Onwards. For the Elective-VI Labs scheme of 6th Sem 2019-20 onwards, refer to IT 6th Sem Elective-VI Labs Scheme 2019-20 Onwards. The detail syllabus for advanced database is as follows.

Advanced Database Syllabus for Information Technology (IT) 3rd Year 6th Sem 2019-20 DBATU

Course Objectives:

For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.
.

Course Outcomes:

After learning the course the students should be able:

1. To explain how databases are used in various fields of industry
2. To apply query evaluation techniques and query optimization techniques.
3. To develop transaction processing systems with concurrency control.
4. To design and develop a database application system as part of a team.
5. To explore open issues in advanced databases

Unit I

PARALLEL AND DISTRIBUTED DATABASES: Database System Architectures: Centralized and Client-Server Architectures – Server System, Architectures – Parallel Systems- Distributed Systems – Parallel Databases: I/O Parallelism – Inter and Intra Query Parallelism – Inter and Intra operation Parallelism – Distributed Database Concepts – Distributed Data Storage – Distributed Transactions – Commit Protocols – Concurrency Control -Distributed Query Processing – Three Tier Client Server Architecture- Case Studies.

Unit II

For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.
.

Unit III

XML DATABASES: XML Databases: XML Data Model – DTD – XML Schema – XML Querying – Web Databases – JDBC- Information Retrieval – Data Warehousing – Data Mining.

Unit IV

MOBILE DATABASES: Mobile Databases: Location and Handoff Management – Effect of Mobility on Data Management – Location Dependent Data Distribution – Mobile Transaction Models – Concurrency Control -Transaction Commit Protocols- Mobile Database Recovery Schemes.

Unit V

For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.
.

Unit VI

COMPLEX QUERIES AND REASONING: Logic of Query Languages – Relational Calculi – Recursive rules -Syntax and semantics of Datalog – Fix-point semantics – Implementation Rules and Recursion – Rule rewriting methods – Compilation and Optimization – Recursive Queries in SQL – Open issues.

Text Books:

1. Carlo Zaniolo, Stefano Ceri, Advanced Database Systems, Morgan Kauffmann Publishers.
2. Subramaniam, Multimedia Databases, Morgan Kauffman Publishers, 2008.
3. Rajesh Narang, Object Oriented Interfaces and Databases, Prentice-Hall of India, Pvt. Ltd., 2004.
4. Thomas Cannolly and Carolyn Begg, Database Systems, A Practical Approach to Design, Implementation and Management, 3rd Edition, Pearson Education, 2007.
5. Jeffrey A. Hoffer, Mary B. Prescottand Fred R. McFadden, Modern Database Management, Prentice Hall, 2007.

Reference Book:

1. Henry F Korth, Abraham Silberschatz and S. Sudharshan, Database System Concepts, 6th Edition, McGraw Hill, 2011.
2. C. J. Date, A. Kannan and S. Swamynathan, An Introduction to Database Systems, 8th Edition, Pearson Education, 2006.
3. R. Elmasri, S. B. Navathe, Fundamentals of Database Systems, 5th Edition, Pearson Education/Addison Wesley, 2007.
4. Ramakrishnan, Gehrke, Database Management System, Tata McGraw Hill Publications, 4th Edition.
5. Ramez Elmasri, Sham Navathe, Fundamentals of Database Systems, Addison-Wesley, 2000.

For detail syllabus of all subjects of Information Technology (IT) 6th Sem 2019-20 onwards, visit IT 6th Sem Subjects of 2019-20 Onwards.