CN112632176A - Interaction method and device for supervising submission database - Google Patents
Interaction method and device for supervising submission database Download PDFInfo
- Publication number
- CN112632176A CN112632176A CN202011637688.6A CN202011637688A CN112632176A CN 112632176 A CN112632176 A CN 112632176A CN 202011637688 A CN202011637688 A CN 202011637688A CN 112632176 A CN112632176 A CN 112632176A
- Authority
- CN
- China
- Prior art keywords
- database
- data table
- control
- data
- source
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 230000003993 interaction Effects 0.000 title claims abstract description 129
- 238000000034 method Methods 0.000 title claims abstract description 56
- 230000002452 interceptive effect Effects 0.000 claims abstract description 25
- 230000008676 import Effects 0.000 claims description 52
- 238000006243 chemical reaction Methods 0.000 claims description 42
- 238000011161 development Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000013459 approach Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses an interaction method and device for supervising a submission database, wherein the method comprises the following steps: obtaining a first type of a source database, a format of a source data table and a second type of a target database; acquiring database interaction configuration information of a first type and a second type from a database interaction configuration library; generating an interactive module according to the interactive configuration information of the database and the format of the source data table; converting a source data table in a source database into a target data table through an interaction module, and loading the target data table to a target database; the format of the target data table matches the target database. Therefore, the interaction method for the supervision submission database provided by the embodiment of the application can automatically generate different interaction modules according to different types of databases and data tables to be loaded in different formats in the databases to complete interaction, so that manpower and material resources are saved, and the interaction modules in the application are automatically generated by the same standard, so that the influence on the stability and fault tolerance of the supervision submission system is small.
Description
Technical Field
The application relates to the field of power supplies, in particular to an interaction method and device for supervising and submitting a database.
Background
In the supervisory submission system, the field definition formats of the data tables stored in the different types of databases are different. If the data table file is directly loaded between different types of databases, errors may occur.
Currently, for the interaction between two different types of databases, it is necessary to develop specific interactive programs or components depending on the types of the two databases. This approach requires a significant expenditure of manpower and material resources when there are multiple types of databases. And because the interaction programs between different types of databases may be different, the stability and fault tolerance of the supervision and delivery system are easily reduced. Therefore, how to provide an interactive method of a supervision submission database which is simple and has little influence on the stability and fault tolerance of the supervision submission system becomes a technical problem which needs to be solved urgently in the field.
Disclosure of Invention
In order to solve the technical problem, the application provides a method and a device for evaluating the attenuation degree of a battery cell, which are used for evaluating the attenuation degree of the battery cell on the premise of not influencing the normal work of the device.
In order to achieve the above purpose, the technical solutions provided in the embodiments of the present application are as follows:
the embodiment of the application provides an interaction method for supervising a delivery database, which comprises the following steps:
obtaining a first type of a source database, a format of a source data table and a second type of a target database;
acquiring the database interaction configuration information of the first type and the second type from a database interaction configuration library;
generating an interactive module according to the database interactive configuration information and the format of the source data table;
converting the source data table in the source database into a target data table through the interaction module, and loading the target data table to the target database; the format of the target data table is matched with the target database.
Optionally, the interaction module includes a data export control and a data import control; generating an interaction module according to the database interaction configuration information and the format of the source data table, including:
generating the data export control according to the format of the source data table and a conversion function from the data type of the source data table to the data type of the standard file in the database interaction configuration information; the conversion function is used for realizing conversion of field granularity;
generating the data import control according to the format of the target data table and the database interaction configuration information; the format of the target data table is determined by the format of the source data table.
Optionally, the converting, by the interaction module, the source data table in the source database into a target data table includes:
generating the standard file from the source data table in the source database through the data export control, and sending the standard file to the data import control;
and loading the data in the standard file to a target data table through the data import control.
Optionally, the data import control includes: a table creation control, a table loading control and a table conversion control;
the generating the data import control according to the format of the target data table and the database interaction configuration information comprises:
generating the table creation control according to the format of the source data table and the database interaction configuration information;
generating the table loading control corresponding to the table creating control;
and generating the table conversion control corresponding to the table creation control.
Optionally, the converting, by the data import control, the source data table in the standard file into a target data table includes:
creating an intermediate data table and the target data table through the table creating control; the data type of the intermediate table is matched with the data type of the standard file;
loading the data in the standard file into the intermediate data table through the table loading control;
and loading the intermediate data table into the target data table through the table conversion control.
An embodiment of the present application further provides an interaction apparatus for supervising an submission database, where the apparatus includes:
the determining module is used for obtaining a first type of a source database, a format of a source data table and a second type of a target database;
the information acquisition module is used for acquiring the database interaction configuration information of the first type and the second type from a database interaction configuration library;
the generating module is used for generating an interactive module according to the interactive configuration information of the database and the format of the source data table;
the loading module is used for converting the source data table in the source database into a target data table through the interaction module and loading the target data table to the target database; the format of the target data table is matched with the target database.
Optionally, the interaction module includes a data export control and a data import control; the generation module comprises:
the export control generating module is used for generating the data export control according to the format of the source data table and a conversion function from the data type of the source data table to the data type of the standard file in the database interaction configuration information; the conversion function is used for realizing conversion of field granularity;
the import control generating module is used for generating the data import control according to the format of the target data table and the database interaction configuration information; the format of the target data table is determined by the format of the source data table.
Optionally, the loading module comprises:
the standard file generation module is used for generating the standard file from the source data table in the source database through the data export control and sending the standard file to the data import control;
and the standard file loading module is used for loading the data in the standard file to a target data table through the data import control.
Optionally, the data import control includes: a table creation control, a table loading control and a table conversion control;
the import control generation module is specifically configured to:
generating the table creation control according to the format of the source data table and the database interaction configuration information;
generating the table loading control corresponding to the table creating control;
and generating the table conversion control corresponding to the table creation control.
Optionally, the standard file loading module is specifically configured to:
creating an intermediate data table and the target data table through the table creating control; the data type of the intermediate table is matched with the data type of the standard file;
loading the data in the standard file into the intermediate data table through the table loading control;
and loading the intermediate data table into the target data table through the table conversion control.
According to the technical scheme, the method has the following beneficial effects: the embodiment of the application provides an interaction method and device for supervising a submission database, wherein the method comprises the following steps: obtaining a first type of a source database, a format of a source data table and a second type of a target database; acquiring database interaction configuration information of a first type and a second type from a database interaction configuration library; generating an interactive module according to the interactive configuration information of the database and the format of the source data table; converting a source data table in a source database into a target data table through an interaction module, and loading the target data table to a target database; the format of the target data table matches the target database.
Therefore, according to the method provided by the application, the configuration information of the two types of databases is obtained from the database interaction configuration database by obtaining the type of the source database, the type of the source data table to be loaded in the source database and the type of the target database. Then, automatically generating a specific interaction module according to the configuration information and the type of the source data table, so that the data table in the source database is loaded in the target database, and the interaction between the databases is completed. Therefore, the interaction method for the supervision submission database provided by the embodiment of the application can automatically generate different interaction modules according to different types of databases and to-be-loaded data tables with different formats in the databases to complete interaction, so that manpower and material resources are saved, and the interaction modules in the application are automatically generated by the same standard, so that the influence on the stability and fault tolerance of the supervision submission system is small.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
Fig. 1 is a schematic flowchart of an interaction method for supervising a delivery database according to an embodiment of the present disclosure;
fig. 2 is a schematic flowchart of a method for generating and applying an interaction module according to an embodiment of the present disclosure;
fig. 3 is a flowchart illustrating a method for generating and applying a data import control according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of an interaction device for supervising a delivery database according to an embodiment of the present application.
Detailed Description
In order to help better understand the scheme provided by the embodiment of the present application, before describing the method provided by the embodiment of the present application, a scenario of an application of the scheme of the embodiment of the present application is described.
In the supervisory submission system, the field definition formats of the data tables stored in the different types of databases are different. If the data table file is directly loaded between different types of databases, errors may occur.
Currently, for the interaction between two different types of databases, it is necessary to develop specific interactive programs or components depending on the types of the two databases. This approach requires a significant expenditure of manpower and material resources when there are multiple types of databases. And because the interaction programs between different types of databases may be different, the stability and fault tolerance of the supervision and delivery system are easily reduced. Therefore, how to provide an interactive method of a supervision submission database which is simple and has little influence on the stability and fault tolerance of the supervision submission system becomes a technical problem which needs to be solved urgently in the field.
In order to solve the above technical problem, an embodiment of the present application provides an interaction method and an interaction device for monitoring a delivery database, where the method includes: obtaining a first type of a source database, a format of a source data table and a second type of a target database; acquiring database interaction configuration information of a first type and a second type from a database interaction configuration library; generating an interactive module according to the interactive configuration information of the database and the format of the source data table; converting a source data table in a source database into a target data table through an interaction module, and loading the target data table to a target database; the format of the target data table matches the target database.
Therefore, according to the method provided by the application, the configuration information of the two types of databases is obtained from the database interaction configuration database by obtaining the type of the source database, the type of the source data table to be loaded in the source database and the type of the target database. Then, automatically generating a specific interaction module according to the configuration information and the type of the source data table, so that the data table in the source database is loaded in the target database, and the interaction between the databases is completed. Therefore, the interaction method for the supervision submission database provided by the embodiment of the application can automatically generate different interaction modules according to different types of databases and to-be-loaded data tables with different formats in the databases to complete interaction, so that manpower and material resources are saved, and the interaction modules in the application are automatically generated by the same standard, so that the influence on the stability and fault tolerance of the supervision submission system is small.
In order to make the aforementioned objects, features and advantages of the present application more comprehensible, embodiments accompanying the drawings are described in detail below.
Referring to fig. 1, the figure is a schematic flowchart of an interaction method for supervising an submission database according to an embodiment of the present application. As shown in fig. 1, the interaction method for monitoring a delivery database provided in the embodiment of the present application includes the following steps S101 to S104:
s101: a first type of a source database, a format of a source data table, and a second type of a target database are obtained.
S102: and acquiring the database interaction configuration information of the first type and the second type from the database interaction configuration library.
S103: and generating an interactive module according to the interactive configuration information of the database and the format of the source data table.
S104: converting the source data table in the source database into a target data table through the interaction module, and loading the target data table to the target database; the format of the target data table is matched with the target database.
It should be noted that, in the embodiment of the present application, the databases are in various types. For example, hive, gbase, oracle, sybase, etc. database types. Wherein, the data table format that different database types can load is different. It should be noted that, in the database interaction configuration library in the embodiment of the present application, interaction configuration information corresponding to a plurality of database types is stored, and the method provided in the embodiment of the present application can acquire the type of the database interaction configuration information from the database interaction configuration library after the type of the source data and the type of the target data are acquired.
It should be noted that, in the embodiment of the present application, the target data table is a data table that can be directly loaded into the target database. That is, the format of the target data table matches the target database.
The following describes specific embodiments of step S103 and step S104 in the embodiments of the present application in detail:
referring to fig. 2, this figure is a schematic flowchart of a method for generating and applying an interaction module according to an embodiment of the present application. As shown in fig. 2, the method for generating a concurrent application interaction module according to the embodiment of the present application includes two parts, namely, a generation interaction module and an application interaction module, which are described in detail below:
generating an interaction module: the interaction module in the embodiment of the application comprises a data export control and a data import control; generating an interaction module according to the database interaction configuration information, wherein the interaction module comprises:
s201: generating the data export control according to the format of the source data table and a conversion function from the data type of the source data table to the data type of the standard file in the database interaction configuration information; the conversion function is used for realizing conversion of field granularity;
s202: generating the data import control according to the format of the target data table and the database interaction configuration information; the format of the target data table is determined by the format of the source data table.
An application interaction module: correspondingly, in this embodiment of the application, converting the source data table in the source database into the target data table through the interaction module may include:
s203: generating a standard file from the source data table in the source database through the data export control, and sending the standard file to the data import control;
s204: and installing the data in the standard file to a target data table through the data import control.
It should be noted that, in step S201 in the embodiment of the present application, in some systems, the data export control may be generated according to a conversion function from a data type of the source data table in the database interaction configuration information to a data type of the standard file. It should be noted that, in the embodiment of the present application, the data type of the standard file is preset. As an example, the data types of the standard file data table may include: at least one of a row separator, a column separator, a character encoding, and a date format. It should be noted that, in the embodiment of the present application, the mapping relationship between the format of the target data table and the format of the source data table is determined by the type of the target database and/or the type of the conversion function.
As a possible implementation manner, the type of the source data table in the embodiment of the present application may be obtained by parsing the source data table, or may be directly input by a human. Of course, the method provided in the embodiment of the present application may obtain the format of the source data table and the format of the target data table according to other manners, which is not limited herein.
It should be noted that, in the embodiment of the present application, the scheme of the present application may be implemented according to the sequence from step S201 to step S204, or step S203 may be implemented after step S201, then step S202 is implemented, and finally step S204 is implemented, which is not limited herein.
As a possible implementation manner, the data import control in the embodiment of the present application includes: a table creation control, a table loading control and a table conversion control;
referring to fig. 3, this figure is a flowchart illustrating a method for generating and applying a data import control according to an embodiment of the present application. As shown in fig. 3, the method for generating and applying a data import control according to the embodiment of the present application includes two parts, that is, generating the data import control and applying the data import control:
generating a data import control: in the embodiment of the present application, generating the data import control according to the format of the source data table and the format of the target data table in the database interaction configuration information includes:
s301: generating the table creation control according to the format of the source data table and the database interaction configuration information; generating a table loading control corresponding to the table creating control; and generating a table conversion control corresponding to the table creation control.
And (3) application data import control: in this embodiment of the application, converting a source data table in a standard file into a target data table through a data import control includes:
s302: creating an intermediate data table and a target data table through a table creating control; loading the data in the standard file into the intermediate data table through the table loading control; and loading the intermediate data table into the target data table through the table conversion control.
It should be noted that, in the embodiment of the present application, the data types in the standard file are matched with the intermediate data table. In the embodiment of the application, the data type of the source data table is converted into the data type of the standard file through the export control, and then the data in the standard file is directly loaded into the intermediate table through the import control.
It should be noted that, in the embodiment of the present application, in order to save the development cost, the source data table is loaded into the intermediate data table, and then the intermediate data table is loaded into the target data table. Therefore, the method provided by the embodiment of the application only needs to generate a table loading control aiming at a source data table format; for a target data table format, only one table conversion control needs to be generated. That is, if there are N types of data packet formats in the present application, the method provided in the embodiment of the present application only needs to generate N types of table loading controls and N types of table conversion controls, and then, according to the N types of table loading controls and the N types of table conversion controls, N types of tables can be set up2And (4) importing data into a control. However, if the data import control is directly generated, N needs to be generated2Compared with the scheme of generating N types of table loading controls and N types of table conversion controls, the data import control needs more development cost. Therefore, the scheme provided by the embodiment of the application saves the development cost to a certain extent.
As a possible implementation manner, in consideration that the intermediate data table and the target data table in the embodiment of the present application may already exist, to avoid repeated creation, the method provided in the embodiment of the present application may further include: when the intermediate data table and the target data table exist, in the step S302 in this embodiment of the present application: and creating an intermediate data table and a target data table through the table creating control. Accordingly, when the intermediate data table or the target data table exists separately, the method provided by the embodiment of the application may skip the step corresponding to the generation of the intermediate data table or the target data separately.
As a possible implementation manner, in order to expand the application range of the intermediate data table in the embodiment of the present application, the length of the intermediate data table in the embodiment of the present application may be a fixed value. Correspondingly, the loading of the source data table in the standard file into the intermediate data table in the embodiment of the present application includes: and filling blank parts in the intermediate data table with preset characters. The loading of the intermediate data table into the target data table in the embodiment of the application comprises the following steps: and deleting the preset characters in the middle data table, and loading the preset characters into the target data table. Therefore, the intermediate data table provided by the embodiment of the application can be loaded with source data tables with different lengths, so that the same intermediate data table can be used when a plurality of source data tables in a source database are loaded into a target database.
It should be noted that, in the embodiment of the present application, step S301 and step S302 do not have a strict sequence. In this embodiment of the present application, step S301 may be implemented first, and then step S302 is implemented, or the methods included in step S301 and step S302 may be executed alternately, which is not limited herein.
Therefore, according to the method provided by the application, the types of the source database and the target database which are different in type and interact with each other are determined, and the configuration information of the two types of data is obtained from the database interaction configuration library. Then, automatically generating a specific interactive module according to the configuration information, so that the data tables in the source database are loaded in the target database, and the interaction between the databases is completed. Therefore, the interaction method for supervising and submitting the databases can automatically generate different interaction modules according to different types of databases to complete interaction, manpower and material resources are saved, and the interaction modules in the method are automatically generated according to the same standard, so that the influence on the stability and the fault tolerance of the supervising and submitting system is small.
According to the interaction method for supervising the delivery database provided by the embodiment, the embodiment of the application also provides an interaction device for supervising the delivery database.
Referring to fig. 4, the drawing is a schematic structural diagram of an interaction device for supervising an submission database according to an embodiment of the present application. As shown in fig. 4, an interaction apparatus for supervising a delivery database according to an embodiment of the present application includes:
the determining module 100 is configured to obtain a first type of a source database, a format of a source data table, and a second type of a target database.
The information obtaining module 200 is configured to obtain the database interaction configuration information of the first type and the database interaction configuration information of the second type from a database interaction configuration library.
The generating module 300 is configured to generate an interaction module according to the database interaction configuration information and the format of the source data table.
A loading module 400, configured to convert the source data table in the source database into a target data table through the interaction module, and load the target data table into the target database; the format of the target data table is matched with the target database.
In the embodiment of the present application, as a possible implementation manner, the interaction module includes a data export control and a data import control; the generation module comprises: the export control generating module is used for generating the data export control according to the format of the source data table and a conversion function from the data type of the source data table to the data type of the standard file in the database interaction configuration information; the conversion function is used for realizing conversion of field granularity; the import control generating module is used for generating the data import control according to the format of the target data table and the database interaction configuration information; the format of the target data table is determined by the format of the source data table.
In an embodiment of the present application, as a possible implementation manner, the loading module includes: the standard file generation module is used for generating the standard file from the source data table in the source database through the data export control and sending the standard file to the data import control; and the standard file loading module is used for loading the data in the standard file to a target data table through the data import control.
In this embodiment of the present application, as a possible implementation manner, the data import control includes: a table creation control, a table loading control and a table conversion control; the import control generation module is specifically configured to: generating the table creation control according to the format of the source data table and the database interaction configuration information; generating the table loading control corresponding to the table creating control; and generating the table conversion control corresponding to the table creation control.
In this embodiment of the present application, as a possible implementation manner, the standard file loading module is specifically configured to: creating an intermediate data table and the target data table through the table creating control; the data type of the intermediate table is matched with the data type of the standard file; loading the data in the standard file into the intermediate data table through the table loading control; and loading the intermediate data table into the target data table through the table conversion control.
Therefore, the device provided by the application obtains the configuration information of the two types of databases from the database interaction configuration database by obtaining the type of the source database, the type of the source data table to be loaded in the source database and the type of the target database. Then, automatically generating a specific interaction module according to the configuration information and the type of the source data table, so that the data table in the source database is loaded in the target database, and the interaction between the databases is completed. Therefore, the interaction method for the supervision submission database provided by the embodiment of the application can automatically generate different interaction modules according to different types of databases and to-be-loaded data tables with different formats in the databases to complete interaction, so that manpower and material resources are saved, and the interaction modules in the application are automatically generated by the same standard, so that the influence on the stability and fault tolerance of the supervision submission system is small.
As can be seen from the above description of the embodiments, those skilled in the art can clearly understand that all or part of the steps in the above embodiment methods can be implemented by software plus a necessary general hardware platform. Based on such understanding, the technical solution of the present application may be essentially or partially implemented in the form of a software product, which may be stored in a storage medium, such as a ROM/RAM, a magnetic disk, an optical disk, etc., and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network communication device such as a media gateway, etc.) to execute the method according to the embodiments or some parts of the embodiments of the present application.
It should be noted that, in the present specification, the embodiments are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments may be referred to each other. The method disclosed by the embodiment corresponds to the system disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the system part for description.
It should also be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The foregoing description of the disclosed embodiments will enable those skilled in the art to make or use the invention in various modifications to these embodiments, which will be apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. An interactive method of supervising a submission database, the method comprising:
obtaining a first type of a source database, a format of a source data table and a second type of a target database;
acquiring the database interaction configuration information of the first type and the second type from a database interaction configuration library;
generating an interactive module according to the database interactive configuration information and the format of the source data table;
converting the source data table in the source database into a target data table through the interaction module, and loading the target data table to the target database; the format of the target data table is matched with the target database.
2. The method of claim 1, wherein the interactive module comprises a data export control and a data import control; generating an interaction module according to the database interaction configuration information and the format of the source data table, including:
generating the data export control according to the format of the source data table and a conversion function from the data type of the source data table to the data type of the standard file in the database interaction configuration information; the conversion function is used for realizing conversion of field granularity;
generating the data import control according to the format of the target data table and the database interaction configuration information; the format of the target data table is determined by the format of the source data table.
3. The method of claim 2, wherein the converting, by the interactive module, the source data table in the source database into a target data table comprises:
generating the standard file from the source data table in the source database through the data export control, and sending the standard file to the data import control;
and loading the data in the standard file to a target data table through the data import control.
4. The method of claim 2, wherein the data import control comprises: a table creation control, a table loading control and a table conversion control;
the generating the data import control according to the format of the target data table and the database interaction configuration information comprises:
generating the table creation control according to the format of the source data table and the database interaction configuration information;
generating the table loading control corresponding to the table creating control;
and generating the table conversion control corresponding to the table creation control.
5. The method of claim 4, wherein converting the source data table in the standard file into the target data table through the data import control comprises:
creating an intermediate data table and the target data table through the table creating control; the data type of the intermediate table is matched with the data type of the standard file;
loading the data in the standard file into the intermediate data table through the table loading control;
and loading the intermediate data table into the target data table through the table conversion control.
6. An interactive apparatus for supervising a submission database, the apparatus comprising:
the determining module is used for obtaining a first type of a source database, a format of a source data table and a second type of a target database;
the information acquisition module is used for acquiring the database interaction configuration information of the first type and the second type from a database interaction configuration library;
the generating module is used for generating an interactive module according to the interactive configuration information of the database and the format of the source data table;
the loading module is used for converting the source data table in the source database into a target data table through the interaction module and loading the target data table to the target database; the format of the target data table is matched with the target database.
7. The apparatus of claim 6, wherein the interaction module comprises a data export control and a data import control; the generation module comprises:
the export control generating module is used for generating the data export control according to the format of the source data table and a conversion function from the data type of the source data table to the data type of the standard file in the database interaction configuration information; the conversion function is used for realizing conversion of field granularity;
the import control generating module is used for generating the data import control according to the format of the target data table and the database interaction configuration information; the format of the target data table is determined by the format of the source data table.
8. The apparatus of claim 7, wherein the loading module comprises:
the standard file generation module is used for generating the standard file from the source data table in the source database through the data export control and sending the standard file to the data import control;
and the standard file loading module is used for loading the data in the standard file to a target data table through the data import control.
9. The apparatus of claim 7, wherein the data import control comprises: a table creation control, a table loading control and a table conversion control;
the import control generation module is specifically configured to:
generating the table creation control according to the format of the source data table and the database interaction configuration information;
generating the table loading control corresponding to the table creating control;
and generating the table conversion control corresponding to the table creation control.
10. The apparatus of claim 9, wherein the standard file loading module is specifically configured to:
creating an intermediate data table and the target data table through the table creating control; the data type of the intermediate table is matched with the data type of the standard file;
loading the data in the standard file into the intermediate data table through the table loading control;
and loading the intermediate data table into the target data table through the table conversion control.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011637688.6A CN112632176A (en) | 2020-12-31 | 2020-12-31 | Interaction method and device for supervising submission database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011637688.6A CN112632176A (en) | 2020-12-31 | 2020-12-31 | Interaction method and device for supervising submission database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112632176A true CN112632176A (en) | 2021-04-09 |
Family
ID=75290446
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011637688.6A Pending CN112632176A (en) | 2020-12-31 | 2020-12-31 | Interaction method and device for supervising submission database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112632176A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105205117A (en) * | 2015-09-09 | 2015-12-30 | 郑州悉知信息科技股份有限公司 | Data table migrating method and device |
| CN106844682A (en) * | 2017-01-25 | 2017-06-13 | 北京百分点信息科技有限公司 | Method for interchanging data, apparatus and system |
| CN106951536A (en) * | 2017-03-22 | 2017-07-14 | 努比亚技术有限公司 | Data method for transformation and system |
| CN108052681A (en) * | 2018-01-12 | 2018-05-18 | 毛彬 | The synchronous method and system of structural data between a kind of relevant database |
| CN109002474A (en) * | 2018-06-15 | 2018-12-14 | 北京信安世纪科技股份有限公司 | A kind of data migration method and device |
| CN111367987A (en) * | 2020-03-31 | 2020-07-03 | 西安震有信通科技有限公司 | Data import method, system and device suitable for multiple database types |
| CN111897856A (en) * | 2020-07-31 | 2020-11-06 | 平安普惠企业管理有限公司 | Supervision message generation method and device, electronic equipment and readable storage medium |
| CN111917825A (en) * | 2020-06-23 | 2020-11-10 | 中国建设银行股份有限公司 | Heterogeneous system data interaction method and device |
-
2020
- 2020-12-31 CN CN202011637688.6A patent/CN112632176A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105205117A (en) * | 2015-09-09 | 2015-12-30 | 郑州悉知信息科技股份有限公司 | Data table migrating method and device |
| CN106844682A (en) * | 2017-01-25 | 2017-06-13 | 北京百分点信息科技有限公司 | Method for interchanging data, apparatus and system |
| CN106951536A (en) * | 2017-03-22 | 2017-07-14 | 努比亚技术有限公司 | Data method for transformation and system |
| CN108052681A (en) * | 2018-01-12 | 2018-05-18 | 毛彬 | The synchronous method and system of structural data between a kind of relevant database |
| CN109002474A (en) * | 2018-06-15 | 2018-12-14 | 北京信安世纪科技股份有限公司 | A kind of data migration method and device |
| CN111367987A (en) * | 2020-03-31 | 2020-07-03 | 西安震有信通科技有限公司 | Data import method, system and device suitable for multiple database types |
| CN111917825A (en) * | 2020-06-23 | 2020-11-10 | 中国建设银行股份有限公司 | Heterogeneous system data interaction method and device |
| CN111897856A (en) * | 2020-07-31 | 2020-11-06 | 平安普惠企业管理有限公司 | Supervision message generation method and device, electronic equipment and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110351325B (en) | Data processing method and related equipment | |
| CN111125064B (en) | Method and device for generating database schema definition statement | |
| CN110543427B (en) | Test case storage method and device, electronic equipment and storage medium | |
| CN110795387B (en) | Data import method, data export device and data processing system | |
| CN112306861A (en) | Unittest and Jenkins tool-based interface automatic testing system and method | |
| CN111818175A (en) | Enterprise service bus configuration file generation method, device, equipment and storage medium | |
| CN110851511A (en) | Data synchronization method and device | |
| CN102880497B (en) | Complier and method for reusing and optimizing software management memory | |
| CN108897551A (en) | A kind of generation method and device of quoting resource relational tree | |
| CN104378362A (en) | Method and device for carrying out conversion of message interfaces | |
| CN112632176A (en) | Interaction method and device for supervising submission database | |
| CN111026451A (en) | Parameter configuration method and configuration tool for transformer substation terminal interval | |
| CN114090719A (en) | AST-based abstract semantic parsing analysis method and device and electronic equipment | |
| CN114648012A (en) | Bill processing method and device, electronic equipment and computer readable medium | |
| CN109063468A (en) | A kind of installation kit integrity verification and the method for reparation | |
| CN114022279A (en) | Service data error correction method, device, equipment and readable storage medium | |
| CN103729451A (en) | Method, device and system for recording information of database | |
| CN107544991A (en) | The method and apparatus of server process access request | |
| CN103631816A (en) | Method for configuring and applying service model across data sources and equipment | |
| CN113419957A (en) | Rule-based big data offline batch processing performance capacity scanning method and device | |
| CN112836479A (en) | Data report generation method, system and storage device | |
| CN113535334B (en) | Project construction method, device and storage medium based on Docker | |
| CN115599868B (en) | Data real-time synchronous processing method, system, equipment and medium | |
| CN111930415B (en) | Construction deployment method and device for large-scale software product | |
| CN104657138B (en) | Report preparing system and method based on script |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |