Posts Tagged ‘ o’reilly media ’

SQL Tuning by Dan Tow

DOWNLOAD – mediafire

O’Reilly Media | 336 pages | 989.18 KB | english | ISBN-10: 0596005733 | ISBN-13: 978-0596005733 | CHM (file format) | 2003

A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications.

There are two basic issues to focus on when tuning SQL: how to find and interpret the execution plan of an SQL statement and how to change SQL to get a specific alternate execution plan. SQL Tuning provides answers to these questions and addresses a third issue that’s even more important: how to find the optimal execution plan for the query to use.

Author Dan Tow outlines a timesaving method he’s developed for finding the optimum execution plan–rapidly and systematically–regardless of the complexity of the SQL or the database platform being used. You’ll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book include exercises to reinforce the concepts you’ve learned. SQL Tuning concludes by addressing special concerns and unique solutions to “unsolvable problems.”

Whether you are a programmer who develops SQL-based applications or a database administrator or other who troubleshoots poorly tuned applications, SQL Tuning will arm you with a reliable and deterministic method for tuning your SQL queries to gain optimal performance.

Dan Tow is an independent consultant, operating under the banner SingingSQL (www.singingsql.com). His experience solving Oracle-related performance problems goes all the way back to his 1989 hire by Oracle Corporation. During most of his tenure at Oracle, Dan focused on the performance of Oracle Applications, managing the performance group for that division. In this role, he found a fertile testing ground for his SQL tuning method applied to the huge set of complex SQL included in those applications, including both online SQL and diverse batch processes. In 1998, Dan left Oracle to lead performance for TenFold Corporation, where he applied the same methods to tuning questions on DB2, and SQL Server, and Sybase, as well as on Oracle. In 2002, Dan started his own business, SingingSQL, through which he offers diverse database-related tuning services, including SQL tuning and systematically analyzing load to learn which SQL should be tuned. He has introduced his SQL tuning method to over 1,000 people in short lectures, and now offers in-depth courses in the material, using this book as textbook. Dan has a Ph.D. in chemical engineering from the University of Wisconsin at Madison. He lives in Palo Alto, California, and can be reached at dantow@singingsql.com.



DOWNLOAD – mediafire

2010
04/23
CATEGORY
Computer Science
Downloads
Textbooks
TAGS



































Leave a comment

MySQL Stored Procedure Programming by Steven Feuerstein

The implementation of stored procedures in MySQL 5.0 a huge milestone — one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures work — and how to build them the right way. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without.

In the decade since MySQL burst on the scene, it has become the dominant open source database, with capabilities and performance rivaling those of commercial RDBMS offerings like Oracle and SQL Server. Along with Linux and PHP, MySQL is at the heart of millions of applications. And now, with support for stored procedures, functions, and triggers in MySQL 5.0, MySQL offers the programming power needed for true enterprise use.

MySQL’s new procedural language has a straightforward syntax, making it easy to write simple programs. But it’s not so easy to write secure, easily maintained, high-performance, and bug-free programs. Few in the MySQL world have substantial experience yet with stored procedures, but Guy Harrison and Steven Feuerstein have decades of combined expertise.

In MySQL Stored Procedure Programming, they put that hard-won experience to good use. Packed with code examples and covering everything from language basics to application building to advanced tuning and best practices, this highly readable book is the one-stop guide to MySQL development. It consists of four major sections:

  • MySQL stored programming fundamentals — tutorial, basic statements, SQL in stored programs, and error handling
  • Building MySQL stored programs — transaction handling, built-in functions, stored functions, and triggers
  • MySQL stored programs in applications — using stored programs with PHP, Java, Perl, Python, and .NET (C# and VB.NET)
  • Optimizing MySQL stored programs — security, basic and advanced SQL tuning, optimizing stored program code, and programming best practices

A companion web site contains many thousands of lines of code, that you can put to use immediately.

Guy Harrison is Chief Architect of Database Solutions at Quest Software and a frequent speaker and writer on MySQL topics. Steven Feuerstein is the author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.

____________________

Guy Harrison has worked with databases for more than a decade, has conducted many MySQL and Oracle training seminars, and is author of several books on Oracle, including “Oracle Desk Reference” (Prentice Hall PTR). Currently a product architect at Quest Software, Harrison has conducted many training seminars and has authored several articles for the Oracle Technical Journal. He resides in Australia.

Steven Feuerstein is considered one of the world’s leading experts on the Oracle PL/SQL language. He is the author or coauthor of “Oracle PL/SQL Programming”, “Oracle PL/SQL Best Practices”, “Oracle PL/SQL Programming: Guide to Oracle8i Features”, “Oracle PL/SQL Developer’s Workbook”, “Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages”, and several pocket reference books (all from O’Reilly). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992. He is currently designing and building Qnxo (www.qnxo.com), the world’s first active mentoring software.

O’Reilly Media | 640 pages | 4.1 MB | english | ISBN-10: 0596100892 | ISBN-13: 978-0596100896 | CHM (file format) | 2006

DOWNLOAD – mediafire

2010
04/22
CATEGORY
Computer Science
Downloads
Textbooks
TAGS





































Leave a comment

MySQL in a Nutshell by Russell J. T. Dyer

When you need to find the right SQL keyword or MySQL client command-line option right away, turn to this convenient reference, known for the same speed and flexibility as the system it covers so thoroughly. MySQL is packed with so many capabilities that the odds of remembering a particular function or statement at the right moment are pretty slim. With MySQL in a Nutshell, you get the details you need, day in and day out, in one concise and extremely well organized book.

The new edition contains all the commands and programming information for version 5.1, including new features and language interfaces. It’s ideal for anyone using MySQL, from novices who need to get up to speed to advanced users who want a handy reference. Like all O’Reilly Nutshell references, it’s easy to use and highly authoritative, written by the editor of the MySQL Knowledge Base at MySQL AB, the creator and owner of MySQL.

Inside, you’ll find:

  • A thorough reference to MySQL statements, functions, and administrative utilities
  • Several tutorial chapters to help newcomers get started
  • Programming language APIs for PHP, Perl, and C
  • Brief tutorials at the beginning of each API chapter to help anyone, regardless of experience level, understand and master unfamiliar territory
  • New chapters on replication, triggers, and stored procedures
  • Plenty of new examples of how MySQL is used in practice
  • Useful tips to help you get through the most difficult subjects

Whether you employ MySQL in a mission-critical, heavy-use environment or for applications that are more modest, this book puts a wealth of easy-to-find information at your fingertips, saving you hundreds of hours of trial and error and tedious online searching. If you’re ready to take advantage of everything MySQL has to offer, MySQL in a Nutshell has precisely what it takes.

________________

Russell Dyer is a freelance writer specializing in MySQL database software and is the editor of the MySQL Knowledge Base (http://www.mysql.com/network/knowledgeba​se.html). He is the author of MySQL in a Nutshell (http://www.oreilly.com/catalog/mysqlian/) and has writen articles for several magazines: Dev Zone (a MySQL publication), Linux Journal, ONlamp.com, The Perl Journal, Red Hat Magazine, SysAdmin Magazine, Tech Republic, Unix Review, and XML.com. He has also finished his first novel, “In Search of Kafka”. More information on Russell, along with a list of his published articles with links to them, can be found on his web site at http://russell.dyerhouse.com

O’Reilly Media | 576 pages | 1.16 MB | english | ISBN-10: 0596514336 | ISBN-13: 978-0596514334 | CHM (file format) | 2008

DOWNLOAD – mediafire

2010
04/22
CATEGORY
Computer Science
Downloads
Textbooks
TAGS




































Leave a comment

MySQL CookBook by Paul Dubois

Good programming–which is to say, programming that yields both efficient code and a profitable life for the programmer–depends on not reinventing the wheel. If someone else has solved the problem you’re facing (and someone almost always has), you’d be foolish to waste your energy figuring out your own solution. MySQL Cookbook presents solutions to scores of problems related to the MySQL database server. Readers stand a good chance of finding a ready-made solution to problems such as querying databases, validating and formatting data, importing and exporting values, and using advanced features like session tracking and transactions. Paul DuBois has done a great job assembling efficient solutions to common database programming problems, and teaches his readers a lot about MySQL and its attendant APIs in the process.

DuBois organizes his cookbook’s recipes into sections on the problem, the solution stated simply, and the solution implemented in code and discussed. The implementation and discussion sections are the most valuable, as they contain the command sequences, code listings, and design explanations that can be transferred to outside projects. The main gripe readers will have about MySQL Cookbook is that the author, in his effort to cover the range of MySQL-friendly programming languages, uses different languages in his solutions to various problems. You’ll see a Perl solution to one programming challenge (Perl, in fact, is the most frequently used language, followed by PHP), a Python fix for the next, and a Java sample after that. Readers have to hope that they find a solution in the language they’re working with, or that they’re able to transliterate the one DuBois has provided. It’s usually not a big problem. –David Wall

Topics covered: How to make MySQL databases do your bidding–in terms of queries, table manipulation, data formatting, transactions, and Web interfaces–through the database server’s command line interfaces and (more importantly) through the MySQL APIs of Perl, PHP, Java, and Python. Particularly excellent coverage deals with formatting dates and times, management of null values, string manipulation, and import/export techniques.

O’Reilly Media | 976 pages | 1.41 MB | english | ISBN-10: 059652708X | ISBN-13: 978-0596527082 | CHM (microsoft compiled HTML help) | 2006

DOWNLOAD – mediafire

2010
04/22
CATEGORY
Computer Science
Downloads
Textbooks
TAGS

































Leave a comment