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

71. 发明授权

US08234292B2 System, method, and computer-readable medium for optimizing processing of queries featuring maximum or minimum equality conditions in a parallel processing system 有权
标题翻译：用于在并行处理系统中优化具有最大或最小相等条件的查询处理的系统，方法和计算机可读介质
公开(公告)号：US08234292B2
公开(公告)日：2012-07-31
申请号：US12332602
申请日：2008-12-11
申请人： Yu Xu , Olli Pekka Kostamaa
发明人： Yu Xu , Olli Pekka Kostamaa
IPC分类号： G06F17/30
CPC分类号： G06F17/30539 , G06F17/30418 , G06F17/30445
摘要： A system, method, and computer-readable medium for optimized processing of queries that feature maximum or minimum equality conditions are provided. A table on which the query is applied is scanned a single time. Rows of the table distributed to respective processing modules are scanned by the processing modules. Each processing module maintains identification of any rows distributed to the respective processing module that have attribute values that equal the maximum or minimum attribute value locally identified by the processing module. Subsequently, a global aggregation mechanism is invoked to compute the query result without requiring an additional rescan of the table. Further, the disclosed mechanisms may be extended to compute top N queries featuring maximum or minimum equality conditions.
摘要翻译：提供了一种用于优化处理具有最大或最小相等条件的查询的系统，方法和计算机可读介质。一次扫描查询应用的表。分配给各个处理模块的表的行由处理模块扫描。每个处理模块维护分配给相应处理模块的任何行的识别，其具有等于由处理模块本地标识的最大或最小属性值的属性值。随后，调用全局聚合机制来计算查询结果，而不需要对表进行额外的重新扫描。此外，所公开的机制可以被扩展到计算具有最大或最小相等条件的前N个查询。

72. 发明授权

US08219546B2 Multi-core scheduling for parallel queries 有权
标题翻译：并行查询的多核调度
公开(公告)号：US08219546B2
公开(公告)日：2012-07-10
申请号：US12758604
申请日：2010-04-12
申请人： Jianfeng Yan , Jian Xu , Wen-Syan Li
发明人： Jianfeng Yan , Jian Xu , Wen-Syan Li
IPC分类号： G06F17/30
CPC分类号： G06F9/505 , G06F17/30445
摘要： An operator manager may be configured to determine a number of available cores and to assign the cores among a plurality of operators of a query, the operators including a running set of operators through which a plurality of query paths exist. The operator manager may include a status monitor configured to determine the number of available cores and to determine the running set of operators, a critical path selector configured to determine a critical path of the query from among the query paths and the running set of operators, and a workload manager configured to assign a first core of the available cores to a running operator of the running set and of the critical path, and to thereafter receive a new critical path from the critical path selector and to assign a second core of the available cores to the running operator of the new critical path.
摘要翻译：操作员管理器可以被配置为确定多个可用核心并且在查询的多个运算符之间分配核心，所述运营商包括存在多个查询路径的运行的运行集合。运营商管理者可以包括配置为确定可用核心数量并且确定运行的运营商集合的状态监视器，关键路径选择器被配置为从查询路径和正在运行的运行集合中确定查询的关键路径，并且工作负载管理器被配置为将可用核心的第一核心分配给运行集合和关键路径的正在运行的运营商，并且此后从关键路径选择器接收新的关键路径并且分配可用的核心核心到新的关键路径的运行操作员。

73. 发明申请

US20120072413A1 SYSTEM AND METHOD FOR COMPARING DATABASE QUERY PLANS 有权
标题翻译：用于比较数据库查询计划的系统和方法
公开(公告)号：US20120072413A1
公开(公告)日：2012-03-22
申请号：US12887895
申请日：2010-09-22
申请人： Maria G. CASTELLANOS , Perla Ruiz
发明人： Maria G. CASTELLANOS , Perla Ruiz
IPC分类号： G06F17/30
CPC分类号： G06F17/30306 , G06F17/30445
摘要： A method and device may accept a first database query plan including a plurality of rows and a second database query plan including a plurality of rows, compare each row in the first database query plan with a corresponding row in the second database query plan, and based on each comparison, calculate a difference between the compared rows. Each difference may be recorded in an output file.
摘要翻译：方法和设备可以接受包括多行的第一数据库查询计划和包括多行的第二数据库查询计划，将第一数据库查询计划中的每一行与第二数据库查询计划中的对应行进行比较，并且基于在每个比较中，计算比较行之间的差异。每个差异可能会记录在输出文件中。

74. 发明申请

US20120011121A1 Data analysis using multiple systems 有权
标题翻译：使用多个系统的数据分析
公开(公告)号：US20120011121A1
公开(公告)日：2012-01-12
申请号：US13135407
申请日：2011-07-05
申请人： Wenchu Cen
发明人： Wenchu Cen
IPC分类号： G06F17/30
CPC分类号： G06F17/30115 , G06F17/30194 , G06F17/30445 , G06F17/30545
摘要： Data analysis is disclosed, including: receiving data to be analyzed, wherein the data includes one or more data identifiers (IDs) and one or more preset key-value pairs, wherein each preset key-value pair includes a preset key and a preset value; acquiring data to be analyzed based at least in part on the data IDs; segmenting the acquired data into one or more data elements; classifying the one or more data elements based at least in part on one preset key of the one or more preset key-value pairs; and analyzing the classified one or more data elements based at least in part on one preset value of the one or more preset key-value pairs.
摘要翻译：公开了数据分析，包括：接收要分析的数据，其中所述数据包括一个或多个数据标识符（ID）和一个或多个预设键值对，其中每个预设键值对包括预设键和预设值 ; 至少部分地基于数据ID获取要分析的数据; 将获取的数据分割成一个或多个数据元素; 至少部分地基于所述一个或多个预设键值对的一个预设键对所述一个或多个数据元素进行分类; 以及至少部分地基于一个或多个预设键值对的一个预设值分析所分类的一个或多个数据元素。

75. 发明申请

US20120005188A1 TECHNIQUES FOR RECOMMENDING PARALLEL EXECUTION OF SQL STATEMENTS 有权
标题翻译：推荐使用SQL语句的并行执行技术
公开(公告)号：US20120005188A1
公开(公告)日：2012-01-05
申请号：US12827926
申请日：2010-06-30
申请人： Hailing Yu , Peter Belknap , Thierry Cruanes , Benoit Dageville , Karl Dias , Khaled Yagoub
发明人： Hailing Yu , Peter Belknap , Thierry Cruanes , Benoit Dageville , Karl Dias , Khaled Yagoub
IPC分类号： G06F17/30
CPC分类号： G06F17/30445
摘要： Techniques for automatically recommending parallel execution of a SQL statement. In one set of embodiments, a first determination can be made regarding whether a SQL statement can be executed in parallel. Further, a second determination can be made regarding whether executing the SQL statement in parallel is faster than executing the statement in serial by a predetermined factor. If the first determination and second determination are positive (i.e., the statement can be executed in parallel and parallel execution is faster by the predetermined factor), a recommendation can be provided indicating that the SQL statement should be executed in parallel. In some embodiments, the recommendation can include a report specifying the degree of performance improvement gained from parallel execution, additional system resources consumed by parallel execution, and other statistics pertaining to the recommended parallel execution plan.
摘要翻译：自动推荐并行执行SQL语句的技术。在一组实施例中，可以首先确定是否可以并行执行SQL语句。此外，可以进行关于并行执行SQL语句是否比以预定因子串行执行语句更快的第二确定。如果第一确定和第二确定是正的（即，可以并行执行语句并且并行执行以预定因子更快），则可以提供指示应该并行执行SQL语句的建议。在一些实施例中，该建议可以包括指定从并行执行获得的性能改进程度的报告，并行执行消耗的附加系统资源以及与推荐的并行执行计划有关的其他统计信息。

76. 发明授权

US08082265B2 Database query processing with dynamically activated buffers 失效
标题翻译：使用动态激活的缓冲区进行数据库查询处理
公开(公告)号：US08082265B2
公开(公告)日：2011-12-20
申请号：US12056344
申请日：2008-03-27
申请人： David Glenn Carlson , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： David Glenn Carlson , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
IPC分类号： G06F7/00
CPC分类号： G06F17/30474 , G06F17/30445 , G06F17/30457 , G06F17/30466
摘要： A method, apparatus and program product dynamically activate and/or deactivate buffers during execution of a database query. The dynamic deactivation and activation is based on the monitoring of information associated with the consumption of data by a plurality of threads during execution of an access plan for the database query. By doing so, the selection of a less optimal buffer position during optimization may be replaced with a more optimal buffer position during runtime, often resulting in improved query performance and parallelism.
摘要翻译：方法，装置和程序产品在执行数据库查询期间动态地激活和/或停用缓冲器。动态去激活和激活是基于在用于数据库查询的访问计划的执行期间监视与多个线程的数据消耗相关联的信息。通过这样做，在优化期间选择较不优化的缓冲器位置可以在运行时期间用更优化的缓冲器位置代替，通常导致改进的查询性能和并行性。

77. 发明申请

US20110282875A1 LOCALIZED DATA AFFINITY SYSTEM AND HYBRID METHOD 有权
标题翻译：本地化数据重建系统和混合方法
公开(公告)号：US20110282875A1
公开(公告)日：2011-11-17
申请号：US13083396
申请日：2011-04-08
申请人： C. Scot Atkins , Joseph Conway
发明人： C. Scot Atkins , Joseph Conway
IPC分类号： G06F17/30
CPC分类号： G06F17/30598 , G06F9/5033 , G06F17/30445 , G06F17/30463 , G06F17/3048 , G06F2209/5012
摘要： A method, system, and computer program for processing records is disclosed. The records are associated with record sets. Record sets are associated with processor sets, which include one or more processors. Records are routed to associated processor sets for processing, based on the record set associated with the record. Records are processed on processors in the processor sets. Furthermore, various localized affinities can be established. Process affinity can link server processes with processor sets. Cache affinity can link database caches with processor sets. Data affinity can link incoming data to processor sets.
摘要翻译：公开了一种用于处理记录的方法，系统和计算机程序。记录与记录集相关联。记录集与处理器集相关联，处理器集包括一个或多个处理器。基于与记录相关联的记录集，将记录路由到相关处理器集合进行处理。记录在处理器集中的处理器上进行处理。此外，可以建立各种局部亲和力。流程关联可以将服务器进程与处理器集进行链接。缓存关联可以将数据库缓存与处理器集链接。数据相关性可将输入数据链接到处理器集。

78. 发明申请

US20110276962A1 PARALLEL PROCESSING OF DATA 有权
标题翻译：并行处理数据
公开(公告)号：US20110276962A1
公开(公告)日：2011-11-10
申请号：US12959022
申请日：2010-12-02
申请人： Craig D. Chambers , Ashish Raniwala , Frances J. Perry , Robert R. Henry , Jordan Tigani
发明人： Craig D. Chambers , Ashish Raniwala , Frances J. Perry , Robert R. Henry , Jordan Tigani
IPC分类号： G06F9/455
CPC分类号： G06F9/45504 , G06F8/314 , G06F8/34 , G06F8/433 , G06F9/30 , G06F9/38 , G06F9/3851 , G06F9/3885 , G06F9/44 , G06F9/445 , G06F9/4494 , G06F9/45533 , G06F9/4843 , G06F17/30445 , G06F17/30471 , G06F21/577 , G06F21/62 , G06F21/6218 , G06F2221/034
摘要： An untrusted application is received at a data center including one or more processing modules and providing a native processing environment. The untrusted application includes a data parallel pipeline. Secured processing environments are used to execute the untrusted application.
摘要翻译：在包括一个或多个处理模块的数据中心接收到不可信的应用程序并提供本地处理环境。不可信应用程序包括数据并行流水线。安全处理环境用于执行不受信任的应用程序。

79. 发明申请

US20110276789A1 PARALLEL PROCESSING OF DATA 有权
标题翻译：并行处理数据
公开(公告)号：US20110276789A1
公开(公告)日：2011-11-10
申请号：US12794348
申请日：2010-06-04
申请人： Craig D. Chambers , Ashish Raniwala , Frances J. Perry , Stephen R. Adams , Robert R. Henry , Robert Bradshaw , Nathan Weizenbaum
发明人： Craig D. Chambers , Ashish Raniwala , Frances J. Perry , Stephen R. Adams , Robert R. Henry , Robert Bradshaw , Nathan Weizenbaum
IPC分类号： G06F9/38
CPC分类号： G06F9/45504 , G06F8/314 , G06F8/34 , G06F8/433 , G06F9/30 , G06F9/38 , G06F9/3851 , G06F9/3885 , G06F9/44 , G06F9/445 , G06F9/4494 , G06F9/45533 , G06F9/4843 , G06F17/30445 , G06F17/30471 , G06F21/577 , G06F21/62 , G06F21/6218 , G06F2221/034
摘要： A data parallel pipeline may specify multiple parallel data objects that contain multiple elements and multiple parallel operations that operate on the parallel data objects. Based on the data parallel pipeline, a dataflow graph of deferred parallel data objects and deferred parallel operations corresponding to the data parallel pipeline may be generated and one or more graph transformations may be applied to the dataflow graph to generate a revised dataflow graph that includes one or more of the deferred parallel data objects and deferred, combined parallel data operations. The deferred, combined parallel operations may be executed to produce materialized parallel data objects corresponding to the deferred parallel data objects.
摘要翻译：数据并行流水线可以指定多个并行数据对象，其中包含对并行数据对象进行操作的多个元素和多个并行操作。基于数据并行流水线，可以生成与数据并行流水线相对应的延迟并行数据对象和延迟并行操作的数据流图，并且可以将一个或多个图变换应用于数据流图，以生成修改后的数据流图，其中包括一个或更多的延迟并行数据对象和延迟的并行数据操作。可以执行延迟的组合并行操作以产生与延迟并行数据对象相对应的物化并行数据对象。

80. 发明申请

US20110246510A1 DEVICE AND METHOD FOR DISTRIBUTED PROCESSING 有权
标题翻译：用于分布式处理的装置和方法
公开(公告)号：US20110246510A1
公开(公告)日：2011-10-06
申请号：US13073083
申请日：2011-03-28
申请人： Ken TAKAHASHI
发明人： Ken TAKAHASHI
IPC分类号： G06F17/30
CPC分类号： G06F7/00 , G06F17/30 , G06F17/30445
摘要： A distributed processing device includes a searching unit that searches, in accordance with attribute names identifying a plurality of records stored on a database, a process group for a second process having as a process target a record of an attribute name different from an attribute name included in a process request of a first process selected from among the process group to the database, a determining unit that determines the first process and the second process as execution targets to be executed by a plurality of nodes when the second process is hit by the searching unit, and an allocation unit that allocates the execution target determined by the determining unit to the plurality of nodes that execute the processes in parallel to the database.
摘要翻译：分布式处理装置包括：搜索单元，其根据识别存储在数据库中的多个记录的属性名称搜索具有与包括的属性名称不同的属性名称的记录的第二进程的处理对象在从所述处理组到所述数据库中选择的第一处理的处理请求中，确定单元，当所述第二处理被所述搜索命中时，所述确定单元将所述第一处理和所述第二处理确定为由所述多个节点执行的执行目标单元，以及分配单元，其将由所述确定单元确定的执行目标分配给与所述数据库并行执行所述处理的所述多个节点。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式