发明申请
- 专利标题: Storage optimization for VARRAY columns
- 专利标题(中): VARRAY列的存储优化
-
申请号: US10912426申请日: 2004-08-05
-
公开(公告)号: US20060047670A1公开(公告)日: 2006-03-02
- 发明人: Qin Yu , Subramanian Muralidhar
- 申请人: Qin Yu , Subramanian Muralidhar
- 申请人地址: US CA Redwood Shores
- 专利权人: ORACLE INTERNATIONAL CORPORATION
- 当前专利权人: ORACLE INTERNATIONAL CORPORATION
- 当前专利权人地址: US CA Redwood Shores
- 主分类号: G06F7/00
- IPC分类号: G06F7/00
摘要:
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.
公开/授权文献
- US07320061B2 Storage optimization for VARRAY columns 公开/授权日:2008-01-15