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

1. 发明申请

US20050192978A1 Method, system and program for optimizing compression of a workload processed by a database management system 有权
标题翻译：用于优化由数据库管理系统处理的工作负载的压缩的方法，系统和程序
公开(公告)号：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.
摘要翻译：本发明提供一种用于优化由数据库管理系统处理的工作负载的压缩的方法，系统和程序。在本发明的实施例中，提供了优化数据库工作负载的压缩的方法。首先，确定根据诸如执行时间或存储器消耗的定义的度量的每个查询的执行成本的估计。然后根据预定的压缩阈值百分比或从分配的工作负载执行时间导出的阈值百分比，从工作负荷中选择相对于定义的压缩度量最贵的成本最低的成本的子集。然后对所选择的查询子集（即将从压缩中获益最多的那些）执行压缩，以实现工作负载压缩成本与工作负载执行成本之间的净有益权衡。

2. 发明申请

US20060184338A1 Method, system and program for selection of database characteristics 有权
标题翻译：用于选择数据库特征的方法，系统和程序
公开(公告)号：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.
摘要翻译：公开了一种用于指导数据处理系统，数据处理系统和制品的方法。数据处理系统具有用于存储数据库的存储器。该方法指导数据处理系统基于具有性能度量的数据库工作负载配置数据库。该方法包括基于数据库工作负载来选择多个数据库特征，每个数据库特征具有数据库工作负载的相关联的估计性能度量，从多个数据库特征中选择一组数据库特征，对于该数据库特征，相关联的估计性能度量低于数据库工作负载性能指标，并使用所选数据库特征集来配置数据库。

3. 发明申请

US20070233991A1 METHOD AND APPARATUS FOR DISTRIBUTING MEMORY IN A DATA PROCESSING SYSTEM 有权
标题翻译：在数据处理系统中分配存储器的方法和装置
公开(公告)号：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.
摘要翻译：提供了用于调整在数据处理系统中的多个应用程序之间分配的存储器的方法和系统。在一个实现中，该方法包括为多个应用产生存储器利益数据，比较与多个应用中的每一个相关联的生成的存储器利益数据，以及将存储器从多个应用中的一个或多个动态地重新分配给一个或多个其他应用的多个应用程序。还提供了一种方法和系统，用于调整针对给定应用的多个单独存储器消费者之间分配的存储器。

4. 发明申请

US20070233439A1 METHOD AND APPARATUS FOR SIMULATING OPERATION IN A DATA PROCESSING SYSTEM 有权
标题翻译：用于模拟数据处理系统中的操作的方法和装置
公开(公告)号：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.
摘要翻译：提供了用于执行数据处理系统中的操作的模拟的方法和系统。在一个实现中，该方法包括在第一组条件下执行操作，确定与第一组条件下的操作的执行相关联的特性，以及在与第二组条件不同的第二组条件下执行操作的模拟第一套条件。操作的模拟受到确定的特性的约束。该方法还可以包括至少部分地基于模拟来确定在与第一组条件不同的一组条件下执行操作的成本/益处。

5. 发明申请

US20060161517A1 Method, system and article of manufacture for improving execution efficiency of a database workload 失效
公开(公告)号：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.

6. 发明申请

US20060155681A1 Method and apparatus for automatic recommendation and selection of clustering indexes 失效
公开(公告)号：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.

7. 发明申请

US20060112093A1 Method, system, and program for collecting statistics of data stored in a database 有权
标题翻译：用于收集数据库中存储的数据的统计信息的方法，系统和程序
公开(公告)号：US20060112093A1
公开(公告)日：2006-05-25
申请号：US10996197
申请日：2004-11-22
申请人： Sam Lightstone , Ivan Popivanov , Kevin Rose
发明人： Sam Lightstone , Ivan Popivanov , Kevin Rose
IPC分类号： G06F17/30
CPC分类号： G06F17/30315
摘要： The present invention relates to collecting statistics automatically for data in a database. There is provided a method for automated statistics collection comprising determining a likelihood that statistics for data have changed; and collecting statistics for data in response to the likelihood. Indicators of the likelihood that statistics have changed may be useful to trigger automated statistics collection. Tables having statistics that change significantly may be collected more often than statistics of tables that are stable. A preferred model is provided to facilitate the collection of statistics that are more relevant: a table is scheduled for collection in accordance with observed patterns of table activity; a table is considered for collection if it meets a threshold level of activity; and a table is sampled to predict whether the statistics to be collected have changed. When collecting statistics, throttling and lock contention can minimize impact on a database user's response experience.
摘要翻译：本发明涉及为数据库中的数据自动采集统计信息。提供了一种用于自动统计收集的方法，包括确定数据的统计数据已经改变的可能性; 并根据可能性收集数据的统计数据。统计变更可能性的指标可能有助于触发自动统计收集。具有显着变化的统计数据的表可能比稳定表的统计数据更频繁地收集。提供了一个优选模型，以便于收集更相关的统计数据：按照观察到的表格模式计划收集表格; 如果满足阈值水平的活动，则考虑表的收集; 并对表进行采样，以预测要收集的统计信息是否发生变化。收集统计信息时，限制和锁定争用可以最小化对数据库用户的响应体验的影响。

8. 发明申请

US20050278381A1 Method and apparatus for online sample interval determination 审中-公开
标题翻译：在线采样间隔确定的方法和装置
公开(公告)号：US20050278381A1
公开(公告)日：2005-12-15
申请号：US10853835
申请日：2004-05-26
申请人： Yixin Diao , Joseph Hellerstein , Sam Lightstone , Adam Storm , Maheswaran Surendra
发明人： Yixin Diao , Joseph Hellerstein , Sam Lightstone , Adam Storm , Maheswaran Surendra
IPC分类号： G06F12/00
CPC分类号： G06F11/3495 , G06F9/5016 , G06F9/5033 , G06F11/3419 , G06F11/3452 , G06F2201/87
摘要： In one embodiment, functional system elements are added to an autonomic manager to enable automatic online sample interval selection. In another embodiment, a method for determining the sample interval by continually characterizing the system workload behavior includes monitoring the system data and analyzing the degree to which the workload is stationary. This makes the online optimization method less sensitive to system noise and capable of being adapted to handle different workloads. The effectiveness of the autonomic optimizer is thereby improved, making it easier to manage a wide range of systems.
摘要翻译：在一个实施例中，将功能系统元件添加到自主管理器以启用自动在线采样间隔选择。在另一个实施例中，用于通过连续地表征系统工作负载行为来确定采样间隔的方法包括监视系统数据并分析工作负载静止的程度。这使得在线优化方法对系统噪声不太敏感，并且能够适应于处理不同的工作负载。从而改进了自主优化器的有效性，从而更容易地管理广泛的系统。

9. 发明申请

US20070233989A1 SYSTEMS AND METHODS FOR SELF-TUNING MEMORY 有权
标题翻译：自调谐存储器的系统与方法
公开(公告)号：US20070233989A1
公开(公告)日：2007-10-04
申请号：US11278130
申请日：2006-03-30
申请人： Christian Garcia-Arellano , Sam Lightstone , Adam Storm , Wojciech Kuczynski , Matthew Huras , Xun Xue , Matthew Carroll
发明人： Christian Garcia-Arellano , Sam Lightstone , Adam Storm , Wojciech Kuczynski , Matthew Huras , Xun Xue , Matthew Carroll
IPC分类号： G06F12/00
CPC分类号： G06F12/0646 , G06F12/0223
摘要： There are disclosed systems, computer program products, and methods for self-tuning memory. In an embodiment, a method for self-tuning memory comprises setting a tuning interval and a target range for free memory for a memory pool. If memory consumption falls outside of the set target range for free memory during a tuning interval, a new target size for the memory pool is set based on the target range for free memory. Memory allocation for the memory pool is increased or decreased for the next tuning interval, such that the new target size for the memory pool is reached. A decrement rate may be used to provide a controlled decrease of the memory pool over a plurality of tuning intervals if necessary, until the new target size for the memory pool is reached.
摘要翻译：已经公开了系统，计算机程序产品和用于自调整存储器的方法。在一个实施例中，一种用于自调整存储器的方法包括设置用于存储器池的空闲存储器的调谐间隔和目标范围。如果内存消耗在调整间隔期间超出了可用内存的设置目标范围，则基于可用内存的目标范围设置内存池的新目标大小。内存池的内存分配在下一个调整间隔内增加或减少，从而达到内存池的新目标大小。如果需要，减量率可以用于在多个调谐间隔中提供存储池的受控减少，直到达到存储器池的新目标大小。

10. 发明申请

US20050273643A1 Method, system and program for oscillation control of an internal process of a computer program 失效
标题翻译：用于计算机程序内部过程振荡控制的方法，系统和程序
公开(公告)号：US20050273643A1
公开(公告)日：2005-12-08
申请号：US10864208
申请日：2004-06-08
申请人： Matthew Carroll , Christian Garcia-Arellano , Sam Lightstone , Maheswaran Surendra , Adam Storm , Yixin Diao
发明人： Matthew Carroll , Christian Garcia-Arellano , Sam Lightstone , Maheswaran Surendra , Adam Storm , Yixin Diao
IPC分类号： G06F7/00 , G06F7/38 , G06F9/00 , G06F9/44 , G06F11/00 , G06F15/00 , G06F17/00
CPC分类号： G05B5/01 , Y10S707/99942
摘要： A method for reducing oscillations of an output value associated with a program to be operatively coupled to a data processing system. The program having an internal process configured to read an input value provided by the program, the input value adjusting a performance aspect of the internal process, the internal process configured to provide an output value reflecting changes in the internal process responsive to the input value, the output value readable by the program. The method including writing the output value to a queue stored in memory of the data processing system, selecting a portion of the queue, matching the selected portion of the queue with a predetermined pattern, selecting a type of adjustment to be made to the input value, the type of adjustment corresponding to the matched predetermined pattern, determining a new input value according to the selected type of adjustment, and providing the new value the internal process, the internal process providing a new output value having reduced oscillations responsive to the new input value.
摘要翻译：一种用于减少与可操作地耦合到数据处理系统的程序相关联的输出值的振荡的方法。所述程序具有被配置为读取由所述程序提供的输入值的内部处理，所述输入值调整所述内部处理的性能方面，所述内部处理被配置为响应于所述输入值提供反映所述内部处理中的变化的输出值，程序可读的输出值。该方法包括将输出值写入存储在数据处理系统的存储器中的队列，选择队列的一部分，与预定模式匹配队列的选定部分，选择要对输入值进行调整的类型，对应于匹配的预定图案的调整类型，根据所选择的调整类型确定新的输入值，以及提供新值内部处理，内部处理响应于新的输入提供具有减小的振荡的新的输出值值。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式