Approach for managing access to large objects in database system

Details Approach for managing access to large objects in database system Approach for managing access to large objects in database system

1997-10-31

2000-05-09

Alam, Hosain T.

Data processing: database and file management or data structures

Database design

Data structure types

707 2, 707100, 707203, G06F 1730

Patent

active

060616784

ABSTRACT:
A method and system for accessing a large object (LOB) that belongs to a cell in a table are provided. An index is built on a column in which the cell resides. The index has a key that includes a LOB identifier. A database server receives from a client a request to access the LOB. The server uses a LOB identifier value for the LOB to traverse the index to locate an index entry for the LOB. The server then follows address information contained in the index entry to a storage containing at least a portion of the LOB and accesses the portion of the LOB as specified in the request. A method and system for tracking storage for data items are also disclosed. Within an index that is built to access the data items are stored both index entries for locating blocks that store current versions of the data items, and index entries for locating blocks that store non-current versions of the data items.

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.
Lehman, et al., DBS LOBs: The Teenage Years, IEEE Computer Society Press, pp. 192-199, 1996.
Campbell, et al., "The Role of Database Systems in the Management of Multimedia Information", Multi media Database Management Systems, 1995. Preceedings., International Workshop, pp. 4-11.
"An Efficient Database Storage Structure for Large Dynamic Objects," Alexandros Biliris, 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

Approach for managing access to large objects in database system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Approach for managing access to large objects in database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Approach for managing access to large objects in database system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1074658