WO2019062019A1

WO2019062019A1 - Data list exporting method and terminal using same

Info

Publication number: WO2019062019A1
Application number: PCT/CN2018/077662
Authority: WO
Inventors: 林林; 张琛
Original assignee: 平安科技（深圳）有限公司
Priority date: 2017-09-30
Filing date: 2018-02-28
Publication date: 2019-04-04
Also published as: CN107784085B; CN107784085A

Abstract

A data list exporting method, a terminal, a terminal device and computer-readable storage medium, the method comprising: displaying a data query result according to a data query request sent by a user terminal (S101); receiving a data exporting instruction returned by the user terminal according to the data query result, and determining data to be exported corresponding to the data export instruction from the data query result (S102); extracting data of which the number of rows matches a preset maximum number of rows for a file from the data to be exported, and generating at least one data sublist according to the data extracted each time (S103); and sending the data sublist to the user terminal (S104).

Description

Method for deriving data list and terminal thereof

The present application claims the priority of the Chinese Patent Application No. 201710919421.8, entitled "Derivation of a Data List and Its Terminal", which is incorporated by reference in its entirety. In this application.

Technical field

The present application belongs to the field of data processing technologies, and in particular, to a method for deriving a data list and a terminal thereof.

Background technique

As various documents are electronically implemented, the amount of data contained in the database is also growing. In daily work and life, users often need to query and export the corresponding data list through the database. Therefore, how to efficiently export the data list is particularly important. When the data list that the user needs to export contains a large amount of data, since the existing data export technology encapsulates all the exported data in one data list for export, the number of data rows of the data list often exceeds the maximum. When the number of rows is accommodated, and the export fails, the data export failure rate is high, which reduces the data export efficiency.

technical problem

The embodiment of the present application provides a method for deriving a data list and a terminal thereof, so as to solve the existing data exporting technology, all the exported data are encapsulated in a data list for export, and the number of data rows of the data list often occurs. If the maximum number of rows is exceeded, and the export fails, the failure rate of data export is high, which reduces the problem of data export efficiency.

Technical solution

A first aspect of the embodiment of the present application provides a method for deriving a data list, where the method for deriving the data list includes:

Displaying a data query result according to a data query request sent by the user terminal;

Receiving, by the user terminal, a data export instruction returned according to the data query result, and determining, from the data query result, the to-be-exported data corresponding to the data export instruction;

And sequentially extracting data matching the maximum number of rows of the preset file from the data to be exported, and generating at least one data sub-list according to the data extracted each time;

Sending the data sublist to the user terminal.

Beneficial effect

According to the preset maximum number of lines of the file, all the data to be exported are split into multiple data sub-lists for export, so that the number of rows actually included in each data sub-list will not exceed the maximum capacity of the file. The number of rows is avoided to avoid the failure of the export due to the excessive amount of data, which improves the success rate of the data export process. On the other hand, due to the improvement of the data export success rate, the number of times the user repeatedly performs the export operation is also reduced, and the efficiency of data list export is also improved.

DRAWINGS

1 is a flowchart of implementing a method for deriving a data list according to a first embodiment of the present application;

2 is a specific implementation flowchart of a method for deriving a data list according to a second embodiment of the present application;

3 is a flowchart of implementing a method for deriving a data list S101 according to a third embodiment of the present application;

4 is a flowchart of implementing a method for deriving a data list S104 according to a fourth embodiment of the present application;

FIG. 5 is a flowchart of implementing a method for deriving a data list S104 according to a fifth embodiment of the present application;

FIG. 6 is a structural block diagram of a data terminal deriving terminal according to an embodiment of the present application;

FIG. 7 is a schematic diagram of a terminal device according to an embodiment of the present application.

Embodiments of the invention

In the embodiment of the present application, the execution subject of the process is a terminal device in which the export program of the data list is installed. FIG. 1 is a flowchart showing an implementation of a method for deriving a data list provided by a first embodiment of the present application, which is described in detail as follows:

In S101, the data query result is displayed according to the data query request sent by the user terminal.

In this embodiment, the user generates a data query request through the local user terminal, and then connects to the terminal device provided in this embodiment through the communication network, and sends a data query request to the terminal device. Specifically, the user can input the keyword of the required query through the data service query interface of the user terminal, and after determining the keywords of all the queries, click the corresponding query confirmation button in the query interface, and the user terminal according to the user in the query interface. The selection content and the input content, the data query request is generated, and is sent to the device corresponding to the destination address indicated by the query interface, that is, the terminal device provided in this embodiment, thereby completing the sending operation of the data query request. Preferably, the user can open the corresponding data service query interface through the APP or the client and other related application programs to complete the data query operation, in addition to opening the webpage page corresponding to the data service query interface through the browser provided in the user terminal.

In this embodiment, after receiving the data query request sent by the user terminal, the terminal device queries the data matching the keyword in the database according to the keyword included in the data query request, and uses the matched data as data. Query the query result corresponding to the request, and then display the query result.

In this embodiment, the terminal device can display all the query results in one page, so that the user can view all the query data by scrolling the page. Since the data content that can be displayed by one interface is limited, in this case, the terminal device only loads the first M query data results, wherein the M value is the number of maximum query data results that can be accommodated in one page interface, when the user slides When viewing the data below, the terminal device reloads the query data result of the corresponding location, thereby avoiding the waiting time for the first display being too long. In addition, the terminal device can display the query result by paging, divide the query result into multiple pages, and set the corresponding number. The user terminal controls the display interface to display the corresponding query result display page by sending the corresponding number.

In S102, a data export instruction that is returned by the user terminal according to the data query result is received, and data to be exported corresponding to the data export instruction is determined from the data query result.

In this embodiment, after obtaining the query result returned by the terminal device, the user terminal may select data to be exported in the query result. For example, the user can select the data to be exported by checking the manner. If the query result is displayed by paging, the corresponding data page can be selected to indicate that all the query data in the data page is exported. Of course, the user can also export all the query results, and select all the options by clicking the all-select button or the all-export button. After confirming the data that the user needs to export, the user terminal generates a data export instruction corresponding thereto and returns it to the terminal device.

In this embodiment, after receiving the data export instruction returned by the user terminal, the terminal device extracts the data identifier included in the data export instruction, and determines the data that the user needs to export according to the data identifier, and extracts the query result. , get the data to be exported.

In S103, data matching the maximum number of rows of the preset file is extracted from the data to be exported, and at least one data sub-list is generated according to the data extracted each time.

In this embodiment, the user terminal pre-sets the maximum number of lines of the file, and the maximum number of lines of the file is specifically used to display the maximum number of lines included in a data sub-list, so as to avoid the number of data rows included in the data sub-list being too large. The sending of an export exception occurred.

In this embodiment, the matching with the maximum number of lines of the preset file is specifically: the number of extracted lines is less than or equal to the maximum number of lines of the file. Specifically, after the terminal device determines the data to be exported according to the data exporting instruction, the data of the corresponding row number is sequentially extracted from the data to be exported according to the maximum number of rows of the preset file, and a data sub-list is generated, if not extracted, If the number of rows of the exported data is less than the maximum number of rows of the file, the last data sub-list is generated from the un-exported data to be extracted, and the operation of S104 is performed.

In this embodiment, the maximum number of lines of the preset file can be set by default by the terminal device, and the default value is the maximum number of lines that the data sub-list can actually accommodate.

In S104, the data sub-list is sent to the user terminal.

In this embodiment, after the terminal device generates at least one data sub-list according to the data export instruction of the user, all the data sub-lists are sent to the user terminal to implement the purpose of exporting the page in response to the user's data. Specifically, the terminal device may send the data sub-list to the user terminal immediately after each data sub-list is generated, or after all the data sub-lists are generated, the terminal device aggregates all the data sub-lists and uniformly sends them to the user terminal.

In this embodiment, after all the data sub-lists are generated, the terminal device determines whether the data to be exported includes unexported data through a preset data leak detection algorithm, and if so, determines the last generated data sub-list. Whether the number of rows is less than the maximum number of rows in the file. If less, the data to be exported is added to the last generated data sublist; if equal, an independent data sublist is generated.

It can be seen that the method for deriving a data list provided by the embodiment of the present application receives the data query request of the user and displays the data query result required by the user, so that the user can select the data to be exported from the data query result. After receiving the data export instruction of the user, the export terminal of the data list extracts only the data matching the maximum number of rows of the preset file at a time, and generates a data sub-list, and then takes all the generated data sub-lists as The result of the export is returned to the user terminal. Compared with the existing data exporting technology, the method for deriving the data list provided by the embodiment of the present application does not encapsulate all the data to be exported in one data list, but according to the maximum number of rows of the preset file, The data to be exported is split into multiple data sub-lists for export, so that the number of rows actually included in each data sub-list will not exceed the maximum number of rows that can be accommodated by the file, so as to avoid the situation that the export fails due to excessive data volume. Occurs, improving the success rate of the data export process. On the other hand, due to the improvement of the data export success rate, the number of times the user repeatedly performs the export operation is also reduced, and the efficiency of data list export is also improved.

FIG. 2 is a flowchart showing a specific implementation of a method for deriving a data list according to a second embodiment of the present application. Referring to FIG. 2, with reference to the embodiment shown in FIG. 1, a method for deriving a data list provided by this embodiment includes the following steps, which are detailed as follows:

In S201, the data query result is displayed according to the data query request sent by the user terminal.

In S202, a data export instruction that is returned by the user terminal according to the data query result is received.

Further, the determining, by the data query result, the data to be exported corresponding to the data exporting instruction includes:

In S203, the communication connection with the user terminal is disconnected, and after the communication connection is disconnected, the data to be exported corresponding to the data export instruction is determined from the data query result.

In this embodiment, the terminal device and the user terminal perform information exchange through the established communication connection, for example, the terminal device receives the data query request initiated by the user terminal, and the user terminal receives the query result returned by the terminal device, etc., therefore, the two In the process of data interaction, the corresponding port number is inevitably occupied to establish a communication connection, and data communication is performed through the communication connection.

In this embodiment, after receiving the data export instruction sent by the user terminal, the terminal device disconnects the communication connection with the user terminal, and adjusts the corresponding port number from the occupied state to the idle state, and executes the slave The operation of determining the data to be exported corresponding to the data export instruction is determined in the data query result. Since the time of the data export process is generally long, and there is no data interaction between the terminal device and the user terminal during the export process, the data is waiting for the result. Therefore, the relevant communication resources can be released at this time to reduce the network resources. Occupy.

In S204, data matching the maximum number of rows of the preset file is extracted from the data to be exported, and at least one data sub-list is generated according to the data extracted each time.

Further, the sending the data sub-list to the user terminal includes:

In S205, if it is detected that the to-be-exported data has been extracted, a communication connection request is sent to the user terminal to establish a communication connection with the user terminal.

In this embodiment, after the terminal device determines that all the data to be exported has been extracted, and the last data sub-list has been generated, it indicates that the export operation has been completed, and the relevant export result can be fed back to the user terminal. Therefore, a communication connection request is sent to the user terminal according to the network address of the user terminal, so that the user terminal establishes a communication link and feeds back the relevant derivation result.

In this embodiment, after receiving the communication connection request sent by the terminal device, the user terminal returns a connection confirmation command to the terminal device, and after receiving the connection confirmation command returned by the user terminal, the terminal device determines that the communication connection has been established. , the related operations of S206 can be performed.

In S206, a derivation result is generated according to the plurality of the data sub-lists, and the derivation result is sent to the user terminal.

In this embodiment, since the terminal device may generate a plurality of data sub-lists in the process of exporting data, in this case, the plurality of data sub-lists are encapsulated in the same file to generate the above-mentioned derivation result.

In this embodiment, after generating the derivation result, the terminal device sends the derivation result to the user terminal through the communication channel established in S205 to complete the response of the derivation data service. Optionally, the user terminal is configured to have a maximum waiting time. When the user terminal sends a data export instruction, the user terminal starts to perform timing. If the waiting time is greater than the maximum waiting time, the communication connection is established with the terminal device, and the export progress is obtained. Instructions to confirm the current export progress.

In the embodiment of the present application, after receiving the data export instruction sent by the user, the communication connection with the user is disconnected, the communication resource is released, and the connection is established after the export operation is completed, and the corresponding export is returned to the same. As a result, the connection failure is prevented due to long-time connection, and the export result cannot be fed back to the user. On the other hand, the network resource is also released, and the process of waiting for a long time in the export process has less data interaction. In this case, the terminal device can respond to the service request of the other user terminal. Therefore, the time division multiplexing of the terminal device service can be fully implemented in the embodiment, the utilization rate of the terminal device is improved, and the occupancy rate of the exported operation resource is reduced.

FIG. 3 is a flowchart showing a specific implementation of a method for deriving a data list S101 according to the third embodiment of the present application. As shown in FIG. 3, with respect to the embodiment shown in FIG. 1, a method S101 for processing customer feedback information provided by this embodiment includes S301~S303, which is as follows:

The data query result in the database that matches the data query request, and the number of data corresponding to the data query result.

In this embodiment, after receiving the data query request of the user, the terminal device determines, according to the query keyword included in the data query request, a data query result that matches the query keyword in the database, and in this step, the terminal device The data obtained by the query is not extracted, but the data matching the query keyword is marked in the database.

In this embodiment, after the terminal device completes the search in the entire database, the data query result is obtained, and all the data to be displayed that matches the query keyword in the database is determined. At this time, the terminal device will include the statistics included in the query result. The number of data, specifically, the number of rows included in the data list obtained by the query.

In S302, the data query result is divided into a plurality of sub-data query results according to a preset maximum number of displays, and a display number is associated with each of the sub-data query results.

In this embodiment, the maximum number of displays is displayed in the terminal device, that is, the number of data or the number of list lines that can be displayed at one time in one page. The maximum number of displays can be set by the system default, or can be adjusted at any time by the user during the query process. Preferably, the maximum number of displays is related to the resolution of the user terminal and the area of the display module, and the maximum number of data that can be accommodated in the same interface is determined according to the resolution of the user terminal and the area of the display module, as the maximum number of displays. .

In this embodiment, the terminal device divides the maximum number of displays and the number of data included in the data query result into multiple sub-data query results, wherein each sub-data query result includes the maximum number of data. The maximum number of displays.

In this embodiment, the terminal device associates each sub-data query result with a display number, that is, a relationship in which the display number and the sub-data query result are in one-to-one correspondence. Specifically, the terminal device may sort the data in the data query result according to a preset sorting manner, and sequentially divide the data query result according to the maximum display number, and sequentially number them.

In S303, the sub-data query result associated with the display number is extracted from the database according to the display number selected by the user terminal, and displayed.

In this embodiment, the terminal device may extract the sub-data query result associated with the display number from the database to the local cache according to the display number sent by the user terminal, and display the data included in the sub-data query result. That is, in the embodiment, the amount of data extracted by the terminal device from the database is the amount of data corresponding to the maximum number of displays.

In the embodiment of the present application, the amount of data extracted by the terminal device is the amount of data corresponding to the maximum number of displays. Since the terminal device does not extract all the data obtained by the query at one time, the waiting time is less, and the response rate is shorter. Fast, so as to avoid the service response timeout caused by the long extraction operation time.

FIG. 4 is a flowchart showing a specific implementation of a method for deriving a data list S103 according to the fourth embodiment of the present application. Referring to FIG. 4, in the embodiment of the data list, the S103 further includes S401~S403 in the method for deriving the data list according to the embodiment shown in FIG.

In S401, an export control instruction initiated by the user terminal is received.

In this embodiment, the corresponding export control button is set by the AJAX technology in the export display page of the user terminal. During the export process, the user can click the corresponding export control button on the local user terminal, and then after receiving the relevant click operation, the user terminal will generate a corresponding export control instruction through the AJAX technology in the page, and export the control command. Send to the terminal device.

In this embodiment, the export control instructions include, but are not limited to, suspending the export instruction, terminating the export instruction, restoring the export instruction, re-exporting the instruction, and the like.

In S402, the export control instruction is added to the extraction operation control data flow; wherein the extraction operation control data flow is: control data generated between the export terminal of the data list and the database when performing the extraction operation.

In this embodiment, in the process of performing the export operation between the terminal device and the database, two data streams are generated between the two, which are: the data stream of the extraction result pointed out by the database to the terminal device, that is, the data sub-list of the generated data is extracted. The data stream generated by the data; and the terminal device, that is, the export terminal of the above data list points to the extraction operation control data flow of the database, and is used for controlling the database to perform related extraction operations, such as sending the maximum number of lines of the file to the database, and the current extraction operation The number range of the data to be exported and the control data such as the above-mentioned export control command.

In this embodiment, after receiving the export control instruction sent by the user terminal, the terminal device adds the export control command to the extraction operation control data stream, so that the control data stream is transmitted to the database to implement a corresponding export control operation. .

In S403, if the extraction operation control data stream includes an export control instruction, the derivation control operation corresponding to the derivation control instruction is executed.

In this embodiment, when the database corresponding to the terminal device detects that the extraction operation control data stream includes the export control instruction, the export control operation of the response is performed. Specifically, if the export control instruction is a pause export instruction, stopping the data extraction operation, waiting for the user to start the export process again; if the export control instruction is aborting the export instruction, ending the export response operation and deleting the generated output The data sub-list; if the export control instruction is the resume export instruction, the data extraction operation corresponding to the pause time is continued, and the data sub-list corresponding to the pause time is generated.

In the embodiment of the present application, the user terminal can control the export operation of the terminal device at any time, thereby improving the operable range of the user and the user experience.

FIG. 5 is a flowchart showing a specific implementation of a method for deriving a data list S103 according to the fifth embodiment of the present application. As shown in FIG. 5, in the method for deriving the data list provided in this embodiment, S103 further includes S501 and S502, which are as follows:

In S501, the value of the derived response timer is reset after each of the data sublists is generated.

In this embodiment, the terminal device sets a corresponding maximum operation duration in each related operation to automatically repair the abnormal operation. Therefore, the terminal device sets the maximum response duration in order to determine whether the export operation is abnormal.

In this embodiment, after each data sub-list is generated, the terminal device resets the value of the derivation response timer to avoid that the amount of data to be exported is too large, and the response time is too long, and is determined to be an abnormal operation. . On the other hand, the export response timer is also used to keep the session between the terminal device and the database valid. Since the terminal device and the database need to maintain data interaction status for a long time during the export process, a session is established between the two. The duration, that is, the session value, when the terminal device resets the value of the response timer, the session value is also updated synchronously to maintain the session between the terminal device and the database.

In S502, if the value of the export response timer is greater than a preset maximum response duration, the export exception operation is performed.

In this embodiment, when the terminal device detects that the value of the export response timer is greater than the maximum response duration, it determines that there is an abnormality in the current export operation, and thus the export abnormal operation is performed. Specifically, the exporting the abnormal operation may be: disconnecting the data connection with the database, and restarting the database; and re-establishing the connection after the database startup is completed, so as to perform the export operation again.

In the embodiment of the present application, after each data sub-list is generated, the value of the export response timer is reset to keep the session between the terminal device and the database valid, and the export timeout is avoided due to excessive data volume. The situation happened.

FIG. 6 is a structural block diagram of a derivation terminal of a data list according to an embodiment of the present application, where each unit included in the derivation terminal of the data list is used to execute each step in the embodiment corresponding to FIG. 1. For details, please refer to the related description in the embodiment corresponding to FIG. 1 and FIG. For the convenience of explanation, only the parts related to the present embodiment are shown.

Referring to FIG. 6, the export terminal of the data list includes:

The data query result display unit 61 is configured to display a data query result according to the data query request sent by the user terminal;

The to-be-exported data determining unit 62 is configured to receive a data exporting instruction that is returned by the user terminal according to the data query result, and determine, from the data query result, the to-be-exported data corresponding to the data exporting instruction;

The data sub-list generating unit 63 is configured to sequentially extract data matching the maximum number of rows of the preset file from the data to be exported, and generate at least one data sub-list according to the data extracted each time;

The data sub-list sending unit 64 is configured to send the data sub-list to the user terminal.

Optionally, the to-be-exported data determining unit 62 includes:

a communication connection interruption unit, configured to disconnect a communication connection with the user terminal, and determine, after the communication connection is disconnected, the data to be exported corresponding to the data export instruction from the data query result;

The data sub-list sending unit 64 includes:

a communication connection reconnection unit, configured to: if it is detected that the to-be-exported data has been extracted, send a communication connection request to the user terminal to establish a communication connection with the user terminal;

And a derivation result sending unit, configured to generate a derivation result according to the plurality of the data sub-lists, and send the derivation result to the user terminal.

Optionally, the data query result display unit 61 includes:

a data query result determining unit, configured to determine the data query result in the database that matches the data query request, and the number of data corresponding to the data query result;

a data query result dividing unit, configured to divide the data query result into a plurality of sub-data query results according to a preset maximum number of displays, and associate a display number with each of the sub-data query results;

The sub-data query result display unit is configured to extract and display the sub-data query result associated with the display number from the database according to the display number selected by the user terminal.

Optionally, the data sub-list generating unit 63 includes:

And an export control instruction receiving unit, configured to receive an export control instruction initiated by the user terminal;

And an export control instruction adding unit, configured to add the export control command to the extracting operation control data stream; wherein the extracting operation controls the data stream to be: when the extracting terminal of the data list and the database are generated during the extracting operation Control data;

The export control command response unit is configured to execute the export control operation corresponding to the export control command if the extraction operation control data stream includes an export control command.

Optionally, the data sub-list generating unit 63 includes:

a response timer reset unit, configured to reset a value of the export response timer after each generating the data sublist;

The exception processing unit is configured to perform an export exception operation if the value of the export response timer is greater than a preset maximum response duration.

Therefore, the derivation terminal of the data category provided by the embodiment of the present application can also split all the data to be exported into multiple data sub-lists according to the preset maximum number of lines of the file, so that each data sub-list actually contains The number of rows will not exceed the maximum number of rows that the file can accommodate, avoiding the failure of the export due to excessive data volume, and improving the success rate of the data export process. On the other hand, due to the improvement of the data export success rate, the number of times the user repeatedly performs the export operation is also reduced, and the efficiency of data list export is also improved.

FIG. 7 is a schematic diagram of a terminal device according to another embodiment of the present application. As shown in FIG. 7, the terminal device 7 of this embodiment includes a processor 70, a memory 71, and computer readable instructions 72 stored in the memory 71 and operable on the processor 70, such as a data list. Export the program. The processor 70 executes the steps of the method for deriving the respective data lists when the computer readable instructions 72 are executed, such as S101 to S104 shown in FIG. 1. Alternatively, the processor 70, when executing the computer readable instructions 72, implements the functions of the various units in the various apparatus embodiments described above, such as the functions of the modules 61-64 shown in FIG.

Illustratively, the computer readable instructions 72 may be partitioned into one or more units, the one or more units being stored in the memory 71 and executed by the processor 70 to complete the application. . The one or more units may be a series of computer readable instruction instructions segments capable of performing a particular function for describing the execution of the computer readable instructions 72 in the terminal device 7. For example, the computer readable instructions 72 may be segmented into a data query result display unit, a data to be derived determination unit, a data sub-list generation unit, and a data sub-list transmission unit, each unit functioning as above.

The terminal device 7 may be a computing device such as a desktop computer, a notebook, a palmtop computer, and a cloud server. The terminal device may include, but is not limited to, a processor 70 and a memory 71. It will be understood by those skilled in the art that FIG. 7 is only an example of the terminal device 7, and does not constitute a limitation of the terminal device 7, and may include more or less components than those illustrated, or combine some components or different components. For example, the terminal device may further include an input/output device, a network access device, a bus, and the like.

The so-called processor 70 can be a central processing unit (Central Processing Unit, CPU), can also be other general-purpose processors, digital signal processors (DSP), application specific integrated circuits (Application Specific Integrated Circuit (ASIC), Field-Programmable Gate Array (FPGA) or other programmable logic device, discrete gate or transistor logic device, discrete hardware components, etc. The general purpose processor may be a microprocessor or the processor or any conventional processor or the like.

The memory 71 may be an internal storage unit of the terminal device 7, such as a hard disk or a memory of the terminal device 7. The memory 71 may also be an external storage device of the terminal device 7, for example, a plug-in hard disk provided on the terminal device 7, a smart memory card (SMC), and a secure digital (SD). Card, flash card (Flash Card) and so on. Further, the memory 71 may also include both an internal storage unit of the terminal device 7 and an external storage device. The memory 71 is configured to store the computer readable instructions and other programs and data required by the terminal device. The memory 71 can also be used to temporarily store data that has been output or is about to be output.

The above-mentioned embodiments are only used to explain the technical solutions of the present application, and are not limited thereto; although the present application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that they can still implement the foregoing embodiments. The technical solutions described in the examples are modified or equivalently replaced with some of the technical features; and the modifications or substitutions do not deviate from the spirit and scope of the technical solutions of the embodiments of the present application, and should be included in Within the scope of protection of this application.

Claims

A method for deriving a data list, comprising:

Displaying a data query result according to a data query request sent by the user terminal;

Receiving, by the user terminal, a data export instruction returned according to the data query result, and determining, from the data query result, the to-be-exported data corresponding to the data export instruction;

And sequentially extracting data matching the maximum number of rows of the preset file from the data to be exported, and generating at least one data sub-list according to the data extracted each time;

Sending the data sublist to the user terminal.
The method according to claim 1, wherein the determining, from the data query result, the data to be exported corresponding to the data exporting instruction comprises:

Disconnecting the communication connection with the user terminal, and determining, after the communication connection is disconnected, the data to be exported corresponding to the data exporting instruction from the data query result;

The sending the data sub-list to the user terminal includes:

If it is detected that the data to be exported has been extracted, sending a communication connection request to the user terminal to establish a communication connection with the user terminal;

Generating an export result according to the plurality of data sub-lists, and transmitting the export result to the user terminal.
The derivation method according to claim 1, wherein the displaying the data query result according to the data query request sent by the user terminal comprises:

Determining, in the database, the data query result that matches the data query request, and the number of data corresponding to the data query result;

Dividing the data query result into a plurality of sub-data query results according to a preset maximum number of displays, and respectively correlating display numbers with each of the sub-data query results;

And extracting, according to the display number selected by the user terminal, the sub-data query result associated with the display number from the database and displaying the sub-data query result.
The derivation method according to any one of claims 1-3, wherein the data that is matched with the maximum number of rows of the preset file is extracted from the data to be exported in turn, and is extracted according to each time. The data generated by the at least one data sub-list includes:

Receiving an export control instruction initiated by the user terminal;

Adding the export control instruction to the extraction operation control data flow; wherein the extraction operation control data flow is: control data generated between the export terminal of the data list and the database when performing an extraction operation;

And if the extraction operation control data stream includes an export control instruction, performing an export control operation corresponding to the export control instruction.
The derivation method according to claim 1, wherein the data that matches the maximum number of rows of the preset file is extracted from the data to be exported in turn, and the data sublist is generated according to the data extracted each time. include:

Resetting the value of the export response timer after each generation of the data sublist;

The export method further includes:

If the value of the export response timer is greater than a preset maximum response duration, an export exception operation is performed.
An export terminal for a data list, comprising:

a data query result display unit, configured to display a data query result according to the data query request sent by the user terminal;

a to be derived data determining unit, configured to receive a data export instruction returned by the user terminal according to the data query result, and determine, from the data query result, the to-be-exported data corresponding to the data exporting instruction;

a data sub-list generating unit, configured to sequentially extract data matching the maximum number of rows of the preset file from the data to be exported, and generate at least one data sub-list according to the data extracted each time;

And a data sub-list sending unit, configured to send the data sub-list to the user terminal.
The deriving terminal according to claim 6, wherein the data to be derived determining unit comprises:

a communication connection interruption unit, configured to disconnect a communication connection with the user terminal, and determine, after the communication connection is disconnected, the data to be exported corresponding to the data export instruction from the data query result;

The data sub-list sending unit includes:

a communication connection reconnection unit, configured to: if it is detected that the to-be-exported data has been extracted, send a communication connection request to the user terminal to establish a communication connection with the user terminal;

And a derivation result sending unit, configured to generate a derivation result according to the plurality of the data sub-lists, and send the derivation result to the user terminal.
The derivation terminal according to claim 6, wherein the data query result display unit comprises:

a data query result determining unit, configured to determine the data query result in the database that matches the data query request, and the number of data corresponding to the data query result;

a data query result dividing unit, configured to divide the data query result into a plurality of sub-data query results according to a preset maximum number of displays, and associate a display number with each of the sub-data query results;

The sub-data query result display unit is configured to extract and display the sub-data query result associated with the display number from the database according to the display number selected by the user terminal.
The deriving terminal according to any one of claims 6 to 8, wherein the data sub-list generating unit comprises:

And an export control instruction receiving unit, configured to receive an export control instruction initiated by the user terminal;

And an export control instruction adding unit, configured to add the export control command to the extracting operation control data stream; wherein the extracting operation controls the data stream to be: when the extracting terminal of the data list and the database are generated during the extracting operation Control data;

The export control command response unit is configured to execute the export control operation corresponding to the export control command if the extraction operation control data stream includes an export control command.
The adjustment terminal according to claim 6, wherein the data sub-list generating unit comprises:

a response timer reset unit, configured to reset a value of the export response timer after each generating the data sublist;

The exception processing unit is configured to perform an export exception operation if the value of the export response timer is greater than a preset maximum response duration.
A terminal device, comprising: a memory, a processor, and computer readable instructions stored in the memory and executable on the processor, the processor executing the computer readable The following steps are implemented when the instruction is executed:

Displaying a data query result according to a data query request sent by the user terminal;

Receiving, by the user terminal, a data export instruction returned according to the data query result, and determining, from the data query result, the to-be-exported data corresponding to the data export instruction;

And sequentially extracting data matching the maximum number of rows of the preset file from the data to be exported, and generating at least one data sub-list according to the data extracted each time;

Sending the data sublist to the user terminal.
The terminal device according to claim 11, wherein the determining, by the data query result, the data to be exported corresponding to the data exporting instruction comprises:

Disconnecting the communication connection with the user terminal, and determining, after the communication connection is disconnected, the data to be exported corresponding to the data exporting instruction from the data query result;

The sending the data sub-list to the user terminal includes:

If it is detected that the data to be exported has been extracted, sending a communication connection request to the user terminal to establish a communication connection with the user terminal;

Generating an export result according to the plurality of data sub-lists, and transmitting the export result to the user terminal.
The terminal device according to claim 11, wherein the displaying the data query result according to the data query request sent by the user terminal comprises:

Determining, in the database, the data query result that matches the data query request, and the number of data corresponding to the data query result;

Dividing the data query result into a plurality of sub-data query results according to a preset maximum number of displays, and respectively correlating display numbers with each of the sub-data query results;

And extracting, according to the display number selected by the user terminal, the sub-data query result associated with the display number from the database and displaying the sub-data query result.
The terminal device according to any one of claims 11 to 13, wherein the data that is matched from the data to be exported is matched with the maximum number of rows of the preset file, and is extracted according to each time. The data generated by the at least one data sub-list includes:

Receiving an export control instruction initiated by the user terminal;

Adding the export control instruction to the extraction operation control data flow; wherein the extraction operation control data flow is: control data generated between the export terminal of the data list and the database when performing an extraction operation;

And if the extraction operation control data stream includes an export control instruction, performing an export control operation corresponding to the export control instruction.
The terminal device according to claim 11, wherein the data that matches the maximum number of lines of the preset file is extracted from the data to be exported, and the data sublist is generated according to the data extracted each time. include:

Resetting the value of the export response timer after each generation of the data sublist;

The export method further includes:

If the value of the export response timer is greater than a preset maximum response duration, an export exception operation is performed.
A computer readable storage medium storing computer readable instructions, wherein the computer readable instructions, when executed by a processor, implement the following steps:

Displaying a data query result according to a data query request sent by the user terminal;

Receiving, by the user terminal, a data export instruction returned according to the data query result, and determining, from the data query result, the to-be-exported data corresponding to the data export instruction;

And sequentially extracting data matching the maximum number of rows of the preset file from the data to be exported, and generating at least one data sub-list according to the data extracted each time;

Sending the data sublist to the user terminal.
The computer readable storage medium according to claim 16, wherein the determining, from the data query result, the data to be exported corresponding to the data exporting instruction comprises:

Disconnecting the communication connection with the user terminal, and determining, after the communication connection is disconnected, the data to be exported corresponding to the data exporting instruction from the data query result;

The sending the data sub-list to the user terminal includes:

If it is detected that the data to be exported has been extracted, sending a communication connection request to the user terminal to establish a communication connection with the user terminal;

Generating an export result according to the plurality of data sub-lists, and transmitting the export result to the user terminal.
The computer readable storage medium according to claim 16, wherein the displaying the data query result according to the data query request sent by the user terminal comprises:

Determining, in the database, the data query result that matches the data query request, and the number of data corresponding to the data query result;

Dividing the data query result into a plurality of sub-data query results according to a preset maximum number of displays, and respectively correlating display numbers with each of the sub-data query results;

And extracting, according to the display number selected by the user terminal, the sub-data query result associated with the display number from the database and displaying the sub-data query result.
The computer readable storage medium according to any one of claims 16 to 18, wherein the data extracted from the data to be exported is matched with the maximum number of rows of the preset file, and is respectively Generating at least one data sublist for each of the extracted data includes:

Receiving an export control instruction initiated by the user terminal;

Adding the export control instruction to the extraction operation control data flow; wherein the extraction operation control data flow is: control data generated between the export terminal of the data list and the database when performing an extraction operation;

And if the extraction operation control data stream includes an export control instruction, performing an export control operation corresponding to the export control instruction.
The computer readable storage medium according to claim 16, wherein the data that matches the maximum number of lines of the preset file is extracted from the data to be exported in turn, and is generated according to the data extracted each time. The data sublist includes:

Resetting the value of the export response timer after each generation of the data sublist;

The export method further includes:

If the value of the export response timer is greater than a preset maximum response duration, an export exception operation is performed.