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

1. 发明申请

US20180336244A1 QUERY GOVERNOR ENHANCEMENTS FOR DATABASES INTEGRATED WITH DISTRIBUTED PROGRAMMING ENVIRONMENTS 审中-公开
公开(公告)号：US20180336244A1
公开(公告)日：2018-11-22
申请号：US15600461
申请日：2017-05-19
申请人： International Business Machines Corporation
发明人： Eric L. BARSNESS , Daniel E. BEUCH , Alexander COOK , John M. SANTOSUOSSO
IPC分类号： G06F17/30
CPC分类号： G06F17/30433 , G06F9/50 , G06F17/30442 , G06F17/30466 , G06F17/30469 , G06F17/30474
摘要： Systems, methods, and computer program products to perform an operation comprising receiving, by a database management system (DBMS), a query for execution, computing, by a query governor, a first resource consumption value for executing a first portion of the received query against a plurality of data tuples in an operator graph of a distributed application, and upon determining that the first resource consumption value does not exceed a first threshold value, executing the query by operation of one or more computer processors.

2. 发明申请

US20180329956A1 DYNAMIC SELF-RECONFIGURATION OF NODES IN A PROCESSING PIPELINE 审中-公开
公开(公告)号：US20180329956A1
公开(公告)日：2018-11-15
申请号：US15977816
申请日：2018-05-11
申请人： Oracle International Corporation
发明人： Ashish Mittal , Steve Simon Joseph Fernandez , Kenneth Khiaw Hong Eng
IPC分类号： G06F17/30 , G06F9/38 , G06F9/445
CPC分类号： G06F17/30474 , G06F9/3867 , G06F9/44505 , G06F17/30477
摘要： A query optimization system is described that, at runtime, optimizes the execution pipeline generated for a query. Based upon communications between nodes in the execution pipeline, the execution pipeline generated for a query is optimized by modifying the execution pipeline to create a modified execution pipeline. The modified execution pipeline is then executed to execute the query and results obtained for the query. The changes or modifications made to an execution pipeline may include changing the capabilities (e.g., changes to inputs and/or outputs of a node, changing the task(s) or function(s) performed by the node) of one or more nodes within the execution pipeline. The changes may include changing the position of one or more nodes within a directed acyclic graph representing the execution pipeline.

3. 发明授权

US09852142B2 Method for EN passant workload shift detection 有权
公开(公告)号：US09852142B2
公开(公告)日：2017-12-26
申请号：US15040009
申请日：2016-02-10
申请人： INTERNATIONAL BUSINESS MACHINES CORPORATION
发明人： Michael Reichert , Torsten Steinbach , Matthias Tschaffler
IPC分类号： G06F17/30 , G06F11/34 , G06F11/30
CPC分类号： G06F17/30144 , G06F11/3034 , G06F11/3414 , G06F17/30433 , G06F17/30463 , G06F17/30469 , G06F17/30474 , G06F17/30595
摘要： Embodiments of the present invention provide systems, methods, and computer program products for detecting shifts in types of workloads handled by a relational database management system. Embodiments of the present invention can afford relational database administrators with the ability to leverage information pertinent to the current type of workload being handled by the relational database management system. Furthermore, embodiments of the present invention provide relational database administrators with information in regard to system workload states and workload transitions.

4. 发明申请

US20170147686A1 MANAGING COMPLEX QUERIES WITH PREDICATES 有权
公开(公告)号：US20170147686A1
公开(公告)日：2017-05-25
申请号：US14951773
申请日：2015-11-25
申请人： International Business Machines Corporation
发明人： Naresh K. Chainani , Kiran K. Chinta , Liping Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30699 , G06F17/30424 , G06F17/30457 , G06F17/30463 , G06F17/30474 , G06F17/30477 , G06F17/30672
摘要： A first query is detected. The first query is for a storage device, and pulls a result set from the storage device using a set of predicates. The first query satisfies a size criterion. A new set of predicates of the result set is identified. The new set of predicates does not include any predicates of the original set of predicates. A second query which is the same as the first query is detected. The new set of predicates is used to determine the result set.

5. 发明申请

US20170075957A1 CONTEXT BASED ACCESS PATH SELECTION 有权
标题翻译：基于上下文的访问路径选择
公开(公告)号：US20170075957A1
公开(公告)日：2017-03-16
申请号：US15345168
申请日：2016-11-07
申请人： International Business Machines Corporation
发明人： Shuo Li , Li Yang , Ke Wei Wei , Xin Ying Yang , Jian Wei Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30469 , G06F17/30474 , G06F17/30516
摘要： A computer-implemented method includes receiving a batch processing job. The method identifies multiple access paths for the batch processing job. The method determines one or more runtime costs for each of the multiple access paths. The method determines whether the batch processing job includes comparable access paths. The method responds to the batch processing job not including comparable access paths by receiving a query and selecting a desired access, based on the one or more runtime costs. The method responds to the batch processing job including comparable access paths by determining one or more context costs for each of the one or more access paths, receiving a query, identifying a context for the query, and selecting a desired access path for the query. The desired access path is based on the one or more runtime costs, the one or more context costs, and the context for the query.
摘要翻译：计算机实现的方法包括接收批处理作业。该方法识别批处理作业的多个访问路径。该方法确定多个访问路径中的每一个的一个或多个运行时间成本。该方法确定批处理作业是否包括可比较的访问路径。该方法通过基于一个或多个运行时间费用接收查询和选择所需的访问来响应不包括可比较的访问路径的批处理作业。该方法通过为一个或多个访问路径中的每一个确定一个或多个上下文成本，接收查询，标识查询的上下文以及为查询选择所需的访问路径来响应批量处理作业，包括可比较的访问路径。期望的访问路径基于一个或多个运行时成本，一个或多个上下文成本以及查询的上下文。

6. 发明申请

US20160246843A1 METHOD FOR EN PASSANT WORKLOAD SHIFT DETECTION 有权
公开(公告)号：US20160246843A1
公开(公告)日：2016-08-25
申请号：US15040009
申请日：2016-02-10
申请人： INTERNATIONAL BUSINESS MACHINES CORPORATION
发明人： Michael Reichert , Torsten Steinbach , Matthias Tschaffler
IPC分类号： G06F17/30
CPC分类号： G06F17/30144 , G06F11/3034 , G06F11/3414 , G06F17/30433 , G06F17/30463 , G06F17/30469 , G06F17/30474 , G06F17/30595
摘要： Embodiments of the present invention provide systems, methods, and computer program products for detecting shifts in types of workloads handled by a relational database management system. Embodiments of the present invention can afford relational database administrators with the ability to leverage information pertinent to the current type of workload being handled by the relational database management system. Furthermore, embodiments of the present invention provide relational database administrators with information in regard to system workload states and workload transitions.

7. 发明申请

US20160246839A1 METHOD FOR EN PASSANT WORKLOAD SHIFT DETECTION 有权
标题翻译：通过便携式移动检测方法
公开(公告)号：US20160246839A1
公开(公告)日：2016-08-25
申请号：US14625650
申请日：2015-02-19
申请人： International Business Machines Corporation
发明人： Michael Reichert , Torsten Steinbach , Matthias Tschaffler
IPC分类号： G06F17/30 , G06F11/30 , G06F11/34
CPC分类号： G06F17/30144 , G06F11/3034 , G06F11/3414 , G06F17/30433 , G06F17/30463 , G06F17/30469 , G06F17/30474 , G06F17/30595
摘要： Embodiments of the present invention provide systems, methods, and computer program products for detecting shifts in types of workloads handled by a relational database management system. Embodiments of the present invention can afford relational database administrators with the ability to leverage information pertinent to the current type of workload being handled by the relational database management system. Furthermore, embodiments of the present invention provide relational database administrators with information in regard to system workload states and workload transitions.
摘要翻译：本发明的实施例提供了用于检测由关系数据库管理系统处理的工作负载类型的变化的系统，方法和计算机程序产品。本发明的实施例可以使关系数据库管理员能够利用与由关系数据库管理系统处理的当前类型的工作负载有关的信息。此外，本发明的实施例为关系数据库管理员提供关于系统工作负载状态和工作负载转换的信息。

8. 发明授权

US09411845B2 Integration flow database runtime 有权
标题翻译：集成流数据库运行时
公开(公告)号：US09411845B2
公开(公告)日：2016-08-09
申请号：US13916889
申请日：2013-06-13
申请人： Christian Mathis , Daniel Ritter
发明人： Christian Mathis , Daniel Ritter
IPC分类号： G06F17/30
CPC分类号： G06F17/30569 , G06F17/30345 , G06F17/30474 , G06F17/3056 , G06F17/30595
摘要： The present disclosure describes methods, systems, and computer program products for providing application integration functionality directly on a relational database according to an implementation. One computer-implemented method includes inserting relational data into a start table of a database, detecting a change in the start table, retrieving the inserted relational data from the start table, processing, using a computer, the relational data using a database integration flow runtime into result data, inserting the result data into an end table of the database, detecting a change in the end table, and retrieving the result data from the end table.
摘要翻译：本公开描述了用于根据实现直接在关系数据库上提供应用集成功能的方法，系统和计算机程序产品。一种计算机实现的方法包括将关系数据插入到数据库的起始表中，检测起始表的变化，从起始表检索插入的关系数据，使用计算机处理使用数据库集成流运行时的关系数据将结果数据插入到数据库的结束表中，检测结束表中的变化，并从结束表中检索结果数据。

9. 发明授权

US09251203B2 User interface for predictive model generation 有权
标题翻译：用于预测模型生成的用户界面
公开(公告)号：US09251203B2
公开(公告)日：2016-02-02
申请号：US14136386
申请日：2013-12-20
申请人： MModal IP LLC
发明人： Jonathan A. Handler , Juergen Fritsch
IPC分类号： G06F17/30 , G06F17/18
CPC分类号： G06F17/30554 , G06F17/18 , G06F17/30345 , G06F17/30424 , G06F17/30474 , G06F17/30477 , G06N7/005
摘要： A dataset is searched using inclusion set criteria to produce an inclusion set and exclusion set criteria to produce an exclusion set. A set of unique content elements is identified from the inclusion set and the exclusion set. Metrics are derived from the inclusion set, exclusion set, and set of unique content elements, such as a measure, for each unique content element, of the absolute value of the difference between the percentage of records in the inclusion set containing the unique content element and the percentage of records in the exclusion set containing the unique content element. The unique content element set may be sorted and displayed in decreasing order of the above-referenced absolute value. The content element set may be filtered. Individual content elements may be excluded from the content set. A predictive model may be generated based on the resulting version of the content element set.
摘要翻译：使用包含集合标准搜索数据集以生成包含集和排除集合标准以生成排除集合。从包含集合和排除集合中识别一组唯一的内容元素。度量是从包含集合，排除集合和唯一内容元素集合（例如每个唯一内容元素的度量）导出包含唯一内容元素的包含集合中记录的百分比之间的差异的绝对值以及包含唯一内容元素的排除集中的记录百分比。可以按照上述绝对值的递减顺序对独特的内容元素集合进行排序和显示。内容元素集可以被过滤。可以从内容集中排除各个内容元素。可以基于所生成的内容元素集的版本来生成预测模型。

10. 发明授权

US09189524B2 Obtaining partial results from a database query 有权
公开(公告)号：US09189524B2
公开(公告)日：2015-11-17
申请号：US14277910
申请日：2014-05-15
申请人： International Business Machines Corporation
发明人： Eric L. Barsness , John M. Santosuosso
IPC分类号： G06F17/30
CPC分类号： G06F17/30474 , G06F17/30424 , G06F17/30463 , G06F17/30536
摘要： A database query governor determines when a query cannot be executed within a defined time threshold, but still executes the query or some variant of the query so partial results for the query may be returned to the user after executing for less than the defined time threshold, instead of an error message indicating the query was not executed at all. The partial results provide information to the user that may be sufficient for some applications, or may indicate to the user how the query could be modified to run in less time.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式