CN114090671A

CN114090671A - Data import method and device, electronic equipment and storage medium

Info

Publication number: CN114090671A
Application number: CN202111393093.5A
Authority: CN
Inventors: 刘均; 林举校
Original assignee: Shenzhen Launch Technology Co Ltd
Current assignee: Shenzhen Launch Technology Co Ltd
Priority date: 2021-11-23
Filing date: 2021-11-23
Publication date: 2022-02-25

Abstract

The application is applicable to the technical field of information, and provides a data import method, a data import device, electronic equipment and a storage medium, wherein the method comprises the following steps: acquiring data to be imported; judging whether a data table corresponding to the data to be imported exists in a target database or not; if the data table corresponding to the data to be imported does not exist in the target database, acquiring the table structure of the data to be imported; creating a corresponding target data table in the target database according to the table structure; and importing the data to be imported into the target data table. According to the method and the device, the data to be imported can be automatically imported into the target database only by inputting the data to be imported into the data import page, manual compiling of a script for creating a table is not needed, the database is not needed to execute the manually compiled script, code development amount is reduced, and labor cost and system maintenance cost are reduced.

Description

Data importing method and device, electronic equipment and storage medium

Technical Field

The present application belongs to the field of information technology, and in particular, to a data importing method and apparatus, an electronic device, and a storage medium.

Background

In the process of managing data, the import operation of the data is often used. However, in some current systems providing data services, if data needs to be added to a data table, a manual operation is required to write a data insertion script insert statement first, then execute the insert statement in a database, and write the data into the data table line by line. Because the insert statement can only write one line of data at a time, the number of insert statements needs to be written when more line of data needs to be added; accordingly, how many times the database needs to execute insert statements. The data import method has a complex import process, and causes a large code development amount, high labor cost and high maintenance cost.

Disclosure of Invention

The embodiment of the application provides a data import method and device, electronic equipment and a storage medium, and can solve the problem of complicated import process.

In a first aspect, an embodiment of the present application provides a data importing method, including:

acquiring data to be imported;

judging whether a data table corresponding to the data to be imported exists in a target database or not;

if the data table corresponding to the data to be imported does not exist in the target database, acquiring a table structure corresponding to the data to be imported;

creating a corresponding target data table in the target database according to the table structure;

and importing the data to be imported into the target data table.

Optionally, the determining whether the data table corresponding to the data to be imported exists in the target database includes:

acquiring a data name of the data to be imported;

judging whether the data name has a corresponding target table name in a first table according to a preset first table, wherein the target table name is the table name of one data table existing in a target database; the first table stores the corresponding relation between the data name and the table name;

if the data name has a corresponding target table name in the first table, judging that a data table corresponding to the data to be imported exists in the target database;

and if the data name does not have a corresponding target table name in the first table, judging that the data table corresponding to the data to be imported does not exist in the target database.

Optionally, the obtaining of the table structure corresponding to the data to be imported includes:

inquiring a table structure corresponding to the data to be imported according to a preset second table; the second table stores a table structure of a data table corresponding to at least one data;

if a table structure corresponding to the data to be imported is inquired, executing the steps of creating a corresponding target data table in the target database according to the table structure and the later step;

and if the table structure corresponding to the data to be imported cannot be inquired, analyzing the data to be imported to obtain the table structure of the data to be imported.

Optionally, the analyzing the data to be imported to obtain the table structure corresponding to the data to be imported includes:

analyzing the data to be imported, and acquiring the data name, the attribute number, the attribute name of each attribute and the field length of the attribute value of the data to be imported;

determining a table name according to the data name, determining the number of table fields according to the attribute number, determining the maximum field length of an attribute value corresponding to the attribute of the same attribute name according to the attribute name of each attribute and the field length of the attribute value, and determining the table field length corresponding to the attribute name according to the maximum field length of the attribute value;

and determining a table structure corresponding to the data to be imported according to the determined table name, the number of table fields, the attribute name and the length of the table fields.

Optionally, after the creating a corresponding target data table in the target database according to the table structure, the method further includes:

binding and storing the data name of the data to be imported and the table name of the target data table into the first table;

and binding and storing the data name of the data to be imported, the table name corresponding to the data to be imported, the attribute name and the table field length into the second table.

Optionally, after determining whether the data table corresponding to the data to be imported exists in the target database, the method further includes:

and if the data table corresponding to the data to be imported exists in the target database, importing the data to be imported into the corresponding existing data table.

Optionally, before the importing the data to be imported into the corresponding existing data table, the method further includes:

judging whether the format of the data to be imported is matched with the table structure of the existing data table;

if so, writing the data to be imported into a data table of the data to be imported;

and if not, generating a prompt message of import failure.

In a second aspect, an embodiment of the present application provides a data importing apparatus, including:

the data acquisition module is used for acquiring data to be imported;

the first judgment module is used for judging whether a data table corresponding to the data to be imported exists in a target database or not;

the table structure acquisition module is used for acquiring a table structure corresponding to the data to be imported if a data table corresponding to the data to be imported does not exist in the target database; (ii) a

The data table creating module is used for creating a corresponding target data table in the target database according to the table structure;

and the first data import module is used for importing the data to be imported into the target data table.

Optionally, the first determining module includes:

the acquisition unit is used for acquiring the data name of the data to be imported;

the judging unit is used for judging whether the data name has a corresponding target table name in a first table according to a preset first table, wherein the target table name is the table name of one data table existing in a target database; the first table stores the corresponding relation between the data name and the table name;

a first determining unit, configured to determine that a data table corresponding to the to-be-imported data exists in the target database if a corresponding target table name exists in the first table for the data name;

and a second determining unit, configured to determine that the data table corresponding to the to-be-imported data does not exist in the target database if the data name does not exist in the first table as a corresponding target table name.

Optionally, the obtaining unit includes:

the query subunit is used for querying the table structure corresponding to the data to be imported according to a preset second table; the second table stores a table structure of a data table corresponding to at least one data;

the first processing subunit is configured to, if the table structure corresponding to the to-be-imported data is queried, execute the steps of creating a corresponding target data table in the target database according to the table structure and then;

and the second processing subunit is used for analyzing the data to be imported and acquiring the table structure of the data to be imported if the table structure corresponding to the data to be imported cannot be inquired.

Optionally, the second processing subunit includes:

the analysis micro unit is used for analyzing the data to be imported, and acquiring the data name, the attribute number, the attribute name of each attribute and the field length of the attribute value of the data to be imported;

the table determining micro-unit is used for determining a table name according to the data name, determining the number of table fields according to the number of the attributes, determining the maximum field length of the attribute value corresponding to the attribute of the same attribute name according to the attribute name of each attribute and the field length of the attribute value, and determining the field length corresponding to the attribute name according to the maximum field length of the attribute value;

and the table structure determining micro unit is used for determining the table structure corresponding to the data to be imported according to the determined table name, the number of the table fields and the length of the table fields.

Optionally, the data importing apparatus further includes:

the first storage module is used for binding and storing the data name of the data to be imported and the table name of the target data table into the first table;

and the second storage module is used for binding and storing the data name of the data to be imported, the table name, the attribute name, the number of table fields and the length of the table fields corresponding to the data to be imported into the second table.

Optionally, the data importing apparatus further includes:

and the second data import module is used for importing the data to be imported into the corresponding existing data table if the data table corresponding to the data to be imported exists in the target database.

Optionally, the data importing apparatus further includes:

the second judgment module is used for judging whether the format of the data to be imported is matched with the table structure of the existing data table;

the third data import module is used for writing the data to be imported into the data table of the data to be imported if the data to be imported are matched;

and the prompt module is used for generating a prompt message of import failure if the input information is not matched with the input information.

In a third aspect, an embodiment of the present application provides an electronic device, including:

a memory, a processor and a computer program stored in the memory and executable on the processor, the computer program, when executed by the processor, implementing the steps of the data importing method according to the first aspect.

In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, including: the computer-readable storage medium stores a computer program which, when executed by a processor, implements the steps of the data import method described above in the first aspect.

In a fifth aspect, an embodiment of the present application provides a computer program product, which, when run on an electronic device, causes the electronic device to execute the steps of the data importing method described in the first aspect.

Compared with the prior art, the embodiment of the application has the advantages that: after data to be imported is obtained, if a data table corresponding to the data to be imported does not exist in a target database, a table structure of the data to be imported is obtained, a corresponding target data table is created in the target database according to the table structure, and finally the data to be imported is imported into the target data table.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required to be used in the embodiments or the prior art description will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings may be obtained according to these drawings without inventive labor.

Fig. 1 is a schematic flowchart of a data importing method according to an embodiment of the present application;

FIG. 2 is a schematic diagram of a piece of xml content in a data import method provided in an embodiment of the present application;

fig. 3 is a schematic structural diagram of a data importing apparatus according to an embodiment of the present application;

fig. 4 is a schematic structural diagram of an electronic device provided in an embodiment of the present application.

Detailed Description

In the following description, for purposes of explanation and not limitation, specific details are set forth, such as particular system structures, techniques, etc. in order to provide a thorough understanding of the embodiments of the present application. It will be apparent, however, to one skilled in the art that the present application may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present application with unnecessary detail.

It will be understood that the terms "comprises" and/or "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.

It should also be understood that the term "and/or" as used in this specification and the appended claims refers to and includes any and all possible combinations of one or more of the associated listed items.

As used in this specification and the appended claims, the term "if" may be interpreted contextually as "when", "upon" or "in response to" determining "or" in response to detecting ". Similarly, the phrase "if it is determined" or "if a [ described condition or event ] is detected" may be interpreted contextually to mean "upon determining" or "in response to determining" or "upon detecting [ described condition or event ]" or "in response to detecting [ described condition or event ]".

Furthermore, in the description of the present application and the appended claims, the terms "first," "second," "third," and the like are used for distinguishing between descriptions and not necessarily for describing or implying relative importance.

Reference throughout this specification to "one embodiment" or "some embodiments," or the like, means that a particular feature, structure, or characteristic described in connection with the embodiment is included in one or more embodiments of the present application. Thus, appearances of the phrases "in one embodiment," "in some embodiments," "in other embodiments," or the like, in various places throughout this specification are not necessarily all referring to the same embodiment, but rather "one or more but not all embodiments" unless specifically stated otherwise. The terms "comprising," "including," "having," and variations thereof mean "including, but not limited to," unless expressly specified otherwise.

Fig. 1 is a schematic flowchart illustrating a data importing method according to an embodiment of the present application, where as shown in fig. 1, the method includes steps S110 to S150. The specific realization principle of each step is as follows:

and S110, acquiring data to be imported.

The data import system can receive a selection instruction input by a data collator and determine data to be imported according to the selection instruction.

In some embodiments, after the data collator sorts the data, the data import page of the data import system may be logged in, and the data to be imported and the data name of the data to be imported may be input in the input text box of the data import page. For example, a piece of xml content in a standard format and a data name of the piece of xml content may be filled in the input text box. The piece of xml content is shown in fig. 2, and the data name of the piece of xml content may be "universal code".

The data to be imported may be a piece of xml content, an xml file, or an excel file.

And S120, judging whether the data table corresponding to the data to be imported exists in the target database.

In some embodiments, the first table may be created in advance. The first table is used for storing the corresponding relation between the data name and the target table name, wherein the target table name is the table name of one data table existing in the target database. If the table name of the first table is sys _ data _ table. Wherein, sys _ data _ table is shown in table 1:

TABLE 1

After the data to be imported and the data name of the data to be imported are obtained in step S110, it is determined whether the data name has a corresponding target table name in the first table according to a preset first table.

If the data name has a corresponding target table name in the first table, it may be determined that a data table corresponding to the data to be imported exists in the target database; and if the data name does not have a corresponding target table name in the first table, judging that the data table corresponding to the data to be imported does not exist in the target database.

For example, the user inputs a data name of "universal code" on the data import page and imports a piece of xml content, where the xml content is as shown in fig. 2. The data importing system learns that the data name of the xml content is a 'universal code', then judges whether a value of a data _ name field in sys _ data _ Table (a first Table) is the 'universal code', if the value of the data _ name field in sys _ data _ Table is not the 'universal code', the data Table corresponding to the data to be imported does not exist in a target database, if the 'universal code' exists, the data importing system continuously judges whether a specific value of the Table _ name field corresponding to the 'universal code', namely whether a corresponding target Table name exists, if the target Table name exists, the data Table corresponding to the data to be imported can be judged to exist in the target database, and if the 'universal code' corresponding Table _ name field is blank, the data Table corresponding to the data to be imported can be judged to not exist in the target database.

S130, if the data table corresponding to the data to be imported does not exist in the target database, acquiring the table structure corresponding to the data to be imported.

In an embodiment of the application, whether the table structure of the data to be imported is recorded is checked according to a pre-created second table, where the second table is used to store the table structure of a data table corresponding to at least one piece of data. (ii) a In another embodiment of the present application, a corresponding table structure may also be obtained by analyzing data to be imported.

S140, creating a corresponding target data table in the target database according to the table structure.

And according to the acquired table structure corresponding to the data to be imported, automatically generating a data table corresponding to the data to be imported.

S150, importing the data to be imported into the target data table.

After the generation of the target data table is detected, the system automatically leads the data to be imported into the target data table.

It should be understood that, in the above steps, after the data to be imported is obtained, it may be automatically determined whether a data table corresponding to the data to be imported exists in the target database, if the data table corresponding to the data to be imported does not exist in the target database, the data to be imported is analyzed to obtain a table structure corresponding to the data to be imported, and then the target data table is generated according to the table structure, so that the data to be imported can be imported into the target data table finally, and the automatic import of the data to be imported is realized.

In some embodiments, the step S130 of obtaining the table structure corresponding to the data to be imported includes:

s1301, inquiring a table structure corresponding to the data to be imported according to a preset second table; the second table stores a table structure of a data table corresponding to at least one data;

s1302, if the table structure corresponding to the data to be imported is inquired, the steps of creating a corresponding target data table in the target database according to the table structure and the subsequent steps are executed;

and S1303, if the table structure corresponding to the data to be imported cannot be inquired, analyzing the data to be imported to obtain the table structure of the data to be imported.

In some embodiments, a second table is created in advance, and the second table is used for storing a table structure of a data table corresponding to at least one data. Therefore, when it is determined that the data table corresponding to the data to be imported does not exist in the target database, the target data table needs to be created, and the created target data table needs to be created according to the table structure corresponding to the data to be imported, so that the data to be imported, which is needed by us, can be successfully imported into the target data table. Therefore, in some embodiments, the table structure corresponding to the data to be imported may be queried according to the second table, and if the table structure corresponding to the data to be imported is queried, the corresponding target data table may be created directly according to the queried table structure and the subsequent steps; if the table structure corresponding to the data to be imported cannot be queried, the data to be imported needs to be analyzed to obtain the table structure of the data to be imported, so that a target data table is created.

In the embodiment of the present application, the table name of the second table is sys _ table _ structure, where sys _ table _ structure is shown in table 2:

TABLE 2

The sys _ table _ structure table stores a table structure of a data table corresponding to at least one piece of data. The table structure corresponding to the data to be imported can be queried according to the sys _ table _ structure table.

The description will be made by taking the contents of one xml shown in fig. 2 as an example: it is queried whether the "sgmCoding" field is present in the sys _ table _ structure table. If not, it may be determined that the table structure of the xml content is not stored in the data import system, and if so, it indicates that the table structure of the xml content is already stored in the data import system.

In some embodiments, by analyzing the data to be imported, various types of information of the data to be imported can be obtained, so as to obtain a table structure of the data to be imported. Taking the xml content of fig. 2 as data to be imported for example, parsing the piece of xml content, where < sgmCoding > is a data name, i.e. an english translation of "universal code", where the data name < sgmCoding > includes two pieces of data, one piece of data is { sgmckey: 2BCB131F999B9A, sgmvale: 0x40000004,0x00000061,0x40000005,0x00000068,0x40000001,0x0000005C,0x4000000C }, and the other piece of data is { sgmckey: 2BCB131F999B9B, sgmvale: 0x40000004,0x00000061,0x40000005,0x00000068,0x40000001,0x0000005C,0x 0000 4000000D }. Wherein < sgmKey > and < sgmValue > are attribute names of data < sgmCoding >, and the following character strings (composed of letters and numbers) are attribute values corresponding to the attribute names. By analyzing the data to be imported, the data information of the data to be imported can be obtained, and thus the table structure of the data table required by the data to be imported can be obtained.

In some embodiments, analyzing the data to be imported and obtaining the table structure of the data to be imported may be implemented by the following steps:

and 11, analyzing the data to be imported, and acquiring the data name, the attribute number, the attribute name of each attribute and the field length of the attribute value of the data to be imported.

Taking the xml content in fig. 2 as an example of data to be imported, analyzing the xml content in fig. 2 can learn that the data name is sgmCoding, where the data includes two pieces of data, and each piece of data includes two attributes, namely, the xml content in fig. 2 includes four attributes, sgmckey and sgmValue are attribute names, 2BCB131F999B9A is an attribute value of < sgmckey > of the first piece of data, whose field length is 14, 0x40000004,0x00000061,0x40000005,0x00000068,0x40000001,0x0000005C,0x4000000C is an attribute value of < sgmValue > of the first piece of data, whose field length is 77; 2BCB131F999B9B is an attribute value of < sgmKey > of the second piece of data, whose field length is 14, 0x40000004,0x00000061,0x40000005,0x00000068,0x40000001,0x0000005C, and 0x4000000D are attribute values of < sgmvale > of the second piece of data, whose field length is 77. By analyzing the xml content, the data information of the data to be imported can be obtained.

And step 12, determining a table name according to the data name, determining the number of table fields according to the number of the attributes, determining the maximum field length of the attribute value corresponding to the attribute with the same attribute name according to the attribute name of each attribute and the field length of the attribute value, and determining the table field length corresponding to the attribute name according to the maximum field length of the attribute value.

In the embodiment of the application, the table name of the target data table is determined according to the data name of the data to be imported, so that the indexing is convenient; determining the number of table fields of a target data table according to the number of attributes of the data to be imported, wherein enough table fields can be stored for each data attribute of the data to be imported; and determining the table field length of the corresponding attribute according to the maximum character length of the attribute value corresponding to the attribute with the same attribute name, wherein the corresponding attribute value can be stored only by enough table field lengths. Taking the xml content of fig. 2 as an example of data to be imported, according to the data name sgmCoding, the table name "T _ SGM _ CODING" may be set, the number of table fields of the target data table is four, the table field length of the attribute value with the attribute name < sgmKey > is 100, and the table field length of the attribute value with the attribute name < sgmvale > is 100. In this embodiment, the table field length may be set to 100 units (the present invention is not limited thereto), and if the field length of the attribute value is less than 100, the table field length is taken to be 100, and if the field length of the attribute value is 101, the table field length is taken to be 200. And step 13, determining a table structure corresponding to the data to be imported according to the determined table name, the number of table fields, the attribute name and the length of the table fields.

Correspondingly, in step S140 of creating a corresponding target data table in the target database according to the table structure, sql statements may be automatically assembled by Java code or other programming code, and the sql statements that create the target data table corresponding to the data to be imported in the database are as follows:

and generating a blank target data table according to the sql statement, wherein the field length of the lower cell of the same column of the SGM _ KEY is 100, and the field length of the lower cell of the same column of the SGM _ VALUE is 100.

T_SGM_CODING

SGM_KEY	SGM_VALUE

TABLE 3

Correspondingly, step S150 of creating a corresponding target data table in the target database according to the table structure, and importing the data to be imported into the target data table includes:

in some embodiments, the data importing system may generate a data insertion statement according to a table structure corresponding to data to be imported, and then invoke the database driver to execute the data insertion statement, so as to import the data to be imported into a table created according to the table structure.

For example, for the xml content shown in fig. 2, the generated data insertion sql statement is as follows:

Insert into T_SGM_CODING(SGM_KEY,SGM_VALUE)values('2BCB131F999B9A','0x40000004,0x00000061,0x40000005,0x00000068,0x40000001,0x0000005C,0x4000000C')

the data in the xml content can be imported into the T _ SGM _ CODING table by generating a data insertion sql statement by Java code, wherein the more values of the sub-tags of the < SGM CODING > tag in the xml content, the more data is inserted into the T _ SGM _ CODING table. The xml content shown in fig. 2 is imported into the T _ SGM _ CODING table, and the T _ SGM _ CODING table is shown in table 4:

TABLE 4

It should be understood that, in the above steps, the table structure corresponding to the data to be imported may be determined according to the target table name of the data to be imported, the number of attributes of the data to be imported, the attribute name of each attribute, and the maximum character length of each attribute value, and the table may be created according to the structure, without manually writing a script for creating the table, or without executing the manually written script by the database, thereby reducing the code development amount, and reducing the labor cost and the system maintenance cost.

In some embodiments, after the step S140 of creating a corresponding target data table in the target database according to the table structure, the following steps may be further performed:

and step 21, binding and storing the data name of the data to be imported and the table name of the target data table into the first table.

After the target data table corresponding to the data to be imported is created, the data name of the data to be imported and the table name of the target data table can be bound and stored in the first table, and whether the corresponding data table exists or not can be judged conveniently when the data is imported subsequently.

For example, the data name "universal code" and the target table name "T _ SGM _ CODING" may be bound and stored into the sys _ data _ table, as shown in table 5.

Name of field

Universal coding

T_SGM_CODING

TABLE 5

And step 22, binding and storing the data name of the data to be imported, the table name corresponding to the data to be imported, the attribute name and the table field length into a second table, so that when the data is continuously imported subsequently, the table structure of the data to be imported can be inquired according to the second table.

Specifically, the following data may be inserted into the sys _ table _ structure table by Java code, as shown in table 6:

TABLE 6

In some embodiments, after the step S120 of determining whether the data table corresponding to the data to be imported exists in the target database, the method may further include the following steps:

and 31, if the data table corresponding to the data to be imported exists in the target database, importing the data to be imported into the corresponding existing data table.

It should be understood that, in the above steps, if the data table corresponding to the data to be imported exists in the target database, the data to be imported may be directly imported into the corresponding existing data table, and there is no need to manually write a table creation script and a plurality of insert statements, nor to execute a manually written table creation script and insert statements by the database, which reduces the code development amount, and reduces the labor cost and the system maintenance cost.

In some embodiments, before step 31, the following steps may also be performed:

41. judging whether the format of the data to be imported is matched with the table structure of the existing data table;

42. if the data to be imported is matched with the data to be imported, importing the data to be imported into a data table of the data to be imported;

43. and if not, generating a prompt message of import failure.

In some embodiments, after the data import system determines that the data table corresponding to the data to be imported exists in the target database, it may be determined whether the format of the data to be imported matches the table structure of the existing data table. If there is no match, the data cannot be successfully imported.

The data import system can judge whether the format of the data to be imported is matched with the table structure of the existing data table or not through the following steps:

step 11, acquiring a table structure of the existing data table according to a preset second table, wherein the table structure comprises a data name, a table name, an attribute name, a table field number and a table field length;

step 12, judging whether the number of the attributes of the data to be imported is consistent with the number of the table fields, and judging whether the maximum field length of the attribute value of the attributes is smaller than or equal to the corresponding table field length aiming at the attributes with the same attribute name;

step 13, if the number of the attributes of the data to be imported is consistent with the number of the table fields and the attributes with the same attribute name are determined that the maximum field length of the attribute value is smaller than or equal to the corresponding table field length, determining that the format of the data to be imported is matched with the table structure of the existing data table; otherwise, judging that the format of the data to be imported is not matched with the table structure of the existing data table.

The data to be imported can be analyzed, the number of the attributes of the data to be imported is extracted, and the maximum field length of the attribute value of the data to be imported is obtained aiming at the attributes with the same attribute name. Meanwhile, table structure information of an existing corresponding data table also needs to be acquired, and specifically, the table structure information may be acquired through the second table or may be acquired directly according to the data table.

For example, taking the contents of one xml shown in fig. 2 as an example, if the corresponding data table T _ SGM _ CODING already exists in the target database, format matching is required when importing the data. Specifically, the data name of the data to be imported is "sgmCoding", and the corresponding data table is found as T _ SGM _ CODING according to the first table. The data import system can extract that the xml content has four attributes, namely two sgmKey and two sgmValue, and can obtain the character length of each attribute value in a data recursion mode.

As shown in table 5, in the T _ SGM _ CODING data table, the number of fields is the same as the number of attributes in each < sgmCoding > tag in xml content, and is four, and in the data to be imported, the maximum field length for an attribute value with an attribute name < sgmckey > is 14, the maximum field length for an attribute value with an attribute name < sgmvale > is 77, in the T _ SGM _ CODING data table, the table field length corresponding to an attribute value with an attribute name < sgmckey > is 100, and the table field length corresponding to an attribute value with an attribute name < sgmvale > is 100, so that the maximum field length for an attribute value with an attribute name < sgmckey > is smaller than the corresponding table field length, and the maximum field length for an attribute value with an attribute name < sgmcale > is also smaller than the corresponding table field length. Therefore, it can be determined that the format of the xml content matches the table structure of the existing data table.

In some embodiments, after the data is successfully imported, the imported data can be queried.

The method can realize the query of the imported data through the following steps:

step 51, acquiring an input data name and query conditions;

step 52, determining a corresponding data table according to the input data name;

and 53, generating a query script according to the determined data table and the query condition, querying in the determined data table and generating a query result.

When data query is performed, the query data "universal code" can be selected, and the input query condition is a query condition in json (JavaScript Object Notation) format, such as { "sgmKey": 2BCB131F999B9 "," sgmValue ": 0x40000004,0x 00000061" }. Finding a corresponding data table as T _ SGM _ CODING in the first table according to the general codes, and generating a query script according to the T _ SGM _ CODING and the query conditions; the specific query script is as follows:

select SGM_KEY as sgmKey,SGM_VALUE as sgmValue from T_SGM_CODING where SGM_KEY like'％2BCB131F999B9％'and SGM_VALUE like'％x40000004,0x00000061％'。

the script query result can be generated by java to be an array in a JSO format, for example:

{data:[{"sgmKey":"2BCB131F999B9A","sgmValue":"0x40000004,0x00000061,0x40000005,0x00000068,0x40000001,0x0000005C,0x4000000C"},{"sgmKey":"2BCB131F999B9B","sgmValue":"0x40000004,0x00000061,0x40000005,0x00000068,0x40000001,0x0000005C,0x4000000D"}]}

finally, the array data showing the JSON format can be analyzed by a page or a client.

Corresponding to the data importing method shown in fig. 1, fig. 3 shows a data importing apparatus M100 provided in an embodiment of the present application, including:

a data obtaining module M110, configured to obtain data to be imported;

a first judging module M120, configured to judge whether a data table corresponding to the data to be imported exists in a target database;

a table structure obtaining module M130, configured to obtain a table structure corresponding to the data to be imported if a data table corresponding to the data to be imported does not exist in the target database;

a data table creating module M140, configured to create a corresponding target data table in the target database according to the table structure;

a first data importing module M150, configured to import the data to be imported into the target data table.

Preferably, the first judging module M120 includes:

a first determination unit, configured to determine that a data table corresponding to the to-be-imported data exists in the target database if a corresponding target table name exists in the first table for the data name;

Preferably, the acquiring unit includes:

Preferably, the second processing subunit includes:

and the table structure determining micro unit is used for determining the table structure corresponding to the data to be imported according to the determined table name, the number of the table fields, the attribute name and the length of the table fields.

Preferably, the data importing apparatus M100 further includes:

and the second storage module is used for binding and storing the data name of the data to be imported, the table name corresponding to the data to be imported, the attribute name and the table field length into the second table.

Preferably, the data importing apparatus M100 further includes:

It is understood that various embodiments and combinations of the embodiments in the above embodiments and their advantages are also applicable to this embodiment, and are not described herein again.

Fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present application. As shown in fig. 4, the electronic device D10 of this embodiment includes: at least one processor D100 (only one is shown in fig. 4), a memory D101, and a computer program D102 stored in the memory D101 and operable on the at least one processor D100, wherein the processor D100 implements the steps of any of the method embodiments described above when executing the computer program D102. Alternatively, the processor D100, when executing the computer program D102, implements the functions of the modules/units in the device embodiments, such as the functions of the modules M110 to M150 shown in fig. 3.

In some embodiments, the processor D100, when executing the computer program D102, performs the following steps:

acquiring data to be imported;

and importing the data to be imported into the target data table.

Preferably, the processor D100 executes the computer program D102 to implement the following steps when determining whether the data table corresponding to the data to be imported exists in the target database:

acquiring a data name of the data to be imported;

judging whether the data name has a corresponding target table name in a first table according to a preset first table, wherein the target table name is the table name of one data table existing in a target database; the first table stores the corresponding relation between the data name and the target table name;

Preferably, the processor D100 executes the computer program D102, and when obtaining the table structure of the data to be imported, further implements the following steps:

if the table structure corresponding to the data to be imported is inquired, the steps of creating a corresponding target data table in the target database according to the table structure and the subsequent steps are executed;

Preferably, the processor D100 executes the computer program D102 to analyze the data to be imported and further implement the following steps when obtaining the table structure of the data to be imported:

Preferably, the processor D100 executes the computer program D102, and after creating the corresponding target data table in the target database according to the table structure, further performs the following steps:

Preferably, after the processor D100 executes the computer program D102 to determine whether the data table corresponding to the data to be imported exists in the target database, the method may further include the following steps:

Preferably, the processor D100 executes the computer program D102, and before the step of importing the data to be imported into the corresponding existing data table is implemented, the method may further include the following steps:

and if not, generating a prompt message of import failure.

The electronic device D10 may be a desktop computer, a notebook, a palm computer, a cloud server, or other computing devices. The electronic device may include, but is not limited to, a processor D100, a memory D101. Those skilled in the art will appreciate that fig. 4 is merely an example of the electronic device D10 and does not constitute a limitation of the electronic device D10, and may include more or fewer components than those shown, or some components in combination, or different components, such as input output devices, network access devices, etc.

Processor D100 may be a Central Processing Unit (CPU), and Processor D100 may be other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field-Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, discrete hardware component, etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

The storage D101 may be an internal storage unit of the electronic device D10 in some embodiments, such as a hard disk or a memory of the electronic device D10. In other embodiments, the memory D101 may also be an external storage device of the electronic device D10, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like, which are provided on the electronic device D10. Further, the memory D101 may also include both an internal storage unit and an external storage device of the electronic device D10. The memory D101 is used for storing an operating system, an application program, a BootLoader (BootLoader), data, and other programs, such as program codes of the computer programs. The memory D101 may also be used to temporarily store data that has been output or is to be output.

It should be noted that, for the information interaction, execution process, and other contents between the above-mentioned devices/units, the specific functions and technical effects thereof are based on the same concept as those of the embodiment of the method of the present application, and specific reference may be made to the part of the embodiment of the method, which is not described herein again.

It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-mentioned division of the functional units and modules is illustrated, and in practical applications, the above-mentioned function distribution may be performed by different functional units and modules according to needs, that is, the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-mentioned functions. Each functional unit and module in the embodiments may be integrated in one processing unit, or each unit may exist alone physically, or two or more units are integrated in one unit, and the integrated unit may be implemented in a form of hardware, or in a form of software functional unit. In addition, specific names of the functional units and modules are only used for distinguishing one functional unit from another, and are not used for limiting the protection scope of the present application. For the specific working processes of the units and modules in the system, reference may be made to the corresponding processes in the foregoing method embodiments, which are not described herein again.

The embodiments of the present application further provide a computer-readable storage medium, where a computer program is stored, and when the computer program is executed by a processor, the steps in the above-mentioned method embodiments may be implemented.

Embodiments of the present application provide a computer program product, which when executed on an electronic device, enables the electronic device to implement the steps in the above method embodiments.

The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, all or part of the processes in the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium and can implement the steps of the embodiments of the methods described above when the computer program is executed by a processor. Wherein the computer program comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, etc. The computer readable medium may include at least: any entity or device capable of carrying computer program code to a photographing apparatus/terminal apparatus, a recording medium, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM), electrical carrier wave signal, telecommunication signal, and software distribution medium. Such as a usb-disk, a removable hard disk, a magnetic or optical disk, etc. In certain jurisdictions, computer-readable media may not be an electrical carrier signal or a telecommunications signal in accordance with legislative and patent practice.

In the above embodiments, the descriptions of the respective embodiments have respective emphasis, and reference may be made to the related descriptions of other embodiments for parts that are not described or illustrated in a certain embodiment.

Those of ordinary skill in the art will appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the technical solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.

In the embodiments provided in the present application, it should be understood that the disclosed apparatus/network device and method may be implemented in other ways. For example, the above-described apparatus/network device embodiments are merely illustrative, and for example, the division of the modules or units is only one logical division, and there may be other divisions when actually implementing, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not implemented. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.

The above-mentioned embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not substantially depart from the spirit and scope of the embodiments of the present application and are intended to be included within the scope of the present application.

Claims

1. A data importing method, comprising:

acquiring data to be imported;

and importing the data to be imported into the target data table.

2. The data importing method according to claim 1, wherein the determining whether the data table corresponding to the data to be imported exists in the target database comprises:

acquiring a data name of the data to be imported;

3. The data import method according to claim 2, wherein the obtaining the table structure corresponding to the data to be imported includes:

4. The data import method according to claim 3, wherein the analyzing the data to be imported and obtaining the table structure corresponding to the data to be imported includes:

and determining a table structure corresponding to the data to be imported according to the determined table name, the number of the table fields, the attribute name and the length of the table fields.

5. The data import method of claim 4, further comprising, after the creating a corresponding target data table in the target database according to the table structure:

6. The data import method according to claim 1, wherein after determining whether the data table corresponding to the data to be imported exists in the target database, the method further comprises:

7. The data import method according to claim 6, wherein before the importing the data to be imported into the corresponding existing data table, the method further comprises:

and if not, generating a prompt message of import failure.

8. A data importing apparatus, comprising:

the data acquisition module is used for acquiring data to be imported;

the table structure acquisition module is used for acquiring a table structure corresponding to the data to be imported if a data table corresponding to the data to be imported does not exist in the target database;

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the data import method of any of claims 1 to 7 when executing the computer program.

10. A computer-readable storage medium storing a computer program, wherein the computer program, when executed by a processor, implements the data import method according to any one of claims 1 to 7.