Patent
1992-12-11
1996-02-27
Black, Thomas G.
395495, 395650, 395700, G06F 1730
Patent
active
054956013
ABSTRACT:
A method is disclosed for a database system for [off-loading] off-loading, to disk [controller] controller, the extraction of committed [data involving the] data. The system first [picking] picks a Commit.sub.-- LSN value and [insuring] 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] 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. [After which] 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] list, and [determining] determining, for each [page] page, if the page's Page.sub.-- LSN value is less than the Commit.sub.-- LSN. If it [is] 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: 4967341 (1990-10-01), Yamamoto et al.
patent: 5043871 (1991-08-01), Nishigaki et al.
patent: 5249262 (1993-09-01), Baule
patent: 5287496 (1994-02-01), Chen et al.
patent: 5317731 (1994-05-01), Dias et al.
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 Copmuting, 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.
C. Mohan, Transaction Processing System and Method with Reduced Locking. Ser. #07/480,700 filed Feb. 15, 1990 Now US Patent #5,247,672.
Iyer Balakrishna R.
Mohan Chandrasekaran
Narang Inderpal S.
Black Thomas G.
Blair Philip
International Business Machines - Corporation
Lintz Paul R.
Pintner James C.
LandOfFree
Method to off-load host-based DBMS predicate evaluation to a dis does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method to off-load host-based DBMS predicate evaluation to a dis, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method to off-load host-based DBMS predicate evaluation to a dis will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1686017