TWI576714B - Data acquisition analysis system - Google Patents

Description

Data extraction analysis system

The present invention relates to a data retrieval analysis system, and more particularly to a system that enables a user to acquire, filter, add, merge, analyze, etc. content in a database in an intuitive manner.

Since data collection and analysis will be carried out according to different needs after data collection, if the database is too large, the traditional practice of collecting the list, as shown in Figure 1, must be done by the engineer through the database software. Enter the database to write the code to get the list data, and if you need to repair the list data, you have to spend the same process and do it again. The process technology threshold is high and it takes a lot of time.

In order to make the list more convenient to be carried out on the website, the interface version is established, but although this function guides how to build SQL syntax, it still needs to have the basic knowledge of SQL to complete the list, but it must be in SQL. Writing database grammar is still a very unintuitive operation. Users must have certain knowledge of database grammar to be able to operate. Therefore, if a company does not have such talents, it must often provide the requirements to the database. The management party picks up the list, but such an approach will take a lot of time, so this aspect is a big problem.

Therefore, if a client webpage program can be designed, an intuitive operation interface can be provided, which enables the user to obtain, filter, and add content in the database in an intuitive manner. Combining, analyzing, etc., to solve the above mentioned problems, the present invention should be an optimal solution.

The data retrieval system of the present invention comprises: a database platform for storing more than one piece of data; a client webpage program, which can be displayed on a computer device, and the client webpage program and the database platform For the connection, the client webpage program includes at least one operation interface providing module for providing an intuitive operation interface required for operating the client webpage program for operation; a data temporary storage module, and the operation The interface provides a module connection, which is used to store at least one or more list files; a field selection module is connected to the operation interface providing module and the data temporary storage module, and can provide more than one field An option for selecting a field to be viewed; a data capture module is coupled to the intuitive operation interface, the data temporary storage module, and the field selection module for use according to the field Selecting the field option selected by the module to retrieve the data in the database platform and establishing it as a list file, and the created list file is pre-stored in the data temporary storage module; The screening module is connected to the operation interface providing module and the data temporary storage module, and is used for setting conditions in at least one field option included in the list file to meet the condition setting in the list file. The data is further filtered out and created as a new list file, and the new list file is pre-stored in the data temporary storage module; and a field option customization module is provided with the operation interface. And the data temporary storage module is connected to establish a new field option and a condition definition for setting the field option.

More specifically, the database platform has a plurality of data tables of a single field, and the database platform must first be denormalized, and then combine several data tables to form a combined large data table. And the data acquisition module is based on the field selection option selected by the field selection module to retrieve data from the combined large data table of the database platform.

More specifically, the intuitive interface of the operation interface providing module can be a draggable interface, a pointable interface, or a combination of the two.

More specifically, the field option customization module is more capable of creating a new field option directly in the list file, and corresponding to the new field option in the database platform through the data extraction module. The data is taken out and the extracted data is merged into the list file.

More specifically, the client webpage program further includes an archive data merge module, and the archive file merge module is connected to the operation interface providing module and the data temporary storage module to enable At least two of the list files are merged and output as another new list file, and another new list file is pre-stored in the data temporary storage module.

More specifically, the client webpage program further includes an archive file data sharing module, and the list file data collection module is connected to the operation interface providing module and the data temporary storage module for at least The same content is filtered out in the two lists, and the same content is output as another new list file, and another new list file is pre-stored in the data temporary storage module.

More specifically, the client webpage program further includes an archive data exclusion module, and the archive data exclusion module is connected to the operation interface providing module and the data temporary storage module for at least The two lists are excluded from the specified content, and the data excluding the same content is output as another new list file, and another new list file is pre-stored in the data temporary storage module.

More specifically, the client webpage program further includes an archive file deduplication module, and the archive file deduplication module is connected to the operation interface providing module and the data temporary storage module, and can provide More than one field option for removing the repeated fields in at least one of the list files, and outputting the removed data to another new list file, and the other new list file is pre- Stored in the data temporary storage module.

A data retrieval analysis system includes: a database platform for storing more than one piece of data; a client webpage program, which can be displayed on a computer device, and the client webpage program and the database platform For the connection, the client webpage program includes at least one operation interface providing module for providing an intuitive operation interface required for operating the client webpage program for operation; a data temporary storage module, and the operation The interface provides a module connection, which is used to store at least one or more list files; a field selection module is connected to the operation interface providing module and the data temporary storage module, and can provide more than one field An option for selecting a field to be viewed; a data capture module is coupled to the operation interface providing module, the data temporary storage module, and the field selection module for use in the column The field selection option selected by the selection module is used to retrieve data from the database platform and is established as a list file, and the created list file is pre-stored in the data temporary storage module. a condition screening module is connected to the operation interface providing module and the data temporary storage module, and is configured to perform condition setting in at least one field option included in the list file to meet the condition in the list file The set data is further screened out and created as a new list file, and the new list file will be pre-stored in the data temporary storage module; a field option customization module is provided with the operation interface. And the data temporary storage module is connected to establish a new field option and a condition definition for setting the field option; and a list file data analysis module, the list file data analysis module and the operation interface Providing a module and the data temporary storage module are connected, capable of providing more than one field option, and selecting one or more field options, the list file data analysis module can correspond to the field option in the list file The data is statistically analyzed, and the statistical analysis result is output as an analysis file, and the output analysis file is pre-stored in the data temporary storage module.

More specifically, the database platform has a plurality of data tables of a single field, and the database platform must be denormalized first to combine several data tables to form a combination. The large data sheet, and the data acquisition module is based on the field selection option selected by the field selection module to retrieve data from the combined large data table of the database platform.

More specifically, the intuitive interface of the operation interface providing module can be a draggable interface, a pointable interface, or a combination of the two.

More specifically, the field option customization module is more capable of creating a new field option directly in the list file, and corresponding to the new field option in the database platform through the data extraction module. The data is taken out and the extracted data is merged into the list file.

More specifically, the client webpage program further includes an archive data merge module, and the archive file merge module is connected to the operation interface providing module and the data temporary storage module to enable At least two of the list files are merged and output as another new list file, and another new list file is pre-stored in the data temporary storage module.

More specifically, the client webpage program further includes an archive file data sharing module, and the list file data collection module is connected to the operation interface providing module and the data temporary storage module for at least The same content is filtered out in the two lists, and the same content is output as another new list file, and another new list file is pre-stored in the data temporary storage module.

More specifically, the client webpage program further includes an archive data exclusion module, and the archive data exclusion module is connected to the operation interface providing module and the data temporary storage module for at least The two lists are excluded from the specified content, and the data excluding the same content is output as another new list file, and another new list file is pre-stored in the data temporary storage module.

More specifically, the client webpage program further includes an archive file deduplication module, and the archive file deduplication module is connected to the operation interface providing module and the data temporary storage module, and can provide More than one field option to remove duplicate columns from at least one of the list files Bit, and the duplicated data is output as another new list file, and another new list file is pre-stored in the data temporary storage module.

More specifically, the client webpage program further includes an archive data analysis module, and the profile data analysis module is connected to the operation interface providing module and the data temporary storage module, and can provide more than one The field option, in selecting more than one field option, the list data analysis module can perform statistical analysis on the data corresponding to the field option in the list file, and output the statistical analysis result as another new one. The list file, and another new list file will be pre-stored in the data temporary storage module.

More specifically, the client webpage program further includes a data analysis setting module, and the data analysis setting module is connected to the intuitive operation interface and the list file data analysis module, and is used to set the list. The statistical analysis mode of the file data analysis module, wherein the statistical analysis mode includes at least statistical analysis conditions and a result output format.

More specifically, the data analysis setting module can directly set the statistical analysis mode directly in the analysis file, and the list data analysis module can perform statistical analysis according to the new statistical analysis mode, and the new statistics are The analysis results replace the statistical analysis results in the original analysis file.

More specifically, the result output format is a table, a chart, or a combination of both.

1‧‧‧Database software

2‧‧‧Database Platform

3‧‧‧Computer equipment

31‧‧‧Client web application

3101‧‧‧Operation interface providing module

31011‧‧‧Intuitive operation interface

3102‧‧‧ Data Temporary Module

3103‧‧‧Field selection module

3104‧‧‧Data acquisition module

3105‧‧‧ Conditional Screening Module

3106‧‧‧Field option custom module

3107‧‧‧Listing data merge module

3108‧‧‧Listing file data sharing module

3109‧‧‧List file data exclusion module

3110‧‧‧Listing data deduplication module

3111‧‧‧Listing data analysis module

3112‧‧‧Data Analysis Setting Module

[Fig. 1] is a schematic diagram of the data acquisition.

[Fig. 2A] is a schematic diagram of the overall structure of the data acquisition analysis system of the present invention.

[Fig. 2B] is a schematic diagram showing the internal structure of the client webpage program of the data acquisition analysis system of the present invention.

[Fig. 3A] is a schematic view showing the first embodiment of the data acquisition analysis system of the present invention.

[Fig. 3B] is a schematic view showing the first embodiment of the data acquisition analysis system of the present invention.

[Fig. 3C] is a schematic view showing the first embodiment of the data acquisition analysis system of the present invention.

[Fig. 3D] is a schematic view showing the first embodiment of the data acquisition analysis system of the present invention.

[Fig. 3E] is a first embodiment of the data acquisition analysis system of the present invention.

[Fig. 4A] Fig. 4 is a schematic view showing the second embodiment of the data acquisition analysis system of the present invention.

[Fig. 4B] is a second embodiment of the data acquisition analysis system of the present invention.

[Fig. 4C] is a second embodiment of the data acquisition analysis system of the present invention.

[Fig. 4D] is a second embodiment of the data acquisition analysis system of the present invention.

[Fig. 4E] Fig. 4 is a schematic view showing the second embodiment of the data acquisition analysis system of the present invention.

[Fig. 4F] Fig. 4 is a schematic view showing the second embodiment of the data acquisition analysis system of the present invention.

[Fig. 4G] is a schematic view of the second embodiment of the data acquisition analysis system of the present invention.

[Fig. 4H] is a schematic view of the second embodiment of the data acquisition analysis system of the present invention.

[Fig. 4I] Fig. 4 is a schematic view showing the second embodiment of the data acquisition analysis system of the present invention.

[Fig. 4J] is a schematic view of the second embodiment of the data acquisition analysis system of the present invention.

[Fig. 5A] Fig. 3 is a schematic view showing the third embodiment of the data acquisition analysis system of the present invention.

[Fig. 5B] is a third embodiment of the data acquisition analysis system of the present invention.

[Fig. 5C] is a third embodiment of the data acquisition analysis system of the present invention.

[Fig. 5D] is a third embodiment of the data acquisition analysis system of the present invention.

[Fig. 6A] is a fourth embodiment of the data acquisition analysis system of the present invention.

[Fig. 6B] is a fourth embodiment of the data acquisition analysis system of the present invention.

[Fig. 6C] is a fourth embodiment of the data acquisition analysis system of the present invention.

[Fig. 7A] is a fifth embodiment of the data acquisition analysis system of the present invention.

[Fig. 7B] is a fifth embodiment of the data acquisition analysis system of the present invention.

[Fig. 7C] is a fifth embodiment of the data acquisition analysis system of the present invention.

[Fig. 7D] is a fifth embodiment of the data acquisition analysis system of the present invention.

[Fig. 8A] Fig. 6 is a schematic view showing the sixth embodiment of the data acquisition analysis system of the present invention.

[Fig. 8B] is a sixth embodiment of the data acquisition analysis system of the present invention.

[Fig. 8C] is a sixth embodiment of the data acquisition analysis system of the present invention.

[Fig. 9A] is a seventh embodiment of the data acquisition analysis system of the present invention.

[Fig. 9B] is a seventh embodiment of the data acquisition analysis system of the present invention.

[Fig. 9C] is a seventh embodiment of the data acquisition analysis system of the present invention.

[Fig. 10A] Fig. 10 is a schematic view showing the eighth embodiment of the data acquisition analysis system of the present invention.

[Fig. 10B] Fig. 10 is a schematic view showing the eighth embodiment of the data acquisition analysis system of the present invention.

[Fig. 10C] Fig. 10 is a schematic view showing the eighth embodiment of the data acquisition analysis system of the present invention.

[Fig. 11A] Fig. 11 is a schematic view showing the ninth implementation of the data acquisition analysis system of the present invention.

[Fig. 11B] Fig. 11 is a schematic view showing the ninth implementation of the data acquisition analysis system of the present invention.

[Fig. 11C] is a schematic view of the ninth implementation of the data retrieval analysis system of the present invention.

[Fig. 11D] is a schematic view of the ninth implementation of the data acquisition analysis system of the present invention.

Other details, features, and advantages of the present invention will be apparent from the following description of the preferred embodiments.

Please refer to FIGS. 2A and 2B , which are schematic diagrams of the overall architecture of the data retrieval analysis system and the internal architecture of the client webpage program. As can be seen from the figure, the data retrieval analysis system includes a database platform 2 and a The computer device 3 of the client webpage program 31, wherein the database platform 2 is used for storing more than one piece of data, and the content of the material is related to user behavior; since the purpose of the invention is to enable an operator who is not an engineer You can easily find the contents of the database without writing complicated code, and use the interface operation of data extraction to complete the actions of obtaining, filtering, adding, and analyzing, and accurately obtain the details of member activities, consumption, shipment, etc. data. To achieve a simple interface operation, in order to achieve this, the database platform 2 must first do the denormalized database architecture (since the database platform 2 has several data tables with a single field or Several data tables with multiple fields, so multiple tables must be combined into one large data table - this example name is VW_CRM, here is the data table with several single fields or several The data tables of multiple fields are combined into one combined large data table. The stored procedures are written, and the data sources are updated regularly every day. The source architecture examples are as follows:

The client webpage program 31 can be connected to the database platform 2, and the client webpage program 31 includes at least one operation interface providing module 3101, a data temporary storage module 3102, and a field selection module. Group 3103, a data retrieval module 3104, a condition screening module 3105, a field option customization module 3106, a list file data merge module 3107, a list file data intersection module 3108, and a list file data exclusion The module 3109, an archive data de-duplication module 3110, an inventory data analysis module 3111, and a data analysis setting module 3112, wherein the operation interface providing module 3101 is provided for providing the client webpage program. The intuitive operation interface 31011 provides a draggable, pulldown or frameable interface for operation.

The data temporary storage module 3102 is configured to store at least one or more list files; the field selection module 3103 is capable of providing more than one field option for selecting a field to be viewed, and The data retrieval module 3104 is capable of acquiring data according to the field selection option selected by the field selection module 3103 in the combined large data table in the database platform 2, and establishing the data as a list file. The list file is pre-stored in the data temporary storage module 3102; and the condition screening module 3105 can be used to set conditions in at least one field option included in the list file to meet the conditions in the list file. The set data is further filtered out and established as a list file, and the created list file is pre-stored in the data temporary storage module 3102; and the actual operation is as shown in Figures 3A to 3E to hold the New Year event. For example, the interface operation of the demonstration data extraction, and the automatic generation of complex database grammar in the program; for the New Year's schedule activities in order to increase the purchase of gas, decided to VIP members and purchased eugenic milk powder The member sends the gift certificate, first finds the member list that meets the qualification for sending the gift certificate. First, as shown in Figure 3A, the data field that you want to see must be selected from the "All Fields" to move to the "current field". After pressing "OK" below, the data of the corresponding name, mobile phone, member type, and product name field will be retrieved in the database platform 2, and the result will be displayed as shown in Fig. 3B, and the above operation mode can be easily obtained. Information, but if you want to write your own database syntax, you can use DISTINCT to exclude VW_CRM due to JOIN multi-TABLE. The architecture example is as follows: However, if the database grammar is very difficult for users who do not have knowledge of the database, it is difficult to directly use such instructions. However, it can be seen from Figure 3B that if the member type is to be selected as VIP, For the member information of eugenic milk powder, as shown in Figures 3C and 3D, after selecting or inputting the conditions, press "OK" below, the results will be displayed as shown in Figure 3E, and the results of Figure 3C~3E The operation is because the client webpage program 31 provides an intuitive interface to simplify the professional operation of the composition of SQL, so it can automatically apply to the logical combination of AND and OR, and can do multiple conditions (OR) in the same field. And each field can be backed up (AND), but if there is no intuitive operation interface 31011 provided by the client webpage program 31, the following instructions must be input by the user (but if the database syntax is Generally speaking, it is difficult for users who do not have knowledge of the database to directly follow such instructions:) For users who generally do not have knowledge of the database, it is difficult to directly use such instructions to complete the purpose of data screening.

The field option customization module 3106 is a condition definition that can be used to create a new field option and can further set the field option; in addition, the field option customization module 3106 can directly directly A new field option is created in the list file stored in the data temporary storage module 3102, and the data corresponding to the new field option is extracted from the database platform 2 through the data extraction module 3104, and the extracted data is taken out. The data is merged into the list file; the actual operation of the new field is as shown in Figures 4A to 4J, because the full number of points is doubled (1 times 1000 times, 2 times 1000~2000, 2000 or more) 3 times), so find the list of eligible data. As shown in Figures 4A and 4B, you must first add a one-page check to find the list of eligible data, so press "+" and then in all fields. Select the data field you want to see (name, region, member type, order date, order amount, order points) to move to the "current field", then press "OK" below, it will be on the database platform 2 In the name, area, member type, order The data of the single date, order amount, order point field, and the result is shown in Figure 4C; since the multiple is a field that is not in the database, a new custom field must be added, so as in 4D As shown in the ~4I figure, the new custom field is set, and the rule for setting the double point is the member type VIP and the order amount is less than 1000=1, the member type VIP and the order amount is between 1000 and 2000=2, and the member type VIP And the order amount is greater than 2000=3, and is named as “multiple”. After pressing “Complete”, the data corresponding to the “Multiple” field will be retrieved in the database platform 2, and the result will be displayed as shown in Figure 4J; If the above-mentioned new custom field is to be input by the user, the following complicated instructions must be input (but if the database syntax is not suitable for users who do not have knowledge of the database, it is difficult to directly use such instructions. of):

If the function is calculated using the existing field values, as shown in Figures 5A to 5D, add a column to calculate the multiple * order points to obtain the double points obtained in this activity, and name it "Double Send First, you must first select the field to be set, then select and input the filter conditions. After all the settings are completed, press "Finish", and the data corresponding to the "Double Delivery" field will be retrieved in the database platform 2. And display the results as shown in Figure 5D; and if the above new custom fields are to be entered by the user, you must enter the following complicated instructions (but if this database syntax is for users who generally do not have knowledge of the database) In terms of it, it is very difficult to directly follow such instructions):

The list file merge module 3107 is configured to be able to merge at least two of the list files into another new list file, and another new list file is pre-stored in the data temporary storage module 1302. Inside, the actual operation is as shown in Figures 6A~6C. Since you want to know the results of this activity, you must first sort through the data to get the list of the event. As shown in Figure 6A, after selecting the merged pattern above, As shown in Figure 6B, select the tab to be merged, and then press "Done". As shown in Figure 6C, a new merge tab containing the source label, Sheet 1&2, and fields will be added. If the above merged tabs are to be generated by the user, the following instructions must be entered (but if the database syntax is not sufficient for users who do not have knowledge of the database), it is difficult to directly enter such instructions:

The list file data sharing module 3108 is configured to filter out the same content data in at least two of the list files, and output the same content data as another new list file, and another new list file will be pre- Stored in the data temporary storage module 1302, and the actual operation is as shown in FIG. 7A. After selecting the pattern of the upper intersection, as shown in FIG. 7B, select the tab to retain the same value, and then press "Complete". After that, as shown in Figures 7C and 7D, the same person in List 1 and List 2 will be taken out, and all the fields of the two tabs will be displayed, and it can be seen from Figure 7D that after the intersection processing, if the same When a person (such as Chen Jinyi) buys multiple items, there will be multiple copies; if the above-mentioned intersection page is to be input by the user, the following instructions must be entered (but if the database syntax is not used for general knowledge of the database) In terms of it, it is very difficult to directly follow such instructions):

The list file data exclusion module 3109 is configured to exclude the data of the specified content from the at least two lists, and output the data after excluding the same content as another new list file, and the other new list file is pre- Stored in the data temporary storage module 3102, and the actual operation is as shown in FIG. 8A. After selecting the pattern excluded above, as shown in FIG. 8B, the tab to be excluded is selected, and then the "finish" is pressed. As shown in Fig. 8C, the display field is the same as the merge, and the data is the same primary key for excluding the intersection; and if the above exclusion tab is to be input by the user, the following instruction must be input (but if such a database is used) Grammar For users who generally do not have knowledge of the database, it is difficult to directly follow such instructions):

The list file deduplication module 3110 is configured to provide more than one field option for removing the repeated fields in at least one of the list files, and outputting the removed data to another new one. The list file, and another new list file will be pre-stored in the data temporary storage module 3102, and the actual operation is as shown in FIG. 9A, after selecting the upper deduplication pattern, as shown in FIG. 9B. , select the field to delete the repeated value, and then press "Done", as shown in Figure 9C, the display field only has the remaining heavy field, and the data is removed repeatedly. If you want the user to enter the input, you must enter the following instructions (but if this database syntax is not easy for users who do not have knowledge of the database), it is difficult to directly enter such instructions:

The list file data analysis module 3111 is configured to provide more than one field option, and select one or more field options, and the list file data analysis module 3111 can display the data in the list file corresponding to the field option. The statistical analysis is performed, and the statistical analysis result is output as an analysis file, and the output analysis file is pre-stored in the data temporary storage module 3102; in addition, the data analysis setting module 3112 can be used to set the list file. The statistical analysis mode of the data analysis module 3111, wherein the statistical analysis mode includes at least a statistical analysis condition and a result output format, and the data analysis setting module 3112 is further capable of setting the statistical analysis mode directly in the analysis file, and The list file data analysis module 3112 can perform statistical analysis according to the new statistical analysis mode, and replace the statistical analysis result in the original analysis file with the new statistical analysis result; and the actual data analysis operation is as shown in FIG. 10A, To analyze the distribution of the members' multiples and write down the percentage of the number of people 1, 2, 3, you must select the graph above. After the case, As shown in FIG. 10B, the field option of “multiple” is selected, and then the data analysis module 3111 of the list file will automatically perform statistical analysis according to the data corresponding to the multiple, and as shown in FIG. 10C. Display the analyzed tables and charts; and in order to analyze the multiples, the regional cross-analysis results of the order amount, and write the multiple of the order amount equal to 1, the Southern District, as shown in Figure 11A, you must open another tab After analysis, as shown in Figure 11B, the field options of "Region", "Order Amount" and "Multiple" are selected and entered into the center. After that, the data analysis module 3111 of the list file will automatically be based on the region and the order. Statistical analysis is performed on the data corresponding to the amount and the multiple, and the analyzed form and chart are displayed as shown in FIG. 11B; and the table format displayed by the analysis can be further modified by the data analysis setting module 3112, such as the 11C As shown in the figure, after clicking the analysis setting, change the format of the analyzed table (for example, drag the area image diagonally upwards). As shown in Figure 11D, the area of the analyzed table will be displayed. In addition to this, it is possible to further set the analyzed chart style (for example, bar graph, column graph, polyline, bar graph, pie chart, area chart, scatter chart, bubble chart, radar chart, stock price) Diagrams, dashboards, full-range diagrams, combination diagrams, Gantt charts, doughnut charts, etc.).

The advantages of the data extraction analysis system provided by the present invention when compared with other conventional techniques are as follows: (1) The present invention can provide an intuitive operation interface, so that the user can easily find it without using complicated code. The information of the database platform, and the extracted data can be established as a list file, and can further obtain, filter, add, merge, analyze and other actions in the intuitive operation mode through the intuitive operation interface.

The present invention has been disclosed above by the above embodiments, but it is not intended to limit the present invention, and anyone skilled in the art can understand the foregoing technical features and implementations of the present invention. For example, and without departing from the spirit and scope of the invention, the scope of the invention is defined by the scope of the appended claims.

2‧‧‧Database Platform

3‧‧‧Computer equipment

31‧‧‧Client web application

Claims (17)

A data retrieval system includes: a database platform for storing more than one piece of data, wherein the database platform has a plurality of data tables of a single field, and the database platform must first be denormalized. After that, a plurality of data tables are combined to form a combined large data table, and the data acquisition module is based on the field selection option selected by the field selection module on the database platform. A client webpage program is displayed on a computer device, and the client webpage program is connected to the database platform, and the client webpage program includes at least: an operation interface providing module For providing an intuitive operation interface for operating the client webpage program for operation; a data temporary storage module is connected to the operation interface providing module, at least for storing more than one list file; A field selection module is connected to the operation interface providing module and the data temporary storage module, and can provide more than one field option for selecting and viewing a data capture module; the data capture module is connected to the operation interface providing module, the data temporary storage module and the field selection module for selecting a field selected by the field according to the field The information is obtained from the database platform and is created as a list file, and the created list file is pre-stored in the data temporary storage module; a conditional screening module is provided with the operation interface and The data temporary storage module is connected to perform condition setting in at least one field option included in the list file, so as to further filter out the conditionally set data in the list file and establish a new list file. And the new list file will be pre-stored in the data temporary storage module; A field option customization module is connected to the operation interface providing module and the data temporary storage module for establishing a new field option and setting a condition definition of the field option. The information retrieval system of claim 1, wherein the intuitive interface provided by the operation interface providing module can be a draggable interface, a clickable interface, or a combination of the two. The data retrieval system of claim 1, wherein the field option customization module is more capable of creating a new field option directly in the list file, and using the data extraction module to be new in the database platform. The data corresponding to the field option is taken out, and the extracted data is merged into the list file. The information retrieval system of claim 1, wherein the client webpage program further comprises an archive data merge module, the archive data merge module and the operation interface providing module and the data temporary storage module The connection is configured to be able to merge at least two of the list files and output them as another new list file, and another new list file is pre-stored in the data temporary storage module. The information retrieval system of claim 1, wherein the client webpage program further comprises an archive data collection module, the interface data collection module and the operation interface providing module and the data temporary storage module The connection is used to filter out the same content in at least two lists, and output the same content as another new list file, and another new list file is pre-stored in the data temporary storage mode. s. The information retrieval system of claim 1, wherein the client webpage program further comprises an archive data exclusion module, the archive data exclusion module is associated with the operation interface providing module and the data temporary storage module The connection is used to exclude the specified content from the at least two lists, and output the data after excluding the same content as another new list file, and another new list file is pre-stored in the data temporary storage. Inside the module. The data retrieval system of claim 1, wherein the client webpage program further comprises There is a list file data deduplication module, and the list file data deduplication module is connected with the operation interface providing module and the data temporary storage module, and can provide more than one field option for at least one The duplicated field is removed from the list file, and the duplicated data is output as another new list file, and another new list file is pre-stored in the data temporary storage module. A data retrieval analysis system includes: a database platform for storing more than one piece of data, wherein the database platform has a plurality of data tables of a single field, and the database platform must first perform anti-regularization After the integration, a number of data tables are combined to form a combined large data table, and the data acquisition module is based on the field selection option selected by the field selection module in the field platform. The client webpage program is displayed on a computer device, and the client webpage program is connected to the database platform. The client webpage program includes at least: an operation interface providing mode The group is configured to provide an intuitive operation interface required to operate the client webpage program for operation; a data temporary storage module is connected to the operation interface providing module, and is configured to store at least one or more of the list files. A field selection module is connected to the operation interface providing module and the data temporary storage module, and can provide more than one field option for selecting The data capture module is connected to the operation interface providing module, the data temporary storage module and the field selection module for selecting the module according to the field selection module. The field option selects the data in the database platform and establishes it as a list file, and the created list file is pre-stored in the data temporary storage module; a condition screening module is provided with the operation interface The group and the data temporary storage module are connected to each other Condition setting is performed in at least one field option included in the list file to further filter out the conditionally set data in the list file and establish a new list file, and the new list file is pre-stored in the In the data temporary storage module; a field option customization module is connected with the operation interface providing module and the data temporary storage module for establishing a new field option and setting the field option. Condition definition; and a list file data analysis module, the list file data analysis module is connected with the operation interface providing module and the data temporary storage module, and can provide more than one field option, and select one or more The field data selection module can perform statistical analysis on the data corresponding to the field option in the list file, and output the statistical analysis result as an analysis file, and the output analysis file is pre-stored in the The data is temporarily stored in the module. The data extraction analysis system of claim 8, wherein the intuitive interface of the operation interface providing module can be a draggable interface, a clickable interface, or a combination of the two. The data extraction analysis system according to claim 8, wherein the field option customization module is further capable of establishing a new field option directly in the list file, and using the data extraction module in the database platform The data corresponding to the new field option is taken out, and the extracted data is merged into the list file. The data extraction analysis system of claim 8, wherein the client webpage program further comprises an archive data merge module, the archive data merge module and the operation interface providing module and the data temporary storage module Connected to enable at least two of the list files to be merged and output as another new list file, and another new list file is pre-stored in the data temporary storage module. The information retrieval analysis system of claim 8, wherein the client webpage program further comprises an archive data intersection module, wherein the profile data intersection module system and the operation interface provide a module The group and the data temporary storage module are connected to filter out the same content in at least two of the list files, and output the same content data as another new list file, and another new list file It will be stored in advance in the data temporary storage module. The data retrieval analysis system of claim 8, wherein the client webpage program further comprises an archive data exclusion module, the archive data exclusion module and the operation interface providing module and the data temporary storage module Connected to exclude the specified content from at least two of the list files, and output the data after excluding the same content as another new list file, and another new list file is pre-stored in the data Save the module. The information retrieval analysis system of claim 8, wherein the client webpage program further comprises an archive data deduplication module, the archive data deduplication module and the operation interface providing module and the data temporary storage The modules are connected to provide more than one field option for removing the repeated fields in at least one of the list files, and outputting the removed data to another new list file, and A new list file will be pre-stored in the data temporary storage module. The information retrieval analysis system of claim 8, wherein the client webpage program further comprises a data analysis setting module, wherein the data analysis setting module is connected to the intuitive operation interface and the list data analysis module. The utility model is used for setting a statistical analysis mode of the data analysis module of the list file, wherein the statistical analysis mode includes at least a statistical analysis condition and a result output format. The data extraction analysis system according to claim 15, wherein the data analysis setting module is further capable of setting the statistical analysis mode directly in the analysis file, and the log file data analysis module is capable of performing statistics according to a new statistical analysis mode. Analyze and replace the statistical analysis results in the original analysis file with the new statistical analysis results. The data retrieval analysis system of claim 15, wherein the result output format is For tables, charts, or a combination of both.