Subject Code : 410445
Subject Name : Advanced Databases
Theory : 100 Marks Term Work : 50 Mark Oral: 50 Mark Duration : 3 Hrs.
Objectives :
• To learn and understand advances in Database System Implementations
• To learn and understand various database architectures and applications.
UNTT I:-Parallel databases
Introduction, Parallel database architecture, I/O 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 rnh.mg, Bayesian classifiers.
UNIT VI : Information Retrieval
Information retrieval - overview , Relevance ranking using terms and hyperlinks, synonyms, homonyms, anthologies, 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 / JSP
4.Building cubes and OLAP analysis
5.Data mining algorithms
6.Case Study a) any one from open source (eg: Postgres SQL »My SQL) b) Any one from Oracle, SQL Server, DB2
Text Books:
1.Abraham Silberschatz, Henry Korth, S, Sudarshan, "Database system concepts'*, 5* Edition , McGraw Hill International Edition
2.Jiawei nan, Micheline Kamber, "Data Mining: Concepts and systems'*, Morgan Kaufmann publishers .
Reference Books :
1.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
|
No responses found. Be the first to respond and make money from revenue sharing program.
|