System R (R*) Optimizer
- 7 Downloads
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*.
System R is a database management system based on a relational data model that was proposed by E. F. Codd  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...
- 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 ACM-SIGFIDET Workshop on Data Description, Access and Control; 1974. p. 249–64.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
- 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