发明授权
US07882134B2 Non-repeating random values in user specified formats and character sets
有权
用户指定格式和字符集中的非重复随机值
- 专利标题: Non-repeating random values in user specified formats and character sets
- 专利标题(中): 用户指定格式和字符集中的非重复随机值
-
申请号: US12150392申请日: 2008-04-28
-
公开(公告)号: US07882134B2公开(公告)日: 2011-02-01
- 发明人: 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 Corporation
- 当前专利权人: Oracle International Corporation
- 当前专利权人地址: US CA Redwood Shores
- 代理机构: Kraguljac & Kalnay, LLC
- 主分类号: G06F7/00
- IPC分类号: G06F7/00 ; G06F17/30
摘要:
Systems, methodologies, media, and other embodiments associated with producing non-repeating random values for use in data masking are described. One example method includes accessing data describing a mask for a value in a database table column to be masked. The example method may also include identifying a number of distinct values in the database table column to be masked and determining a field width for a mask to provide unique random numbers to mask the distinct values. The method may include identifying locations in a mask value to store the unique random value and locations in a mask value to store filler values. The mask value may include different character sets and may comply with user specified formats. The method may include generating a set of statements that when executed produce a mapping table that includes masks for distinct values in the database table column to be masked.
公开/授权文献
信息查询