東華大學圖書館 |

Language: English

Help

回圖書館首頁

手機版館藏查詢

Back

Switch To: Labeled | MARC Mode | ISBD

Formal SQL tuning for Oracle databas...

Nossov, Leonid.

Linked to FindBook

Google Book

Amazon

博客來

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

Record Type:	Electronic resources : 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.
Published:	Berlin, Heidelberg :Springer Berlin Heidelberg : : 2016.,
Description:	xvi, 109 p. :ill. (some col.), digital ;24 cm.
[NT 15003449]:	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.
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 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$q(electronic bk.)

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

Oracle (Computer file)
Subjects--Topical Terms:

606987
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:01988nmm a2200337 a 4500 001 2052390
003 DE-He213
005 20160916155440.0
006 m d
007 cr nn 008maaau
008 170421s2016 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 3135656
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 539566
650 0 $a SQL (Computer program language) $3 606987
650 0 $a Relational databases. $3 539565
650 1 4 $a Computer Science. $3 626642
650 2 4 $a Database Management. $3 891010
650 2 4 $a Management of Computing and Information Systems. $3 892490
650 2 4 $a Computer Appl. in Administrative Data Processing. $3 892567
700 1 $a Ernst, Hanno. $3 3135657
700 1 $a Chupis, Victor. $3 3135658
710 2 $a SpringerLink (Online service) $3 836513
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)