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

Access method and device for multi-source heterogeneous database, equipment and storage medium

A data access, multi-source heterogeneous technology, applied to database models, relational databases, structured data retrieval, etc., can solve problems such as high operation and maintenance costs, storage solution isolation, learning, and code migration costs, and reduce development costs. cost and operation and maintenance costs, and the effect of improving versatility

Active Publication Date: 2021-08-13
北京奇岱松科技有限公司
View PDF14 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Existing relational databases (such as PostgreSQL database) and non-relational databases (such as AliyunTablestore) have different interactive instructions for storage solutions, serious ecological fragmentation, and isolation of storage solutions, which prevents developers from quickly utilizing existing knowledge and The code base uses other storage solutions, the cost of learning and code migration is huge, and the cost of operation and maintenance is high

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
  • Access method and device for multi-source heterogeneous database, equipment and storage medium
  • Access method and device for multi-source heterogeneous database, equipment and storage medium
  • Access method and device for multi-source heterogeneous database, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0025] figure 1 A flowchart of an access method of a multi-source heterogeneous data provided by the embodiment of the present invention, the present embodiment can be applied to access the multi-source heterogeneous database, and the data in the multi-source heterogeneous database is changed. The method can be performed by an access device of the multi-source heterogeneous data in the embodiment of the present invention, which can be implemented in software and / or hardware. like figure 1 As shown, the method specifically includes the steps of:

[0026] S110, acquire the first data access request for the user by the access interface of the unified interface layer.

[0027] Wherein, the unified interface layer can provide the user interface layer, providing the user to the user interface service to the user, implement the user's access operation of the multi-source heterogeneous database, and displays the return result.

[0028] The access interface provided by the unified inter...

Embodiment 2

[0044] figure 2 A flowchart of an access method of a multi-source heterogeneous database according to the second embodiment of the present invention, the present embodiment is optimized by the above embodiment, in the present embodiment, by the target driver pair The data access request is converted to obtain the second data access request, including: querying each database name pre-stored in the target driver according to the root node name, determines the target database; according to the access interface and the target database, The access interface protocol corresponding to the first data access request is determined; based on the access interface protocol, the data access parameters in the first data access request are converted to obtain a second data access request.

[0045] like figure 2 As shown, the method of this embodiment includes the steps of:

[0046] S210, acquire the first data access request of the user by the access interface of the unified interface layer.

[...

Embodiment 3

[0122] Figure 4 A structural diagram of an access device for a multi-source heterogeneous database provided in the first embodiment of the present invention. This embodiment can be applied to access the multi-source heterogeneous database, and the data in the multi-source heterogeneous database is changed. The device can be implemented in software and / or hardware, which can be integrated in any provider. In the device of the access function of the source partitioned database, such as Figure 4 As shown, the apparatus for accessing the multi-source heterogeneous database includes: uniform interface layer 310, data drive layer 320, and data storage layer 330.

[0123] Wherein, the unified interface layer 310 is used to obtain a first data access request for user input by an access interface, and at least the first data access request includes at least the root node name and table property, the table properties including: Table Name and field Array, store field properties in the fi...

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 embodiment of the invention discloses an access method and device for a multi-source heterogeneous database, equipment and a storage medium. The method comprises the following steps: acquiring a first data access request input by a user through an access interface of a uniform interface layer; determining a target driver corresponding to the access interface through a data driving layer, and converting the first data access request through the target driver to obtain a second data access request; and executing the second data access request on a target database through a data storage layer, wherein the database comprises a relational database and a non-relational database. Through the technical scheme of the embodiment of the invention, the universality of the multi-source heterogeneous database can be improved, and the development cost and the operation and maintenance cost of database access software are reduced.

Description

Technical field [0001] Embodiments of the present invention relate to computer data processing techniques, and more particularly to access methods, devices, devices, and storage media for multi-source heterogeneous databases. Background technique [0002] In the process of space digital, many companies have built many mutually isolated heterogeneous storage schemes based on their own business needs and technical features. Due to the lack of unified data models, there is no architecture design, the development platform is endless, and the business systems are independent of each other. [0003] Existing relational databases, such as PostgreSQL Databases, such as AliyuntableStore, such as the interaction of stored scenarios variably, ecological fragmentation, storage solution isolation, leading to developers unable to use existing knowledge and The code base uses other storage schemes, learning, code migration costs, high operation and maintenance cost. Inventive content [0004] ...

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/25G06F16/28
CPCG06F16/252G06F16/284
Inventor 刘春旭
Owner 北京奇岱松科技有限公司