专利快速检索-快速检索全球专利，免费商用专利数据库-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. 发明申请

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

3. 发明申请

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

4. 发明申请

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.

5. 发明申请

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.
摘要翻译：在一个实施例中，将功能系统元件添加到自主管理器以启用自动在线采样间隔选择。在另一个实施例中，用于通过连续地表征系统工作负载行为来确定采样间隔的方法包括监视系统数据并分析工作负载静止的程度。这使得在线优化方法对系统噪声不太敏感，并且能够适应于处理不同的工作负载。从而改进了自主优化器的有效性，从而更容易地管理广泛的系统。

6. 发明申请

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.
摘要翻译：已经公开了系统，计算机程序产品和用于自调整存储器的方法。在一个实施例中，一种用于自调整存储器的方法包括设置用于存储器池的空闲存储器的调谐间隔和目标范围。如果内存消耗在调整间隔期间超出了可用内存的设置目标范围，则基于可用内存的目标范围设置内存池的新目标大小。内存池的内存分配在下一个调整间隔内增加或减少，从而达到内存池的新目标大小。如果需要，减量率可以用于在多个调谐间隔中提供存储池的受控减少，直到达到存储器池的新目标大小。

7. 发明申请

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.
摘要翻译：一种用于减少与可操作地耦合到数据处理系统的程序相关联的输出值的振荡的方法。所述程序具有被配置为读取由所述程序提供的输入值的内部处理，所述输入值调整所述内部处理的性能方面，所述内部处理被配置为响应于所述输入值提供反映所述内部处理中的变化的输出值，程序可读的输出值。该方法包括将输出值写入存储在数据处理系统的存储器中的队列，选择队列的一部分，与预定模式匹配队列的选定部分，选择要对输入值进行调整的类型，对应于匹配的预定图案的调整类型，根据所选择的调整类型确定新的输入值，以及提供新值内部处理，内部处理响应于新的输入提供具有减小的振荡的新的输出值值。

8. 发明申请

US20050268063A1 Systems and methods for providing constrained optimization using adaptive regulatory control 有权
标题翻译：使用自适应调节控制提供约束优化的系统和方法
公开(公告)号：US20050268063A1
公开(公告)日：2005-12-01
申请号：US10853845
申请日：2004-05-25
申请人： Yixin Diao , Christian Garcia-Arellano , Joseph Hellerstein , Sam Lightstone , Sujay Parekh , Adam Storm , Maheswaran Surendra
发明人： Yixin Diao , Christian Garcia-Arellano , Joseph Hellerstein , Sam Lightstone , Sujay Parekh , Adam Storm , Maheswaran Surendra
IPC分类号： G06F9/50 , G06F12/00
CPC分类号： G06F9/5083
摘要： Systems and methods are provided for optimizing the performance and/or allocation of constrained resources in a dynamic computing environment using adaptive regulatory control methods. For example, systems and methods for providing constrained optimization in a dynamic computing system implement model-based adaptive (self-tuning) regulatory control schemes that are designed to handle the system dynamics and which take into consideration control costs (such as the overheads of changing resource allocations and performance degradation due to transient load imbalances) to find an optimal solution. To facilitate practical application, a dual control architecture is disclosed which combines a heuristic fixed step control process that is implemented when there is no valid system model for model-based control. A system model is continually obtained and validated during run-time to adapt control parameters to variations in system dynamics.
摘要翻译：提供的系统和方法用于使用自适应调节控制方法来优化动态计算环境中约束资源的性能和/或分配。例如，用于在动态计算系统中提供约束优化的系统和方法实施基于模型的自适应（自调节）调节控制方案，其被设计为处理系统动态并考虑到控制成本（例如变化的开销资源分配和由于瞬态负载不平衡引起的性能下降），以找到最佳解决方案。为了便于实际应用，公开了一种双控制架构，其结合了当没有用于基于模型的控制的有效系统模型时实现的启发式固定步长控制过程。系统模型在运行期间不断获得和验证，以使控制参数适应系统动态变化。

9. 发明申请

US20070233990A1 SYSTEMS AND METHODS FOR DYNAMICALLY RESIZING MEMORY POOLS 失效
标题翻译：用于动态记忆池的系统和方法
公开(公告)号：US20070233990A1
公开(公告)日：2007-10-04
申请号：US11278133
申请日：2006-03-30
申请人： Wojciech Kuczynski , Adam Storm , Roger Zheng , Sarah Posner , Christian Garcia-Arellano , Sam Lightstone
发明人： Wojciech Kuczynski , Adam Storm , Roger Zheng , Sarah Posner , Christian Garcia-Arellano , Sam Lightstone
IPC分类号： G06F12/00
CPC分类号： G06F17/30312 , Y10S707/99942 , Y10S707/99953
摘要： There are disclosed systems, computer program products, and methods for dynamically resizing memory pools used by database management systems. In one aspect, if a decrease in allocation to the memory pool is required, at least one page grouping that may be freed from the memory pool is identified as a candidate based on its position in a list of page groupings. If the page grouping contains any used memory blocks, the used memory blocks may be copied from a candidate page grouping to another page grouping in the list in order to free the candidate page grouping. Once the candidate page grouping is free of used memory blocks, the candidate page grouping may be freed from the memory pool. As an example, this method may be used for dynamically resizing locklists or lock memory.
摘要翻译：公开了用于动态地调整由数据库管理系统使用的内存池的系统，计算机程序产品和方法。在一个方面，如果需要减少对存储器池的分配，则可以根据其在页面分组列表中的位置来将可以从存储器池中释放的至少一个页面分组识别为候选。如果页面分组包含任何使用的存储器块，则所使用的存储器块可以从候选页面分组复制到列表中的另一页面分组，以便释放候选页面分组。一旦候选页面分组没有使用的存储器块，候选页面分组可以从存储器池中释放出来。作为示例，该方法可以用于动态地调整锁定列表大小或锁定内存。

10. 发明申请

US20070233638A1 METHOD AND SYSTEM FOR PROVIDING COST MODEL DATA FOR TUNING OF QUERY CACHE MEMORY IN DATABASES 失效
标题翻译：提供成本模型数据的方法和系统，用于调查数据库中的高速缓存存储器
公开(公告)号：US20070233638A1
公开(公告)日：2007-10-04
申请号：US11278373
申请日：2006-03-31
申请人： Matthew Carroll , Christian Garcia-Arellano , Sam Lightstone , Michael Snowbell , Adam Storm
发明人： Matthew Carroll , Christian Garcia-Arellano , Sam Lightstone , Michael Snowbell , Adam Storm
IPC分类号： G06F17/30
CPC分类号： G06F17/30587 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99953
摘要： Providing cost model data for tuning query cache memory size in database systems. In one aspect, a query is received, and a query cache is checked to determine whether a stored query matches the received query. When a cache miss has occurred due to no stored queries matching the received query, the processing time saved by the avoidance of the cache miss and a cache size needed to avoid the cache miss are determined.
摘要翻译：提供用于在数据库系统中调优查询缓存内存大小的成本模型数据。在一个方面，接收到查询，并检查查询高速缓存以确定所存储的查询是否与接收到的查询匹配。当由于没有存储的查询匹配接收的查询而发生高速缓存未命中时，确定避免高速缓存未命中所节省的处理时间以及避免高速缓存未命中所需的高速缓存大小。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式