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

Database access method and device

An access method and access device technology, applied in the field of data processing, can solve problems such as complex access at the application layer, and achieve the effects of simplifying access, reducing workload, and ensuring stability and integrity

Inactive Publication Date: 2017-01-11
ZTE CORP
View PDF2 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The CPP application program needs to access both the ODBC interface and the CPP-to-JDBC interface, and the calling methods of the two interfaces are inconsistent. Therefore, the CPP application program needs to pay attention to some technical details of the interface layer, which makes the application layer access more and more complicated.

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

no. 1 example

[0018] refer to figure 2 As shown, it is a flow chart of the database access method provided by the first embodiment of the present invention. In this embodiment, the method includes the following steps:

[0019] Step S1, receiving an access request to the target database in the database system sent by the application program;

[0020] Step S2, selecting the access interface corresponding to the target database from the access interfaces corresponding to various databases preset in the interface layer;

[0021] Step S3, according to the access request, call the selected access interface to perform an access operation on the target database.

[0022] According to the above database access method, each database in the database system can be accessed through an interface layer independent of the database system, and the application layer can shield the difference in access to different types of databases. When the database system is upgraded, the stability and integrity of the...

no. 2 example

[0036] The second embodiment of the present invention provides a database access method. Compared with the database access method provided in the first embodiment, it further proposes:

[0037]The access request to the target database in the database system sent by the receiving application program in step S1 can be realized through a programming language-independent data exchange protocol. Specifically, the programming language-independent data exchange protocol may be a simple object access protocol (SOAP, Simple Object Access Protocol) based on a hypertext transfer protocol (HTTP, HyperText Transfer Protocol). Similarly, sending the access result to the application program through the selected access interface is also implemented through the programming language-independent data exchange protocol.

[0038] Since the application layer and the general interface layer interact through a data exchange protocol independent of the programming language, such as SOAP, the applicati...

no. 3 example

[0040] refer to Figure 4 As shown, it is a flow chart of the database access method provided by the third embodiment of the present invention. In this embodiment, the database access methods described in the first embodiment and the second embodiment are applied to an application scenario where a big data database (such as Hive) is integrated with a traditional database (such as Sybase IQ). Specifically, the application program in the application layer sends a data analysis request to Hive through the interface layer, and Hive returns the analysis result to the application layer after receiving the data analysis request. After receiving the analysis result, the application sends a data saving request to Sybase IQ through the interface layer, and Sybase IQ saves the analysis result after receiving the data saving request. In addition, if the application program has the same data analysis request, it can directly access Sybase IQ to obtain the analysis result from Sybase IQ. ...

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 database access method, which comprises the following steps of: receiving an access request, which is sent from an application program, for a target database in a database system; selecting an access interface corresponding to the target database from access interfaces corresponding to various classes of preset databases in an interface layer; and according to the access request, calling the selected access interface to execute an access operation for the target database. The invention also provides a database access device. By use of the database access method and device, the access of the application program can be simplified, and stability and integrity when a database system is updated are guaranteed.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a database access method and device. Background technique [0002] In the fields of communication, Internet, computer, etc., with the increasing amount of processed data, big data databases have been widely used at present. From Oracle, Sybase IQ to Hive, Spark, more and more databases are applied in the database system and become a very important part of the database system, providing access methods such as storage, query, and analysis for various data. [0003] When the database system needs to be upgraded, such as connecting a new database in the database system or replacing the original database, ensuring the integrity and stability of the database system is a major challenge for the upgrade operation. In order to make the database system compatible with different types of databases, the current practice is that when a new type of database is added to the database sy...

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): G06F17/30
CPCG06F16/00G06F16/2365G06F16/23
Inventor 杨兆辉
Owner ZTE CORP