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

1. 发明授权

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

2. 发明授权

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.

3. 发明授权

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.

4. 发明授权

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

5. 发明授权

US06615214B1 Accommodation of data definition statements in the sharing of dynamic SQL statements 失效
标题翻译：数据定义语句在动态SQL语句的共享中的定位
公开(公告)号：US06615214B1
公开(公告)日：2003-09-02
申请号：US09614358
申请日：2000-07-12
申请人： Paul M. Bird , Yuk-kuen Chan , Michael J. Snowbell
发明人： Paul M. Bird , Yuk-kuen Chan , Michael J. Snowbell
IPC分类号： G06F1700
CPC分类号： G06F17/30433 , G06F8/433 , Y10S707/954 , Y10S707/99933
摘要： A relational database management system which determines the shareable status of an executable object (section) in an cache. The shareable status is defined for a section in a cache by the system maintaining an identification list which has reference to database entities which are affected by a statement in the current unit of work. When a statement is compiled, the compiler generates a list of dependencies, which list is compared with the identification list. If the statement data dependencies are on the identification list, the statement will be treated as non-shareable until the completion of the current unit of work.
摘要翻译：确定缓存中可执行对象（部分）的可共享状态的关系数据库管理系统。由系统维护一个标识列表的高速缓存中的一个部分定义了可共享状态，该标识列表参考受当前工作单元中的语句影响的数据库实体。当编译语句时，编译器生成依赖关系列表，该列表与标识列表进行比较。如果声明数据依赖关系在识别列表上，则声明将被视为不可共享，直到完成当前工作单元。

6. 发明授权

US08577906B2 Method for modifying a query by use of an external system for managing assignment of user and data classifications 有权
标题翻译：通过使用外部系统修改查询以管理用户和数据分类的分配的方法
公开(公告)号：US08577906B2
公开(公告)日：2013-11-05
申请号：US12951982
申请日：2010-11-22
申请人： Paul M. Bird , Walid Rjaibi
发明人： Paul M. Bird , Walid Rjaibi
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30448
摘要： Disclosed is a data processing-implemented method, a data processing system, and an article of manufacture for modifying a query during compilation of the query. The query includes a request for an element of data from a table in a database and parameters identifying the requested element. The data processing-implemented method includes determining available information from parameters for locating a classification of the requested element and a classification associated with the query, the requested data classification controlling access to the requested element according to the query associated classification, requesting a suggested action from an external system for obtaining a comparison of the requested data classification and the query associated classification based on the available information, receiving the suggested action from the external system responsive to the sent request, and incorporating the suggested action into the query, the suggested action effecting comparison of the requested data classification with the query associated classification.
摘要翻译：公开了一种数据处理实现的方法，数据处理系统和用于在查询的编译期间修改查询的制品。该查询包括对来自数据库中的表的数据元素的请求以及标识所请求元素的参数。数据处理实现的方法包括从用于定位所请求的元素的分类和与查询相关联的分类的参数确定可用信息，所请求的数据分类根据查询关联分类来控制对所请求的元素的访问，请求建议的动作用于基于所述可用信息获得所请求的数据分类和所述查询关联分类的比较的外部系统，响应于所发送的请求从所述外部系统接收所述建议的动作，并将所述建议的动作合并到所述查询中，所述建议的动作请求的数据分类与查询关联分类的比较。

7. 发明授权

US07433950B2 Method and mechanism to multiplex multiple application server requests over a single database connection 有权
标题翻译：通过单个数据库连接复用多个应用程序服务器请求的方法和机制
公开(公告)号：US07433950B2
公开(公告)日：2008-10-07
申请号：US10729636
申请日：2003-12-04
申请人： 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/173
CPC分类号： G06F17/3056 , G06F17/30348 , G06F17/30445 , Y10S707/99953
摘要： In a method 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.
摘要翻译：在通过单个数据库连接避免应用程序服务器请求的部分冲突的方法中，数据库服务器为应用程序内为相同处理级别打开的同一个游标的每个实例分配查询标识符，允许处理相同光标的多个实例平行而无分段碰撞。应用程序服务器为通过单个数据库连接发送的每个语句分配命令源标识符，以唯一标识语句的应用程序源。这适用于同一应用程序中由不同应用程序源发送的相同语句的倍数，对于包含多个应用程序源的单个语句，以及来自通过单个数据库连接复用的不同应用程序的多个语句。这些语句可以彼此分开处理，也可以彼此并行处理，而不会出现部分冲突。

8. 发明授权

US07007150B2 Memory balancing and optimization services 失效
公开(公告)号：US07007150B2
公开(公告)日：2006-02-28
申请号：US10401329
申请日：2003-03-27
申请人： Gary Valentin , Paul M. Bird , Matthew A Huras , Xun Xue
发明人： Gary Valentin , Paul M. Bird , Matthew A Huras , Xun Xue
IPC分类号： G06F12/00
CPC分类号： G06F9/5016
摘要： Memory balancing and optimization services (MBOS) control a size of a plurality of memory heaps, and a memory optimizer for allocating and de-allocating memory for a plurality of respective memory consumers. The MBOS may be instantiated within an application program such as a database management system providing services to memory consumers within the application. Alternatively, the MBOS may be instantiated within an operating system for providing services to memory consumers that are applications such as database management systems, e-commerce engines, operating systems, customer relationship management (CRM), enterprise resource planning (ERP), or supply chain management (SCM). Alternatively, an MBOS is instantiated within the operating system to provide services to applications and an MBOS is instantiated within each application to provide services to memory consumers within the application.

9. 发明授权

US07661125B2 System for providing and utilizing a network trusted context 失效
标题翻译：用于提供和利用网络可信上下文的系统
公开(公告)号：US07661125B2
公开(公告)日：2010-02-09
申请号：US12166839
申请日：2008-07-02
申请人： Paul M. Bird , Gayathiri R. Chandran , Curt L. Cotner , Adrian B. Lobo , James W. Pickel , Walid Rjaibi
发明人： Paul M. Bird , Gayathiri R. Chandran , Curt L. Cotner , Adrian B. Lobo , James W. Pickel , Walid Rjaibi
IPC分类号： G06F21/00 , H04L9/00
CPC分类号： H04L63/08 , H04L63/102
摘要： A system for establishing a connection between a data server and a middleware server is disclosed. The system includes defining a plurality of trust attributes corresponding to a trusted context between the middleware server and the data server and validating the plurality of trust attributes against a plurality of attributes corresponding to the middleware server. The plurality of attributes provided in a connection request. The system also includes establishing the trusted context based on the validating the plurality of trust attributes.
摘要翻译：公开了一种用于在数据服务器和中间件服务器之间建立连接的系统。该系统包括定义与中间件服务器和数据服务器之间的可信上下文相对应的多个信任属性，并针对对应于中间件服务器的多个属性来验证多个信任属性。在连接请求中提供的多个属性。该系统还包括基于验证多个信任属性来建立可信赖的上下文。

10. 发明申请

US20080270609A1 COMPUTER-READABLE MEDIUM TO MULTIPLEX MULTIPLE APPLICATION SERVER REQUESTS OVER A SINGLE DATABASE CONNECTION 失效
标题翻译：计算机可读介质到多个多应用程序服务器要求单个数据库连接
公开(公告)号：US20080270609A1
公开(公告)日：2008-10-30
申请号：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/173
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.
摘要翻译：在用于通过单个数据库连接避免应用程序服务器请求的部分冲突的系统中，数据库服务器为应用程序内为相同处理级别打开的同一个游标的每个实例分配查询标识符，允许处理相同光标的多个实例平行而无分段碰撞。应用程序服务器为通过单个数据库连接发送的每个语句分配命令源标识符，以唯一标识语句的应用程序源。这适用于同一应用程序中由不同应用程序源发送的相同语句的倍数，对于包含多个应用程序源的单个语句，以及来自通过单个数据库连接复用的不同应用程序的多个语句。这些语句可以彼此分开处理，也可以彼此并行处理，而不会出现部分冲突。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式