1.1. DATABASE MANAGEMENT SYSTEM BACKGROUND

A Database Management System (DBMS) is a software package whose purpose is to store, modify and retrieve large amounts of data.

A Relational Database Management System (RDBMS) can be thought of as a DBMS consisting of one or more collections of tables. Today's commercial RDBMS products

  • are organized as collections of tables, and also

  • use ANSI-standard SQL language

  • use client-server architecture

1.1.1. Brief History of Relational DBMSs and SQL Language

Table 1-1 summarizes the history of RDBMSs and SQL language development.

Table 1-1. Summary of RDBMS History
1970Dr. E. F. Codd of IBM Research Lab in San Jose published “A Relational Model of Data for Large Shared Data Banks.” This paper is considered to ...

Get Transact-SQL Desk Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial