Database optimization method based on WiMAX local routing

An optimization method and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of increased database server load performance requirements, operators' operating cost burden, etc., to achieve fast and high-quality services and reduce performance requirements , the effect of reducing the delay

Active Publication Date: 2014-05-21
NANJING UNIV OF POSTS & TELECOMM
View PDF5 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At the same time, as the number of users in the CSN continues to increase, the load performance requirements on the performance of the database server are also increasing. The general solution is to replace the database server with better performance and larger storage space, which will undoubtedly increase the operating costs of operators. bring burden

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 optimization method based on WiMAX local routing
  • Database optimization method based on WiMAX local routing
  • Database optimization method based on WiMAX local routing

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] In order to better understand the technical content of the present invention, specific embodiments are given together with the attached drawings for description as follows.

[0038] In general, the present invention proposes a database optimization method based on WiMAX local routing, adopts a fragmentation optimization method based on user IP address and database operation frequency improvement, and uses the user information in the CSN user database according to the user IP address according to a certain The rules are transferred to other physical servers to form a shard cluster, and the database route is set in the CSN user database. When querying user information, the IP address of the called user is sent to the database route. The database route is selected according to the above rules in the corresponding Shards query called user information, and database routing distributes user information stored in each shard in real time according to an improved algorithm based ...

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 database optimization method based on WiMAX local routing. A sharding optimization method based on user IP addresses and database operation frequency improvement is used for transferring user information in a CSN user database to other physical servers through certain rules according to the user IP addresses so as to form a sharding cluster, a database router is arranged in the CSN user database, when the user information is inquired, the IP address of a called user is sent to the database router, the database router is used for inquiring the information of the called user at a corresponding sharding according to the rules, and the database router is used for distributing the user information stored in all the shardings in real time according to an algorithm based on database operation frequency improvement so as to enable all sharding servers to reach load balance. By means of the database optimization method, the query management efficiency of the CSN user database at high concurrent reading can be improved, meanwhile, the operating cost of operator servers can be lowered, and rapid and high-quality communication service can be provided for users.

Description

technical field [0001] The invention relates to the technical field of databases in computer mobile communications, in particular to a database optimization method based on WiMAX local routing. Background technique [0002] With the development of 3G technology attracting much attention today, WiMAX (Global Interconnection for Microwave Access) technology, as an emerging wireless broadband technology, can provide "last mile" broadband connectivity in a wider geographical range than Wi-Fi. This supports enterprise customers to enjoy T1 services and residential users to have access capabilities equivalent to cable / DSL. Due to its excellent performance and good development prospects, it occupies a place in the field of communication at home and abroad, and will serve as a powerful driving force to promote the development of communication. [0003] At the same time, the WiMAX system, which is an extension of the Internet, generates a large amount of user data every day, and how...

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/215G06F16/2453
Inventor 潘甦周炜
Owner NANJING UNIV OF POSTS & TELECOMM
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