WO2019161645A1

WO2019161645A1 - Shell-based data table extraction method, terminal, device, and storage medium

Info

Publication number: WO2019161645A1
Application number: PCT/CN2018/101880
Authority: WO
Inventors: 林林; 戴建明
Original assignee: 平安科技（深圳）有限公司
Priority date: 2018-02-24
Filing date: 2018-08-23
Publication date: 2019-08-29
Also published as: CN108536745B; CN108536745A

Abstract

Disclosed in the present application are a Shell-based data table extraction method, a terminal, a device, and a storage medium. The method comprises: identifying data tables in a Shell script; extracting the table names of the data tables; classifying the data tables according to the extracted table names, wherein the data tables comprise a source table and a target table; and obtaining data information corresponding to different types of data tables, and outputting the obtained different types of data information into the same preset document. By using the improved data table extraction method in the present application, there is no need to search for data tables related to each script manually and complicatedly, sorting and updating processes are simplified to the maximum extent, and a large amount of manpower resources can be saved.

Description

Shell-based data table extraction method, terminal, device and storage medium

This application is required to be submitted to the China Patent Office on February 24, 2018, the application number is CN201810156612.8, and the application name is “Shell-based data table extraction method, terminal, equipment and storage medium” and submitted on March 9, 2018. The Chinese Patent Office, Application No. CN201810196485.4, the priority of the entire disclosure of the entire disclosure of the entire disclosure of the disclosure of the disclosure of the disclosure of the disclosure of the disclosure of the disclosure of the disclosure of the disclosure of the disclosure of

Technical field

The present application relates to the field of computer technology, and in particular, to a Shell-based data table extraction method, terminal, device, and storage medium.

Background technique

Shell is a free programming language for communicating between automated and interactive tasks without human intervention. Use it to create a script to provide input to a command or program. The shell can simulate the input of the standard input provided by the program according to the prompt of the program to implement interactive program execution.

In the existing shell script application, the shell script often involves more data tables. If you manually sort each shell script to get the data table in the shell script, the extraction process will be very time consuming, and The workload is very large; in addition, the statement of the data table in the shell script will change with the modification of the application version. It takes a lot of manpower to manually organize and update the information, and the compiled data table is also prone to appear. error.

Summary of the invention

In view of this, the embodiment of the present application provides a Shell-based data table extraction method, terminal, device, and storage medium, which can simplify the finishing and updating process to the greatest extent, and can save a lot of human resources.

In one aspect, the embodiment of the present application provides a Shell-based data table extraction method, where the method includes:

Identify the data tables in the shell script;

Extracting the table name of the data table;

Sorting the data table according to the extracted table name, wherein the data table includes a source table and a target table;

Obtaining data information corresponding to different types of data tables, and outputting the acquired different types of data information to the same preset document.

On the other hand, the embodiment of the present application provides a shell-based data table extraction terminal, where the terminal includes:

a recognition unit for identifying a data table in the shell script;

An extracting unit, configured to extract a table name of the data table;

a classification unit, configured to classify the data table according to the extracted table name, where the data table includes a source table and a target table;

The obtaining unit is configured to obtain data information corresponding to different types of data tables, and output the obtained different types of data information into the same preset document.

In another aspect, the embodiment of the present application further provides a Shell-based data table extraction device, including:

a memory for storing a program implementing the data table extraction method;

a processor for running a program for implementing the data table extraction method stored in the memory to perform the following operations:

Identify the data tables in the shell script;

Extracting the table name of the data table;

In still another aspect, the embodiment of the present application further provides a computer readable storage medium, where the one or more computer programs are stored, and the one or more computer programs may be one or more The processor executes to implement the following steps:

Identify the data tables in the shell script;

Extracting the table name of the data table;

The improved data table extraction method of the application of the present application does not require manual and cumbersome search for each script-related data table, greatly simplifies the collation and update process, and can save a lot of human resources.

DRAWINGS

In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings used in the description of the embodiments will be briefly described below. Obviously, the drawings in the following description are some embodiments of the present application, For the ordinary technicians, other drawings can be obtained based on these drawings without any creative work.

1 is a schematic flow chart of a Shell-based data table extraction method according to an embodiment of the present application;

2 is a schematic flowchart of a Shell-based data table extraction method according to an embodiment of the present application;

3 is a schematic flowchart of a method for extracting a data table based on a shell provided by an embodiment of the present application;

4 is a schematic flowchart of a Shell-based data table extraction method according to an embodiment of the present application;

FIG. 5 is a schematic flowchart of a method for extracting a data table based on a shell according to another embodiment of the present application; FIG.

6 is a schematic block diagram of a shell-based data table extraction terminal according to an embodiment of the present application;

FIG. 7 is another schematic block diagram of a shell-based data table extracting terminal according to an embodiment of the present application; FIG.

FIG. 8 is another schematic block diagram of a shell-based data table extracting terminal according to an embodiment of the present application; FIG.

9 is another schematic block diagram of a shell-based data table extraction terminal according to an embodiment of the present application;

FIG. 10 is another schematic block diagram of a shell-based data table extraction terminal according to an embodiment of the present application; FIG.

FIG. 11 is a schematic structural diagram of a Shell-based data table extraction device according to an embodiment of the present application.

Detailed ways

The technical solutions in the embodiments of the present application are clearly and completely described in the following with reference to the drawings in the embodiments of the present application. It is obvious that the described embodiments are a part of the embodiments of the present application, and not all of the embodiments. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments of the present application without departing from the inventive scope are the scope of the present application.

The use of the terms "comprising", "comprising", "","," The presence or addition of a plurality of other features, integers, steps, operations, elements, components, and/or collections thereof.

The terminology used herein is for the purpose of describing particular embodiments and is not intended to be limiting. As used in the specification and the appended claims, the claims

Please refer to FIG. 1. FIG. 1 is a schematic flowchart of a method for extracting a data table based on a shell according to an embodiment of the present application. The method can be run on terminals such as smart phones (such as Android phones, IOS phones, etc.), tablets, laptops, and smart devices. The data dimension generation method described in the embodiment of the present application does not require manual cumbersome search for each script-related data table, greatly simplifies the collation and update process, and can save a lot of human resources. 1 is a schematic flow chart of a Shell-based data table extraction method provided by an embodiment of the present application. The method includes steps S101 to S104.

S101. Identify a data table in the shell script.

In the embodiment of the present application, the data table refers to a related data table that is called from a database through a SQL statement in a shell script; the database is connected in a shell script and the data table is called to obtain a database. In the daily operation and maintenance work, the data in the database can be obtained to achieve the purpose of monitoring certain information in the database, so as to further understand the performance of the device in real time.

Identifying the data table in the shell script can be implemented by identifying the keyword in the SQL statement. For example, the insert statement "insert into" can be identified to identify the data table following the insert statement; the query can be identified by identifying the query *from", thereby identifying the data table following the query statement; also identifying the update statement "update" to identify the data table following the update statement; also identifying the delete statement "delete from" Delete the data table followed by the statement and so on.

S102. Extract a table name of the data table.

In the embodiment of the present application, after identifying the data table in the shell script, extracting the table name of the identified data table, for example, in the insert statement "insert into {TABLENAME}", extracting the table name of the data table Is "TABLENAME"; in the query statement "select*from{USERNAME}", the table name of the extracted data table is "USERNAME", and the table name of the data table extracted in the update statement "update{DBNAME}" "DBNAME", the table name of the data table extracted in the delete statement "delete from{KBNAME}" is "KBNAME".

S103. Sort the data table according to the extracted table name, where the data table includes a source table and a target table.

In the embodiment of the present application, after extracting the table name of the data table by using a keyword of a series of SQL statements, the data table table name is stored in the temporary file, and the type of the data table includes a source table and a target table, where The method for classifying the type of the data table according to the name of the data table may be: if the table name of the data table is an independent string, and there is a space or a new line before and after the independent string, and the from keyword is followed by the table name. Then the type of the data table is a source table, if the data table table name is a separate string, and the independent string has spaces or newlines before and after the table name and the non-from keyword is followed by the table name, then the type of the data table For the target table, optional, non-from keywords can be into, update and other SQL statement keywords.

Further, as shown in FIG. 2, the step S103 includes steps S201 to S202.

S201. Determine a character string corresponding to the data table table name.

In the embodiment of the present application, the character string refers to a string of characters corresponding to the table name of the data table. Since the table name of the data table may be composed of numbers, letters, and underscores, the string may also be a number, A character consisting of letters and underscores.

S202. Sort the data table according to the character string.

In the embodiment of the present application, the data table is classified according to the character string, and the classification method is related to the SQL statement keyword in front of the data table table name, and the classification method may be: if the data table table name is an independent a string, and the independent string has spaces or newlines before and after the table name and the following keyword are followed by the from keyword, then the type of the data table is a source table, if the data table table name is an independent string, and the independent character There are spaces or newlines before and after the string and the non-from keyword is followed by the table name. Then the type of the data table is the target table. Optionally, the non-from keyword can be the SQL statement keyword such as into, update, and so on. By classifying the data table by the character string, the interference of the invalid data table to the valid data table can be excluded, for example, from_unixtime, and characters following such from not belonging to the specified content are recognized as invalid data tables. This situation is not considered.

S104. Acquire data information corresponding to different types of data tables, and output the acquired different types of data information into the same preset document.

In the embodiment of the present application, the data table is a Hadoop JOB association table, and the Hadoop JOB association table is written by using a Hadoop statement and a SQL statement, and is saved in a corresponding database, and the Hadoop JOB association table is used. The table name is written into the corresponding shell script. When the Hadoop JOB association table needs to be identified, the table name in the shell script is extracted first, that is, which JOB association tables are involved in the script, and the JOB associations are identified. Whether the type of the table belongs to the source table or the target table.

It should be noted that the source table refers to the table inside Hadoop and the table of the external relational database. The string of the source table has spaces or newlines before and after the string, and the table name is followed by the from keyword; the target table refers to Write mode is divided into insert target table and overlay target table, such as insert into tableA, this is the insert target table, insert overwrite tableB, this is the overlay target table, the preset document can be the default database In the data table, for example, capture keywords and their related content from the script of the JOB association table, and record the captured content into a temporary file, which is done at the hdfs level of Hadoop, and then in the temporary file The result is loaded into the Hive table of the Hadoop. The data in the Hive table is output to the specified preset Oracle database through the Sqoop method. Specifically, the data information is output to the pre-established data in the preset Oracle database. In the table. Optionally, the user can form a pre-established data table storing data information into an Oracle Pkg (Oracle packaging, Oracle packaging file). If the data table is needed for optimization, only the Oracle Pkg needs to be optimized.

Further, as shown in FIG. 3, if the data table is a source table, the step S104 includes steps S301 to S303.

S301. The source table is divided into an internal source table and an external source table.

In the embodiment of the present application, the internal source table refers to a table inside Hadoop (for example, a Hive table of Hadoop), and the external source table refers to a table of an external relational database.

S302. Acquire data information corresponding to the internal source table and the external source table.

In the embodiment of the present application, the data information includes table information, field information, and the like, where the table information may be a table name, a table type, or the like, and the field information may be a field name, a field type, or the like.

S303. Output the acquired data information into the preset document.

In the embodiment of the present application, the preset document may be a pre-established data table in the preset Oracle database. Specifically, the acquired data information may be output to the pre-established data in the preset Oracle database. In the table, and the user can store the pre-established data table with data information and form an Oracle Pkg (Oracle packaging, Oracle package file). If you need to optimize the data table, you only need to optimize the Oracle Pkg to optimize. Preset the default data table created in the Oracle database.

Further, as shown in FIG. 4, if the data table is a target table, the step S104 includes steps S401 to S403.

S401. The target table is divided into an insertion target table and an overlay target table.

In the embodiment of the present application, the insertion target table is, for example, the table tableA in the SQL statement "insert into table A", and the type of the target table is determined by the SQL statement keyword in front of the data table table name, such as into followed by insertion. The target table, the coverage target table such as the table table B in the SQL statement "insert overwrite tableB", the type of the target table is determined by the SQL statement keyword in front of the data table table name, such as overwrite followed by the overlay target table.

S402. Acquire data information corresponding to the insertion target table and the coverage target table.

S403. Output the acquired data information into a preset document.

It can be seen from the above that the embodiment of the present application identifies the data table in the shell script, extracts the table name of the data table, and classifies the data table according to the extracted table name, where the data table includes the source table and the target. The data information corresponding to different types of data tables is obtained, and the obtained different types of data information are output to the same preset document. The improved data table extraction method of the application of the present application does not require manual and cumbersome search for each script-related data table, greatly simplifies the collation and update process, and can save a lot of human resources.

Please refer to FIG. 5. FIG. 5 is a schematic flowchart of a Shell-based data table extraction method according to an embodiment of the present application. The method can be run on terminals such as smart phones (such as Android phones, IOS phones, etc.), tablets, laptops, and smart devices. As shown in FIG. 5, the method includes steps S501 to S506.

S501. The shell script is traversed according to a preset keyword.

In the embodiment of the present application, when the shell script is traversed, the rule for creating a short time is traversed by using a rule that traverses the data table first, and then traversing the rule that the data table is established for a long time, thereby implementing a data table for the shell script. The traversal of the shell script from the creation time to the long creation time traversal rules, can improve the efficiency of the shell script processing.

S502: Locating the data table in the shell script according to the result of the traversal.

In the embodiment of the present application, the position of the data table in the shell script is displayed by using the traversal result of the shell script, and the data table in the shell script is located by using the position information of the displayed data table.

S503, identifying a data table in the shell script.

S504. Extract a table name of the data table.

S505. The data table is classified according to the extracted table name, where the data table includes a source table and a target table.

S506. Acquire data information corresponding to different types of data tables, and output the obtained different types of data information into the same preset document.

It should be noted that the source table refers to the table inside Hadoop and the table of the external relational database. The string of the source table has spaces or newlines before and after the string, and the table name is followed by the from keyword; the target table refers to Write mode is divided into insert target table and overlay target table, such as insert into tableA, this is the insert target table, insert overwrite tableB, this is the overlay target table, the preset document can be the default database In the data table, for example, capture keywords and their related content from the script of the JOB association table, and record the captured content into a temporary file, which is done at the hdfs level of Hadoop, and then in the temporary file The result is loaded into the Hive table of the Hadoop. The data in the Hive table is output to the specified preset Oracle database through the Sqoop method. Specifically, the data information is output to the pre-established data in the preset Oracle database. In the table. Optionally, the user can store a pre-established data table with data information and form an Oracle Pkg (Oracle packaging, Oracle package file). If the data table is needed for optimization, only the Oracle Pkg needs to be optimized.

Referring to FIG. 6 , corresponding to the above-mentioned Shell-based data table extraction method, the embodiment of the present application further provides a Shell-based data table extraction terminal, where the terminal 100 includes: an identification unit 101, an extraction unit 102, a classification unit 103, The acquisition unit 104.

The identification unit 101 is configured to identify a data table in the shell script.

The extracting unit 102 is configured to extract a table name of the data table.

The classification unit 103 is configured to classify the data table according to the extracted table name, wherein the data table includes a source table and a target table.

The obtaining unit 104 is configured to acquire data information corresponding to different types of data tables, and output the acquired different types of data information into the same preset document.

As shown in FIG. 7, the classification unit 103 includes:

The determining unit 1031 is configured to determine a character string corresponding to the data table table name.

The classification subunit 1032 is configured to classify the data table according to the character string.

As shown in FIG. 8, if the data table is a source table, the obtaining unit 104 includes:

The first execution unit 1041 is configured to divide the source table into an internal source table and an external source table.

The first obtaining subunit 1042 is configured to acquire data information corresponding to the internal source table and the external source table. The first output unit 1043 is configured to output the acquired data information into the preset document.

As shown in FIG. 9, if the data table is a target table, the obtaining unit 104 includes:

The second execution unit 1044 is configured to divide the target table into an insertion target table and an overlay target table.

The second obtaining subunit 1045 is configured to acquire data information corresponding to the insertion target table and the coverage target table.

The second output unit 1046 is configured to output the acquired data information into the preset document.

Referring to FIG. 10 , corresponding to the foregoing method for extracting a data table based on a shell, the embodiment of the present application further provides a data table extraction terminal based on a shell, where the terminal 200 includes: a traversing unit 201, a positioning unit 202, and an identifying unit 203. The extracting unit 204, the classifying unit 205, and the obtaining unit 206.

The traversing unit 201 is configured to traverse the shell script according to a preset keyword.

The locating unit 202 is configured to locate the data table in the shell script according to the result of the traversal.

The identification unit 203 is configured to identify a data table in the shell script.

The extracting unit 204 is configured to extract a table name of the data table.

The classification unit 205 is configured to classify the data table according to the extracted table name, wherein the data table includes a source table and a target table.

The obtaining unit 206 is configured to acquire data information corresponding to different types of data tables, and output the acquired different types of data information into the same preset document.

The above Shell-based data table extraction terminal can be implemented in the form of a computer program that can be run on a device as shown in FIG.

FIG. 11 is a schematic structural diagram of a Shell-based data table extraction device according to the present application. The device may be a terminal or a server, wherein the terminal may be a communication device such as a smart phone, a tablet computer, a notebook computer, a desktop computer, a personal digital assistant, and a wearable device. The server can be a standalone server or a server cluster consisting of multiple servers. Referring to FIG. 11, the computer device 500 includes a processor 502, a non-volatile storage medium 503, an internal memory 504, and a network interface 505 connected by a system bus 501. The non-volatile storage medium 503 of the computer device 500 can store an operating system 5031 and a computer program 5032. When the computer program 5032 is executed, the processor 502 can be caused to execute a shell-based data table extraction method. The processor 502 of the computer device 500 is used to provide computing and control capabilities to support the operation of the entire computer device 500. The internal memory 504 provides an environment for the operation of the computer program 5032 in the non-volatile storage medium 503, which when executed by the processor, causes the processor 502 to perform a shell-based data table extraction method. The network interface 505 of the computer device 500 is used to perform network communications, such as sending assigned tasks and the like. It will be understood by those skilled in the art that the structure shown in FIG. 11 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation of the computer device to which the solution of the present application is applied. The specific computer device may It includes more or fewer components than those shown in the figures, or some components are combined, or have different component arrangements.

The processor 502 performs the following operations:

Identify the data tables in the shell script;

Extracting the table name of the data table;

In one embodiment, the processor 502 also performs the following operations:

Traversing the shell script according to a preset keyword;

The data table in the shell script is located according to the result of the traversal.

In one embodiment, the classifying the data table according to the extracted table name comprises:

Determining a string corresponding to the table name of the data table;

The data table is classified according to the character string.

In an embodiment, if the data table is a source table, the acquiring data information corresponding to different types of data tables, and outputting the acquired different types of data information to the same preset document, includes:

Dividing the source table into an internal source table and an external source table;

Obtaining data information corresponding to the internal source table and the external source table;

The acquired data information is output to a preset document.

In an embodiment, if the data table is a target table, the acquiring data information corresponding to different types of data tables, and outputting the acquired different types of data information to the same preset document, includes:

Dividing the target table into an insertion target table and an overlay target table;

Obtaining data information corresponding to the insertion target table and the coverage target table;

The acquired data information is output to a preset document.

Those skilled in the art can appreciate that the embodiment of the Shell-based data table extraction device shown in FIG. 11 does not constitute a limitation on the specific configuration of the Shell-based data table extraction device. In other embodiments, the Shell-based data table The extraction device may include more or fewer components than illustrated, or some components may be combined, or different component arrangements. For example, in some embodiments, the Shell-based data table extraction device includes only the memory and the processor. In such an embodiment, the structure and function of the memory and the processor are consistent with the embodiment shown in FIG. Narration.

The application provides a computer readable storage medium storing one or more computer programs, the one or more computer programs being executable by one or more processors to implement the above-described shell-based Data table extraction method.

The foregoing storage medium of the present application includes: a magnetic disk, an optical disk, a read-only memory (ROM), and the like, which can store various program codes.

The units in all the embodiments of the present application may be implemented by a general-purpose integrated circuit, such as a CPU (Central Processing Unit), or by an ASIC (Application Specific Integrated Circuit).

The steps in the method for extracting the data table based on the Shell in the embodiment of the present application may be sequentially adjusted, merged, and deleted according to actual needs.

In the embodiment of the present application, the unit in the terminal based on the data table of the Shell may be merged, divided, and deleted according to actual needs.

The foregoing is only a specific embodiment of the present application, but the scope of protection of the present application is not limited thereto, and any equivalents can be easily conceived by those skilled in the art within the technical scope disclosed in the present application. Modifications or substitutions are intended to be included within the scope of the present application. Therefore, the scope of protection of this application should be determined by the scope of protection of the claims.

Claims

A Shell-based data table extraction method, the method comprising:

Identify the data tables in the shell script;

Extracting the table name of the data table;

Sorting the data table according to the extracted table name, wherein the data table includes a source table and a target table;

Obtaining data information corresponding to different types of data tables, and outputting the acquired different types of data information to the same preset document.
The method of claim 1, wherein before the identifying the data table in the shell script, the method further comprises:

Traversing the shell script according to a preset keyword;

The data table in the shell script is located according to the result of the traversal.
The method of claim 1, wherein the classifying the data table according to the extracted table name comprises:

Determining a string corresponding to the table name of the data table;

The data table is classified according to the character string.
The method according to claim 1, wherein if the data table is a source table, the acquiring data information corresponding to different types of data tables, and outputting the acquired different types of data information to the same preset The documentation includes:

Dividing the source table into an internal source table and an external source table;

Obtaining data information corresponding to the internal source table and the external source table;

The acquired data information is output to a preset document.
The method according to claim 1, wherein if the data table is a target table, the acquiring data information corresponding to different types of data tables, and outputting the acquired different types of data information to the same preset The documentation includes:

Dividing the target table into an insertion target table and an overlay target table;

Obtaining data information corresponding to the insertion target table and the coverage target table;

The acquired data information is output to a preset document.
A shell-based data table extracting terminal, wherein the terminal comprises:

a recognition unit for identifying a data table in the shell script;

An extracting unit, configured to extract a table name of the data table;

a classification unit, configured to classify the data table according to the extracted table name, where the data table includes a source table and a target table;

The obtaining unit is configured to obtain data information corresponding to different types of data tables, and output the obtained different types of data information into the same preset document.
The terminal according to claim 6, wherein the terminal further comprises:

a traversing unit, configured to traverse the shell script according to a preset keyword;

a positioning unit, configured to locate the data table in the shell script according to the result of the traversal.
The terminal according to claim 6, wherein the classification unit comprises:

a determining unit, configured to determine a character string corresponding to the data table table name;

a classification subunit, configured to classify the data table according to the character string.
The terminal according to claim 6, wherein the obtaining unit comprises: if the data table is a source table,

a first execution unit, configured to divide the source table into an internal source table and an external source table;

a first acquiring subunit, configured to acquire data information corresponding to the internal source table and the external source table;

The first output unit is configured to output the acquired data information into the preset document.
The terminal according to claim 6, wherein if the data table is a target table, the obtaining unit comprises:

a second execution unit, configured to divide the target table into an insertion target table and an overlay target table;

a second acquiring subunit, configured to acquire data information corresponding to the insertion target table and the coverage target table;

And a second output unit, configured to output the acquired data information into the preset document.
A Shell-based data table extraction device, comprising:

a memory for storing a program implementing the data table extraction method;

a processor for running a program for implementing the data table extraction method stored in the memory to perform the following operations:

Identify the data tables in the shell script;

Extracting the table name of the data table;

Sorting the data table according to the extracted table name, wherein the data table includes a source table and a target table;

Obtaining data information corresponding to different types of data tables, and outputting the acquired different types of data information to the same preset document.
The device of claim 11 wherein said processor further performs the following operations:

Traversing the shell script according to a preset keyword;

The data table in the shell script is located according to the result of the traversal.
The device according to claim 11, wherein said classifying said data table according to said extracted table name comprises:

Determining a string corresponding to the table name of the data table;

The data table is classified according to the character string.
The device according to claim 11, wherein if the data table is a source table, the acquiring data information corresponding to different types of data tables, and outputting the acquired different types of data information to the same preset The documentation includes:

Dividing the source table into an internal source table and an external source table;

Obtaining data information corresponding to the internal source table and the external source table;

The acquired data information is output to a preset document.
The device according to claim 11, wherein if the data table is a target table, the acquiring data information corresponding to different types of data tables, and outputting the acquired different types of data information to the same preset The documentation includes:

Dividing the target table into an insertion target table and an overlay target table;

Obtaining data information corresponding to the insertion target table and the coverage target table;

The acquired data information is output to a preset document.
A computer readable storage medium, wherein the computer readable storage medium stores one or more computer programs, the one or more computer programs being executable by one or more processors to implement the following step:

Identify the data tables in the shell script;

Extracting the table name of the data table;

Sorting the data table according to the extracted table name, wherein the data table includes a source table and a target table;

Obtaining data information corresponding to different types of data tables, and outputting the acquired different types of data information to the same preset document.
The computer readable storage medium of claim 16 wherein said step further comprises:

Traversing the shell script according to a preset keyword;

The data table in the shell script is located according to the result of the traversal.
The computer readable storage medium of claim 16, wherein the classifying the data table according to the extracted table name comprises:

Determining a string corresponding to the table name of the data table;

The data table is classified according to the character string.
The computer readable storage medium according to claim 16, wherein if the data table is a source table, the acquiring data information corresponding to different types of data tables, and outputting the acquired different types of data information To the same preset document, including:

Dividing the source table into an internal source table and an external source table;

Obtaining data information corresponding to the internal source table and the external source table;

The acquired data information is output to a preset document.
The computer readable storage medium according to claim 16, wherein if the data table is a target table, the acquiring data information corresponding to different types of data tables, and outputting the acquired different types of data information To the same preset document, including:

Dividing the target table into an insertion target table and an overlay target table;

Obtaining data information corresponding to the insertion target table and the coverage target table;

The acquired data information is output to a preset document.