Organization of Clustered Files for Consecutive Retrieval

J. S. Deogun, V. V. Raghavan, T. K.W. Tsou

Research output: Contribution to journalArticle

6 Citations (Scopus)

Abstract

This paper studies the problem of storing single-level and multilevel clustered files. Necessary and sufficient conditions for a single-level clustered file to have the consecutive retrieval property (CRP) are developed. A linear time algorithm to test the CRP for a given clustered file and to identify the proper arrangement of objects, if CRP exists, is presented. For the single-level clustered files that do not have CRP, it is shown that the problem of identifying a storage organization with minimum redundancy is NP-complete. Consequently, an efficient heuristic algorithm to generate a good storage organization for such files is developed. Furthermore, it is shown that, for certain types of multilevel clustered files, there exists a storage organization such that the objects in each cluster, for all clusters in each level of the clustering, appear in consecutive locations.

Original languageEnglish (US)
Pages (from-to)646-671
Number of pages26
JournalACM Transactions on Database Systems (TODS)
Volume9
Issue number4
DOIs
StatePublished - Dec 5 1984

Fingerprint

Heuristic algorithms
Redundancy

Keywords

  • NP-complete
  • Single-level clustered files
  • consecutive retrieval property
  • heuristic algorithm
  • minimum redundancy organization
  • multilevel clustered files
  • overlapping and nonoverlapping clustering

ASJC Scopus subject areas

  • Information Systems

Cite this

Organization of Clustered Files for Consecutive Retrieval. / Deogun, J. S.; Raghavan, V. V.; Tsou, T. K.W.

In: ACM Transactions on Database Systems (TODS), Vol. 9, No. 4, 05.12.1984, p. 646-671.

Research output: Contribution to journalArticle

Deogun, J. S. ; Raghavan, V. V. ; Tsou, T. K.W. / Organization of Clustered Files for Consecutive Retrieval. In: ACM Transactions on Database Systems (TODS). 1984 ; Vol. 9, No. 4. pp. 646-671.
@article{604467024a224dd9b2053a0592744a10,
title = "Organization of Clustered Files for Consecutive Retrieval",
abstract = "This paper studies the problem of storing single-level and multilevel clustered files. Necessary and sufficient conditions for a single-level clustered file to have the consecutive retrieval property (CRP) are developed. A linear time algorithm to test the CRP for a given clustered file and to identify the proper arrangement of objects, if CRP exists, is presented. For the single-level clustered files that do not have CRP, it is shown that the problem of identifying a storage organization with minimum redundancy is NP-complete. Consequently, an efficient heuristic algorithm to generate a good storage organization for such files is developed. Furthermore, it is shown that, for certain types of multilevel clustered files, there exists a storage organization such that the objects in each cluster, for all clusters in each level of the clustering, appear in consecutive locations.",
keywords = "NP-complete, Single-level clustered files, consecutive retrieval property, heuristic algorithm, minimum redundancy organization, multilevel clustered files, overlapping and nonoverlapping clustering",
author = "Deogun, {J. S.} and Raghavan, {V. V.} and Tsou, {T. K.W.}",
year = "1984",
month = "12",
day = "5",
doi = "10.1145/1994.2208",
language = "English (US)",
volume = "9",
pages = "646--671",
journal = "ACM Transactions on Database Systems",
issn = "0362-5915",
publisher = "Association for Computing Machinery (ACM)",
number = "4",

}

TY - JOUR

T1 - Organization of Clustered Files for Consecutive Retrieval

AU - Deogun, J. S.

AU - Raghavan, V. V.

AU - Tsou, T. K.W.

PY - 1984/12/5

Y1 - 1984/12/5

N2 - This paper studies the problem of storing single-level and multilevel clustered files. Necessary and sufficient conditions for a single-level clustered file to have the consecutive retrieval property (CRP) are developed. A linear time algorithm to test the CRP for a given clustered file and to identify the proper arrangement of objects, if CRP exists, is presented. For the single-level clustered files that do not have CRP, it is shown that the problem of identifying a storage organization with minimum redundancy is NP-complete. Consequently, an efficient heuristic algorithm to generate a good storage organization for such files is developed. Furthermore, it is shown that, for certain types of multilevel clustered files, there exists a storage organization such that the objects in each cluster, for all clusters in each level of the clustering, appear in consecutive locations.

AB - This paper studies the problem of storing single-level and multilevel clustered files. Necessary and sufficient conditions for a single-level clustered file to have the consecutive retrieval property (CRP) are developed. A linear time algorithm to test the CRP for a given clustered file and to identify the proper arrangement of objects, if CRP exists, is presented. For the single-level clustered files that do not have CRP, it is shown that the problem of identifying a storage organization with minimum redundancy is NP-complete. Consequently, an efficient heuristic algorithm to generate a good storage organization for such files is developed. Furthermore, it is shown that, for certain types of multilevel clustered files, there exists a storage organization such that the objects in each cluster, for all clusters in each level of the clustering, appear in consecutive locations.

KW - NP-complete

KW - Single-level clustered files

KW - consecutive retrieval property

KW - heuristic algorithm

KW - minimum redundancy organization

KW - multilevel clustered files

KW - overlapping and nonoverlapping clustering

UR - http://www.scopus.com/inward/record.url?scp=0021609025&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0021609025&partnerID=8YFLogxK

U2 - 10.1145/1994.2208

DO - 10.1145/1994.2208

M3 - Article

AN - SCOPUS:0021609025

VL - 9

SP - 646

EP - 671

JO - ACM Transactions on Database Systems

JF - ACM Transactions on Database Systems

SN - 0362-5915

IS - 4

ER -