Unlock instant, AI-driven research and patent intelligence for your innovation.

Data query method and device, electronic equipment and storage medium

A data query and database technology, applied in the database field, can solve problems such as implementation complexity, and achieve the effect of reducing complexity, saving local storage resources, and being highly portable.

Pending Publication Date: 2020-09-25
TENCENT TECH (SHENZHEN) CO LTD
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, once the data in the original database changes, the data in the view table needs to be updated synchronously. Therefore, the scheme of querying data from the locally stored view table requires relevant algorithm strategies for continuous data update, which is more complicated to implement

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
  • Data query method and device, electronic equipment and storage medium
  • Data query method and device, electronic equipment and storage medium
  • Data query method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] In order to make the purpose, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application.

[0047] For the convenience of understanding, the nouns involved in the embodiments of the present application are explained below:

[0048] Cloud technology refers to a hosting technology that unifies a series of resources such as hardware, software, and network in a wide area network or a local area network to realize data calculation, storage, processing, and sharing. Cloud technology is a general term for network technology, information technology, integration technology, management platform technology, application technology, etc. based on cloud computing business model applications. It can form a resource pool and be used on demand, which is flexible an...

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 relates to the technical field of databases, and discloses a data query method and device, electronic equipment and a storage medium, which do not need to develop and maintain a complexdata sustainable update algorithm strategy, reduce the implementation complexity of data query, do not need to locally store data in a view table, and save storage resources. The method comprises thesteps of obtaining a first query statement used for indicating to query specified data from a view table, wherein the view table is generated based on an original query statement, and the original query statement is used for indicating to query data from a specified database; modifying the first query statement based on the original query statement to obtain a second query statement used for indicating to query specified data from a specified database; and obtaining specified data based on the second query statement.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a data query method, device, electronic equipment and storage medium. Background technique [0002] When developing products and systems related to data visualization analysis, the data queried based on user-input SQL (Structured Query Language, Structured Query Language) is often used as the data source of the visual report, and the generated view table is stored locally. In this way, users can use new SQL statements to directly query data from locally stored view tables, and realize secondary processing of data in view tables, such as querying, filtering, grouping, sorting, etc., to obtain better data analysis result. However, once the data in the original database changes, the data in the view table needs to be updated synchronously. Therefore, the scheme of querying data from the locally stored view table requires relevant algorithm strategies for continuous data...

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/242G06F16/23
CPCG06F16/23G06F16/2433
Inventor 张晓锋
Owner TENCENT TECH (SHENZHEN) CO LTD