Library Automation and Digital Archive
LONTAR
Fakultas Ilmu Komputer
Universitas Indonesia

Pencarian Sederhana

Find Similar Add to Favorite

Call Number SEM - 359
Collection Type Indeks Artikel prosiding/Sem
Title Query optimization for parallel execution (hal 9 -18)
Author Sumit Ganguly, Waqar Hasan, Ravi Krishnamurthy;
Publisher Proceedings of the 1992 acm sigmod international conference on management of data san diego,carlifonia june 2-5,1992
Subject
Location
Lokasi : Perpustakaan Fakultas Ilmu Komputer
Nomor Panggil ID Koleksi Status
SEM - 359 TERSEDIA
Tidak ada review pada koleksi ini: 48050
The decreasing cost of computing makes it economically viable to reduce the response time of decision support queries by using paraller execution to exploit inexpensive resources. this goal poces the following query optimization problem: Minimize response time subject to constraints on throughput, which we motivate as the dual of the traditional DBMS problem. we address this novel problem in the context of select-project-join queries by extending the execution space, cost model and search al gorithm that are widely used in commercial DBMSs. we incorporate the sources and deterrents of parallelism in the traditional execution space. we show that a cost model can predict rospanse time while accounting for the new aspects due to parallelism. we observe that the response time optimization metric violates a fundamental assumption in the dynamic programming algorithm that is the linchpin in the optimizers of most commercial DMBSs. we extend dynamic programing and show how optimization metrics which correctly predict response time may be designed.