| Anna University CSE | | Anna University IT |

Database Management Systems - CS8492

Online Study Material, Lecturing Notes, Assignment, Reference, Wiki and important questions and answers

| Anna University CSE | | Anna University IT |

UNIT I RELATIONAL DATABASES

UNIT II DATABASE DESIGN

UNIT III TRANSACTIONS

UNIT IV IMPLEMENTATION TECHNIQUES

UNIT V ADVANCED TOPICS

Refer

INTRODUCTION TO DBMS

=> Trust Management in Virtualized Data Centers
=> Introduction to DBMS(Database Management Systems)
=> Purpose of Database Systems
=> File systems vs Database systems
=> Database System Terminologies
=> Data Models
=> Components of DBMS
=> Relational Algebra
=> ER Model
=> Functional Dependencies Definition
=> Database Normalization
=> Data Anomalies

SQL and QUERY OPTIMIZATION

=> SQL Overview
=> Data Types in SQL
=> object-oriented database management system
=> Data Definition Language or Data Description Language(DDL)
=> Data Manipulation Language (DML)
=> Data Control Language(DCL)
=> Transaction Control Language (TCL)
=> Embedded SQL
=> Query Processing and Optimization (QPO)

TRANSACTION PROCESSING AND CONCURRENCY CONTROL

=> Transaction Processing
=> Introduction to Concurrency
=> Lock
=> Two-Phase Locking Techniques: The algorithm

TRENDS IN DATABASE TECHNOLOGY

=> Physical Storage Media
=> RAID: Redundant Arrays of Independent Disks
=> File Operations
=> Hashing
=> Indexing
=> B+-Tree Index Files
=> Data Warehouse
=> Data Mining
=> Mobile Databases
=> Spatial Database Types of Spatial Data
=> Multi-dimensional Indexes

ADVANCED TOPICS

FUNDAMENTALS OF Database Systems by Ramez Elmasri and Shamkant B Navathe

PART 1 Introduction to Databases

chapter 1 Databases and Database Users

=> Databases and Database Users
=> An Example - Databases and Database Users
=> Characteristics of the Database Approach
=> Actors on the Scene - Databases and Database Users
=> Workers behind the Scene - Databases and Database Users
=> Advantages of Using the DBMS Approach
=> A Brief History of Database Applications
=> When Not to Use a DBMS

chapter 2 Database System Concepts and Architecture

=> Database System Concepts and Architecture
=> Data Models, Schemas, and Instances
=> Three-Schema Architecture and Data Independence
=> Database Languages and Interfaces
=> The Database System Environment
=> Centralized and Client/Server Architectures for DBMSs
=> Classification of Database Management Systems

PART 2 The Relational Data Model and SQL

chapter 3 The Relational Data Model and Relational Database Constraints

=> The Relational Data Model and Relational Database Constraints
=> Relational Model Concepts
=> Relational Model Constraints and Relational Database Schemas
=> Update Operations, Transactions, and Dealing with Constraint Violations

chapter 4 Basic SQL

=> Basic SQL
=> SQL Data Definition and Data Types
=> Specifying Constraints in SQL
=> Basic Retrieval Queries in SQL
=> INSERT, DELETE, and UPDATE Statements in SQL
=> Additional Features of SQL

chapter 5 More SQL Complex Queries Triggers Views and Schema Modification

=> More SQL: Complex Queries, Triggers, Views, and Schema Modification
=> More Complex SQL Retrieval Queries
=> Specifying Constraints as Assertions and Actions as Triggers
=> Views (Virtual Tables) in SQL
=> Schema Change Statements in SQL

chapter 6 The Relational Algebra and Relational Calculus

=> The Relational Algebra and Relational Calculus
=> Unary Relational Operations: SELECT and PROJECT
=> Relational Algebra Operations from Set Theory
=> Binary Relational Operations: JOIN and DIVISION
=> Additional Relational Operations
=> Examples of Queries in Relational Algebra
=> The Tuple Relational Calculus
=> The Domain Relational Calculus

PART 3 Conceptual Modeling and Database Design

chapter 7 Data Modeling Using the Entity Relationship ER Model

=> Data Modeling Using the Entity-Relationship (ER) Model
=> Using High-Level Conceptual Data Models for Database Design
=> A Sample Database Application
=> Entity Types, Entity Sets, Attributes, and Keys
=> Relationship Types, Relationship Sets, Roles, and Structural Constraints
=> Weak Entity Types
=> Refining the ER Design for the COMPANY Database
=> ER Diagrams, Naming Conventions, and Design Issues
=> Example of Other Notation: UML Class Diagrams
=> Relationship Types of Degree Higher than Two

chapter 8 The Enhanced Entity Relationship EER MODEL

=> The Enhanced Entity-Relationship (EER) Model
=> Subclasses, Superclasses, and Inheritance
=> Specialization and Generalization
=> Constraints and Characteristics of Specialization and Generalization Hierarchies
=> Modeling of UNION Types Using Categories
=> A Sample UNIVERSITY EER Schema, Design Choices, and Formal Definitions
=> Example of Other Notation: Representing Specialization and Generalization in UML Class Diagrams
=> Data Abstraction, Knowledge Representation, and Ontology Concepts

chapter 9 Relational Database Design by ER and EER to Relational Mapping

=> Relational Database Design by ER- and EER-to-Relational Mapping
=> Relational Database Design Using ER-to-Relational Mapping
=> Mapping EER Model Constructs to Relations

chapter 10 Practical Database Design Methodology and Use of UML Diagrams

=> Practical Database Design Methodology and Use of UML Diagrams
=> The Role of Information Systems in Organizations
=> The Database Design and Implementation Process
=> The Database Design and Implementation Process: Phase 1: Requirements Collection and Analysis
=> The Database Design and Implementation Process: Phase 2: Conceptual Database Design
=> The Database Design and Implementation Process: Phase 3: Choice of a DBMS
=> Database Design and Implementation Process: Phase 4: Data Model Mapping (Logical Database Design)
=> Database Design and Implementation Process: Phase 5: Physical Database Design
=> Database Design and Implementation Process: Phase 6: Database System Implementation and Tuning
=> Use of UML Diagrams as an Aid to Database Design Specification
=> Rational Rose: A UML-Based Design Tool
=> Automated Database Design Tools

PART 4 Object Object Relational and XML Concepts Models Languages and Standards

chapter 11 Object and Object Relational Databases

=> Object and Object-Relational Databases
=> Overview of Object Database Concepts
=> Introduction to Object-Oriented Concepts and Features
=> Object Identity, and Objects versus Literals
=> Complex Type Structures for Objects and Literals
=> Encapsulation of Operations and Persistence of Objects
=> Type Hierarchies and Inheritance
=> Object-Relational Features: Object Database Extensions to SQL
=> The ODMG Object Model and the Object Definition Language ODL
=> Object Database Conceptual Design
=> The Object Query Language OQL
=> Overview of the C++ Language Binding in the ODMG Standard

chapter 12 XML Extensible Markup Language

=> XML: Extensible Markup Language
=> Structured, Semistructured, and Unstructured Data
=> XML Hierarchical (Tree) Data Model
=> XML Documents, DTD, and XML Schema
=> Storing and Extracting XML Documents from Databases
=> XML Languages
=> Extracting XML Documents from Relational Databases

PART 5 Database Programming Techniques

chapter 13 Introduction to SQL Programming TECHNIQUES

=> Introduction to SQL Programming Techniques
=> Database Programming: Techniques and Issues
=> Embedded SQL, Dynamic SQL, and SQLJ
=> Retrieving Single Tuples with Embedded SQL
=> Retrieving Multiple Tuples with Embedded SQL Using Cursors
=> Specifying Queries at Runtime Using Dynamic SQL
=> SQLJ: Embedding SQL Commands in Java
=> Retrieving Multiple Tuples in SQLJ Using Iterators
=> Database Programming with Function Calls: SQL/CLI and JDBC
=> Database Stored Procedures and SQL/PSM
=> Comparing the Three Approaches

chapter 14 Web Database Programming Using PHP

=> Web Database Programming Using PHP
=> A Simple PHP Example
=> Overview of Basic Features of PHP
=> Overview of PHP Database Programming

PART 6 Database Design Theory and Normalization

chapter 15 Basics of Functional Dependencies and Normalization or Relational Databases

=> Basics of Functional Dependencies and Normalization for Relational Databases
=> Informal Design Guidelines for Relation Schemas
=> Functional Dependencies
=> Normal Forms Based on Primary Keys
=> General Definitions of Second and Third Normal Forms
=> Boyce-Codd Normal Form
=> Multivalued Dependency and Fourth Normal Form
=> Join Dependencies and Fifth Normal Form

chapter 16 Relational Database Design Algorithms and Further Dependencies

=> Relational Database Design Algorithms and Further Dependencies
=> Further Topics in Functional Dependencies: Inference Rules, Equivalence, and Minimal Cover
=> Properties of Relational Decompositions
=> Algorithms for Relational Database Schema Design
=> About Nulls, Dangling Tuples, and Alternative Relational Designs
=> Further Discussion of Multivalued Dependencies and 4NF
=> Other Dependencies and Normal Forms

PART 7 File Structures Indexing and Hashing

chapter 17 Disk Storage Basic File Structures and Hashing

=> Disk Storage, Basic File Structures, and Hashing
=> Secondary Storage Devices
=> Buffering of Blocks
=> Placing File Records on Disk
=> Operations on Files
=> Files of Unordered Records (Heap Files)
=> Files of Ordered Records (Sorted Files)
=> Hashing Techniques
=> Internal Hashing
=> External Hashing for Disk Files
=> Hashing Techniques That Allow Dynamic File Expansion
=> Other Primary File Organizations
=> Parallelizing Disk Access Using RAID Technology
=> New Storage Systems

chapter 18 Indexing Structures for Files

=> Indexing Structures for Files
=> Types of Single-Level Ordered Indexes
=> Multilevel Indexes
=> Dynamic Multilevel Indexes Using B-Trees and B+-Trees
=> Search Trees and B-Trees
=> B+-Trees
=> Indexes on Multiple Keys
=> Other Types of Indexes
=> Some General Issues Concerning Indexing

PART 8 Query Processing and Optimization and Database Tuning

chapter 19 Algorithms for Query Processing and Optimization

=> Algorithms for Query Processing and Optimization
=> Translating SQL Queries into Relational Algebra
=> Algorithms for External Sorting
=> Implementing the SELECT Operation and Algorithms
=> Implementing the JOIN Operation and Algorithms
=> Algorithms for PROJECT and Set Operations
=> Implementing Aggregate Operations and OUTER JOINs
=> Combining Operations Using Pipelining
=> Using Heuristics in Query Optimization
=> Using Selectivity and Cost Estimates in Query Optimization
=> Cost Components for Query Execution
=> Catalog Information Used in Cost Functions
=> Examples of Cost Functions for SELECT
=> Examples of Cost Functions for JOIN
=> Multiple Relation Queries and JOIN Ordering
=> Example to Illustrate Cost-Based Query Optimization
=> Overview of Query Optimization in Oracle
=> Semantic Query Optimization

chapter 20 Physical Database Design and Tuning

=> Physical Database Design and Tuning
=> Physical Database Design in Relational Databases
=> Factors That Influence Physical Database Design
=> Physical Database Design Decisions
=> An Overview of Database Tuning in Relational Systems

PART 9 Transaction Processing Concurrency Control and Recovery

chapter 21 Introduction to Transaction Processing Concepts and Theory

=> Introduction to Transaction Processing Concepts and Theory
=> Introduction to Transaction Processing
=> Transaction and System Concepts
=> Desirable Properties of Transactions
=> Characterizing Schedules Based on Recoverability
=> Characterizing Schedules Based on Serializability
=> Transaction Support in SQL

chapter 22 Concurrency Control Techniques

=> Concurrency Control Techniques
=> Two-Phase Locking Techniques for Concurrency Control
=> Concurrency Control Based on Timestamp Ordering
=> Multiversion Concurrency Control Techniques
=> Validation (Optimistic) Concurrency Control Techniques
=> Granularity of Data Items and Multiple Granularity Locking
=> Using Locks for Concurrency Control in Indexes
=> Other Concurrency Control Issues

chapter 23 Database Recovery Techniques

=> Database Recovery Techniques
=> Recovery Concepts
=> NO-UNDO/REDO Recovery Based on Deferred Update
=> Recovery Techniques Based on Immediate Update
=> Shadow Paging
=> The ARIES Recovery Algorithm
=> Recovery in Multidatabase Systems
=> Database Backup and Recovery from Catastrophic Failures

PART 10 Additional Database Topics Security and Distribution

chapter 24 Database Security

=> Database Security
=> Introduction to Database Security Issues
=> Discretionary Access Control Based on Granting and Revoking Privileges
=> Mandatory Access Control and Role-Based Access Control for Multilevel Security
=> SQL Injection
=> Introduction to Statistical Database Security
=> Introduction to Flow Control
=> Encryption and Public Key Infrastructures
=> Privacy Issues and Preservation
=> Challenges of Database Security
=> Oracle Label-Based Security

chapter 25 Distributed Databases

=> Distributed Databases
=> Distributed Database Concepts
=> Types of Distributed Database Systems
=> Distributed Database Architectures
=> Data Fragmentation, Replication, and Allocation Techniques for Distributed Database Design
=> Query Processing and Optimization in Distributed Databases
=> Overview of Transaction Management in Distributed Databases
=> Overview of Concurrency Control and Recovery in Distributed Databases
=> Distributed Catalog Management
=> Current Trends in Distributed Databases
=> Distributed Databases in Oracle

PART 11 Advanced Database Models Systems and Applications

chapter 26 Enhanced Data Models for Advanced Applications

=> Enhanced Data Models for Advanced Applications
=> Active Database Concepts and Triggers
=> Temporal Database Concepts
=> Spatial Database Concepts
=> Multimedia Database Concepts
=> Introduction to Deductive Databases

chapter 27 Introduction to Information Retrieval and Web Search

=> Introduction to Information Retrieval and Web Search
=> Information Retrieval (IR) Concepts
=> Retrieval Models
=> Types of Queries in IR Systems
=> Text Preprocessing
=> Inverted Indexing
=> Evaluation Measures of Search Relevance
=> Web Search and Analysis
=> Trends in Information Retrieval

chapter 28 Data Mining Concepts

=> Data Mining Concepts
=> Overview of Data Mining Technology
=> Association Rules
=> Classification - Data Mining
=> Clustering
=> Approaches to Other Data Mining Problems
=> Applications of Data Mining
=> Commercial Data Mining Tools

chapter 29 Overview of Data Warehousing and OLAP

=> Overview of Data Warehousing and OLAP
=> Introduction, Definitions, and Terminology - Data warehouses
=> Characteristics of Data Warehouses
=> Data Modeling for Data Warehouses
=> Building a Data Warehouse
=> Typical Functionality of a Data Warehouse
=> Data Warehouse versus Views
=> Difficulties of Implementing Data Warehouses

CS8492 Database Management Systems - Anna University 2017 Regulation Syllabus - Download Pdf
Download Anna University Notes Android App
Database Management Systems - Start Reading Online

Engineering Electrical Engineering Electronics Engineering Civil Engineering Mechanical Engineering Computer Science Engineering Information Technology Medical MBBS Nursing BPharm MD MBA AnnaUniv MBA TN School 11th 12th Anna University EEE - Anna University ECE - Anna University Civil - Anna University MECH - Anna University CSE - Anna University IT - Anna University Online Student Guide UPSC Civil services Entrance exams GATE Exam GATE Exam EE Electrical GATE Exam EC Electronics GATE Exam CS Computer Science GATE Exam CE Civil GATE Exam ME Mechanical IIT JEE IEEE Entrance Exam NEET Entrance Exam AIIMS Entrance Exams Problem Solving and Reasoning Verbal, Reading Comprehension Data Interpretation Logical Reasoning Mathematics or Quantitative CAT Entrance Exams CLAT LAW Entrance exams Banking Entrance exams TANCET Anna University TN State Board one mark TN 11th Standard one mark