大葉大學圖書館 |

Formal SQL tuning for Oracle databases[electronic resource] :practical efficiency - efficient practice /

紀錄類型:	書目-電子資源 : Monograph/item
杜威分類號:	005.756
書名/作者:	Formal SQL tuning for Oracle databases : practical efficiency - efficient practice // by Leonid Nossov, Hanno Ernst, Victor Chupis.
作者:	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)
標題:	Relational databases.
標題:	Computer Science.
標題:	Database Management.
標題:	Management of Computing and Information Systems.
標題:	Computer Appl. in Administrative Data Processing.
ISBN:	9783662504178
ISBN:	9783662504161
內容註:	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.
電子資源:	http://dx.doi.org/10.1007/978-3-662-50417-8

Formal SQL tuning for Oracle databases[electronic resource] :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:

351101
SQL (Computer program language)

LC Class. No.: QA76.73.S67

Dewey Class. No.: 005.756

Formal SQL tuning for Oracle databases[electronic resource] :practical efficiency - efficient practice /
LDR:01988nmm a2200337 a 4500 001 466214
003 DE-He213
005 20160916155440.0
006 m d
007 cr nn 008maaau
008 170415s2016 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 670872
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 344128
650 0 $a SQL (Computer program language) $3 351101
650 0 $a Relational databases. $3 344126
650 1 4 $a Computer Science. $3 423143
650 2 4 $a Database Management. $3 463966
650 2 4 $a Management of Computing and Information Systems. $3 466225
650 2 4 $a Computer Appl. in Administrative Data Processing. $3 466759
700 1 $a Ernst, Hanno. $3 670873
700 1 $a Chupis, Victor. $3 670874
710 2 $a SpringerLink (Online service) $3 463450
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)