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

11. 发明授权

US07970787B2 Access concurrency for cached authorization information in relational database systems 失效
标题翻译：访问关系数据库系统中缓存授权信息的并发性
公开(公告)号：US07970787B2
公开(公告)日：2011-06-28
申请号：US10391118
申请日：2003-03-17
申请人： Michael A. F. Stuy , Paul M. Bird
发明人： Michael A. F. Stuy , Paul M. Bird
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30362
摘要： A method and system for improving access concurrency to information stored in at least one table in a relational database system is disclosed. The method comprises providing a data cache, which stores a portion of the at least one table. The data cache includes a plurality of cache entries, wherein each cache entry comprises a first data item, a second data item, and a cache entry state. The method further comprises retrieving from the at least one table and storing in a cache entry's first data item a representation of committed information for a user, and retrieving from the at least one table and storing in the cache entry's second data item a representation of changes applied to the committed information, but not yet committed in the database system.
摘要翻译：公开了一种用于改善与关系数据库系统中的至少一个表中存储的信息的访问并发性的方法和系统。该方法包括提供存储该至少一个表的一部分的数据高速缓存。数据高速缓存包括多个高速缓存条目，其中每个高速缓存条目包括第一数据项，第二数据项和高速缓存条目状态。所述方法还包括从所述至少一个表中检索并在高速缓存条目的第一数据项中存储用于用户的已提交信息的表示，以及从所述至少一个表中检索并在所述高速缓存条目的第二数据项中存储变化的表示应用于提交的信息，但尚未在数据库系统中提交。

12. 发明授权

US07933948B2 Computer-readable medium to multiplex multiple application server requests over a single database connection 失效
标题翻译：用于通过单个数据库连接复用多个应用程序服务器请求的计算机可读介质
公开(公告)号：US07933948B2
公开(公告)日：2011-04-26
申请号：US12164920
申请日：2008-06-30
申请人： Paul M. Bird , William R. Bireley , Curt L. Cotner , Tammie Dang , Margaret A. Dong , Georgia C. Fuller , Michelle D. Lam , James W. Pickel , Frankie K. Sun
发明人： Paul M. Bird , William R. Bireley , Curt L. Cotner , Tammie Dang , Margaret A. Dong , Georgia C. Fuller , Michelle D. Lam , James W. Pickel , Frankie K. Sun
IPC分类号： G06F15/16
CPC分类号： G06F17/3056 , G06F17/30348 , G06F17/30445 , Y10S707/99953
摘要： In a system for avoiding section collision for application server requests over a single database connection, the database server assigns query identifiers to each instance of the same cursor opened for the same processing level within an application, allowing multiple instances of the same cursor to be processed in parallel without section collision. The application server assigns a command source identifier to each statement sent over a single database connection to uniquely identify the application source of the statement. This applies for multiples of the same statement sent by different application sources within the same application, for a single statement containing multiple application sources, and for multiple statements from different applications multiplexed over a single database connection. These statements can be processed separately from and in parallel with the each other without section collision.
摘要翻译：在用于通过单个数据库连接避免应用程序服务器请求的部分冲突的系统中，数据库服务器为应用程序内为相同处理级别打开的同一个游标的每个实例分配查询标识符，允许处理相同光标的多个实例平行而无分段碰撞。应用程序服务器为通过单个数据库连接发送的每个语句分配命令源标识符，以唯一标识语句的应用程序源。这适用于同一应用程序中由不同应用程序源发送的相同语句的倍数，对于包含多个应用程序源的单个语句，以及来自通过单个数据库连接复用的不同应用程序的多个语句。这些语句可以彼此分开处理，也可以彼此并行处理，而不会出现部分冲突。

13. 发明授权

US07099863B2 System and method for caching database query statements 有权
标题翻译：用于缓存数据库查询语句的系统和方法
公开(公告)号：US07099863B2
公开(公告)日：2006-08-29
申请号：US10425164
申请日：2003-04-29
申请人： Paul M. Bird , Michael J. Snowbell
发明人： Paul M. Bird , Michael J. Snowbell
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30607 , G06F17/30433 , G06F17/30457 , G06F17/30471 , G06F17/30595 , G06F21/6227 , Y10S707/955 , Y10S707/99933 , Y10S707/99934
摘要： In a database system that supports object name overloading, database query statements are compiled and cached as data structures so that object level privileges are correctly resolved. Database query statements stored in the cached data structures are utilized when appropriate and a new compilation is performed when an incorrect resolution would result. The data structures are stored in a predefined order to ensure that a deterministic search of the cache is efficiently performed.
摘要翻译：在支持对象名称重载的数据库系统中，将数据库查询语句编译和缓存为数据结构，以便正确解析对象级特权。存储在缓存的数据结构中的数据库查询语句在适当时被使用，当导致不正确的解析时执行新的编译。以预定义的顺序存储数据结构，以确保有效执行高速缓存的确定性搜索。

14. 发明授权

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）由数据库服务器上的逻辑代理处理该请求，其中逻辑代理与事务相关联，其中请求被维护在逻辑代理中的第二多个逻辑连接之一中。以这种方式，连接在逻辑上彼此分离，具有最小的存储影响。也可以避免冲突和不可预知的行为。

15. 发明授权

US06735605B2 Method and apparatus for synchronizing not-logged application temporary tables in a multi-node relational database management system 失效
标题翻译：用于在多节点关系数据库管理系统中同步未记录的应用程序临时表的方法和装置
公开(公告)号：US06735605B2
公开(公告)日：2004-05-11
申请号：US09796843
申请日：2001-02-28
申请人： Paul M. Bird , Yuk Kuen Chan , Jesse Lee , Hebert W. Pereyra , Yeung-Kuen See , Michael J. Snowbell , Catharina K. Wong
发明人： Paul M. Bird , Yuk Kuen Chan , Jesse Lee , Hebert W. Pereyra , Yeung-Kuen See , Michael J. Snowbell , Catharina K. Wong
IPC分类号： G06F1730
CPC分类号： G06F17/30371 , Y10S707/99943 , Y10S707/99956
摘要： A multi-node relational database management system is provided that can be embodied in software for managing a database having declared temporary tables associated with respective software application programs. The system comprises a plurality of nodes. The nodes include a catalog node for maintaining a list of identifiers for declared temporary tables associated with any application; a coordinator node for an application; at least one subordinate node for the application, the subordinate node having at least one partition of the declared temporary tables of the application; and a declared temporary table manager for causing the coordinator node to maintain for the application a list of declared temporary tables.
摘要翻译：提供了一种多节点关系数据库管理系统，其可以用于管理具有与各个软件应用程序相关联的声明临时表的数据库的软件。该系统包括多个节点。节点包括用于维护与任何应用相关联的声明临时表的标识符列表的目录节点; 用于应用程序的协调器节点; 用于所述应用的至少一个下级节点，所述下级节点具有所述申请的已声明临时表的至少一个分区; 以及声明的临时表管理器，用于使协调器节点为应用程序维护已声明的临时表的列表。

16. 发明授权

US07370049B2 Detection and prevention of writing conflicts within nested query statements 有权
标题翻译：检测和防止在嵌套查询语句中写入冲突
公开(公告)号：US07370049B2
公开(公告)日：2008-05-06
申请号：US10413637
申请日：2003-04-14
申请人： Douglas J. Doole , Paul M. Bird
发明人： Douglas J. Doole , Paul M. Bird
IPC分类号： G06F17/30
CPC分类号： G06F17/30359 , Y10S707/99932 , Y10S707/99933 , Y10S707/99938
摘要： Conflict checking for writing operations in an SQL database system is carried out for nested statements invoked by a parent statement. Each statement has an associated table access data structure defined at compile-time indicating the tables in the database that the statement accesses and the mode of access. At execution-time the table access data structure for each nested statement is accessed and the information is compared with a list of tables maintained for the parent statement to determine if there is a read/write or write/write conflict possible if the nested statement is executed. Where there is no conflict detected, the information from the table access data structure is copied to the list of tables.
摘要翻译：对于由父语句调用的嵌套语句，对SQL数据库系统中的写入操作进行冲突检查。每个语句都具有在编译时定义的关联表访问数据结构，指示数据库中该表所访问的表和访问模式。在执行时，访问每个嵌套语句的表访问数据结构，并将信息与为父语句维护的表的列表进行比较，以确定是否存在读/写或写/写冲突，如果嵌套语句为执行。在没有检测到冲突的情况下，来自表访问数据结构的信息被复制到表的列表中。

17. 发明授权

US07010517B2 Organization of SQL working memory in a transaction-bounded processing environment 有权
公开(公告)号：US07010517B2
公开(公告)日：2006-03-07
申请号：US10317260
申请日：2002-12-10
申请人： Paul M. Bird , Timothy J. Vincent
发明人： Paul M. Bird , Timothy J. Vincent
IPC分类号： G06F17/30
CPC分类号： G06F17/30286 , Y10S707/99932 , Y10S707/99942 , Y10S707/99945
摘要： Working memory in an SQL database system is organized in workspaces. Agent workspaces are defined into which working copies of SQL executable logic information are loaded. Application workspaces are also defined for the loading of working copies of SQL executable logic information. Reference copies of the SQL information are available in a global SQL cache. An application SQL context data structure is used as an entry point to access working copies of SQL information in the agent or application workspaces. An application workspace is associated with an application and is maintained until the last application in the set is not active. An agent workspace is associated with an agent in the database system and is maintained until the agent is no longer active.

18. 发明授权

US07007016B2 Support for concurrent active SQL statements having shared SQL context information 失效
公开(公告)号：US07007016B2
公开(公告)日：2006-02-28
申请号：US10317229
申请日：2002-12-11
申请人： Paul M. Bird , Timothy J. Vincent
发明人： Paul M. Bird , Timothy J. Vincent
IPC分类号： G06F17/30
CPC分类号： G06F17/30286 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99943
摘要： An SQL database management system for executing SQL requests from applications. The SQL database management system includes a hierarchical arrangement of data structures comprising packages, section entries, sibling control blocks and sections, for representing SQL context information and SQL statement information. Each package represents SQL context information on an application component-level basis. Each section entry is associated with a package and corresponds to a set of SQL actions. Each section entry is potentially associated with one or more sibling control blocks. Each sibling control block is associated with one section and represents context information relating to a unique SQL request. Each section includes logic for a specific SQL statement.

19. 发明授权

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.
摘要翻译：定义游标查询标识符以唯一标识支持嵌套例程调用的关系数据库系统中的游标。标识符包括与光标所在的嵌套级别相对应的游标嵌套级别值。标识符还包括对应于光标被打开的例程的调用标识符。标识符的第三部分是唯一的光标计数器。游标查询标识符的定义允许在相同关系数据库上下文的嵌套级别中打开游标，并且被唯一标识以供数据库系统和访问系统的应用程序引用。

20. 发明授权

US06321235B1 Global caching and sharing of SQL statements in a heterogeneous application environment 失效
标题翻译：在异构应用程序环境中全局缓存和共享SQL语句
公开(公告)号：US06321235B1
公开(公告)日：2001-11-20
申请号：US09162164
申请日：1998-09-29
申请人： Paul M. Bird
发明人： Paul M. Bird
IPC分类号： G06F1730
CPC分类号： G06F17/30433 , Y10S707/954 , Y10S707/955 , Y10S707/99932 , Y10S707/99934 , Y10S707/99954
摘要： A global cache for SQL sections and methods of accessing the cache. The global cache being at the database level and being accessible to all agents of all applications. The global cache having a static and a dynamic portion. The static portion containing section entries having both section information and section data. The dynamic portion having two sub-portions, a statement portion and a dependency portion. The dependency portion containing multiple SQL statements, multiple compilation environments for each SQL statement and multiple variations within each compilation environment. The dependency portion of the dynamic portion containing a plurality of lists of object types. Each object type having its own list, the list containing data on which variations are dependant on each object.
摘要翻译：用于SQL部分和访问缓存的方法的全局缓存。全局缓存位于数据库级别，可供所有应用程序的所有代理访问。全局缓存具有静态和动态部分。静态部分包含部分条目具有部分信息和部分数据。具有两个子部分的动态部分，语句部分和依赖部分。包含多个SQL语句的依赖部分，每个SQL语句的多个编译环境以及每个编译环境中的多个变体。动态部分的依赖部分包含多个对象类型列表。每个对象类型都有自己的列表，该列表包含数据，变化依赖于每个对象。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式