Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data routing method and device based on database distributed storage

A distributed storage and data routing technology, applied in the direction of electronic digital data processing, special data processing applications, digital data information retrieval, etc., can solve the problems of increasing the complexity of data query, so as to alleviate the access pressure, simplify the access process, The effect of masking differences

Pending Publication Date: 2019-07-23
PING AN TECH (SHENZHEN) CO LTD
View PDF2 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, from the user's point of view, they do not want to increase the complexity of data query due to database sub-databases

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 routing method and device based on database distributed storage
  • Data routing method and device based on database distributed storage
  • Data routing method and device based on database distributed storage

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0019] The invention provides a data routing method, device, computer equipment and storage medium based on distributed storage of databases. The method is aimed at the data routing of databases that have been divided into databases and tables. For users, access to the original The original data query statement of the database (the database before sub-database sub-table) is queried. After re...

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 provides a data routing method and device based on database distributed storage. The method comprises the following steps: receiving an original data query statement for accessing an original database; performing content analysis on the original data query statement to obtain metadata of the original data query statement; rewriting the original data query statement into a plurality of new data query statements according to a table definition rule; routing each new data query statement according to a routing rule; executing each new data query statement according to the routing result; aggregating the data obtained after executing each new data query statement according to the aggregation information; and outputting an aggregated result as a query result of the original data query statement. According to the method and the device, distributed storage is utilized to elastically expand database storage, so that the access pressure of a large database is relieved, and the usedifference of sub-databases and sub-tables is shielded.

Description

technical field [0001] The present invention relates to the technical field of distributed storage in cloud storage, in particular to a data routing method, device, computer equipment and storage medium based on database distributed storage. Background technique [0002] As the amount of data increases, the query speed of querying data in the database becomes slower and slower. In order to increase the speed of data query, the database can be stored in a distributed manner. Specifically, the database can be divided into databases and tables , thereby alleviating the access pressure of large-capacity databases. However, from the user's point of view, they do not want to increase the complexity of data query due to database sub-databases. [0003] Therefore, a method, device, computer equipment, and storage medium for data routing based on distributed storage of a database are provided, which can alleviate database access pressure through database sub-database and sub-table, ...

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
IPC IPC(8): G06F16/2458G06F16/2455
CPCG06F16/2471G06F16/24556Y02D10/00
Inventor 王冬冬
Owner PING AN TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com