-
公开(公告)号：US10891111B2
公开(公告)日：2021-01-12
申请号：US16279604
申请日：2019-02-19
Applicant: International Business Machines Corporation
Inventor： Shuo Li , Xin Peng Liu , Meng M. Wan , Chen Xin Yu
Abstract: A processor within a networked distributed drafting platform generates a public key-value context file that includes initial default key-value mappings between keywords and values for use in a distributed drafting project. Refined project-level key-value mappings are elected by considering differences between the initial default key-value mappings and personal key-value mappings within a set of distributed personal key-value context files each maintained by different drafters of the distributed drafting project. The initial default key-value mappings of the public key-value context file are updated with the elected refined project-level key-value mappings within the networked distributed drafting platform.
-
公开(公告)号：US20180173775A1
公开(公告)日：2018-06-21
申请号：US15815229
申请日：2017-11-16
Applicant: International Business Machines Corporation
Inventor： Shuo Li , Xin Peng Liu , Xiaobo Wang , Chong Yuan Yin , Chen Xin Yu
IPC: G06F17/30
CPC classification number: G06F16/254 , G06F16/24568
Abstract: A database processing system includes a coordinator agent controller and a virtual node data base. The coordinator agent controller detects a request to access a database by an application program and to extracts database objects from a database protocol stream based on a requirement requested by the application program. The virtual node database is generated according to the extracted database objects. The virtual node database includes memory dump storage that stores the database objects extracted from the database protocol stream, and based on the database objects the virtual node database generates virtual database objects corresponding to the database protocol stream. The extraction of database objects is performed directly on the database protocol stream without communicating with a target real database.
-
公开(公告)号：US10885052B2
公开(公告)日：2021-01-05
申请号：US15815229
申请日：2017-11-16
Applicant: International Business Machines Corporation
Inventor： Shuo Li , Xin Peng Liu , Xiaobo Wang , Chong Yuan Yin , Chen Xin Yu
IPC: G06F16/00 , G06F16/25 , G06F16/2455
Abstract: A database processing system includes a coordinator agent controller and a virtual node data base. The coordinator agent controller detects a request to access a database by an application program and to extracts database objects from a database protocol stream based on a requirement requested by the application program. The virtual node database is generated according to the extracted database objects. The virtual node database includes memory dump storage that stores the database objects extracted from the database protocol stream, and based on the database objects the virtual node database generates virtual database objects corresponding to the database protocol stream. The extraction of database objects is performed directly on the database protocol stream without communicating with a target real database.
-
公开(公告)号：US10585890B2
公开(公告)日：2020-03-10
申请号：US15335724
申请日：2016-10-27
Applicant: International Business Machines Corporation
Inventor： Shuo Li , Ke Wei Wei , Xin Ying Yang , Chen Xin Yu
IPC: G06F16/2453 , G06F16/14
Abstract: Aspects of the present disclosure relate to an approach for generating query execution plans for a database query. A computer-implemented method comprises determining whether a size of a file to be generated during execution of a database query is variable in response to obtaining the database query. The method further comprises determining a plurality of ranges for the size of the file in response to determining that the size of the file is variable. The method further comprises generating a plurality of query execution plans corresponding to the plurality of ranges. Accordingly, a plurality of query execution plans corresponding to different file sizes can be generated for the database query, and an efficient and cost effective query execution plan may be selected based on the actual file size during the execution of the database query.
-
公开(公告)号：US20180173773A1
公开(公告)日：2018-06-21
申请号：US15385501
申请日：2016-12-20
Applicant: International Business Machines Corporation
Inventor： Shuo Li , Xin Peng Liu , Xiaobo Wang , Chong Yuan Yin , Chen Xin Yu
IPC: G06F17/30
Abstract: A database processing system includes a coordinator agent controller and a virtual node data base. The coordinator agent controller detects a request to access a database by an application program and to extracts database objects from a database protocol stream based on a requirement requested by the application program. The virtual node database is generated according to the extracted database objects. The virtual node database includes memory dump storage that stores the database objects extracted from the database protocol stream, and based on the database objects the virtual node database generates virtual database objects corresponding to the database protocol stream. The extraction of database objects is performed directly on the database protocol stream without communicating with a target real database.
-
Patent Agency Ranking
公开(公告)号：US09495419B1
公开(公告)日：2016-11-15
申请号：US15045522
申请日：2016-02-17
Applicant: International Business Machines Corporation
Inventor： Shuo Li , Ping Liang , Ke Wei Wei , Xin Ying Yang , Chen Xin Yu
IPC: G06F17/30
CPC classification number: G06F17/30474 , G06F17/30327 , G06F17/30463 , G06F17/30471
Abstract: Optimization of a multi-index database access at runtime. A processor receives a query. A processor determines a plan and an RID results threshold for the plan, wherein the plan includes an access to the index. A processor determines a static risk threshold, a static risk for the access, and whether the static risk exceeds the static risk threshold. Responsive to the static risk exceeding the static risk threshold, a processor determines a risk bound for the access, and links the access to the risk bound. A processor accesses the index with the key. Responsive to the access being linked to a risk bound, a processor determines a dynamic risk for the access. A processor receives one or more RID results during the execution of the plan. A processor aborts the execution of the plan if a quantity of the RID results is less than the RID results threshold.
Abstract translation: 在运行时优化多索引数据库访问。 处理器接收查询。 处理器确定计划的计划和RID结果阈值，其中计划包括对索引的访问。 处理器确定静态风险阈值，访问的静态风险以及静态风险是否超过静态风险阈值。 响应于超过静态风险阈值的静态风险，处理器确定访问的风险，并将访问链接到风险限制。 处理器使用密钥访问索引。 响应于与风险限制相关联的访问，处理器确定访问的动态风险。 处理器在执行计划期间接收一个或多个RID结果。 如果RID结果的数量小于RID结果阈值，则处理器中止计划的执行。
-
公开(公告)号：US10528586B2
公开(公告)日：2020-01-07
申请号：US15385501
申请日：2016-12-20
Applicant: International Business Machines Corporation
Inventor： Shuo Li , Xin Peng Liu , Xiaobo Wang , Chong Yuan Yin , Chen Xin Yu
IPC: G06F16/00 , G06F16/25 , G06F16/2455
Abstract: A database processing system includes a coordinator agent controller and a virtual node data base. The coordinator agent controller detects a request to access a database by an application program and to extracts database objects from a database protocol stream based on a requirement requested by the application program. The virtual node database is generated according to the extracted database objects. The virtual node database includes memory dump storage that stores the database objects extracted from the database protocol stream, and based on the database objects the virtual node database generates virtual database objects corresponding to the database protocol stream. The extraction of database objects is performed directly on the database protocol stream without communicating with a target real database.
-
公开(公告)号：US10078570B2
公开(公告)日：2018-09-18
申请号：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: G06F16/2379 , G06F16/217 , G06F16/221 , G06F16/2322 , G06F16/283
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.
-
公开(公告)号：US20170344454A1
公开(公告)日：2017-11-30
申请号：US15658429
申请日：2017-07-25
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.
-
公开(公告)号：US20170228431A1
公开(公告)日：2017-08-10
申请号：US15581013
申请日：2017-04-28
Applicant: International Business Machines Corporation
Inventor： Shuo Li , Ping Liang , Ke Wei Wei , Xin Ying Yang , Chen Xin Yu
IPC: G06F17/30
CPC classification number: G06F17/30474 , G06F17/30327 , G06F17/30463 , G06F17/30471
Abstract: Optimization of a multi-index database access at runtime. A processor receives a query. A processor determines a plan and a record identifier (RID) results threshold for the plan, wherein the plan includes an access to the index. A processor determines a static risk threshold, a static risk for the access, and whether the static risk exceeds the static risk threshold. Responsive to the static risk exceeding the static risk threshold, a processor determines a risk bound for the access, and links the access to the risk bound. A processor accesses the index with the key. Responsive to the access being linked to a risk bound, a processor determines a dynamic risk for the access. A processor receives one or more RID results during the execution of the plan. A processor aborts the execution of the plan if a quantity of the RID results is less than the RID results threshold.
-
-
-
-
-
-
-
-
-
Search Results
21
records
(took 0.018 seconds)
