Abstract
The query-tree class shown in Chapter 12 and the heuristic optimizer shown in Chapter 13 form the first two of the three components that make up the DBXP query-execution engine. In this chapter, I show you how to expand the query-tree class to process project, restrict, and join operations. This will give you a glimpse into the world of database-query execution. I begin by briefly explaining the basic principles of the query execution algorithms and then jump into writing the code. Because the code for some of the methods is quite lengthy, not all of the code examples shown in this chapter include the complete source code. If you are following along by coding the examples, consider loading the source code for this chapter and using it rather than typing in the code from scratch.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Charles Bell
About this chapter
Cite this chapter
Bell, C. (2012). Query Execution. In: Expert MySQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4660-2_14
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4660-2_14
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4659-6
Online ISBN: 978-1-4302-4660-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books