Unlock instant, AI-driven research and patent intelligence for your innovation.

Database node-based data access method and system

A data access and database technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of storage space expansion processing, low efficiency, and inability to run work, and achieve the effect of improving performance

Inactive Publication Date: 2015-02-04
北京思特奇信息技术股份有限公司
View PDF5 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The current centralized database has relatively high requirements for hardware storage space, and the database management center cannot expand the storage space; it has relatively high requirements for hardware processing performance, and all lower-level management centers need to transmit their own logs to upper-level management Center, the daily log volume is very large; the database management center retrieves data slowly, and needs to retrieve and query from a huge amount of data, which is inefficient; the data of the database management center is seriously lagging behind, and the real-time performance is not high, and the data upload interface is complicated. Data that has not been uploaded cannot be monitored; all work depends on the upper-level database management center, and once the upper-level database management center fails, all work will not be able to run

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 node-based data access method and system
  • Database node-based data access method and system
  • Database node-based data access method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0025] Embodiment 1. A data access method based on database nodes. Combine below Figure 2-Figure 6 The method provided by the present invention is described in detail.

[0026] figure 2 , S201. Receive a database access request message sent by a client, and extract a SQL statement to be executed from the database access request message.

[0027] Specifically, see image 3 , the database in this embodiment is based on a multi-level distributed database and is based on a MySQL database, that is, there are multiple database nodes in each level of database management center, and each level of databases has sub-node databases. Therefore, it is first necessary to establish a distributed cluster database, install the storage node database in the database management center, set up the lower-level storage node database, and set the access data access authority by setting the IP, user name, password and port information for accessing the database; Unify the data storage model in e...

Embodiment 2

[0046] Embodiment 2. A data access system based on database nodes. Combine below Figure 8 The system provided by the present invention is described in detail.

[0047] Figure 8 Among them, the system provided by the present invention includes a request message receiving unit 801, a node matching unit 802, a heartbeat detection unit 803, a judging unit 804, an authority verification unit 805, an execution unit 806, a connection recycling unit 807 and an execution result merging unit 808.

[0048] Wherein, the request message receiving unit 801 is mainly used for receiving the database access request message sent by the client, and extracting the SQL statement to be executed from the database access request message.

[0049] Specifically, the database in this embodiment is based on a multi-level distributed database and is based on a MySQL database, that is, there are multiple database nodes in each level of database management center, and each level of database has a sub-no...

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 node-based data access method and system. The database node-based data access method comprises the following steps: receiving a database access request message transmitted by a client and extracting an SQL (Structured Query Language) statement to be executed from the database access request message; analyzing the SQL statement and matching at least one target database node, which is matched with the analyzed SQL statement, according to a preset matching rule; executing the analyzed SQL statement on the matched target database node; combining executing results returned by a plurality of target database nodes and feeding the combined executing result back to the client. Through the method provided by the invention, parallel access of a database can be realized, and the database query speed is quickened.

Description

technical field [0001] The invention relates to the technical field of database access, in particular to a data access method and system based on database nodes. Background technique [0002] For the current centralized database, all data is stored in the database management center, see figure 1 , For example, each application business site must regularly provide the network logs obtained by its own monitoring to the city management center through the application program interface. It is transmitted to the provincial management center and uploaded level by level. In addition, when the upper-level management center issues a data audit instruction, the lower-level management center provides an interface for receiving the data audit instruction, the lower-level management center stores the data audit instruction locally, and then sends the data audit instruction to the lower-level management center of the current management center. level release. [0003] The current central...

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/2453
Inventor 王虎
Owner 北京思特奇信息技术股份有限公司