|Advanced Data Base Management System||Learning Schedule|
This course is an advanced study of
- non-relational data models,
- the internals of a database management system,
- and database frontiers.
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.
- 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.
- Database System Concepts, Avi Silberschatz , Henry F. Korth , and S. Sudarshan. . Fifth Edition. McGrawHill .
- 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.