Lecture Notes || SNS Courseware

Subject Details

Dept : CSE

Sem : 4

Regul : R-2017

Faculty : Mr. Karthikeyan. K

phone : NIL

E-mail : sns.cse.karthik@gmail.com

1.668K

Page views

Files

Videos

R.Links

Lecture Notes

UNIT 1:

SQL fundamentals

Embedded SQL– Dynamic SQL

Advanced SQL features

Relational Algebra

Introduction to relational databases

Database System Architecture

Views of data

Purpose of Database System

introduction to Database System

UNIT 2:

Entity-Relationship model -E-R Diagrams

Enhanced-ER Model

Functional Dependencies

Non-loss Decomposition – First, Second

Third Normal Forms, Dependency Preservation

Multi-valued Dependencies and Fourth Normal Form

Join Dependencies and Fifth Normal Form

UNIT 3:

Transaction Recovery - Save Points

Transaction Concepts

ACID Properties

Schedules – Serializability

Concurrency Control – Need for Concurrency

Locking Protocols

Deadlock

Two Phase Locking

Transaction Recovery - Save Points

UNIT 4:

RAID – File Organization

Indexing and Hashing –Ordered Indices

B+ tree Index Files

B tree Index Files

Static Hashing – Dynamic Hashing

Query Processing Overview

Algorithms for SELECT and JOIN operations

Query optimization using Heuristics and Cost Estimation

UNIT 5:

Distributed Databases: Architecture

Data Storage, Transaction Processing

ODMG Object Model

Object-based Databases: Object Database Concepts

ODL, OQL - XML Databases

XML Hierarchical Model

Information Retrieval: IR Concepts, Retrieval Models

Queries in IR systems

Lecture Notes

Announcements

Recent Files

Copyright © SNS College Of Engineering 2014 Developed bySNSCE