Data query method and device based on incremental algorithm, and storage medium

A technology of data query and query method, applied in the field of databases, can solve the problems of high writing pressure and large amount of calculation in online service databases, and achieve the effect of reducing the amount of calculation and writing pressure

Pending Publication Date: 2022-03-22
大箴(杭州)科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In order to ensure the timeliness and correctness of users querying tags, related technologies calculate the query results of each tag once a day, and write the query results into the online database, which requires a large amount of calculation and high writing pressure on the online service database.

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 based on incremental algorithm, and storage medium
  • Data query method and device based on incremental algorithm, and storage medium
  • Data query method and device based on incremental algorithm, and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0058] Hereinafter, the present application will be described in detail with reference to the drawings and embodiments. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other.

[0059] In this embodiment, a data query method based on an incremental algorithm is provided, such as figure 1 As shown, the method includes:

[0060] Step 101, the data synchronization module reads the newly added data within the preset time period in the data warehouse, and writes the newly added data into the online service database through the online service interface module;

[0061] The data query method provided by the embodiment of the present application is based on an incremental algorithm, and writes the newly added offline data in the data warehouse into the online service database for calculation. Among them, the data warehouse guards the offline database of data development, proces...

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 data query method and device based on an incremental algorithm, a storage medium and computer equipment. The method comprises the steps that a data synchronization module reads newly-added data in a data warehouse within a preset time period, and writes the newly-added data into an online service database through an online service interface module; the online service interface module receives a data query instruction from a service calling party, and reads target data matched with a target query label in the data query instruction in an online service database; the label real-time calculation module reads the data processing rule configured in the rule management module, and processes the target data according to the data processing rule to obtain a query result of the target data; and the query result is fed back to the service calling party through the online service interface module. According to the method, only the newly added data is written into the online service database, the writing pressure of the online service database is reduced, in addition, the query result is calculated only when the query instruction is received, and the calculation amount is low.

Description

technical field [0001] The present application relates to the field of databases, in particular to a data query method and device, storage medium and computer equipment based on an incremental algorithm. Background technique [0002] Many systems contain a large number of users and their corresponding labels, such as the number of loans of users in the past 180 days. In order to ensure the timeliness and correctness of users querying tags, related technologies calculate the query results of each tag once a day and write the query results into the online database, which requires a large amount of calculation and high writing pressure on the online service database. Contents of the invention [0003] In view of this, the present application provides an incremental algorithm-based data query method and device, storage medium and computer equipment, which help to reduce the amount of calculation and reduce the writing pressure of the online service database. [0004] Accordin...

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/2458G06F16/27G06F16/28
CPCG06F16/2458G06F16/2474G06F16/27G06F16/283
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