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

A database access method and system

An access method and database technology, applied in database management systems, structured data retrieval, electronic digital data processing, etc., can solve problems such as lack of effective management, complex database environment, etc., and achieve the effect of simplifying development

Active Publication Date: 2022-03-04
北京宇信科技集团股份有限公司
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] (1) The customer's on-site database environment is complex, and the product needs to be compatible with various databases. Different driver packages must be introduced for each database
[0005] (2) For different databases, there is a lack of unified and effective management

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
  • A database access method and system
  • A database access method and system
  • A database access method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0062] figure 1 is an overall architecture diagram of the system of the embodiment of the present invention; figure 2 is an architecture diagram of the proxy driver of the embodiment of the present invention; image 3 It is an implementation architecture diagram of the database proxy server in the embodiment of the present invention. Such as Figure 1 to Figure 3 As shown, the embodiment of the present invention consists of two parts: database proxy service and database proxy driver.

[0063] The database proxy service is used to provide adaptation services for a variety of different databases, provide an SQL execution environment, and also provide support for the database proxy JDBC driver.

[0064] The database agent JDBC driver is a standard implementation of the JDBC interface, and is a programming access mode provided by the embodiment of the present invention. After the application program APP introduces the driver program, it can access various data sources accesse...

Embodiment 2

[0151] Figure 4 It is a flow chart of the method of the embodiment of the present invention. Such as Figure 4 As shown, the method includes the following steps:

[0152] S110: The database proxy driver receives the Java database connection JDBC application programming interface API instruction for accessing the target database from the application program, converts the JDBCAPI instruction into an http message based on the conversion relationship mapping table of the JDBC API instruction and the http message, and converts the http message Sent to the database proxy service;

[0153] S120: The database proxy service receives the http message, converts the http message into the JDBC API instruction of the driver package of the target database based on the conversion relationship mapping table of the JDBC API instruction and the http message, and implements the target according to the JDBC API instruction of the driver package of the target database database access.

[0154]...

Embodiment 3

[0186] This embodiment provides a database access system, which includes:

[0187] The client device is used to receive the Java database connection JDBC application programming interface API instruction for accessing the target database from the application program, based on the conversion relationship mapping table of the JDBC API instruction and the http message, the JDBC API instruction is converted into an http message, and the http message is converted into the http message. The message is sent to the server;

[0188] The server is used to receive the above http message, convert the http message into the JDBC API instruction of the driver package of the target database based on the conversion relationship mapping table of the JDBC API instruction and the http message, and implement the target according to the JDBC API instruction of the driver package of the target database database access.

[0189] In some embodiments, the server is connected to various databases, and ...

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 present invention provides a database access method and system, the method comprising: the database agent driver program receives the JDBC application programming interface API from the application program, and converts the JDBC API instruction into an http message based on the conversion relationship mapping table of the JDBC API instruction and the http message , send the http message to the database proxy service; the database proxy service receives the http message, converts the http message into the JDBC API command of the driver package of the target database based on the JDBC API command and the conversion relationship mapping table of the http message, and converts the http message into the JDBC API command of the driver package of the target database. The package's JDBC API commands implement access to the target database. This invention shields the differentiation of different database drivers, provides a unified proxy driver externally, and simplifies the development of APP.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database access method and system. Background technique [0002] In the information society, the database that can store and manage a large amount of data has become the core part of various information systems such as management information systems, office automation systems, decision support systems, and trading platforms. [0003] In the course of realizing the present invention, the inventor finds that there are at least the following problems in the prior art: [0004] (1) The customer's on-site database environment is complex, and the product needs to be compatible with various databases. Different driver packages must be introduced for each database. [0005] (2) For different databases, there is a lack of unified and effective management. Contents of the invention [0006] In view of this, the purpose of the embodiments of the present invention is to provide a dat...

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/25G06F9/54
CPCG06F16/252G06F9/541
Inventor 贾永强
Owner 北京宇信科技集团股份有限公司