CN108874894A - Crosstab deriving method, device, computer equipment and storage medium - Google Patents
Crosstab deriving method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN108874894A CN108874894A CN201810489984.2A CN201810489984A CN108874894A CN 108874894 A CN108874894 A CN 108874894A CN 201810489984 A CN201810489984 A CN 201810489984A CN 108874894 A CN108874894 A CN 108874894A
- Authority
- CN
- China
- Prior art keywords
- crosstab
- worksheet
- export
- duration
- caching
- 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.)
- Withdrawn
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
Abstract
This application involves a kind of crosstab deriving method, device, computer equipment and storage mediums.The method includes：It receives the crosstab that first terminal is sent and exports request, crosstab export request carries book mark.Search the first worksheet corresponding with book mark；By the first worksheet with derived caching crosstab matches in buffer queue；It is extracted from buffer queue and caches crosstab with the first of the first worksheet successful match, and find out the second worksheet of failed matching caching crosstab from the first worksheet；Estimated export duration is calculated according to the second worksheet；Obtain the duration to be processed of lineation journey everywhere, go out the distribution task duration of the lineation journey everywhere according to the estimated export duration and the duration calculation to be processed, it is distributed in the journey of lineation everywhere and matched second worksheet of corresponding distribution task duration, the acquisition export crosstab corresponding with the second worksheet that lineation journey generates everywhere；It is generated according to the first caching crosstab and export crosstab and intersects list file, and be back to first terminal for list file is intersected.
Description
Technical field
This application involves field of computer technology, more particularly to a kind of crosstab deriving method, device, computer equipment
And storage medium.
Background technique
Existing data management platform carries out storage and management to the magnanimity Job Data Sheet of multiple users, and user can be
The operations such as data management platform carries out data edition, data upload.Also, user often has to export Job Data Sheet and strike a bargain
The demand pitching table and downloading.
But the quantity of the Job Data Sheet stored in current management platform is larger, when platform while receiving multiple
Crosstab export request, and it is frequently encountered mass data block system to exporting when request focuses on, cause to handle
Efficiency is very low, and the case where be likely to result in system failure.
Summary of the invention
Based on this, it is necessary in view of the above technical problems, provide a kind of crosstab export side that can be improved export efficiency
Method, device, computer equipment and storage medium.
A kind of crosstab deriving method, the method includes：
It receives the crosstab that first terminal is sent and exports request, the crosstab export request carries book mark；
Search the first worksheet corresponding with book mark；
By first worksheet with derived caching crosstab matches in buffer queue；
It is extracted from the buffer queue and caches crosstab with the first of the first worksheet successful match, and from institute
State the second worksheet for finding out in the first worksheet and matching the caching crosstab not successfully；
Estimated export duration is calculated according to second worksheet；
The duration to be processed for obtaining lineation journey everywhere goes out according to the estimated export duration and the duration calculation to be processed
The distribution task duration of the journey of lineation everywhere is distributed matched with corresponding distribution task duration in the journey of lineation everywhere
Second worksheet obtains the export crosstab corresponding with second worksheet that the lineation journey everywhere generates；
It is generated according to the first caching crosstab and the export crosstab and intersects list file, and the crosstab is literary
Part is back to the first terminal.
In one of the embodiments, after the crosstab export request for receiving first terminal transmission, including：
Login account is obtained from crosstab export request；
The corresponding export permission of the login account is searched, when the export permission is lower than default access rank, is searched
The corresponding administrator's account of the login account；
It is identified according to the book and generates crosstab export approval request, crosstab export approval request is sent
Give administrator's account corresponding second terminal；
It is described to search corresponding with book mark the first worksheet, including：
When the examination & approval for receiving the second terminal return pass through notice, then search corresponding with book mark
First worksheet.
The acquisition export corresponding with second worksheet that lineation journey generates everywhere in one of the embodiments,
After crosstab, including：
It counts and respectively caches the corresponding Band 1 of crosstab and extraction frequency in the buffer queue；
Each caching crosstab is ranked up according to the Band 1 and the extraction frequency；
Search corresponding second group of the export crosstab；
The export is intersected in the buffer queue after list insertion sort according to second group.
Further include in one of the embodiments,：
Calculate the data capacity of the crosstab file；
When the data capacity is greater than preset capacity threshold value, login account is read from crosstab export request；
Compression processing is carried out to the crosstab file according to the login account and obtains crosstab compressed package, according to institute
It states crosstab compressed package and generates crosstab acquisition link, the crosstab is linked and is returned；
When the data capacity is less than or equal to preset capacity threshold value, then continues to execute and be back to the intersection list file
The step of first terminal.
Described find out from first worksheet matches the caching intersection not successfully in one of the embodiments,
After second worksheet of table, further include：
Data format verification is carried out to the data in second worksheet, according to the judgement of data format check results
Whether the second worksheet meets crosstab export condition；
When second worksheet be unsatisfactory for crosstab export condition when, according to be unsatisfactory for crosstab export condition second
The worksheet mark of worksheet generates format check failure notification, and the format check failure notification is returned to described first
Terminal.
It is described in one of the embodiments, that estimated export duration is calculated according to second worksheet, including：
Count the worksheet quantity of second worksheet；
Data format mark is read from crosstab export request；
When the data format, which is identified as format, retains mark, obtains the format and retain corresponding first export of mark
Time quantum calculates estimated export duration according to the worksheet quantity and the first export time quantum；
When the data format, which is identified as format, excludes mark, obtains the format and exclude corresponding second export of mark
Time quantum calculates estimated export duration according to the worksheet quantity and the second export time quantum.
It is described in one of the embodiments, to expect export duration and the duration to be processed by described second according to described
Before worksheet is distributed into the journey of lineation everywhere, including：
From the crosstab export request in obtain first task timestamp, by second worksheet with it is described first
Business timestamp is associated record；
It is described to be distributed second worksheet to described each according to the estimated export duration and the duration to be processed
After handling in thread, including：
Acquisition is assigned the corresponding second task time stamp of each worksheet in the processing thread of second worksheet；
Each worksheet is ranked up according to second task time stamp in the processing thread.
A kind of crosstab guiding device, described device include：
Request receiving module is exported, for receiving the crosstab export request of first terminal transmission, the crosstab export
Request carries book mark；
First searching module, for searching the first worksheet corresponding with book mark；
Matching module, for by first worksheet with derived caching crosstab matches in buffer queue；
Second searching module, for extracting first with the first worksheet successful match from the buffer queue
Crosstab is cached, and finds out the second worksheet for matching the caching crosstab not successfully from first worksheet；
Duration estimates module, for calculating estimated export duration according to second worksheet；
Thread distribution module, for obtaining the duration to be processed of lineation journey everywhere, according to the estimated export duration and institute
State the distribution task duration that duration calculation to be processed goes out the lineation journey everywhere, in the journey of lineation everywhere distribution with it is corresponding
Matched second worksheet of distribution task duration obtains the leading corresponding with second worksheet of the generation of lineation journey everywhere
Crosstab out；
File generating module, for generating crosstab text according to the first caching crosstab and the export crosstab
Part, and the intersection list file is back to the first terminal.
A kind of computer equipment, including memory and processor, the memory are stored with computer program, the processing
The step of device realizes the above method when executing the computer program.
A kind of computer readable storage medium, is stored thereon with computer program, and the computer program is held by processor
The step of above method is realized when row.
Above-mentioned crosstab deriving method, device, computer equipment and storage medium, when receiving crosstab export request,
First search whether to exist from buffer queue with to derived worksheet match it is derived cache crosstab, and can will
The caching crosstab to match directly extracts, so that the workload of export processing is reduced, according to unmatched work meter
Calculate estimated export handling duration, export on the estimation duration and everywhere in lineation journey task duration to be processed, will not
The worksheet reasonable distribution matched to multiple processing threads carry out processing and generate crosstab, and intersection can be improved in multithreading collaboration processing
Table exports the treatment effeciency of work, and can effectively reduce data jamming.
Detailed description of the invention
Fig. 1 is the application scenario diagram of crosstab deriving method in one embodiment；
Fig. 2 is the flow diagram of crosstab deriving method in one embodiment；
Fig. 3 is the flow diagram of crosstab deriving method in another embodiment；
Fig. 4 is the structural block diagram of crosstab guiding device in one embodiment；
Fig. 5 is the internal structure chart of computer equipment in one embodiment.
Specific embodiment
It is with reference to the accompanying drawings and embodiments, right in order to which the objects, technical solutions and advantages of the application are more clearly understood
The application is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the application, not
For limiting the application.
Crosstab deriving method provided by the present application, can be applied in application environment as shown in Figure 1.Wherein, terminal
It is communicated by network with server.The crosstab that server receiving terminal is sent exports request, exports and requests from crosstab
Middle read work book mark, searches the first worksheet corresponding with book mark, and server is slow by the first worksheet and locally
It deposits in queue derived caching crosstab to be matched, and extracts from caching team and to state the of the first worksheet successful match
One caching crosstab, and find out from the first worksheet the second worksheet of failed matching caching crosstab calculates the
Estimated export duration in two worksheets obtains the duration to be processed of current time lineation journey everywhere, exports duration on the estimation
Second worksheet is distributed everywhither in lineation journey with duration to be processed, obtain that lineation journey everywhere generates with the second worksheet pair
The export crosstab answered, server generate crosstab text according to the export crosstab of the first caching crosstab extracted and generation
Part will intersect list file and return to terminal.Wherein, terminal can be, but not limited to be various personal computers, laptop, intelligence
Energy mobile phone, tablet computer and portable wearable device, server can use independent server either multiple server groups
At server cluster realize.
In one embodiment, as shown in Fig. 2, providing a kind of crosstab deriving method, it is applied in Fig. 1 in this way
Server for be illustrated, include the following steps：
Step 210, it receives the crosstab that first terminal is sent and exports request, crosstab export request carries book mark
Know.
Book is the file for storing and handling operational data, such as excel file, and book is identified for work
Make book and carry out unique identification, book mark can be, but not limited to file name, code, number etc..One book can be by
Multiple group of worksheets are at worksheet is shown in the data form in workbook window, and every worksheet, which also has, carries out it
The worksheet of unique identification identifies, the worksheet mark of the corresponding all working table of same book and corresponding book mark
It is associated.Crosstab is the data sheet generated according to worksheet, and crosstab carries out Classifying Sum to the data in worksheet,
Data query is carried out convenient for user, therefore, user often has the demand that the data in book are exported as to crosstab.
User can carry out the derived operation of Cross Report batch to book in first terminal, and user can lead needs
The book of crosstab is selected out.First terminal is identified according to the book that the book that user chooses carries, and is generated and is handed over
Table export request is pitched, and crosstab export request is sent to server.Server receives the crosstab that first terminal is sent and leads
After requesting out, the book mark carried in crosstab export request is read.
Step 220, the first worksheet corresponding with book mark is searched.
All working book data are stored in server, server can search the first work corresponding with book mark
Table mark, and search the first worksheet corresponding with the first worksheet mark.First worksheet by multiple group of worksheets at, including
Book identifies all working table in corresponding book.
Step 230, by the first worksheet with derived caching crosstab matches in buffer queue.
Caching crosstab is to be stored with to have already passed through the obtained crosstab of export operation in buffer queue, caching crosstab with
The worksheet mark of corresponding worksheet is associated storage.Server searches whether exist and the first worksheet from buffer queue
Corresponding caching crosstab is identified, when finding the first worksheet corresponding caching crosstab of mark, then successful match, no
Then, it fails to match.
Step 240, it is extracted from buffer queue and caches crosstab with the first of the first worksheet successful match, and from the
The second worksheet of failed matching caching crosstab is found out in one worksheet.
Server extracts the first caching crosstab corresponding with the first worksheet of successful match from buffer queue
Come, and not there is no the second worksheet of the caching crosstab to match from screening in the first worksheet.In the present embodiment,
Two worksheets are a subset set of the first worksheet, and the second worksheet is the worksheet for needing to continue export operation.
Step 250, estimated export duration is calculated according to the second worksheet.
After screening server goes out the second worksheet, can according to the quantity of the second worksheet, the data volume of included data,
The factors such as data type, and the unit export durations of the various worksheets that are empirically derived are estimated out the second worksheet
All export needs the total duration spent.
Step 260, the duration to be processed of lineation journey everywhere is obtained, duration is exported on the estimation and duration calculation to be processed goes out
The distribution task duration of lineation journey everywhere, throughout distribution works with corresponding distribution task duration matched second in lineation journey
Table obtains the export crosstab corresponding with the second worksheet that lineation journey generates everywhere.
It is provided with multiple processing threads for crosstab export operation in server, is assigned intersection in lineation journey everywhere
The export task of table, the data volume of the worksheet for the pending export processing that server statistics distribute in lineation journey everywhere at present,
The duration to be processed of processing thread is calculated according to the data volume of worksheet to be processed.Server according to lineation journey everywhere to
The estimated export duration of handling duration and the second worksheet is led crosstab is carried out in the distribution of the second worksheet everywhither lineation journey
It handles out, and the total handling duration for be assigned with everywhere in after the second worksheet in lineation journey is generally kept in balance, and is made each
Processing thread can cooperate with processing.
Server when calculating the distribution task duration of lineation journey everywhere, can calculate lineation journey everywhere it is to be processed when
Long handling duration ratio, the allocation proportion of task amount can be distributed by calculating lineation journey everywhere further according to handling duration radiometer,
Allocation proportion and handling duration ratio negative correlation.
Server using each allocation proportion with it is expected that the product of export duration as the distribution task of reason duration everywhere in corresponding
Duration, i.e., it is each to handle the total duration that export task in thread with assignment table.Server is according to each second worksheet
Estimate export duration the second worksheet is combined so that combination after the second worksheet always estimate export duration with locate
The values match of the distribution task duration of lineation journey, and by the second worksheet after combination distribute to distribution task duration it is matched
It handles in thread.
When distributing the second worksheet to everywhither lineation journey, the second all worksheets can be carried out to unified label, example
Such as, it is marked using corresponding book mark, so that by the export task of the second worksheet and its in processing thread
The corresponding export task of his book is distinguished with showing.Lineation journey is according to the default derived rule of crosstab by the second worksheet everywhere
It carries out export processing and generates export crosstab, different types of worksheet likely corresponds to different default derived rules.Everywhere
After lineation journey exports the second all worksheets, export prompt can be carried out.
Step 270, it is generated according to the first caching crosstab and export crosstab and intersects list file, and returned list file is intersected
It is back to first terminal.
After server detects that the second worksheet in all processing threads exports, obtained from lineation journey everywhere
Take the export crosstab of generation, and the export crosstab for caching crosstab by extract first and obtaining from lineation journey everywhere
It carries out summarizing generation intersection list file, the intersection list file of generation is returned into first terminal
In above-mentioned crosstab deriving method, when server receives crosstab export request, first searched from buffer queue
Derived crosstab, and the caching crosstab that can will be matched are cached with the presence or absence of with what is matched to derived worksheet
It directly extracts, to reduce the workload of export processing, estimated export is calculated according to unmatched worksheet and is handled
Duration, on the estimation export duration and everywhere in lineation journey task duration to be processed, by unmatched worksheet reasonable distribution
Processing is carried out to multiple processing threads and generates crosstab, and the processing effect of crosstab export work can be improved in multithreading collaboration processing
Rate, and data jamming can be effectively reduced.
In one embodiment, as shown in figure 3, further including after receiving the crosstab export request that first terminal is sent
Following steps：
Step 212, login account is obtained from crosstab export request.
First terminal obtains the login account of active user, and login account is added when generating crosstab export request
It adds in crosstab export request.After server receives crosstab export request, reads and log in from crosstab export request
Account.
Step 214, the corresponding export permission of login account is searched, when exporting permission lower than default access rank, is searched
The corresponding administrator's account of login account.
There are different users different data the permissions such as to check, edit, export, and be previously stored each user in server
Login account and data the mapping relations for checking permission, editing authority, the export permissions such as permission, server, which is read, logs in account
After number, the corresponding export permission of login account is searched.Export permission is divided into different Permission Levels.In the present embodiment, it presets
Permission Levels are the rank that can carry out the export permission of crosstab export operation, are stored in advance in the server.Server will
The export permission of the user found is compared with default access rank, when export permission is equal to or higher than default access rank
When, then it can carry out continuing step 220；When exporting permission lower than default access rank, server searches login account
Corresponding administrator's account.The account permission of administrator's account is greater than common user account, and user account can be grouped
Management, same administrator's account can carry out rights management to multiple user accounts.
Step 216, it is identified according to book and generates crosstab export approval request, crosstab export approval request is sent
Give administrator's account corresponding second terminal.
The corresponding book mark of book for needing to carry out crosstab export operation, clothes are carried in crosstab approval request
Crosstab export request is sent to the corresponding second terminal of administrator's account by business device, so that administrator leads according to crosstab
The book mark in request judges whether the corresponding user of login account can carry out the crosstab export of corresponding book out
Work.Second terminal determines to generate examination & approval notice according to the examination & approval of administrator, will examine notice and return to server.
Step 220 may include：When the examination & approval for receiving second terminal return pass through notice, then search and book mark
Know corresponding first worksheet.
When the examination & approval that server receives second terminal return pass through notice, from examination & approval by reading examination & approval knot in notice
Fruit, when approval results, which cross examination & approval, to be passed through, server then searches the first worksheet corresponding with book mark.Work as approval results
When not passing through to examine, prompt of the active user without export permission is can be generated in server, will be prompted to return to first terminal.
In the present embodiment, server is before carrying out crosstab export operation, and first judgement issues the user of export request
Whether there is export permission, export operation is carried out again when having export permission, so as to guarantee the safety of data.
In one embodiment, after obtaining the export crosstab corresponding with the second worksheet that lineation journey generates everywhere,
Including：The corresponding Band 1 of crosstab is respectively cached in statistics buffer queue and extracts frequency；According to Band 1 and extract frequency
Each caching crosstab is ranked up by rate；Search corresponding second group of export crosstab；Export is intersected according to the second group
In buffer queue after list insertion sort.
In the present embodiment, server is grouped management to book and worksheet, can be with when being grouped management
It is grouped management according to data category belonging to book, worksheet, it can also be according to belonging to the user of creation book
User grouping is grouped management, can also be grouped management using other modes.Correspondingly, the friendship generated according to worksheet
Fork table is also grouped according to the packet mode of worksheet.
The corresponding Band 1 of crosstab is respectively cached in server statistics current cache queue, since different cachings intersects
Table likely corresponds to different groups, and Band 1 may include multiple groups.Server is by each caching crosstab according to first
Group is classified, and sorted each group is ranked up, and server can be randomly ordered, and difference also can be set in each group
Processing priority, the other caching crosstab of each group is ranked up by server according to the other processing priority of each group.Classifying
The extraction time that crosstab is extracted due to export demand is respectively cached in each group afterwards, in server statistics group
Number, and extraction frequency of each caching crosstab in preset duration is calculated according to extraction time, server will be in same group
Each caching crosstab according to extract frequency be ranked up.
It is second group corresponding to search export crosstab after obtaining the export crosstab that lineation journey generates everywhere for server
Not, it searches to whether there is in buffer queue and will export crosstab when it is present with the consistent caching crosstab of the second group group
It is inserted into the tail of the queue of second group of other caching crosstab；When it be not present, export crosstab is inserted into the team of entire buffer queue
Tail.In one embodiment, the quantity of the export crosstab obtained when server is greater than the quantity of clear position in buffer queue
When, cache overflow quantity is calculated according to the quantity of the quantity of export crosstab and clear position, and preferentially from the other team of each group
Tail deletes quantity and the consistent caching crosstab of cache overflow quantity.In other embodiments, server can also directly postpone
The tail of the queue for depositing queue is deleted and the consistent caching crosstab of cache overflow quantity.Export is surrendered into table according to above-mentioned implementation after deletion
Insertion rule in example is inserted into buffer queue.
In the present embodiment, being ranked up according to group and extraction frequency for crosstab will be respectively cached in buffer queue, it can
It is retained in buffer queue so that the big caching crosstab of frequency will be extracted, the utilization rate of caching crosstab is improved, so as to mention
The export efficiency of high crosstab.
In one embodiment, crosstab deriving method further includes：Calculate the data capacity of crosstab file；Work as data
When capacity is greater than preset capacity threshold value, login account is read from crosstab export request；According to login account to crosstab text
Part folder carries out compression processing and obtains crosstab compressed package, generates crosstab according to crosstab compressed package and obtains link, by crosstab
Link returns；When data capacity is less than or equal to preset capacity threshold value, then list file will be intersected by, which continuing to execute, is back to first eventually
The step of end.
After server generates intersection list file, calculates the data capacity for intersecting list file and obtain preset capacity threshold value.
Preset capacity threshold value is used to set the maximum transmission data capacity of maximum file, and preset capacity threshold value is previously stored in server
In.Calculated data capacity is compared by server with preset capacity threshold value, when data capacity is greater than preset capacity threshold value
When, server reads login account from crosstab export request, compression Crypted password corresponding with login account is searched, according to
Compression Crypted password carries out compression encryption to crosstab file and generates crosstab compressed package.First terminal can be by each use
The file encryption password and login account at family are sent to server in advance, and server is corresponding by file encryption password and login account
Storage.
Server stores crosstab compressed package to designated storage location, or by crosstab compressed package upload to cloud disk into
Row storage, server generate crosstab according to the storage location of crosstab compressed package and obtain link, and crosstab acquisition is linked as handing over
The download access address of table compressed package is pitched, crosstab is obtained link and returns to first terminal, the user of first terminal by server
After receiving crosstab acquisition link, crosstab can be opened and obtain link and voluntarily download crosstab compressed package.When data are held
When amount is less than or equal to preset capacity threshold value, server continues to execute the step 270 that intersection list file is back to first terminal.
In the present embodiment, when server detect the crosstab file of generation quantity it is excessive when, according to crosstab
File generated crosstab compressed package, and crosstab is generated according to crosstab compressed package and obtains link, only crosstab is obtained and is linked
First terminal is returned to, so that data transmission blocking is avoided, improve data transfer efficiency.
In one embodiment, found out from the first worksheet failed matching caching crosstab the second worksheet it
Afterwards, further include：Data format verification is carried out to the data in the second worksheet, judges the second work according to data format check results
Make whether table meets crosstab export condition；When the second worksheet is unsatisfactory for crosstab export condition, according to being unsatisfactory for intersecting
The worksheet mark that table exports the second worksheet of condition generates format check failure notification, and format check failure notification is returned
Back to first terminal.
After server finds out the second worksheet, data format verification is carried out to the second worksheet, judges the second work
Whether table meets the condition that can export crosstab.Specifically, server judges whether the data in the second worksheet are polymerization
Data, and judge whether the data in the second worksheet are discrete data, it should be noted that in the present embodiment, two are sentenced
The sequencing that disconnected step executes is it is not limited here.When the data in the second worksheet are aggregated data and are discrete data
When, the data format of the second worksheet is verified successfully；And it continues to execute and estimated export duration is calculated according to the second worksheet
Step 250.
When the data in the second worksheet are non-polymeric data or are continuous data, then to the number in the second worksheet
Fail according to format check.And when implementing result of the server to first judgment step is verification failure, then do not continue to hold
Another judgment step of row.When verifying failure, the second worksheet continues crosstab because being unsatisfactory for crosstab export condition
Export operation, server identifies according to the worksheet of the second worksheet and generates format check failure notification, and format check is lost
It loses notice and returns to first terminal, so that first terminal obtains the relevant information for being unsatisfactory for the worksheet of crosstab export condition.
In one embodiment, estimated export duration is calculated according to second worksheet, including：The second work of statistics
The worksheet quantity of table；Data format mark is read from crosstab export request；Retain mark when data format is identified as format
When knowledge, obtains format and retain the corresponding first export time quantum of mark, according to worksheet quantity and the first export time quantum
Calculate estimated export duration；When data format, which is identified as format, excludes mark, obtains format and exclude mark corresponding second
Time quantum is exported, estimated export duration is calculated according to worksheet quantity and the second export time quantum.
In the present embodiment, when calculating estimated export duration according to the second worksheet, server statistics go out the second work
Make the worksheet quantity of table.User when first terminal carries out crosstab export operation, can data format to crosstab into
Row is select and set, and first terminal generates data format according to the data format of user setting and identifies, and data format is identified
It is added in crosstab export request.
Server reads data format mark from crosstab export request, in the present embodiment, data format mark point
It is two kinds, including format retains mark and data exclude mark.In the crosstab export request to format reservation mark is carried
The data format for needing to retain data in former worksheet when being handled, when worksheet is exported as crosstab, as Data Color,
The formats such as data font, and to carry format exclude mark crosstab export request handle when, then only need encumbrance
According to numerical value, without retaining data format, therefore, to format exclude worksheet carry out crosstab export processing when speed more
It is fast.
When server judges that data format is identified as format reservation mark, server obtains format and retains mark correspondence
First export time quantum, first export time quantum be count to a worksheet carry out intersect sheet format reservation lead
Average duration when handling out, when calculating estimated export according to the worksheet quantity counted and the first export time quantum
It is long.When server judges that data format is identified as format and excludes mark, server obtains format and excludes mark corresponding the
Two export time quantums, second export time quantum be count to a worksheet carry out intersect sheet format exclude export at
Average duration when reason calculates estimated export duration according to the worksheet quantity counted and the second export time quantum.
In this embodiment, format classification being exported according to the data of crosstab and calculating estimated export duration, calculated result is more
It is accurate to add.
In one embodiment, duration and duration to be processed are exported on the estimation distribute the second worksheet to everywhither lineation
Before in journey, further include：First task timestamp is obtained from crosstab export request, when by the second worksheet and first task
Between stamp be associated record.
After export duration and duration to be processed distribute the second worksheet in everywhither lineation journey on the estimation, also wrap
It includes：Acquisition is assigned the corresponding second task time stamp of each worksheet in the processing thread of the second worksheet；In processing thread
Each worksheet is ranked up according to the second task time stamp.
Server is before carrying out thread distribution for the second worksheet, when obtaining first task from crosstab export request
Between stab, in the first task time can for first terminal issue crosstab export request when time.Server is according to first
Timestamp be engaged in the second worksheet progress task time record.When server by the second worksheet distribute everywhither lineation journey it
Afterwards, server, which obtains, is assigned with the corresponding second task time stamp of all working table in the processing thread of the second worksheet, and second
It include the multiple tasks timestamp of each worksheet associated record in task time stamp, server is by each worksheet according to corresponding
Task time stamp sequence from front to back is ranked up, in the crosstab export for carrying out worksheet in lineation journey everywhere again after sequence
Processing, so that priority processing requests first export task, avoids period of reservation of number too long, improves user experience.
It should be understood that although each step in the flow chart of Fig. 2-3 is successively shown according to the instruction of arrow,
These steps are not that the inevitable sequence according to arrow instruction successively executes.Unless expressly stating otherwise herein, these steps
Execution there is no stringent sequences to limit, these steps can execute in other order.Moreover, at least one in Fig. 2-3
Part steps may include that perhaps these sub-steps of multiple stages or stage are not necessarily in synchronization to multiple sub-steps
Execute completion, but can execute at different times, the execution in these sub-steps or stage sequence also need not be successively into
Row, but can be held in turn or alternately at least part of the sub-step or stage of other steps or other steps
Row.
In one embodiment, as shown in figure 4, providing a kind of crosstab guiding device, including：Export request receives mould
Block 410, the first searching module 420, matching module 430, the second searching module 440, duration estimate module 450, thread distribution mould
Block 460 and file generating module 470, wherein：
Request receiving module 410 is exported, for receiving the crosstab export request of first terminal transmission, crosstab export is asked
It asks and carries book mark.
First searching module 420, for searching the first worksheet corresponding with book mark.
Matching module 430, for by the first worksheet with derived caching crosstab matches in buffer queue.
Second searching module 440, for extracting the first caching with the first worksheet successful match from buffer queue
Crosstab, and failed the second worksheet for matching caching crosstab is found out from the first worksheet.
Duration estimates module 450, for calculating estimated export duration according to the second worksheet.
Thread distribution module 460, for obtaining the duration to be processed of lineation journey everywhere, according to the estimated export duration and
The duration calculation to be processed goes out the distribution task duration of the lineation journey everywhere, in the journey of lineation everywhere distribution with it is corresponding
Matched second worksheet of distribution task duration, obtain the lineation journey everywhere generate it is corresponding with second worksheet
Export crosstab.
File generating module 470 intersects list file for generating according to the first caching crosstab and export crosstab, and will
Intersect list file and is back to first terminal.
In one embodiment, crosstab guiding device further includes：
Login account obtains module, for obtaining login account from crosstab export request.
Administrator's account searching module, for searching the corresponding export permission of login account, when export permission is lower than default
When Permission Levels, the corresponding administrator's account of login account is searched.
Sending module is examined, crosstab export approval request is generated for identifying according to book, crosstab is exported and is examined
It criticizes request and is sent to the corresponding second terminal of administrator's account.
First searching module 420 can be also used for when the examination & approval for receiving the second terminal return pass through notice, then
Search the first worksheet corresponding with book mark.
In one embodiment, crosstab guiding device further includes：
Cache table statistical module respectively caches the corresponding Band 1 of crosstab and extraction frequency for counting in buffer queue
Rate.
Cache table sorting module, for being ranked up each caching crosstab according to Band 1 and extraction frequency.
Group searching module, for searching corresponding second group of export crosstab.
Module is inserted into queue, for being intersected export in the buffer queue after list insertion sort according to the second group.
In one embodiment, crosstab guiding device further includes：
Capacity calculation module, for calculating the data capacity of crosstab file.
Login account read module, for being exported in request from crosstab when data capacity is greater than preset capacity threshold value
Read login account.
Connection generation module is obtained, obtains crosstab for carrying out compression processing to crosstab file according to login account
Compressed package generates crosstab according to crosstab compressed package and obtains link, crosstab is linked and is returned.
Execution module, for when data capacity is less than or equal to preset capacity threshold value, then list file will to be intersected by continuing to execute
The step of being back to first terminal.
In one embodiment, crosstab guiding device further includes：
Format check module, for carrying out data format verification to the data in the second worksheet, according to data format school
It tests result and judges whether the second worksheet meets crosstab export condition.
Failure notification module, for when the second worksheet is unsatisfactory for crosstab export condition, according to being unsatisfactory for crosstab
The worksheet mark of second worksheet of export condition generates format check failure notification, and format check failure notification is returned
To first terminal.
In one embodiment, duration estimates module and may include：
Table quantity statistics module, for counting the worksheet quantity of the second worksheet.
Format identification (FID) read module, for reading data format mark from crosstab export request.
First duration calculation module, for obtaining format and retaining mark when data format is identified as format and retains mark
Corresponding first export time quantum calculates estimated export duration according to worksheet quantity and the first export time quantum.
Second duration calculation module, for obtaining format and excluding mark when data format is identified as format exclusion mark
Corresponding second export time quantum calculates estimated export duration according to worksheet quantity and the second export time quantum.
In one embodiment, crosstab guiding device further includes：
Timestamp logging modle, for obtaining first task timestamp from crosstab export request, by the second worksheet
Record is associated with first task timestamp.
Second timestamp obtains module, corresponding for obtaining each worksheet in the processing thread for be assigned the second worksheet
Second task time stamp.
Thread ordering module, for being ranked up each worksheet according to the second task time stamp in processing thread.
Specific about crosstab guiding device limits the restriction that may refer to above for crosstab deriving method,
This is repeated no more.Modules in above-mentioned crosstab guiding device can come fully or partially through software, hardware and combinations thereof
It realizes.Above-mentioned each module can be embedded in the form of hardware or independently of in the processor in computer equipment, can also be with software
Form is stored in the memory in computer equipment, executes the corresponding operation of the above modules in order to which processor calls.
In one embodiment, a kind of computer equipment is provided, which can be server, internal junction
Composition can be as shown in Figure 5.The computer equipment include by system bus connect processor, memory, network interface and
Database.Wherein, the processor of the computer equipment is for providing calculating and control ability.The memory packet of the computer equipment
Include non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program and data
Library.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating
The database of machine equipment is for storing book, worksheet etc. for data derived from crosstab.The network of the computer equipment
Interface is used to communicate with external terminal by network connection.To realize a kind of intersection when the computer program is executed by processor
Table deriving method.
It will be understood by those skilled in the art that structure shown in Fig. 5, only part relevant to application scheme is tied
The block diagram of structure does not constitute the restriction for the computer equipment being applied thereon to application scheme, specific computer equipment
It may include perhaps combining certain components or with different component layouts than more or fewer components as shown in the figure.
In one embodiment, a kind of computer equipment, including memory and processor are provided, which is stored with
Computer program, the processor realize following steps when executing computer program：Receive the crosstab export that first terminal is sent
Request, crosstab export request carry book mark；Search the first worksheet corresponding with book mark；By the first work
Table with derived caching crosstab is matched in buffer queue；It is extracted from buffer queue and the success of the first worksheet
The the first caching crosstab matched, and failed the second worksheet for matching caching crosstab is found out from the first worksheet；Root
Estimated export duration is calculated according to the second worksheet；Obtain the duration to be processed of lineation journey everywhere, export on the estimation duration and
Duration calculation to be processed goes out the distribution task duration of lineation journey everywhere, when throughout distribution is with corresponding distribution task in lineation journey
Long matched second worksheet, obtains the export crosstab corresponding with the second worksheet that lineation journey generates everywhere；According to first
It caches crosstab and export crosstab generates and intersects list file, and be back to first terminal for list file is intersected.
In one embodiment, following steps are also realized when processor executes computer program：It exports and requests from crosstab
Middle acquisition login account；The corresponding export permission of login account is searched, when exporting permission lower than default access rank, lookup is stepped on
Record the corresponding administrator's account of account；It is identified according to book and generates crosstab export approval request, crosstab is exported and is examined
Request is sent to the corresponding second terminal of administrator's account；The first worksheet corresponding with book mark is searched, including：When connecing
The examination & approval of second terminal return are received when passing through notice, then search the first worksheet corresponding with book mark.
In one embodiment, following steps are also realized when processor executes computer program：Count each in buffer queue
It caches the corresponding Band 1 of crosstab and extracts frequency；Each caching crosstab is arranged according to Band 1 and extraction frequency
Sequence；Search corresponding second group of export crosstab；Export is intersected to the buffer queue after list insertion sort according to the second group
In.
In one embodiment, following steps are also realized when processor executes computer program：Calculate crosstab file
Data capacity；When data capacity is greater than preset capacity threshold value, login account is read from crosstab export request；According to stepping on
Record account carries out compression processing to crosstab file and obtains crosstab compressed package, generates crosstab according to crosstab compressed package and obtains
Link is taken, crosstab is linked and is returned；When data capacity is less than or equal to preset capacity threshold value, then continue to execute crosstab text
Part is back to the step of first terminal.
In one embodiment, following steps are also realized when processor executes computer program：To in the second worksheet
Data carry out data format verification, judge whether the second worksheet meets crosstab export item according to data format check results
Part；When the second worksheet is unsatisfactory for crosstab export condition, according to the second worksheet for being unsatisfactory for crosstab export condition
Worksheet mark generates format check failure notification, and format check failure notification is returned to first terminal.
In one embodiment, it is realized when processor executes computer program and estimated export is calculated according to the second worksheet
It is also used to when the step of duration：Count the worksheet quantity of the second worksheet；Data format is read from crosstab export request
Mark；When data format, which is identified as format, retains mark, obtains format and retain the corresponding first export time quantum of mark, root
Estimated export duration is calculated according to worksheet quantity and the first export time quantum；Mark is excluded when data format is identified as format
When, it obtains format and excludes the corresponding second export time quantum of mark, according to worksheet quantity and the second export time quantum meter
Calculate estimated export duration.
In one embodiment, following steps are also realized when processor executes computer program：It exports and requests from crosstab
Second worksheet and first task timestamp are associated record by middle acquisition first task timestamp；Acquisition is assigned second
The corresponding second task time stamp of each worksheet in the processing thread of worksheet；By each worksheet according to second in processing thread
Task time stamp is ranked up.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated
Machine program realizes following steps when being executed by processor：It receives the crosstab that first terminal is sent and exports request, crosstab export
Request carries book mark；Search the first worksheet corresponding with book mark；It will be in the first worksheet and buffer queue
Derived caching crosstab is matched；It extracts from buffer queue and is handed over the first caching of the first worksheet successful match
Table is pitched, and finds out the second worksheet of failed matching caching crosstab from the first worksheet；According to the second work meter
Calculate estimated export duration；The duration to be processed of lineation journey everywhere is obtained, exports duration and duration calculation to be processed on the estimation
The distribution task duration of lineation journey everywhere out, throughout distribution and matched second work of corresponding distribution task duration in lineation journey
Make table, obtains the export crosstab corresponding with the second worksheet that lineation journey generates everywhere；According to the first caching crosstab and lead
Crosstab, which generates, out intersects list file, and is back to first terminal for list file is intersected.
In one embodiment, following steps are also realized when computer program is executed by processor：It is asked from crosstab export
Seek middle acquisition login account；The corresponding export permission of login account is searched, when exporting permission lower than default access rank, is searched
The corresponding administrator's account of login account；It is identified according to book and generates crosstab export approval request, crosstab is exported and is examined
It criticizes request and is sent to the corresponding second terminal of administrator's account；The first worksheet corresponding with book mark is searched, including：When
The examination & approval of second terminal return are received when passing through notice, then search the first worksheet corresponding with book mark.
In one embodiment, following steps are also realized when computer program is executed by processor：It counts in buffer queue
It is each to cache the corresponding Band 1 of crosstab and extract frequency；Each caching crosstab is carried out according to Band 1 and extraction frequency
Sequence；Search corresponding second group of export crosstab；Export is intersected to the caching team after list insertion sort according to the second group
In column.
In one embodiment, following steps are also realized when computer program is executed by processor：It calculates and intersects list file
The data capacity of folder；When data capacity is greater than preset capacity threshold value, login account is read from crosstab export request；According to
Login account carries out compression processing to crosstab file and obtains crosstab compressed package, generates crosstab according to crosstab compressed package
Link is obtained, crosstab is linked and is returned；When data capacity is less than or equal to preset capacity threshold value, then continue to execute crosstab
File is back to the step of first terminal.
In one embodiment, following steps are also realized when computer program is executed by processor：To in the second worksheet
Data carry out data format verification, according to data format check results judge the second worksheet whether meet crosstab export item
Part；When the second worksheet is unsatisfactory for crosstab export condition, according to the second worksheet for being unsatisfactory for crosstab export condition
Worksheet mark generates format check failure notification, and format check failure notification is returned to first terminal.
In one embodiment, following steps are also realized when computer program is executed by processor：Count the second worksheet
Worksheet quantity；Data format mark is read from crosstab export request；Retain mark when data format is identified as format
When, it obtains format and retains the corresponding first export time quantum of mark, according to worksheet quantity and the first export time quantum meter
Calculate estimated export duration；When data format, which is identified as format, excludes mark, obtains format exclusion mark corresponding second and lead
Time quantum out calculates estimated export duration according to worksheet quantity and the second export time quantum.
In one embodiment, following steps are also realized when computer program is executed by processor：It is asked from crosstab export
Middle acquisition first task timestamp is sought, the second worksheet and first task timestamp are associated record；Acquisition is assigned
The corresponding second task time stamp of each worksheet in the processing thread of two worksheets；By each worksheet according to the in processing thread
Two task times stamp is ranked up.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer
In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein,
To any reference of memory, storage, database or other media used in each embodiment provided herein,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms,
Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing
Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above embodiments can be combined arbitrarily, for simplicity of description, not to above-described embodiment
In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance
Shield all should be considered as described in this specification.
The several embodiments of the application above described embodiment only expresses, the description thereof is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
It says, without departing from the concept of this application, various modifications and improvements can be made, these belong to the protection of the application
Range.Therefore, the scope of protection shall be subject to the appended claims for the application patent.
Claims (10)
1. a kind of crosstab deriving method, the method includes：
It receives the crosstab that first terminal is sent and exports request, the crosstab export request carries book mark；
Search the first worksheet corresponding with book mark；
By first worksheet with derived caching crosstab matches in buffer queue；
It is extracted from the buffer queue and caches crosstab with the first of the first worksheet successful match, and from described the
The second worksheet for matching the caching crosstab not successfully is found out in one worksheet；
Estimated export duration is calculated according to second worksheet；
The duration to be processed for obtaining lineation journey everywhere goes out described according to the estimated export duration and the duration calculation to be processed
The distribution task duration of lineation journey everywhere is distributed and corresponding distribution task duration matched second in the journey of lineation everywhere
Worksheet obtains the export crosstab corresponding with second worksheet that the lineation journey everywhere generates；
It is generated according to the first caching crosstab and the export crosstab and intersects list file, and the intersection list file is returned
It is back to the first terminal.
2. the method according to claim 1, wherein the crosstab export request for receiving first terminal and sending
Later, further include：
Login account is obtained from crosstab export request；
The corresponding export permission of the login account is searched, when the export permission is lower than default access rank, described in lookup
The corresponding administrator's account of login account；
It is identified according to the book and generates crosstab export approval request, crosstab export approval request is sent to institute
State the corresponding second terminal of administrator's account；
It is described to search corresponding with book mark the first worksheet, including：
When receiving the examination & approval that the second terminal returns and passing through notice, then search and book mark corresponding first
Worksheet.
3. the method according to claim 1, wherein it is described acquisition everywhere lineation journey generate with second work
After making the corresponding export crosstab of table, further include：
It counts and respectively caches the corresponding Band 1 of crosstab and extraction frequency in the buffer queue；
Each caching crosstab is ranked up according to the Band 1 and the extraction frequency；
Search corresponding second group of the export crosstab；
The export is intersected in the buffer queue after list insertion sort according to second group.
4. the method according to claim 1, wherein the method also includes：
Calculate the data capacity of the crosstab file；
When the data capacity is greater than preset capacity threshold value, login account is read from crosstab export request；
Compression processing is carried out to the crosstab file according to the login account and obtains crosstab compressed package, according to the friendship
It pitches table compressed package and generates crosstab acquisition link, the crosstab is linked and is returned；
When the data capacity is less than or equal to preset capacity threshold value, then continue to execute described in being back to the intersections list file
The step of first terminal.
5. the method according to claim 1, wherein described find out failed from first worksheet
After the second worksheet with the caching crosstab, further include：
Data format verification is carried out to the data in second worksheet, judges described second according to data format check results
Whether worksheet meets crosstab export condition；
When second worksheet is unsatisfactory for crosstab export condition, according to the second work for being unsatisfactory for crosstab export condition
The worksheet mark of table generates format check failure notification, and the format check failure notification is returned to described first eventually
End.
6. the method according to claim 1, wherein described calculate estimated export according to second worksheet
Duration, including：
Count the worksheet quantity of second worksheet；
Data format mark is read from crosstab export request；
When the data format, which is identified as format, retains mark, obtains the format and retain the mark corresponding first export time
Unit calculates estimated export duration according to the worksheet quantity and the first export time quantum；
When the data format, which is identified as format, excludes mark, obtains the format and exclude the mark corresponding second export time
Unit calculates estimated export duration according to the worksheet quantity and the second export time quantum.
7. the method according to claim 1, wherein described according to the estimated export duration and described to be processed
Before duration distributes second worksheet into the journey of lineation everywhere, further include：
First task timestamp is obtained from crosstab export request, when by second worksheet and the first task
Between stamp be associated record；
It is described to be distributed second worksheet to each processing according to the estimated export duration and the duration to be processed
After in thread, further include：
Acquisition is assigned the corresponding second task time stamp of each worksheet in the processing thread of second worksheet；
Each worksheet is ranked up according to second task time stamp in the processing thread.
8. a kind of crosstab guiding device, which is characterized in that described device includes：
Request receiving module is exported, for receiving the crosstab export request of first terminal transmission, the crosstab export request
Carry book mark；
First searching module, for searching the first worksheet corresponding with book mark；
Matching module, for by first worksheet with derived caching crosstab matches in buffer queue；
Second searching module, for extracting the first caching with the first worksheet successful match from the buffer queue
Crosstab, and the second worksheet for matching the caching crosstab not successfully is found out from first worksheet；
Duration estimates module, for calculating estimated export duration according to second worksheet；
Thread distribution module, for obtaining the duration to be processed of lineation journey everywhere, according to the estimated export duration and it is described to
Handling duration calculates the distribution task duration of the lineation journey everywhere, distributes and corresponding distribution in the journey of lineation everywhere
Matched second worksheet of task duration obtains the export corresponding with second worksheet that the lineation journey everywhere generates and hands over
Pitch table；
File generating module intersects list file for generating according to the first caching crosstab and the export crosstab, and
The intersection list file is back to the first terminal.
9. a kind of computer equipment, including memory and processor, the memory are stored with computer program, feature exists
In the step of processor realizes any one of claims 1 to 7 the method when executing the computer program.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of method described in any one of claims 1 to 7 is realized when being executed by processor.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810489984.2A CN108874894A (en) | 2018-05-21 | 2018-05-21 | Crosstab deriving method, device, computer equipment and storage medium |
| PCT/CN2018/096907 WO2019223092A1 (en) | 2018-05-21 | 2018-07-24 | Crosstab export method and apparatus, computer device, and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810489984.2A CN108874894A (en) | 2018-05-21 | 2018-05-21 | Crosstab deriving method, device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108874894A true CN108874894A (en) | 2018-11-23 |
Family
ID=64333327
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810489984.2A Withdrawn CN108874894A (en) | 2018-05-21 | 2018-05-21 | Crosstab deriving method, device, computer equipment and storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN108874894A (en) |
| WO (1) | WO2019223092A1 (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109697211A (en) * | 2018-12-07 | 2019-04-30 | 用友网络科技股份有限公司 | The processing method and system, computer readable storage medium of crosstab export data |
| CN110688344A (en) * | 2019-09-24 | 2020-01-14 | 捷开通讯(深圳)有限公司 | File scanning method and device, computer readable storage medium and terminal |
| CN111782658A (en) * | 2020-07-08 | 2020-10-16 | 支付宝(杭州)信息技术有限公司 | Cross table processing method, cross table processing device, electronic equipment and storage medium |
| CN112685481A (en) * | 2019-10-17 | 2021-04-20 | 北京京东振世信息技术有限公司 | Data processing method and device |
| CN112800824A (en) * | 2020-12-08 | 2021-05-14 | 北京方正印捷数码技术有限公司 | Processing method, device and equipment for scanning file and storage medium |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8015061B2 (en) * | 2005-10-21 | 2011-09-06 | Sap Ag | File export channel |
| CN104536827B (en) * | 2015-01-27 | 2019-05-28 | 浪潮(北京)电子信息产业有限公司 | A kind of data dispatching method and device |
| CN105843951B (en) * | 2016-04-12 | 2019-12-13 | 北京小米移动软件有限公司 | Data query method and device |
-
2018
- 2018-05-21 CN CN201810489984.2A patent/CN108874894A/en not_active Withdrawn
- 2018-07-24 WO PCT/CN2018/096907 patent/WO2019223092A1/en active Application Filing
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109697211A (en) * | 2018-12-07 | 2019-04-30 | 用友网络科技股份有限公司 | The processing method and system, computer readable storage medium of crosstab export data |
| CN109697211B (en) * | 2018-12-07 | 2020-12-01 | 用友网络科技股份有限公司 | Method and system for processing cross table derived data and computer readable storage medium |
| CN110688344A (en) * | 2019-09-24 | 2020-01-14 | 捷开通讯(深圳)有限公司 | File scanning method and device, computer readable storage medium and terminal |
| CN112685481A (en) * | 2019-10-17 | 2021-04-20 | 北京京东振世信息技术有限公司 | Data processing method and device |
| CN112685481B (en) * | 2019-10-17 | 2023-11-03 | 北京京东振世信息技术有限公司 | Data processing method and device |
| CN111782658A (en) * | 2020-07-08 | 2020-10-16 | 支付宝(杭州)信息技术有限公司 | Cross table processing method, cross table processing device, electronic equipment and storage medium |
| CN112800824A (en) * | 2020-12-08 | 2021-05-14 | 北京方正印捷数码技术有限公司 | Processing method, device and equipment for scanning file and storage medium |
| CN112800824B (en) * | 2020-12-08 | 2024-02-02 | 北京方正印捷数码技术有限公司 | Method, device, equipment and storage medium for processing scanned file |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2019223092A1 (en) | 2019-11-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108874894A (en) | Crosstab deriving method, device, computer equipment and storage medium | |
| CN111506498B (en) | Automatic generation method and device of test case, computer equipment and storage medium | |
| WO2020186786A1 (en) | File processing method and apparatus, computer device and storage medium | |
| US7853770B2 (en) | Storage system, data relocation method thereof, and recording medium that records data relocation program | |
| CN104391954B (en) | The processing method and processing device of database journal | |
| CN109492021A (en) | Enterprise's portrait information query method, device, computer equipment and storage medium | |
| CN109359283A (en) | Method of summary, terminal device and the medium of list data | |
| CN113297182B (en) | Data migration method, device, storage medium and program product | |
| US8983913B2 (en) | System and method for business-driven archiving | |
| US11119843B2 (en) | Verifying application behavior based on distributed tracing | |
| CN110046298A (en) | Query word recommendation method and device, terminal device and computer readable medium | |
| CN107688488A (en) | A kind of optimization method and device of the task scheduling based on metadata | |
| WO2024021555A1 (en) | Resource examination and approval method and device, and random forest model training method and device | |
| CN106603673A (en) | Fine-grained cloud storage scheduling method based on erasure codes | |
| CN105677549A (en) | Software testing management method and system | |
| CN110659297A (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN107644382A (en) | Policy information statistical method and device | |
| CN112100219A (en) | Report generation method, device, equipment and medium based on database query processing | |
| CN111078794A (en) | Big data storage system | |
| WO2020233310A1 (en) | Asynchronous compensation method and apparatus for real-time processing data, device, and storage medium | |
| CN112764794A (en) | Open source software information management system and method | |
| CN107330031A (en) | A kind of method of data storage, device and electronic equipment | |
| US9092579B1 (en) | Rating popularity of clusters of runs of test scenarios based on number of different organizations | |
| US9483560B2 (en) | Data analysis control | |
| CN111045983B (en) | Nuclear power station electronic file management method, device, terminal equipment and medium |
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 | ||
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20181123 |