A cross-data-source SQL compiling device and method

A technology across data sources and user groups, applied in the field of big data

Active Publication Date: 2019-03-01
北京百分点科技集团股份有限公司
View PDF6 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, there is still a lack of a SQL compilation device and method based on PRESTODB

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A cross-data-source SQL compiling device and method
  • A cross-data-source SQL compiling device and method
  • A cross-data-source SQL compiling device and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] The present invention will be further described below in conjunction with the accompanying drawings. It should be noted that this embodiment is based on the technical solution, and provides detailed implementation and specific operation process, but the protection scope of the present invention is not limited to the present invention. Example.

[0038] Such as figure 1 As shown, a cross-data source SQL compilation device provided in this embodiment includes:

[0039] JSON query condition generation module: used to generate query conditions of JSON structure;

[0040] In this embodiment, the JSON generation module specifically generates a user group expression, and the query condition is encapsulated in the user group expression.

[0041] The user group expression includes the fields group_id, entity_english_name, type, prev_group_expression, group_expression, wherein:

[0042] group_id is used to record the id of the target user group to be queried. Through the id of...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a cross-data-source SQL compiling device and method. The device mainly comprises a JSON generation module, an SQL compiling tool, a final query SQL generation module, an SQL submission module, a request cache implementation module and the like. According to the method, the query condition is packaged through the JSON, the condition is analyzed, the SQL is formed and submitted to the PRESTODB, and the real-time query function of multiple scenes (conditions) can be achieved.

Description

technical field [0001] The present invention relates to the field of big data technology, in particular to a SQL compilation device and method based on PRESTODB across data sources, and is especially suitable for any combination of conditional scenarios including user behaviors and user portraits. Background technique [0002] PRESTODB is a distributed real-time computing engine, which is mainly used for real-time computing and analysis needs in the field of big data. It has excellent capabilities in ETL, data analysis, real-time query, etc. It also supports multi-data source joint query and flexible customization The connector function can realize the docking of different data sources through a custom connector. Because of the above advantages, PRESTODB is widely used in big data OLAP analysis. At present, there is still a lack of a SQL compiling device and method based on PRESTODB. Contents of the invention [0003] Aiming at the deficiencies of the prior art, the prese...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/25G06F16/242G06F8/41G06F8/30
CPCG06F8/31G06F8/41
Inventor 刘钰孙伟殷宏亮宋德龙赵丹高体伟
Owner 北京百分点科技集团股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap