Patent
1995-08-11
1996-12-17
Amsbury, Wayne
G06F 1730
Patent
active
055863159
ABSTRACT:
A computer program product, such as a pre-recorded software program on a floppy disk, is disclosed, for use with a processing and database system for off-loading, to disk controller, the extraction of committed data. Responsive to the pre-recorded program instructions, the system first picks a Commit.sub.-- LSN value and insures all the data modified prior to the Commit.sub.-- LSN value is processed following the DBMS policy of reducing some disk I/Os or not for the modified pages cached in the system. If the policy is not to do disk I/Os for such pages, then the system places the identifiers of those pages in an ignore list. Otherwise, the system writes those pages to disk and empties the ignore list. Afterwards, the system forwards the ignore list and the Commit.sub.-- LSN along with information regarding the data to be processed to the controller. The controller performs the off-load function by reading from disk every page identified by the system except those in the ignore list, and determining, for each page, if the page's Page.sub.-- LSN value is less than the Commit.sub.-- LSN. If it is, then the controller processes the page and adds any qualifying data from that page to a defined answer set. Otherwise, the controller adds the Page.sub.-- ID for that page to a defined exception list. The controller than passes the answer set and the exception list to the system. The system processes the pages identified in the exception list and those in the ignore list. The system consolidates these answers with the answer set returned by the controller for presentation to the user.
REFERENCES:
patent: 5043871 (1991-08-01), Nishigaki et al.
patent: 5247672 (1993-09-01), Mohan
T. Kitamura et al., A Relational Database Machine Architecture Based on an Attached Processor Approach, NTT Communications & Info. Processing Lab., pp. 663-671, 1987.
C. Mohan, Commit-LSN: A Novel and Simple Method for Reducing Locking and Latching in Transaction Processing Systems, Proceedings of the 16th VLDB Conf., Brisbane, Australia, pp. 1-14, Aug. 1990.
J. Kreybig et al., An Intelligent Disk Controller--A Processor System for File Management and Query Functions, No.-Holland, Microprocessing & Microprogramming 25 pp. 55-60, 1989.
E. A. Ozkarahan et al., On-The-Fly and Background Data Filtering System for Database Architectures, New Generation Computing, vol. 5, pp. 281-314, 1987.
K. I. Yu et al., The Fast Data Finder--An Architecture for Very High Speed Data Search and Dissemination, IEEE CH2031, pp. 167-174, 1984.
Iyer Balakrishna R.
Mohan Chandrasekaran
Narang Inderpal S.
Amsbury Wayne
International Business Machines - Corporation
Lintz Paul R.
Pintner James C.
LandOfFree
Computer program product for off-loading host-based DBMS predica does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Computer program product for off-loading host-based DBMS predica, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Computer program product for off-loading host-based DBMS predica will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2000377