Database routing apparatus and method

A database and routing technology, applied in the field of data processing, can solve problems such as inflexible configuration of sub-database and sub-table algorithms, time-wasting, error-prone, etc.

Active Publication Date: 2018-06-19
YONYOU NETWORK TECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] ⑴The database access method changes with the change of the structure: as the data changes from less to more and the database structure changes, the original routing method changes, and the database access method needs to be modified accordingly, requiring a lot of code modification and testing, which is time-consuming and error-prone
[0004] ⑵ The sub-database and sub-table algorithm cannot be flexibly configured: at different stages of data accumulation, there will be different sub-database and sub-table methods, which cannot be flexibly configured, and the scheme is not universal

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 apparatus and method
  • Database routing apparatus and method
  • Database routing apparatus and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] In order to understand the above-mentioned purpose, features and advantages of the present invention more clearly, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be noted that, in the case of no conflict, the embodiments of the present application and the features in the embodiments can be combined with each other.

[0030] In the following description, many specific details are set forth in order to fully understand the present invention. However, the present invention can also be implemented in other ways different from those described here. Therefore, the protection scope of the present invention is not limited by the specific details disclosed below. EXAMPLE LIMITATIONS.

[0031] figure 1 A block diagram of a database routing device according to an embodiment of the present invention is shown.

[0032] Such as figure 1 As shown, the database routing device 100 accor...

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 database routing device, and the database routing device comprises: a database routing rule management unit for managing database routing rules; a database routing unit for routing query statements based on management of the database routing rules; a database cluster monitoring unit for monitoring all database nodes based on route operation of query statements, to two backup machines in each group, inserting and updating the machine, upon downtime, automatically switching inserting and updating operations into backup machines, and automatically switching back to the operations after recovering the inserted machine. The invention further a database routing method. Through the technical solution of the invention, the database route of the multi-object metadata can be completed by fully utilizing the single-object metadata and the document description type based on the existing database routing manner, thereby creating an universal and uniform routing idea which involves in the multi-object metadata and faces the object language database route.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a database routing device and a database routing method. Background technique [0002] In Internet applications, with the development of business, more and more data are accumulated, and the database architecture designed at the beginning cannot meet the performance and business requirements. Usually, the original database is horizontally split, that is, tables are divided; at the same time, it may Vertically split the database according to the business, that is, sub-database. With the change of the database structure, the database access method also changes accordingly, and the sub-database and sub-table algorithms used in different stages are also different. The main problems are: [0003] ⑴The database access method changes with the change of the structure: as the data changes from less to more and the database structure changes, the original routing method ch...

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 Patents(China)
IPC IPC(8): G06F17/30
CPCG06F11/1464G06F16/2379G06F16/27
Inventor 卢相宁杨鹏
Owner YONYOU NETWORK 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