國立虎尾科技大學 |

Formal SQL tuning for Oracle databases = practical efficiency - efficient practice /

紀錄類型:	書目-語言資料,印刷品 : Monograph/item
正題名/作者:	Formal SQL tuning for Oracle databases/ by Leonid Nossov, Hanno Ernst, Victor Chupis.
其他題名:	practical efficiency - efficient practice /
作者:	Nossov, Leonid.
其他作者:	Ernst, Hanno.
出版者:	Berlin, Heidelberg :Springer Berlin Heidelberg : : 2016.,
面頁冊數:	xvi, 109 p. :ill. (some col.), digital ; : 24 cm.;
Contained By:	Springer eBooks
標題:	SQL (Computer program language) -
電子資源:	http://dx.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. - 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

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

Oracle (Computer file)
Subjects--Topical Terms:

561599
SQL (Computer program language)

LC Class. No.: QA76.73.S67

Dewey Class. No.: 005.756

Formal SQL tuning for Oracle databases = practical efficiency - efficient practice /
LDR:01988nam a2200337 a 4500 001 866947
003 DE-He213
005 20160916155440.0
006 m d
007 cr nn 008maaau
008 170720s2016 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 1113485
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 : $c 2016. $b Springer Berlin Heidelberg : $b Imprint: Springer,
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 569317
650 0 $a SQL (Computer program language) $3 561599
650 0 $a Relational databases. $3 555903
650 1 4 $a Computer Science. $3 593922
650 2 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. $3 1113486
700 1 $a Chupis, Victor. $3 1113487
710 2 $a SpringerLink (Online service) $3 593884
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)