Data query method and device, electronic equipment, computer program product and computer readable storage medium
CN118035270BActive Publication Date: 2026-08-28TENCENT TECHNOLOGY (SHENZHEN) CO LTD
Patent Information
- Application Number
- CN202211389714.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-11-08
- Publication Date
- 2026-08-28
- Estimated Expiration
- 2042-11-08
AI Technical Summary
Technical Problem
[0003]根据用户的使用需求，需要基于物化视图进行数据查询，但是相关技术中仅能支持全量的物化视图更新，降低了数据处理计算引擎的性能，如果强行指定进行物化视图更新，则会降低物化视图的性能，同时影响数据查询结果的准确性
Benefits of technology
本发明实施例通过获取与所述原始结构化查询语言指令相匹配的第一物化视图；利用所述第一物化视图的元数据，对所述原始结构化查询语言指令进行改写，得到目标结构化查询语言指令；当所述第一物化视图的物理数据为分区表类型时，对所述目标结构化查询语言指令相匹配的第二物化视图进行谓词补偿，得到第三物化视图；在所述第三物化视图中进行数据查询，得到所述原始结构化查询语言指令的查询结果，由此，通过对物化视图进行谓词补偿，可以保证计算引擎的性能，也保证物化视图的性能，获得准确地数据查询结果。
✦ Generated by Eureka AI based on patent content.
Smart Images
Figure CN118035270B_ABST
Abstract
The application provides a data query method and device, electronic equipment, computer program product and computer readable storage medium, the method comprises: using the metadata of the first materialized view, rewriting the original structured query language instruction, obtaining the target structured query language instruction; when the physical data of the first materialized view is the partition table type, the second materialized view matched with the target structured query language instruction is compensated by the predicate, and the third materialized view is obtained; data query is carried out in the third materialized view, and the query result of the original structured query language instruction is obtained, so that the performance of the computing engine can be ensured by compensating the predicate of the materialized view, the performance of the materialized view is also ensured, and accurate data query result is obtained.
Need to check novelty before this filing date? Find Prior Art
Citation Information
Patent Citations
Stored procedures for incremental updates to internal tables for materialized views
US11354304B1
System and method for optimizing queries using materialized views and fast view matching
US20030093415A1