Database access method and device

An access method and access device technology, applied in the database field, can solve problems such as server balance scheduling, data loss, and small server access volume, and achieve the effects of improving flexibility, improving efficiency, and reducing waste

Active Publication Date: 2020-03-17
BEIJING DIGITAL UNION WEB SCI & TECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] There are generally two ways to access the existing database clusters. One is to connect to the database server with a fixed address. This method cannot perform balanced scheduling among the servers, and some servers will have heavy access pressure, while others will not. The number of visits is small; the other is to use proxy (PROXY) technology to send access requests to each server in a balanced manner. This method achieves balanced scheduling between servers, but requires all databases to have the ability to handle the same business , and if there is an abnormal connection to a certain server, data loss will occur

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] figure 1 is a schematic block diagram of a database access device 100 according to an embodiment of the present invention. The database access device 100 may generally include: a type acquisition module 110 , an index call module 120 , a state query module 130 , and an instance access module 140 .

[0026] In this embodiment, the databases for access are divided into multiple categories according to business types in advance, and each type of database is provided with its own index. The number of specific divisions can be determined according to the functional business of the database, each type of database can complete relatively independent data services, and each type of database can include multiple database instances (instances). A database instance is a combination of background processes and in-memory structures that operate on a database. The type obtaining module 110 is configured to obtain the type of the database to be accessed. The index calling module 12...

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 access method and apparatus. The database access method comprises the steps of obtaining the types of databases needed to be accessed, wherein the databases used to be accessed are divided into multiple types previously according to business types, and each type of the database is provided with an index; calling the indexes corresponding to the types of the databases needed to be accessed; determining a connection state of database instances pointed by the indexes; and when the connection state is that the database instances are being connected, accessing the database instances pointed by the indexes. According to the scheme, the databases providing data services are classified according to the business types, and each type of the database is provided with the index separately, so that balanced scheduling is performed in the corresponding databases according to the business types; and on one hand, the configuration of the database instances can be performed according to the business types, and on the other hand, access load balancing of the same types of the databases can be ensured, so that the database access efficiency is improved.

Description

technical field [0001] The present invention relates to a database, in particular to a database access method and device. Background technique [0002] Database (Database) is a collection of data organized according to certain rules to achieve a certain purpose. With the rapid development of computer technology, the database's read and write speed, data availability, security, and scalability are all facing higher requirements. [0003] Especially for large-scale and high-concurrency background service architecture systems, the database is generally distributed, that is, a database cluster is used. When using a database cluster, it is necessary to ensure load balancing between databases. Therefore, access coordination of database clusters is an important technology in the database field. [0004] There are generally two ways to access the existing database clusters. One is to connect to the database server with a fixed address. This method cannot perform balanced schedulin...

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): G06F16/22G06F9/50
CPCG06F9/5083G06F16/2228G06F16/27
Inventor 杨玉奇杨从安张宇平
Owner BEIJING DIGITAL UNION WEB SCI & 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