liveBook · Manning

Database management system

Also called DBMS

A database management system is software that defines, stores, retrieves, modifies, and manages access to data in databases.

How 3 Manning books explain it

100 SQL Server Mistakes and How to Avoid Them

A database engine is the subsystem that processes queries, manages transactions, and accesses stored database data.

How it is used
Provides the core service for building and hosting relational databases and processing application queries.
How deep it goes
Traces protocol entry, parsing, algebraization, normalization, and optimization while stopping short of a complete execution treatment.
Examples
Uses a MagicChoc product query against dbo.Products, including stock logic, product imagery, and a cautioned NOLOCK hint.
What you can do after
Evaluate query flow and recognize how Database Engine choices can contribute to performance, data-loss, or security problems.

Read how 100 SQL Server Mistakes and How to Avoid Them explains database management system →

Building Web APIs with ASP.NET Core

A database management system is software that stores, organizes, retrieves, and manages access to structured data.

How it is used
Uses a DBMS as the persistent data source behind a web API and as an infrastructure choice for backend applications.
How deep it goes
Defines core DBMS properties and compares deployment options, but stops short of detailed database administration or transaction implementation.
Examples
Uses board-game data, static sample-data replacement, web API clients, on-premise servers, and cloud-hosted database services.
What you can do after
Evaluate and configure a DBMS choice for a web API, then connect it through Entity Framework Core.

Read how Building Web APIs with ASP.NET Core explains database management system →

Spring Start Here, Second Edition

A database management system (DBMS) is software for storing, retrieving, modifying, and managing data in databases.

How it is used
Positions the DBMS as the system a Java persistence layer connects to through a data source.
How deep it goes
Defines the DBMS and database, then explains connection management; does not detail DBMS internals.
Examples
Names MySQL, Postgres, and Oracle as relational database technologies Java apps can connect to.
What you can do after
Understand how a DBMS manages persisted data and why an app uses a data source for its connections.

Read how Spring Start Here, Second Edition explains database management system →

Also covered in

What to know first

Related concepts

Questions about database management system

What is database management system?

A database management system is software that defines, stores, retrieves, modifies, and manages access to data in databases.

Which Manning books explain database management system?

100 SQL Server Mistakes and How to Avoid Them, Building Web APIs with ASP.NET Core and Spring Start Here, Second Edition.

What should I know before learning database management system?

Manning books that teach database management system usually introduce container first.

What kinds of database management system are there?

Kinds of database management system include relational database management system and CloudBeaver.

What is database management system part of?

Database management system is part of SQL Server. SQL Server is Microsoft's relational database management system for storing, querying, and managing data.

What are the parts of database management system?

Database management system includes relational engine and storage engine.

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.