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

Database service system and method for making multiple databases compatible

A service system and database technology, which is applied in the direction of database management system, database design/maintenance, structured data retrieval, etc., can solve the problems of low development efficiency and achieve the effect of improving development efficiency

Active Publication Date: 2017-08-08
BEIJING SANKUAI ONLINE TECH CO LTD
View PDF2 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] This application provides a database service system and a method compatible with multiple databases, which solves the problem of low development efficiency when compatible with multiple databases in the prior art

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 service system and method for making multiple databases compatible
  • Database service system and method for making multiple databases compatible
  • Database service system and method for making multiple databases compatible

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0022] A database service system disclosed in this application, such as figure 1 As shown, the system includes: a plug-in layer 100 , a plug-in middle layer 110 and a multi-level task system 120 .

[0023] Wherein, the plug-in layer 100 includes at least one plug-in corresponding to a database type one by one, and the plug-in is used to output database operation parameters of a corresponding type of database.

[0024] The multi-level task system 120 is used for performing database operations.

[0025] The plug-in middle layer 110 is located between the plug-in layer 100 and the multi-level task system 120, and is used to obtain database operation parameters from the plug-ins in the plug-in layer, and then convert them into tasks of the multi-level task system Scheduling parameters, the task associated with the database operation is scheduled by the multi-level task system according to the converted task scheduling parameters, so as to execute the database operation.

[0026]...

Embodiment 2

[0037] A method compatible with multiple databases disclosed in this embodiment, such as image 3 As shown, the method includes: Step 300 to Step 320. The method is applied to the database service system described in the first embodiment.

[0038] Step 300, determine the task to be scheduled according to the received database operation instruction.

[0039] Firstly, the database service system receives a database operation instruction issued by an upper layer application, and the database operation instruction is used to instruct the database service system to provide the requested database service. During specific implementation, the database operation instructions may include instructions such as creating a cluster, querying a database, deleting a database, and writing a database. Database operation instructions usually include two parts: database operation and operation parameters. Taking the database operation instruction as "create cluster" as an example, the database ...

Embodiment 3

[0048] A method compatible with multiple databases disclosed in this embodiment, such as Figure 4 As shown, the method includes: Step 400 to Step 470. The method is applied to the database service system described in Embodiment 1. In this embodiment, the PaaS database service system is used as an example to illustrate the compatibility method of various databases.

[0049] Step 400, the database service system receives a database operation instruction.

[0050] During specific implementation, the PaaS system can receive relevant database operation instructions for database services in real time through message middleware or queue monitoring, such as: "create database cluster" instructions, "query database" instructions, "delete database cluster" instructions instructions etc. Taking the PaaS system as an example when it receives an instruction to "create a database cluster", the parameters of the database operation instruction include: database type, configuration size, num...

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 provides a database service system and belongs to the technical field of computers. The database service system comprises a plug-in layer, a multistage task system and a plug-in middle layer, wherein the plug-in layer comprises at least one plug-in in one-to-one correspondence to the types of databases, and the at least one plug-in is used for outputting database operation parameters of the databases of the corresponding type; the multistage task system is used for executing database operation; the plug-in middle layer is located between the plug-in layer and the multistage task system and used for converting database operation parameters acquired by the at least one plug-in in the plug-in layer into task scheduling parameters of the multistage task system, and the multistage task system schedules tasks associated with the database operation according to the converted task scheduling parameters to execute database operation. The problem of low development efficiency due to the fact that a set of task flows and tasks is required to be developed independently for newly added database types when the database service system supports multiple databases in the prior art is solved.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a database service system and a method compatible with various databases. Background technique [0002] PaaS (Platform as a Service) is based on virtualization technology and provides a series of middleware, of which the most common and important one is the database service system. There are many types of databases, such as relational database MySQL, PostgreSQL, non-relational MongoDB, cache database Redis, Memcached, etc. The basic management functions (create, delete, adjust configuration, start and stop, etc.) of different types of databases are quite different. When the PaaS system supports different types of databases, it needs to be compatible with the differences in the deployment and management of different types of databases. For each basic database-related management function on the PaaS system, a series of tasks need to be completed, including virtualizat...

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): G06F9/48G06F17/30
CPCG06F9/4881G06F16/21G06F16/25
Inventor 李文俊巩向锋
Owner BEIJING SANKUAI ONLINE 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