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

Method and system for implementing database clustering function

An implementation method and database technology, which are applied in the field of database cluster function implementation methods and systems, can solve problems such as single database performance bottlenecks, and achieve the effect of realizing database expansion and solving performance bottlenecks

Active Publication Date: 2016-06-01
AGRICULTURAL BANK OF CHINA +1
View PDF5 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the object of the present invention is to provide a method and system for implementing a database cluster function, aiming to effectively expand the database by implementing a database cluster function, thereby solving the performance bottleneck problem caused by a single database

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
  • Method and system for implementing database clustering function
  • Method and system for implementing database clustering function
  • Method and system for implementing database clustering function

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0060] Embodiment 1 of the present invention discloses a method for realizing the function of a database cluster, wherein the database cluster includes a plurality of database nodes, and the plurality of database nodes respectively store different first-type data, refer to figure 1 , the method may include the following steps:

[0061] S101: Receive a first-type data service request from a sender, where the first-type data service request includes a first service element and a first-type data operation task.

[0062] This application solves the performance bottleneck problem caused by a single database node by extending the database system including only a single database node in the prior art to a database cluster including multiple database nodes, and realizing an effective database cluster function.

[0063] Wherein, the sender may be an ordinary user or a corresponding application system.

[0064] The present embodiment takes the bank system as an example to describe the ...

Embodiment 2

[0080] In the second embodiment, refer to image 3 The method for realizing the database cluster function may also include the following steps:

[0081] S104: Feed back the returned result data generated by the target database node to the sender.

[0082] This embodiment specifically supplements the solution of Embodiment 1, wherein, if the target database node generates corresponding result data that needs to be returned to the front-end application system after executing the SQL statement (such as query) submitted by the SQL mapper, it can be passed The data connection established in the first embodiment feeds back the returned data to the front-end application system via the SQL mapper and the interceptor.

[0083] Among them, if there are multiple target database nodes, the SQL mapper will integrate the data returned by each target database node into a result set and return it to the front-end application system when receiving multiple copies of result data returned by ea...

Embodiment 3

[0085] In the third embodiment, refer to Figure 4 The method for realizing the database cluster function may also include the following steps:

[0086] S105: When the target database node fails, allocate the first type of data service request to the target backup database node corresponding to the target database node, and the target backup database node is used to The first type of data is backed up.

[0087] Since each database node in the database cluster stores different first-type data, such as transactional data, etc., based on this, this embodiment backs up the first-type data of each database node in the database cluster in advance, and By pre-adding the relevant backup information of the database cluster in the configuration files of the interceptor and the SQL mapper, when the target database node fails, the intercepted first type of data service request is routed to the corresponding backup database node, thereby ensuring The first type of data is still available...

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 method and system for implementing a database clustering function. According to the method and system, an existing database system only comprising a single database node is expanded into a database cluster comprising multiple database nodes, different kinds of first-type data are stored in the nodes of the database cluster respectively, on this basis, when a first-type data service request of a sender is received, a matched target database node is assigned for the request based on service elements included in the request, and then the request is distributed to the assigned target database node to be processed. Thus, different kinds of data are stored in different nodes of the database cluster, the database clustering function is achieved through effective service routing, database expansion can be effectively achieved based on the function, and therefore the problem of performance bottleneck brought by a single database is solved.

Description

technical field [0001] The invention belongs to the technical field of database management and application, and in particular relates to a method and system for realizing a database cluster function. Background technique [0002] Today's era is an era of information, and people's life, work and study are inseparable from information systems. The processing and storage of data by information systems need to be supported by database systems. Based on this, database systems have become particularly important in today's information age. [0003] Most of the current database systems are single database systems that only use a single database node. With the rapid growth of data volume in various industries, the database system is also facing performance bottlenecks caused by a single database while correctly recording data results. Take the banking system as an example. A large number of customers go to the banking system to handle various businesses every day. The peak number of...

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/27
Inventor 马川郑德健张吉吴旭春朱寅生谢之波
Owner AGRICULTURAL BANK OF CHINA
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