发明授权
- 专利标题: Maintaining referential integrity while masking
- 专利标题(中): 在屏蔽时保持参照完整性
-
申请号: US12221157申请日: 2008-07-30
-
公开(公告)号: US07979410B2公开(公告)日: 2011-07-12
- 发明人: Ravi Pattabhi , Harish Akali , Luming Han , Xiaolan Shen , Andrew Bodge
- 申请人: Ravi Pattabhi , Harish Akali , Luming Han , Xiaolan Shen , Andrew Bodge
- 申请人地址: US CA Redwood Shores
- 专利权人: Oracle International Corp.
- 当前专利权人: Oracle International Corp.
- 当前专利权人地址: US CA Redwood Shores
- 代理机构: Kraguljac & Kalnay, LLC
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
Systems, methods, and other embodiments associated with maintaining referential integrity while masking database columns are described. One example method includes determining a transitive closure for dependency relationships involving a column to be masked and other columns related to the column to be masked through a dependency relationship. The example method may also include identifying a root column for a column in the transitive closure and creating a mapping table that stores original values and masking values for the root column. The method includes masking the root column and related child columns based on the mapping table in a manner that maintains referential integrity between the root column and the child column. Integrity may be maintained by masking corresponding values in the root column and a child column(s) with identical mask values from the mapping table.
公开/授权文献
- US20100030795A1 Maintaining referential integrity while masking 公开/授权日:2010-02-04
信息查询