Invention Grant
- Patent Title: Partitioning of nested tables
- Patent Title (中): 嵌套表的分区
-
Application No.: US11707735Application Date: 2007-02-16
-
Publication No.: US07756889B2Publication Date: 2010-07-13
- Inventor: Qin Yu , Geeta Arora , Sriram Krishnamurthy , Adiel Yoaz
- Applicant: Qin Yu , Geeta Arora , Sriram Krishnamurthy , Adiel Yoaz
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Truong & Becker LLP
- Agent Daniel D. Ledesma
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
Techniques for partitioning nested tables are provided. A parent table includes a column for collection items. A nested table is created for storing items that belong to the collection items. The nested table is partitioned to create a plurality of nested table partitions. Each nested table partition is a distinct, separately stored structure within a database. How the nested table is partitioned may, or may not, be based on how the parent table is partitioned. For example, a nested table may be partitioned based on the same criteria in which the parent table is partitioned. As another example, a nested table may be partitioned, whereas the parent table is not partitioned.
Public/Granted literature
- US20080201296A1 Partitioning of nested tables Public/Granted day:2008-08-21
Information query