SUK TY CSE (DS) syllabus

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.

  1. Unit 1: Parallel and Distributed Databases

    7 hours

    Centralised, 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
  2. Unit 2: Advanced SQL

    7 hours

    Relational 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
  3. Unit 3: NoSQL Database Management

    8 hours

    Features 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
  4. Unit 4: Database Administration and Security

    7 hours

    The 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
  5. Unit 5: Business Intelligence and Data Warehouses

    7 hours

    The 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
  6. Unit 6: Data Analysis and Exploration

    6 hours

    Mathematical 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.