eBooks-it.org Logo
eBooks-IT.org Inner Image

Refactoring SQL Applications

Refactoring SQL Applications Image

Book Details:

Publisher:O'Reilly Media, Inc.
Series: OReilly
Author:Stephane Faroult
Edition:1
ISBN-10:0596514972
ISBN-13:9780596514976
Pages:277
Published:Dec 08 2008
Posted:Nov 19 2014
Language:English
Book format:PDF
Book size:2.27 MB

Book Description:

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, youll 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.

Download Link:

Related Books:

Oracle Database 10g

XML & SQL Design, Build, & Manage XML Applications in Java, C, C++ & PL/SQL
Oracle Database 10g Image
Written by members of the Oracle XML group, this is a must-have reference for all IT managers, DBAs, and developers who want to learn the best practices for using XML with Oracle's XML-enabled products. Includes real-world case studies based on the authors' experience managing Oracle's XML Discussion Forum--a community of 20,000+ XML component users....

Refactoring

Improving the Design of Existing Code
Refactoring Image
Refactoring is about improving the design of existing code. It is the process of changing a software system in such a way that it does not alter the external behavior of the code, yet improves its internal structure. With refactoring you can even take a bad design and rework it into a good one. This book offers a thorough discussion of the principles of refactoring, including where to spot opportunities for refactoring, and how to set up the required tests. There is also a catalog of more than 40 proven refactorings with details as to when and why to use the refactoring, step by step instructions for implementing it, and an example illustrating how it works The book is written using Java as its principle language, but the ideas are applicable to any ...

Refactoring in Ruby

Refactoring in Ruby Image
The First Hands-On, Practical, All-Ruby Refactoring Workbook! Refactoringthe art of improving the design of existing codehas taken the world by storm. So has Ruby. Now, for the first time, there's a refactoring workbook designed from the ground up for the dynamic Ruby language. Refactoring in Ruby gives you all the realistic, hands-on practice you need to refactor Ruby code quickly and effectively. You'll discover how to recognize 'code smells,' which signal opportunities for improvement, and then perfect your program's design one small, safe step at a time. The book shows you when and how to refactor with both legacy code and during new test-driven development, and walks you through real-world refactoring in detail. The workbook concludes w...



2007 - 2021 © eBooks-IT.org