Cargando…
Refactoring SQL applications /
What can you do when database performance doesn't meet expectations? This book offers methods for refactoring (or changing) SQL code to improve performance without altering a database application's purpose -- and helps you do it on a shoestring budget. This isn't a rehash of theory, b...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, Calif. :
O'Reilly Media,
2008.
|
| Edición: | 1st ed. |
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | OR_ocn297556520 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 090109s2008 caua o 001 0 eng d | ||
| 040 | |a UMI |b eng |e pn |c UMI |d WPG |d OCLCQ |d CEF |d OCLCQ |d NHM |d DEBSZ |d OCLCQ |d C6I |d OCLCF |d OCLCQ |d EBLCP |d N$T |d NLE |d YDXCP |d OCLCQ |d FEM |d OCLCQ |d WYU |d MERER |d OCLCQ |d UAB |d VT2 |d ERF |d UKAHL |d OCLCQ |d UKBTH |d UHL |d OCLCQ |d TOH |d TAC |d OCLCO |d OCLCQ |d OCLCO | ||
| 015 | |a GBA859174 |2 bnb | ||
| 016 | 7 | |a 014595917 |2 Uk | |
| 019 | |a 261225853 |a 609840914 |a 775300463 |a 859878817 |a 968036935 |a 969060828 |a 1044258987 |a 1056383002 |a 1075253614 |a 1103262447 |a 1112590524 |a 1113011347 |a 1113255569 |a 1129338798 |a 1224589234 |a 1302703306 |a 1355686708 | ||
| 020 | |a 9780596514976 | ||
| 020 | |a 0596514972 | ||
| 020 | |a 9780596551773 |q (electronic bk.) | ||
| 020 | |a 0596551770 |q (electronic bk.) | ||
| 020 | |a 9780596154950 |q (electronic bk.) | ||
| 020 | |a 059615495X |q (electronic bk.) | ||
| 024 | 8 | |a 9780596514976 | |
| 029 | 1 | |a AU@ |b 000062564196 | |
| 029 | 1 | |a AU@ |b 000070668319 | |
| 029 | 1 | |a CHBIS |b 006150056 | |
| 029 | 1 | |a CHVBK |b 171445058 | |
| 029 | 1 | |a DEBSZ |b 355421275 | |
| 029 | 1 | |a DEBSZ |b 396273394 | |
| 029 | 1 | |a DEBSZ |b 396385591 | |
| 029 | 1 | |a HEBIS |b 291493017 | |
| 035 | |a (OCoLC)297556520 |z (OCoLC)261225853 |z (OCoLC)609840914 |z (OCoLC)775300463 |z (OCoLC)859878817 |z (OCoLC)968036935 |z (OCoLC)969060828 |z (OCoLC)1044258987 |z (OCoLC)1056383002 |z (OCoLC)1075253614 |z (OCoLC)1103262447 |z (OCoLC)1112590524 |z (OCoLC)1113011347 |z (OCoLC)1113255569 |z (OCoLC)1129338798 |z (OCoLC)1224589234 |z (OCoLC)1302703306 |z (OCoLC)1355686708 | ||
| 037 | |a CL0500000030 |b Safari Books Online | ||
| 050 | 4 | |a QA76.73.S67 |b F37 2008 | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.756 |2 22 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Faroult, Stéphane. | |
| 245 | 1 | 0 | |a Refactoring SQL applications / |c Stephane Faroult with Pascal L'Hermite. |
| 250 | |a 1st ed. | ||
| 260 | |a Sebastopol, Calif. : |b O'Reilly Media, |c 2008. | ||
| 300 | |a 1 online resource (xv, 277 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a 1. Assessment -- A Simple Example -- Assessing Possible Gains -- 2. Sanity Checks -- Statistics and Data Skewness -- Indexing Review -- Parsing and Bind Variables -- Bulk Operations -- Transaction Management -- 3. User Functions and Views -- User-Defined Functions -- Views -- 4. Testing Framework -- Generating Test Data -- Comparing Alternative Versions -- 5. Statement Refactoring -- Execution Plans and Optimizer Directives -- Analyzing a Slow Query -- Refactoring the Query Core -- Rebuilding the Initial Query -- 6. Task Refactoring -- The SQL Mindset -- Restructuring the Code -- 7. Refactoring Flows and Databases -- Reorganizing Processing -- Shaking Foundations -- 8. How It Works: Refactoring in Practice -- Can you Look at the Database? -- Queries of Death -- All These Fast Queries -- No Obvious Very Wrong Query -- Time to Conclude -- A. Scripts and Sample Programs -- B. Tools. | |
| 520 | |a What can you do when database performance doesn't meet expectations? This book offers methods for refactoring (or changing) SQL code to improve performance without altering a database application's purpose -- and helps you do it on a shoestring budget. This isn't a rehash of theory, but a tested set of options for making code modifications to dramatically improve the way your applications function. | ||
| 542 | |f Copyright © O'Reilly Media, Inc. |g 2008 | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Database management. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a SQL (Computer program language) |2 blmlsh | |
| 650 | 7 | |a Database management. |2 blmlsh | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 653 | |a Databases | ||
| 700 | 1 | |a L'Hermite, Pascal. | |
| 776 | 1 | |z 9780596514976 | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9780596514976/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26837898 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL443171 | ||
| 938 | |a EBSCOhost |b EBSC |n 415314 | ||
| 938 | |a YBP Library Services |b YANK |n 7462377 | ||
| 938 | |a YBP Library Services |b YANK |n 3179779 | ||
| 994 | |a 92 |b IZTAP | ||