公开(公告)号：US07991796B2

公开(公告)日：2011-08-02

申请号：US12348818

申请日：2009-01-05

申请人： Curt Lee Cotner ,  Margaret A. Dong

发明人： Curt Lee Cotner ,  Margaret A. Dong

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  Y10S707/99931

摘要： Provided are a system and program for accessing data in a distributed database environment. A client program receives multiple requests for data from a database object satisfying specified search predicates from an application program. Each request includes a request for at least one row from the table. The client program transfers a database command and a rowset parameter indicating a maximum number of rows to return to a server program over a network if the requested row is not maintained by the client program. A data block is generated with the server program including rows from the database object satisfying the search predicates in response to the database command. The rows included in the data block do not exceed the rowset parameter. The server program transfers the data block to the client program. In turn, the client program returns at least one requested row from the received data block in response to one request for the at least one row of data from the application program.

摘要翻译： 提供了一种用于在分布式数据库环境中访问数据的系统和程序。 客户程序从满足来自应用程序的指定搜索谓词的数据库对象接收对数据的多个请求。 每个请求包括从表中至少一行的请求。 如果客户端程序没有维护所请求的行，则客户机程序传送数据库命令和行集参数，指示最大行数返回到网络上的服务器程序。 生成数据块，服务器程序包括响应数据库命令满足搜索谓词的数据库对象的行。 包含在数据块中的行不超过行集参数。 服务器程序将数据块传输到客户端程序。 反过来，响应于来自应用程序的至少一行数据的一个请求，客户端程序从接收的数据块返回至少一个所请求的行。

公开(公告)号：US07487159B2

公开(公告)日：2009-02-03

申请号：US11146516

申请日：2005-06-06

申请人： Curt Lee Cotner ,  Margaret A. Dong

发明人： Curt Lee Cotner ,  Margaret A. Dong

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  Y10S707/99931

摘要： Provided is a method for accessing data in a distributed database environment. A client program receives multiple requests for data from a database object satisfying specified search predicates from an application program. Each request includes a request for at least one row from the table. The client program transfers a database command and a rowset parameter indicating a maximum number of rows to return to a server program over a network if the requested row is not maintained by the client program. A data block is generated with the server program including rows from the database object satisfying the search predicates in response to the database command. The rows included in the data block do not exceed the rowset parameter. The server program transfers the data block to the client program. In turn, the client program returns at least one requested row from the received data block in response to one request for the at least one row of data from the application program.

摘要翻译： 提供了一种在分布式数据库环境中访问数据的方法。 客户程序从满足来自应用程序的指定搜索谓词的数据库对象接收对数据的多个请求。 每个请求包括从表中至少一行的请求。 如果客户端程序没有维护所请求的行，则客户机程序传送数据库命令和行集参数，指示最大行数返回到网络上的服务器程序。 生成数据块，服务器程序包括响应数据库命令满足搜索谓词的数据库对象的行。 包含在数据块中的行不超过行集参数。 服务器程序将数据块传输到客户端程序。 反过来，响应于来自应用程序的至少一行数据的一个请求，客户端程序从接收的数据块返回至少一个所请求的行。

公开(公告)号：US06990477B2

公开(公告)日：2006-01-24

申请号：US09819476

申请日：2001-03-28

申请人： Curt Lee Cotner ,  Margaret A. Dong

发明人： Curt Lee Cotner ,  Margaret A. Dong

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  Y10S707/99931

摘要： Provided is a method, system, and program for accessing data in a distributed database environment. A client program receives multiple requests for data from a database object satisfying specified search predicates from an application program. Each request includes a request for at least one row from the table. The client program transfers a database command and a rowset parameter indicating a maximum number of rows to return to a server program over a network if the requested row is not maintained by the client program. A data block is generated with the server program including rows from the database object satisfying the search predicates in response to the database command. The rows included in the data block do not exceed the rowset parameter. The server program transfers the data block to the client program. In turn, the client program returns at least one requested row from the received data block in response to one request for the at least one row of data from the application program.

公开(公告)号：US20090112886A1

公开(公告)日：2009-04-30

申请号：US12348818

申请日：2009-01-05

申请人： Curt Lee Cotner ,  Margaret A. Dong

发明人： Curt Lee Cotner ,  Margaret A. Dong

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  Y10S707/99931

摘要： Provided are a system and program for accessing data in a distributed database environment. A client program receives multiple requests for data from a database object satisfying specified search predicates from an application program. Each request includes a request for at least one row from the table. The client program transfers a database command and a rowset parameter indicating a maximum number of rows to return to a server program over a network if the requested row is not maintained by the client program. A data block is generated with the server program including rows from the database object satisfying the search predicates in response to the database command. The rows included in the data block do not exceed the rowset parameter. The server program transfers the data block to the client program. In turn, the client program returns at least one requested row from the received data block in response to one request for the at least one row of data from the application program.

摘要翻译： 提供了一种用于在分布式数据库环境中访问数据的系统和程序。 客户程序从满足来自应用程序的指定搜索谓词的数据库对象接收对数据的多个请求。 每个请求包括从表中至少一行的请求。 如果客户端程序没有维护所请求的行，则客户机程序传送数据库命令和行集参数，指示最大行数返回到网络上的服务器程序。 生成数据块，服务器程序包括响应数据库命令满足搜索谓词的数据库对象的行。 包含在数据块中的行不超过行集参数。 服务器程序将数据块传输到客户端程序。 反过来，响应于来自应用程序的至少一行数据的一个请求，客户端程序从接收的数据块返回至少一个所请求的行。

公开(公告)号：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.

摘要翻译： 在用于通过单个数据库连接避免应用程序服务器请求的部分冲突的系统中，数据库服务器为应用程序内为相同处理级别打开的同一个游标的每个实例分配查询标识符，允许处理相同光标的多个实例 平行而无分段碰撞。 应用程序服务器为通过单个数据库连接发送的每个语句分配命令源标识符，以唯一标识语句的应用程序源。 这适用于同一应用程序中由不同应用程序源发送的相同语句的倍数，对于包含多个应用程序源的单个语句，以及来自通过单个数据库连接复用的不同应用程序的多个语句。 这些语句可以彼此分开处理，也可以彼此并行处理，而不会出现部分冲突。

公开(公告)号：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.

摘要翻译： 在通过单个数据库连接避免应用程序服务器请求的部分冲突的方法中，数据库服务器为应用程序内为相同处理级别打开的同一个游标的每个实例分配查询标识符，允许处理相同光标的多个实例 平行而无分段碰撞。 应用程序服务器为通过单个数据库连接发送的每个语句分配命令源标识符，以唯一标识语句的应用程序源。 这适用于同一应用程序中由不同应用程序源发送的相同语句的倍数，对于包含多个应用程序源的单个语句，以及来自通过单个数据库连接复用的不同应用程序的多个语句。 这些语句可以彼此分开处理，也可以彼此并行处理，而不会出现部分冲突。

公开(公告)号：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.

摘要翻译： 在用于通过单个数据库连接避免应用程序服务器请求的部分冲突的系统中，数据库服务器为应用程序内为相同处理级别打开的同一个游标的每个实例分配查询标识符，允许处理相同光标的多个实例 平行而无分段碰撞。 应用程序服务器为通过单个数据库连接发送的每个语句分配命令源标识符，以唯一标识语句的应用程序源。 这适用于同一应用程序中由不同应用程序源发送的相同语句的倍数，对于包含多个应用程序源的单个语句，以及来自通过单个数据库连接复用的不同应用程序的多个语句。 这些语句可以彼此分开处理，也可以彼此并行处理，而不会出现部分冲突。

公开(公告)号：US5093912A

公开(公告)日：1992-03-03

申请号：US371563

申请日：1989-06-26

申请人： Margaret A. Dong ,  Richard K. Treiber

发明人： Margaret A. Dong ,  Richard K. Treiber

IPC分类号： G06F12/02 ,  G06F9/46 ,  G06F9/50

CPC分类号： G06F9/5061 ,  G06F2209/5011

摘要： A method for expanding and contracting a resource pool dynamically, i.e. in response to demand for the resources, is disclosed. Resources are allocated for use from a single master pool 22. The overall pool of available resources is expanded by creating an extension pool and adding its resources to the master pool. The master pool can theoretically be expanded to the limits of the number of resources available in the system.To contract the pool dynamically, first one of the extension pools is selected to be freed (FREE.sub.-- POOL 66). Those resources owned by the freed pool but still in the master pool (i.e., not in use) are moved to the extension pool, preventing their reuse. Resources in use which are owned by the freed pool are labeled by changing their home address 52 so that they will be returned to the extension pool instead of to the master pool. Once all such resources have been returned to the freed extension pool it is deleted, thereby contracting the overall pool of resources.Pseudocode implementations of the procedures for manipulating storage buffers and buffer pools are included.