PHYSICAL RECORD CLUSTERING IN DATABASES

PHYSICAL RECORD CLUSTERING IN DATABASES The NPcomplete problem of optimally placing tuples on a hierarchy of secondary storage devices is considered using a heuristic approach. From load specification details captured at database design time, those tuples associated with queries which merit tailored, setinconcrete, physical access paths are placed using a twolevel graph partitioning algorithm. Experiments are reported with the pages and cylinders as the two hierarchical levels of storage for a centralised database, but the technique is applicable to an nIevel storage hierarchyas up to the different sites level for distributed databases. The results show up to 39 improvement over singlelevel partitioning algorithms for the database considered. http://www.deepdyve.com/assets/images/DeepDyve-Logo-lg.png Kybernetes Emerald Publishing

PHYSICAL RECORD CLUSTERING IN DATABASES

Kybernetes, Volume 13 (1): 7 – Jan 1, 1984

Loading next page...
 
/lp/emerald-publishing/physical-record-clustering-in-databases-ZDseBUxg31
Publisher
Emerald Publishing
Copyright
Copyright © Emerald Group Publishing Limited
ISSN
0368-492X
DOI
10.1108/eb005671
Publisher site
See Article on Publisher Site

Abstract

The NPcomplete problem of optimally placing tuples on a hierarchy of secondary storage devices is considered using a heuristic approach. From load specification details captured at database design time, those tuples associated with queries which merit tailored, setinconcrete, physical access paths are placed using a twolevel graph partitioning algorithm. Experiments are reported with the pages and cylinders as the two hierarchical levels of storage for a centralised database, but the technique is applicable to an nIevel storage hierarchyas up to the different sites level for distributed databases. The results show up to 39 improvement over singlelevel partitioning algorithms for the database considered.

Journal

KybernetesEmerald Publishing

Published: Jan 1, 1984

There are no references for this article.

You’re reading a free preview. Subscribe to read the entire article.


DeepDyve is your
personal research library

It’s your single place to instantly
discover and read the research
that matters to you.

Enjoy affordable access to
over 18 million articles from more than
15,000 peer-reviewed journals.

All for just $49/month

Explore the DeepDyve Library

Search

Query the DeepDyve database, plus search all of PubMed and Google Scholar seamlessly

Organize

Save any article or search result from DeepDyve, PubMed, and Google Scholar... all in one place.

Access

Get unlimited, online access to over 18 million full-text articles from more than 15,000 scientific journals.

Your journals are on DeepDyve

Read from thousands of the leading scholarly journals from SpringerNature, Elsevier, Wiley-Blackwell, Oxford University Press and more.

All the latest content is available, no embargo periods.

See the journals in your area

DeepDyve

Freelancer

DeepDyve

Pro

Price

FREE

$49/month
$360/year

Save searches from
Google Scholar,
PubMed

Create folders to
organize your research

Export folders, citations

Read DeepDyve articles

Abstract access only

Unlimited access to over
18 million full-text articles

Print

20 pages / month

PDF Discount

20% off