0

I was reading book "Database System Concepts" (6th edition by Henry F Korth Abraham Silberschatz, S Sudharshan

There is slight confusion between database system and DBMS Are both term same or different?

A database system is a collection of interrelated data and a set of programs that allow users to access and modify these data.

A database-management system (DBMS) is a collection of interrelated data and a set of programs to access those data.

What I understand--- A database system (DBMS) means a set of programs to access and modify data.

A database-management system (DBMS) means a set of programs to only access data.

1 Answer 1

2

Often the two terms are used interchangeably, so you may find Microsoft SQL Server or Postgres being referred to as either a DBMS or a database system.

Where a distinction is maintained "database system" usually refers to the overall application or set of applications that constitute a project. So for instance in the case of a business management suite that has a few applications which uses a few on-premises SQL Server databases for online storage, and has a data warehouse in some cloud database for reporting, and utilities for maintaining the warehouse and running reports; the application suite is a "database system" that itself uses one or more instances of one or more "database management systems" as part of its construction.

A "database system" in that respect might use several different database management systems in its design. A single application suite may use OLTP style stores for the main data, OLAP optimised stores for reporting, and NoSQL stores for "soft" supplementary data (and/or perhaps caching).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.