Skip to main content
SpringerLink
Log in

System R (R*) Optimizer

  • Living reference work entry
  • First Online:
Encyclopedia of Database Systems

  • 44 Accesses

Definition

The System R Optimizer is the cost-based query optimizer of System R. It pioneered several optimization techniques, including using dynamic programming for bottom-up join tree construction, and the concept of interesting orderings for exploiting ordering in intermediate results. Later, it was generalized for distributed database systems in System R*.

Historical Background

System R is a database management system based on a relational data model that was proposed by E. F. Codd [4] in 1970. The system offers data independence by providing a high-level user interface through which the end user deals with data content rather than the underlying storage structures. In other words, users do not need to know how the tuples are physically stored and which access paths are available to write queries. Thus, data storage structures may change over time without users being aware of it, providing a high level of data independence and user productivity. Moreover, System R offers...

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

Recommended Reading

  1. Astrahan MM, Blasgen MW, Chamberlin DD, Eswaran KP, Gray J, Griffiths PP, King WF, Lorie RA, McJones PR, Mehl JW, Putzolu GR, Traiger IL, Wade BW, Watson V. System R: relational approach to database management. ACM Trans Database Syst. 1979; 1(2):97–137.

    Google Scholar 

  2. Chamberlin DD, Astrahan MM, Blasgen MW, Gray J, King WF, Lindsay BG, Lorie RA, Mehl JW, Price TG, Putzolu GR, Selinger PG, Schkolnick M, Slutz DR, Traiger IL, Wade BW, Yost RA. A history and evaluation of system R. Commun. ACM. 1981; 24(10):632–46.

    Google Scholar 

  3. Chamberlin DD, Boyce RF. SEQUEL: A Structured English Query Language. In: Proceedings of the SIGMOD workshop. Vol. 1. 1974. p. 249–64.

    Google Scholar 

  4. Codd EF. A relational model of data for large shared data banks. Commun. ACM. 1970; 13(6):377–87.

    Google Scholar 

  5. Gray J. Notes on data base operating systems. In: Advanced course: operating systems. 1978. p. 393–481.

    Google Scholar 

  6. Lohman GM, Mohan C, Haas LM, Daniels D, Lindsay BG, Selinger PG, Wilms PF. Query processing in R*. In: Query processing in database systems. Springer; 1985. p. 31–47.

    Google Scholar 

  7. Lorie RA, Nilsson JF. An access specification language for a relational data base system. IBM J Res Dev. 1979; 23(3):286.

    Google Scholar 

  8. Selinger PG, Astrahan MM, Chamberlin DD, Lorie RA, Price TG. Access path selection in a relational database management system. In: Proceedings of the ACM SIGMOD international conference on management of data. 1979. p. 23–34.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Max-Planck Institute for Informatics, Saarbrücken, Germany

    Mouna Kacimi & Thomas Neumann

Authors
  1. Mouna Kacimi
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Thomas Neumann
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Mouna Kacimi .

Editor information

Editors and Affiliations

  1. Georgia Institute of Technology College of Computing, Atlanta, Georgia, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, Ontario, Canada

    M. Tamer Özsu

Section Editor information

  1. Dept. of Computer Science, Univ. of Ioannina, P.O. Box 1186, 45110, Ioannina, Greece

    Evaggelia Pitoura

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer Science+Business Media LLC

About this entry

Cite this entry

Kacimi, M., Neumann, T. (2016). System R (R*) Optimizer. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_384-2

Download citation

  • DOI: https://doi.org/10.1007/978-1-4899-7993-3_384-2

  • Received:

  • Accepted:

  • Published:

  • Publisher Name: Springer, New York, NY

  • Online ISBN: 978-1-4899-7993-3

  • eBook Packages: Springer Reference Computer SciencesReference Module Computer Science and Engineering

Publish with us

Policies and ethics

Search

Navigation