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

Database deployment method and device

A database and instance data technology, applied in the database field, can solve the problems of occupying a lot of memory, high consumption of server memory resources, and low utilization of server resources, so as to reduce consumption and improve resource utilization.

Pending Publication Date: 2022-01-07
CHINA CONSTRUCTION BANK
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although this method can realize the deployment of databases of multiple business systems on the server, since each database management system instance needs to occupy part of the content of the server after startup, and multiple database management system instances must occupy more memory, The memory resource consumption of the server is large, and the utilization rate of server resources is low.

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 deployment method and device
  • Database deployment method and device
  • Database deployment method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] The solution of the embodiment of the present application can be applied to scenarios where databases of multiple business systems need to be deployed on a physical machine server. Through the solution of this application, a single physical machine server can be used to carry the databases required by multiple business systems. It can also reduce the consumption of resources such as the memory of the physical machine server.

[0051] The following will clearly and completely describe the technical solutions in the embodiments of the application with reference to the drawings in the embodiments of the application. Apparently, the described embodiments are only some of the embodiments of the application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0052] like figure 1As shown, it shows a schemat...

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 deployment method and device. The method comprises the following steps: deploying and operating a database management system instance in a first physical storage space of a server; determining at least one to-be-borne service system in the server; for each service system, creating a database of the service system based on the database management system instance, and creating a database directory of the database in the first physical storage space; for the database of each business system, creating a logical volume for the database of the business system, performing file system formatting on the logical volume corresponding to the database of the business system, and mounting the formatted logical volume to a database directory corresponding to the database of the business system, wherein the logical volume and a second physical storage space of the server have a mapping relationship. According to the scheme, while databases of multiple service systems can be deployed on a single server, the memory resource consumption in the server is reduced, and the resource utilization rate of the server is improved.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a database deployment method and device. Background technique [0002] At present, there are many types of business systems involved in the banking system, and each business system needs to be configured with a corresponding database. [0003] If the database of one business system is deployed on each server, since the business volume of each business system is not large, it will cause a great waste of server resources. In order to improve resource utilization, multiple database management system instances can be deployed on the server, and a business system database can be created on each database management system instance. Although this method can realize the deployment of databases of multiple business systems on the server, since each database management system instance needs to occupy part of the content of the server after startup, and multiple database manage...

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): G06F16/21G06F16/22G06F16/28G06F9/50G06F3/06
CPCG06F16/211G06F16/2272G06F16/284G06F9/5016G06F3/0608G06F3/0643
Inventor 王良元卢星辰万鹏童慧明
Owner CHINA CONSTRUCTION BANK
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