+612 9045 4394
Refactoring SQL Applications : THEORY IN PRACTICE - Stephane Faroult

Refactoring SQL Applications



Published: 1st August 2008
Ships: 7 to 10 business days
7 to 10 business days
RRP $90.00
if ordered within

eBook View Product

Published: 9th February 2009
Format: ePUB

What can you do when database performance doesn't meet expectations? Before you turn to expensive hardware upgrades to solve the problem, reach for this book. "Refactoring SQL Applications" provides a set of tested options for making code modifications to dramatically improve the way your database applications function. Backed by real-world examples, you'll find quick fixes for simple problems, in-depth answers for more complex situations, and complete solutions for applications with extensive problems. Learn to:
Determine if and where you can expect performance gains Apply quick fixes, such as limiting calls to the database in stored functions and procedures Refactor tasks, such as replacing application code by a stored procedure, or replacing iterative, procedural statements with sweeping SQL statements Refactor flow by increasing parallelism and switching business-inducted processing from synchronous to asynchronous Refactor design using schema extensions, regular views, materialized views, partitioning, and more Compare before and after versions of a program to ensure you get the same results once you make modifications

"Refactoring SQL Applications" teaches you to recognize and assess code that needs refactoring, and to understand the crucial link between refactoring and performance. If and when your application bogs down, this book will help you get it back up to speed.

Prefacep. vii
Assessmentp. 1
A Simple Examplep. 2
Assessing Possible Gainsp. 19
Sanity Checksp. 37
Statistics and Data Skewnessp. 38
Indexing Reviewp. 44
Parsing and Bind Variablesp. 55
Bulk Operationsp. 70
Transaction Managementp. 73
User Functions and Viewsp. 75
User-Defined Functionsp. 76
Viewsp. 103
Testing Frameworkp. 115
Generating Test Datap. 116
Comparing Alternative Versionsp. 132
Statement Refactoringp. 147
Execution Plans and Optimizer Directivesp. 148
Analyzing a Slow Queryp. 152
Refactoring the Query Corep. 158
Rebuilding the Initial Queryp. 176
Task Refactoringp. 179
The SQL Mindsetp. 180
Restructuring the Codep. 185
Refactoring Flows and Databasesp. 211
Reorganizing Processingp. 212
Shaking Foundationsp. 233
How it Works: Refactoring in Practicep. 243
Can You Look at the Database?p. 243
Queries of Deathp. 245
All These Fast Queriesp. 247
No Obvious Very Wrong Queryp. 248
Time to Concludep. 249
Scripts and Sample Programsp. 251
Toolsp. 261
Indexp. 269
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9780596514976
ISBN-10: 0596514972
Audience: General
Format: Paperback
Language: English
Number Of Pages: 277
Published: 1st August 2008
Publisher: O'Reilly Media, Inc, USA
Country of Publication: US
Dimensions (cm): 23.2 x 17.8  x 1.91
Weight (kg): 0.49