My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
|
UOM - M Sc - Information Technology Year I, Paper IV, Term II
Posted Date: 15 Dec 2007 Resource Type: Articles/Knowledge Sharing Category: General
|
Posted By: Jyothi Member Level: Diamond
Rating:  Points: 1
|
|
|
SUBJECT: ADVANCED DATABASE SYSTEMS
Objectives: To study the further database techniques beyond which covered in the second year, and thus to acquaint the students with some relatively advanced issues. At the end of the course students should be able to: gain an awareness of the basic issues in objected oriented data models, learn about the Web-DBMS integration technology and XML for Internet database applications, familiarize with the data-warehousing and data-mining techniques and other advanced topics, apply the knowledge acquired to solve simple problems
Pre-requisites: Database Systems, OOAD.
DETAILED SYLLABUS
1. The Extended Entity Relationship Model and Object Model: The ER model revisited, Motivation for complex data types, User defined abstract data types and structured types, Subclasses, Super classes, Inheritance, Specialization and Generalization, Constraints and characteristics of specialization and Generalization, Relationship types of degree higher than two.
2. Object-Oriented Databases: Overview of Object-Oriented concepts, Object identity, Object structure, and type constructors, Encapsulation of operations, Methods, and Persistence, Type hierarchies and Inheritance, Type extents and queries, Complex objects; Database schema design for OODBMS; OQL, Persistent programming languages; OODBMS architecture and storage issues; Transactions and Concurrency control, Example of ODBMS
3. Object Relational and Extended Relational Databases: Database design for an ORDBMS - Nested relations and collections; Storage and access methods, Query processing and Optimization; An overview of SQL3, Implementation issues for extended type; Systems comparison of RDBMS, OODBMS, ORDBMS
4. Parallel and Distributed Databases and Client-Server Architecture: Architectures for parallel databases, Parallel query evaluation; Parallelizing individual operations, Sorting, Joins; Distributed database concepts, Data fragmentation, Replication, and allocation techniques for distributed database design; Query processing in distributed databases; Concurrency control and Recovery in distributed databases. An overview of Client-Server architecture
5. Databases on the Web and Semi Structured Data: Web interfaces to the Web, Overview of XML; Structure of XML data, Document schema, Querying XML data; Storage of XML data, XML applications; The semi structured data model, Implementation issues, Indexes for text data
6. Enhanced Data Models for Advanced Applications: Active database concepts. Temporal database concepts.; Spatial databases, Concepts and architecture; Deductive databases and Query processing; Mobile databases, Geographic information systems.
BOOKS
Text Books:
1. Elmasri and Navathe, ?Fundamentals of Database Systems?, Pearson Education
2. Raghu Ramakrishnan, Johannes Gehrke, ?Database Management Systems?, McGraw-Hill
References:
1. Korth, Silberchatz, Sudarshan , ?Database System Concepts?, McGraw-Hill.
2. Peter Rob and Coronel, ?Database Systems, Design, Implementation and Management?, Thomson Learning.
3. C.J.Date, Longman, ?Introduction To Database Systems?, Pearson Education
TERM WORK
7. Term work should consist of at least 10 practical experiments and two assignments covering the topics of the syllabus.
ORAL EXAMINATION
An oral examination is to be conducted based on the above syllabus.
|
Responses
|
No responses found. Be the first to respond and make money from revenue sharing program.
|
|
Watch TV Channels
|