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

1. 发明授权

US08930410B2 Query transformation for masking data within database objects 有权
标题翻译：用于屏蔽数据库对象内的数据的查询转换
公开(公告)号：US08930410B2
公开(公告)日：2015-01-06
申请号：US13251448
申请日：2011-10-03
申请人： Eric L. Alton , Thomas A. Beavin , Harley W. Boughton , Yao-Ching S. Chen , Curt L. Cotner , Yuping Ding , Dengfeng Gao , Gerald G. Kiernan , Xun Li , Irene C. Liu , Walid Rjaibi , Gregory R. Stager , Joyce A. Taylor , Timothy J. Vincent , Liyan Zhou
发明人： Eric L. Alton , Thomas A. Beavin , Harley W. Boughton , Yao-Ching S. Chen , Curt L. Cotner , Yuping Ding , Dengfeng Gao , Gerald G. Kiernan , Xun Li , Irene C. Liu , Walid Rjaibi , Gregory R. Stager , Joyce A. Taylor , Timothy J. Vincent , Liyan Zhou
IPC分类号： G06F17/30
CPC分类号： G06F17/30477
摘要： According to one embodiment of the present invention, a system processes a database query, and comprises a computer system including at least one processor. The system identifies one or more expressions within the database query utilizing a database object with value masking. Masking requirements are determined for each identified expression and the database object utilized by that identified expression is replicated to provide masked and actual versions of that database object in response to the masking requirements for that expression including masked values and actual values of that database object. The value masking of the database object is applied to the identified expressions within the database query based on the determined masking requirements to produce search results with masked values for the database query. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manner described above.
摘要翻译：根据本发明的一个实施例，系统处理数据库查询，并且包括包括至少一个处理器的计算机系统。系统使用具有值屏蔽的数据库对象来识别数据库查询中的一个或多个表达式。针对每个已标识的表达式确定掩蔽要求，并复制由该标识表达式使用的数据库对象，以响应该表达式的掩蔽要求（包括该数据库对象的掩蔽值和实际值）来提供该数据库对象的屏蔽和实际版本。数据库对象的值屏蔽将基于确定的屏蔽要求应用于数据库查询中的标识表达式，以生成具有数据库查询的掩码值的搜索结果。本发明的实施例还包括用于以与上述基本相同的方式处理数据库查询的方法和计算机程序产品。

2. 发明申请

US20130086088A1 Query Transformation for Masking Data Within Database Objects 有权
标题翻译：数据库对象中掩码数据的查询转换
公开(公告)号：US20130086088A1
公开(公告)日：2013-04-04
申请号：US13251448
申请日：2011-10-03
申请人： Eric L. Alton , Thomas A. Beavin , Harley W. Boughton , Yao-Ching S. Chen , Curt L. Cotner , Yuping Ding , Dengfeng Gao , Gerald G. Kiernan , Xun Li , Irene C. Liu , Walid Rjaibi , Gregory R. Stager , Joyce A. Taylor , Timothy J. Vincent , Liyan Zhou
发明人： Eric L. Alton , Thomas A. Beavin , Harley W. Boughton , Yao-Ching S. Chen , Curt L. Cotner , Yuping Ding , Dengfeng Gao , Gerald G. Kiernan , Xun Li , Irene C. Liu , Walid Rjaibi , Gregory R. Stager , Joyce A. Taylor , Timothy J. Vincent , Liyan Zhou
IPC分类号： G06F17/30
CPC分类号： G06F17/30477
摘要： According to one embodiment of the present invention, a system processes a database query, and comprises a computer system including at least one processor. The system identifies one or more expressions within the database query utilizing a database object with value masking. Masking requirements are determined for each identified expression and the database object utilized by that identified expression is replicated to provide masked and actual versions of that database object in response to the masking requirements for that expression including masked values and actual values of that database object. The value masking of the database object is applied to the identified expressions within the database query based on the determined masking requirements to produce search results with masked values for the database query. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manner described above.
摘要翻译：根据本发明的一个实施例，系统处理数据库查询，并且包括包括至少一个处理器的计算机系统。系统使用具有值屏蔽的数据库对象来识别数据库查询中的一个或多个表达式。针对每个已标识的表达式确定掩蔽要求，并复制由该标识表达式使用的数据库对象，以响应该表达式的掩蔽要求（包括该数据库对象的掩蔽值和实际值）来提供该数据库对象的屏蔽和实际版本。数据库对象的值屏蔽将基于确定的屏蔽要求应用于数据库查询中的标识表达式，以生成具有数据库查询的掩码值的搜索结果。本发明的实施例还包括用于以与上述基本相同的方式处理数据库查询的方法和计算机程序产品。

3. 发明授权

US08515948B2 Managing materialized query tables (MQTS) over fine-grained access control (FGAC) protected tables 有权
标题翻译：通过细粒度访问控制（FGAC）受保护的表管理物化查询表（MQTS）
公开(公告)号：US08515948B2
公开(公告)日：2013-08-20
申请号：US13044415
申请日：2011-03-09
申请人： Yao-Ching S. Chen , Curt L. Cotner , Gerald G. Kiernan , David J. Kuang , Irene C. Liu , Regina J. Liu , Walid Rjaibi , Timothy J. Vincent
发明人： Yao-Ching S. Chen , Curt L. Cotner , Gerald G. Kiernan , David J. Kuang , Irene C. Liu , Regina J. Liu , Walid Rjaibi , Timothy J. Vincent
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30448 , G06F17/30383 , G06F17/30442 , G06F17/30457 , G06F17/30935 , G06F21/604
摘要： Provided are techniques for creating one or more fine-grained access control rules that are associated with a base table. A materialized query table is created from the base table without applying the one or more fine-grained access control rules associated with the base table when obtaining data from the base table. A fine-grained access control protection indicator is turned on for the materialized query table. In response to receiving a direct access request to the materialized query table in a query referencing the materialized query table, access is provided to the data in the materialized query table by applying one or more fine-grained access control rules associated directly with the materialized query table to the data in the materialized query table before returning the data.
摘要翻译：提供了用于创建与基表相关联的一个或多个细粒度访问控制规则的技术。当从基表获取数据时，从基表创建物化查询表，而不应用与基表相关联的一个或多个细粒度访问控制规则。为物化查询表打开了一个细粒度的访问控制保护指示器。响应于在引用物化查询表的查询中接收到物化查询表的直接访问请求，通过应用与物化查询直接相关联的一个或多个细粒度访问控制规则，向物化查询表中的数据提供访问表返回数据之前的物化查询表中的数据。

4. 发明授权

US08983985B2 Masking sensitive data of table columns retrieved from a database 有权
标题翻译：屏蔽从数据库检索的表列的敏感数据
公开(公告)号：US08983985B2
公开(公告)日：2015-03-17
申请号：US13016010
申请日：2011-01-28
申请人： Stephen Yao Ching Chen , Curt L. Cotner , Gerald G. Kiernan , Irene Ching-Hua Liu , Claire W. McFeely , Walid Rjaibi , Timothy J. Vincent
发明人： Stephen Yao Ching Chen , Curt L. Cotner , Gerald G. Kiernan , Irene Ching-Hua Liu , Claire W. McFeely , Walid Rjaibi , Timothy J. Vincent
IPC分类号： G06F17/30
CPC分类号： G06F17/30315 , G06F17/30
摘要： Access to a data element stored within a database object is controlled. A request is received from a user to perform an operation in relation to the database object, the operation including retrieval of information from the data element of the database object. Prior to retrieving information from the data element, a determination is made whether at least a portion of the information from the data element is subject to masking in accordance with an access policy. In response to determining that information from the data element is subject to masking, the request is modified to require that information from the data element be retrieved in a masked condition.
摘要翻译：控制对数据库对象中存储的数据元素的访问。从用户接收到执行与数据库对象相关的操作的请求，该操作包括从数据库对象的数据元素检索信息。在从数据元素检索信息之前，确定根据访问策略是否对来自数据元素的信息的至少一部分进行掩蔽。响应于确定来自数据元素的信息被屏蔽，修改该请求以要求在掩蔽条件下检索来自数据元素的信息。

5. 发明申请

US20120197919A1 Masking Sensitive Data of Table Columns Retrieved From a Database 有权
标题翻译：从数据库检索表列的屏蔽敏感数据
公开(公告)号：US20120197919A1
公开(公告)日：2012-08-02
申请号：US13016010
申请日：2011-01-28
申请人： Stephen Yao Ching Chen , Curt L. Cotner , Gerald G. Kiernan , Irene Ching-Hua Liu , Claire W. McFeely , Walid Rjaibi , Timothy J. Vincent
发明人： Stephen Yao Ching Chen , Curt L. Cotner , Gerald G. Kiernan , Irene Ching-Hua Liu , Claire W. McFeely , Walid Rjaibi , Timothy J. Vincent
IPC分类号： G06F17/30
CPC分类号： G06F17/30315 , G06F17/30
摘要： Access to a data element stored within a database object is controlled. A request is received from a user to perform an operation in relation to the database object, the operation including retrieval of information from the data element of the database object. Prior to retrieving information from the data element, a determination is made whether at least a portion of the information from the data element is subject to masking in accordance with an access policy. In response to determining that information from the data element is subject to masking, the request is modified to require that information from the data element be retrieved in a masked condition.
摘要翻译：控制对数据库对象中存储的数据元素的访问。从用户接收到执行与数据库对象相关的操作的请求，该操作包括从数据库对象的数据元素检索信息。在从数据元素检索信息之前，确定根据访问策略是否对来自数据元素的信息的至少一部分进行掩蔽。响应于确定来自数据元素的信息被屏蔽，修改该请求以要求在掩蔽条件下检索来自数据元素的信息。

6. 发明授权

US07039651B2 System and method for executing a large object fetch query against a database 有权
标题翻译：用于针对数据库执行大型对象提取查询的系统和方法
公开(公告)号：US07039651B2
公开(公告)日：2006-05-02
申请号：US10425851
申请日：2003-04-29
申请人： Curt L. Cotner , Robert A. Begg , Brent P. Gross , Paul A. Ostler , Timothy J. Vincent
发明人： Curt L. Cotner , Robert A. Begg , Brent P. Gross , Paul A. Ostler , Timothy J. Vincent
IPC分类号： G06F17/30
CPC分类号： G06F17/30318 , Y10S707/99944 , Y10S707/99946
摘要： A database server helps to streamline the retrieval of LOB values by deciding to send a locator in replacement of the LOB value, or the LOB value itself, depending upon the specific LOB value being retrieved. A threshold value is determined in a fetch query, and the LOB sizes below that threshold are sent as values in a corresponding fetch response, and the lengths above are sent as locators in the fetch response. Indicators are inserted in a fetch parameter of the response to inform the receiving client the form of retrieval that was used for each requested LOB value being returned.
摘要翻译：数据库服务器有助于通过根据正在检索的特定LOB值决定发送定位器替换LOB值或LOB值本身来简化LOB值的检索。在获取查询中确定阈值，并且低于该阈值的LOB大小作为相应获取响应中的值发送，并且上述长度作为定位器发送在获取响应中。指示符插入到响应的提取参数中，以通知接收客户端返回的每个请求的LOB值所使用的检索形式。

7. 发明授权

US06959305B2 Unique identification of SQL cursor occurrences in a repetitive, nested environment 失效
标题翻译：重复嵌套环境中SQL游标出现的唯一标识
公开(公告)号：US06959305B2
公开(公告)日：2005-10-25
申请号：US10317234
申请日：2002-12-10
申请人： Paul M. Bird , Timothy J. Vincent , Curt L. Cotner
发明人： Paul M. Bird , Timothy J. Vincent , Curt L. Cotner
IPC分类号： G06F17/30
CPC分类号： G06F17/30286 , Y10S707/954 , Y10S707/99932 , Y10S707/99933 , Y10S707/99942 , Y10S707/99945
摘要： A cursor query identifier is defined to uniquely identify cursors in a relational database system that supports nested routine invocation. The identifier includes a cursor nesting level value that corresponds to the nested level at which the cursor is opened. The identifier also includes a invocation identifier that corresponds to the routine within which a cursor is opened. The third part of the identifier is a unique cursor counter. The definition of the cursor query identifier permits cursors to be opened within nested levels of the same relational database context and to be uniquely identified for reference by database system and by applications accessing the system.
摘要翻译：定义游标查询标识符以唯一标识支持嵌套例程调用的关系数据库系统中的游标。标识符包括与光标所在的嵌套级别相对应的游标嵌套级别值。标识符还包括对应于光标被打开的例程的调用标识符。标识符的第三部分是唯一的光标计数器。游标查询标识符的定义允许在相同关系数据库上下文的嵌套级别中打开游标，并且被唯一标识以供数据库系统和访问系统的应用程序引用。

8. 发明授权

US06850942B2 System and method for providing multiple virtual database connections in a relational database system 失效
标题翻译：在关系数据库系统中提供多个虚拟数据库连接的系统和方法
公开(公告)号：US06850942B2
公开(公告)日：2005-02-01
申请号：US10133162
申请日：2002-04-26
申请人： Curt L. Cotner , Paul M. Bird , Timothy J. Vincent
发明人： Curt L. Cotner , Paul M. Bird , Timothy J. Vincent
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30595 , Y10S707/959 , Y10S707/99931
摘要： A method for providing database connections in a network includes: (a) mapping a first plurality of logical connections for a transaction at the application server to a physical connection between the application server and the database server; (b) sending a request of the transaction to the database server utilizing one of the first plurality of logical connections, where the request is sent utilizing the physical connection; and (c) processing the request by a logical agent on the database server, where the logical agent is associated with the transaction, where the request is maintained in one of a second plurality of logical connections within the logical agent. In this manner, connections are logically separated from one another with minimal storage implications. Conflicts and unpredictable behavior can also be avoided.
摘要翻译：一种用于在网络中提供数据库连接的方法包括：（a）将应用服务器处的事务的第一多个逻辑连接映射到应用服务器与数据库服务器之间的物理连接; （b）使用所述第一多个逻辑连接中的一个将所述交易的请求发送到所述数据库服务器，其中使用所述物理连接发送所述请求; 以及（c）由数据库服务器上的逻辑代理处理该请求，其中逻辑代理与事务相关联，其中请求被维护在逻辑代理中的第二多个逻辑连接之一中。以这种方式，连接在逻辑上彼此分离，具有最小的存储影响。也可以避免冲突和不可预知的行为。

9. 发明申请

US20080201288A1 METHOD, SYSTEM AND PROGRAM PRODUCT FOR IDENTIFYING CACHING OPPORTUNITIES 审中-公开
标题翻译：用于识别移动机会的方法，系统和程序产品
公开(公告)号：US20080201288A1
公开(公告)日：2008-08-21
申请号：US11675142
申请日：2007-02-15
申请人： Gennaro A. Cuomo , Thomas R. Gissel , Stephen Rees , Timothy J. Vincent
发明人： Gennaro A. Cuomo , Thomas R. Gissel , Stephen Rees , Timothy J. Vincent
IPC分类号： G06N5/02 , G06F3/01
CPC分类号： G06F12/0888 , G06F12/0866 , H04L67/2852
摘要： A method, system and program product for identifying caching opportunities is provided. The method includes identifying one or more data sources stored on a database system that are utilized by an application, establishing a pre-set read-update ratio threshold for data accessed from a data source, and tracking the read-update ratio threshold for data accessed from the data source, such that exceeding the pre-set read-update ratio threshold for the data accessed identifies a caching opportunity. The method further includes defining an action to be taken when the pre-set read-update ratio threshold for the data accessed from the data source has been exceeded and taking the action defined when the pre-set read-update ratio threshold for the data accessed from the data source has been exceeded. The action defined includes either advising a user of an opportunity to cache the data accessed or automatically caching the data accessed from the data source.
摘要翻译：提供了一种用于识别缓存机会的方法，系统和程序产品。该方法包括识别存储在应用程序利用的数据库系统上的一个或多个数据源，为从数据源访问的数据建立预设的读取 - 更新比率阈值，以及跟踪所访问数据的读取更新比率阈值从数据源，使得超过所访问的数据的预设读取更新比率阈值识别缓存机会。该方法还包括定义当从数据源访问的数据的预设读取 - 更新比率阈值已经被超过时采取的动作，并且采取在所访问的数据的预设读取 - 更新比率阈值时定义的动作从数据源已被超越。定义的操作包括建议用户有机会缓存访问的数据或自动缓存从数据源访问的数据。

10. 发明授权

US06807540B2 System and method for deadlock management in database systems with demultiplexed connections 失效
标题翻译：具有解复用连接的数据库系统中的死锁管理系统和方法
公开(公告)号：US06807540B2
公开(公告)日：2004-10-19
申请号：US09872831
申请日：2001-05-31
申请人： Matthew A. Huras , Sean W. McKeough , Timothy J. Vincent , Xun Xue , Roger L. Zheng
发明人： Matthew A. Huras , Sean W. McKeough , Timothy J. Vincent , Xun Xue , Roger L. Zheng
IPC分类号： G06F1730
CPC分类号： G06F9/526 , G06F17/30362 , Y10S707/99938 , Y10S707/99945
摘要： A system and method for managing deadlocks in a database management system (DBMS) for a demultiplexed database system. The DBMS supports applications that are capable of holding and retaining locks on database resources while disassociated from worker agents. The system and method includes an application scheduler for managing requests for access to the database, and a deadlock detector for identifying a deadlock. The application scheduler assigns one worker agent to an application requesting access to a database resource, assigns a flag to an application holding a lock on the database resource while disassociated from a worker agent, and in cooperation with the deadlock detector, resolves the deadlock between the application requesting access and the flagged application holding the lock.
摘要翻译：一种用于管理解复用数据库系统的数据库管理系统（DBMS）中的死锁的系统和方法。 DBMS支持能够保留和保留数据库资源上的锁定的应用程序，同时与工作代理程序解除关联。该系统和方法包括用于管理对数据库的访问请求的应用调度器，以及用于识别死锁的死锁检测器。应用程序调度器向请求访问数据库资源的应用程序分配一个工作代理，在与工作代理解除关联的同时向持有数据库资源的锁定的应用程序分配标志，并且与死锁检测器协作解决了请求访问的应用程序和持有锁定的标记应用程序。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式