Command use in a relational database system

  • Authors:
  • John D. Joyce;David R. Warn

  • Affiliations:
  • General Motors Research Laboratories, Warren, Michigan;General Motors Research Laboratories, Warren, Michigan

  • Venue:
  • AFIPS '83 Proceedings of the May 16-19, 1983, national computer conference
  • Year:
  • 1983

Quantified Score

Hi-index 0.00

Visualization

Abstract

A study of commands in a relational database system was undertaken to provide a basis for improving future implementations of relational techniques. The use of Regis (Relational General Information System), an interactive relational database system developed at General Motors Research Laboratories, was monitored to accumulate a large amount of data about distribution of command uses across a variety of applications developed by users with a diverse set of capabilities. Of the basic relational commands, it is important that searching, PROJECTION, and JOIN operations be efficient. However, optimizing INTERSECTION and "exclusive or" may not warrant the time and effort it would require. Although proportions of use varied, the rankings of use of relational operations were reasonably independent of applications and the programming expertise level of the users.