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 Algorithms for creating indexes for very large tavles without qulescing updates (hal 361 - 370)
Author C. Mohan, Inderpal Narang;
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: 48124
As relational DBMSs become more and more popular and as organizations grow. the sizes of individual tables are increasing dramatically. unfortunately, current DBMSs do not allow updates to be performed on a table while an index (e.g.,a B+ -tree) is being built for that table,thereby decreasing the systems' availability. this paper describes two algorithms in order to relax this restriction. our emphasis has been to maximize concurrency, minimize overheads and cover all aspects of the problem. builds of both unique and nonunique indexes are handled correctly. we also describe techniques for making the index-building operation restartable, without loss of all work, in case a system failurewere to interrupt the completion of the creation of the index. in this connection, we also present algorithms for making a long a sort operation restartable. these include algorithms for the sort and marge phases of sorting.