Data and knowledge in database systems: relational databases

  • Authors:

  • Raghu Ramakrishnan

  • Affiliations:

  • Professor of Computer Science, University of Wisconsin at Madison

  • Venue:
  • Handbook of data mining and knowledge discovery
  • Year:
  • 2002

Quantified Score

Hi-index 0.00

Visualization

Abstract

Relational Database Management Systems (RDBMS) are widely used to store, manipulate, and query large data sets in a variety of applications. Complex application packages supporting human resource management, enterprise resource planning, and so on have been developed to run on top of RDBMS, and have helped to make RDBMS ubiquitous; virtually every major organization today relies upon an RDBMS to handle payroll, sales, inventory, and other mission-critical data. The underlying technology has been developed over the last three decades, and has proved itself in demanding situations involving vast data sets and requiring nonstop operations. We introduce the data model and query language used in relational systems. We also touch upon how an RDBMS stores data, optimizes and executes queries, handles concurrent requests, and recovers from system failures.