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

1. 发明申请

US20070244898A1 ROW-LEVEL SECURITY IN A RELATIONAL DATABASE MANAGEMENT SYSTEM 失效
标题翻译：关系数据库管理系统中的ROW级安全性
公开(公告)号：US20070244898A1
公开(公告)日：2007-10-18
申请号：US11746896
申请日：2007-05-10
申请人： Curt Cotner , Roger Miller
发明人： Curt Cotner , Roger Miller
IPC分类号： G06F17/30
CPC分类号： G06F21/6227 , G06F17/30289 , G06F17/30595 , G06F2221/2113 , G06F2221/2145 , Y10S707/954 , Y10S707/956 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99939
摘要： An access control system and access control methods provide multilevel and mandatory access control for a database management system. The access control techniques provide access control at the row level in a relational database table. The database table contains a security label column within which is recorded a security label that is defined within a hierarchical security scheme. A user's security label is encoded with security information concerning the user. When a user requests access to a row, a security mechanism compares the user's security information with the security information in the row. If the user's security dominates the row's security, the user is given access to the row.
摘要翻译：访问控制系统和访问控制方法为数据库管理系统提供多级和强制访问控制。访问控制技术在关系数据库表中的行级别提供访问控制。数据库表包含一个安全标签列，其中记录了在分层安全机制中定义的安全标签。用户的安全标签被编码与关于用户的安全信息。当用户请求访问行时，安全机制将用户的安全信息与行中的安全信息进行比较。如果用户的安全性主导了该行的安全性，则该用户可以访问该行。

2. 发明申请

US20070143313A1 Peephole DBMS reorganization allowing concurrent data manipulation 失效
标题翻译： Peephole DBMS重组允许并发数据操作
公开(公告)号：US20070143313A1
公开(公告)日：2007-06-21
申请号：US11313117
申请日：2005-12-19
申请人： Curt Cotner , James Ruddy
发明人： Curt Cotner , James Ruddy
IPC分类号： G06F7/00
CPC分类号： G06F17/30339 , Y10S707/99931 , Y10S707/99942
摘要： A method, apparatus and program storage device readable by a computer tangibly embodying a program of instructions executable by the computer is provided for reorganization of database data. The computer database reorganization method reorganizes one set of database data blocks at a time, allowing concurrent data manipulation. Method identifies a set of data blocks for reorganization in a sliding peephole mode, re-orders the set of data blocks and replaces the original set of data blocks with the re-ordered set of data blocks, if possible. Preferred embodiments include an overlapping peephole method, which chooses, for each set of data block to be reorganized, a next succeeding set of data blocks plus an overlap segment, wherein the overlap segment includes a set of empty pages other than intentionally specified free pages, and the overlap segment is a subset of the preceding set of data blocks.
摘要翻译：提供有形地体现由计算机可执行的指令程序的计算机可读的方法，装置和程序存储装置，用于重新组织数据库数据。计算机数据库重组方法一次重组一组数据库数据块，允许并发数据操作。方法识别一组用于在滑动窥视模式中进行重组的数据块，如果可能，重新命令该组数据块并用重新排序的数据块集替换原始数据块集合。优选实施例包括重叠窥视孔方法，其对于要重新组织的每组数据块选择下一个后续数据块集合加上重叠段，其中重叠段包括除有意指定的空闲页之外的一组空页，并且重叠段是前面的数据块集合的子集。

3. 发明申请

US20050177590A1 Low-overhead built-in timestamp column for relational database systems 有权
标题翻译：关系数据库系统的低开销内置时间戳列
公开(公告)号：US20050177590A1
公开(公告)日：2005-08-11
申请号：US10777604
申请日：2004-02-11
申请人： Yao-Ching Chen , Curt Cotner
发明人： Yao-Ching Chen , Curt Cotner
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99933 , Y10S707/99943
摘要： An improved automatically updated timestamp for database systems is disclosed. The automatically updated timestamp can be provided in a hidden timestamp column for a table, where the value of the timestamp column can be retrieved with a query that calls the column by name. Optionally, the timestamp column can be provided for each table in the database system to ensure its availability to applications. For cases where a timestamp for each row in a table is not desired, an automatically updated timestamp can be provided for a data page. This timestamp can be retrieved from an update timestamp recorded on disk and in the buffer pool or from a log relative byte address. Although this is a page-level timestamp, its use may be desirable for infrequently updated tables or where space on the disk and buffer pool is at a premium.
摘要翻译：公开了一种用于数据库系统的改进的自动更新时间戳。可以在表的隐藏时间戳列中提供自动更新的时间戳，其中可以使用按名称调用列的查询来检索时间戳列的值。可选地，可以为数据库系统中的每个表提供时间戳列，以确保其对应用程序的可用性。对于不需要表中每行的时间戳的情况，可以为数据页提供自动更新的时间戳。可以从记录在磁盘和缓冲池中的更新时间戳记或从日志相对字节地址检索此时间戳。虽然这是一个页面级的时间戳，但是对于不经常更新的表或者磁盘和缓冲池上的空间是非常重要的，它的使用可能是可取的。

4. 发明申请

US20050097090A1 System and method for managing query access to information 有权
标题翻译：用于管理信息查询访问的系统和方法
公开(公告)号：US20050097090A1
公开(公告)日：2005-05-05
申请号：US10931535
申请日：2004-09-01
申请人： Paul Bird , Curt Cotner , Patrick Dantressangle
发明人： Paul Bird , Curt Cotner , Patrick Dantressangle
IPC分类号： G06F17/30 , G06F21/62
CPC分类号： G06F21/6209 , G06F2221/2105 , G06F2221/2141 , Y10S707/99933
摘要： A system, computer usable medium and computer-based method for supporting named memory variables in an information retrieval system including a relational database. PUBLIC and PRIVATE named memory variables can be created, referenced, modified or deleted using SQL statements. The information retrieval system allocates a memory area as a named variable storage space for storing named memory variables. System catalogs may be used for storing information about PUBLIC, SECURE PUBLIC, PRIVATE, SECURE PRIVATE and pre-defined named memory variables. PUBLIC and PRIVATE named memory variables can be used for transferring information between SQL statements of one or more sessions or for retrieving system information from the relational database. Both PUBLIC and PRIVATE types can be defined as SECURE named memory variables requiring specific authorization privileges to read or write to the variable.
摘要翻译：一种用于在包括关系数据库的信息检索系统中支持命名存储器变量的系统，计算机可用介质和基于计算机的方法。可以使用SQL语句创建，引用，修改或删除PUBLIC和PRIVATE命名的内存变量。信息检索系统将存储区域分配为用于存储命名的存储器变量的命名变量存储空间。系统目录可用于存储有关PUBLIC，SECURE PUBLIC，PRIVATE，SECURE PRIVATE和预定义的命名内存变量的信息。 PUBLIC和PRIVATE命名的内存变量可用于在一个或多个会话的SQL语句之间传输信息，或用于从关系数据库检索系统信息。 PUBLIC和PRIVATE类型都可以定义为SECURE命名的内存变量，需要特定的授权权限来读取或写入变量。

5. 发明授权

US08478713B2 Row-level security in a relational database management system 有权
标题翻译：关系数据库管理系统中的行级安全性
公开(公告)号：US08478713B2
公开(公告)日：2013-07-02
申请号：US12242241
申请日：2008-09-30
申请人： Curt Cotner , Roger Lee Miller
发明人： Curt Cotner , Roger Lee Miller
IPC分类号： G06F17/30 , G06F15/16
CPC分类号： G06F21/6227 , G06F17/30289 , G06F17/30595 , G06F2221/2113 , G06F2221/2145 , Y10S707/954 , Y10S707/956 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99939
摘要： An access control system provides multilevel and mandatory access control for a database management system. The access control systems provide access control at the row level in a relational database table. The database table contains a security label column within which is recorded a security label that is defined within a hierarchical security scheme. A user's security label is encoded with security information concerning the user. When a user requests access to a row, a security mechanism compares the user's security information with the security information in the row. If the user's security dominates the row's security, the user is given access to the row.
摘要翻译：访问控制系统为数据库管理系统提供多级和强制访问控制。访问控制系统在关系数据库表中的行级提供访问控制。数据库表包含一个安全标签列，其中记录了在分层安全机制中定义的安全标签。用户的安全标签被编码与关于用户的安全信息。当用户请求访问行时，安全机制将用户的安全信息与行中的安全信息进行比较。如果用户的安全性主导了该行的安全性，则该用户可以访问该行。

6. 发明授权

US07240046B2 Row-level security in a relational database management system 有权
标题翻译：关系数据库管理系统中的行级安全性
公开(公告)号：US07240046B2
公开(公告)日：2007-07-03
申请号：US10233397
申请日：2002-09-04
申请人： Curt Cotner , Roger Lee Miller
发明人： Curt Cotner , Roger Lee Miller
IPC分类号： G06F17/30 , G06F15/16
CPC分类号： G06F21/6227 , G06F17/30289 , G06F17/30595 , G06F2221/2113 , G06F2221/2145 , Y10S707/954 , Y10S707/956 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99939
摘要： An access control system and access control methods provide multilevel and mandatory access control for a database management system. The access control techniques provide access control at the row level in a relational database table. The database table contains a security label column within which is recorded a security label that is defined within a hierarchical security scheme. A user's security label is encoded with security information concerning the user. When a user requests access to a row, a security mechanism compares the user's security information with the security information in the row. If the user's security dominates the row's security, the user is given access to the row.
摘要翻译：访问控制系统和访问控制方法为数据库管理系统提供多级和强制访问控制。访问控制技术在关系数据库表中的行级别提供访问控制。数据库表包含一个安全标签列，其中记录了在分层安全机制中定义的安全标签。用户的安全标签被编码与关于用户的安全信息。当用户请求访问行时，安全机制将用户的安全信息与行中的安全信息进行比较。如果用户的安全性主导了该行的安全性，则该用户可以访问该行。

7. 发明申请

US20060123468A1 Method, system and program for establishing a trusted relationship between a data server and a middleware server 失效
标题翻译：用于在数据服务器和中间件服务器之间建立可靠关系的方法，系统和程序
公开(公告)号：US20060123468A1
公开(公告)日：2006-06-08
申请号：US11008507
申请日：2004-12-08
申请人： Paul Bird , Curt Cotner , Walid Rjaibi , Timothy Vincent
发明人： Paul Bird , Curt Cotner , Walid Rjaibi , Timothy Vincent
IPC分类号： H04L9/32
CPC分类号： H04L63/083 , G06F17/30286
摘要： A data server of a data processing system is operably coupled to a database and in communication with a middleware server. A connection between the data server and the middleware server is established and managed. A set of attributes identifying trusted middleware servers is instituted with the data server. The middleware server transmits a connection request to the data server. The connection request has request attributes including identifying the connection request as being for a new connection or reuse of an existing connection with different connection request attributes. A connection with the middleware server is established by the data server based on the connection request. A connection status message is received by the middleware server from the data server indicating a status of the connection request. A trust indicator for the connection is established at the data server according to a trust status identified by the set of attributes for the middleware server.
摘要翻译：数据处理系统的数据服务器可操作地耦合到数据库并与中间件服务器通信。建立和管理数据服务器与中间件服务器之间的连接。数据服务器建立了识别可信中间件服务器的一组属性。中间件服务器向数据服务器发送连接请求。连接请求具有请求属性，包括将连接请求标识为用于新连接或重新使用具有不同连接请求属性的现有连接。数据服务器根据连接请求建立与中间件服务器的连接。连接状态消息由中间件服务器从数据服务器接收到，指示连接请求的状态。根据由中间件服务器的属性集识别的信任状态，在数据服务器处建立用于连接的信任指示符。

8. 发明申请

US20050125445A1 High performance support for XA protocols in a clustered shared database 有权
标题翻译：在群集共享数据库中对XA协议的高性能支持
公开(公告)号：US20050125445A1
公开(公告)日：2005-06-09
申请号：US10726700
申请日：2003-12-04
申请人： Curt Cotner , Brian Howell , Jeffrey Josten , James Pickel
发明人： Curt Cotner , Brian Howell , Jeffrey Josten , James Pickel
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30371 , Y10S707/99953
摘要： A shared memory device called the Coupling Facility (CF) is used to record the indoubt transaction entries for each member of the database cluster, avoiding the CPU cost and elapsed time impact of persisting this information to disk (either via a log write or a relational table I/O). The CF provides full read/write access and data coherency for concurrent access by all the members in the database cluster. At any given point in time, the CF will contain the full list of indoubt transactions for the entire database cluster. CF duplexing is used to guarantee the integrity of the CF structure used for the indoubt list. In the event of complete loss of both CF structures (which will not happen except in major disaster situations), data sharing group restart processing can reconstruct the CF structures from the individual member logs.
摘要翻译：称为耦合设施（CF）的共享内存设备用于记录数据库集群中每个成员的不确定事务条目，从而避免将此信息持续存储在磁盘上的CPU成本和耗时时间（通过日志写入或关系表I / O）。 CF为数据库集群中的所有成员提供完全读/写访问和数据一致性并发访问。在任何给定的时间点，CF将包含整个数据库集群的不确定事务的完整列表。 CF双工用于确保用于不确定列表的CF结构的完整性。在CF结构完全丢失的情况下（除主要灾害情况外不会发生），数据共享组重新启动处理可以从各个成员日志中重构CF结构。

9. 发明授权

US08131664B2 Row-level security in a relational database management system 有权
公开(公告)号：US08131664B2
公开(公告)日：2012-03-06
申请号：US12242241
申请日：2008-09-30
申请人： Curt Cotner , Roger Lee Miller
发明人： Curt Cotner , Roger Lee Miller
IPC分类号： G06F17/30 , G06F15/16
摘要： An access control system provides multilevel and mandatory access control for a database management system. The access control systems provide access control at the row level in a relational database table. The database table contains a security label column within which is recorded a security label that is defined within a hierarchical security scheme. A user's security label is encoded with security information concerning the user. When a user requests access to a row, a security mechanism compares the user's security information with the security information in the row. If the user's security dominates the row's security, the user is given access to the row.

10. 发明申请

US20070143249A1 System and method for deploying an SQL procedure 有权
标题翻译：用于部署SQL过程的系统和方法
公开(公告)号：US20070143249A1
公开(公告)日：2007-06-21
申请号：US11311810
申请日：2005-12-17
申请人： Margaret Bernal , Yao-Ching Chen , Ding-Wei Chieh , Curt Cotner , Baoqiu Cui , Tammie Dang , Marion Farber , Georgia Fuller , Joe Huang , Hui-An Lee , Claire McFeely , Chunfeng Pei , James Pickel , Yumi Tsuji , Jay Yothers , Margaret Zagelow , Liyan Zhou
发明人： Margaret Bernal , Yao-Ching Chen , Ding-Wei Chieh , Curt Cotner , Baoqiu Cui , Tammie Dang , Marion Farber , Georgia Fuller , Joe Huang , Hui-An Lee , Claire McFeely , Chunfeng Pei , James Pickel , Yumi Tsuji , Jay Yothers , Margaret Zagelow , Liyan Zhou
IPC分类号： G06F17/30
CPC分类号： G06F17/30587
摘要： An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component.
摘要翻译： SQL过程部署系统将包含过程逻辑组件和数据库请求组件的查询过程从源系统部署到目标系统。在生成查询过程时，系统生成查询过程源代码，符号表和封装的优化结果，以重新生成数据库请求组件的查询语句的运行时指令，并使查询语句具有部署的过程逻辑零件。在部署期间，系统维护程序逻辑组件和数据库请求组件之间的关联。系统将程序逻辑组件的内部表示复制到目标系统，而无需再生。系统重新生成数据库请求组件以在目标系统上重新创建查询过程，并在过程逻辑组件和数据库请求组件之间保持一致的接口。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式