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

Database routing method and device and database system

A data routing and database technology, applied in the field of database systems, can solve the problems of degraded read and write performance, relational databases do not support distributed expansion, deadlock, etc., to achieve the effect of ensuring read and write performance

Active Publication Date: 2017-06-06
HUAWEI TECH CO LTD
View PDF3 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The relational database itself does not support distributed expansion, and the maximum processing capacity of a single database node is limited. When the relational database reaches a certain scale, concurrency problems such as deadlocks are very prone to occur, resulting in a serious decline in its read and write performance

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 routing method and device and database system
  • Database routing method and device and database system
  • Database routing method and device and database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] The technical solutions in the embodiments of the present application will be described below with reference to the drawings in the embodiments of the present application.

[0045] figure 1 It is a database system architecture diagram of an embodiment of the present application, such as figure 1 As shown, the database system includes:

[0046] Application system 101, database 102 and database routing device 103, application system 101 includes a plurality of different business applications (application 1-application N), can read and invoke business data from database 102 to provide different services, database 102 includes Multiple database nodes (database 1 -database N) are used to store business data for use by the application system 101, and the business data stored by each node of the database may be different. The database routing device 103 provides the application system 101 with a data routing query function. The database routing device 103 includes:

[0047...

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 embodiment of the invention provides a database routing method which is applied to a database. The database comprises multiple database nodes. A database routing device is introduced to the method to provide route scheduling of the database, and the method comprises the steps that the database routing device receives a data routing information query request sent by an application, wherein the data routing information query request contains data types; the database routing device determines database nodes corresponding to the data types according to the data types; the database routing device sends data routing information query response to the application, wherein the data routing information query response contains identifier information of the database nodes. The database routing method performs route scheduling of the database by introducing the database routing device so that the relational database can be expanded in a distributed mode. Accordingly, the reading-writing performance of the database is ensured under the situation of increase of a large amount of data.

Description

technical field [0001] The present application relates to a database system, in particular to a database routing method, device and database system. Background technique [0002] A relational database refers to a database that uses a relational model to organize data. The relational model was first proposed by IBM researcher Dr. E.F. Codd in 1970. In the following decades, the concept of the relational model was fully developed and gradually became the mainstream model of database architecture. Simply put, the relational model refers to the two-dimensional table model, and a relational database is a data organization composed of two-dimensional tables and the connections between them. The current mainstream relational databases include Oracle, DB2, MySQL, Inspur K-DB, etc. [0003] With the development of business and the increase of data volume, when the number of users and visits of an application system are increasing day by day, the traditional relational database has ...

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/27G06F16/284
Inventor 张卫兵
Owner HUAWEI 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