CN107784085A - The deriving method and its terminal of a kind of data list - Google Patents
The deriving method and its terminal of a kind of data list Download PDFInfo
- Publication number
- CN107784085A CN107784085A CN201710919421.8A CN201710919421A CN107784085A CN 107784085 A CN107784085 A CN 107784085A CN 201710919421 A CN201710919421 A CN 201710919421A CN 107784085 A CN107784085 A CN 107784085A
- Authority
- CN
- China
- Prior art keywords
- data
- export
- user terminal
- query result
- exported
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention is applied to technical field of data processing, there is provided the deriving method and its terminal of a kind of data list, including：The data inquiry request sent according to user terminal, display data Query Result；Receive the data that user terminal returns according to data query result and export instruction, and data to be exported corresponding to data export instruction is determined from data query result；The data that line number matches with default file maximum number of lines are extracted from data to be exported successively, and generate at least one data sublist according to the data extracted every time respectively；Data sublist is sent to the user terminal.The present invention; solve in existing data export technology; all derived data are packaged in a data list and exported; the number of data lines that data list can usually occur accommodates line number beyond maximum; and the situation for causing export to fail; mortality is higher derived from data, the problem of reducing the export efficiency of data.
Description
Technical field
The invention belongs to the deriving method and its terminal of technical field of data processing, more particularly to a kind of data list.
Background technology
As various file carries out electronization, the data volume included in database is also more and more huger.User exists
In routine work and life, it is often necessary to by data base querying and corresponding data list is exported, therefore it is how efficient
Ground export data list is particularly important.And when the data volume that data list derived from user's needs includes is larger, due to
In existing data export technology, all derived data are packaged in a data list and exported, can usually be occurred
The number of data lines of data list accommodates line number beyond maximum, and the situation for causing export to fail, and mortality derived from data is higher,
Reduce the export efficiency of data.
The content of the invention
In view of this, it is existing to solve the embodiments of the invention provide a kind of deriving method of data list and its terminal
Data export technology in, all derived data are packaged in a data list and exported, data can usually occur
The number of data lines of list accommodates line number beyond maximum, and the situation for causing export to fail, and mortality derived from data is higher, reduces
The problem of export efficiency of data.
The first aspect of the embodiment of the present invention provides a kind of deriving method of data list, the export of the data list
Method includes：
The data inquiry request sent according to user terminal, display data Query Result；
Receive the data that the user terminal returns according to the data query result and export instruction, and looked into from the data
Ask and data to be exported corresponding to the data export instruction is determined in result；
The data that line number matches with default file maximum number of lines, and root respectively are extracted from the data to be exported successively
At least one data sublist is generated according to the data extracted every time；
The data sublist is sent to the user terminal.
The second aspect of the embodiment of the present invention provides a kind of terminal device, including memory, processor and is stored in
In the memory and the computer program that can run on the processor, described in the computing device during computer program
Realize following steps：
The data inquiry request sent according to user terminal, display data Query Result；
Receive the data that the user terminal returns according to the data query result and export instruction, and looked into from the data
Ask and data to be exported corresponding to the data export instruction is determined in result；
The data that line number matches with default file maximum number of lines, and root respectively are extracted from the data to be exported successively
At least one data sublist is generated according to the data extracted every time；
The data sublist is sent to the user terminal.
The third aspect of the embodiment of the present invention provides a kind of computer-readable recording medium, the computer-readable storage
Media storage has computer program, and the computer program realizes following steps when being executed by processor：
The data inquiry request sent according to user terminal, display data Query Result；
Receive the data that the user terminal returns according to the data query result and export instruction, and looked into from the data
Ask and data to be exported corresponding to the data export instruction is determined in result；
The data that line number matches with default file maximum number of lines, and root respectively are extracted from the data to be exported successively
At least one data sublist is generated according to the data extracted every time；
The data sublist is sent to the user terminal.
The deriving method and its terminal for implementing a kind of data list provided in an embodiment of the present invention have the advantages that：
The embodiment of the present invention shows the data query result needed for user by receiving the data inquiry request of user,
Derived data are treated so as to which user can choose from data query result, the export terminal of data list is receiving the number of user
After being instructed according to export, then the data that line number matches with default file maximum number of lines are only extracted every time, and generate data
List, all generations are then obtained into data sublist and return to user terminal as export result.Exported with existing data
Technology is compared, the deriving method of data list provided in an embodiment of the present invention, will not be needed derived data and is packaged in
In one data list, but according to default file maximum number of lines, all data to be exported are split as multiple data
List is exported, so as to which the actual line number included of each data sublist will not be over the maximum open ended line number of file,
The situation for avoiding factor data amount excessive and causing export to fail occurs, and improves the success rate of data export process.On the other hand,
Due to the raising of data export success rate, the number that user repeats export operation is decreased, also improves data list
Derived efficiency.
Brief description of the drawings
Technical scheme in order to illustrate the embodiments of the present invention more clearly, below will be to embodiment or description of the prior art
In the required accompanying drawing used be briefly described, it should be apparent that, drawings in the following description be only the present invention some
Embodiment, for those of ordinary skill in the art, without having to pay creative labor, can also be according to these
Accompanying drawing obtains other accompanying drawings.
Fig. 1 is a kind of implementation process figure of the deriving method for data list that first embodiment of the invention provides；
Fig. 2 is a kind of specific implementation flow chart of the deriving method for data list that second embodiment of the invention provides；
Fig. 3 is a kind of deriving method S101 for data list that third embodiment of the invention provides specific implementation flow
Figure；
Fig. 4 is a kind of deriving method S104 for data list that fourth embodiment of the invention provides specific implementation flow
Figure；
Fig. 5 is a kind of deriving method S104 for data list that fifth embodiment of the invention provides specific implementation flow
Figure；
Fig. 6 is a kind of structured flowchart of the export terminal for data list that one embodiment of the invention provides；
Fig. 7 is a kind of schematic diagram for terminal device that one embodiment of the invention provides.
Embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
The embodiment of the present invention shows the data query result needed for user by receiving the data inquiry request of user,
Derived data are treated so as to which user can choose from data query result, the export terminal of data list is receiving the number of user
After being instructed according to export, then the data that line number matches with default file maximum number of lines are only extracted every time, and generate data
List, all generations are then obtained into data sublist and return to user terminal as export result, solve existing data
In export technology, all derived data are packaged in a data list and exported, data list can usually occur
Number of data lines accommodates line number beyond maximum, and the situation for causing export to fail, and mortality derived from data is higher, reduces data
Export efficiency the problem of.
In embodiments of the present invention, the executive agent of flow is the terminal device for the derivation program for being provided with data list,
Terminal device includes the intelligent terminals such as mobile phone, computer equipment, tablet personal computer, server, wherein, for the number of user's inquiry data
It can be stored in the memory set in intelligent terminal, be stored in independent storage terminal according to storehouse, in this case, intelligence
Energy terminal obtains the data of correlation by communication network from independent storage terminal, and responds the data service request of user.
Fig. 1 shows the implementation process figure of the deriving method for the data list that first embodiment of the invention provides, and details are as follows：
In S101, according to the data inquiry request of user terminal transmission, display data Query Result.
In the present embodiment, data inquiry request is generated in user terminal of the user by local, then passes through communication network
The terminal device that network provides with the present embodiment is connected, and sends data inquiry request to terminal device.Specifically, user can pass through
The data service query interface of user terminal, input needed for inquiry keyword, it is determined that after the keyword of all inquiries, then point
Hit corresponding acknowledgment of your inquiry button in query interface, selection content and input of the user terminal according to user in the query interface
Content, data inquiry request is generated, and be sent to device corresponding to the signified destination address of the query interface, be i.e. the present embodiment carries
The terminal device of confession, so as to complete the transmission of data inquiry request operation.Preferably, user is except by setting in user terminal
Corresponding to browser opening data service query interface outside Webpage, the related application journey such as APP or client can also be passed through
Sequence, corresponding data service query interface is opened, complete data query operation.
In the present embodiment, terminal device, will be according to the number after the data inquiry request of user terminal transmission is received
It is investigated that asking the keyword that request bag contains, the data with the Keywords matching in database are inquired about, and obtained data work will be matched
For Query Result corresponding to data inquiry request, then Query Result is shown.Specifically, if being not present in database
The data matched with data inquiry request, then display data be not present message to user terminal.Preferably, in this case, eventually
End equipment can send data renewal request to other databases, and whether the data included in current database for confirmation are newest
Data.Because user terminal initiates a certain data inquiry request, representing that the user estimates can match pair from database
Data answered, and database can not match corresponding data, the data in possible data storehouse fail real-time synchronization, therefore
Primary database or other sync databases data renewal request can be sent upwards, so that the data judged in current database are
No is latest data, then searches whether the data matched with data inquiry request be present from newest database.
In the present embodiment, terminal device can show all Query Results in a page, so that user passes through rolling
The page checks all inquiry data.Because a displayable data content in interface is limited, therefore in this case, terminal is set
M most preceding inquiry data result of standby only loading, wherein M values are open ended maximum inquiry data result in a page interface
Number, when user glide check lower section data when, terminal device reloads the inquiry data result of correspondence position, so as to keep away
The stand-by period for exempting to show first is long.In addition, terminal device can also show Query Result by paging mode, will look into
Ask result and be divided into multiple pages, and corresponding numbering is set, user terminal corresponding to transmission by numbering to control display interface
Query Result corresponding to display shows the page.
In S102, receive the data export that the user terminal returns according to the data query result and instruct, and from
Data to be exported corresponding to the data export instruction is determined in the data query result.
In the present embodiment, user terminal, can be in Query Result after the Query Result of terminal device return is got
Choose data derived from needing.Illustratively, user can be by way of choosing, derived data needed for selection, if inquiry knot
Fruit is shown by way of paging, then corresponding data page may be selected to represent to inquiry data all in the data page
Exported.Certainly, user can also be exported to all Query Results, and button or all export button are selected entirely by clicking on
Full selection operation is carried out etc. mode.User terminal then generates corresponding data and led after derived data needed for user are confirmed
Go out instruction, and return to terminal device.
In the present embodiment, terminal device then extracts data after the data export instruction of user terminal return is received
The Data Identification that includes in export instruction, and the derived data according to needed for the Data Identification determines user, and from Query Result
Extracted, obtain data to be exported.
In S103, the number that line number matches with default file maximum number of lines is extracted from the data to be exported successively
According to, and generate at least one data sublist according to the data extracted every time respectively.
In the present embodiment, user terminal is preset with file maximum number of lines, and this document maximum number of lines is specifically used for display one
The maximum line number included in individual data sublist, the number of data lines for avoiding including in factor data sublist is excessive and to send export different
Normal situation occurs.Illustratively, when this document maximum number of lines is 1000, then 1000 can be at most included in each data sublist
Row data.
In the present embodiment, matched with default file maximum number of lines and be specially：Extraction line number is less than or equal to this document
Maximum number of lines.Specifically, after terminal device determines data to be exported according to data export instruction, then according to default file most
Big line number extracts the data of corresponding line number from data to be exported successively, a data sublist is generated, if what is be not extracted by treats
The line number of export data is less than this document maximum number of lines, then the data to be exported being not extracted by is generated into last data son row
Table, and perform S104 operation.
Illustratively, file maximum number of lines is 1000, treats that derived packet contains 3200 row data, therefore, terminal device
1000 row data of extraction generate 3 data sublist every time, and the line number of the remaining data to be exported being not extracted by is 200 rows, number
It is less than file maximum number of lines according to line number, then the remaining data to be exported being not extracted by is generated into last data sublist,
And perform S104 associative operation.Certainly, if data to be exported only includes 200 row data, a data sublist is only generated,
And perform S104 operation.
In the present embodiment, the default file maximum number of lines can be then by terminal device default setting, the default value
The actual open ended maximum line number of data sublist, illustratively, the data list such as Excel forms, then it is maximum
Open ended number of data lines is 65000 rows.User can also adjust this document maximum number of lines according to the reading habit of itself, but
Above-mentioned default value is not to be exceeded in the numerical value for the file maximum number of lines that user is set.
Alternatively, this document maximum number of lines is adjusted according to the columns of data to be exported in the present embodiment, terminal device, specifically
Ground, if the columns of data to be exported is more than standard columns, according to the ratio that standard columns is accounted for beyond part, it is maximum to reduce file
Line number；If the columns of data to be exported is less than standard columns, according to the ratio that standard columns is accounted for beyond part, increase file is most
Big line number.Because export failure is generally related to data volume, if data volume exceeds the maximum open ended data volume of file,
The situation of export failure then occurs.Therefore, it is maximum if the columns of data to be exported is larger, and in the case that data volume is certain
Columns and maximum number of lines then inversely proportional relation, therefore, open ended line number is less；On the contrary, the columns of data to be exported compared with
Hour, then open ended line number will be more.
In S104, the data sublist is sent to the user terminal.
In the present embodiment, terminal device exports instruction according to the data of user and generates at least one data sublist
Afterwards, then all data sublist are sent to user terminal, realize the purpose of the data export page of response user.Specifically,
Terminal device can then be sent to user terminal at once, can also generate all numbers after one data sublist of every generation
After sublist, all data sublist are collected and are uniformly sent to user terminal by terminal device.
In the present embodiment, terminal device is then calculated after all data sublist are generated by default data leakage detection
Method, determine whether comprising the data not being exported in data to be exported, if so, then judging the row of data sublist ultimately produced
Whether number is less than file maximum number of lines, if being less than, will treat that derived data are added in the data sublist ultimately produced；If
It is equal to, then generates an independent data sublist.
Above as can be seen that a kind of deriving method of data list provided in an embodiment of the present invention is by receiving the number of user
According to inquiry request, and the data query result needed for user is shown, wait to export so as to which user can choose from data query result
Data, the export terminal of data list after the data for receiving user export instruction, then every time only extraction line number with it is default
File maximum number of lines matching data, and generate a data sublist, then by it is all generation obtain data sublist make
User terminal is returned to for export result.Compared with existing data export technology, data list provided in an embodiment of the present invention
Deriving method, will not need derived data and be packaged in a data list, but according to default file most
Big line number, all data to be exported are split as multiple data sublist and exported, so as to which each data sublist is actual
Comprising line number will not be over the maximum open ended line number of file, the situation for avoiding factor data amount excessive and causing export to fail
Occur, improve the success rate of data export process.On the other hand, due to the raising of data export success rate, use is decreased
Family repeats the number of export operation, also improves efficiency derived from data list.
Fig. 2 shows a kind of specific implementation flow of the deriving method for data list that second embodiment of the invention provides
Figure.It is shown in Figure 2, relative to embodiment described in Fig. 1, the present embodiment provide a kind of data list deriving method include with
Lower step, details are as follows：
In S201, according to the data inquiry request of user terminal transmission, display data Query Result.
Because S201 is identical with the implementation of S101 in embodiment corresponding to Fig. 1, above-mentioned reality is specifically referred to
The associated description of the S101 in example is applied, will not be repeated here.
In S202, receive the data that the user terminal returns according to the data query result and export instruction.
Because S202 is identical with the implementation of S102 in embodiment corresponding to Fig. 1, above-mentioned reality is specifically referred to
The associated description of the S102 in example is applied, will not be repeated here.
Further, it is described that data to be exported corresponding to the data export instruction is determined from the data query result
Including：
In S203, the communication connection with the user terminal is disconnected, and after communication connection disconnects, looked into from the data
Ask and data to be exported corresponding to the data export instruction is determined in result.
In the present embodiment, terminal device fetches carry out information exchange with user terminal by the communication link established, such as
Terminal device receives the data inquiry request that user terminal is initiated, the Query Result that user terminal receiving terminal apparatus returns etc.,
Therefore, both during data interaction, necessarily take corresponding to port numbers establish communication connection, and pass through the communication link
Tap into row data communication.
In the present embodiment, terminal device will be switched off with being somebody's turn to do after the data export instruction of user terminal transmission is received
Communication connection between user terminal, and corresponding port numbers are adjusted to idle condition from seizure condition, and perform from described
The operation of data to be exported corresponding to the data export instruction is determined in data query result.Due to data export process when
Between it is general longer, and do not have data interaction between terminal device and user terminal during export, be in waiting result
State, therefore, the now releasable related communication resource, to reduce the occupancy to Internet resources.
Alternatively, terminal device, can be whole by the port numbers and other users of release when data are carried out with export operation
End is communicatively coupled, and responds the data service operation of correlation.In this case, in order to improve the utilization rate of terminal device,
Data query operation, data import operation of the initiation of other users terminal etc. can be responded in the related export result of generation
Associative operation.
Alternatively, terminal device can return to a service response and confirm to instruct to user terminal before communication connection is disconnected,
User terminal is after receiving the service response and confirming instruction, then it represents that its corresponding data export instruction responds, and breaks
Open communication connection.In this case, it is to belong to exceptional communication interruption that user terminal, which can determine that terminal device disconnects communication connection,
Or it is that proper communication is interrupted, avoids user from repeating to connect, and initiate multiple data export operation.In this case, user is whole
End can show the dynamic picture of correlation in result waits the page, operate in normal perform, be not to prompt user to export
Delay machine state, avoid user from thinking that operation is stuck.
In S204, the number that line number matches with default file maximum number of lines is extracted from the data to be exported successively
According to, and generate at least one data sublist according to the data extracted every time respectively.
Because S203 is identical with the implementation of S103 in embodiment corresponding to Fig. 1, above-mentioned reality is specifically referred to
The associated description of the S103 in example is applied, will not be repeated here.
Further, it is described the data sublist is sent to the user terminal to include：
In S205, finished if detecting that the data to be exported has extracted, communication link is sent to the user terminal
Request is connect, to establish the communication connection between the user terminal.
In the present embodiment, terminal device has been extracted in all data to be exported of judgement and finished, and last data
After the completion of sublist has generated, then it represents that this time export operation has been completed, and related export knot can be now fed back to user terminal
Fruit.Therefore, by the network address according to user terminal, a communication connection request is sent to user terminal, in order to which user is whole
A communication link is established at end, the export result related to its feedback.
In the present embodiment, user terminal then returns to connection after the communication connection request of terminal device transmission is received
Confirm that instruction is given to terminal device, terminal device then judges communication after the connection for receiving user terminal return confirms instruction
Connection has been established, and can perform S206 associative operation.
In S206, according to multiple data sublist generation export results, the export result is sent to described
User terminal.
In the present embodiment, because terminal device is during data are exported, multiple data sublist may be generated,
In this case, multiple data sublist are packaged in same file, above-mentioned export result is generated.Illustratively, the envelope
Loaded on can be, by the form of compressed package, multiple data sublist to be compressed in a compressed package, group in same file
It is combined into the export result of a compression；Can also be in same Excel file, newly-built quantity identical with data sublist
Sheet, the data of each data sublist are imported into each Sheet, so as to be packaged in a file.Due to each
Equivalent to one single listing file of Sheet, therefore can't occur to lead because line number exceeds and can accommodate maximum number of lines
Situation about making mistake.
In the present embodiment, terminal device is after generation exports result, by the communication channel by being established in S205, to
User terminal sends export result, to complete to export the response of data, services.Alternatively, when user terminal is provided with maximum wait
Between, after user terminal is sending data export instruction, timing will be proceeded by, the stand-by period is more than maximum wait if detecting
Time, then establish and communicate to connect with terminal device, and send export progress and obtain instruction, current export progress for confirmation.
In embodiments of the present invention, by after the data export instruction that user sends is received, then disconnecting between it
Communication connection, release communication resources, export operate after the completion of, just establish connection, and to its return corresponding to export result,
So as to avoid causing Joint failure because long-time connects, export result can not be fed back to user, on the other hand, also released
Internet resources, the process for waiting as long for result is belonged to during export, the situation of data interaction is less, now terminal device
The service request of other users terminal can be responded, therefore the present embodiment can also fully realize that the time-division of terminal device business answers
With, improve terminal device utilization rate and reduce export operating resource occupancy.
Fig. 3 shows a kind of deriving method S101 for data list that third embodiment of the invention provides specific implementation stream
Cheng Tu.It is shown in Figure 3, relative to embodiment described in Fig. 1, a kind of processing method for client feedback information that the present embodiment provides
S101 includes S301~S303, and details are as follows：
Further, the data inquiry request sent according to user terminal, display data Query Result include：
In S301, the data query result matched in database with the data inquiry request, Yi Jisuo are determined
State data amount check corresponding to data query result.
In the present embodiment, terminal device is after the data inquiry request of user is received, then according to data inquiry request
In the searching keyword that includes, determine the data query result matched in database with searching keyword, in this step, terminal
The data that equipment does not obtain to inquiry are extracted, and the data matched with searching keyword are simply marked in database.
In the present embodiment, after the completion of terminal device is searched in whole database, then data query result is obtained, really
Determine all data to be shown matched in database with searching keyword, now, terminal device will wrap in statistical query result
The data amount check contained, specifically, the then line number included in the data list for inquiring about to obtain are how many.
It should be noted that if terminal device and geo-database integration, in same equipment, S301 associative operation exists
Performed in memory module where the database, if terminal device is not the S301 correlation in same equipment with database
Operation performs in the equipment where database；And the associative operation that above-mentioned two situations are extracted without reference to data, because
The required time of the process of this query process and number statistics is shorter, and response efficiency is very fast.
In S302, according to it is default it is maximum show number, the data query result is divided into multiple subnumbers it is investigated that
Result is ask, and each subdata Query Result is respectively associated display numbering.
In the present embodiment, maximum display number is provided with terminal device, that is, is represented once displayable in a page
Data amount check or list line number.Wherein, the maximum shows that number can be set by system default, can also inquired about by user
During adjust at any time.Preferably, the maximum shows that number is related to the resolution ratio of user terminal and the area of display module,
According to the resolution ratio of user terminal and the area of display module, maximum open ended data amount check in same interface is determined, is made
Number is shown for maximum.
In the present embodiment, terminal device will show what is included in number and data query result according to default maximum
Data amount check, multiple subdata Query Results are divided into, wherein, the data amount check that each subdata Query Result includes is up to
Maximum shows number.Data to be exported is divided into the process of multiple data sublist, the number of last time division in similar S103
According to amount for that can be less than maximum display number, and the data amount check for the subquery data result that other divisions obtain then shows with maximum
Show that number is equal.Specific partition process can refer to S103 related elaboration, will not be described here.
In the present embodiment, respectively each subdata Query Result is associated a display numbering by terminal device, i.e., aobvious
Show that numbering and subdata Query Result are one-to-one relations.Specifically, terminal device can be right according to default sortord
Data in data query result are ranked up, and show number according to maximum, and data query result is divided successively, and
It is numbered successively.
In S303, numbered, extracted from the database described aobvious according to the display of the user terminal selecting
Show the subdata Query Result of numbering association and show.
In the present embodiment, the display that terminal device can be sent according to user terminal is numbered, and it is aobvious that this is extracted from database
Show the subdata Query Result of numbering association into local cache, and show the data included in the subdata Query Result.I.e.
In the present embodiment, the data volume that terminal device extracts from database every time shows data volume corresponding to number to be maximum.
Alternatively, in the present embodiment, for terminal device after the completion of division, then most forward son is numbered in acquiescence extraction display
Data query result, and shown.Such as show the subdata Query Result that numbering is 1 association.Because user is clicking on inquiry
After operation, display numbering will not be directly inputted, now terminal device will show that numbering most forward subdata Query Result makees
To give tacit consent to the subdata Query Result shown first.
Alternatively, in the present embodiment, the subdata Query Result that user has shown will be stored in local cache region,
If user detects that the display numbering of user's input is the display numbering shown, directly corresponding from local cache extracted region
Subdata Query Result shown, without being extracted again from database.
In embodiments of the present invention, the data volume that terminal device extracts every time shows data volume corresponding to number to be maximum,
Because terminal device and the non-disposable data obtained to all inquiries extract, therefore the time waited is less, response speed
Rate is very fast, so as to avoid causing the situation of service response time-out to occur because the extraction operating time is long.
Fig. 4 shows a kind of deriving method S103 for data list that fourth embodiment of the invention provides specific implementation stream
Cheng Tu.It is shown in Figure 4, relative to embodiment described in Fig. 1 to Fig. 3, a kind of export side for data list that the present embodiment provides
It is described described in method to extract the data that line number matches with default file maximum number of lines from the data to be exported successively, and divide
At least one data sublist not being generated according to the data extracted every time and also including S401~S403, details are as follows：
In S401, the export control instruction that the user terminal is initiated is received.
In the present embodiment, the export of user terminal is shown in the page sets corresponding export control to press by AJAX technologies
Button.User can click on corresponding export control button during export on the user terminal of local, and then user terminal connects
, will be by the corresponding export control instruction of AJAX technologies generation in the page after the clicking operation for receiving correlation, and the export is controlled
Instruction processed is sent to terminal device.
In the present embodiment, export control instruction includes but is not limited to：Pause export instruction, terminate export instruction, recover
Export instruction, again export instruction etc..
In S402, the export control instruction is added to extraction operation control data stream；Wherein, the extraction operation control
Data flow processed is：Between the export terminal of data list and the database carry out extraction operation when caused control number
According to.
In the present embodiment, terminal device will produce two between the two with database during export operation is carried out
Circuit-switched data stream, it is respectively：The number of the extraction result data stream of terminal device, i.e. extraction generation data sublist is pointed to by database
According to caused data flow；And having terminal device, i.e., the export terminal of above-mentioned data list points to the extraction operation control of database
Data flow processed, related extraction operation is carried out for controlling database, such as sends file maximum number of lines, this extraction to database
The control data such as the Serial Number Range of data to be exported and above-mentioned export control instruction in operation.
In the present embodiment, terminal device controls the export after the export control instruction of user terminal transmission is received
Instruction processed is added in the extraction operation control data stream, is led accordingly so that the control data is streamed to realization in database
Go out control operation.
In S403, if the extraction operation control data stream includes export control instruction, the export control is performed
Export control operation corresponding to instruction.
In the present embodiment, database detection corresponding to terminal device includes export into the extraction operation control data stream
Control instruction, then perform the export control operation of response.Specifically, if the export control instruction is pause export instruction, stop
Only data extraction operation, user is waited to be again started up the export flow；If the export control instruction is tied to stop export instruction
Shu Benci export response operations, and delete the data sublist generated；If exporting control instruction to recover export instruction,
Continue executing with the data extraction operation corresponding to the pause moment, the data sublist corresponding to the generation pause moment.
In embodiments of the present invention, user terminal can control the export of terminal device to operate at any time, and improve user can
Opereating specification and user experience.
Fig. 5 shows a kind of deriving method S103 for data list that fifth embodiment of the invention provides specific implementation stream
Cheng Tu.It is shown in Figure 5, relative to embodiment described in Fig. 1, in a kind of deriving method for data list that the present embodiment provides
S103 also includes S501 and S502, and details are as follows：
In S501, after the one data sublist of every generation, the numerical value of export response timer is reset.
In the present embodiment, terminal device is respectively provided with corresponding maximum operation duration, come in each associative operation is performed
Automatically abnormal operation is repaired.Therefore, whether terminal device is abnormal in order to judge export operation, during by setting peak response
It is long.
In the present embodiment, terminal device then resets export response timer after one data sublist of every generation
Numerical value, to avoid the data volume because derived from excessive, and cause the response time long, be judged as exporting abnormal operation.The opposing party
Face, the export response timer are additionally operable to keep the session between terminal device and database effective, during export, needed
Want terminal device to keep data interaction state for a long time with database, therefore a session effective time can be set up between the two,
That is session values, terminal device when resetting the numerical value of the response timer, also can the synchronized update session values, to maintain
Session between terminal device and database is effective.
In S502, if the numerical value of the export response timer is more than default peak response duration, export is performed
Abnormal operation.
In the present embodiment, terminal device detect export response timer numerical value be more than peak response duration when,
It is abnormal then to judge that current export operation is present, therefore abnormal operation is exported by performing.Specifically, the export abnormal operation can be with
For：The data disconnected between database connect, and restart database；Connection is re-established again after database start completion,
To perform export operation again.
In embodiments of the present invention, after by generating a data sublist every time, the number of export response timer is reset
Value, to keep the session between terminal device and database effective, and avoid factor data amount excessive and cause the feelings of export time-out
Condition occurs.
It should be understood that the size of the sequence number of each step is not meant to the priority of execution sequence, each process in above-described embodiment
Execution sequence should determine that the implementation process without tackling the embodiment of the present invention forms any limit with its function and internal logic
It is fixed.
Fig. 6 shows a kind of structured flowchart of the export terminal for data list that one embodiment of the invention provides, the data
The each unit that the export terminal of list includes is used to perform each step in embodiment corresponding to Fig. 1.Referring specifically to Fig. 1 and figure
The associated description in embodiment corresponding to 1.For convenience of description, it illustrate only part related to the present embodiment.
Referring to Fig. 6, the export terminal of the data list includes：
Data query result display unit 61, for the data inquiry request sent according to user terminal, display data is looked into
Ask result；
Data to be exported determining unit 62, the number returned for receiving the user terminal according to the data query result
Instructed according to export, and data to be exported corresponding to the data export instruction is determined from the data query result；
Data sublist generation unit 63, for extracting line number and default file most from the data to be exported successively
The data of big line number matching, and generate at least one data sublist according to the data extracted every time respectively；
Data sublist transmitting element 64, for the data sublist to be sent into the user terminal.
Alternatively, the data to be exported determining unit 62 includes：
Broken communication connection unit, for disconnecting the communication connection with the user terminal, and after communication connection disconnects,
Data to be exported corresponding to the data export instruction is determined from the data query result；
The data sublist transmitting element 64 includes：
Reconnection unit is communicated to connect, it is whole to the user if being finished for detecting that the data to be exported has extracted
End sends communication connection request, to establish the communication connection between the user terminal；
Result transmitting element is exported, for according to multiple data sublist generation export results, the export to be tied
Fruit is sent to the user terminal.
Alternatively, the data query result display unit 61 includes：
Data query result determining unit, for the data for determining to match with the data inquiry request in database
Query Result, and data amount check corresponding to the data query result；
Data query result division unit, for according to default maximum display number, the data query result to be drawn
It is divided into multiple subdata Query Results, and each subdata Query Result is respectively associated display numbering；
Subdata Query Result display unit, for being numbered according to the display of the user terminal selecting, from described
The subdata Query Result of the display numbering association is extracted in database and is shown.
Alternatively, the data sublist generation unit 63 includes：
Control instruction receiving unit is exported, the export control instruction initiated for receiving the user terminal；
Control instruction adding device is exported, for adding the export control instruction to extraction operation control data stream；Its
In, the extraction operation control data stream is：Extraction operation is being carried out between the export terminal of data list and the database
When caused control data；
Control instruction response unit is exported, if including export control instruction for the extraction operation control data stream,
Perform export control operation corresponding to the export control instruction.
Alternatively, the data sublist generation unit 63 includes：
Response timer reset cell, for after the one data sublist of every generation, resetting export response timer
Numerical value；
Exception processing unit, if the numerical value for the export response timer is more than default peak response duration,
Perform export abnormal operation.
Therefore, the export terminal of data category provided in an embodiment of the present invention again may be by receive user data look into
Request is ask, and shows the data query result needed for user, derived number is treated so as to which user can choose from data query result
According to the export terminal of data list then only extracts line number and default text every time after the data for receiving user export instruction
The data of part maximum number of lines matching, and a data sublist is generated, all generations are then obtained into data sublist as leading
Go out result and return to user terminal.Compared with existing data export technology, data list provided in an embodiment of the present invention is led
Go out method, will not need derived data and be packaged in a data list, but according to default file maximum row
Number, is split as multiple data sublist by all data to be exported and is exported, and is included so as to which each data sublist is actual
Line number will not be over the maximum open ended line number of file, the situation hair for avoiding factor data amount excessive and causing export to fail
It is raw, improve the success rate of data export process.On the other hand, due to the raising of data export success rate, user is decreased
The number of export operation is repeated, also improves efficiency derived from data list.
Fig. 7 is a kind of schematic diagram for terminal device that another embodiment of the present invention provides.As shown in fig. 7, the embodiment
Terminal device 7 includes：Processor 70, memory 71 and it is stored in the memory 71 and can be transported on the processor 70
Capable computer program 72, such as the derivation program of data list.The processor 70 performs real during the computer program 72
Step in the deriving method embodiment of existing above-mentioned each data list, such as the S101 to S104 shown in Fig. 1.It is or described
Processor 70 realizes the function of each unit in above-mentioned each device embodiment when performing the computer program 72, such as shown in Fig. 6
The function of module 61 to 64.
Exemplary, the computer program 72 can be divided into one or more units, one or more of
Unit is stored in the memory 71, and is performed by the processor 70, to complete the present invention.One or more of lists
Member can complete the series of computation machine programmed instruction section of specific function, and the instruction segment is used to describe the computer journey
Implementation procedure of the sequence 72 in the terminal device 7.For example, the computer program 72 can be divided into data query result
Display unit, data to be exported determining unit, data sublist generation unit and data sublist transmitting element, each unit tool
Body function is as follows：
Data query result display unit, for the data inquiry request sent according to user terminal, display data inquiry
As a result；
Data to be exported determining unit, the data returned for receiving the user terminal according to the data query result
Export instruction, and data to be exported corresponding to the data export instruction is determined from the data query result；
Data sublist generation unit, it is maximum with default file for extracting line number from the data to be exported successively
The data of line number matching, and generate at least one data sublist according to the data extracted every time respectively；
Data sublist transmitting element, for the data sublist to be sent into the user terminal.
The terminal device 7 can be that the calculating such as desktop PC, notebook, palm PC and cloud server are set
It is standby.The terminal device may include, but be not limited only to, processor 70, memory 71.It will be understood by those skilled in the art that Fig. 7
The only example of terminal device 7, the restriction to terminal device 7 is not formed, can included than illustrating more or less portions
Part, some parts or different parts are either combined, such as the terminal device can also include input-output equipment, net
Network access device, bus etc..
Alleged processor 70 can be CPU (Central Processing Unit, CPU), can also be
Other general processors, digital signal processor (Digital Signal Processor, DSP), application specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other PLDs, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor can also be any conventional processor
Deng.
The memory 71 can be the internal storage unit of the terminal device 7, such as the hard disk of terminal device 7 or interior
Deposit.The memory 71 can also be the External memory equipment of the terminal device 7, such as be equipped with the terminal device 7
Plug-in type hard disk, intelligent memory card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card, dodge
Deposit card (Flash Card) etc..Further, the memory 71 can also both include the storage inside list of the terminal device 7
Member also includes External memory equipment.The memory 71 is used to store needed for the computer program and the terminal device
Other programs and data.The memory 71 can be also used for temporarily storing the data that has exported or will export.
It is apparent to those skilled in the art that for convenience of description and succinctly, only with above-mentioned each work(
Can unit, module division progress for example, in practical application, can be as needed and by above-mentioned function distribution by different
Functional unit, module are completed, i.e., the internal structure of described device are divided into different functional units or module, more than completion
The all or part of function of description.Each functional unit, module in embodiment can be integrated in a processing unit, also may be used
To be that unit is individually physically present, can also two or more units it is integrated in a unit, it is above-mentioned integrated
Unit can both be realized in the form of hardware, can also be realized in the form of SFU software functional unit.In addition, each function list
Member, the specific name of module are not limited to the protection domain of the application also only to facilitate mutually distinguish.Said system
The specific work process of middle unit, module, the corresponding process in preceding method embodiment is may be referred to, will not be repeated here.
In the above-described embodiments, the description to each embodiment all emphasizes particularly on different fields, and is not described in detail or remembers in some embodiment
The part of load, it may refer to the associated description of other embodiments.
Those of ordinary skill in the art are it is to be appreciated that the list of each example described with reference to the embodiments described herein
Member and algorithm steps, it can be realized with the combination of electronic hardware or computer software and electronic hardware.These functions are actually
Performed with hardware or software mode, application-specific and design constraint depending on technical scheme.Professional and technical personnel
Described function can be realized using distinct methods to each specific application, but this realization is it is not considered that exceed
The scope of the present invention.
In embodiment provided by the present invention, it should be understood that disclosed device/terminal device and method, can be with
Realize by another way.For example, device described above/terminal device embodiment is only schematical, for example, institute
The division of module or unit is stated, only a kind of division of logic function, there can be other dividing mode when actually realizing, such as
Multiple units or component can combine or be desirably integrated into another system, or some features can be ignored, or not perform.Separately
A bit, shown or discussed mutual coupling or direct-coupling or communication connection can be by some interfaces, device
Or INDIRECT COUPLING or the communication connection of unit, can be electrical, mechanical or other forms.
The unit illustrated as separating component can be or may not be physically separate, show as unit
The part shown can be or may not be physical location, you can with positioned at a place, or can also be distributed to multiple
On NE.Some or all of unit therein can be selected to realize the mesh of this embodiment scheme according to the actual needs
's.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, can also
That unit is individually physically present, can also two or more units it is integrated in a unit.Above-mentioned integrated list
Member can both be realized in the form of hardware, can also be realized in the form of SFU software functional unit.
If the integrated module/unit realized in the form of SFU software functional unit and as independent production marketing or
In use, it can be stored in a computer read/write memory medium.Based on such understanding, the present invention realizes above-mentioned implementation
All or part of flow in example method, by computer program the hardware of correlation can also be instructed to complete, described meter
Calculation machine program can be stored in a computer-readable recording medium, and the computer program can be achieved when being executed by processor
The step of stating each embodiment of the method..Wherein, the computer program includes computer program code, the computer program
Code can be source code form, object identification code form, executable file or some intermediate forms etc..Computer-readable Jie
Matter can include：Can carry any entity or device of the computer program code, recording medium, USB flash disk, mobile hard disk,
Magnetic disc, CD, computer storage, read-only storage (ROM, Read-Only Memory), random access memory (RAM,
Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium etc..It is it should be noted that described
The content that computer-readable medium includes can carry out appropriate increasing according to legislation in jurisdiction and the requirement of patent practice
Subtract, such as in some jurisdictions, electric carrier signal and electricity are not included according to legislation and patent practice, computer-readable medium
Believe signal.
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations；Although with reference to foregoing reality
Example is applied the present invention is described in detail, it will be understood by those within the art that：It still can be to foregoing each
Technical scheme described in embodiment is modified, or carries out equivalent substitution to which part technical characteristic；And these are changed
Or replace, the essence of appropriate technical solution is departed from the spirit and scope of various embodiments of the present invention technical scheme, all should
Within protection scope of the present invention.
Claims (10)
- A kind of 1. deriving method of data list, it is characterised in that including：The data inquiry request sent according to user terminal, display data Query Result；Receive the data that the user terminal is returned according to the data query result and export instruction, and from the data query knot Data to be exported corresponding to the data export instruction is determined in fruit；The data that line number matches with default file maximum number of lines are extracted from the data to be exported successively, and respectively according to every The data of secondary extraction generate at least one data sublist；The data sublist is sent to the user terminal.
- 2. deriving method according to claim 1, it is characterised in that it is described from the data query result determine described in Data to be exported corresponding to data export instruction includes：The communication connection with the user terminal is disconnected, and after communication connection disconnects, is determined from the data query result Data to be exported corresponding to the data export instruction；It is described the data sublist is sent to the user terminal to include：If detecting that the data to be exported has extracted to finish, communication connection request is sent to the user terminal, to establish With the communication connection between the user terminal；According to multiple data sublist generation export results, the export result is sent to the user terminal.
- 3. deriving method according to claim 1, it is characterised in that the data query sent according to user terminal please Ask, display data Query Result includes：Determine the data query result matched in database with the data inquiry request, and the data query result Corresponding data amount check；According to default maximum display number, the data query result is divided into multiple subdata Query Results, and to every Display numbering is respectively associated in the individual subdata Query Result；Numbered according to the display of the user terminal selecting, the institute of the display numbering association is extracted from the database State subdata Query Result and show.
- 4. according to the deriving method described in claim any one of 1-3, it is characterised in that described successively from the data to be exported The data that middle extraction line number matches with default file maximum number of lines, and generated at least according to the data extracted every time respectively One data sublist includes：Receive the export control instruction that the user terminal is initiated；The export control instruction is added to extraction operation control data stream；Wherein, the extraction operation control data stream is：Number According between the export terminal of list and the database carry out extraction operation when caused control data；If the extraction operation control data stream includes export control instruction, perform and exported corresponding to the export control instruction Control operation.
- 5. deriving method according to claim 1, it is characterised in that it is described successively from the data to be exported extraction with The data of default file maximum number of lines matching, and included according to the data generation data sublist extracted every time：After the one data sublist of every generation, the numerical value of export response timer is reset；The deriving method also includes：If the numerical value of the export response timer is more than default peak response duration, export abnormal operation is performed.
- 6. a kind of terminal device, it is characterised in that the terminal device includes memory, processor and is stored in the storage Realized in device and the computer program that can run on the processor, described in the computing device during computer program as follows Step：The data inquiry request sent according to user terminal, display data Query Result；Receive the data that the user terminal is returned according to the data query result and export instruction, and from the data query knot Data to be exported corresponding to the data export instruction is determined in fruit；The data that line number matches with default file maximum number of lines are extracted from the data to be exported successively, and respectively according to every The data of secondary extraction generate at least one data sublist；The data sublist is sent to the user terminal.
- 7. terminal device according to claim 6, it is characterised in that it is described from the data query result determine described in Data to be exported corresponding to data export instruction includes：The communication connection with the user terminal is disconnected, and after communication connection disconnects, is determined from the data query result Data to be exported corresponding to the data export instruction；It is described the data sublist is sent to the user terminal to include：If detecting that the data to be exported has extracted to finish, communication connection request is sent to the user terminal, to establish With the communication connection between the user terminal；According to multiple data sublist generation export results, the export result is sent to the user terminal.
- 8. terminal device according to claim 6, it is characterised in that the data query sent according to user terminal please Ask, display data Query Result includes：Determine the data query result matched in database with the data inquiry request, and the data query result Corresponding data amount check；According to default maximum display number, the data query result is divided into multiple subdata Query Results, and to every Display numbering is respectively associated in the individual subdata Query Result；Numbered according to the display of the user terminal selecting, the institute of the display numbering association is extracted from the database State subdata Query Result and show.
- 9. according to the terminal device described in claim any one of 6-8, it is characterised in that described successively from the data to be exported The data that middle extraction line number matches with default file maximum number of lines, and generated at least according to the data extracted every time respectively One data sublist includes：Receive the export control instruction that the user terminal is initiated；The export control instruction is added to extraction operation control data stream；Wherein, the extraction operation control data stream is：Number According between the export terminal of list and the database carry out extraction operation when caused control data；If the extraction operation control data stream includes export control instruction, perform and exported corresponding to the export control instruction Control operation.
- 10. a kind of computer-readable recording medium, the computer-readable recording medium storage has computer program, and its feature exists In when the computer program is executed by processor the step of realization such as any one of claim 1 to 5 methods described.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710919421.8A CN107784085B (en) | 2017-09-30 | 2017-09-30 | Data list exporting method and terminal thereof |
| PCT/CN2018/077662 WO2019062019A1 (en) | 2017-09-30 | 2018-02-28 | Data list exporting method and terminal using same |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710919421.8A CN107784085B (en) | 2017-09-30 | 2017-09-30 | Data list exporting method and terminal thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107784085A true CN107784085A (en) | 2018-03-09 |
| CN107784085B CN107784085B (en) | 2021-04-13 |
Family
ID=61434159
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710919421.8A Active CN107784085B (en) | 2017-09-30 | 2017-09-30 | Data list exporting method and terminal thereof |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN107784085B (en) |
| WO (1) | WO2019062019A1 (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110309217A (en) * | 2019-05-30 | 2019-10-08 | 平安科技（深圳）有限公司 | Lead-in and lead-out method, device, terminal and the computer readable storage medium of data |
| CN110807058A (en) * | 2018-08-01 | 2020-02-18 | 北京京东尚科信息技术有限公司 | Method and system for exporting data |
| CN112383313A (en) * | 2020-10-10 | 2021-02-19 | 中科驭数（北京）科技有限公司 | Parallel data decoding device and method |
| CN112650805A (en) * | 2020-12-30 | 2021-04-13 | 杭州贝嘟科技有限公司 | Data export method and device, computer equipment and readable storage medium |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101231665A (en) * | 2008-02-20 | 2008-07-30 | 中兴通讯股份有限公司 | Apparatus and method for educing data into Excel files from database |
| CN101426019A (en) * | 2007-10-30 | 2009-05-06 | 广州商机网络科技有限公司 | Data file transmission method for mobile phone system |
| CN101710402A (en) * | 2009-12-14 | 2010-05-19 | 白雪松 | Management information system for college staff and implementation thereof |
| CN102387120A (en) * | 2010-08-31 | 2012-03-21 | 北大方正集团有限公司 | File transmission method, server, client and network transmission system |
| CN103034735A (en) * | 2012-12-26 | 2013-04-10 | 北京讯鸟软件有限公司 | Big data distributed file export method |
| CN103473234A (en) * | 2012-06-07 | 2013-12-25 | 中兴通讯股份有限公司 | Method, device and system for deriving report forms from web inquiring system |
| US20150012506A1 (en) * | 2013-07-03 | 2015-01-08 | International Business Machines Corporation | Effective method to compress tabular data export files for data movement |
| CN106776829A (en) * | 2016-11-28 | 2017-05-31 | 成都广达新网科技股份有限公司 | A kind of data guiding system and its method of work |
| CN106776843A (en) * | 2016-11-28 | 2017-05-31 | 浪潮软件集团有限公司 | Method for importing excel file based on xml analysis |
| CN106897431A (en) * | 2017-02-27 | 2017-06-27 | 郑州云海信息技术有限公司 | A kind of daily record deriving method and system |
| CN107153717A (en) * | 2017-06-14 | 2017-09-12 | 成都三零凯天通信实业有限公司 | Million grades of method and system that recorded form are exported from database by browser |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100407203C (en) * | 2005-12-30 | 2008-07-30 | 华为技术有限公司 | Method for processing mass data |
| CN101826085B (en) * | 2009-12-30 | 2012-01-18 | 厦门市美亚柏科信息股份有限公司 | AJAX-based method for importing/exporting large file into/from web page on line |
| CN102521296A (en) * | 2011-11-30 | 2012-06-27 | 向进轮 | Method for screening data items in separated pages of web page |
| CN103390007A (en) * | 2012-05-11 | 2013-11-13 | 阿里巴巴集团控股有限公司 | Method and device for data acquisition |
-
2017
- 2017-09-30 CN CN201710919421.8A patent/CN107784085B/en active Active
-
2018
- 2018-02-28 WO PCT/CN2018/077662 patent/WO2019062019A1/en active Application Filing
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101426019A (en) * | 2007-10-30 | 2009-05-06 | 广州商机网络科技有限公司 | Data file transmission method for mobile phone system |
| CN101231665A (en) * | 2008-02-20 | 2008-07-30 | 中兴通讯股份有限公司 | Apparatus and method for educing data into Excel files from database |
| CN101710402A (en) * | 2009-12-14 | 2010-05-19 | 白雪松 | Management information system for college staff and implementation thereof |
| CN102387120A (en) * | 2010-08-31 | 2012-03-21 | 北大方正集团有限公司 | File transmission method, server, client and network transmission system |
| CN103473234A (en) * | 2012-06-07 | 2013-12-25 | 中兴通讯股份有限公司 | Method, device and system for deriving report forms from web inquiring system |
| CN103034735A (en) * | 2012-12-26 | 2013-04-10 | 北京讯鸟软件有限公司 | Big data distributed file export method |
| US20150012506A1 (en) * | 2013-07-03 | 2015-01-08 | International Business Machines Corporation | Effective method to compress tabular data export files for data movement |
| CN106776829A (en) * | 2016-11-28 | 2017-05-31 | 成都广达新网科技股份有限公司 | A kind of data guiding system and its method of work |
| CN106776843A (en) * | 2016-11-28 | 2017-05-31 | 浪潮软件集团有限公司 | Method for importing excel file based on xml analysis |
| CN106897431A (en) * | 2017-02-27 | 2017-06-27 | 郑州云海信息技术有限公司 | A kind of daily record deriving method and system |
| CN107153717A (en) * | 2017-06-14 | 2017-09-12 | 成都三零凯天通信实业有限公司 | Million grades of method and system that recorded form are exported from database by browser |
Non-Patent Citations (3)
| Title |
|---|
| 吴志强 等: ""基于VBA和PI-Datalink批量数据导出的设计和实现"", 《企业技术开发》 * |
| 曹志广: "《金融计算与编程-基于MATLAB的应用》", 31 May 2013, 《上海财经大学出版社》 * |
| 韩小良 等: "《Excel VBA工资管理应用案列详解》", 31 December 2006, 《中国铁道出版社》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110807058A (en) * | 2018-08-01 | 2020-02-18 | 北京京东尚科信息技术有限公司 | Method and system for exporting data |
| CN110807058B (en) * | 2018-08-01 | 2024-04-12 | 北京京东尚科信息技术有限公司 | Method and system for exporting data |
| CN110309217A (en) * | 2019-05-30 | 2019-10-08 | 平安科技（深圳）有限公司 | Lead-in and lead-out method, device, terminal and the computer readable storage medium of data |
| CN110309217B (en) * | 2019-05-30 | 2024-03-08 | 平安科技（深圳）有限公司 | Data import and export method and device, terminal and computer readable storage medium |
| CN112383313A (en) * | 2020-10-10 | 2021-02-19 | 中科驭数（北京）科技有限公司 | Parallel data decoding device and method |
| CN112383313B (en) * | 2020-10-10 | 2023-08-04 | 中科驭数（北京）科技有限公司 | Parallel data decoding device and method |
| CN112650805A (en) * | 2020-12-30 | 2021-04-13 | 杭州贝嘟科技有限公司 | Data export method and device, computer equipment and readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2019062019A1 (en) | 2019-04-04 |
| CN107784085B (en) | 2021-04-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107102941B (en) | Test case generation method and device | |
| CN107784085A (en) | The deriving method and its terminal of a kind of data list | |
| CN110417879A (en) | A kind of message treatment method, device, equipment and storage medium | |
| CN108540568B (en) | Computing capacity sharing method and intelligent equipment | |
| CN107770269A (en) | A kind of service response method and its terminal | |
| CN108737570A (en) | A kind of information-pushing method, apparatus and system | |
| CN106993048A (en) | Determine method and device, information recommendation method and the device of recommendation information | |
| CN110245116A (en) | Reconciliation data processing method, device, equipment and computer readable storage medium | |
| CN108737292A (en) | A kind of sending method and system, server of bulk messages | |
| CN109117039A (en) | Display method and terminal equipment | |
| CN107894945A (en) | Bury an adding method, mobile terminal and computer-readable recording medium | |
| CN107807935B (en) | Using recommended method and device | |
| CN111898057A (en) | Resource distribution method and device | |
| CN107018503A (en) | A kind of note transmission method and system | |
| CN107370628A (en) | Based on the log processing method and system buried a little | |
| CN104618364A (en) | Information processing method, electronic device and server | |
| CN106257449B (en) | A kind of information determines method and apparatus | |
| CN106293851A (en) | A kind of firmware upgrade method and equipment | |
| CN112260933A (en) | Communication method, communication device, electronic equipment and medium | |
| CN107423446A (en) | New media based on cloud storage automates credible deployment system and method | |
| CN110333815A (en) | Touch event treating method and apparatus | |
| CN115834189A (en) | Privacy intersection method and device for low-bandwidth environment and related products | |
| CN109544206A (en) | Business opportunity processing method, device, computer equipment and storage medium | |
| CN110266814B (en) | Transmission method and transmission device | |
| CN105763511B (en) | A kind of method for processing business and communication system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |