公开(公告)号：US20110161742A1

公开(公告)日：2011-06-30

申请号：US12648434

申请日：2009-12-29

申请人： Paul M. Bird ,  David Kalmuk ,  Scott D. Walkty

发明人： Paul M. Bird ,  David Kalmuk ,  Scott D. Walkty

IPC分类号： G06F11/28 ,  G06F11/00

CPC分类号： G06F11/3466 ,  G06F11/0715 ,  G06F11/0757 ,  G06F2201/81 ,  G06F2201/865

摘要： A monitoring of a server system during an execution of a server system processing logic, includes: during collection and storage of operational metrics by a given thread in a thread-local memory, determining that a checkpoint within the server system processing logic is reached; determining whether a threshold number of checkpoints have been encountered by the given thread; in response to the threshold number of checkpoints having been encountered, determining whether a threshold time interval since a last rollup of the collected operational metrics has been exceeded; and in response to the threshold time interval being exceeded, performing a rollup of the collected operational metrics from the thread-local memory to an accumulation point in a shared memory, where the accumulation point stores aggregated operational metrics from a plurality of threads.

摘要翻译： 在执行服务器系统处理逻辑期间对服务器系统的监视包括：在由线程本地存储器中的给定线程收集和存储操作指标期间，确定到达服务器系统处理逻辑内的检查点; 确定给定线程是否遇到阈值数量的检查点; 响应于已经遇到的检查点的阈值数量，确定是否已经超过了所收集的操作度量的最后一次累积的阈值时间间隔; 并且响应于所述阈值时间间隔被超过，从所述线程本地存储器到所述共享存储器中的累积点执行所收集的操作度量的汇总，其中所述累积点存储来自多个线程的聚合操作度量。

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

摘要翻译： 确定缓存中可执行对象（部分）的可共享状态的关系数据库管理系统。 由系统维护一个标识列表的高速缓存中的一个部分定义了可共享状态，该标识列表参考受当前工作单元中的语句影响的数据库实体。 当编译语句时，编译器生成依赖关系列表，该列表与标识列表进行比较。 如果声明数据依赖关系在识别列表上，则声明将被视为不可共享，直到完成当前工作单元。

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

摘要翻译： 公开了一种数据处理实现的方法，数据处理系统和用于在查询的编译期间修改查询的制品。 该查询包括对来自数据库中的表的数据元素的请求以及标识所请求元素的参数。 数据处理实现的方法包括从用于定位所请求的元素的分类和与查询相关联的分类的参数确定可用信息，所请求的数据分类根据查询关联分类来控制对所请求的元素的访问，请求建议的动作 用于基于所述可用信息获得所请求的数据分类和所述查询关联分类的比较的外部系统，响应于所发送的请求从所述外部系统接收所述建议的动作，并将所述建议的动作合并到所述查询中，所述建议的动作 请求的数据分类与查询关联分类的比较。

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

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

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

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

摘要翻译： 公开了一种用于在数据服务器和中间件服务器之间建立连接的系统。 该系统包括定义与中间件服务器和数据服务器之间的可信上下文相对应的多个信任属性，并针对对应于中间件服务器的多个属性来验证多个信任属性。 在连接请求中提供的多个属性。 该系统还包括基于验证多个信任属性来建立可信赖的上下文。

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

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

公开(公告)号：US06353833B1

公开(公告)日：2002-03-05

申请号：US09162165

申请日：1998-09-29

申请人： Paul M. Bird ,  Michael J. Snowbell

发明人： Paul M. Bird ,  Michael J. Snowbell

IPC分类号： G06F1730

CPC分类号： G06F17/30433 ,  G06F17/3048 ,  Y10S707/99938 ,  Y10S707/99952

摘要： A method and system for caching dynamic SQL statements and their sections at different nodes in a multiple node Relational Database Management System (RDBMS) while maintaining cache and application integrity across all nodes. Each node in the RDBMS having a global cache shared by all applications on that node. One of the nodes in the RDBMS being a catalogue node which controls access to a database. The catalogue node maintaining a list of participating nodes that have requested access to the database controlled by the catalogue node. The list of participating nodes being used to notify each participating node of any changes to the database that may affect the validity of a dynamic SQL statement stored in the global cache of the node.

摘要翻译： 一种用于在多节点关系数据库管理系统（RDBMS）中的不同节点处缓存动态SQL语句及其部分的方法和系统，同时在所有节点上保持缓存和应用程序完整性。 RDBMS中的每个节点都具有由该节点上的所有应用程序共享的全局高速缓存。 RDBMS中的一个节点是控制对数据库的访问的目录节点。 目录节点维护已请求访问由目录节点控制的数据库的参与节点的列表。 参与节点的列表用于通知每个参与节点对数据库的任何可能影响存储在节点的全局缓存中的动态SQL语句的有效性的任何更改。

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

摘要翻译： 公开了一种用于改善与关系数据库系统中的至少一个表中存储的信息的访问并发性的方法和系统。 该方法包括提供存储该至少一个表的一部分的数据高速缓存。 数据高速缓存包括多个高速缓存条目，其中每个高速缓存条目包括第一数据项，第二数据项和高速缓存条目状态。 所述方法还包括从所述至少一个表中检索并在高速缓存条目的第一数据项中存储用于用户的已提交信息的表示，以及从所述至少一个表中检索并在所述高速缓存条目的第二数据项中存储变化的表示 应用于提交的信息，但尚未在数据库系统中提交。

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

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