18001025661 / 8527794500
info@sgtuniversity.org

Syllabus | B.Tech-Computer Science & Engineering | Advanced Data Base Management System

  Advanced Data Base Management System Learning Schedule
L T P C
Pre-requisites: DBMS 3 0 0 3

COURSE DESCRIPTION

This course is an advanced study of

  • non-relational data models,
  • the internals of a database management system,
  • and database frontiers.

COURSE OBJECTIVES

This course will help students to achieve the following objectives.

  • Learn new ways to query and model data.
  • Become familiar with the expanding role of database technology.

COURSE OUTCOMES

  • Master the basic concepts and appreciate the applications of database systems.
  • Master the basics of SQL and construct queries using SQL.
  • Be familiar with a commercial relational database system (Oracle) by writing SQL using the system.

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.

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 II :  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.

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 III: 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.

TEXT BOOKS

  • Database System Concepts, Avi Silberschatz , Henry F. Korth , and S. Sudarshan.  . Fifth Edition. McGrawHill .

REFERENCE BOOKS:

  • Silberschatz, Korth, “Database System Concepts”, 6th Edition, TMH, 2010.
  •  Elmasri R, Navathe S B, Somayajulu D V L N, and Gupta S K, “Fundamentals of Database Systems”, 5th Edition, Pearson Education, 2009.
  • C. J. Date, “Introduction to Database Systems”, 8th Edition, Pearson Education, 2009.
ADMISSIONS 2021