Database query method and system

A query method and database technology, which are used in electrical digital data processing, special data processing applications, digital data information retrieval, etc., can solve problems such as inapplicability for repeated use, high memory usage of large-scale data, and low query efficiency for large-scale data.

Active Publication Date: 2021-05-11
SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
View PDF16 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The technical task of the present invention is to provide a database query method and system for the above deficiencies, which can solve the low efficiency of a large number of data queries in the traditional database query method , The high memory usage of large batches of data affects system performance, and it is not suitable for scenarios where the same batch of data is used repeatedly

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
  • Database query method and system
  • Database query method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] The present invention will be further described below in conjunction with the accompanying drawings and specific embodiments.

[0056] The embodiment of the present invention provides a kind of database query method, and this method is based on KV storage engine, and the data that database is queried from disk according to user-defined SELECT statement is stored in this KV storage engine;

[0057] Define metadata for the data collection queried by users, and record data information;

[0058] The metadata status information of the queried batch of data at different time nodes is recorded through the status recorder, and the metadata changes caused by the operation are recorded in the status recorder every time the data is operated.

[0059] This method stores the data queried from the disk by the database according to the SELECT statement defined by the user into the KV storage engine, which effectively reduces the IO operations with the disk when the queried data is use...

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 database query method and system, and belongs to the technical field of data query; the method includes, based on a KV storage engine, storing data queried from a disk by a database according to a SELECT statement defined by a user in the KV storage engine; defining metadata for a data set queried by a user, and recording data information; recording metadata state information of the batch of queried data at different time nodes through a state recorder, and recording metadata changes caused by operation into the state recorder when the data are operated every time. The problems that a traditional database query method is low in large-batch data query efficiency, large-batch data memory occupation is high, system performance is affected, and the traditional database query method is not suitable for scenes where the same batch of data is repeatedly used can be solved. The performance of repeatedly using the query data is remarkably improved, the disk loss is reduced, the function is expanded, and the operation convenience is improved.

Description

technical field [0001] The invention relates to the technical field of data query, in particular to a database query method and system. Background technique [0002] The main operations of the database are SELECT, INSERT, UPDATE, DELETE, and SELECT query data is the most common operation in the database. The SELECT query operation needs to go through the following stages: the user initiates a custom query statement to the database, and the database parses and optimizes the query statement into an expression recognized by the database after receiving the query statement, executes it on the storage node, loads the data from the hard disk into the memory, and The data is parsed and returned and displayed to the user. [0003] The disadvantage of this method is: the larger the amount of data queried by the query operation, the more data is loaded into the memory, the slower the speed, and the greater the pressure on the storage of the node, it is easy to affect performance, and...

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/2455G06F16/2453G06F16/242
CPCG06F16/24553G06F16/2453G06F16/2433Y02D10/00
Inventor 刘浩喆齐光鹏齐亮
Owner SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
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