Browse Prior Art Database

Computer Output to Laser Disk System Database Segmentation Heuristic

IP.com Disclosure Number: IPCOM000115890D
Original Publication Date: 1995-Jul-01
Included in the Prior Art Database: 2005-Mar-30
Document File: 2 page(s) / 59K

Publishing Venue

IBM

Related People

McMonagle, PS: AUTHOR

Abstract

A massive database application is required to support a Computer Output to Laser Disk (COLD) system. To best support access to all the historical data in the COLD system as well as managing system cost and database manipulation processing requirements, the COLD system database is segmented. This disclosure discusses a heuristic that determines when to segment the COLD system database.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 54% of the total text.

Computer Output to Laser Disk System Database Segmentation Heuristic

      A massive database application is required to support a
Computer Output to Laser Disk (COLD) system.  To best support access
to all the historical data in the COLD system as well as managing
system cost and database manipulation processing requirements, the
COLD system database is segmented.  This disclosure discusses a
heuristic that determines when to segment the COLD system database.

      Before detailing the technique, it may be of some benefit to
discuss why database segmentation is advantageous for the AFP
OnDemand COLD system.  The nature of AFP OnDemand COLD system
requires that print documents be retained in an archive for extended
periods of time.  These print documents (production reports, billing
statements, etc.) are indexed to provide quick access to the archived
documents.  The document index records are stored in a database to
support later access to the archived documents.

      The high volumes of indexed print documents combined with the
extended duration of time the print documents are retained cause data
storage and performance problems.  Database segmentation eliminates
problems in data storage and the performance of loading and accessing
the data.  Data storage problems are eliminated since the database
information is stored in several database tables.  These database
tables can be managed to eliminate potential data storage problems.
The performance prob...