-
公开(公告)号:US20170344453A1
公开(公告)日:2017-11-30
申请号:US15165368
申请日:2016-05-26
Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventor: Xiao Di Deng , Shuo Li , Shu Hua Liu , Wei Liu , Meng Wan , Xiaobo Wang , Xin Ying Yang , Chen Xin Yu , Xiong Wei Zhao
CPC classification number: G06F11/3452 , G06F17/30306 , G06F17/30315 , G06F17/30353 , G06F17/30377 , G06F17/30592
Abstract: A method for dynamically updating database statistics and a plurality of access paths associated with at least one database table is provided. The method may include identifying at least one dynamically changing column associated with the at least one database table. The method may further include determining at least one predicate pattern associated with the identified at least one dynamically changing column. Additionally, the method may include dynamically detecting at least one range change associated with the determined at least one predicate pattern based on at least one record insert. The method may also include updating the plurality of database statistics associated with the identified at least one dynamically changing column based on the dynamically detected at least one range change. The method may further include determining at least one filter factor based on the updated plurality of database statistics associated with the identified at least one dynamically changing column.
-
公开(公告)号:US09753978B2
公开(公告)日:2017-09-05
申请号:US15366523
申请日:2016-12-01
Applicant: International Business Machines Corporation
Inventor: Shuo Li , Meng Wan , Xiaobo Wang , Xin Ying Yang
IPC: G06F17/30
CPC classification number: G06F17/30474 , G06F17/30451 , G06F17/30457 , G06F17/3046 , G06F17/30469 , G06F17/30492
Abstract: A tool for combining common processes shared by at least two or more sub-queries within a query is provided. The tool determines the query with the at least two or more sub-queries. 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. The tool determines an access path for the query. The tool executes the access path during run-time for data accessing.
-
公开(公告)号:US20170124087A1
公开(公告)日:2017-05-04
申请号:US15049705
申请日:2016-02-22
Applicant: International Business Machines Corporation
Inventor: Xiao Di Deng , Shuo Li , Meng Wan , Xin Ying Yang
IPC: G06F17/30
CPC classification number: G06F17/3053 , G06F17/30011 , G06F17/30442 , G06F17/30528 , G06F17/30699
Abstract: 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.
-
公开(公告)号:US20170124081A1
公开(公告)日:2017-05-04
申请号:US14929574
申请日:2015-11-02
Applicant: International Business Machines Corporation
Inventor: Xiao Di Deng , Shuo Li , Meng Wan , Xin Ying Yang
IPC: G06F17/30
CPC classification number: G06F17/3053 , G06F17/30011 , G06F17/30442 , G06F17/30528 , G06F17/30699
Abstract: 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.
-
公开(公告)号:US09569496B1
公开(公告)日:2017-02-14
申请号:US15067560
申请日:2016-03-11
Applicant: International Business Machines Corporation
Inventor: Shuo Li , Meng Wan , Xiaobo Wang , Xin Ying Yang
IPC: G06F17/30
CPC classification number: G06F17/30474 , G06F17/30451 , G06F17/30457 , G06F17/3046 , G06F17/30469 , G06F17/30492
Abstract: A tool for combining common processes shared by at least two or more sub-queries within a query is provided. The tool determines the query with the at least two or more sub-queries. 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. The tool determines an access path for the query. The tool executes the access path during run-time for data accessing.
Abstract translation: 提供了用于组合查询内的至少两个或多个子查询共享的公共进程的工具。 该工具使用至少两个或多个子查询确定查询。 所述工具确定在所述至少两个或更多个子查询之间是否共享一个或多个子集关系。 响应于确定在所述至少两个或更多个子查询之间共享一个或多个子集合关系,所述工具基于所述一个或多个子集合关系确定所述至少两个或更多个子查询的订单类别。 该工具确定查询的访问路径。 该工具在运行时执行访问路径以进行数据访问。
-
公开(公告)号:US20240428126A1
公开(公告)日:2024-12-26
申请号:US18339407
申请日:2023-06-22
Applicant: International Business Machines Corporation
Inventor: MING QIAO SHANG GUAN , Mai Zeng , Meng Wan , Xin Xin Dong , Sheng Yan Sun , Wei Song , Wen Zhong Liu
IPC: G06N20/00
Abstract: One or more systems, devices, computer program products and/or computer-implemented methods of use provided herein relate to training an AI model to predict status of a DBMS. The computer-implemented system can comprise a memory that can store computer executable components. The computer-implemented system can further comprise a processor that can execute the computer executable components stored in the memory, wherein the computer executable components can comprise a data ingestion component that can use testing data of an AI model to generate ingested data by randomly changing one or more records of at least one feature comprised in the testing data, wherein the ingested data can be used to compute a first ratio indicative of inequity of the at least one feature. The computer executable components can further comprise a training component that can train the AI model using at least the first ratio to predict a status of system.
-
公开(公告)号:US12147886B2
公开(公告)日:2024-11-19
申请号:US17060165
申请日:2020-10-01
Applicant: International Business Machines Corporation
Inventor: Meng Wan , Li Na Guo , Wang Liu , Xue Rui Hu , Mei Qin Si , Hong Yan Zhang
IPC: G06N3/04 , G06F18/10 , G06F18/21 , G06F18/213 , G06F18/214 , G06N3/08 , H04L67/133 , H04L67/51
Abstract: Described are techniques for predictive microservice activation. The techniques include training a machine learning model using a plurality of sequences of coordinates, where the plurality of sequences of coordinates are respectively based upon a corresponding plurality of series of vectors generated from historical usage data for an application and its associated microservices. The techniques further include inputting a new sequence of coordinates representing a series of application operations to the machine learning model. The techniques further include identifying a predicted microservice for future utilization based on an output vector generated by the machine learning model. The techniques further include activating the predicted microservice prior to the predicted microservice being called by the application.
-
公开(公告)号:US12147330B2
公开(公告)日:2024-11-19
申请号:US17481399
申请日:2021-09-22
Applicant: International Business Machines Corporation
Inventor: Xue Rui Hu , Wang Liu , Meng Wan , Mei Qin Si , Li Na Guo , Hong Yan Zhang
Abstract: In an approach for smart test data workload generation, a processor receives a plurality of expected image frames for a user interface application to be tested. The plurality of expected image frames is pre-defined and represents a series of workflows and operations of the user interface application to be expected based on a design requirement. A processor calculates a first set of hash-values for each corresponding expected image frame. A processor samples the user interface application with a frequency to a plurality of testing image frames during a test run on the user interface application. A processor calculates a second set of hash-values for each sampled testing image frame. A processor compares the first set of hash-values to the second set of hash-values. A processor verifies that the second set of hash-values matches the first set of hash-values.
-
公开(公告)号:US11914586B2
公开(公告)日:2024-02-27
申请号:US17709802
申请日:2022-03-31
Applicant: International Business Machines Corporation
Inventor: Hong Mei Zhang , Sheng Yan Sun , Meng Wan , Peng Hui Jiang
IPC: G06F16/2453 , G06F11/34 , G06F16/22 , G06F16/25
CPC classification number: G06F16/2453 , G06F11/3409 , G06F16/2255 , G06F16/2282 , G06F16/256
Abstract: An embodiment includes generating a partition schema for a distributed database based on historical usage data indicative of usage of the distributed database, where the generating of the partition schema comprises determining a partition range of a partition of the partition schema. The embodiment also includes generating a node identifier for the partition using a hash function and a first weight value assigned to the partition. The embodiment also includes monitoring performance data indicative of a performance of the distributed database, the monitoring comprising detecting a failure of the performance to satisfy a performance threshold. The embodiment also includes initiating, responsive to detecting the failure, a redistribution procedure by changing the node identifier of the partition by replacing the first weight value with a second weight value.
-
公开(公告)号:US11874830B2
公开(公告)日:2024-01-16
申请号:US17654110
申请日:2022-03-09
Applicant: International Business Machines Corporation
Inventor: Sheng Yan Sun , Hong Mei Zhang , Meng Wan , Peng Hui Jiang
IPC: G06F16/2453 , G06F16/242 , G06F11/34 , G06F16/23
CPC classification number: G06F16/24542 , G06F11/3409 , G06F16/2386 , G06F16/2433
Abstract: In a computer-implemented method for improving performance of a database, a processor receives batch jobs for a relational database. The batch jobs may include a first member with a first buffer pool, and a second member with a second buffer pool. The processor may also identify a first actual object and an isolation level for the batch jobs, generate related queries based on the first actual object and the isolation level, calculate a cost for the first member and the second member to run the batch jobs based on the related queries, and assign the batch jobs to the first member based on a lower calculated cost.
-
-
-
-
-
-
-
-
-