Saturday, September 17, 2011

Advance Database Management Systems : BE [Comp & IT]

   Advance Database Management System is an elective subject introduced into the academics of Computer & IT Final year Engineering of of Pune University. Most of the students run away from ADBMS and choose subjects like Artificial Intelligence and Compiler Design or other subjects as their elective subjects  since DBMS was a bit tough and less scoring subject subject in Third year.

   I feel, most of the students should opt for ADBMS as it really an important subject for your career. Wherever you  go, you will always find Database management very crucial. Almost all corners of technology are connected with database. People, who opt for ADBMS will definitely have an advantage over others when you appear for your campus placements. The questions you will face in your technical interview will   be mostly covering  C, C++, DBMS. So , students who have opted for ADBMS as their elective subject, definitely stay in touch with the DBMS concepts and excel relatively better compared to others. This was my opinion, people who deep interest in other subjects should definitely opt for the subject which makes them  feel comfortable.

   ADBMS, is much different when compared to DBMS, which was more of basic. ADBMS has more of theory when compared with the older one. Here, the concepts are really interesting. People who have interest in DBMS will definitely love Data Warehousing and Data Mining along with OLAP concepts. 

   The problem with ADBMS is that you need to refer more than one reference books to cover the whole syllabus as DBMS by Korth alone will not suffice.

 The Syllabus for ADBMS [I.T.] :
Unit I Overview
PL/SQL – Introduction to PL/SQL – Declare, begin statements, Variables, Control Structure, PL/SQL Transactions – Savepoint, Cursor, PL/SQL Database Objects – Procedures, Functions, Packages, Triggers. Programmatic SQL – Embedded SQL, Dynamic SQL, and ODBC Standard.

Unit II  Transaction processing and concurrency control
Definition of Transaction and ACID properties. Transaction Processing - Transaction-processing monitors, transactional workflows, main-memory databases, real-time transaction systems, long-duration transactions, transaction management in multi-databases. Concurrency Control – Locks, Optimistic Concurrency Control (Backward and Forward validations), Timestamping Concurrency Control.

Unit III Object-based databases and xml
Object-based databases – Complex data types, structured types and inheritance in SQL, table inheritance, array and multiset types in SQL, object identity and reference types in SQL, implementing O-R features, Persistent programming languages, OO vs OR. XML – Structure of XML, Document Schema, Querying and Transformation, API in XML, XML applications.

Unit IV Data warehousing 
Introduction to Data Warehousing – Concepts, Benefits and Problems, DW Architecture – Operational Data, load manager, meta data, DW Data flows – inflow, upflow, meta flow, DW tools and technologies – Extraction, cleansing and transformation tools, DW DBMS, admin and management tools, data marts – reasons and issues, Data Warehousing using Oracle.
Data Warehousing Design – Designing, Dimensionality modeling, Design methodology, DW deign using Oracle.

Unit V Olap and data mining 
On-line Analytical Processing – OLAP BenchMarks, applications, benefits,tools, categories, extensions to SQL, Data mining – introduction, techniques,predictive modeling, tools. Data mining algorithms – Apriori, Decision tree,k-means, Bayesian classifier.

Unit VI Database security 
Security and integrity threats, Defence mechanisms, Statistical database auditing & control. Security issue based on granting/revoking of privileges, Introduction to statistical database security. PL/SQL Security – Locks – Implicit locking, types and levels of locks, explicit locking, Oracles’ named Exception Handlers.


Syllabus for ADBMS  - Computer Engineering

Unit I
Introduction, Parallel database architecture, speedup, scale-up I/O parallelism, Inter-query and Intra-query parallelism, Inter-operational and Intra-operational parallelism, parallel query evaluation, Design of parallel systems, Implementation issues of Parallel query evaluation, Design of parallel systems, Comparison of Inter-query and Intra-query parallelism.
Unit IIDistributed Databases, Study of DDBMS architectures, Comparison of Homogeneous and Heterogeneous Databases, Analysis of Concurrency control in distributed databases, Implementation of Distributed query processing.
Distributed data storage, Distributed transactions, Commit protocols, Availability, Distributed query processing, Directory systems-ldap, Distributed data storage and transactions.

Unit IIIOverview of client server architecture, Databases and web architecture, N-tier architecture, XML, Introduction, Structure of XML Data, XML Document Schema, DTD, Querying and Transformation: XQuery, FLOWR, XPath, XML validation, Web server, API to XML, Storage of XML Data, XML Applications: web services, Web based system, Implementation of XML validations, Use of web servers. XML and DTD implementation, Use of Web service like Amazon web service or Microsoft Azure.

Unit IVIntroduction to Decision Support, Data Warehousing, Creating and maintaining a warehouse. Introduction to Data warehouse and OLAP, Multidimensional data model, Data Warehouse architecture, OLAP and data cubes, Operations on cubes, Data preprocessing need for preprocessing, Multidimensional data model, OLAP and data cubes, Data warehousing Concepts, Study of Data preprocessing need for preprocessing, Simulating and maintaining a Warehouse, Analysis of Data preprocessing.

Unit VIntroduction to data mining , Data mining functionalities, clustering - k means algorithm, classification - decision tree, Baysian classifiers, Outlier analysis, association rules - apriori algorithm, Introduction to text mining, Implementing Clustering - k means algorithm, Analysis of Decision tree.

Unit VIInformation 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. Information Retrieval, Study and Comparison of Synonyms, Homonyms, Ontologies. Implementation issues of Relevance ranking Algorithm.


Complete ADBMS Book for BE- IT [Pune University] 

Download Link
Unit 1
Unit 2
Unit 3
Unit 4
Unit 5
Unit 6


 Books to Download for ADBMS

Database System Concepts
Korth, Sudarshan,Silberschatz


Fundamentals of Database Systems
Elmasari , Navathe

Data Warehousing for dummies

Database Management Systems
Raghu Ramkrishnan, Gehrke


Database Systems
A Practical Approach to Design, Implementation & Management
Thomas Connolly, Carolyn Begg

Data Mining : Concepts  Techniques
Han, Kamber, Pei


Handbook of Database Security
Applications and Trends
Gertz, Jajodia,

Data Warehousing : OLAP & Data Mining


Video Lectures

Introduction to Database Systems

What is relational Database

Data Warehousing - Basics

Introduction to  Data Warehousing

Data Warehousing - Definition
What is Data Mining?

Database Security

What is OLAP?




  1. can i get question paper of 2012 exams??


  2. For BE -IT question papers

    For BE Comp papers

  3. Please upload mobile computing books

  4. not able to download database security handbook. plz check the link.