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

Database operation method and device based on middleware and terminal equipment

An operation method and database technology, applied in the database field, can solve the problem of inability to transfer database instances, affecting the read and write performance of other database instances, etc.

Pending Publication Date: 2021-03-02
JINGDONG TECH HLDG CO LTD
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When the current database is running with middleware, based on the design defect of the middleware, if a certain database instance fails when the database is running, the middleware will accumulate the Structured Query Language (SQL) sent by the client in the In the running memory, the corresponding database instance cannot be passed in. When the storage of the running memory reaches saturation, it will seriously affect the read and write performance of other database instances

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 operation method and device based on middleware and terminal equipment
  • Database operation method and device based on middleware and terminal equipment
  • Database operation method and device based on middleware and terminal equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with aspects of the present application as recited in the appended claims.

[0047] see figure 1 , figure 1 It is a schematic flowchart of a middleware-based database operation method provided by an embodiment of the present application.

[0048] like figure 1 As shown, the middleware-based database operation method provided in this embodiment may include:

[0049] Step S101. Obtain a database instance status list maintained in real time. The database instanc...

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 relates to a middleware-based database operation method and device and terminal equipment, and the method comprises the steps: firstly obtaining a database instance state list maintainedin real time, wherein the database private state list is used for storing all database private identifiers and the service states of all database instances; determining a database instance with a service state being a fault state in the database instance state list as a target database instance; finally storing a database instruction sent to a target database in a locally preset storage file, andbased on this, if the database instance with the service state being the fault state appears, storing the database instruction to be sent to the database instance in the locally preset storage file,which is not accumulated in the running memory any more, so that the situation that the storage of the running memory is saturated due to the failure of the database instance is avoided.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a middleware-based database operation method, device and terminal equipment. Background technique [0002] With the advent of the digital age, people's work and life are inextricably linked with data, and with it, the amount of data continues to increase. In order to effectively manage these data, databases have emerged. The database is used to store data for a long time. When necessary, the data in the database can be queried through the database instance, and new data can also be written into the database through the database instance. [0003] In order to improve the availability of the database, high-availability middleware is generally set between the client and the database to reduce the downtime of the database and maintain high availability of database query and write services. When the current database is running with middleware, based on the design defect o...

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 Applications(China)
IPC IPC(8): G06F11/07G06F9/54G06F16/21
CPCG06F11/0796G06F9/544G06F16/21
Inventor 张宁程建波吕军
Owner JINGDONG TECH HLDG CO LTD