System and method for database access for implementing load sharing

A load sharing and database technology, applied in the database field, can solve problems such as server bottlenecks

Inactive Publication Date: 2007-03-14
HUAWEI TECH CO LTD
View PDF0 Cites 22 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] In view of this, the purpose of the present invention is to provide a load sharing database access method and system to solve the problem of server bottlenecks without additional cost

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 database access for implementing load sharing
  • System and method for database access for implementing load sharing
  • System and method for database access for implementing load sharing

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] The idea of ​​the present invention is to make the auxiliary database share the load on the main control database, thereby solving the bottleneck problem without additional cost.

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

[0038] Fig. 2 is a schematic diagram of a database access process for implementing load sharing according to an embodiment of the present invention.

[0039] Step 201: After receiving the database access request from the application, the data agent determines the type of the access request according to the identifier in the database access request. If it is a data query request, execute step 202; if it is a data update request, execute step 203.

[0040] The aforementioned data query request includes a data query request, a data statistics request, a data analysis request, etc.; the aforementioned data update request includes a data addition request, a data deletion ...

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 disclosed loading-share method for database access comprises: once receiving access request, the database agent decides the request type; for data request, the agent accesses the assist database to execute operation and respond result, end; for data update, the agent accesses the master database to update data. This invention can improve system performance without additional cost.

Description

Technical field [0001] The present invention relates to the field of database technology, in particular to a database access method and system for implementing load sharing. Background technique [0002] Typical commercial telecommunications products use a cluster mode to improve availability. Cluster solutions involving databases also need to be highly available. [0003] Informix is ​​a large-scale database management system with advanced technology, performance and reliability. It is widely used in various applications around the world, including government, financial insurance, postal telecommunications, manufacturing and retail and other important industries or fields. Database servers like Informix must also adopt High Availability Data Replication (HDR) mode to provide high availability. In the HDR solution, one database server runs in the main mode as the master database, and the other runs in the read-only mode as the secondary server. HDR will copy the operations perfor...

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
Inventor 开守诺
Owner HUAWEI 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