7th Sem, IT

Advanced Topics On Databases It 7th Sem Syllabus for BE 2017 Regulation Anna Univ (Professional Elective III)

Advanced Topics On Databases It 7th Sem Syllabus for BE 2017 Regulation Anna Univ (Professional Elective III) detail syllabus for Information Technology (It), 2017 regulation is collected from the Anna Univ official website and presented for students of Anna University. The details of the course are: course code (CS8071), Category (PE), Contact Periods/week (3), Teaching hours/week (3), Practical Hours/week (0). The total course credits are given in combined syllabus.

For all other it 7th sem syllabus for be 2017 regulation anna univ you can visit It 7th Sem syllabus for BE 2017 regulation Anna Univ Subjects. For all other Professional Elective III subjects do refer to Professional Elective III. The detail syllabus for advanced topics on databases is as follows.

Course Objective:

  • To learn the modeling and design of databases.
  • To acquire knowledge on parallel and distributed databases and their applications.
  • To study the usage and applications of Object Oriented and Intelligent databases.
  • To understand the usage of advanced data models.
  • To learn emerging databases such as XML, Cloud and Big Data.
  • To acquire inquisitive attitude towards research topics in databases.

Unit I

For complete syllabus and results, class timetable and more pls download iStudy. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.

Unit II

Object and Object Relational Databases
Concepts for Object Databases: Object Identity – Object structure – Type Constructors -Encapsulation of Operations – Methods – Persistence – Type and Class Hierarchies – Inheritance -Complex Objects – Object Database Standards, Languages and Design: ODMG Model – ODL – OQL – Object Relational and Extended – Relational Systems: Object Relational features in SQL/Oracle -Case Studies.

Unit III

Intelligent Databases
Active Databases: Syntax and Semantics (Starburst, Oracle, DB2)- Taxonomy- Applications-Design Principles for Active Rules- Temporal Databases: Overview of Temporal Databases- TSQL2-Deductive Databases: Logic of Query Languages – Datalog- Recursive Rules-Syntax and Semantics of Datalog Languages- Implementation of Rules and Recursion- Recursive Queries in SQL- Spatial Databases- Spatial Data Types- Spatial Relationships- Spatial Data Structures-Spatial Access Methods- Spatial DB Implementation.

Unit IV

For complete syllabus and results, class timetable and more pls download iStudy. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.

Unit V

Emerging Technologies
XML Databases: XML-Related Technologies-XML Schema- XML Query Languages- Storing XML in Databases-XML and SQL- Native XML Databases- Web Databases- Geographic Information Systems- Biological Data Management- Cloud Based Databases: Data Storage Systems on the Cloud- Cloud Storage Architectures-Cloud Data Models- Query Languages- Introduction to Big DataStorage-Analysis.

Course Outcome:

Upon Completion of the course, the students will be able,

  • To develop in-depth understanding of relational databases and skills to optimize database performance in practice.
  • To understand and critique on each type of databases.
  • To design faster algorithms in solving practical database problems.
  • To implement intelligent databases and various data models.

Text Books:

  1. Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, Sixth Edition , Pearson, 2011.
  2. Thomas Cannolly and Carolyn Begg, Database Systems, A Practical Approach to Design, Implementation and Management, Fourth Edition, Pearson Education, 2008.

References:

  1. Henry F Korth, Abraham Silberschatz, S. Sudharshan, Database System Concepts, Sixth Edition, McGraw Hill, 2011.
  2. C.J.Date, A.Kannan, S.Swamynathan, An Introduction to Database Systems, Eighth Edition, Pearson Education, 2006.
  3. Carlo Zaniolo, Stefano Ceri, Christos Faloutsos, Richard T.Snodgrass, V.S.Subrahmanian, Roberto Zicari, Advanced Database Systems, Morgan Kaufmann publishers,2006.

For detail syllabus of all other subjects of BE It, 2017 regulation do visit It 7th Sem syllabus for 2017 Regulation.

Dont forget to download iStudy for latest syllabus and results, class timetable and more.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.