Storage optimization for VARRAY columns

Details Storage optimization for VARRAY columns Storage optimization for VARRAY columns

2008-01-15

2008-01-15

Nguyen, Hiep T. (Department: 2187)

Electrical computers and digital processing systems: memory

Storage accessing and control

Memory configuring

Reexamination Certificate

active

07320061

ABSTRACT:
Methods and apparatus for efficiently storing data in a variable array (VARRAY) of a database system are disclosed. A method for storing data in a VARRAY having an associated large object segment in a system having a memory and a kernel includes determining a size of data to be inserted into the VARRAY. The method also includes determining when the size of the data is less than a threshold value, and storing the data as inline raw data in a column of the VARRAY that is present in the memory when the size of the data is less than the threshold value. When the size of the data is not less than the threshold value, the data is stored in a large object that is associated with the VARRAY. Further, when a VARRAY type is evolved to have a larger maximum size, existing data is not migrated or transformed.

REFERENCES:
patent: 5857203 (1999-01-01), Kauffman et al.
patent: 6061690 (2000-05-01), Nori et al.
patent: 6513043 (2003-01-01), Chan et al.

Affiliated with

Also associated with

Rating

Storage optimization for VARRAY columns does not yet have a rating. At this time, there are no reviews or comments for this patent.

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2769322