Umfang:
XVIII, 133 S.
,
Ill., graph. Darst.
ISBN:
3540620656
Serie:
Lecture notes in computer science 1182
Inhalt:
Parallel execution offers a method for reducing the response time of queries against large databases. We address the problem of parallel query optimization: Given a declarative SQL query, find a procedural parallel plan that delivers the query result in minimal time
Inhalt:
We develop optimization algorithms using models that incorporate both sources and obstacles to speedup. We address independent, pipelined and partitioned parallelism. We incorporate inherent constraints on available parallelism and the extra cost of parallel execution. Our models are motivated by experiments with NonStop SQL, a commercial parallel DBMS
Inhalt:
We adopt a two-phase approach to parallel query optimization: JOQR (join ordering and query rewrite), followed by parallelization. JOQR minimizes total work. Then, parallelization spreads work among processors to minimize response time
Anmerkung:
Zugl.: Stanford, CA, Univ., Diss.
Sprache:
Deutsch
Fachgebiete:
Informatik
Schlagwort(e):
SQL
;
Response-Zeit
;
Hochschulschrift
;
Hochschulschrift
URL:
http://www.loc.gov/catdir/enhancements/fy0815/96039704-d.html
Bookmarklink