Skip to content
ISBN: B0D96KK8DW
ISBN13: 9798332740954

Database Management Systems: A practical approach (Database Technologies Series)

ISBN: B0D96KK8DW
ISBN13: 9798332740954
Formats

Conditions

Formats

Conditions

See all 1 editions

Book Overview

This book provides a comprehensive overview of database systems, starting with the fundamental concepts, such as database applications, purposes, data abstraction, models, languages, architecture, and the roles of users and administrators. It introduces database design through Entity-Relationship (ER) diagrams, exploring entities, attributes, relationships, and conceptual design with the ER model. The relational model is covered in detail, including integrity constraints, querying, and logical database design. The book delves into relational algebra and SQL, including basic and advanced queries, set operations, nested queries, and triggers. It addresses schema refinement and normalization, discussing problems of redundancy, decompositions, functional dependencies, and various normal forms up to the fifth normal form. Transaction management is thoroughly explained, focusing on the ACID properties, concurrency control, deadlocks, and crash recovery using ARIES. Finally, the book covers data storage and indexing, detailing file organization, clustered and secondary indexes, hash-based and tree-based indexing, and the use of B+ trees for dynamic indexing. This resource is essential for understanding both the theoretical and practical aspects of database systems.
Format:
Paperback
Language:
English
ISBN:
B0D96KK8DW
ISBN13:
9798332740954
Release Date:
July 2024
Publisher:
Independently published
Length:
216 Pages
Weight:
0.85 lbs.
Dimensions:
9.0″ × 0.5″ × 6.0″

More by Viswanadh Manne

Customer Reviews

0 customer ratings | 0 reviews
Write a Review

There are currently no reviews. Be the first to review this work.