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

11. 发明申请

US20170228449A1 Frequency Dependent Partial Index 审中-公开
公开(公告)号：US20170228449A1
公开(公告)日：2017-08-10
申请号：US15016744
申请日：2016-02-05
申请人： International Business Machines Corporation
发明人： Kai Feng Cui , Shuo Li , Shu Hua Liu , Xin Ying Yang
IPC分类号： G06F17/30
CPC分类号： G06F16/278 , G06F16/221 , G06F16/2228
摘要： Using historical queries to determine database columns to populate a partial database. A partial database is created based, at least in part, on key values related to columns in a database for which the columns are most frequently accessed.

12. 发明授权

US09661030B2 Building and switching IP multimedia sessions 有权
公开(公告)号：US09661030B2
公开(公告)日：2017-05-23
申请号：US13665463
申请日：2012-10-31
申请人： International Business Machines Corporation
发明人： Sheng Hua Bao , Jian Chen , Zhong Su , Xin Ying Yang , Xiang Zhou
IPC分类号： G06F15/173 , H04L29/06
CPC分类号： H04L65/1066 , H04L65/1016 , H04L65/1069 , H04L65/1073 , H04L65/80
摘要： Embodiments of the present disclosure include methods and systems of building an IP multimedia session without the use of a central server and switching IP multimedia session among devices. The method of building an IP multimedia session includes receiving a registering request from a plurality of IP multimedia session participant devices, electing a service device from the plurality of participant devices, and building IP multimedia session among the plurality of participant devices by using the elected service device.

13. 发明授权

US09633059B2 Data table performance optimization 有权
公开(公告)号：US09633059B2
公开(公告)日：2017-04-25
申请号：US15234482
申请日：2016-08-11
申请人： International Business Machines Corporation
发明人： Shuo Li , Shu Hua Liu , Xin Ying Yang , Jian W. Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , G06F7/08 , G06F17/3002 , G06F17/30289 , G06F17/30339 , G06F17/3053
摘要： A computer program product to optimize a database is provided. A processor determines a frequency of search for a plurality of columns in a table. A processor determines a length of the plurality of columns. A processor determines a rank for the plurality of columns based, at least in part, on both the frequency of search and the length of the plurality of columns. A processor generates a first set of combinations of the plurality of columns. A processor determines an optimization of the first set of combinations of the plurality of columns. A processor selects an optimal combination of the first set of combinations, wherein the optimization of the optimal combination is greater than the optimization for all other combinations in the first set of combinations. A processor moves the plurality of columns excluded from the optimal combination.

14. 发明授权

US09613075B2 Index masking based on insert contention ratio 有权
公开(公告)号：US09613075B2
公开(公告)日：2017-04-04
申请号：US15066543
申请日：2016-03-10
申请人： International Business Machines Corporation
发明人： Shuo Li , Ping Liang , Xin Ying Yang , Jian Wei Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30336 , G06F17/30315 , G06F17/30377
摘要： Embodiments of the present invention provide a method, computer program product, and computer system for masking indexes. The method may include masking the index if the index contention exceeds a defined threshold. The method may also include configuring the mask type for the index to insert the index without masking. In response to determining that the mask type for the index is configured to insert the index without masking, the index is masked according to a set of rules.

15. 发明申请

US20170075956A1 CONTEXT BASED ACCESS PATH SELECTION 有权
公开(公告)号：US20170075956A1
公开(公告)日：2017-03-16
申请号：US14854087
申请日：2015-09-15
申请人： International Business Machines Corporation
发明人： Shuo Li , Ke Wei Wei , Li Yang , 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.

16. 发明授权

US09575916B2 Apparatus and method for identifying performance bottlenecks in pipeline parallel processing environment 有权
标题翻译：用于识别流水线并行处理环境中性能瓶颈的装置和方法
公开(公告)号：US09575916B2
公开(公告)日：2017-02-21
申请号：US14148697
申请日：2014-01-06
申请人： International Business Machines Corporation
发明人： Brian K. Caufield , Ron E. Liu , DongJie Wei , Xin Ying Yang
IPC分类号： G06F7/00 , G06F13/36
CPC分类号： G06F13/36
摘要： A system identifies a performance bottleneck status in a parallel data processing environment by examining data flow associated with the parallel data processing environment to identify at least one operator, where an operator type is associated with at least one operator, at least one buffer, and a relationship that the buffer has with the operator, where the relationship is associated with the operator type. The system monitors the buffer to determine a buffer status associated with the buffer. The system applies a set of rules to identify an operator bottleneck status associated with the operator. The set of rules is applied to the operator, based on the operator type, the buffer status, and relationship that the buffer has with the operator. The system then determines a performance bottleneck status associated with the parallel data processing environment, based on the operator bottleneck status.
摘要翻译：系统通过检查与并行数据处理环境相关联的数据流来识别并行数据处理环境中的性能瓶颈状态，以识别至少一个运营商，其中运营商类型与至少一个运营商，至少一个缓冲区和缓冲区与操作员的关系，其中关系与操作员类型相关联。系统监视缓冲区以确定与缓冲区相关联的缓冲区状态。系统应用一组规则来识别与操作员相关联的操作员瓶颈状态。根据操作员类型，缓冲区状态以及缓冲区与操作员的关系，将一组规则应用于操作员。然后，系统基于操作员瓶颈状态确定与并行数据处理环境相关联的性能瓶颈状态。

17. 发明授权

US09569470B2 Managing sharing relationship of tables 有权
标题翻译：管理表的共享关系
公开(公告)号：US09569470B2
公开(公告)日：2017-02-14
申请号：US14458313
申请日：2014-08-13
申请人： INTERNATIONAL BUSINESS MACHINES CORPORATION
发明人： Shuo Li , Xin Ying Yang , Mai Zeng , Xiang Zhou
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30292
摘要： Managing a sharing relationship of tables. A super schema is formed incorporating a plurality of tables in a database according to data types of respective columns of the plurality of tables. A free storage capacity of the super schema is evaluated according to holes not occupied by any table in the super schema. A sharing relationship of the plurality of tables is determined according to the free storage capacity of the super schema. The sharing relationship of a large number of tables in a database can be managed effectively, so as to design or optimize the sharing solution among the tables.
摘要翻译：管理表的共享关系。根据多个表的各列的数据类型，形成在数据库中并入多个表的超级模式。超级模式的空闲存储容量根据超级模式中的任何表未占用的孔进行评估。根据超级模式的可用存储容量来确定多个表的共享关系。可以有效地管理数据库中大量表的共享关系，以便设计或优化表之间的共享解决方案。

18. 发明申请

US20170017686A1 ACCESS PATH OPTIMIZATION THROUGH SYSTEM STATISTICS 审中-公开
公开(公告)号：US20170017686A1
公开(公告)日：2017-01-19
申请号：US14798537
申请日：2015-07-14
申请人： International Business Machines Corporation
发明人： Hao Feng , Shuo Li , ShengYan Sun , Xin Ying Yang
IPC分类号： G06F17/30
CPC分类号： G06F17/30469 , G06F17/30424 , G06F17/30448 , G06F17/30474
摘要： In an approach for calculating one or more access paths during bind time, a computer receives a query. The computer identifies one or more access paths for processing the received query, wherein the one or more access paths include steps associated with retrieving data from a database based on the received query. The computer calculates resource costs associated with processing the received query on the one or more identified access paths based on one of more of: resources utilized to perform steps associated with processing the received query, and system statistics associated with the one or more identified access paths.

19. 发明授权

US09547691B1 Access path optimization through system statistics 有权
标题翻译：访问路径优化通过系统统计
公开(公告)号：US09547691B1
公开(公告)日：2017-01-17
申请号：US15210094
申请日：2016-07-14
申请人： International Business Machines Corporation
发明人： Hao Feng , Shuo Li , ShengYan Sun , Xin Ying Yang
IPC分类号： G06F17/30
CPC分类号： G06F17/30469 , G06F17/30448 , G06F17/30474
摘要： In an approach for calculating one or more access paths during bind time, a computer receives a query. The computer identifies one or more access paths for processing the received query, wherein the one or more access paths include steps associated with retrieving data from a database based on the received query. The computer calculates resource costs associated with processing the received query on the one or more identified access paths based on one of more of: resources utilized to perform steps associated with processing the received query, and system statistics associated with the one or more identified access paths.
摘要翻译：在绑定时间内计算一个或多个访问路径的方法中，计算机接收查询。计算机识别用于处理所接收的查询的一个或多个访问路径，其中所述一个或多个访问路径包括与基于所接收的查询从数据库检索数据相关联的步骤。计算机基于以下之一来计算与处理接收的查询相关联的资源成本：用于执行与处理所接收的查询相关联的步骤的资源;以及与所述一个或多个所识别的访问路径相关联的系统统计。

20. 发明申请

US20160371328A1 PARTITION ACCESS METHOD FOR QUERY OPTIMIZATION 审中-公开
公开(公告)号：US20160371328A1
公开(公告)日：2016-12-22
申请号：US14746321
申请日：2015-06-22
申请人： International Business Machines Corporation
发明人： Shuo Li , Ping Liang , Ke Wei Wei , Xin Ying Yang
IPC分类号： G06F17/30
CPC分类号： G06F16/2453 , G06F16/2282 , G06F16/24545 , G06F16/24554 , G06F16/278
摘要： In an approach to determining an access method for a partition in a partition table, a computer receives a query and determines if there is a partition table utilized by the query. When there is a partition table utilized by the query, then the computer determines that a partition in the partition table meets the plurality of conditions of the query. The computer collects a plurality of partition level statistics for the partition that meets the plurality of conditions of the query. Additionally, the computer determines, based, at least in part, on the plurality of partition level statistics, a cost for one or more access methods for the partition that meets the plurality of conditions of the query. Furthermore, the computer determines, based, at least in part, on the cost for each access method, an access method for the partition that meets the plurality of conditions of the query.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式