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

91. 发明申请

US20160055156A1 DATABASE QUERY CACHING AND REUSE 审中-公开
标题翻译：数据库查询缓存和重用
公开(公告)号：US20160055156A1
公开(公告)日：2016-02-25
申请号：US14753123
申请日：2015-06-29
申请人： International Business Machines Corporation
发明人： Shuo Li , Ke Wei Wei , Xin Ying Yang , Xiang Zhou
IPC分类号： G06F17/30 , G06F12/08
CPC分类号： G06F16/24552 , G06F12/0864 , G06F2212/1032 , G06F2212/465
摘要： A query block may be cached, not like the traditional solution, which can only cache a query result for the query block. For example, a work file for storing a result set of a query block may be maintained after relevant query has been completed. In subsequent use, once a query for the query block is received, query may be processed quickly by directly reusing the result set. In this way, the data overheads for reducing the query processing can be significantly reduced, and the response time for shorting the query processing can be shortened. Corresponding methods and systems are described in the present disclosure.
摘要翻译：查询块可能被缓存，不像传统的解决方案，它只能缓存查询块的查询结果。例如，可以在相关查询完成之后维护用于存储查询块的结果集的工作文件。在后续使用中，一旦接收到查询块的查询，可以通过直接重用结果集来快速处理查询。以这种方式，可以显着减少用于减少查询处理的数据开销，并且可以缩短用于缩短查询处理的响应时间。在本公开中描述了相应的方法和系统。

92. 发明授权

US09176958B2 Method and apparatus for music searching 有权
标题翻译：音乐搜索的方法和装置
公开(公告)号：US09176958B2
公开(公告)日：2015-11-03
申请号：US13795602
申请日：2013-03-12
申请人： International Business Machines Corporation
发明人： Xin Ying Yang , Xiang Zhou , Shan Shan Wang , Heng Liu
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30026 , G06F17/30743 , G10H1/0008 , G10H1/40 , G10H2210/076 , G10H2220/096 , G10H2220/211 , G10H2220/391 , G10H2220/395 , G10H2240/141
摘要： In an exemplary embodiment of this disclosure, a method may include generating a tempo scale set based on a received query, where the query includes a plurality of query values defining a tempo of music to be searched. A tempo word set may be constructed based on the generated tempo scale set. The tempo word set may include one or more tempo words, where each tempo word includes at least one tempo scale in the tempo scale set. The music may be identified using the constructed tempo word set.
摘要翻译：在本公开的示例性实施例中，方法可以包括基于接收到的查询生成速度规模集合，其中查询包括定义要搜索的音乐节奏的多个查询值。可以基于生成的速度标度集来构建速度词集合。节奏单词集可以包括一个或多个节奏单词，其中每个节奏单词在速度比例集中包括至少一个节奏量表。可以使用构建的速度词集来识别音乐。

93. 发明授权

US09031934B2 Estimation of a filter factor used for access path optimization in a database 有权
标题翻译：用于数据库中访问路径优化的过滤因子的估计
公开(公告)号：US09031934B2
公开(公告)日：2015-05-12
申请号：US13686030
申请日：2012-11-27
申请人： International Business Machines Corporation
发明人： Xin Ying Yang , Chun Guang Zeng , Xiang Zhou , Ke Wei Wei
IPC分类号： G06F17/30
CPC分类号： G06F17/30442
摘要： A computer program product and method for estimating a filter factor for access path optimization in a database are provided. The method includes extracting from a statement segment for database query a relation condition which defines the relationship between a variable and a first table. The method includes obtaining first statistics information according to the relation condition and the statistics information of the first table. The method includes extracting from the statement segment a filter condition which defines the relationship between the variable and a second table. The method includes obtaining second statistics information according to the filter condition and the statistics information of the second table, and according to the first statistics information and the second statistics information, estimating the filter factor of the filter condition. The method and computer program product according to the embodiments of the disclosure may more accurately estimate filter factor of the filter condition.
摘要翻译：提供了一种用于估计数据库中的访问路径优化的过滤因子的计算机程序产品和方法。该方法包括从用于数据库查询的语句段中提取定义变量和第一表之间的关系的关系条件。该方法包括根据关系条件和第一表的统计信息获得第一统计信息。该方法包括从语句段提取定义变量与第二表之间的关系的过滤条件。该方法包括根据第二表的过滤条件和统计信息获得第二统计信息，并且根据第一统计信息和第二统计信息，估计过滤条件的过滤因子。根据本公开的实施例的方法和计算机程序产品可以更准确地估计滤波器条件的滤波器因子。

94. 发明授权

US11222016B2 Dynamic combination of processes for sub-queries 有权
公开(公告)号：US11222016B2
公开(公告)日：2022-01-11
申请号：US16402259
申请日：2019-05-03
申请人： International Business Machines Corporation
发明人： Shuo Li , Meng Wan , Xiaobo Wang , Xin Ying Yang
IPC分类号： G06F16/2453 , G06F16/2452 , G06F16/2455
摘要： A tool for combining common processes shared by at least two or more sub-queries within a query is provided. The tool determines whether one or more sub set relationships are shared between the at least two or more sub-queries. Responsive to a determination that one or more sub set relationships are shared between the at least two or more sub-queries, the tool determines an order class for the at least two or more sub-queries based on the one or more sub set relationships, wherein determining the order class includes transforming the query to include one or more differing aspects within the single shared common process, with the one or more differing aspects arranged based, at least in part, on a query style, a query type, and a query function. Responsive to determining an access path for the query, the tool executes the access path during run-time for data accessing.

95. 发明授权

US11120000B2 Enhancements for optimizing query executions 有权
公开(公告)号：US11120000B2
公开(公告)日：2021-09-14
申请号：US16406046
申请日：2019-05-08
申请人： International Business Machines Corporation
发明人： Shuo Li , Ping Liang , Kewei Wei , Xin Ying Yang
IPC分类号： G06F16/2453 , G06F16/22 , G06F16/28 , G06F16/2455
摘要： In an approach for optimizing query executions a processor receives a request to transfer data from a first table to a second table. A processor detects a relationship between the first table and the second table, wherein the relationship is based on a similarity between the first table and the second table. A processor identifies at least a first access path for transferring the data from the first table to the second table. A processor calculates a first cost of transferring the data from the first table to the second table using the first access path based on the similarity between the first table and the second table, wherein the first cost indicates estimated processor usage to transfer the data.

96. 发明授权

US10795898B2 Rank-based calculation for keyword searches 有权
公开(公告)号：US10795898B2
公开(公告)日：2020-10-06
申请号：US16031260
申请日：2018-07-10
申请人： International Business Machines Corporation
发明人： Xiao Di Deng , Shuo Li , Meng Wan , Xin Ying Yang
IPC分类号： G06F16/2457 , G06F16/93 , G06F16/335 , G06F16/2453
摘要： Embodiments of the present invention provide efficient systems and methods for searching a keyword. Embodiments of the present invention can be used to more quickly and comprehensively search a document for a keyword or phrase, based on the preferences and behaviors of a user, so that the returned results to the user are ranked in order of the preferences of the user. By factoring in user data such as time spent on certain content and highlighted content, the system is able to more efficiently return preferred results of a user of a keyword search.

97. 发明授权

US10762099B2 Syntactical transformation of database interaction statements 有权
公开(公告)号：US10762099B2
公开(公告)日：2020-09-01
申请号：US15175593
申请日：2016-06-07
申请人： International Business Machines Corporation
发明人： Dong Jie Wei , Ke Wei Wei , Xin Ying Yang , Miao Zheng
IPC分类号： G06F16/00 , G06F16/25 , G06F16/23 , G06F16/21
摘要： A computer-implemented method includes identifying a primary database interaction statement and determining one or more intermediate database interaction statements based on the primary database interaction statement. The computer-implemented further includes determining, for each of the one or more intermediate database interaction statements, an intermediate statement transformation indicator. The computer-implemented method further includes determining one or more transformed database interaction statements based on each intermediate statement transformation indicator. A corresponding computer program product and computer system are also disclosed.

98. 发明授权

US10572480B2 Adaptive intersect query processing 有权
公开(公告)号：US10572480B2
公开(公告)日：2020-02-25
申请号：US15809406
申请日：2017-11-10
申请人： International Business Machines Corporation
发明人： Shuo Li , Heng Liu , Ke Wei Wei , Xin Ying Yang
IPC分类号： G06F17/30 , G06F16/2453 , G06F16/248 , G06F16/2455
摘要： A computer-implemented method includes identifying a query, including one or more predicates and one or more branches, wherein one or more branches includes one or more legs. The computer-implemented method further includes, for each branch, in parallel: determining a risk, determining a return row threshold, estimating a number of return rows; terminating access if the return rows exceed the threshold. The computer-implemented method further includes, for each leg, in parallel: determining a leg return row threshold; accessing the leg; fetching one or more return rows into one or more leg return row pages; terminating access if the return rows exceed the threshold; intersecting one or more leg return row pages into one or more intersected leg return row pages; and applying the one or more predicates to the one or more intersected leg return row pages. The method may be embodied in a corresponding computer system or computer program product.

99. 发明授权

US10546379B2 Interactive video generation 有权
公开(公告)号：US10546379B2
公开(公告)日：2020-01-28
申请号：US15832852
申请日：2017-12-06
申请人： INTERNATIONAL BUSINESS MACHINES CORPORATION
发明人： Hong Wei Jia , Qian Li , Shuang Li , Hai Lei Song , Yun Ting Wang , Xin Ying Yang , Wenyan Yuan , Guang Ming Zhang
IPC分类号： G06T7/11 , G06K9/62 , G06K9/00 , G06F3/048 , G11B27/00
摘要： A method includes receiving an input from a user, the input including a selection of an object, where the object is contained in a video, identifying, in response to the input, the object in the video, determining an attribute of the object associated with a profile of the user, where the profile contains a preference of the user regarding at least one object to be viewed, and determining, in response to the attribute of the object associated with the profile, a target segment in the video, where the target segment includes the object.

100. 发明授权

US10528562B2 Adaptive intersect query processing 有权
公开(公告)号：US10528562B2
公开(公告)日：2020-01-07
申请号：US15262538
申请日：2016-09-12
申请人： International Business Machines Corporation
发明人： Shuo Li , Heng Liu , Ke Wei Wei , Xin Ying Yang
IPC分类号： G06F17/30 , G06F16/2453 , G06F16/248 , G06F16/2455
摘要： A computer-implemented method includes identifying a query, including one or more predicates and one or more branches, wherein one or more branches includes one or more legs. The computer-implemented method further includes, for each branch, in parallel: determining a risk, determining a return row threshold, estimating a number of return rows; terminating access if the return rows exceed the threshold. The computer-implemented method further includes, for each leg, in parallel: determining a leg return row threshold; accessing the leg; fetching one or more return rows into one or more leg return row pages; terminating access if the return rows exceed the threshold; intersecting one or more leg return row pages into one or more intersected leg return row pages; and applying the one or more predicates to the one or more intersected leg return row pages. The method may be embodied in a corresponding computer system or computer program product.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式