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

Method, system and device based on DBIO interface and medium

A technology of interface access and interface function, which is applied in the field of database interface, can solve the problems of inability to flexibly relocate data, synchronization, system error reporting, etc., and achieve the effect of improving development efficiency and adaptability

Pending Publication Date: 2021-11-26
北京乾元大通技术有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For these read-only tables, only read operations can be performed. If a write operation is used, the system will report an error
This makes DBIO in the prior art unable to flexibly relocate and synchronize data between databases, so a method and system based on a DBIO interface is needed to realize flexible relocation and synchronization of data between any databases

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
  • Method, system and device based on DBIO interface and medium
  • Method, system and device based on DBIO interface and medium
  • Method, system and device based on DBIO interface and medium

Examples

Experimental program
Comparison scheme
Effect test

specific Embodiment approach

[0038] see figure 1 , a method for accessing a database based on a DBIO interface provided in the embodiment of this application. The DBIO platform defines and implements a set of interfaces for accessing databases. Through this interface, the connection to various databases is simplified. Generally, accessing databases is A C interface or an ODBC interface embedded with a structured query language (structured query language, hereinafter referred to as SQL) statement through a command line interface (command-line interface, hereinafter referred to as CLI). However, this method adopts the method of storing the code that realizes the interface function in the preset database operation file, so that the developer does not need to consider the type of the underlying reference database, and does not need to consider the specific writing method of SQL for direct reference, which improves the adaptation of the interface performance, improving development efficiency. Its specific imple...

Embodiment 2

[0082] see Image 6 , a system for accessing a database based on a DBIO interface provided in the embodiment of the present application, including:

[0083]Define module 1, which is used to define environment variables to specify the database type; define the interface function of the database according to the access point provided by the database;

[0084] The preset module 2 is used to store the code for realizing the interface function in the database into the preset database operation file;

[0085] The compilation module 3 is used to configure the rule file, select the current database and use the corresponding code in the database operation file to read the operation file and compile the operation of data synchronization and data cancellation;

[0086] The execution module 4 is used for executing the compiled file and accessing the database.

Embodiment 3

[0088] see Figure 7 , is an electronic device provided by the embodiment of the present application, including at least one processor 5, at least one memory 6, and a data bus 7; wherein: the processor 5 and the memory 6 complete the mutual communication through the data bus 7 communication; the memory 6 stores program instructions executable by the processor 5, and the processor 5 invokes the program instructions to execute a method for accessing a database based on a DBIO interface. Example implementation:

[0089] Define environment variables to specify the database type; define the interface function of the database according to the access point provided by the database; store the code that implements the interface function in the database into the preset database operation file; configure the rule file, select the current database to use the database Compile the corresponding code in the operation file; execute the compiled file to access the database.

[0090] Wherein,...

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 method, system and device based on a DBIO interface and a medium, and relates to the technical field of database interfaces. The method includes defining environment variables to specify database types; defining an interface function of the database according to an access point provided by the database; storing codes for realizing the interface function in the database into a preset database operation file; configuring a rule file, selecting a current database, and compiling a to-be-operated file by using a corresponding code in a database operation file; and executing the compiled file, and accessing the database. According to the method, a developer can directly quote without considering the type of a bottom-layer reference database and the specific writing method of a structured query language, so that the adaptability of an interface is improved, and the development efficiency is improved.

Description

technical field [0001] The present invention relates to the technical field of database interfaces, in particular to a method, system, device and medium based on a DBIO interface. Background technique [0002] DBIO is a database data migration, real-time change subscription and synchronization service. It is gradually improved based on the open source OTTER project, and it becomes a channel for data sharing between databases. Functionally, DBIO includes table data addition, deletion, modification and query functions. DBIO also supports placing some read-only tables into another database. For these read-only tables, only read operations can be performed. If a write operation is used, the system will report an error. This makes it impossible for DBIO in the prior art to flexibly relocate and synchronize data between databases, so a method and system based on a DBIO interface is needed to realize flexible relocation and synchronization of data between any databases. Content...

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 Applications(China)
IPC IPC(8): G06F16/242G06F16/2455G06F16/25
CPCG06F16/2433G06F16/24552G06F16/25
Inventor 徐贤笑
Owner 北京乾元大通技术有限公司