Jagdish Chandra Patni

A database management system (DBMS) is a collection of programs that enable users to create and maintain a database; it also consists of a collection of interrelated data and a set of programs to access that data. Hence, a DBMS is a general-purpose software system that facilitates the processes of defining, constructing, and manipulating databases for various applications. The primary goal of a DBMS is to provide an environment that is both convenient and efficient to use in retrieving and storing database information. It is an interface between the user of application programs, on the one hand, and the database, on the other.The objective of Database Management System: An Evolutionary Approach, is to enable the learner to grasp a basic understanding of a DBMS, its need, and its terminologies discern the difference between the traditional file-based systems and a DBMS code while learning to grasp theory in a practical way study provided examples and case studies for better comprehensionThis book is intended to give under- and postgraduate students a fundamental background in DBMSs. The book follows an evolutionary learning approach that emphasizes the basic concepts and builds a strong foundation to learn more advanced topics including normalizations, normal forms, PL/SQL, transactions, concurrency control, etc.This book also gives detailed knowledge with a focus on entity-relationship (ER) diagrams and their reductions into tables, with sufficient SQL codes for a more practical understanding.

A Comprehensive Study of SQL - Practice and Implementation is designed as a textbook and provides a comprehensive approach to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. It demonstrates how to leverage the two most vital tools for data query and analysis – SQL and Excel – to perform comprehensive data analysis without the need for a sophisticated and expensive data mining tool or application.FeaturesThe book provides a complete collection of modeling techniques, beginning with fundamentals and gradually progressing through increasingly complex real-world case studiesIt explains how to build, populate, and administer high-performance databases and develop robust SQL-based applicationsIt also gives a solid foundation in best practices and relational theoryThe book offers self-contained lessons on key SQL concepts or techniques at the end of each chapter using numerous illustrations and annotated examplesThis book is aimed primarily at advanced undergraduates and graduates with a background in computer science and information technology. Researchers and professionals will also find this book useful.

A Comprehensive Study of SQL - Practice and Implementation is designed as a textbook and provides a comprehensive approach to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. It demonstrates how to leverage the two most vital tools for data query and analysis – SQL and Excel – to perform comprehensive data analysis without the need for a sophisticated and expensive data mining tool or application.FeaturesThe book provides a complete collection of modeling techniques, beginning with fundamentals and gradually progressing through increasingly complex real-world case studiesIt explains how to build, populate, and administer high-performance databases and develop robust SQL-based applicationsIt also gives a solid foundation in best practices and relational theoryThe book offers self-contained lessons on key SQL concepts or techniques at the end of each chapter using numerous illustrations and annotated examplesThis book is aimed primarily at advanced undergraduates and graduates with a background in computer science and information technology. Researchers and professionals will also find this book useful.

A database management system (DBMS) is a collection of programs that enable users to create and maintain a database; it also consists of a collection of interrelated data and a set of programs to access that data. Hence, a DBMS is a general-purpose software system that facilitates the processes of defining, constructing, and manipulating databases for various applications. The primary goal of a DBMS is to provide an environment that is both convenient and efficient to use in retrieving and storing database information. It is an interface between the user of application programs, on the one hand, and the database, on the other.The objective of Database Management System: An Evolutionary Approach, is to enable the learner to grasp a basic understanding of a DBMS, its need, and its terminologies discern the difference between the traditional file-based systems and a DBMS code while learning to grasp theory in a practical way study provided examples and case studies for better comprehensionThis book is intended to give under- and postgraduate students a fundamental background in DBMSs. The book follows an evolutionary learning approach that emphasizes the basic concepts and builds a strong foundation to learn more advanced topics including normalizations, normal forms, PL/SQL, transactions, concurrency control, etc.This book also gives detailed knowledge with a focus on entity-relationship (ER) diagrams and their reductions into tables, with sufficient SQL codes for a more practical understanding.

Wormhole routing is a popular switching technique being used in current generation parallel systems. Wormhole Routing is successful to deadlock due to its pipeline operation in the networks. In this book two deadlock free Wormhole Routing algorithms are given for Torus networks. First a simple and efficient minimal adaptive wormhole routing algorithm is presented that recovers from potential deadlocks. This algorithm removes those packets from the network that have stalled for more than a given timeout in a router. Second a fault-tolerant and non-adaptive routing algorithm is proposed for wormhole routed torus networks. This can tolerate any number of non-overlapping rectangular faulty blocks with simple logic and requires only three virtual channels. The algorithm is proved to provide deadlock-livelock free routing with non-overlapping f-rings. The use of such a limited number of virtual channels will significantly reduce the implementation cost of the algorithm in router hardware.