公开(公告)号：US20060155681A1

公开(公告)日：2006-07-13

申请号：US11033327

申请日：2005-01-11

申请人： Fei Chiang ,  Leslie Cranston ,  Sam Lightstone ,  Daniele Zilio

发明人： Fei Chiang ,  Leslie Cranston ,  Sam Lightstone ,  Daniele Zilio

IPC分类号： G06F7/00

CPC分类号： G06F17/30312 ,  Y10S707/99932 ,  Y10S707/99933

摘要： A method, apparatus, and computer instructions for selecting and recommending of clustering indexes are provided. Baseline run time cost estimates are calculated based on database designs. Workload benefit of a candidate clustering design is calculated and compared to the baseline costs. If the workload benefit outweighs the baseline costs, clustering dimension solutions originated from the record identifier (RID) based index are identified. A clustering design is selected based on the identified clustering dimension solutions and the total number of recommended clustering dimensions for a given table. Based on the number of dimensions observed, either a multidimensional clustering solution or a RID based clustering index is recommended.

公开(公告)号：US20070233991A1

公开(公告)日：2007-10-04

申请号：US11278134

申请日：2006-03-30

申请人： Yixin Diao ,  James Finnie ,  Christian Garcia-Arellano ,  Sam Lightstone ,  Lan Pham ,  Adam Storm ,  Maheswaran Surendra ,  Gary Valentin ,  Daniele Zilio

发明人： Yixin Diao ,  James Finnie ,  Christian Garcia-Arellano ,  Sam Lightstone ,  Lan Pham ,  Adam Storm ,  Maheswaran Surendra ,  Gary Valentin ,  Daniele Zilio

IPC分类号： G06F12/00

CPC分类号： G06F9/5016

摘要： Methods and systems are provided for tuning memory allocated among a plurality of applications in a data processing system. In one implementation, the method includes generating memory benefit data for the plurality of applications, comparing the generated memory benefit data associated with each of the plurality of applications, and dynamically reallocating memory from one or more of the plurality of applications to one or more other of the plurality of applications based on the comparison. A method and system is also provided for tuning memory allocated among a plurality of individual memory consumers for a given application.

摘要翻译： 提供了用于调整在数据处理系统中的多个应用程序之间分配的存储器的方法和系统。 在一个实现中，该方法包括为多个应用产生存储器利益数据，比较与多个应用中的每一个相关联的生成的存储器利益数据，以及将存储器从多个应用中的一个或多个动态地重新分配给一个或多个其他应用 的多个应用程序。 还提供了一种方法和系统，用于调整针对给定应用的多个单独存储器消费者之间分配的存储器。

公开(公告)号：US20070220058A1

公开(公告)日：2007-09-20

申请号：US11374812

申请日：2006-03-14

申请人： Mokhtar Kandil ,  Alberto Lerner ,  Volker Markl ,  Daniele Zilio ,  Calisto Zuzarte

发明人： Mokhtar Kandil ,  Alberto Lerner ,  Volker Markl ,  Daniele Zilio ,  Calisto Zuzarte

IPC分类号： G06F17/30

CPC分类号： G06F17/30536 ,  G06F17/30306

摘要： A method, computer program product, and system for managing statistical views in a database system are provided. The method, computer program product, and system provide for collecting data relating to optimization and execution of a workload in the database system and automatically generating a set of one or more statistical views based on the collected optimization and execution data.

摘要翻译： 提供了一种用于管理数据库系统中的统计视图的方法，计算机程序产品和系统。 所述方法，计算机程序产品和系统提供用于收集与数据库系统中的工作负载的优化和执行有关的数据，并且基于所收集的优化和执行数据自动生成一组或多个统计视图。

公开(公告)号：US20070174292A1

公开(公告)日：2007-07-26

申请号：US11340203

申请日：2006-01-26

申请人： Wen-Syan Li ,  Daniele Zilio

发明人： Wen-Syan Li ,  Daniele Zilio

IPC分类号： G06F17/30

CPC分类号： G06F17/30457 ,  Y10S707/99932

摘要： A system and method of evaluating queries in distributed databases with MQTs comprises deriving MQTs; replicating the derived MQTs from a local server to at least one remote server; and distributing data and replicated derived MQTs to a plurality of other remote servers, wherein the distributing increases overall query execution efficiency. The databases may comprise heterogeneous databases. The query execution efficiency comprises observed response time at a frontend database and associated costs comprising computational central processing unit costs, input/output costs, and network communication costs. All of the associated costs comprise statistically estimated costs. The method further comprises running a MQT advisor at a frontend database, and considering the costs of at least one MQT placed at the frontend database. The method further comprises running a MQT advisor at a non-frontend database. Additionally, the increased overall query execution efficiency may consider all dependencies of all involved database instances and associated costs.

摘要翻译： 使用MQT对分布式数据库中的查询进行评估的系统和方法包括导出MQT; 将派生的MQT从本地服务器复制到至少一个远程服务器; 以及将数据和复制的导出MQT分发到多个其他远程服务器，其中所述分发增加了整体查询执行效率。 数据库可以包括异构数据库。 查询执行效率包括在前端数据库处的观察到的响应时间和包括计算中央处理单元成本，输入/输出成本和网络通信成本的相关费用。 所有相关成本包括统计估计成本。 该方法还包括在前端数据库上运行MQT顾问，并考虑放置在前端数据库中的至少一个MQT的成本。 该方法还包括在非前端数据库上运行MQT顾问。 此外，增加的整体查询执行效率可以考虑所有相关数据库实例和相关成本的所有依赖关系。

公开(公告)号：US20070233439A1

公开(公告)日：2007-10-04

申请号：US11278124

申请日：2006-03-30

申请人： MATTHEW CARROLL ,  Christian Garcia-Arellano ,  Sam Lightstone ,  Bruce Lindsay ,  Adam Storm ,  Daniele Zilio ,  Adriana Zubiri

发明人： MATTHEW CARROLL ,  Christian Garcia-Arellano ,  Sam Lightstone ,  Bruce Lindsay ,  Adam Storm ,  Daniele Zilio ,  Adriana Zubiri

IPC分类号： G06G7/48

CPC分类号： G06F17/5022

摘要： Methods and systems are provided for executing a simulation of an operation in a data processing system. In one implementation, the method includes executing an operation under a first set of conditions, determining a characteristic associated with the execution of the operation under the first set of conditions, and executing a simulation of the operation under a second set of conditions different from the first set of conditions. The simulation of the operation is constrained by the determined characteristic. The method can further include determining a cost/benefit of executing the operation under a set of conditions different from the first set of conditions based at least in part on the simulation.

摘要翻译： 提供了用于执行数据处理系统中的操作的模拟的方法和系统。 在一个实现中，该方法包括在第一组条件下执行操作，确定与第一组条件下的操作的执行相关联的特性，以及在与第二组条件不同的第二组条件下执行操作的模拟 第一套条件。 操作的模拟受到确定的特性的约束。 该方法还可以包括至少部分地基于模拟来确定在与第一组条件不同的一组条件下执行操作的成本/益处。

公开(公告)号：US20060184338A1

公开(公告)日：2006-08-17

申请号：US11060009

申请日：2005-02-17

申请人： Sam Lightstone ,  Guy Lohman ,  William O'Connell ,  Jun Rao ,  Robin Van Boeschoten ,  Daniele Zilio ,  Calisto Zuzarte

发明人： Sam Lightstone ,  Guy Lohman ,  William O'Connell ,  Jun Rao ,  Robin Van Boeschoten ,  Daniele Zilio ,  Calisto Zuzarte

IPC分类号： G21C17/00

CPC分类号： G06F11/3447 ,  G06F2201/80 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99942

摘要： Disclosed is a method for directing a data processing system, the data processing system and an article of manufacture. The data processing system has memory for storing a database. The method directs the data processing system to configuring the database based on a database workload having a performance metric. The method includes selecting a plurality of database characteristics based upon the database workload, each of the database characteristics having an associated estimated performance metric for the database workload, selecting a set of database characteristics from the plurality of database characteristics for which the associated estimated performance metric is lower than the database workload performance metric, and configuring the database using the selected set of database characteristics.

摘要翻译： 公开了一种用于指导数据处理系统，数据处理系统和制品的方法。 数据处理系统具有用于存储数据库的存储器。 该方法指导数据处理系统基于具有性能度量的数据库工作负载配置数据库。 该方法包括基于数据库工作负载来选择多个数据库特征，每个数据库特征具有数据库工作负载的相关联的估计性能度量，从多个数据库特征中选择一组数据库特征，对于该数据库特征，相关联的估计性能度量 低于数据库工作负载性能指标，并使用所选数据库特征集来配置数据库。

公开(公告)号：US20050192978A1

公开(公告)日：2005-09-01

申请号：US10788583

申请日：2004-02-27

申请人： Sam Lightstone ,  Guy Lohman ,  Ivan Popivanov ,  Jun Rao ,  Adam Storm ,  Daniele Zilio

发明人： Sam Lightstone ,  Guy Lohman ,  Ivan Popivanov ,  Jun Rao ,  Adam Storm ,  Daniele Zilio

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

CPC分类号： G06F17/3046 ,  Y10S707/99934

摘要： The present invention provides a method, system and program for optimizing compression of a workload processed by a database management system. In an embodiment of the present invention a method of optimizing the compression of database workloads is provided. Initially, an estimate of a cost of execution for each query according to a defined metric such as execution time or memory consumption is determined. A sub-set of queries is then selected from the workload in order of the most costly to least costly relative to the defined metric for compression according to either a predetermined compression threshold percentage or a threshold percentage derived from an allotted workload execution time. Compression is then performed on the selected sub-set of queries (i.e. those that will benefit the most from the compression) to achieve a net beneficial trade-off between the cost of workload compression and the cost of workload execution.

摘要翻译： 本发明提供一种用于优化由数据库管理系统处理的工作负载的压缩的方法，系统和程序。 在本发明的实施例中，提供了优化数据库工作负载的压缩的方法。 首先，确定根据诸如执行时间或存储器消耗的定义的度量的每个查询的执行成本的估计。 然后根据预定的压缩阈值百分比或从分配的工作负载执行时间导出的阈值百分比，从工作负荷中选择相对于定义的压缩度量最贵的成本最低的成本的子集。 然后对所选择的查询子集（即将从压缩中获益最多的那些）执行压缩，以实现工作负载压缩成本与工作负载执行成本之间的净有益权衡。

公开(公告)号：US20060161517A1

公开(公告)日：2006-07-20

申请号：US11038513

申请日：2005-01-18

申请人： Bishwaranjan Bhattacharjee ,  Sam Lightstone ,  Timothy Malkemus ,  Sriram Padmanabhan ,  Adam Storm ,  Daniele Zilio

发明人： Bishwaranjan Bhattacharjee ,  Sam Lightstone ,  Timothy Malkemus ,  Sriram Padmanabhan ,  Adam Storm ,  Daniele Zilio

IPC分类号： G06F17/30

CPC分类号： G06F17/30592 ,  G06F17/30306 ,  Y10S707/99932 ,  Y10S707/99942 ,  Y10S707/99943

摘要： Disclosed is a data processing system implemented method, a data processing system and an article of manufacture for improving execution efficiency of a database workload to be executed against a database. The database includes database tables, and the database workload identifies at least one of the database tables. The data processing system includes an identification module for identifying candidate database tables being identifiable in the database workload, the identified candidate database tables being eligible for organization under a clustering schema, a selection module for selecting the identified candidate tables according to whether execution of the database workload is improved if the selected identified candidate table is organized according to the clustering scheme, and an organization module for organizing the clustering schema of the selected organized identified candidate tables prior to the database workload being execution against the database.