发明授权
- 专利标题: Reference partitioned tables
- 专利标题(中): 引用分区表
-
申请号: US11974084申请日: 2007-10-11
-
公开(公告)号: US07870174B2公开(公告)日: 2011-01-11
- 发明人: George Eadon , Eugene Inseok Chong , Shrikanth Shankar , Ananth Raghavan , Jagannathan Srinivasan , Souripriya Das
- 申请人: George Eadon , Eugene Inseok Chong , Shrikanth Shankar , Ananth Raghavan , Jagannathan Srinivasan , Souripriya Das
- 申请人地址: US CA Redwood Shores
- 专利权人: Oracle International Corporation
- 当前专利权人: Oracle International Corporation
- 当前专利权人地址: US CA Redwood Shores
- 代理机构: Kraguljac + Kalnay, LLC
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
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.
公开/授权文献
- US20090100089A1 Reference partitioned tables 公开/授权日:2009-04-16
信息查询