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

1. 发明公开

EP4303743A2 LEARNING-BASED QUERY PLAN CACHE FOR CAPTURING LOW-COST QUERY PLAN 审中-实审
公开(公告)号：EP4303743A2
公开(公告)日：2024-01-10
申请号：EP23211055.1
申请日：2019-05-24
申请人： Huawei Technologies Co., Ltd.
发明人： HU, Ron-Chung , GHAZAL, Ahmad , ZHANG, Mingyi
IPC分类号： G06F18/21
摘要： A query processing device is provided, including a processor coupled to a communication interface and a query storage. The processor receives a current submission of a query in a training mode, a stored prior execution plan, and stored statistics for the prior execution plan. The processor generates a current execution plan for the query, executes the current execution plan, and collects statistics. The processor stores the current execution plan and the statistics in the query storage and determines, based on the current execution plan, that the query is not in the training mode. The processor selects an execution plan for the query from among a plurality of stored execution plans for the query, including the prior execution plan and the current execution plan, and stores the selected execution plan for the query in the query storage with an indication that the query is not in the training mode.

2. 发明公开

EP3170110A1 METHOD AND SYSTEM FOR ADAPTIVELY BUILDING A COLUMN STORE DATABASE FROM A TEMPORAL ROW STORE DATABASE BASED ON QUERY DEMANDS 有权
标题翻译：的方法和系统用于基于QUERY REQUEST用线存储器中的临时数据库列存储的数据库自适应施工
公开(公告)号：EP3170110A1
公开(公告)日：2017-05-24
申请号：EP15842381.4
申请日：2015-09-15
申请人： Huawei Technologies Co. Ltd.
发明人： HU, Ron-Chung , SHI, Guangyu , MORTAZAVI, Masood , KU, Chi Yong , CHEN, Mengmeng
IPC分类号： G06F17/30
CPC分类号： G06F16/24544 , G06F16/21 , G06F16/221 , G06F16/2379 , G06F16/283
摘要： A method for dynamically building a column store database from a row store database. The method includes establishing the row store database for storing data, wherein each row includes a plurality of attributes, and wherein data in row store database is current to a temporal point in time. The method includes establishing the column store database including data structured to satisfy received analytic queries. The method includes beginning from an initial state of the column store database, for each subsequently received analytic query, importing a targeted amount of data from a corresponding temporal state of the row store database into the column store database to satisfy the corresponding subsequently received analytic query.
摘要翻译：一种从行存储数据库动态生成列存储数据库的方法。该方法包括建立行存储数据库，用于存储数据，worin每行包括属性的行存储数据库中的多个，并且worin数据是电流在时间的时间点。该方法包括建立列存储数据库，包括构造成满足接收到的分析查询的数据。该方法包括从在列存储数据库的初始状态开始，对于每个随后接收的解析查询，导入数据的目标量从行存储数据库的一个相应的时间状态成列存储数据库，以满足相应的随后接收到的解析查询，

3. 发明公开

EP3108388A1 SYSTEM AND METHOD FOR COLUMN-SPECIFIC MATERIALIZATION SCHEDULING 审中-公开
标题翻译：系统和方法列的具体实施方案中规划
公开(公告)号：EP3108388A1
公开(公告)日：2016-12-28
申请号：EP15764647.2
申请日：2015-03-21
申请人： Huawei Technologies Co. Ltd.
发明人： KU, Chi Young , HU, Ron-Chung , CHEN, Mengmeng
IPC分类号： G06F17/30
CPC分类号： G06F17/30315 , G06F17/30463 , G06F17/30598 , G06F17/30864 , G06F17/30935
摘要： A method of dynamically computing an optimal materialization schedule for each column in a column oriented RDBMS. Dynamic column-specific materialization scheduling in a distributed column oriented RDBMS is optimized by choosing a materialization strategy based on execution cost including central processing unit (CPU), disk, and network costs for each individual exchange operator. The dynamic programming approach is computationally feasible because the optimal schedule for a sub-plan is path independent.

4. 发明公开

EP4303743A3 LEARNING-BASED QUERY PLAN CACHE FOR CAPTURING LOW-COST QUERY PLAN 审中-实审
公开(公告)号：EP4303743A3
公开(公告)日：2024-03-27
申请号：EP23211055.1
申请日：2019-05-24
申请人： Huawei Technologies Co., Ltd.
发明人： HU, Ron-Chung , GHAZAL, Ahmad , ZHANG, Mingyi
IPC分类号： G06F16/2452 , G06F16/2453 , G06F18/21
摘要： A query processing device is provided, including a processor coupled to a communication interface and a query storage. The processor receives a current submission of a query in a training mode, a stored prior execution plan, and stored statistics for the prior execution plan. The processor generates a current execution plan for the query, executes the current execution plan, and collects statistics. The processor stores the current execution plan and the statistics in the query storage and determines, based on the current execution plan, that the query is not in the training mode. The processor selects an execution plan for the query from among a plurality of stored execution plans for the query, including the prior execution plan and the current execution plan, and stores the selected execution plan for the query in the query storage with an indication that the query is not in the training mode.

5. 发明公开

EP3977308A1 LEARNING-BASED QUERY PLAN CACHE FOR CAPTURING LOW-COST QUERY PLAN 有权
公开(公告)号：EP3977308A1
公开(公告)日：2022-04-06
申请号：EP19731043.6
申请日：2019-05-24
申请人： Huawei Technologies Co., Ltd.
发明人： HU, Ron-Chung , GHAZAL, Ahmad , ZHANG, Mingyi
IPC分类号： G06F16/2453 , G06F16/2452

6. 发明授权

EP3170110B1 METHOD AND SYSTEM FOR ADAPTIVELY BUILDING A COLUMN STORE DATABASE FROM A TEMPORAL ROW STORE DATABASE BASED ON QUERY DEMANDS 有权
公开(公告)号：EP3170110B1
公开(公告)日：2020-02-26
申请号：EP15842381.4
申请日：2015-09-15
申请人： Huawei Technologies Co. Ltd.
发明人： HU, Ron-Chung , SHI, Guangyu , MORTAZAVI, Masood , KU, Chi Yong , CHEN, Mengmeng
IPC分类号： G06F16/22 , G06F16/23

7. 发明公开

EP3170109A1 METHOD AND SYSTEM FOR ADAPTIVELY BUILDING AND UPDATING COLUMN STORE DATABASE FROM ROW STORE DATABASE BASED ON QUERY DEMANDS 有权
标题翻译：基于式请求要求METHOD AND SYSTEM FOR ADAPTIVE创建和更新面向数据库从面向行的数据库中的列
公开(公告)号：EP3170109A1
公开(公告)日：2017-05-24
申请号：EP15841406.0
申请日：2015-09-15
申请人： Huawei Technologies Co. Ltd.
发明人： HU, Ron-Chung , SHI, Guangyu , MORTAZAVI, Masood , KU, Chi Yong , CAO, Fang
IPC分类号： G06F17/30
CPC分类号： G06F17/30563 , G06F17/30578
摘要： A method for adaptively building and updating a column store database from a row store database using queries. The method includes establishing the row store database for storing data, wherein at least one row of the row store includes attributes. The method includes establishing the column store including data structured to satisfy received analytic queries, wherein the column store includes attribute vectors corresponding to attributes in the row store, wherein at least one of the attribute vectors includes data used to satisfy previously received analytic queries. The method includes receiving change transactions directed to the row store, wherein the change transactions are ordered. The method includes when a first referenced attribute referenced by an analytic query corresponds to an attribute vector in the column store, updating the attribute vector based on log information corresponding to change transactions directed to the referenced attribute to satisfy the analytic query.
摘要翻译：一种用于自适应构建和使用查询行存储数据库更新列存储数据库的方法。该方法包括建立行存储数据库，用于存储数据，所述worin行存储中的至少一个行包括属性。该方法包括建立列存储的数据，包括结构化的，以满足接收分析查询，worin列存储包括属性矢量对应于所述行存储的属性，所述属性矢量的worin的至少一个包括用于满足先前接收到的分析查询的数据。该方法包括接收针对所述行存储改变的交易，worin变化交易是有序的。该方法包括：当通过在解析查询所引用的第一参考属性对应于属性矢量在列存储，基于日志信息对应于改变引导到参考属性以满足解析查询事务更新所述属性向量。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式