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
and
related issues for
extended type systems; The nested relational model.
3. Enhanced Data Models
for 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
features)
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
of
nested tables to represent complex objects. Write suitable queries to demonstrate
their use.
3. Design and develop a suitable Student Database application. One of the attributes to me maintained is
the
attendance 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
syllabus
DOWNLOAD
Home
13:42 - By Rajshekar Targar
0
0 comments: