Verwandte Artikel zu Refactoring SQL Applications (THEORY IN PRACTICE)
Inhaltsangabe
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.
Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.
Über die Autorin bzw. den Autor
Stephane Faroult first discovered the relational model and the SQL language in 1983, and has been performing database consultancy since then. The founder of RoughSea Ltd, he formerly worked for Oracle.Pascal L'Hermite has been working with relational databases in OLTP, production and development environments on Oracle Databases for the past 12 years and on Microsoft SQL Server for the past 5 years.
„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.
Gebraucht kaufen
Zustand: BefriedigendUsed book that is in clean, average...
Diesen Artikel anzeigen
EUR 7,39
Gratis für den Versand innerhalb von/der USA
Versandziele, Kosten & DauerNeu kaufen
Diesen Artikel anzeigen
EUR 26,80
EUR 3,41 für den Versand innerhalb von/der USA
Versandziele, Kosten & Dauer
Suchergebnisse für Refactoring SQL Applications (THEORY IN PRACTICE)
Beispielbild für diese ISBN
Refactoring SQL Applications
Verlag:
O'Reilly Media, Incorporated, 2008
ISBN 10: 0596514972
ISBN 13: 9780596514976
Gebraucht
Softcover
Anbieter: Better World Books, Mishawaka, IN, USA
Verkäuferbewertung 5 von 5 Sternen
Zustand: Good. Used book that is in clean, average condition without any missing pages. Bestandsnummer des Verkäufers 4923078-75
Anzahl: 1 verfügbar
Beispielbild für diese ISBN
Refactoring SQL Applications
Verlag:
O'Reilly Media (edition 1), 2008
ISBN 10: 0596514972
ISBN 13: 9780596514976
Gebraucht
Paperback
Anbieter: BooksRun, Philadelphia, PA, USA
Verkäuferbewertung 5 von 5 Sternen
Paperback. Zustand: Very Good. 1. It's a well-cared-for item that has seen limited use. The item may show minor signs of wear. All the text is legible, with all pages included. It may have slight markings and/or highlighting. Bestandsnummer des Verkäufers 0596514972-8-1
Anzahl: 1 verfügbar
Beispielbild für diese ISBN
Refactoring SQL Applications
Anbieter: Half Price Books Inc., Dallas, TX, USA
Verkäuferbewertung 5 von 5 Sternen
paperback. Zustand: Very Good. Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority! Bestandsnummer des Verkäufers S_441807586
Anzahl: 1 verfügbar
Beispielbild für diese ISBN
Refactoring SQL Applications
Anbieter: Lakeside Books, Benton Harbor, MI, USA
Verkäuferbewertung 5 von 5 Sternen
Zustand: New. Brand New! Not Overstocks or Low Quality Book Club Editions! Direct From the Publisher! We're not a giant, faceless warehouse organization! We're a small town bookstore that loves books and loves it's customers! Buy from Lakeside Books! Bestandsnummer des Verkäufers OTF-S-9780596514976
Anzahl: Mehr als 20 verfügbar
Foto des Verkäufers
Refactoring SQL Applications
Anbieter: GreatBookPrices, Columbia, MD, USA
Verkäuferbewertung 5 von 5 Sternen
Zustand: New. Bestandsnummer des Verkäufers 5556803-n
Anzahl: 1 verfügbar
Foto des Verkäufers
Refactoring SQL Applications (Paperback or Softback)
Verlag:
O'Reilly Media 8/1/2008, 2008
ISBN 10: 0596514972
ISBN 13: 9780596514976
Neu
Paperback or Softback
Anbieter: BargainBookStores, Grand Rapids, MI, USA
Verkäuferbewertung 5 von 5 Sternen
Paperback or Softback. Zustand: New. Refactoring SQL Applications 1.07. Book. Bestandsnummer des Verkäufers BBS-9780596514976
Anzahl: 5 verfügbar
Beispielbild für diese ISBN
Refactoring SQL Applications
Anbieter: Lucky's Textbooks, Dallas, TX, USA
Verkäuferbewertung 5 von 5 Sternen
Zustand: New. Bestandsnummer des Verkäufers ABLIING23Feb2416190070988
Anzahl: Mehr als 20 verfügbar
Beispielbild für diese ISBN
Refactoring SQL Applications
Anbieter: Best Price, Torrance, CA, USA
Verkäuferbewertung 5 von 5 Sternen
Zustand: New. SUPER FAST SHIPPING. Bestandsnummer des Verkäufers 9780596514976
Anzahl: 2 verfügbar
Foto des Verkäufers
Refactoring SQL Applications
Anbieter: GreatBookPrices, Columbia, MD, USA
Verkäuferbewertung 5 von 5 Sternen
Zustand: As New. Unread book in perfect condition. Bestandsnummer des Verkäufers 5556803
Anzahl: 1 verfügbar
Foto des Verkäufers
Refactoring SQL Applications
Anbieter: Rarewaves USA, OSWEGO, IL, USA
Verkäuferbewertung 5 von 5 Sternen
Paperback. Zustand: New. 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.In this work, 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; and, 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. Bestandsnummer des Verkäufers LU-9780596514976
Anzahl: Mehr als 20 verfügbar