國立虎尾科技大學 |

Formal SQL Tuning for Oracle Databases = Practical Efficiency - Efficient Practice /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	Formal SQL Tuning for Oracle Databases/ by Leonid Nossov, Hanno Ernst, Victor Chupis.
Reminder of title:	Practical Efficiency - Efficient Practice /
Author:	Nossov, Leonid.
other author:	Ernst, Hanno.
Description:	XVI, 109 p. 68 illus., 13 illus. in color.online resource. :
Contained By:	Springer Nature eBook
Subject:	Database management. -
Online resource:	https://doi.org/10.1007/978-3-662-50417-8
ISBN:	9783662504178

Formal SQL Tuning for Oracle Databases = Practical Efficiency - Efficient Practice /
Nossov, Leonid.

Formal SQL Tuning for Oracle DatabasesPractical Efficiency - Efficient Practice /[electronic resource] :by Leonid Nossov, Hanno Ernst, Victor Chupis. - 1st ed. 2016. - XVI, 109 p. 68 illus., 13 illus. in color.online resource.

Prefaces -- Introduction -- Some thoughts concerning the term "SQL Tuning" -- Minimum minimorum to the subject "Execution Plan" -- Approaches to formal SQL Tuning -- Bottlenecks in Execution Plans -- Procedure for formal SQL Tuning -- Practical experiences with formal SQL Tuning -- Appendix -- Application of the formal method for analysis of performance issues following Oracle migration.

The target of SQL tuning is the improvement of the existing execution plan. The authors discuss the removal of brakes in the execution plan. Such "brakes" or bottlenecks can be recognized by a formal analysis of the execution plan. For this purpose no data model knowledge is needed. This is especially beneficial for database administrators because they are usually not or insufficiently familiar with the data model. The book presents numerous practical examples with this method.

ISBN: 9783662504178

Standard No.: 10.1007/978-3-662-50417-8doiSubjects--Topical Terms:

557799
Database management.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.74

Formal SQL Tuning for Oracle Databases = Practical Efficiency - Efficient Practice /
LDR:02303nam a22004095i 4500 001 976514
003 DE-He213
005 20200630222426.0
007 cr nn 008mamaa
008 201211s2016 gw | s |||| 0|eng d
020 $a 9783662504178 $9 978-3-662-50417-8
024 7 $a 10.1007/978-3-662-50417-8 $2 doi
035 $a 978-3-662-50417-8
050 4 $a QA76.9.D3
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
072 7 $a UMT $2 thema
082 0 4 $a 005.74 $2 23
100 1 $a Nossov, Leonid. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1113485
245 1 0 $a Formal SQL Tuning for Oracle Databases $h [electronic resource] : $b Practical Efficiency - Efficient Practice / $c by Leonid Nossov, Hanno Ernst, Victor Chupis.
250 $a 1st ed. 2016.
264 1 $a Berlin, Heidelberg : $b Springer Berlin Heidelberg : $b Imprint: Springer, $c 2016.
300 $a XVI, 109 p. 68 illus., 13 illus. in color. $b online resource.
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 $b PDF $2 rda
505 0 $a Prefaces -- Introduction -- Some thoughts concerning the term "SQL Tuning" -- Minimum minimorum to the subject "Execution Plan" -- Approaches to formal SQL Tuning -- Bottlenecks in Execution Plans -- Procedure for formal SQL Tuning -- Practical experiences with formal SQL Tuning -- Appendix -- Application of the formal method for analysis of performance issues following Oracle migration.
520 $a The target of SQL tuning is the improvement of the existing execution plan. The authors discuss the removal of brakes in the execution plan. Such "brakes" or bottlenecks can be recognized by a formal analysis of the execution plan. For this purpose no data model knowledge is needed. This is especially beneficial for database administrators because they are usually not or insufficiently familiar with the data model. The book presents numerous practical examples with this method.
650 0 $a Database management. $3 557799
650 0 $a Management information systems. $3 561123
650 0 $a Computer science. $3 573171
650 0 $a Application software. $3 528147
650 1 4 $a Database Management. $3 669820
650 2 4 $a Management of Computing and Information Systems. $3 593928
650 2 4 $a Computer Appl. in Administrative Data Processing. $3 669633
700 1 $a Ernst, Hanno. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1113486
700 1 $a Chupis, Victor. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1113487
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9783662504161
776 0 8 $i Printed edition: $z 9783662504185
776 0 8 $i Printed edition: $z 9783662570562
856 4 0 $u https://doi.org/10.1007/978-3-662-50417-8
912 $a ZDB-2-SCS
912 $a ZDB-2-SXCS
950 $a Computer Science (SpringerNature-11645)
950 $a Computer Science (R0) (SpringerNature-43710)