SUK · Third Year B.Tech. Computer Science and Engineering (Data Science) · NEP 2020
Advanced Database Systems
DS3201 · Semester VI · 3 credits · ISE 10 + mid-semester 30 + ESE 60
Unit IV is headed Database Administration and Security; the syllabus prints its contents under the role of the database administrator.
Unit 1: Parallel and Distributed Databases
7 hoursCentralised, client-server and server system architectures; parallel database architectures and I/O, inter- and intra-query and inter- and intra-operation parallelism; distributed data storage, transactions, commit protocols, concurrency control and query processing; distributed databases in Oracle.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Parallel database architectures
- Cloud and distributed databases
- Distributed database design: fragmentation, replication and allocation
- Distributed transactions: two-phase and three-phase commit
- Distributed query processing
Unit 2: Advanced SQL
7 hoursRelational set and join operators, subqueries and correlated queries, SQL functions, Oracle sequences, synonyms, database links and updatable views; procedural SQL, triggers, stored procedures, cursors and stored functions; embedded and dynamic SQL; a PostgreSQL case study.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- SQL joins, subqueries and CTEs
- PL/SQL procedures and functions
- Triggers
Unit 3: NoSQL Database Management
8 hoursFeatures and types of NoSQL databases: column-oriented, key-value, document and graph stores; storing, accessing and querying data in MongoDB; interfacing with NoSQL; CouchDB versus MongoDB; Compass and Atlas.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- NoSQL database types
- Key-value and document stores
- Column-family and graph stores
- MongoDB CRUD and aggregation
- HBase and CouchDB
Unit 4: Database Administration and Security
7 hoursThe role of a database in an organisation and the evolution of database administration; the human component and security; the data dictionary and CASE tools; a data administration strategy; Oracle for database administration.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Database security threats and DBMS vulnerabilities
- Secure DBMS design
Unit 5: Business Intelligence and Data Warehouses
7 hoursThe need for data analysis; BI architecture and decision-support data; the data warehouse, OLAP and star schemas; implementing a warehouse, data mining, SQL extensions for OLAP and materialised views; a Firebase case study.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- BI architecture and components
- Decision support systems
- Star and snowflake schemas
- OLAP operations
Unit 6: Data Analysis and Exploration
6 hoursMathematical models for decision making; data mining, data preparation and exploration; association rules.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Modelling in business intelligence
- Data mining and the KDD process
- Association rules
Unit contents are summarised from the official SUK syllabus . AiCanCode.org is not affiliated with Shivaji University, Kolhapur.