阅读说明：本技术 一种高效的元数据批量配置方法 (Efficient metadata batch configuration method ) 是由 李世彬 曹新彬 肖辉 舒建 黄钰 于 2021-04-25 设计创作，主要内容包括：本发明公开了一种高效的元数据批量配置方法,包括以下步骤：S1：用户配置资源目录以及源数据信息；S2：下载配置文件模板并进行配置；S3：将配置好的模板文件上传至服务器；S4：服务器完成匹配工作,并在配置文件列表中显示匹配成功的数据表；S5：判断匹配是否异常；若异常,则返回错误信息；S6：下载匹配后的配置文件查看结果,批量选择数据表进行保存完成元数据批量配置；S7：判断配置是否完成,若未完成,则返回错误信息；S8：通过可视化界面显示元数据配置信息。本发明通过提供的配置文件进行简单的配置,然后上传回服务器,完成数据库表的自动匹配,减少了用户的操作,简化了配置的过程。(The invention discloses an efficient metadata batch configuration method, which comprises the following steps: s1: configuring a resource directory and source data information by a user; s2: downloading a configuration file template and configuring; s3: uploading the configured template file to a server; s4: the server completes the matching work and displays the data table successfully matched in the configuration file list; s5: judging whether the matching is abnormal; if the abnormal condition exists, returning error information; s6: downloading the matched configuration file to check results, and selecting a data table in batches to store to complete the batch configuration of the metadata; s7: judging whether the configuration is finished or not, and if not, returning error information; s8: and displaying the metadata configuration information through a visual interface. The invention carries out simple configuration through the provided configuration file, and then uploads the configuration file back to the server to finish the automatic matching of the database table, thereby reducing the operation of users and simplifying the configuration process.)

1. An efficient metadata batch configuration method is characterized by comprising the following steps:

s1: configuring a resource directory and source data information by a user;

s2: downloading a configuration file template and configuring;

s3: uploading the configured template file to a server;

s4: the server completes the matching work and displays the data table successfully matched in the configuration file list;

s5: judging whether the matching is abnormal; if the abnormal condition exists, returning error information;

s6: downloading the matched configuration file to check results, and selecting a data table in batches to store to complete the batch configuration of the metadata;

s7: judging whether the configuration is finished or not, and if not, returning error information;

s8: and displaying the metadata configuration information through a visual interface.

2. The method as claimed in claim 1, wherein the source data information includes a database type, database connection information, and an object type, and the configuration file template required by the user is generated from the source data information.

3. The efficient metadata batch configuration method according to claim 2, wherein the database connection information comprises an IP, a user name, a password and a database name; the object types include tables and views.

4. The efficient metadata batch configuration method according to claim 1, wherein said step S2 includes the following sub-steps:

s201: downloading a configuration file template generated by the server according to the source data information;

s202: and configuring the data table name needing matching in the configuration file template.

5. The efficient metadata batch configuration method according to claim 1, wherein said step S4 includes the following sub-steps:

s401: the server analyzes the template file and takes out the user configuration data;

s402: the server inquires data of the data table according to the source data information;

s403: and matching the user configuration data with the data table data, and then taking out the data which is in line with the configuration in the source data.

6. The efficient metadata batch configuration method according to claim 1, wherein said step S6 includes the following sub-steps:

s601: selecting a required data table by a user;

s602: inquiring metadata according to a data table selected by a user;

s603: associating metadata information with metadata configuration, and storing the metadata information to a database;

s604: associating a metadata configuration with a resource directory;

s605: judging whether the data tables selected by the user successfully create the data sets or not; if all the creation is completed, ending; if not, the process returns to step S602.

Technical Field

The invention relates to the field of computer data integration, in particular to an efficient metadata batch configuration method.

Background

Metadata is information about the organization of data, data fields, and their relationships, and in short, metadata is data about data. With the gradual development of informatization, values contained in data are gradually mined and discovered by people, the collection of the data becomes one of the most popular topics at present, and before the collection of the data, metadata information needs to be configured to collect the matched data. At present, most of operations of a metadata batch configuration mode are complicated, and a user cannot quickly and efficiently create metadata configuration. For example, patent No. CN201711222117.4 discloses a method and an apparatus for configuring advertisement style metadata, in which standardized definitions are performed on metadata of advertisement styles to determine components corresponding to the metadata, and a large number of new advertisement styles can be obtained by arranging and combining components of different types of advertisement styles, thereby improving the update efficiency of advertisement styles. However, when a large amount of new metadata needs to be created, a large number of parameter configurations and creations are required, and the method is not applicable to a large amount of metadata configurations.

Disclosure of Invention

The invention aims to overcome the defects of the prior art, and provides an efficient metadata batch configuration method for solving the problem of complex metadata batch acquisition operation.

The purpose of the invention is realized by the following technical scheme:

an efficient metadata batch configuration method comprises the following steps:

s1: configuring a resource directory and source data information by a user;

s2: downloading a configuration file template and configuring;

s3: uploading the configured template file to a server;

s4: the server completes the matching work and displays the data table successfully matched in the configuration file list;

s5: judging whether the matching is abnormal; if the abnormal condition exists, returning error information;

s6: downloading the matched configuration file to check results, and selecting a data table in batches to store to complete the batch configuration of the metadata;

s7: judging whether the configuration is finished or not, and if not, returning error information;

s8: and displaying the metadata configuration information through a visual interface.

Furthermore, the source data information comprises a database type, database connection information and an object type, and a configuration file template required by the user is generated through the source data information.

Further, the database connection information includes an IP, a user name, a password, and a database name; the object types include tables and views.

Further, the step S2 includes the following sub-steps:

S201: downloading a configuration file template generated by the server according to the source data information;

s202: and inputting the table name of the data table needing matching in the configuration file template.

Further, the step S4 includes the following sub-steps:

s401: the server analyzes the template file and takes out the user configuration data;

s402: the server inquires data of the data table according to the source data information;

s403: and matching the user configuration data with the data table data, and then taking out the data which is in line with the configuration in the source data.

Further, the step S6 includes the following sub-steps:

s601: selecting a required data table by a user;

s602: inquiring metadata according to a data table selected by a user;

s603: associating metadata information with metadata configuration, and storing the metadata information to a database;

s604: associating a metadata configuration with a resource directory;

s605: judging whether the data tables selected by the user successfully create the data sets or not; if all the creation is completed, ending; if not, the process returns to step S602.

The invention has the beneficial effects that: the invention carries out simple configuration through the provided configuration file, and then uploads the configuration file back to the server to finish the automatic matching of the database table, thereby reducing the operation of users, simplifying the configuration process, and realizing the configuration of the metadata only by configuring some simple acquisition configuration information.

Drawings

FIG. 1 is a schematic flow diagram of the process of the present invention.

FIG. 2 is a schematic diagram of metadata batch creation of the present invention.

Detailed Description

In order to more clearly understand the technical features, objects, and effects of the present invention, embodiments of the present invention will now be described with reference to the accompanying drawings.

In this embodiment, as shown in fig. 1 and fig. 2, an efficient metadata batch configuration method includes the following steps:

s1: configuring a resource directory and source data information by a user;

s2: downloading a configuration file template and configuring;

s3: uploading the configured template file to a server;

s4: the server completes the matching work and displays the data table successfully matched in the configuration file list;

s5: judging whether the matching is abnormal; if the abnormal condition exists, returning error information;

s6: downloading the matched configuration file to check results, and selecting a data table in batches to store to complete the batch configuration of the metadata;

s7: judging whether the configuration is finished or not, and if not, returning error information;

s8: and displaying the metadata configuration information through a visual interface.

Furthermore, the source data information comprises a database type, database connection information and an object type, and a configuration file template required by the user is generated through the source data information.

Further, the database connection information includes an IP, a user name, a password, and a database name; the object types include tables and views.

Further, the step S2 includes the following sub-steps:

s201: downloading a configuration file template generated by the server according to the source data information;

s202: and inputting the table name of the data table needing matching in the configuration file template.

Further, the step S4 includes the following sub-steps:

s401: the server analyzes the template file and takes out the user configuration data;

s402: the server inquires data of the data table according to the source data information;

s403: and matching the user configuration data with the data table data, and then taking out the data which is in line with the configuration in the source data.

Further, the step S6 includes the following sub-steps:

s601: selecting a required data table by a user;

s602: inquiring metadata according to a data table selected by a user;

s603: associating metadata information with metadata configuration, and storing the metadata information to a database;

s604: associating a metadata configuration with a resource directory;

s605: judging whether the data tables selected by the user successfully create the data sets or not; if all the creation is completed, ending; if not, the process returns to step S602.

In this embodiment, the data loading mode is as follows:

1. and configuring data source information.

a) The database type of the configuration data source, database connection information (IP, username, password, database name, etc.), object type (table or view).

2. And downloading the configuration template.

a) Downloading a configuration template, and configuring the table name (which is not distinguished from case to case) needing to be matched in the [ English table name ] column of the template.

3. And uploading the configuration template.

4. The server analyzes the template and loads the corresponding object list.

a) And the server reads the data source information configured in the first step and loads all the data information.

b) And (c) the server analyzes the template file data and matches the template file data with the data information in the step a.

c) The matching data set is returned.

5. And after the user confirms, the server loads the metadata information of the specified object according to the configuration information.

a) And inquiring the metadata information according to the confirmed table.

b) The matching data set is returned.

Only some necessary source data configurations need to be selected to represent the databases that need to be collected; then, the data tables are matched by downloading and configuring the template, a server can finish a series of operations of analyzing the template file, reading related information from configuration information, matching with data table information of a data source and the like without paying attention to a specific implementation mode, and only a final object list needs to be confirmed, but the data tables to be configured do not need to be selected from a large number of tables; and the uploaded template file can be downloaded again to check the matching result list.

When a task of configuring metadata in batches starts to be executed, metadata query is carried out on a database in a mode of combining JDBC and SQL to finish data acquisition, then the metadata is added into an association table according to services in the same mode and is bound into a selected resource directory to finish batch configuration of the metadata. There is no need to find the metadata information separately from the data form by the query.

The invention carries out simple configuration through the provided configuration file, and then uploads the configuration file back to the server to finish the automatic matching of the database table, thereby reducing the operation of users, simplifying the configuration process, and realizing the configuration of the metadata only by configuring some simple acquisition configuration information.

The foregoing shows and describes the general principles and broad features of the present invention and advantages thereof. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are described in the specification and illustrated only to illustrate the principle of the present invention, but that various changes and modifications may be made therein without departing from the spirit and scope of the present invention, which fall within the scope of the invention as claimed. The scope of the invention is defined by the appended claims and equivalents thereof.