Patent ID: 7761411
Filing Date: 2010-07-20
Classification: G06F

Abstract:
1. A computer-readable storage medium comprising instructions for a computer to perform operations in a structured query language (SQL) compliant database management system (DBMS) that allows storage of large objects (LOBs) of unknown structure, the instructions comprising: instructions to receive an SQL statement that includes a first command to update inside a block in a large object (LOB) in the DBMS, a portion that is smaller than the block; instructions to execute the first command by modifying data of the portion without movement of data in a remainder of the block unrelated to the portion; instructions to modify metadata that maps a first offset identifying the portion in the block to a second offset at which data of the portion is located within the block; and instructions responsive to a second command, to use the metadata obtained by said modifying to translate a third offset in the second command, use the result of translation to read data from the LOB and output the read data from the computer.