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

11. 发明授权

US09177023B2 Evaluation of database query plan robustness landmarks using operator maps or query maps 有权
标题翻译：使用运营商地图或查询地图评估数据库查询计划的鲁棒性地标
公开(公告)号：US09177023B2
公开(公告)日：2015-11-03
申请号：US12364063
申请日：2009-02-02
申请人： Goetz Graefe , Harumi Kuno , Janet L. Wiener
发明人： Goetz Graefe , Harumi Kuno , Janet L. Wiener
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： Computer-implemented systems and associated operating methods create and use an operator map to identify and evaluate database query plan robustness landmarks. The computer-implemented system comprises logic that creates a map evaluating performance of an implementation of a database engine operator during execution under actual operating conditions. The logic measures and maps performance for a selected range of runtime conditions including resource availability and data characteristics.
摘要翻译：计算机实现的系统和相关的操作方法创建和使用操作员图来识别和评估数据库查询计划的鲁棒性地标。计算机实现的系统包括在实际操作条件下创建在执行期间评估数据库引擎操作者的实现的性能的映射的逻辑。逻辑测量和映射所选范围的运行时条件的性能，包括资源可用性和数据特性。

12. 发明授权

US09176860B2 Database join optimized for flash storage 有权
标题翻译：针对闪存存储优化数据库连接
公开(公告)号：US09176860B2
公开(公告)日：2015-11-03
申请号：US12370551
申请日：2009-02-12
申请人： Janet L. Wiener , Stavros Harizopoulos , Mehul A. Shah , Goetz Graefe
发明人： Janet L. Wiener , Stavros Harizopoulos , Mehul A. Shah , Goetz Graefe
IPC分类号： G06F12/00 , G06F12/02 , G06F17/30
CPC分类号： G06F12/0246 , G06F17/30498 , G06F2212/7202
摘要： Computer-implemented systems and associated operating methods implement a fast join for databases which is adapted for usage with flash storage. A system comprises a processor that performs a join of two tables stored in a storage in pages processed in a column orientation wherein column values for all rows on a page are co-located in mini-pages within the page. The processor reduces input/output operations of the join by accessing only join columns and mini-pages containing join results.
摘要翻译：计算机实现的系统和相关的操作方法为适用于闪存存储的数据库实现快速连接。一种系统包括一个处理器，该处理器执行存储在一个列方向处理的页面中的存储在存储器中的两个表的连接，其中页面上所有行的列值共同位于该页内的小页面中。处理器通过仅访问连接列和包含连接结果的小页面来减少连接的输入/输出操作。

13. 发明授权

US09128984B2 Query plan analysis of alternative plans using robustness mapping 有权
标题翻译：使用鲁棒性映射的替代计划的查询计划分析
公开(公告)号：US09128984B2
公开(公告)日：2015-09-08
申请号：US12364107
申请日：2009-02-02
申请人： Janet L. Wiener , Goetz Graefe , Harumi Kuno
发明人： Janet L. Wiener , Goetz Graefe , Harumi Kuno
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30463 , G06F17/30474
摘要： Computer-implemented and associated operating methods evaluate robustness of a query plan by measuring performance with regard to a range of runtime conditions and producing a map of relative performance of the given query plan when compared with alternative plans for a range of conditions. The computer-implemented system comprises logic that evaluates the selected query plan in comparison to multiple alternative query plans in a predetermined range of runtime conditions that include data characteristics. The logic produces a set of performance measurements and analyzes the measured performance to map performance of the selected query plan in comparison to performance of one or more alternative query plans.
摘要翻译：计算机实现和相关联的操作方法通过针对一系列运行时条件测量性能，并且与一系列条件的替代计划相比较，产生给定查询计划的相对性能的映射来评估查询计划的鲁棒性。计算机实现的系统包括在包括数据特性的运行时间条件的预定范围内与多个备选查询计划相比较来评估所选择的查询计划的逻辑。与一个或多个替代查询计划的性能相比，该逻辑产生一组性能测量并分析测量的性能以映射所选查询计划的性能。

14. 发明授权

US08224811B2 Workload management using robustness mapping 有权
标题翻译：工作量管理使用鲁棒性映射
公开(公告)号：US08224811B2
公开(公告)日：2012-07-17
申请号：US12364113
申请日：2009-02-02
申请人： Harumi Kuno , Umeshwar Dayal , Janet L. Wiener , Goetz Graefe
发明人： Harumi Kuno , Umeshwar Dayal , Janet L. Wiener , Goetz Graefe
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： Computer-implemented systems and associated operating methods use performance maps created by evaluating robustness of a database operator, query plan, or query to analyze health of a currently-executing query. The computer-implemented system comprises logic that receives one or more robustness maps of measured database system performance acquired during database execution in a predetermined range of runtime conditions. The logic analyzes state of a currently-executing query by locating the query's performance on the robustness maps.
摘要翻译：计算机实现的系统和相关的操作方法使用通过评估数据库运算符，查询计划或查询的鲁棒性来分析当前执行的查询的运行状况而创建的性能映射。计算机实现的系统包括在预定的运行时间条件范围内接收在数据库执行期间获取的测量数据库系统性能的一个或多个鲁棒性映射的逻辑。该逻辑通过将查询的性能定位在鲁棒性映射上来分析当前执行的查询的状态。

15. 发明申请

US20100235349A1 PROGRESS ANALYZER FOR DATABASE QUERIES 有权
标题翻译：用于数据库查询的进度分析器
公开(公告)号：US20100235349A1
公开(公告)日：2010-09-16
申请号：US12401503
申请日：2009-03-10
申请人： Harumi Kuno , Janet L. Wiener , Umeshwar Dayal , Stefan Krompass
发明人： Harumi Kuno , Janet L. Wiener , Umeshwar Dayal , Stefan Krompass
IPC分类号： G06F17/30
CPC分类号： G06F17/30306
摘要： A data processing system includes a query progress analyzer. The database processing system comprises a receiver that receives database queries including a target query directed to a database and a query analyzer. The query analyzer is coupled to the receiver and analyzes progress status of the target query based on comparison of measured target query resource usage to resource usage predicted from a query plan of the target query and measured system resource usage.
摘要翻译：数据处理系统包括查询进度分析器。数据库处理系统包括接收数据库查询的接收器，包括定向到数据库的目标查询和查询分析器。查询分析器耦合到接收器，并基于目标查询的查询计划和测量的系统资源使用情况，将测量的目标查询资源使用量与资源使用情况进行比较，分析目标查询的进度状态。

16. 发明申请

US20100198810A1 EVALUATION OF DATABASE QUERY PLAN ROBUSTNESS LANDMARKS USING OPERATOR MAPS OR QUERY MAPS 有权
标题翻译：使用操作员的MAPS或QUERY MAPS评估数据库查询计划的鲁棒性
公开(公告)号：US20100198810A1
公开(公告)日：2010-08-05
申请号：US12364063
申请日：2009-02-02
申请人： Goetz Graefe , Harumi Kuno , Janet L. Wiener
发明人： Goetz Graefe , Harumi Kuno , Janet L. Wiener
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： Computer-implemented systems and associated operating methods create and use an operator map to identify and evaluate database query plan robustness landmarks. The computer-implemented system comprises logic that creates a map evaluating performance of an implementation of a database engine operator during execution under actual operating conditions. The logic measures and maps performance for a selected range of runtime conditions including resource availability and data characteristics.
摘要翻译：计算机实现的系统和相关的操作方法创建和使用操作员图来识别和评估数据库查询计划的鲁棒性地标。计算机实现的系统包括在实际操作条件下创建在执行期间评估数据库引擎操作者的实现的性能的映射的逻辑。逻辑测量和映射所选范围的运行时条件的性能，包括资源可用性和数据特性。

17. 发明申请

US20100198806A1 EVALUATION OF SET OF REPRESENTATIVE QUERY PERFORMANCE USING ROBUSTNESS MAPPING 有权
标题翻译：使用鲁棒映射评估代表性查询性能
公开(公告)号：US20100198806A1
公开(公告)日：2010-08-05
申请号：US12364086
申请日：2009-02-02
申请人： Goetz Graefe , Murali M. Krishna , Harumi Kuno , Janet L. Wiener
发明人： Goetz Graefe , Murali M. Krishna , Harumi Kuno , Janet L. Wiener
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： Computer-implemented systems and associated operating methods use atomic query maps to identify and evaluate database query plan robustness landmarks. The computer-implemented system comprises logic that evaluates robustness of a selected atomic query by measuring performance of atomic query execution in a predetermined range of runtime conditions that include data characteristics. The logic produces a set of measurements that can be displayed as one or more performance maps and analyzes the measured performance to identify landmarks indicative of database atomic query performance degradation greater than a predetermined amount.
摘要翻译：计算机实现的系统和相关操作方法使用原子查询图来识别和评估数据库查询计划的鲁棒性地标。计算机实现的系统包括通过在包括数据特征的运行时条件的预定范围内测量原子查询执行的性能来评估所选原子查询的鲁棒性的逻辑。逻辑产生一组可以显示为一个或多个性能映射的测量值，并且分析测量的性能以识别指示大于预定量的数据库原子查询性能退化的地标。

18. 发明授权

US08973000B2 Determining multiprogramming levels 有权
标题翻译：确定多重程序级别
公开(公告)号：US08973000B2
公开(公告)日：2015-03-03
申请号：US12777401
申请日：2010-05-11
申请人： Harumi Kuno , Janet L. Wiener , Lyle H. Ramshaw , Umeshwar Dayal , William K. Wilkinson , Stefan Krompass
发明人： Harumi Kuno , Janet L. Wiener , Lyle H. Ramshaw , Umeshwar Dayal , William K. Wilkinson , Stefan Krompass
IPC分类号： G06F9/46 , G06F9/50
CPC分类号： G06F9/5083
摘要： A method of managing the execution of a workload of transactions of different transaction types on a computer system. Each transaction type may have a different resource requirement. The method may include intermittently, during execution of the workload, determining the performance of each transaction type. A determination may be made of whether if there is an overloaded transaction type in which performance is degraded with an increase in the number of transactions of the transaction type. If there is an overloaded transaction type, the number of transactions of at least one transaction type may be changed.
摘要翻译：一种在计算机系统上管理不同事务类型的事务的工作负载的执行的方法。每种交易类型可能具有不同的资源需求。该方法可以在执行工作负载期间间歇性地包括确定每个事务类型的性能。可以确定是否存在随着交易类型的交易数量的增加而性能下降的重载事务类型。如果存在重载的事务类型，则可能会更改至少一个事务类型的事务数。

19. 发明授权

US08402016B2 Fetching optimization in multi-way pipelined database joins 有权
标题翻译：在多路流水线数据库联接中获取优化
公开(公告)号：US08402016B2
公开(公告)日：2013-03-19
申请号：US12473065
申请日：2009-05-27
申请人： Dimitrios Tsirogiannis , Stavros Harizopoulos , Mehul A. Shah , Janet L. Wiener , Goetz Graefe
发明人： Dimitrios Tsirogiannis , Stavros Harizopoulos , Mehul A. Shah , Janet L. Wiener , Goetz Graefe
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30498
摘要： A method of performing a multi-way join of a plurality of database relations includes executing a plurality of pipelined two-way joins with the database relations. Each two-way join has two sequential phases. In the first phase, missing attributes of the input relations that are required to evaluate a joining criterion specific to said two-way join are fetched from a non-volatile memory device, and the input relations are joined according to the criterion. In the second phase, any additional missing attributes of the input relations are fetched from the non-volatile memory device as assigned by an optimization process executed prior to commencing the multi-way join.
摘要翻译：执行多个数据库关系的多路连接的方法包括执行具有数据库关系的多个流水线的双向连接。每个双向连接都有两个连续的阶段。在第一阶段，从非易失性存储器件取出评估特定于所述双向连接的连接标准所需的输入关系的缺失属性，并且根据该标准连接输入关系。在第二阶段中，通过在开始多路连接之前执行的优化处理所指定的非易失性存储器设备，从输入关系的任何附加的缺失属性获取。

20. 发明授权

US08364829B2 System and method for ascribing resource consumption to activity in a causal path of a node of a distributed computing system 有权
标题翻译：将资源消耗归因于分布式计算系统的节点的因果路径中的活动的系统和方法
公开(公告)号：US08364829B2
公开(公告)日：2013-01-29
申请号：US10950025
申请日：2004-09-24
申请人： Jeffrey C. Mogul , Janet L. Wiener , Marcos K. Aguilera , Keith I. Farkas , Parthasarathy Ranganathan
发明人： Jeffrey C. Mogul , Janet L. Wiener , Marcos K. Aguilera , Keith I. Farkas , Parthasarathy Ranganathan
IPC分类号： G06F15/16
CPC分类号： G06F9/5005
摘要： According to at least one embodiment, a method comprises identifying at least one causal path that includes a node of a distributed computing environment that is of interest. The method further comprises analyzing the identified at least one causal path to determine at least one time interval when the node is active in such causal path, and correlating consumption of a resource by the node to the node's activity in the at least one causal path.
摘要翻译：根据至少一个实施例，一种方法包括识别包括感兴趣的分布式计算环境的节点的至少一个因果路径。所述方法还包括分析所识别的至少一个因果路径以确定当所述节点在所述因果路径中处于活动状态时的至少一个时间间隔，以及将所述节点的资源的消耗与所述至少一个因果路径中的节点的活动相关联。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式