Book Details

Database Management Systems

Database Management Systems

Published by uLektz

Course Code:CS6302

Author:uLektz

University: Anna University, Tamil Nadu

Regulation:2013

Categories:Computer Science

Format : ico_bookePUB3 (DRM Protected)

Type :eBook

Rs.330 Rs.66 Rs.80% off

Preview Buy Now

Description :Database Management Systems

Note : No printed book. Only ebook. Access eBook using uLektz apps for Android, iOS and Windows Desktop PC.

Topics
UNIT I INTRODUCTION TO DBMS

1.1 File Systems Organization

1.2 Sequential, Pointer, Indexed, Direct

1.3 Purpose of Database System - Database System Terminologies-Database characteristics-Data models - Types of data models

1.4 Components of DBMS

1.5 Relational Algebra

1.6 LOGICAL DATABASE DESIGN: Relational DBMS -Codd's Rule -Entity-Relationship model -Extended ER Normalization -Functional Dependencies- Anomaly- 1NF to 5NF

1.7 Domain Key Normal Form

1.8 Denormalization

UNIT II SQL & QUERY OPTIMIZATION

2.1 SQL Standards

2.2 Data types

2.3 Database Objects- DDL-DML-TCL-Embedded SQL-Static Vs Dynamic SQL

2.4 QUERY OPTIMIZATION: Query Processing and Optimization -Heuristics and Cost Estimates in Query Optimization

UNIT III TRANSACTION PROCESSING AND CONCURRENCY CONTROL

3.1 Introduction

3.2 Properties of Transaction

3.3 Serializability

3.4 Concurrency Control

3.5 Locking Mechanisms-Two Phase Commit Protocol-Dead lock

UNIT IV TRENDS IN DATABASE TECHNOLOGY

4.1 Overview of Physical Storage Media

4.2 Magnetic Disks

4.3 RAID

4.4 Tertiary storage

4.5 File Organization

4.6 Organization of Records in Files

4.7 Indexing and Hashing -Ordered Indices -B+ tree Index Files -B tree Index Files -Static Hashing -5Dynamic Hashing

4.8 Introduction to Distributed Databases-Client server technology-Multidimensional and Parallel databases-Spatial and multimedia databases-Mobile and web databases

4.9 Data Warehouse

4.10 Mining

4.11 Data marts

UNIT V ADVANCED TOPICS

5.1 DATABASE SECURITY: Data Classification

5.2 Threats and risks

5.3 Database access Control

5.4 Types of Privileges

5.5 Cryptography

5.6 Statistical Databases

5.7 Distributed Databases

5.8 Architecture

5.9 Transaction Processing

5.10 Data Warehousing and Mining

5.11 Classification

5.12 Association rules

5.13 Clustering

5.14 Information Retrieval

5.15 Relevance ranking

5.16 Crawling and Indexing the Web

5.17 Object Oriented Databases

5.18 XML Databases

loading