Incremental File Reorganization Schemes.
Edward Omiecinski:
Incremental File Reorganization Schemes.
VLDB 1985: 346-357@inproceedings{DBLP:conf/vldb/Omiecinski85,
author = {Edward Omiecinski},
editor = {Alain Pirotte and
Yannis Vassiliou},
title = {Incremental File Reorganization Schemes},
booktitle = {VLDB'85, Proceedings of 11th International Conference on Very
Large Data Bases, August 21-23, 1985, Stockholm, Sweden},
publisher = {Morgan Kaufmann},
year = {1985},
pages = {346-357},
ee = {db/conf/vldb/Omiecinski85.html},
crossref = {DBLP:conf/vldb/85},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
For many files, reorganization is
essential during their lifetime in order to
maintain an adequate performance level for
users. File reorganization can be defined as
the process of changing the physical structure
of the file. In this paper we are mainly
concerned with changes in the placement of
records of a file on pages in secondary
storage. We model the problem of file
reorganization in terms of a hypergraph and
show that this problem is NP-hard. We present
two heuristics which can be classified as
incremental reorganization schemes. Both
algorithms incorporate a heuristic for the
traveling salesman problem. The objective of
our approach is the minimization of the number
of pages swapped in and out of the main memory
buffer area during the reorganization process.
Synthetic experiments have been performed to
compare our heuristics with alternative
strategies.
Copyright © 1985 by the VLDB Endowment.
Permission to copy without fee all or part of this material is granted provided that the copies are not made or
distributed for direct commercial advantage, the VLDB
copyright notice and the title of the publication and
its date appear, and notice is given that copying
is by the permission of the Very Large Data Base
Endowment. To copy otherwise, or to republish, requires
a fee and/or special permission from the Endowment.
Online Paper
CDROM Version: Load the CDROM "Volume 1 Issue 4, VLDB '75-'88" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
BibTeX
Printed Edition
Alain Pirotte, Yannis Vassiliou (Eds.):
VLDB'85, Proceedings of 11th International Conference on Very Large Data Bases, August 21-23, 1985, Stockholm, Sweden.
Morgan Kaufmann 1985
Contents BibTeX
References
- [1]
- Don S. Batory:
Optimal File Designs and Reorganization Points.
ACM Trans. Database Syst. 7(1): 60-81(1982) BibTeX
- [2]
- ...
- [3]
- Richard S. Brice, Stephen W. Sherman:
An Extension of the Performance of a Database Manager in a Virtual Memory System Using Partially Locked Virtual Buffers.
ACM Trans. Database Syst. 2(2): 196-207(1977) BibTeX
- [4]
- M. R. Garey, David S. Johnson:
Computers and Intractability: A Guide to the Theory of NP-Completeness.
W. H. Freeman 1979, ISBN 0-7167-1044-7
BibTeX
- [5]
- ...
- [6]
- Daniel J. Rosenkrantz, Richard Edwin Stearns, Philip M. Lewis II:
An Analysis of Several Heuristics for the Traveling Salesman Problem.
SIAM J. Comput. 6(3): 563-581(1977) BibTeX
- [7]
- Peter Scheuermann, Aris M. Ouksel:
Multidimensional B-trees for associative searching in database systems.
Inf. Syst. 7(2): 123-137(1982) BibTeX
- [8]
- ...
- [9]
- Gary H. Sockut, Robert P. Goldberg:
Database Reorganization - Principles and Practice.
ACM Comput. Surv. 11(4): 371-395(1979) BibTeX
- [10]
- Lars Söderlund:
Concurrent Data Base Reorganization - Assessment of a Powerful Technique through Modeling.
VLDB 1981: 499-509 BibTeX
- [11]
- Michael Stonebraker:
Operating System Support for Database Management.
Commun. ACM 24(7): 412-418(1981) BibTeX
- [12]
- ...
- [13]
- ...
- [14]
- S. Bing Yao, K. Sundar Das, Toby J. Teorey:
A Dynamic Database Reorganization Algorithm.
ACM Trans. Database Syst. 1(2): 159-174(1976) BibTeX
- [15]
- Clement T. Yu, Cheing-Mei Suen, K. Lam, M. K. Siu:
Adaptive Record Clustering.
ACM Trans. Database Syst. 10(2): 180-204(1985) BibTeX
Referenced by
- Chye-Lin Chee, Hongjun Lu, Hong Tang, C. V. Ramamoorthy:
Adaptive Prefetching and Storage Reorganization In A Log-Structured Storage System.
IEEE Trans. Knowl. Data Eng. 10(5): 824-838(1998)
- Edward Omiecinski:
Concurrent File Reorganization: Clustering, Conversion and Maintenance.
IEEE Data Eng. Bull. 19(2): 25-32(1996)
- Kiran J. Achyutuni, Edward Omiecinski, Shamkant B. Navathe:
Two Techniques for On-Line Index Modification in Shared Nothing Parallel Databases.
SIGMOD Conference 1996: 125-136
- Edward Omiecinski, Liehuey Lee, Peter Scheuermann:
Performance Analysis of a Concurrent File Reorganization Algorithm for Record Clustering.
IEEE Trans. Knowl. Data Eng. 6(2): 248-257(1994)
- William J. McIver Jr., Roger King:
Self-Adaptive, On-Line Reclustering of Complex Object Data.
SIGMOD Conference 1994: 407-418
- Goetz Graefe:
Query Evaluation Techniques for Large Databases.
ACM Comput. Surv. 25(2): 73-170(1993)
- Jia-bing R. Cheng, Ali R. Hurson:
Effective Clustering of Complex Objects in Object-Oriented Databases.
SIGMOD Conference 1991: 22-31
- Edward Omiecinski, Peter Scheuermann:
A Parallel Algorithm for Record Clustering.
ACM Trans. Database Syst. 15(4): 599-624(1990)
- Edward Omiecinski:
Concurrent Storage Structure Conversion: from B+ Tree to Linear Hash File.
ICDE 1988: 589-596
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:45:26 2009