Adavance Database Management System

Download Adavance Database Management System Lab Manual

Download  Adavance Database Management System FAQ

Downlaod ADBMS Program

Download Database system concepts", 5th

Download Data Mining: Concepts and systems

410445 Advanced Databases

Teaching Scheme:

 Lecturers: 4 Hrs. I Week

Practical: 2 Hrs I Week

Examination Scheme:

 Theory: 100 Marks

Term Work: 50 Mark

 Oral: 50 Mark Duration: 3 Hrs.

Objectives: ­

                 . . To Iearn and understand advances in Database System Implementations

               .. . To learn and understand various database architectures and applications.

.

UNlT I :

Parallel databases

Introduction, Parallel database architecture, VO parallelism, Inter-query and Intra-query parallelism, Inter-operational and Intra-operational parallelism, Design of parallel systems

UNIT II :

Distributed Databases

Introduction, DDBMS architectures, Homogeneous and Heterogeneous Databases, Distributed data storage, Distributed transactions, Commit protocols, Concurrency control in distributed databases, Availability, Distributed query processing, Directory systems

UNIT III :

Web based systems

Overview of client server architecture, Databases and web architecture, N-tier architecture, Business logic - SOAP

XML -Introduction, XML DTD's, Domain specific DTD's , Querying XML data

UNIT IV :

Data Warehousing

Introduction to Data warehousing, architecture, Dimensional data modeling- star, snowflake schemas, fact constellation, OLAP and data cubes, Operations on cubes, Data preprocessing ­need for preprocessing, data cleaning, data integration and transformation, data reduction

UNIT V :

Data Mining

Introduction to data mining, Introduction to machine learning, descriptive' and predictive data mining, outlier analysis, clustering - k means algorithm, classification - decision tree, association rules - apriori algorithm, Introduction to text mining, Baysian classifiers. . .

UNIT VI :

Information Retrieval

Information retrieval - overview, Relevance ranking using terms and hyperlinks, synonyms, homonyms, ontologies, Indexing of documents, measuring retrieval effectiveness, web search engines, Information retrieval and structured data .

List of assignments

1. ORDBMS - Implement system using composite, multivalued attributes, inheritance

2. Directory systems - address book using LDAP

3. Web based system using ASP I JSP

4. Building cubes and OLAP analysis

5. Data mining algorithms

6. Case Study a) anyone from open source ( eg : Postgres SQL , MySQL ) b) Anyone from Oracle, SQL Server, DB2

Text Books :

      I. Abraham Silberschatz, Henry Korth, S. Sudarshan, "Database system concepts", 5th

            Edition, McGraw Hill International Edition

      2. Jiawei han, Micheline Kamber, "Data Mining: Concepts and systems" , Morgan

            Kaufmann publishers

Reference Books

      I. Rob Coronel, Database systems: "Design implementation and management", 4th Edition,

            Thomson Learning Press

      2. Raghu Ramkrishnan, Johannes Gehrke, "Database Management Systems", Second

            Edition, McGraw Hill International Edition