October-2024 | ISBN: 978-93-6786-595-8
by: Dr.A. Vijayaraj | Mr. Hari Krishna Chilakala | Mr. Malladi Chanti | Mr. Jyoti Prakash Singh | Dr. Raksha Badgaiyan
Overview of the book
The title “Database Management Systems” presents a comprehensive study of the principles, architecture, and practical applications of database management systems (DBMS). This book explores the fundamental concepts of relational databases, including the purpose and structure of DBMS, data models, and system architecture. It provides in-depth coverage of key topics such as relational algebra, SQL fundamentals, database design, and the ACID properties crucial to maintaining data integrity.
Beginning with an introduction to database systems, the book elaborates on relational databases, illustrating the structure of tables, the use of keys (primary, foreign, and candidate keys), and data constraints to maintain accuracy and consistency. It progresses into database design principles, focusing on the Entity-Relationship (ER) model, normalization techniques to reduce redundancy, and functional dependencies to ensure efficient database organization.
The book covers advanced topics like transaction management, concurrency control, and database recovery techniques, which are essential in high-availability environments. The architecture of DBMS is discussed in detail, including the roles of query processors, storage managers, and different levels of data abstraction. Special sections on indexing, hashing, RAID, and query optimization techniques provide insights into improving database performance and managing large datasets.
In its final sections, the book delves into distributed databases, object-based databases, and XML databases, expanding on the role of DBMS in modern applications across various fields. Practical examples from industries like banking, healthcare, and e-commerce illustrate the relevance of DBMS in real-world scenarios. This book serves as a guide for students, database professionals, and software engineers, offering a robust foundation in the design and management of databases.
Click the below link to access the index
About the Author's
Dr.A.Vijayaraj is an Associate Professor in the Department of Information Technology, R.M.K Engineering College, RSM Nagar, Kavaraipettai, Gummidipoondi Taluk, Chennai. He obtained his Bachelor’s degree from Bharathidasan University in 1997 and Master of Engineering in CSE from Sathyabama University in 2005. He obtained his Ph.D. from Anna University, Chennai, India. His area of specialization is Computer Networks and communications, Mobile Computing, Information Retrieval, and Knowledge Management. He has 24 years of teaching experience from various Engineering Colleges during tenure he was Awarded Best Teacher Award thrice. He is a Member of IEEE, CSI, ISTE, IAENG, ICST, UACEE, IASTER and CSTA. He organized number of Workshops, Faculty development programs, Seminars, National and International conferences. He has Published 40 papers in (SCI and Scopus) reputed journals and 25 Papers in International IEEE and springer conferences and also Published 5 textbooks and 10 patents.
Mr. Chilakala Hari Krishna working as Associate Professor in the Department of Computer Science and Engineering at Rise Krishna Sai Gandhi Group of Institutions, Valluru, Ongole, Andhra Pradesh. He completed MCA at Acharya Nagarjuna University, Guntur, Andhra Pradesh. He secured Master of Technology in Computer Science under JNTUK, Kakinada, Pursuing Ph.D., in Computer Science and Engineering at JNTUK, Kakinada. He is in the field of Computer Science and Engineering at Rise Krishna Sai Gandhi Group of Institutions, Valluru, Ongole, Andhra Pradesh. He is in teaching profession for more than 10 years. He published 4 research papers in reputed journals. His research area includes Computer Networks, Machine Learning.
Mr.Malladi Chanti received his MCA (Master of Computer Applications) from V.V.R PG College, Osmania University in 2011 and M.Tech in Computer Science and Engineering from S.S.J Engineering College ,J.N.T.U.H in 2017.He is currently working as an Assistant Professor ,Department of Computer Science and Engineering in Malla Reddy Engineering College (Autonomous), Hyderabad, Telangana, India.
Prof. Jyoti Prakash Singh is currently serving as an Assistant Professor in the Department of Computer Science and Engineering. He completed his Bachelor of Technology in Information Technology in 2005 at KIET, Ghaziabad, Uttar Pradesh, and subsequently obtained a Master of Technology in Computer Science and Engineering from LNCT, Indore. He is presently engaged in doctoral research in Computer Science and Engineering at LNCT University, Bhopal, Madhya Pradesh. With over 12 years of experience in teaching and administrative roles within engineering institutions, Prof. Singh specializes in several key areas, including Data Science, Artificial Intelligence and Machine Learning, Programming Language Logic, Databases and Data Mining. His extensive academic background and research interests contribute significantly to the
advancement of knowledge in these domains.
Dr. Raksha Badgaiyan is a professor in the Department of Computer Science, Vipra Arts, Commerce and Physical Education College, Raipur (C.G.), where she has been since july 2023. She worked as Adhoc Assistant Professor for 5 years at Department of Computer Science of Govt. Bilasa Girls College Bilaspur (C.G.) and 3 year in Department of Computer Science of Govt. E.R.R. P.G. Science College, Bilaspur (C.G.). She Received B.Sc. Computer Science in 2006 and M.Sc. Computer Science in 2008 from Guru Ghasidas University, Bilaspur (C.G.). She Received M.Phil. Computer Science from Dr. C.V. Raman University, Kota Bilaspur (C.G.) in 2009. She received Ph.D. Computer Science from Kalinga Univerrsity, Naya Raipur (C.G.) in Jun 2022. Her research interests are data mining and machine learning with application in social impact of computing. In data mining she worked on classification based on different algorithm and clustering based on fuzzy logic. She presented research paper in 10 national and international conference and seminar. She attends many workshop and conference. Her 4 research papers are published in international journal and she also delivered 1 guest lecture.