Return to Answer

Typo and product names

Source Link

edited Oct 13, 2016 at 4:56

90.3k
30
424
663

Often the two terms are used interchangeably, so you may find MSMicrosoft 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-premesis MSSQLpremises 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 no-sqlNoSQL stores for "soft" supplementary data (and/or perhaps caching).

Often the two terms are used interchangeably, so you may find MS 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-premesis MSSQL 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 no-sql stores for "soft" supplementary data (and/or perhaps caching).

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).

Source Link

created Oct 13, 2016 at 4:31

David Spillett

32.4k
3
49
91

Often the two terms are used interchangeably, so you may find MS 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-premesis MSSQL 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 no-sql stores for "soft" supplementary data (and/or perhaps caching).