While you may know the basics of a relational database management system (RDBMS) and be an expert at administering the system, you may have never explored the inner workings of a database system. Most of us have been trained on and have experience with managing database systems, but neither academic nor professional training includes much about the way database systems are constructed. A database professional may never need this knowledge, but it is good to know how the system works so that you can understand how best to optimize your server and even how best to utilize its features.
KeywordsDatabase System Client Application Execution Plan Query Optimizer Query Execution
Unable to display preview. Download preview PDF.
- 3.C. J. Date, The Database Relational Model: A Retrospective Review and Analysis (Reading, MA: Addison-Wesley, 2001).Google Scholar
- 4.C. J. Date and H. Darwen Foundation for Future Database Systems: The Third Manifesto (Reading, MA: Addison-Wesley, 2000).Google Scholar
- 7.M. Stonebraker and J. L. Hellerstein, Readings in Database Systems, 3rd ed., edited by Michael Stonebraker (Morgan Kaufmann Publishers, 1998).Google Scholar
- 8.C. J. Date, The Database Relational Model: A Retrospective Review and Analysis (Reading, MA: Addison-Wesley, 2001).Google Scholar
- 9.R. Elmasri and S. B. Navathe, Fundamentals of Database Systems, 4th ed. (Boston: Addison-Wesley, 2003).Google Scholar
- 12.M. Kruckenberg and J. Pipes. Pro MySQL. (Berkeley, CA: Apress, 2005).Google Scholar