IniciGrupsConversesMésTendències
Cerca al lloc
Aquest lloc utilitza galetes per a oferir els nostres serveis, millorar el desenvolupament, per a anàlisis i (si no has iniciat la sessió) per a publicitat. Utilitzant LibraryThing acceptes que has llegit i entès els nostres Termes de servei i política de privacitat. L'ús que facis del lloc i dels seus serveis està subjecte a aquestes polítiques i termes.
Hide this

Resultats de Google Books

Clica una miniatura per anar a Google Books.

Refactoring SQL Applications de Stephane…
S'està carregant…

Refactoring SQL Applications (edició 2008)

de Stephane Faroult, Pascal L'Hermite

MembresRessenyesPopularitatValoració mitjanaConverses
391499,275 (4.5)No n'hi ha cap
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.… (més)
Membre:crono
Títol:Refactoring SQL Applications
Autors:Stephane Faroult
Altres autors:Pascal L'Hermite
Informació:O'Reilly Media, Inc. (2008), Paperback, 296 pages
Col·leccions:La teva biblioteca, Llista de desitjos
Valoració:
Etiquetes:Wanted

Detalls de l'obra

Refactoring SQL Applications de Stephane Faroult

No n'hi ha cap
S'està carregant…

Apunta't a LibraryThing per saber si aquest llibre et pot agradar.

No hi ha cap discussió a Converses sobre aquesta obra.

This book is a sort of "companion" to The Art of SQL (same author).
While I appreciate the style and find it pretty useful, I am a bit disappointed for the choice of title (hence the 4 stars).

"Refactoring" is usually succinctly described as "improving quality without changing the behaviour of a given piece of code" - and in this sense the title is more or less adequate. The problem is that the only concept of "quality" in this case regards query efficiency.

I suppose this is more or less what a DBA or SQL expert really cares about, but if you expected patterns (and anti-patterns), the concept of code smells or - maybe more appropriately - how to incrementally redesign your tables to make them "better"... well, this book is not for you.

In fact you are probably looking for "Agile Database Techniques" or some other title. This one is 99% about query rewriting and maybe 1% of other techniques like change indexes or even restructure tables. But always and only in order to improve throughput.

If this is the type of "quality" you are concerned about, I doubt you can find something better. For a more balanced concept of "Refactoring" you should probably check some other book. ( )
  pamar | Aug 25, 2014 |
Sense ressenyes | afegeix-hi una ressenya

» Afegeix-hi altres autors

Nom de l'autorCàrrecTipus d'autorObra?Estat
Stephane Faroultautor primaritotes les edicionscalculat
L'Hermite, Pascalautor secundaritotes les edicionsconfirmat

Pertany a aquestes sèries

Has d'iniciar sessió per poder modificar les dades del coneixement compartit.
Si et cal més ajuda, mira la pàgina d'ajuda del coneixement compartit.
Títol normalitzat
Títol original
Títols alternatius
Data original de publicació
Gent/Personatges
Llocs importants
Esdeveniments importants
Pel·lícules relacionades
Premis i honors
Epígraf
Dedicatòria
Primeres paraules
Citacions
Darreres paraules
Nota de desambiguació
Editor de l'editorial
Informació del coneixement compartit en anglès. Modifica-la per localitzar-la a la teva llengua.
Creadors de notes promocionals a la coberta
Informació del coneixement compartit en anglès. Modifica-la per localitzar-la a la teva llengua.
Llengua original
CDD/SMD canònics

Referències a aquesta obra en fonts externes.

Wikipedia en anglès

No n'hi ha cap

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.

No s'han trobat descripcions de biblioteca.

Descripció del llibre
Sumari haiku

Dreceres

Cobertes populars

Valoració

Mitjana: (4.5)
0.5
1
1.5
2
2.5
3
3.5
4 1
4.5
5 1

O'Reilly Media

Una edició d'aquest llibre ha estat publicada per O'Reilly Media.

» Pàgina d'informació de l'editor

Ets tu?

Fes-te Autor del LibraryThing.

 

Quant a | Contacte | LibraryThing.com | Privadesa/Condicions | Ajuda/PMF | Blog | Botiga | APIs | TinyCat | Biblioteques llegades | Crítics Matiners | Coneixement comú | 157,339,188 llibres! | Barra superior: Sempre visible