|
Free ebooks
 Free database ebooks SQL Expert MySQL - The Expert's Voice in Open Source
|
 The first part of the ebook, “Getting Started with MySQL Development,” is used to introduce concepts in developing and modifying open source systems. Part 1 provides you with the tools and resources necessary to begin exploring the more advanced database concepts presented in the rest of the book.Chapter 1, “MySQL and the Open Source Revolution,” is less technical and contains more narration than the rest of the book. It guides you through the benefits and responsibilities of an open source system integrator. It highlights the rapid growth of MySQL and its importance in the open source and database system markets. Chapter 2, “The Anatomy of a Database System,” covers the basics of what a database system is and how it is constructed. The anatomy of the MySQL system is used to illustrate the key components of modern relational database systems. Chapter 3, “A Tour of the MySQL Source Code,” presents a complete introduction to the MySQL source along with how to obtain and build the system. You are introduced to the mechanics of the source code along with coding guidelines and best practices for how the code is maintained. Chapter 4, “Test-Driven MySQL Development,” introduces a key element in generating high-quality extensions to the MySQL system. Software testing is presented along with the common practices of how to test large systems. Part 2, “Extending MySQL,” uses a hands-on approach to investigate the MySQL system. It introduces you to how the MySQL code can be modified and how the system can be used as an embedded database system. Examples and projects are used to illustrate how to debug the source code, how to modify the SQL commands to extend the language, and how to build a custom storage engine. Chapter 5, “Debugging,” examines debugging skills and techniques that help make development easier and less prone to failure. Several debugging techniques are presented, along with the pros and cons of each. Chapter 6, “Embedded MySQL,” provides a tutorial on embedding the MySQL system in enterprise applications. Example projects assist you in applying the skills you’ll learn to your own integration needs. Chapter 7, “Building Your Own Storage Engine,” is the first of the MySQL modification chapters. It demonstrates techniques that require the least amount of modifications to the MySQL code. Chapter 8, “Adding Functions and Commands to MySQL,” presents the most popular modification to the MySQL code. You are shown how to modify the SQL commands and how to build custom SQL commands. Part 3, “Advanced Database Internals,” takes a deeper look into the MySQL system and provides you with an insider’s look at what makes the system work. The part begins with an introduction to the advanced database technologies. Theory and practices are presented in a no-nonsense manner to enable you to apply the knowledge gained to tackle the more complex topics of database systems. This part also presents examples of how to implement an internal query representation, an alternative query optimizer, and an alternative query execution mechanism. Chapter 9, “Database Systems Internals,” presents advanced database techniques and examines the MySQL architecture. Topics include query execution, multiuser concerns, and programmatic considerations. Chapter 10, “Internal Query Representation,” discusses the MySQL internal query representation. You are provided with an example alternative query representation. Chapter 11, “Query Optimization,” presents the MySQL internal query optimizer. The chapter includes an example alternative query optimizer that uses the alternative query representation from the previous chapter. Chapter 12, “Query Execution,” combines the techniques from the previous chapters to provide you with instructions on how to modify the MySQL system to implement alternative query processing engine techniques. Download free ebooks of SQL:Expert MySQL - The Expert's Voice in Open Source
|
