专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明专利

JP2004348744A Identification method for identifying change carried out for table, and its system 有权
标题翻译：识别用于表及其系统的识别方法
公开(公告)号：JP2004348744A
公开(公告)日：2004-12-09
申请号：JP2004152121
申请日：2004-05-21
申请人： Microsoft Corp , マイクロソフトコーポレーション
发明人： KRISHNAMOORTHY GANAPATHY , XIAO WEI , ELLIS NIGEL R , KLINE RODGER N , AGARWAL SAMEET H
IPC分类号： G06F12/00 , G06F17/30 , G06F17/40
CPC分类号： G06F17/30368 , Y10S707/99942 , Y10S707/99943 , Y10S707/99945
摘要： PROBLEM TO BE SOLVED: To efficiently identify and store change carried out for a table.
SOLUTION: A basic table is scanned by using a deletion marker and an insertion marker. The deletion marker identifies last change committed to the basic table as a part of transaction before executing a statement, and the insertion marker identifies last change committed to the basic table as a part of transaction during the execution of the statement. The scanning result of the insertion marker is filtered by using deletion stored in a delta table, and a filtered row is inputted into a deletion file. The scanning result of the insertion marker is filtered by using insertion stored in the delta table, and a filtered row is inputted into an insertion table.
COPYRIGHT: (C)2005,JPO&NCIPI
摘要翻译：要解决的问题：有效地识别和存储为表执行的更改。
解决方案：使用删除标记和插入标记扫描基本表。在执行语句之前，删除标记将作为事务的一部分提交给基本表的最后一次更改标识，并且插入标记在执行语句时识别作为事务的一部分提交给基本表的最后一次更改。通过使用存储在增量表中的删除来对插入标记的扫描结果进行滤波，将滤波后的行输入到删除文件中。通过使用存储在增量表中的插入来对插入标记的扫描结果进行滤波，将滤波后的行输入到插入表中。版权所有（C）2005，JPO＆NCIPI

2. 发明专利

JP2005228312A System and method for optimizing row level database security 有权
标题翻译：优化数据库安全性的系统和方法
公开(公告)号：JP2005228312A
公开(公告)日：2005-08-25
申请号：JP2005026874
申请日：2005-02-02
申请人： Microsoft Corp , マイクロソフトコーポレーション
发明人： CHANDER GIRSH , HAMILTON JAMES R , CRISTOFOR LAURENTIU B , KLINE RODGER N , DUTTA TANMOY
IPC分类号： G06F17/30 , G06F17/40 , G06F21/62 , G06F12/14
CPC分类号： G06F21/6227
摘要： PROBLEM TO BE SOLVED: To facilitate database row-level security by utilizing SQL extensions to create and associate named security expressions with a query initiator(s). SOLUTION: Such expressions include Boolean expressions, which must be satisfied by a row of data in order for that data to be made accessible from the query initiator. A query is augmented with security expressions, which are aggregated and utilized during querying rows of data. This application variously place security expressions within a query in order to optimize query performance while mitigating information leaks. This is achieved by tagging security expressions as special and utilizing rules of predicate to pull or push non-security expressions above or below security expressions, depending on the likelihood of a non-security being safe, as determined via a static and/or dynamic analysis. COPYRIGHT: (C)2005,JPO&NCIPI
摘要翻译：要解决的问题：通过利用SQL扩展来创建和关联命名的安全表达式和查询启动器来促进数据库行级安全性。
解决方案：这样的表达式包括布尔表达式，必须由一行数据满足，才能使该数据从查询启动器访问。在查询数据行期间，会将查询扩展为安全表达式，这些表达式将被聚合和使用。此应用程序将查询中的安全表达式各不相同，以优化查询性能，同时减轻信息泄漏。这是通过将安全表达式标记为特殊的，并利用谓词的规则在安全表达式之上或之下拉取或推送非安全表达式，这取决于非安全性的可能性，通过静态和/或动态分析确定。版权所有（C）2005，JPO＆NCIPI

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式