Lob locators

Details Lob locators Lob locators

1997-10-31

1999-12-07

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707 10, 707103, G06F 1730

Patent

active

059999438

ABSTRACT:
A method and system for performing operations on large objects (LOBs) in a database system are provided. A server receives from a client a command that identifies a row of a table. The table includes a LOB column that contains LOBs. The server responds to the command by sending the client a first set of data from the row. The first set of data includes a locator for a LOB that belongs in the LOB column of the row. The locator includes a LOB identifier that uniquely identifies the LOB and snapshot information that identifies a particular version of the LOB. The server receives from the client a request to perform an operation on the LOB. The request passes the locator for the LOB to a routine provided by the server. The server performs the operation on the particular version of the LOB that is identified in the snapshot information contained in the locator passed to the server by the client.

REFERENCES:
patent: 5109487 (1992-04-01), Ohgomori et al.
patent: 5566329 (1996-10-01), Gainer et al.
patent: 5678046 (1997-10-01), Cahill et al.
patent: 5732402 (1998-03-01), Lehman
patent: 5742810 (1998-04-01), Ng et al.
patent: 5857203 (1999-01-01), Kauffman et al.
Campbell et al, The Role of Database Systems in the Management of Multimedia Information, Multi media Database Management Systems, 1995. Proceedings., International Workshop, pp. 4-11, Aug. 1995.
Lehman et al., DB2 LOBs: The Teenage Years, IEEE Computer Society Press, pp. 192-199, 1996.
Biliris, An Efficient Database Storage Structure for Large Dynamic Objeccts, Proceedings of the 1992 International Conference on Data Engineering, USA, IEEE Computer Society Press pp. 301-308, Feb. 1994.

Affiliated with

Also associated with

Rating

Lob locators does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Lob locators, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Lob locators will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-836028