Distributed database based sql statement processing method

A processing method and database technology, applied in the direction of electrical digital data processing, special data processing applications, database models, etc., can solve problems such as cross-node connections, exaggerated node sub-queries, troubles, etc., and achieve the effect of reducing costs and improving speed

Active Publication Date: 2016-12-14
杭州宇为科技有限公司
View PDF5 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to solve the above-mentioned problems existing in the prior art, and avoid the trouble of synchronizing online data to a data warehouse (such as hadoop or heterogeneous database); later data processing, including data analysis, data mining, machine learning; online data Problems such as cross-node connections, exaggerated node subqueries, etc. will be encountered in processing and post-data processing

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
  • Distributed database based sql statement processing method
  • Distributed database based sql statement processing method
  • Distributed database based sql statement processing method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0046] Suppose there are two tables in the system, user table tab_user_info and user login table tab_login_info.

[0047] The user table tab_user_info is as follows:

[0048] field

field description

Field Type

u_id

user id

int type

u_name

username

varchar

u_reg_dt

User registration time

timestamp

u_age

user age

int

[0049] The structure of the user login table tab_login_info is as follows:

[0050] field

field description

Field Type

u_id

user id

int

login_ip

login ip

int

login_dt

Log in time

timestamp

login_product

Which product to log into

varchar

[0051] An example record of the table is as follows:

[0052]

[0053]

[0054]If the number of nodes is num_node, u_id is a balanced field, and the maximum value of u_id is max_value-1 (0<=u_id<max_value), if the modulo hash algorithm is used, then the record ...

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 a distributed database based sql statement processing method and belongs to the technical field of storage and computing technology for online data processing and later data processing. The method is based on a distributed database, tables are stored in multiple database modes, sql statement input is performed and includes addition, deletion, modification and lookup operations, and sql execution results are output. The method is applied to insertion, update, deletion and query for online data processing and is especially applied to cross-node connection, cross-node sub-query and other complicated logics under the large data volume situation.

Description

technical field [0001] The invention relates to a method for processing sql statements based on a distributed database, which belongs to the technical field of online data processing and storage and calculation of later data processing. Online data processing has the characteristics of high concurrency and a large amount of data, and later data processing includes online Data synchronization to data warehouse, data analysis and mining, machine learning. Background technique [0002] With the increasing amount of data storage and calculation in practical applications, it is necessary to expand the independent database horizontally and store data in multiple database nodes according to a certain strategy. The idea of ​​sub-table in the prior art is realized. Data expansion. [0003] Under the sub-table architecture, it also brings computing troubles, that is, it must cross machines and different database instances, and some specific application scenarios such as connection, s...

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): G06F17/30
CPCG06F16/24556G06F16/273G06F16/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

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