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

Method and device for reading and writing separation of database

A read-write separation and database technology, applied in the computer field, can solve problems such as inconvenient maintenance, inconvenient troubleshooting, complex configuration, etc.

Inactive Publication Date: 2017-10-27
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF6 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, if middleware is used, the configuration is more complicated and inconvenient to maintain. Once an error occurs, only the DBA is required to handle it. It is inconvenient for simple program developers to troubleshoot errors. Among them, the DBA is engaged in the management and maintenance of the database management system (DBMS). The collective name of the staff is responsible for the full life cycle management of the business database from design, testing to deployment and delivery; if the separation of read and write is implemented in the program, it is necessary to judge whether the master library or the slave library is currently used when executing each sql, and the embedded amount of the modified code will be reduced is quite large

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 device for reading and writing separation of database
  • Method and device for reading and writing separation of database
  • Method and device for reading and writing separation of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] The application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain related inventions, rather than to limit the invention. It should also be noted that, for the convenience of description, only the parts related to the related invention are shown in the drawings.

[0026] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and embodiments.

[0027] figure 1 Shown is an exemplary system architecture 100 to which embodiments of the database read-write separation method or the database read-write separation apparatus of the present application can be applied.

[0028] Such as figure 1 As shown, the system archite...

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 a device for reading and writing separation of a database. One embodiment of the method comprises the steps that a business request of a user is acquired through a web access layer; a business method of the business request is named according to a business type of the business request; the business method is intercepted through a pre-declared aspect oriented programming interception class; and according to an interception result of the aspect oriented programming interception class, the business request is linked to a master base of the database for corresponding writing operation, or the business request is linked to a slave base of the database for corresponding reading operation. Through the embodiment, reading and writing separation of the database is realized.

Description

technical field [0001] The present application relates to the field of computer technology, specifically to the field of Internet technology, and in particular to a method and device for separating reads and writes from a database. Background technique [0002] With the development of the Internet, the application of large databases has become an indispensable part of web applications. When a large amount of data accesses the database concurrently, the number of database reads and writes is huge, causing the database access pressure to increase exponentially. In the daily Java web application background business implementation scenario, in order to disperse the pressure on the database, many data sources are configured, and usually, each data source corresponds to a separate IP address, and in these databases In the middle, the data source needs to be divided into main database and slave database. The main database is mainly used to undertake the demand of writing data, and...

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/30G06F9/44
CPCG06F16/23G06F16/24G06F16/25
Inventor 刘鹏
Owner BEIJING JINGDONG SHANGKE 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