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

1. 发明申请

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.
摘要翻译：提供有形地体现由计算机可执行的指令程序的计算机可读的方法，装置和程序存储装置，用于重新组织数据库数据。计算机数据库重组方法一次重组一组数据库数据块，允许并发数据操作。方法识别一组用于在滑动窥视模式中进行重组的数据块，如果可能，重新命令该组数据块并用重新排序的数据块集替换原始数据块集合。优选实施例包括重叠窥视孔方法，其对于要重新组织的每组数据块选择下一个后续数据块集合加上重叠段，其中重叠段包括除有意指定的空闲页之外的一组空页，并且重叠段是前面的数据块集合的子集。

2. 发明申请

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.
摘要翻译：访问控制系统和访问控制方法为数据库管理系统提供多级和强制访问控制。访问控制技术在关系数据库表中的行级别提供访问控制。数据库表包含一个安全标签列，其中记录了在分层安全机制中定义的安全标签。用户的安全标签被编码与关于用户的安全信息。当用户请求访问行时，安全机制将用户的安全信息与行中的安全信息进行比较。如果用户的安全性主导了该行的安全性，则该用户可以访问该行。

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. 发明申请

US20090030907A1 ROW-LEVEL SECURITY IN A RELATIONAL DATABASE MANAGEMENT SYSTEM 有权
标题翻译：关系数据库管理系统中的ROW级安全性
公开(公告)号：US20090030907A1
公开(公告)日：2009-01-29
申请号：US12242241
申请日：2008-09-30
申请人： Curt Cotner , Roger Lee Miller
发明人： Curt Cotner , Roger Lee 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 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. 发明申请

US20070174838A1 Tuning of work to meet performance goal 失效
标题翻译：调整工作以达到业绩目标
公开(公告)号：US20070174838A1
公开(公告)日：2007-07-26
申请号：US11339002
申请日：2006-01-24
申请人： Curt Cotner , You-Chin Fuh , Holger Karn , James Porell , Bryan Smith
发明人： Curt Cotner , You-Chin Fuh , Holger Karn , James Porell , Bryan Smith
IPC分类号： G06F9/46
CPC分类号： G06F11/3466 , G06F11/3409 , G06F11/3433
摘要： Techniques are provided for tuning work. In response to identifying a trigger for a work, automatic tuning is invoked. The trigger indicates that a performance goal for the work has been missed. The work is analyzed. A tuning operation is selected for the work based on a tuning history. The selected tuning operation is implemented for the work.
摘要翻译：提供了调整工作的技术。响应于识别工作的触发，调用自动调整。触发器指示工作的性能目标已经错过。分析工作。基于调谐历史为工作选择调谐操作。所选择的调谐操作是为工作实现的。

7. 发明申请

US20060288052A1 Supporting multiple versions of a routine 有权
公开(公告)号：US20060288052A1
公开(公告)日：2006-12-21
申请号：US11156509
申请日：2005-06-17
申请人： Yao-Ching Chen , Curt Cotner , Baoqiu Cui , Tammie Dang , Joe Huang , Claire McFeely , Robert Miller , Manogari Simanjuntak , Yumi Tsuji , Xiaoyu Yang , Jay Yothers , Margaret Zagelow
发明人： Yao-Ching Chen , Curt Cotner , Baoqiu Cui , Tammie Dang , Joe Huang , Claire McFeely , Robert Miller , Manogari Simanjuntak , Yumi Tsuji , Xiaoyu Yang , Jay Yothers , Margaret Zagelow
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99952 , Y10S707/99953
摘要： Techniques are provided for supporting versions of a routine. A first version of the routine is created. A second version of the routine is generated in response to receiving an alter statement including an add version clause. The second version of the routine is activated in response to receiving an alter statement including an activate version clause.

8. 发明授权

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.
摘要翻译：访问控制系统为数据库管理系统提供多级和强制访问控制。访问控制系统在关系数据库表中的行级提供访问控制。数据库表包含一个安全标签列，其中记录了在分层安全机制中定义的安全标签。用户的安全标签被编码与关于用户的安全信息。当用户请求访问行时，安全机制将用户的安全信息与行中的安全信息进行比较。如果用户的安全性主导了该行的安全性，则该用户可以访问该行。

9. 发明授权

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.
摘要翻译：访问控制系统和访问控制方法为数据库管理系统提供多级和强制访问控制。访问控制技术在关系数据库表中的行级别提供访问控制。数据库表包含一个安全标签列，其中记录了在分层安全机制中定义的安全标签。用户的安全标签被编码与关于用户的安全信息。当用户请求访问行时，安全机制将用户的安全信息与行中的安全信息进行比较。如果用户的安全性主导了该行的安全性，则该用户可以访问该行。

10. 发明申请

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.
摘要翻译：数据处理系统的数据服务器可操作地耦合到数据库并与中间件服务器通信。建立和管理数据服务器与中间件服务器之间的连接。数据服务器建立了识别可信中间件服务器的一组属性。中间件服务器向数据服务器发送连接请求。连接请求具有请求属性，包括将连接请求标识为用于新连接或重新使用具有不同连接请求属性的现有连接。数据服务器根据连接请求建立与中间件服务器的连接。连接状态消息由中间件服务器从数据服务器接收到，指示连接请求的状态。根据由中间件服务器的属性集识别的信任状态，在数据服务器处建立用于连接的信任指示符。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式