Browse Prior Art Database

Record Recycling in a Volume Load Responsive to a Data Base Query

IP.com Disclosure Number: IPCOM000059692D
Original Publication Date: 1986-Jan-01
Included in the Prior Art Database: 2005-Mar-08
Document File: 1 page(s) / 11K

Publishing Venue

IBM

Related People

Harper, LN: AUTHOR [+2]

Abstract

This invention relates to the recycling of records in a volume load responsive to a data base query. The method steps include (a) accessing records and ascertaining whether said accessed records satisfy the query terms, (b) independently buffering those records failing to satisfy the query terms, and (c) editing preselected ones of said buffered records and resubmitting them for processing as in step (a). Such a method takes advantage of a data structure denominatable as a load discard file. The load discard file implements the method for handling records rejected during the bulk loading of a relational data base table space. The aforementioned method identifies and collects rejected input records, permits modification of these records, and supports subsequent bulk loading.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 100% of the total text.

Page 1 of 1

Record Recycling in a Volume Load Responsive to a Data Base Query

This invention relates to the recycling of records in a volume load responsive to a data base query. The method steps include (a) accessing records and ascertaining whether said accessed records satisfy the query terms, (b) independently buffering those records failing to satisfy the query terms, and (c) editing preselected ones of said buffered records and resubmitting them for processing as in step (a). Such a method takes advantage of a data structure denominatable as a load discard file. The load discard file implements the method for handling records rejected during the bulk loading of a relational data base table space. The aforementioned method identifies and collects rejected input records, permits modification of these records, and supports subsequent bulk loading. Since the quantity of input records can be very large, such a method facilitates relational data base use. Advantageously, the method or load process permits users to specify the loading of a particular subset of records contained within an input data set. Such a method or process rejects a record when the record fails to satisfy user-defined filtering criteria or a system integrity constraint. If rejection is due only to user-defined filtering criteria, typically no modification of the rejected record is necessary. The user merely specifies a different filtering criterion for subsequent bulk loading.

1