Advances in Databases detailed syllabus for Information Technology (IT) for 2019 regulation curriculum has been taken from the Anna Universities official website and presented for the IT students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.
For Information Technology 5th Sem scheme and its subjects, do visit IT 5th Sem 2019 regulation scheme. For Professional Elective-I scheme and its subjects refer to IT Professional Elective-I syllabus scheme. The detailed syllabus of advances in databases is as follows.
Course Objective:
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 pdfs platform to make students’s lives easier.
.
Unit I
Distributed Databases
Distributed Systems – Introduction – Architecture – Distributed Database Concepts -Distributed Data Storage – Distributed Transactions – Commit Protocols – Concurrency Control – Distributed Query Processing.
Suggested Activities:
- Practical – Design of distributed database with fragmentation using any DBMS.
- Flipped classroom on distributed transaction protocols.
- Writing distributed queries and optimizing the queries.
Suggested Evaluation Methods:
- Evaluation of designed Distributed Database system.
- Quizzes on distributed transactions.
- Tutorials on distributed queries and optimization.
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 pdfs platform to make students’s lives easier..
Unit III
Advanced Database Systems
Spatial Databases: Spatial Data Types, Spatial Relationships, Spatial Data Structures, Spatial Access Methods – Temporal Databases: Overview – Active Databases – Deductive Databases – Recursive Queries in SQL – Mobile Databases: Location and Handoff Management, Mobile Transaction Models, Concurrency – Transaction Commit Protocols -Multimedia Databases.
Suggested Activities:
- Individual/group activities for application specific data handling.
- Discussion about advantages and drawbacks of transaction models for different applications involving spatial-temporal data.
Suggested Evaluation Methods:
- Tutorials on active and deductive databases.
- Assignments on spatial databases.
- Quizzes on mobile database transactions.
Unit IV
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 pdfs platform to make students’s lives easier..
Unit V
Information Retrieval and Web Search
IR concepts – Retrieval Models – Queries in IR system – Text Preprocessing – Inverted Indexing – Evaluation Measures – Web Search and Analytics – Current trends.
Suggested Student Activities:
- Flipped classroom on queries in IR.
- Practical – Install any IR framework such as SOLR, and experiment with it.
Suggested Evaluation Methods:
- Practical demonstration on IR Queries.
- Quizzes on IR frameworks and related tools.
Course Outcome:
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 pdfs platform to make students’s lives easier..
Text Books:
- Henry F Korth, Abraham Silberschatz, S. Sudharshan, “Database System Concepts”, Sixth Edition, McGraw Hill, 2011.
- R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, Seventh Edition, Pearson Education/Addison Wesley, 2017.
References:
- C. J. Date, A. Kannan, S. Swamynathan, “An Introduction to Database Systems”, Eighth Edition, Pearson Education, 2006.
- Jiawei Han, Micheline Kamber , Jian Pei, “Data Mining: Concepts and Techniques”, Third Edition, Morgan Kaufmann, 2012.
- Brad Dayley, “Teach Yourself NoSQL with MongoDB in 24 Hours”, Sams Publishing, 2014.
- Shashank Tiwari, “Professional NoSQL”, O”Reilly Media, 2011.
- Vijay Kumar, “Mobile Database Systems”, John Wiley and Sons, 2006.
For detailed syllabus of all the other subjects of Information Technology 5th Sem, visit IT 5th Sem subject syllabuses for 2019 regulation.
For all Information Technology results, visit Anna University IT all semester results direct link.