Sunday, 28 April 2013

M.Tech VTU CS old syllabus 2010

April 28, 2013 - By rajshekar targar 0

Advances in Database Management Systems

 Subject Code : 10SCS13                                                                                                                    IA Marks : 50
 No of Lecture Hrs/Week : 4                                                                                                             Exam hours : 3
 Total No of Lecture Hours : 52                                                                                                      Exam Marks : 100

1. Review of Relational Data Model and Relational Database Constraints: Relational model concepts; Relational model constraints and relational database schemas; Update operations, transactions and dealing with constraint violations.
2. Object and Object-Relational Databases: Overview of Object-Oriented Concepts Objects, Encapsulation, Type and class hierarchies, complex objects; Object model of ODMG, Object definition Language ODL; Object Query Language OQL; Overview of C++ language binding; Conceptual design of Object database. Overview of object relational features of SQL; Object-relational features of Oracle; Implementation andrelated issues for extended type systems; The nested relational model.
3. Enhanced Data Modelsfor Some Advanced Applications: Active database concepts and triggers; Temporal, Spatial, and Deductive Databases Basic concepts.
4. Parallel and Distributed Databases: Architectures for parallel databases; Parallel query evaluation; Parallelizing 
Image credit
individual operations; Parallel query optimizations; Introduction to distributed databases; Distributed DBMS architectures; Storing data in a Distributed DBMS; Distributed catalog management; Distributed Query processing; Updating distributed data; Distributed transactions; Distributed Concurrency control and Recovery.
5.  Data  Warehousing,  Decision  Support  and  Data  Mining:  Introduction  to  decision  support;  OLAP,
multidimensional model; Window queries in SQL; Finding answers quickly; Implementation techniques for OLAP; Data Warehousing; Views and Decision support; View materialization; Maintaining materialized views. Introduction to Data Mining; Counting co-occurrences; Mining for rules; Tree-structured rules; Clustering; Similarity search over sequences; Incremental mining and data streams; Additional data mining tasks.
6. More Recent Applications: Mobile databases; Multimedia databases; Geographical Information Systems; Genome data management.

Laboratory Work:
(The following tasks can be implemented on Oracle or any other suitable RDBMS with support for Object
        1.    Develop a database application to demonstrate storing and retrieving of BLOB and CLOB objects.
2.     Develop a database application to demonstrate the representation of multivalued attributes, and the use ofnested tables to represent complex objects. Write suitable queries to demonstratetheir use.
3.     Design and develop a suitable Student Database application. One of the attributes to me maintained is theattendance of a student in each subject for which he/she has enrolled. Using TRIGGERS, write active rules to do the following:
a.    Whenever the attendance is updated, check if the attendance is less than 85%; if so, notify the
Head of the Department concerned.
b.     Whenever, the marks in an Internal Assessment Test are entered, check if the marks are less than 40%; if so, notify the Head of the Department concerned.

4.    Design, develop, and execute a program in a language of your choice to implement any one algorithm for mining association rules. Run the program against any large database available in the public domain and discuss the results.

The above is sample. Click on Download to get the complete 



                                                     How to download?


About the Author

Rajshekar Targar is a tech passionate guy who loves to code,blog,surf tech news, reading motivational articles, and tries out something new and interesting on technology every now and then. Follow me Rajshekar

Share This Post


Note: only a member of this blog may post a comment.

© 2014 M.Tech CS VTU. WP Theme-junkie converted by Bloggertheme9
Powered by Blogger.
back to top