Data query method and device

By receiving the user's set of pending files, judging the query conditions and creating a target data table in the database, querying based on query information and splicing information, the problems of slow query speed and limited scope in the existing technology are solved, and the rapid and Comprehensive data query.

CN113392073BActive Publication Date: 2024-11-26CHINA CONSTRUCTION BANK
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202110790514.1
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-07-13
Publication Date
2024-11-26
Estimated Expiration
2041-07-13

AI Technical Summary

Technical Problem

In the prior art, when multiple data queries are queried, the query speed is slow and the query range is limited, especially when the data volume is large.

Method used

By receiving the set of pending files uploaded by the user, we can determine whether the pre-set query conditions are met. If so, create a target data table and query it in the database based on the query information and splicing information to obtain query results, improve query speed and avoid query scope being affected by query scope limit.

Benefits of technology

It realizes the speed of data query and the expansion of query scope, and can quickly obtain accurate results under large amounts of data.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN113392073B_ABST
    Figure CN113392073B_ABST
Patent Text Reader

Abstract

The present invention provides a data query method and device, which receive a set of to-be-processed files uploaded by a user; determine whether the query condition is met; if so, send file information to the user to prompt the user to select a file type; receive selection information based on the user's feedback on the file information; determine a source file and a target file in the set of to-be-processed files based on the selection information; send the user information on each column name of the source file and each column name of the target file; receive a query request sent by the user based on the information on each column name of the source file and each column name of the target file; the query request contains query information and splicing information; create a target data table in a preset database; the target data table contains data on each column of the source file and data on each column of the target file; query the target data table based on the query information and the splicing information, and quickly obtain query results corresponding to the query request.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a data query method and device. Background Art

[0002] With the development of computer science and technology, computers are widely used in various fields. People usually use computers to process various data, which greatly improves production efficiency. For example, data query and processing can be performed through the computer's EXCEL software.

[0003] In the prior art, when processing multiple copies of data, EXCEL software is usually used to complete the work with the assistance of the vlookup function. However, when querying through Excel software, the returned results can only be located in table_array, and the data on the left side of table_array cannot be searched. The data on the right side of table_array cannot be searched if it is not included in the table_array range. The query range is limited, and when the amount of data is large, the query speed is slow. Summary of the invention

[0004] The technical problem to be solved by the present invention is to provide a data query method, which can improve the query speed and avoid the limitation of the query scope.

[0005] The present invention also provides a data query device to ensure the implementation and application of the above method in practice.

[0006] A data query method, comprising:

[0007] Receive a collection of files to be processed uploaded by the user;

[0008] Determine whether the to-be-processed file set meets a preset query condition;

[0009] If the to-be-processed file set meets the preset query condition, the file information of the to-be-processed file set is sent to the user to prompt the user to select a file type;

[0010] receiving selection information of the user based on the feedback of the file information;

[0011] Determine a source file and a target file in the set of files to be processed based on the selection information;

[0012] Sending each column name information of the source file and each column name information of the target file to the user;

[0013] Receiving a query request sent by the user based on each column name information of the source file and each column name information of the target file; the query request contains query information and splicing information; the query information includes the first target column name information of the source file; the splicing information includes at least the first target column name information of the source file and the second target column name information of the target file; the second target column name information is consistent with the first target column name information;

[0014] Creating a target data table in a preset database; the target data table contains each column data of the source file and each column data of the target file;

[0015] The target data table is queried based on the query information and the splicing information to obtain a query result corresponding to the query request.

[0016] In the above method, optionally, the determining whether the to-be-processed file set satisfies a preset query condition includes:

[0017] Determining whether the preset database is in a normal state, and determining whether the to-be-processed files in the to-be-processed file set are complete;

[0018] If the database is in a normal state, and the to-be-processed files in the to-be-processed file set are complete, then it is determined that the to-be-processed file set meets the query condition; otherwise, it is determined that the to-be-processed files do not meet the query condition.

[0019] In the above method, optionally, the step of creating a target data table in a preset database includes:

[0020] According to the column name information of the source file and the column name information of the target file, an initial data table is established in the database, and a control file corresponding to the derivative tool is created;

[0021] Control the derivative tool according to the control file to import each column of data in the source file and each column of data in the target file into the initial data table;

[0022] The initial data table into which the column data has been imported is determined as a target data table.

[0023] In the above method, optionally, querying the target data table based on the query information and the splicing information to obtain a query result corresponding to the query request includes:

[0024] Generate a database query condition according to the query information;

[0025] Determine the query range of the target data table according to the splicing information;

[0026] A query is performed within a query range of the target data table based on the database query condition to obtain a query result corresponding to the query request.

[0027] The above method, optionally, after obtaining the query result corresponding to the query request, further includes:

[0028] Convert the query result to a format that is in a preset format.

[0029] The query file is fed back to the user.

[0030] A data query device, comprising:

[0031] A first receiving unit, configured to receive a set of files to be processed uploaded by a user;

[0032] A judging unit, used to judge whether the set of files to be processed meets a preset query condition;

[0033] A first sending unit, configured to send file information of the to-be-processed file set to the user if the to-be-processed file set meets a preset query condition, so as to prompt the user to select a file type;

[0034] A second receiving unit, configured to receive selection information of the user based on feedback of the file information;

[0035] A determination unit, configured to determine a source file and a target file in the set of files to be processed based on the selection information;

[0036] A second sending unit, configured to send each column name information of the source file and each column name information of the target file to the user;

[0037] A third receiving unit is used to receive a query request sent by the user based on each column name information of the source file and each column name information of the target file; the query request contains query information and splicing information; the query information includes the first target column name information of the source file; the splicing information includes at least the first target column name information of the source file and the second target column name information of the target file; the second target column name information is consistent with the first target column name information;

[0038] A creation unit, used to create a target data table in a preset database; the target data table includes each column data of the source file and each column data of the target file;

[0039] A query unit is used to query the target data table based on the query information and the splicing information to obtain a query result corresponding to the query request.

[0040] In the above device, optionally, the judging unit includes:

[0041] A judging subunit, used to judge whether the preset database is in a normal state, and to judge whether the to-be-processed files in the to-be-processed file set are complete;

[0042] The execution subunit is used to determine that the set of to-be-processed files meets the query condition if the database is in a normal state and the to-be-processed files in the set of to-be-processed files are complete; otherwise, determine that the to-be-processed files do not meet the query condition.

[0043] In the above device, optionally, the creation unit includes:

[0044] A creation subunit is used to establish an initial data table in the database according to each column name information of the source file and each column name information of the target file, and to create a control file corresponding to the derivative tool;

[0045] A data import subunit, used for controlling the derivative tool to import each column of data in the source file and each column of data in the target file into the initial data table according to the control file;

[0046] The first determining subunit is used to determine the initial data table into which the column data has been imported as a target data table.

[0047] In the above device, optionally, the query unit includes:

[0048] A generating subunit, used for generating a database query condition according to the query information;

[0049] A second determining subunit, configured to determine a query range of the target data table according to the splicing information;

[0050] The query subunit is used to query within the query range of the target data table based on the database query condition to obtain the query result corresponding to the query request.

[0051] The above device may optionally further include:

[0052] A format conversion unit, used to convert the format of the query result to obtain a query file in a preset format;

[0053] A feedback unit is used to feed back the query file to the user.

[0054] Compared with the prior art, the present invention has the following advantages:

[0055] The present invention provides a data query method and device, which first receives a set of to-be-processed files uploaded by a user; determines whether the set of to-be-processed files meets a query condition; if the set of to-be-processed files meets a query condition, sends file information of the set of to-be-processed files to the user to prompt the user to select a file type; receives selection information based on feedback from the user on the file information; determines a source file and a target file in the set of to-be-processed files based on the selection information; sends the user information on each column name of the source file and each column name of the target file; receives a query request sent by the user based on the information on each column name of the source file and each column name of the target file; the query request contains query information and splicing information; queries The information includes the first target column name information of the source file; the splicing information includes at least the first target column name information of the source file and the second target column name information of the target file; the second target column name information is consistent with the first target column name information; a target data table is created in a preset database; the target data table contains each column data of the source file and each column data of the target file; based on the query information and the splicing information, the target data table is queried to obtain the query result corresponding to the query request, and the query is performed by means of a database, which can improve the query speed, and the splicing information includes at least the first target column name information of the source file and the second target column name information, which can also avoid limiting the query scope. BRIEF DESCRIPTION OF THE DRAWINGS

[0056] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without paying creative work.

[0057] Figure 1 A method flow chart of a data query method provided by the present invention;

[0058] Figure 2 A flowchart of a process of creating a target data table in a preset database provided by the present invention;

[0059] Figure 3 A flowchart of a process for executing creation of a storage directory provided by the present invention;

[0060] Figure 4 A flowchart of another method of a data query method provided by the present invention;

[0061] Figure 5 A flowchart of a process of obtaining query results using a database provided by the present invention;

[0062] Figure 6A structural schematic diagram of a data query device provided by the present invention. DETAILED DESCRIPTION

[0063] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0064] In this application, the terms "comprises", "comprising" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device comprising a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, an element defined by the sentence "comprising a ..." does not exclude the presence of other identical elements in the process, method, article or device comprising the element.

[0065] The embodiment of the present invention provides a data query method, which can be applied to an electronic device, and the electronic device can be a server. The method flow chart of the method is as follows: Figure 1 As shown, specifically including:

[0066] S101: receiving a set of files to be processed uploaded by a user.

[0067] In the embodiment of the present invention, the to-be-processed file set includes a plurality of to-be-processed files.

[0068] Each file to be processed may include multiple columns of data.

[0069] S102: Determine whether the to-be-processed file set meets a preset query condition. If so, execute S103; if not, execute S110.

[0070] The query condition may include at least one of the following: the database is in an available state, and the files in the to-be-processed file set are complete.

[0071] S103: Sending file information of the to-be-processed file set to the user to prompt the user to select a file type.

[0072] In the embodiment of the present invention, the file information of each to-be-processed file in the to-be-processed file set may be sent to the terminal held by the user to prompt the user to select a source file and a target file in the to-be-processed file set.

[0073] The file information may be a file identifier.

[0074] S104: Receive selection information from the user based on the feedback of the file information.

[0075] In the embodiment of the present invention, the selection information includes source file information and target file information selected by the user from the file information of each to-be-processed file.

[0076] There are at least some identical fields in the target file and the source file.

[0077] S105: Determine a source file and a target file in the set of files to be processed based on the selection information.

[0078] In the embodiment of the present invention, in the set of files to be processed, the files to be processed that match the source file information in the selection information are used as source files, and the files to be processed that match the target file information in the selection information are used as target files.

[0079] Among them, at least one source file and at least one target file can be determined in the set of files to be processed.

[0080] S106: Sending the information of each column name of the source file and the information of each column name of the target file to the user.

[0081] In an embodiment of the present invention, by reading the contents of a source file and a target file, parsing the first line of the source file and formatting it, the column name information of the source file is obtained; parsing the first line of the target file and formatting it, the column name information of the target file is obtained.

[0082] The column name information of the source file and the column name information of the target file are sent to the user to prompt the user to select at least one first target column name information as query information from the column name information of the source file, and to select splicing information from the column name information of the source file and the column name information of the target file.

[0083] S107: receiving a query request sent by the user based on each column name information of the source file and each column name information of the target file; the query request contains query information and splicing information; the query information includes the first target column name information of the source file; the splicing information includes at least the first target column name information of the source file and the second target column name information of the target file; the second target column name information is consistent with the first target column name information.

[0084] The first target column name information may be one or more, and the splicing information may include the first target column name information and the second target column name information, and may also include other column name information of the source file and other column name information of the target file.

[0085] Specifically, the splicing information is the column name information required by the user.

[0086] S108: creating a target data table in a preset database; the target data table contains each column data of the source file and each column data of the target file.

[0087] In the embodiment of the present invention, the database may be any type of database, for example, an ORACLE database.

[0088] S109: Query the target data table based on the query information and the splicing information to obtain a query result corresponding to the query request.

[0089] In an embodiment of the present invention, a query statement may be generated according to the query information and the concatenated information, and the query statement may be executed to query the target data table and obtain a query result corresponding to the query request.

[0090] The number of rows in the query result may be consistent with the number of rows in the source file.

[0091] S110: Prompt the user that an abnormality has occurred.

[0092] The user may be prompted to confirm the file and try again, or the user may be prompted to check the database status and try again.

[0093] By applying the method provided in the embodiment of the present invention, querying through a database can improve the query speed. Moreover, the splicing information includes at least the first target column name information and the second target column name information of the source file, which can also avoid limiting the query scope.

[0094] The method provided by the embodiment of the present invention is based on the above implementation process. Specifically, the process of determining whether the set of files to be processed meets the preset query condition includes:

[0095] Determining whether the preset database is in a normal state, and determining whether the to-be-processed files in the to-be-processed file set are complete;

[0096] If the database is in a normal state, and the to-be-processed files in the to-be-processed file set are complete, then it is determined that the to-be-processed file set meets the query condition; otherwise, it is determined that the to-be-processed files do not meet the query condition.

[0097] In the embodiment of the present invention, if the database is not in a normal state and / or the to-be-processed files in the to-be-processed file set are incomplete, it is determined that the to-be-processed file set does not satisfy the query condition.

[0098] Among them, judging whether the database is in a normal state means judging whether the database is available. If the database is available, it is determined that the database is in a normal state. If the database is unavailable, it is determined that the database is not in a normal state.

[0099] The method provided in the embodiment of the present invention is based on the above implementation process. Specifically, the target data table is created in a preset database, such as Figure 2 As shown, specifically including:

[0100] S201: According to the column name information of the source file and the column name information of the target file, an initial data table is established in the database, and a control file corresponding to the derivative tool is created.

[0101] In the embodiment of the present invention, the initial data table may be an empty table, and the derivative tool may be a SQLLDR derivative tool.

[0102] S202: Control the derivative tool according to the control file to import each column of data in the source file and each column of data in the target file into the initial data table.

[0103] S203: Determine the initial data table into which the column data has been imported as the target data table.

[0104] In the embodiment of the present invention, the target data table includes each column of data of the source file and each column of data of the target file.

[0105] The method provided by the embodiment of the present invention is based on the above implementation process. Specifically, querying the target data table based on the query information and the splicing information to obtain the query result corresponding to the query request specifically includes:

[0106] Generate a database query condition according to the query information;

[0107] Determine the query range of the target data table according to the splicing information;

[0108] A query is performed within a query range of the target data table based on the database query condition to obtain a query result corresponding to the query request.

[0109] Specifically, a query statement may be generated according to the database query condition and the splicing information, and the query statement may be executed to query within the query range of the target data table to obtain a query result corresponding to the query request.

[0110] The method provided by the embodiment of the present invention is based on the above implementation process. Specifically, after obtaining the query result corresponding to the query request, it also includes:

[0111] Convert the query result to a format that is in a preset format.

[0112] The query file is fed back to the user.

[0113] After the query result is obtained in the database, the query result is converted into a format and exported into a query file in a preset format. Specifically, the query file may be a file in a CSV format.

[0114] In the actual application process of the data query method provided by the present invention, the ORACLE database can be installed in the server first, and the process of creating a storage directory can be executed, such as Figure 3 As shown, you can upload the script to the server. Executing the deployment script will initialize and create a storage directory. The user only needs to put the two data to be compared into this directory, execute the main program script, and select according to the script prompts to get the final result.

[0115] Furthermore, a data query method may be executed on the server, such as Figure 4 As shown, it is another method flow chart of a data query method provided by an embodiment of the present invention. When using it, the user needs to put the two data to be compared into the corresponding directory of the server and execute the main program. The program will first detect whether the database is available and whether the stored files are recognizable structured or semi-structured data. Then the file name is given, and the user is prompted to select the source file and the target search file; all the column names of the source file are listed, and the user is prompted to select which columns to select as search conditions. At the same time, all the columns of the two files are given, and the user is prompted to select which column information the final result needs to include. After the user confirms all the information, confirm to start, and the program will import the data into the database from the background and perform calculations, and then return the user's required columns and save them as csv files. The user can download the file to get the final result.

[0116] Among them, the process of applying the database to obtain query results, such as Figure 5 As shown in the figure, the corresponding table can be created in the database according to the source and target file column information given by the user, the corresponding SQLLDR control file can be created by splicing, and the user file can be imported into the database. The SQL screening conditions can be spliced ​​according to the column conditions selected by the user, and the query range can be spliced ​​according to the column conditions required by the user. The query SQL process is executed and the results are exported to the corresponding directory and returned to the user.

[0117] For example, the source file contains the following contents, as shown in Table 1:

[0118] Column Name A Column Name B 1 2 3 4

[0119] Table 1

[0120] The source file contains columns of data named A(1, 3) and B(2, 4).

[0121] The target file contains the following contents, as shown in Table 2:

[0122] Column Name A Column Name B Column Name C Column Name D 1 2 8 f 3 4 7 x 5 9 6 t

[0123] Table 2

[0124] The target file contains columns of data named A(1, 3, 5), B(2, 4, 9), C(8, 7, 6) and D(f, x, t).

[0125] If the query information includes column name A and column name B in the source file, and the concatenated information includes column name A and column name B in the first source file, and column name A, column name B, column name C, and column name D in the target file, the query result finally obtained may be as shown in Table 3:

[0126] Column Name A Column Name B 1 2 8 f 3 4 7 x

[0127] Table 3

[0128] The query result includes the first row (column name A, column name B), the second row (1, 2, 8, f) and the third row (3, 4, 7, x).

[0129] and Figure 1 Corresponding to the method described above, the embodiment of the present invention further provides a data query device for querying Figure 1 The data query device provided in the embodiment of the present invention can be applied to electronic devices, and its structural diagram is as follows Figure 6 As shown, specifically including:

[0130] The first receiving unit 601 is used to receive a set of files to be processed uploaded by a user;

[0131] A judging unit 602 is used to judge whether the to-be-processed file set satisfies a preset query condition;

[0132] A first sending unit 603 is configured to send file information of the to-be-processed file set to the user if the to-be-processed file set meets a preset query condition, so as to prompt the user to select a file type;

[0133] The second receiving unit 604 is used to receive selection information of the user based on the feedback of the file information;

[0134] A determination unit 605 is used to determine a source file and a target file in the set of files to be processed based on the selection information;

[0135] A second sending unit 606 is used to send each column name information of the source file and each column name information of the target file to the user;

[0136] The third receiving unit 607 is used to receive a query request sent by the user based on each column name information of the source file and each column name information of the target file; the query request contains query information and splicing information; the query information includes the first target column name information of the source file; the splicing information at least includes the first target column name information of the source file and the second target column name information of the target file; the second target column name information is consistent with the first target column name information;

[0137] A creation unit 608 is used to create a target data table in a preset database; the target data table includes each column data of the source file and each column data of the target file;

[0138] The query unit 609 is used to query the target data table based on the query information and the splicing information to obtain a query result corresponding to the query request.

[0139] In an embodiment provided by the present invention, based on the above solution, specifically, the judging unit includes:

[0140] A judging subunit, used to judge whether the preset database is in a normal state, and to judge whether the to-be-processed files in the to-be-processed file set are complete;

[0141] The execution subunit is used to determine that the set of to-be-processed files meets the query condition if the database is in a normal state and the to-be-processed files in the set of to-be-processed files are complete; otherwise, determine that the to-be-processed files do not meet the query condition.

[0142] In an embodiment provided by the present invention, based on the above solution, specifically, the creation unit includes:

[0143] A creation subunit is used to establish an initial data table in the database according to each column name information of the source file and each column name information of the target file, and to create a control file corresponding to the derivative tool;

[0144] A data import subunit, used for controlling the derivative tool to import each column of data in the source file and each column of data in the target file into the initial data table according to the control file;

[0145] The first determining subunit is used to determine the initial data table into which the column data has been imported as a target data table.

[0146] In an embodiment provided by the present invention, based on the above solution, specifically, the query unit includes:

[0147] A generating subunit, used for generating a database query condition according to the query information;

[0148] A second determining subunit, configured to determine a query range of the target data table according to the splicing information;

[0149] The query subunit is used to query within the query range of the target data table based on the database query condition to obtain the query result corresponding to the query request.

[0150] In an embodiment provided by the present invention, based on the above solution, specifically, it also includes:

[0151] A format conversion unit, used to convert the format of the query result to obtain a query file in a preset format;

[0152] A feedback unit is used to feed back the query file to the user.

[0153] The specific principles and execution processes of each unit and module in the data query device disclosed in the above embodiment of the present invention are the same as the data query method disclosed in the above embodiment of the present invention. Please refer to the corresponding parts of the data query method provided in the above embodiment of the present invention, and will not be repeated here.

[0154] It should be noted that each embodiment in this specification is described in a progressive manner, and each embodiment focuses on the differences from other embodiments, and the same or similar parts between the embodiments can be referred to each other. For the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0155] Finally, it should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.

[0156] For the convenience of description, the above device is described as being divided into various units according to their functions. Of course, when implementing the present invention, the functions of each unit can be implemented in the same or multiple software and / or hardware.

[0157] It can be known from the description of the above implementation methods that those skilled in the art can clearly understand that the present invention can be implemented by means of software plus a necessary general hardware platform. Based on such an understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art can be embodied in the form of a software product, which can be stored in a storage medium such as ROM / RAM, a magnetic disk, an optical disk, etc., and includes a number of instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in the various embodiments of the present invention or certain parts of the embodiments.

[0158] The above is a detailed introduction to a data query method provided by the present invention. Specific examples are used in this article to illustrate the principles and implementation methods of the present invention. The description of the above embodiments is only used to help understand the method of the present invention and its core idea. At the same time, for those skilled in the art, according to the idea of ​​the present invention, there will be changes in the specific implementation method and application scope. In summary, the content of this specification should not be understood as a limitation on the present invention.

Claims

1. A data query method, characterized in that: include: Receive a collection of files to be processed uploaded by the user; Determine whether the to-be-processed file set meets a preset query condition; If the to-be-processed file set meets the preset query condition, the file information of the to-be-processed file set is sent to the user to prompt the user to select a file type; receiving selection information of the user based on the feedback of the file information; Determine a source file and a target file in the set of files to be processed based on the selection information; Sending each column name information of the source file and each column name information of the target file to the user; Receiving a query request sent by the user based on each column name information of the source file and each column name information of the target file; the query request includes query information and splicing information; The query information includes the first target column name information of the source file; the splicing information includes at least the first target column name information of the source file and the second target column name information of the target file; the second target column name information is consistent with the first target column name information; Create a target data table in the preset database; The target data table includes each column data of the source file and each column data of the target file; The target data table is queried based on the query information and the splicing information to obtain a query result corresponding to the query request.

2. The method according to claim 1, characterized in that The determining whether the to-be-processed file set satisfies a preset query condition includes: Determining whether the preset database is in a normal state, and determining whether the to-be-processed files in the to-be-processed file set are complete; If the database is in a normal state, and the to-be-processed files in the to-be-processed file set are complete, then it is determined that the to-be-processed file set meets the query condition; otherwise, it is determined that the to-be-processed files do not meet the query condition.

3. The method according to claim 1, characterized in that The step of creating a target data table in a preset database includes: According to the column name information of the source file and the column name information of the target file, an initial data table is established in the database, and a control file corresponding to the derivative tool is created; Control the derivative tool according to the control file to import each column of data in the source file and each column of data in the target file into the initial data table; The initial data table into which the column data has been imported is determined as a target data table.

4. The method according to claim 1, characterized in that: The querying the target data table based on the query information and the splicing information to obtain a query result corresponding to the query request includes: Generate a database query condition according to the query information; Determine the query range of the target data table according to the splicing information; A query is performed within a query range of the target data table based on the database query condition to obtain a query result corresponding to the query request.

5. The method according to claim 1, characterized in that After obtaining the query result corresponding to the query request, the method further includes: Convert the query result to a format that is in a preset format. The query file is fed back to the user.

6. A data query device, characterized in that: include: A first receiving unit, configured to receive a set of files to be processed uploaded by a user; A judging unit, used to judge whether the set of files to be processed meets a preset query condition; A first sending unit, configured to send file information of the to-be-processed file set to the user if the to-be-processed file set meets a preset query condition, so as to prompt the user to select a file type; A second receiving unit, configured to receive selection information of the user based on feedback of the file information; A determination unit, configured to determine a source file and a target file in the set of files to be processed based on the selection information; A second sending unit, configured to send each column name information of the source file and each column name information of the target file to the user; A third receiving unit, configured to receive a query request sent by the user based on each column name information of the source file and each column name information of the target file; The query request includes query information and splicing information; the query information includes the first target column name information of the source file; the splicing information includes at least the first target column name information of the source file and the second target column name information of the target file; the second target column name information is consistent with the first target column name information; A creation unit is used to create a target data table in a preset database; The target data table includes each column data of the source file and each column data of the target file; A query unit is used to query the target data table based on the query information and the splicing information to obtain a query result corresponding to the query request.

7. The device according to claim 6, characterized in that The judging unit comprises: A judging subunit, used to judge whether the preset database is in a normal state, and to judge whether the to-be-processed files in the to-be-processed file set are complete; The execution subunit is used to determine that the set of to-be-processed files meets the query condition if the database is in a normal state and the to-be-processed files in the set of to-be-processed files are complete; otherwise, determine that the to-be-processed files do not meet the query condition.

8. The device according to claim 6, characterized in that The creation unit comprises: A creation subunit is used to establish an initial data table in the database according to each column name information of the source file and each column name information of the target file, and to create a control file corresponding to the derivative tool; A data import subunit, used for controlling the derivative tool to import each column of data in the source file and each column of data in the target file into the initial data table according to the control file; The first determining subunit is used to determine the initial data table into which the column data has been imported as a target data table.

9. The device according to claim 6, characterized in that The query unit comprises: A generating subunit, used for generating a database query condition according to the query information; A second determining subunit, configured to determine a query range of the target data table according to the splicing information; The query subunit is used to query within the query range of the target data table based on the database query condition to obtain the query result corresponding to the query request.

10. The device according to claim 6, characterized in that Also includes: A format conversion unit, used to convert the format of the query result to obtain a query file in a preset format; A feedback unit is used to feed back the query file to the user.