发明申请
- 专利标题: Reference partitioned tables
- 专利标题(中): 引用分区表
-
申请号: US11974084申请日: 2007-10-11
-
公开(公告)号: US20090100089A1公开(公告)日: 2009-04-16
- 发明人: George Eadon , Eugene Inseok Chong , Shrikanth Shankar , Ananth Raghavan , Jagannathan Srinivasan , Souriprlya Das
- 申请人: George Eadon , Eugene Inseok Chong , Shrikanth Shankar , Ananth Raghavan , Jagannathan Srinivasan , Souriprlya Das
- 申请人地址: US CA REDWOOD SHORES
- 专利权人: ORACLE INTERNATIONAL CORPORATION
- 当前专利权人: ORACLE INTERNATIONAL CORPORATION
- 当前专利权人地址: US CA REDWOOD SHORES
- 主分类号: G06F7/00
- IPC分类号: G06F7/00
摘要:
Systems, methodologies, media, and other embodiments associated with supporting reference partitioned tables in a relational database are described. One example method includes identifying a partitioning strategy (e.g., range, list, hash) associated with a parent table that is related to a child table by a referential constraint. The example method may also include creating the child table to be a reference-partitioned table partitioned according to the partitioning strategy associated with the parent table. The example method may also include creating the child table to be equi-partitioned with respect to the parent table. The child table is not to replicate a partition key of the parent table but rather is to inherit a partitioning key associated with the parent table through a foreign key relationship.
公开/授权文献
- US07870174B2 Reference partitioned tables 公开/授权日:2011-01-11
信息查询