Название: The creation and management of database systems
Автор: Adele Kuzmiakova
Издательство: Arcler Press
Год: 2023
Страниц: 262
Язык: английский
Формат: pdf (true)
Размер: 21.2 MB

This book on creation and management of database systems provides an in-depth analysis of several real-world examples of database applications. This textbook offers a clear and comprehensive overview of the fundamentals, principles, and, in particular, sophisticated instrumentation techniques used in database systems. It discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource.The book examines different database concepts, principles, design, implementation, and management challenges. Each chapter is carefully divided into concise, reader-friendly chunks, with itemization of the key elements to remember. It solves database system challenges in a methodical and pragmatic manner. Diagrams and pictures can also be used to summarise key topics in order to improve learning. This book does an outstanding job of providing an overview of the many different aspects of database systems. The book is intended for all the readers from multidisciplinary backgrounds.

In the recent past, SQL has emerged as the dominant language for relational database management systems (RDBMSs). The Structured Query Language (SQL) specification was first developed in 1986 first by American National Standards Institute (ANSI), and it has been later approved for use internationally and accepted in 1987 even by International Organization for Standardization (ISO). SQL is presently supported by more than one hundred Database Systems, and it can operate on a wide variety of hardware platforms, including personal computers to mainframes. Even though SQL is now rather important, we do not make an effort to cover all aspects of the language because this particular standard is somewhat complicated. In this chapter, we will concentrate on the expressions of a language that are responsible for data modification.

The book is divided up into a total of eight different chapters. The reader is given an introduction to the principles of database systems in the first chapter. The data models are discussed in considerable depth in Chapter 2. The Database environment is covered in great detail in Chapter 3. In Chapter 4, the relational model is presented to the readers of the book. The planning and design of the database are given a lot of attention in Chapter 5. The concept of data manipulation is broken down and shown in Chapter 6. Database connectivity and web technologies are also discussed in Chapter 7. In the last chapter, “Chapter 8, Administration and Security of Databases,” we discuss database administration and security.