國立高雄大學圖資館 |

Language: English

Back

Formal SQL tuning for Oracle databas...

Chupis, Victor.

Formal SQL tuning for Oracle databasespractical efficiency - efficient practice /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Formal SQL tuning for Oracle databasesby Leonid Nossov, Hanno Ernst, Victor Chupis.
Reminder of title:	practical efficiency - efficient practice /
Author:	Nossov, Leonid.
other author:	Ernst, Hanno.
Published:	Berlin, Heidelberg :Springer Berlin Heidelberg :2016.
Description:	xvi, 109 p. :ill. (some col.), digital ;24 cm.
Contained By:	Springer eBooks
Subject:	SQL (Computer program language)
Online resource:	http://dx.doi.org/10.1007/978-3-662-50417-8
ISBN:	9783662504178$q(electronic bk.)

Formal SQL tuning for Oracle databasespractical efficiency - efficient practice /
Nossov, Leonid.

Formal SQL tuning for Oracle databasespractical efficiency - efficient practice /[electronic resource] :by Leonid Nossov, Hanno Ernst, Victor Chupis. - Berlin, Heidelberg :Springer Berlin Heidelberg :2016. - xvi, 109 p. :ill. (some col.), digital ;24 cm.

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$q(electronic bk.)

Standard No.: 10.1007/978-3-662-50417-8doiSubjects--Uniform Titles:

Oracle (Computer file)
Subjects--Topical Terms:

189402
SQL (Computer program language)

LC Class. No.: QA76.73.S67

Dewey Class. No.: 005.756

Formal SQL tuning for Oracle databasespractical efficiency - efficient practice /
LDR:01988nmm a2200337 a 4500 001 497309
003 DE-He213
005 20160916155440.0
006 m d
007 cr nn 008maaau
008 170420s2016 gw s 0 eng d
020 $a 9783662504178$q(electronic bk.)
020 $a 9783662504161$q(paper)
024 7 $a 10.1007/978-3-662-50417-8 $2 doi
035 $a 978-3-662-50417-8
040 $a GP $c GP
041 1 $a eng $h ger
050 4 $a QA76.73.S67
072 7 $a UN $2 bicssc
072 7 $a UMT $2 bicssc
072 7 $a COM021000 $2 bisacsh
082 0 4 $a 005.756 $2 23
090 $a QA76.73.S67 $b N897 2016
100 1 $a Nossov, Leonid. $3 759918
240 1 0 $a Formales SQL-Tuning fur Oracle-Datenbanken. $l English
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.
260 $a Berlin, Heidelberg : $b Springer Berlin Heidelberg : $b Imprint: Springer, $c 2016.
300 $a xvi, 109 p. : $b ill. (some col.), digital ; $c 24 cm.
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.
630 0 0 $a Oracle (Computer file) $3 200209
650 0 $a SQL (Computer program language) $3 189402
650 0 $a Relational databases. $3 214969
650 1 4 $a Computer Science. $3 212513
650 2 4 $a Database Management. $3 273994
650 2 4 $a Management of Computing and Information Systems. $3 274191
650 2 4 $a Computer Appl. in Administrative Data Processing. $3 275283
700 1 $a Ernst, Hanno. $3 759919
700 1 $a Chupis, Victor. $3 759920
710 2 $a SpringerLink (Online service) $3 273601
773 0 $t Springer eBooks
856 4 0 $u http://dx.doi.org/10.1007/978-3-662-50417-8
950 $a Computer Science (Springer-11645)