公开(公告)号：US20080162523A1

公开(公告)日：2008-07-03

申请号：US11648332

申请日：2006-12-29

申请人： Timothy Brent Kraus ,  John Mark Morris

发明人： Timothy Brent Kraus ,  John Mark Morris

IPC分类号： G06F17/30

CPC分类号： G06F17/30339

摘要： Techniques for selective compression of database information are presented. Selective first portions of a field associated with a database table are identified along with metadata associated with the database table. The first portions and the metadata are then compressed by selecting one or more compression algorithms in response to compression capabilities associated with the algorithms.

摘要翻译： 介绍了选择性压缩数据库信息的技术。 与数据库表相关联的字段的选择性第一部分与数据库表相关联的元数据一起被识别。 然后通过响应于与算法相关联的压缩能力选择一个或多个压缩算法来压缩第一部分和元数据。

公开(公告)号：US20080162419A1

公开(公告)日：2008-07-03

申请号：US11716892

申请日：2007-03-12

申请人： Douglas P. Brown ,  Scott E. Gnau ,  John Mark Morris

发明人： Douglas P. Brown ,  Scott E. Gnau ,  John Mark Morris

IPC分类号： G06F17/30

CPC分类号： G06F17/30289 ,  G06F17/30067 ,  G06F17/30129 ,  G06F17/30979 ,  Y10S707/99932

摘要： A system and method for managing a domain comprised of a plurality of database systems, wherein each of the database systems performs database queries to retrieve data stored by the database systems. There are one or more virtual regulators for managing the domain and one or more closed-loop system management (CLSM) regulators for managing each of the database systems in the domain. Both the virtual regulators and CLSM regulators perform parallel virtual optimization of the database queries performed by the database systems.

摘要翻译： 一种用于管理由多个数据库系统组成的域的系统和方法，其中每个数据库系统执行数据库查询以检索由数据库系统存储的数据。 有一个或多个用于管理域的虚拟监管器和一个或多个闭环系统管理（CLSM）监管器用于管理域中的每个数据库系统。 虚拟调节器和CLSM调节器均执行由数据库系统执行的数据库查询的并行虚拟优化。

公开(公告)号：US09766933B2

公开(公告)日：2017-09-19

申请号：US13309806

申请日：2011-12-02

申请人： John Mark Morris ,  P. Keith Muller ,  Douglas P. Brown

发明人： John Mark Morris ,  P. Keith Muller ,  Douglas P. Brown

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F17/30 ,  G06F9/50

CPC分类号： G06F9/5011 ,  G06F2209/504 ,  Y02D10/22

摘要： Computing capacity of a computing environment can be managed by controlling it associated processing capacity based on a target (or desired) capacity. In addition, fine-grained control over the processing capacity can be exercised. For example, a computing system can change the processing capacity (e.g., processing rate) of at least one processor operating based on a target capacity. The computing system may also be operable to change the processing capacity based on a measured processing capacity (e.g., a measured average of various processing rates of a processor taken over a period of time when a processor may have been operating at different processing rates over that period). By way of example, the processing rate of a processor can be switched between 1/8 and 2/8 of a maximum processing rate to achieve virtually any effective processing rates between them.

公开(公告)号：US08434075B1

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

申请号：US12423885

申请日：2009-04-15

申请人： Douglas P. Brown ,  John Mark Morris

发明人： Douglas P. Brown ,  John Mark Morris

IPC分类号： G06F9/45 ,  G06F9/44 ,  G06F17/30

CPC分类号： G06F17/30463

摘要： Execution of a query is optimized. A plurality of plans for executing the query on a multi-database system are analyzed. A first plan having a first step and a second step is selected. The first step of the first plan is executed. The plan selection is re-evaluated before executing the second step of the first plan. A second plan of the plurality of plans for executing the query is executed to produce a result. The result is stored.

摘要翻译： 对查询的执行进行了优化。 分析了用于在多数据库系统上执行查询的多个计划。 选择具有第一步骤和第二步骤的第一计划。 执行第一个计划的第一步。 在执行第一个计划的第二个步骤之前，重新评估计划选择。 执行用于执行查询的多个计划的第二计划以产生结果。 结果存储。

公开(公告)号：US20130086590A1

公开(公告)日：2013-04-04

申请号：US13250006

申请日：2011-09-30

申请人： John Mark Morris ,  Anita Richards ,  Douglas P. Brown

发明人： John Mark Morris ,  Anita Richards ,  Douglas P. Brown

IPC分类号： G06F9/46

CPC分类号： G06F9/5011 ,  G06F2209/504 ,  G06F2209/508 ,  Y02D10/22

摘要： Capacity of a computing environment that includes a database can be maintained at a target capacity by regulating the usage of one or more of the resources by one or more tasks or activities (e.g., database work). Moreover, the usage of the resource(s) can be regulated based on the extent of use of the resource(s) by one or more other activities not being regulated (e.g., non-database activities that cannot be regulated by a database system). In other words, a target capacity can be maintained by effectively adjusting the extent by which one or more tasks can access one more resources in consideration of the extent by which one or more of the resources are used by one or more other tasks or activities that are not being regulated with respect to their access of the resource(s).

摘要翻译： 包括数据库的计算环境的容量可以通过一个或多个任务或活动（例如，数据库工作）来调节一个或多个资源的使用来维持在目标容量。 此外，资源的使用可以基于一个或多个未受管制的其他活动（例如，不能被数据库系统管理的非数据库活动）的资源的使用程度来调节。 。 换句话说，考虑到一个或多个资源被一个或多个其他任务或活动使用的程度，有效调整一个或多个任务可以访问一个或多个资源的程度可以维持目标能力， 对资源的访问没有受到管制。

公开(公告)号：US08386444B2

公开(公告)日：2013-02-26

申请号：US11648332

申请日：2006-12-29

申请人： Timothy Brent Kraus ,  John Mark Morris

发明人： Timothy Brent Kraus ,  John Mark Morris

IPC分类号： G06F17/30

CPC分类号： G06F17/30339

摘要： Techniques for selective compression of database information are presented. Selective first portions of a field associated with a database table are identified along with metadata associated with the database table. The first portions and the metadata are then compressed by selecting one or more compression algorithms in response to compression capabilities associated with the algorithms.

摘要翻译： 介绍了选择性压缩数据库信息的技术。 与数据库表相关联的字段的选择性第一部分与数据库表相关联的元数据一起被识别。 然后通过响应于与算法相关联的压缩能力选择一个或多个压缩算法来压缩第一部分和元数据。

公开(公告)号：US08359333B2

公开(公告)日：2013-01-22

申请号：US11716889

申请日：2007-03-12

申请人： Douglas P. Brown ,  Anita Richards ,  John Mark Morris ,  Todd A. Walter

发明人： Douglas P. Brown ,  Anita Richards ,  John Mark Morris ,  Todd A. Walter

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30289 ,  G06F17/30067 ,  G06F17/30129 ,  G06F17/30979 ,  Y10S707/99932

摘要： A system for managing a plurality of systems, includes a domain comprised of a plurality of systems, wherein the systems are managed by one or more closed-loop system management (CLSM) regulators. A virtual regulator manages operational characteristics of the domain and the plurality of systems, by communicating with the CLSM regulators to monitor the systems' states, events and conditions within the domain and to adjust the systems' operational characteristics in response to the systems' states, events and conditions.

摘要翻译： 用于管理多个系统的系统包括由多个系统组成的域，其中所述系统由一个或多个闭环系统管理（CLSM）调节器管理。 虚拟调节器通过与CLSM监管者沟通来监控域内的状态，事件和状况以及响应于系统状态来调整系统的操作特性来管理域和多个系统的操作特性， 事件和条件。

公开(公告)号：US07730171B2

公开(公告)日：2010-06-01

申请号：US11745475

申请日：2007-05-08

申请人： Peter Frazier ,  Paul Andersen ,  Gary Boggs ,  Criselda Carrillo ,  Donn Holtzman ,  John Mark Morris ,  P. Keith Muller ,  Paul Rubio

发明人： Peter Frazier ,  Paul Andersen ,  Gary Boggs ,  Criselda Carrillo ,  Donn Holtzman ,  John Mark Morris ,  P. Keith Muller ,  Paul Rubio

IPC分类号： G06F15/177 ,  G06F15/173

CPC分类号： G06F17/30289

摘要： The subject matter herein relates to database management systems and, more particularly, to decoupled logical and physical data storage within a database management system. Various embodiments provide systems, methods, and software that separate physical storage from logical storage of data. These embodiments include a mapping of logical storage to physical storage to allow data to be moved within the physical storage to increase database responsiveness.

摘要翻译： 本文的主题涉及数据库管理系统，更具体地，涉及数据库管理系统内的解耦逻辑和物理数据存储。 各种实施例提供将物理存储与数据的逻辑存储分开的系统，方法和软件。 这些实施例包括将逻辑存储器映射到物理存储器以允许在物理存储器内移动数据以增加数据库响应性。

公开(公告)号：US20080162418A1

公开(公告)日：2008-07-03

申请号：US11716890

申请日：2007-03-12

申请人： John Mark Morris ,  Anita Richards ,  Douglas P. Brown

发明人： John Mark Morris ,  Anita Richards ,  Douglas P. Brown

IPC分类号： G06F17/30

CPC分类号： G06F17/30289 ,  G06F17/30067 ,  G06F17/30129 ,  G06F17/30979 ,  Y10S707/99932

摘要： A system and method for managing database systems, wherein the database systems perform database queries to retrieve data stored by the database systems. One or more regulators are used for managing the database systems, wherein a database tuning agent function of the regulator uses statistics on physical and logical data access in order to perform automated block size management for database objects.

摘要翻译： 一种用于管理数据库系统的系统和方法，其中数据库系统执行数据库查询以检索由数据库系统存储的数据。 一个或多个调节器用于管理数据库系统，其中调节器的数据库调优代理功能使用关于物理和逻辑数据访问的统计信息，以便为数据库对象执行自动化块大小管理。

公开(公告)号：US20080162417A1

公开(公告)日：2008-07-03

申请号：US11716880

申请日：2007-03-12

申请人： John Mark Morris ,  Anita Richards ,  Douglas P. Brown

发明人： John Mark Morris ,  Anita Richards ,  Douglas P. Brown

IPC分类号： G06F17/30

CPC分类号： G06F17/30289 ,  G06F17/30067 ,  G06F17/30129 ,  G06F17/30979 ,  Y10S707/99932

摘要： A system and method for managing one or more database systems, wherein the database systems perform database queries to retrieve data stored by the database systems. One or more regulators are used for managing the database systems, wherein the regulators monitor workload priority influenced data temperature in order to allocate resources for the systems. The data temperature is a measure of physical accesses to logical data, and the workload priority is used to further define data temperature, in order to optimize data storage placement and data access decisions.

摘要翻译： 一种用于管理一个或多个数据库系统的系统和方法，其中数据库系统执行数据库查询以检索由数据库系统存储的数据。 一个或多个调节器用于管理数据库系统，其中监管者监视工作负载优先级影响的数据温度，以便为系统分配资源。 数据温度是物理访问逻辑数据的度量，并且工作负载优先级用于进一步定义数据温度，以便优化数据存储位置和数据访问决策。