Database Management Systems | Seema Kedar
Rs. 199.0000 13
Zoom

Sale Database Management Systems | Seema Kedar

DATABASE MANAGEMENT SYSTEMS

Index

Introduction to DBMS File systems organization - Sequential, Pointer, Indexed, Direct - Purpose of database system - Database system terminologies - Database characteristics - Data models - Types of data models - Components of DBMS - Relational algebra. Logical database design : Relational DBMS - Codd's rule - Entity - Relationship model - Extended ER normalization - Functional dependencies, Anomaly - 1NF to 5NF - Domain key normal form - Denormalization. SQL and Query Optimization SQL standards - Data types - Database objects - DDL - DML - DCL - TCL - Embedded SQL - Static Vs Dynamic SQL - Query optimization : Query processing and optimization - Heuristics and cost estimates in query optimization. Transaction Processing and Concurrency Control Introduction - Properties of transaction - Serializability - Concurrency control - Locking mechanisms - Two phase commit protocol - Deadlock. Trends in Database Technology Overview of physical storage media - Magnetic disks - RAID - Tertiary storage - File organization - Organization of records in files - Indexing and hashing - Ordered indices - B+ tree index files - B tree index files - Static hashing - Dynamic hashing - Introduction to distributed databases - Client server technology - Multidimensional and parallel databases - Spatial and multimedia databases - Mobile and web databases - Data warehouse - Mining - Data marts. Advanced Topics Database security : Data classification - Threats and risks - Database access control - Types of privileges - Cryptography - Statistical databases - Distributed databases - Architecture - Transaction processing - Data warehousing and mining - Classification - Association rules - Clustering - Information retrieval - Relevance ranking - Crawling and indexing the web - Object oriented databases - XML databases.

Author : Seema Kedar

Language : English

Publisher : Technical Publications

Pages : 488

Regulation : 2013

ISBN-13 : 9789350997178 For Anna University

Details
Publication Technical Publications
Writer Seema Kedar
ISBN-10 9350997177
ISBN-13 9789350997178

Write a review

Your Name:

Your Review:

Note: HTML is not translated!

Rating: Bad Good

Enter the code in the box below:

Latest tweets