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

System and method for balancing load according to content to be inquired

A load balancing and content technology, applied in the field of database query or statistical system, can solve problems such as inconvenient use and poor concurrency performance, and achieve the effect of increasing input costs, reducing parallel computing, and improving concurrent access capabilities

Inactive Publication Date: 2017-01-18
SHANGHAI JUSHU INFORMATION TECH CO LTD
View PDF6 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When there are large concurrent accesses, the concurrent performance of the system will be relatively poor, which brings inconvenience to people's use

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
  • System and method for balancing load according to content to be inquired
  • System and method for balancing load according to content to be inquired
  • System and method for balancing load according to content to be inquired

Examples

Experimental program
Comparison scheme
Effect test

specific Embodiment 1

[0028] refer to Figure 3-4 , image 3 It is a schematic diagram of a source database with a large amount of data. This source database includes four data tables: Store table, Sales table, Time table and Product table, the data volumes are 400,000, 100 million, 1825 and 1000 respectively. First, the data in the source database should be divided and distributed to each node database. Since the data volume of the Store table and the Sales table is relatively large, and the data volume of the Time table and the Product table is not large, the Store table and the Sales table are divided according to the Store field, and the Time table and the Product table are not divided, and are directly copied to each node database . When splitting the data, you can also add the city field and the region field for sorting, so as to ensure that the data of a city or a region is in a node database or an adjacent node database.

[0029]Next, index information is formed according to the segment...

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 system for balancing a load according to a content to be inquired. The system comprises a data portioning server, a master server, a node server and a front end display module, and the master server comprises a node index storage unit, a thread distribution unit, a simplifying unit, a main processor and a temporary table storage unit. The invention further discloses a method for balancing the load according to the content to be inquired. By means of parallel computation of a plurality of nodes, the calculation of a large database is distributed to a plurality of node databases, the capability of computing through multiple machines and cores is played, and the query speed or the statistical speed of the database with a large data volume is greatly increased. The load of the content to be inquired is balanced to reduce unnecessary concurrent computation, the concurrent access capability of the whole system is improved by times or dozens of times under the same hardware condition, the system and the method do not rely on special hardware or network, and can be implemented through a common PC and a gigabit network or even a 100 M network, and the cost performance is very high.

Description

technical field [0001] The invention relates to a database query or statistics system, in particular to a system for load balancing according to query content. Background technique [0002] With the development and popularization of computer technology, large-scale databases have rapidly entered various industries such as telecommunications and finance. SQL (Structured Query Language, Structured Query Language) is a set of operation commands specially established for databases, and it is a database language. The main function of SQL is to establish relationships with various databases and enable communication between different types of databases. According to ANSI (American National Standards Institute), SQL is used as a standard language for relational database management systems. When using SQL, you only need to issue the "what to do" command without thinking about "how to do it". SQL statements can be used to perform various operations on the database, such as updating...

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): G06F17/30
CPCG06F16/2453G06F16/2471
Inventor 李晓华
Owner SHANGHAI JUSHU INFORMATION TECH 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