Issue No. 04 - Oct.-Dec. (2012 vol. 34)
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/MAHC.2012.58
To improve performance of repetitive transactions in System R, IBM's Raymond Lorie devised a scheme to create, save, and reuse a generalized access plan that could be instantiated with specific values. The author recounts his role in compiling such generalized access plans into machine code for even better performance.
Relational databases, Performance evaluation, Scheduling, Programming, Computer languages, Software development, Encoding, machine language, history of computing, relational databases, relational database systems, IBM, System R, SQL, Raymond Lorie, System/370
Bradford W. Wade, "Compiling SQL into System/370 Machine Language", IEEE Annals of the History of Computing, vol. 34, no. , pp. 49-50, Oct.-Dec. 2012, doi:10.1109/MAHC.2012.58