Method and apparatus for accessing of large object data segments

Details Method and apparatus for accessing of large object data segments Method and apparatus for accessing of large object data segments

1997-09-15

1999-07-06

Amsbury, Wayne

Data processing: database and file management or data structures

Database design

Data structure types

707 2, 707 10, G06F 1730

Patent

active

059208600

ABSTRACT:
A method enables a computer to manipulate data from a table in a remote database in accord with a query from a query requestor, wherein at least some data in the table includes large data objects (LOBs). The method includes the steps of: responding to the query by configuring a database query and determining (i) if a response to the database query requires transfer of LOB data from the table and if yes, and (ii) the LOB data can be transferred in response to the database query without a data manipulation which uses the LOB data or (iii) a data manipulation required in response to the database query which uses the LOB data can be performed at the remote database, then designating the LOB data for "streaming"; dispatching the database query to the remote database and receiving a result set from the table from the remote database in response to the query; and storing the result set and causing any LOB data which has been marked for streaming to be then dispatched to the query requestor without being written to disk.

REFERENCES:
patent: 5517605 (1996-05-01), Wolf
patent: 5566329 (1996-10-01), Gainer et al.
patent: 5600831 (1997-02-01), Levy et al.
patent: 5623652 (1997-04-01), Vora et al.
patent: 5625818 (1997-04-01), Zarmer et al.
patent: 5675721 (1997-10-01), Freedman et al.
patent: 5701451 (1997-12-01), Rogers et al.
patent: 5708825 (1998-01-01), Sotomayor
patent: 5712979 (1998-01-01), Graber et al.
patent: 5748954 (1998-05-01), Mauldin
IBM Technical Disclosure Bulletin, vol. 31, No. 5, Oct. 1988, pp. 301-303, "Interpretive Database Merge Join Operation".

Affiliated with

Also associated with

Rating

Method and apparatus for accessing of large object data segments 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 and apparatus for accessing of large object data segments, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for accessing of large object data segments will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-907579