CN109254969A - Tables of data processing method, device, equipment and storage medium - Google Patents
Tables of data processing method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN109254969A CN109254969A CN201811008790.2A CN201811008790A CN109254969A CN 109254969 A CN109254969 A CN 109254969A CN 201811008790 A CN201811008790 A CN 201811008790A CN 109254969 A CN109254969 A CN 109254969A
- Authority
- CN
- China
- Prior art keywords
- tables
- data
- service
- condition
- identification information
- 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.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 35
- 239000011159 matrix material Substances 0.000 claims abstract description 60
- 238000012545 processing Methods 0.000 claims description 22
- 238000012550 audit Methods 0.000 claims description 18
- 238000004590 computer program Methods 0.000 claims description 18
- 230000005540 biological transmission Effects 0.000 claims description 10
- 238000012795 verification Methods 0.000 claims description 10
- 238000012937 correction Methods 0.000 claims description 6
- 238000004321 preservation Methods 0.000 claims description 6
- 238000012360 testing method Methods 0.000 claims description 5
- 235000013399 edible fruits Nutrition 0.000 claims description 3
- 238000005516 engineering process Methods 0.000 abstract description 3
- 238000000034 method Methods 0.000 description 15
- 238000012546 transfer Methods 0.000 description 9
- 239000000047 product Substances 0.000 description 8
- 230000006870 function Effects 0.000 description 7
- 230000008676 import Effects 0.000 description 7
- 230000006978 adaptation Effects 0.000 description 5
- 238000012423 maintenance Methods 0.000 description 5
- 238000007726 management method Methods 0.000 description 5
- 230000004075 alteration Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 239000000463 material Substances 0.000 description 3
- 230000000694 effects Effects 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 230000000717 retained effect Effects 0.000 description 2
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000003693 cell processing method Methods 0.000 description 1
- 230000010485 coping Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 238000005194 fractionation Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000029058 respiratory gaseous exchange Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 239000013589 supplement Substances 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 230000029305 taxis Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/08—Error detection or correction by redundancy in data representation, e.g. by using checking codes
- G06F11/10—Adding special bits or symbols to the coded information, e.g. parity check, casting out 9's or 11's
- G06F11/1004—Adding special bits or symbols to the coded information, e.g. parity check, casting out 9's or 11's to protect a block of data words, e.g. CRC or checksum
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Security & Cryptography (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention relates to field of computer technology, providing a kind of tables of data processing method, device, equipment and storage medium, the tables of data processing method includes: acquisition primary data information (pdi);In preset condition set, merging condition corresponding with service identification information is obtained;In service attribute field, the objective attribute target attribute field for meeting merging condition is searched, and according to the condition of merging, objective attribute target attribute field is merged, target matrix is obtained;Target matrix is verified, check results are obtained;If check results be it is correct, using target matrix as normal data table, and normal data table is stored in preset database.The present invention realizes the raising to the treatment effeciency of tables of data.
Description
Technical field
The present invention relates to field of computer technology more particularly to a kind of tables of data processing method, device, equipment and storage to be situated between
Matter.
Background technique
Currently, generally requiring during the tables of data to numerous species carries out tables of data storage for Various types of data
The type of service of table creates the form template of adaptation, and the situation huge to complicated tables of data or data volume needs to carry out
The project of merging or the fractionation of cell is often very much, and traditional technology is usually to pass through before Various types of data table import system
Written in code is write the form template of adaptation for each tables of data, is handled according to the cell of the form template tables of data,
Then, table cell handled well imports in database, and saves, to realize management and storage to Various types of data table.
However, traditional cell processing method needs to carry out written in code, for the type of service of Various types of data table, it is
Each tables of data writes the form template of adaptation, is easy to cause bulk redundancy code, meanwhile, during writing code, also
It needs to carry out the code write every test, modifies unreasonable code, the manpower and material resources for needing to expend and time carry out pipe
Reason and maintenance, cause the increase of maintenance cost, cause to handle the inefficient of data.
Summary of the invention
The embodiment of the present invention provides a kind of tables of data processing method, device, equipment and storage medium, to solve traditional data
The not high problem of tables of data treatment effeciency present in list processing technique.
A kind of tables of data processing method, comprising:
Obtain primary data information (pdi), wherein the primary data information (pdi) include service identification information and with the business
The corresponding original service tables of data of identification information, the original service tables of data include service attribute field and the business category
The property corresponding service attribute value of field;
In preset condition set, merging condition corresponding with the service identification information is obtained;
In the service attribute field, the objective attribute target attribute field for meeting the merging condition is searched, and according to the conjunction
And condition, the objective attribute target attribute field is merged, target matrix is obtained;
The target matrix is verified, check results are obtained;
If the check results be it is correct, using the target matrix as normal data table, and by the criterion numeral
It is stored in preset database according to table.
A kind of tables of data processing unit, comprising:
Data acquisition module, for obtaining primary data information (pdi), wherein the primary data information (pdi) includes service identification letter
Breath and original service tables of data corresponding with the service identification information, the original service tables of data includes service attribute
Field and the corresponding service attribute value of the service attribute field;
Condition obtains module, for obtaining merging corresponding with the service identification information in preset condition set
Condition;
Field merging module, for searching the objective attribute target attribute for meeting the merging condition in the service attribute field
Field, and according to the merging condition, the objective attribute target attribute field is merged, target matrix is obtained;
Table correction verification module obtains check results for verifying to the target matrix;
Table storage module, if for the check results be it is correct, using the target matrix as normal data
Table, and the normal data table is stored in preset database.
A kind of computer equipment, including memory, processor and storage are in the memory and can be in the processing
The computer program run on device, the processor realize the step of above-mentioned tables of data processing method when executing the computer program
Suddenly.
A kind of computer readable storage medium, the computer-readable recording medium storage have computer program, the meter
The step of calculation machine program realizes above-mentioned tables of data processing method when being executed by processor.
Above-mentioned tables of data processing method, device, equipment and storage medium, by Various types of data table import database it
Before, primary data information (pdi) is obtained, in preset condition set, is obtained corresponding with the service identification information in primary data information (pdi)
Merging condition, and according to merge condition, the attribute field in primary data information (pdi) is merged automatically, obtains target data
Table can be directed to the type of service of all kinds of raw data tables, directly generate the target matrix of this business of adaptation, can keep away
Exempt to expend a large amount of manpower and material resources to be each raw data table, write form template, reduce the code redundancy for writing form template,
To improve then the treatment effeciency of tables of data verifies target matrix, obtains normal data table, can guarantee
The accuracy of data information in normal data table, to reduce the maintenance cost of tables of data, convenient for tables of data management and
It saves.
Detailed description of the invention
In order to illustrate the technical solution of the embodiments of the present invention more clearly, below by institute in the description to the embodiment of the present invention
Attached drawing to be used is needed to be briefly described, it should be apparent that, the accompanying drawings in the following description is only some implementations of the invention
Example, for those of ordinary skill in the art, without any creative labor, can also be according to these attached drawings
Obtain other attached drawings.
Fig. 1 is an application environment schematic diagram of tables of data processing method in one embodiment of the invention;
Fig. 2 is a flow chart of tables of data processing method in one embodiment of the invention;
Fig. 3 is the implementation flow chart of step S2 in tables of data processing method in one embodiment of the invention;
Fig. 4 is the implementation flow chart of step S5 in tables of data processing method in one embodiment of the invention;
Fig. 5 is to carry out when check results are wrong in tables of data processing method in one embodiment of the invention to target matrix
One implementation flow chart of processing;
Fig. 6 is an implementation flow chart of query criteria tables of data in tables of data processing method in one embodiment of the invention;
Fig. 7 is the implementation flow chart for exporting normal data table in one embodiment of the invention in tables of data processing method;
Fig. 8 is a schematic diagram of tables of data processing unit in one embodiment of the invention;
Fig. 9 is a schematic diagram of computer equipment in one embodiment of the invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are some of the embodiments of the present invention, instead of all the embodiments.Based on this hair
Embodiment in bright, every other implementation obtained by those of ordinary skill in the art without making creative efforts
Example, shall fall within the protection scope of the present invention.
Fig. 1 shows application environment provided in an embodiment of the present invention, which includes server-side and client,
In, it is attached between server-side and client by network, client will be requested or be referred to for receiving request or instruction
Order is sent to server-side, and client specifically can be, but not limited to various personal computers, laptop, smart phone, plate
Computer and portable wearable device;Server-side for handling tables of data, server-side specifically can with independent server or
The server cluster of multiple server compositions is realized.Tables of data processing method provided in an embodiment of the present invention is applied to server-side.
Referring to Fig. 2, Fig. 2 shows the implementation processes of tables of data processing method provided in this embodiment.Details are as follows:
S1: primary data information (pdi) is obtained, wherein primary data information (pdi) includes service identification information and believes with service identification
The corresponding original service tables of data of manner of breathing, original service tables of data include service attribute field and the corresponding industry of service attribute field
Business attribute value.
In the present embodiment, service identification information refers to for unique identification original service tables of data, each original service
Tables of data has unique service identification information.Service identification information includes but is not limited to the business name of tables of data or the volume of tables of data
Number, herein with no restrictions, for example, service identification information is business name " value-added tax tax declaration ", " environment protection tax is paid taxes Shen
Report " or " export tariffs tax declaration " etc. or the number " 001 ", " 002 " or " 003 " of tables of data etc..Service attribute field is such as
" income ", " financial products transfer income " or " non-business income " etc..The corresponding service attribute value of service attribute field, such as
" financial products transfer income " corresponding service attribute value is " 200,000 yuan ", or " non-business income " corresponding service attribute value
For " 100,000 yuan " etc..
Specifically, the acquisition modes of primary data information (pdi) can specifically be but not limited to receive the original number that user imports
It is believed that breath, or timing obtain primary data information (pdi) from big data platform, wherein the original in primary data information (pdi) got
Each service attribute field and the corresponding service attribute value of service attribute field of beginning of the school year business tables of data separately exist in a line, and
The corresponding original service tables of data of same service identification information uses identical foundation forms, i.e., each original service tables of data
Gauge outfit it is consistent, original service tables of data is specifically as shown in table 1:
Table 1
S2: in preset condition set, merging condition corresponding with service identification information is obtained.
In the present embodiment, merging condition includes one or more condition entries, for restricting or determining the place to tables of data
Reason operation, preset condition set includes service identification information, and merging condition corresponding with service identification information, wherein
Service identification information at most corresponds to a merging condition, i.e., each service identification information can uniquely correspond to a merging condition,
It is also possible to no corresponding merging condition.
It should be noted that the condition of merging is configured according to practical business demand, herein with no restrictions.
S3: in service attribute field, searching the objective attribute target attribute field for meeting merging condition, and according to the condition of merging, right
Objective attribute target attribute field merges, and obtains target matrix.
In the present embodiment, objective attribute target attribute field is the service attribute field for merging according to merging condition.?
The mode that objective attribute target attribute field is found in original service tables of data specifically can be all industry traversed in original service tables of data
Business attribute field, detects service attribute field identical with the preset attribute field merged in condition, by the service attribute
Field, or can be by way of other lookups, herein with no restrictions as objective attribute target attribute field.
According to the condition of merging, merging objective attribute target attribute field, detailed process is as follows:
For each condition entry in the merging condition got, found and condition entry in original service tables of data to be processed
In identical service attribute field, as objective attribute target attribute field;
According to each condition entry, the first aim attribute field that will test is retained, and will test this
Other corresponding objective attribute target attribute fields of part item return to blank, i.e., objective attribute target attribute field are replaced with empty content, complete the condition
The merging of item.
It should be noted that during to objective attribute target attribute field, while each condition in parallel execution merging condition
?.
For example, continuing by taking the original service tables of data of table 1 as an example, if the service identification information got is that " value-added tax is received
Tax is declared ", a condition entry is " merging A1 to A5 " in corresponding merging condition in preset condition set, then according to this
Condition entry finds 5 that " A1 to A5 " corresponding service attribute field under " type one " of A column is " income " in table 1
Cell merges into the service attribute field " income " of 1 cell, i.e., will be in the first A1 cell that detected in table 1
Objective attribute target attribute field " income " retained, and the objective attribute target attribute field by A2 into A5 cell returns to blank, generates 1
The service attribute field " income " of a cell merges and completes, obtains target matrix, as shown in table 2.
Table 2
For example, continue by taking the tables of data of table 1 as an example, if the service identification information got is " value-added tax tax declaration ",
Corresponding merging condition is by the service attribute of " field contents are identical " in original service tables of data in preset condition set
Field merges, then is " income " by the service attribute field under " type one " of the A column in table 1 according to the condition of merging
Each cell merges into the service attribute field " income " of 1 cell;By the service attribute word under " type two " of B column
Section is each cell of " financial products transfer income ", merges into service attribute field " the financial products transfer of 1 cell
Income ";It is each cell of " miscellaneous receipt " by the service attribute field under " type two " of B column, merges into 1 cell
Service attribute field " miscellaneous receipt ";And by the service attribute field under " type two " of B column for " non-business income is (no
Include sale) " each cell, merge into the service attribute field " non-business income (do not include sale) " of 1 cell,
Tables of data after merging saves as target matrix, as shown in table 3.
Table 3
It should be noted that when column locations of the merging condition conditional item without containing cell where objective attribute target attribute field
Information, then while finding objective attribute target attribute field, the column locations letter of cell where will record the objective attribute target attribute field
Breath, and the column locations information is added in corresponding merging condition, for updating preset set of circumstances, it is convenient for subsequent
Quick export according to the column locations information realization updated in merging condition to tables of data.
For example, original service tables of data shown in table 4, if a service identification information corresponding one merges condition are as follows: by B column
Service attribute field under " type two " is each cell of " financial products transfer income ", merges into the industry of 1 cell
It is engaged in attribute field " financial products transfer income ".Due to not containing objective attribute target attribute field " financial products transfer in the merging condition
The column locations information of cell where income " then finds objective attribute target attribute field " finance according to the merging condition in table 4
The column locations information of commodity transfer income " is that " B3, B4 and B5 " therefore by the information of " B3, B4 and B5 are merged ", adds
It is added in corresponding merging condition, update condition set.
Table 4
It should be noted that according to the condition of merging, after being merged to original service tables of data, the target data of generation
The column locations Information invariability of cell in table, it is identical as the column locations information of cell in original service tables of data, i.e., pair
When original service tables of data merges, row or column neither will increase, will not delete row or column.
S4: verifying target matrix, obtains check results.
In the present embodiment, the mode verified to target matrix specifically can be using MD5 checking algorithm, pass through
Target will be calculated to check the correctness of service attribute value by executing hash operations to the service attribute value in target matrix
The hashed value of service attribute value is compared with the hashed value of service attribute value in original service tables of data in tables of data, if two
Hashed value is identical, then illustrates that target matrix is completely errorless, and the service attribute value in target matrix was not tampered, and may be used also
To be verified by other verification modes to target matrix, herein with no restrictions.Obtained check results include it is correct or
Mistake.
S5: if check results be it is correct, using target matrix as normal data table, and normal data table is stored in
In preset database.
In the present embodiment, after normal data table is according to verifying in step S4 to target matrix, obtained school
Testing result is correct corresponding target matrix.
It should be noted that normal data table is stored in preset database, it can specifically be converted into xml text
Part, preservation corresponding with service identification information in the database, facilitate subsequent inquiry and calling to normal data table, can also turn
It is changed to alternative document format, or does not convert and directly saves in a tabular form in the database, herein with no restrictions.
In the present embodiment, by primary data information (pdi) being obtained, in default item before Various types of data table imports database
In part set, merging condition corresponding with the service identification information in primary data information (pdi) is obtained, and according to the condition of merging, it is right
Attribute field in primary data information (pdi) is merged automatically, obtains target matrix, can be for all kinds of raw data tables
Type of service directly generates the target matrix of this business of adaptation, and it is each for can be avoided a large amount of manpower and material resources of consuming
Raw data table writes form template, reduces the code redundancy for writing form template, imitates to mention original text to the processing of tables of data
Then rate verifies target matrix, obtain normal data table, can guarantee the standard of data information in normal data table
True property, so that the maintenance cost of tables of data is reduced, convenient for the management and preservation to tables of data.
In one embodiment, as shown in figure 3, in step S2, i.e., in preset condition set, acquisition and service identification information
Corresponding merging condition specifically comprises the following steps:
S201: there is default merging condition corresponding with service identification information if concentrating in preset condition, will preset
Merging condition is as merging condition.
In the present embodiment, preset merging condition be it is corresponding with service identification information be stored in preset condition set, be
It is configured according to practical business demand, for being merged to service attribute field in original service tables of data.
For example, service identification information is " value-added tax tax declaration ", the corresponding default merging item in preset condition set
Part are as follows: merging service attribute field in the cell in original service tables of data under " type one " of A column is " income ";Merge B
Service attribute field is " financial products transfer income " in cell under " type two " of column;Under " type two " that merges B column
Cell in service attribute field be " miscellaneous receipt ";And service attribute in the cell under " type two " of merging B column
Field is " non-business income ".
S202:, will if default merging condition corresponding with service identification information is not present in preset condition set
Original service tables of data corresponding with service identification information is sent to auditor.
It in the present embodiment, is one-to-one due to presetting merging condition in preset condition set with service identification information
Relationship, but service identification information is an at most corresponding default merging condition, thus there are in preset condition set with business mark
Knowing the corresponding default merging condition of information is empty situation.
Specifically, when default merging condition corresponding with service identification information is not present in preset condition set,
In order to realize that the automation to the service attribute field of original service tables of data merges, to improve the processing effect of tables of data
Rate, can by original service tables of data, service identification information and lack default merging condition include send content in send
To auditor, the processing status of original service tables of data is understood in time convenient for auditor, and can be in time according to practical business
Demand supplements the merging condition of the original service tables of data suitable for the content information received.
It original service tables of data is sent to the mode of the transmission of auditor specifically can be but not limited to using mail, short
Letter or instant message, can also be other modes, herein with no restrictions.
S203: receiving the audit that auditor returns and merge condition, using audit merging condition as merging condition, and will audit
The preservation corresponding with service identification information of merging condition is into preset condition set.
In the present embodiment, audit merging condition refers to auditor according to practical business demand, and arrangement is suitable for receiving
To content information in original service tables of data merging condition.It, can be perfect using audit merging condition as merging condition
The corresponding merging condition that service identification information lacks in preset set of circumstances, timely update set of circumstances, further real
Now merge the raising of effect to the automation of original service tables of data.
Specifically, while auditor returns to audit merging condition, service identification information is also returned, therefore can be default
Set of circumstances in traverse, find the position of corresponding service identification information, and the audit received merging condition is incorporated into pre-
If set of circumstances in, it is corresponding with the service identification information found save.
In the present embodiment, on the one hand pass through the default merging condition being directly obtained as merging condition, convenient for subsequent
Original service tables of data is merged according to the merging condition, quickly generates corresponding target matrix;On the other hand, pass through
There will be no the original service tables of data of default merging condition to be sent to auditor, receives the audit that auditor returns and merges item
Part, and audit merging condition is updated to merging condition, it can more fully realize the automation to original service tables of data
Merge, to improve the treatment effeciency to tables of data on the whole.
In one embodiment, as shown in figure 4, verifying to target matrix in step S4, check results tool is obtained
Body includes the following steps:
S401: judge service attribute value in target matrix and the service attribute value in original service tables of data whether one
It causes.
Judge whether the service attribute value in target matrix and the service attribute value in original service tables of data are consistent
Detailed process is as follows:
In target matrix, reads and each contain the column locations letter of the Set cell of target service attribute value
Breath, the column locations information of such as one Set cell for containing target service attribute value are " 3 row of D column ";
In original service tables of data, reads and each contain the column locations of the original unit lattice of original service attribute value
Information, the column locations information of such as one original unit lattice for containing original service attribute value are " 8 row of E column ";
By the service attribute in the cell in target matrix and original service tables of data, having identical column locations information
Value is compared, and obtains comparison result.
Understanding can be facilitated by one embodiment, for example, after being merged due to original service tables of data, generation
The column locations Information invariability of cell in target matrix, thus, it is supposed that there is the mesh of one " 5 row of D column " in target matrix
Cell is marked, target service attribute value is " 5000 " in the Set cell, and ranks position is found in original service tables of data
Confidence breath is the original unit lattice of " 5 row of D column ", and original service attribute value is " 3000 " in the original unit lattice, by target service
Attribute value is compared with original service attribute value, obtains two inconsistent comparison results of attribute value.
S402: if judging result be it is consistent, check results be it is correct, otherwise, if judging result be it is inconsistent, verify
It as a result is mistake.
In the present embodiment, the comparing result according to obtained in step S401, if comparison result is that attribute value is consistent,
It indicates the target matrix obtained after merging, the case where error in data or data alteration does not occur, do not need further progress
The amendment of tables of data;If comparison result is to have attribute value inconsistent, then it represents that the target matrix obtained after merging has data wrong
The case where mistake or data alteration, need the amendment of further progress tables of data.
In this embodiment, target matrix is verified, obtains check results, can guarantee data in normal data table
The accuracy of information, so that the maintenance cost of tables of data is reduced, convenient for the management and preservation to tables of data.
In one embodiment, as shown in figure 5, after step s4, which further includes following steps:
S6: if check results are mistake, target matrix and original service tables of data is sent to auditor and carried out
Amendment.
In the present embodiment, it is mistake according to the check results that step S4 is obtained, then illustrates that target matrix there are data wrong
The case where mistake or data alteration.
Further, need to check results be mistake target matrix in, have error in data Set cell and
Target service attribute value carries out the label of error identification, and the mode of marked erroneous mark specifically can be symbol, figure or volume
Number etc., it is also possible to other forms, herein with no restrictions.
Specifically, auditor is according to receiving original service tables of data, to the target matrix comprising wrong mark mark into
Row amendment, mistake mark mark can allow auditor to grasp the cell there are error in data in time, and be modified in time, to protect
Demonstrate,prove the accuracy of target matrix.
S7: the amendment tables of data that auditor returns is received, and is saved using amendment tables of data as normal data table to data
In library.
In the present embodiment, the amendment tables of data auditor received returned is as normal data table, and and business
Identification information is corresponding to be saved in the database, can guarantee the accuracy of database Plays tables of data, and convenient for standard
The inquiry and management of tables of data.
In the present embodiment, by being wrong target matrix original service tables of data corresponding with its by check results
It is sent to auditor to be modified, and receives the amendment tables of data of auditor's return, using amendment tables of data as normal data table
It saves in the database, the tables of data there are error in data can be modified in time, guarantee database Plays tables of data
Accuracy, convenient for the inquiry and management to normal data table.
In one embodiment, as shown in fig. 6, after step s 5, which further includes following steps:
S8: if receiving the inquiry request of user's transmission, the inquiry identification information in inquiry request is obtained.
In the present embodiment, the concrete form for inquiring identification information is identical as service identification information, can be marked by inquiry
Know information, find identical service identification information in the database, to realize the inquiry to normal data table.
Specifically, since user is when needing to check tables of data or analyze, the request of inquiry tables of data can be issued,
Therefore, when receiving user and needing to inquire the request of tables of data, then the inquiry identification information carried in the request can be obtained,
Realize the subsequent inquiry to normal data table.
S9: target criteria data corresponding with the identical service identification information of identification information is inquired are obtained in the database
Table.
In the present embodiment, the side with the inquiry identic service identification information of identification information is found in the database
Method specifically can be the service identification information in ergodic data library, detect and inquire the completely the same business mark of identification information
Know the keyword in information, or selection inquiry identification information, filters out the service identification of same keyword in database
Information, and then according to inquiry identification information, from the service identification information for having same keyword, then filter out and inquiry mark letter
Completely the same service identification information is ceased, can also be other modes, can be specifically configured according to practical business demand, this
Place is with no restrictions.Target criteria tables of data is the normal data table to be inquired in the inquiry request of user's transmission.
Specifically, according to the inquiry identification information got in step S8, traversed in the database, when retrieving and
Then the completely the same service identification information of inquiry identification information can be obtained quickly then according to the service identification information found
Take target criteria tables of data corresponding with the service identification information.
S10: target criteria tables of data is shown.
In the present embodiment, show that the mode of target criteria tables of data specifically can be, in order to reflect mesh intuitionistic and concisely
The data in normal data table are marked, user's fast browsing is facilitated, are shown directly in the form of the table of target criteria tables of data, or
Person in order to more it is careful fully show target criteria tables of data in data, can graphically be shown in webpage, or
Person is other exhibition methods, herein with no restrictions.
In the present embodiment, according to the inquiry identification information in the inquiry request for receiving user's transmission, in the database
Service identification information identical with inquiry identification information is searched, and obtains the corresponding normal data table of the service identification information and opens up
Show, mode of operation is simple and efficient, can be realized the quick search to normal data table.
In one embodiment, as shown in fig. 7, after step s 5, which further includes following steps:
S11: if receiving the tables of data export instruction of user's transmission, the export mark in tables of data export instruction is obtained
Information.
In the present embodiment, the concrete form for exporting identification information is identical as service identification information, can be marked by export
Know information and find identical services identification information in database or preset set of circumstances, to realize to normal data table
Export.
Specifically, due to user need to export tables of data carry out in use, can issue export tables of data instruction, because
This can then obtain the export identification information carried in the instruction when receiving user and needing to export the instruction of tables of data, real
The existing subsequent export to normal data table.
S12: obtaining export normal data table corresponding with the identical service identification information of identification information is exported and target is closed
And condition.
In the present embodiment, according to export identification information, business identical with export identification information is found in the database
According to inquiry identification information in the concrete mode and step S10 of identification information, find in the database and inquiry identification information phase
With the mode that uses of service identification information it is identical, details are not described herein again.It is identical as export identification information that target, which merges condition,
Service identification information corresponding to merging condition.
Specifically, normal data corresponding with the identical service identification information of identification information is exported is obtained in the database
Table as export normal data table, and obtains service identification identical with export identification information in preset set of circumstances and believes
Corresponding merging condition is ceased, merges condition as target.
S13: merging condition according to target, and initial table is carried out cell span, generates tables of data template.
In the present embodiment, initial table specifically can be the clear data table initialized in excel software, be also possible to
The clear data table of the initialization of other spreadsheets, herein with no restrictions.
Specifically, condition is merged according to the target got in step s 12, according to the unit in the target merging condition
The column locations information of lattice merges cell in the initial table of excel software, for example, continuing to use table 3 in step S3
Example, be incorporated into column locations information in the corresponding merging condition of table 3 be " by B3, B4 and B5 in original service tables of data 3 into
Row merges ", then it is according to the column locations information of the cell in the target merging condition, B3, B4 and B5 in initial table is mono-
First lattice merge, and the tables of data of generation is as tables of data template.
Merge it should be noted that obtaining with target corresponding to the export identic service identification information of identification information
Condition is to be able to merge condition according to the target got, close automatically to the cell in the table of excel software
And be directly applied for normal data table and generate excel tables of data template, it avoids first passing through in the table of excel software artificial
Editor, setting are suitable for the form template of normal data table, reduce data redundancy and artificial workload.
S14: service attribute field and the corresponding service attribute value of service attribute field in normal data table will be exported, led
Enter in the corresponding cell of tables of data template, generates target and export tables of data.
Specifically, according to corresponding to the service identification information identical with export identification information got in step s 12
Export normal data table will be led according to the column locations information of cell in the tables of data template generated in excel software
Standard tables of data has the service attribute field and service attribute of identical column locations information with cell in tables of data template out
The corresponding service attribute value of field, imported into the corresponding cell of tables of data template, generates target and exports tables of data.
S15: output target exports tables of data.
In the present embodiment, by the target generated in step S14 export tables of data specifically can in excel software it is defeated
It out and shows, due to that synchronism output and can show multiple tables of data in excel software, number can be grasped in time convenient for user
According to the information of table.
In the present embodiment, by obtaining and export corresponding to the export identic service identification information of identification information
Normal data table and target merge condition, in order to merge condition according to the target got, automatically to the table of excel software
Cell in lattice merges, and avoids first passing through artificial setting in the table of excel software suitable for normal data table
Form template, then the case where import the benchmark service attribute field and benchmark service attribute value in normal data table, can will mark
Quasi- tables of data quickly exports in the table such as excel spreadsheet, to improve the export efficiency of normal data table.
It should be understood that the size of the serial number of each step is not meant that the order of the execution order in above-described embodiment, each process
Execution sequence should be determined by its function and internal logic, the implementation process without coping with the embodiment of the present invention constitutes any limit
It is fixed.
In one embodiment, a kind of tables of data processing unit is provided, number in the tables of data processing unit and above-described embodiment
It is corresponded according to list processing method.As shown in figure 8, the tables of data processing unit includes data acquisition module 801, condition acquisition mould
Block 802, field merging module 803, table correction verification module 804 and table storage module 805.Each functional module is described in detail such as
Under:
Data acquisition module 801, for obtaining primary data information (pdi), wherein primary data information (pdi) includes service identification letter
Breath and original service tables of data corresponding with service identification information, original service tables of data include service attribute field and industry
The corresponding service attribute value of business attribute field;
Condition obtains module 802, for obtaining merging item corresponding with service identification information in preset condition set
Part;
Field merging module 803, for searching the objective attribute target attribute field for meeting merging condition in service attribute field,
And according to the condition of merging, objective attribute target attribute field is merged, target matrix is obtained;
Table correction verification module 804 obtains check results for verifying to target matrix;
Table storage module 805, if for check results be it is correct, using target matrix as normal data table, and
Normal data table is stored in preset database.
Further, condition acquisition module 802 includes:
Condition query unit 8021, if there is default conjunction corresponding with service identification information for concentrating in preset condition
And condition, then using default merging condition as merging condition;
Table transmission unit 8022, if for there is no corresponding with service identification information pre- in preset condition set
If the condition of merging, then be sent to auditor for original service tables of data corresponding with service identification information;
Condition reception unit 8023, for receive auditor return audit merge condition, will audit merging condition as
Merging condition, and by the preservation corresponding with service identification information of audit merging condition into preset condition set.
Further, table correction verification module 804 includes:
Numerical value judging unit 8041, for judging in the service attribute value in target matrix and original service tables of data
Whether service attribute value is consistent;
As a result acquiring unit 8042, if for judging result be it is consistent, check results be it is correct, otherwise, if judge tie
Fruit be it is inconsistent, then check results be mistake.
Further, the tables of data processing unit further include:
Table correction module 806, if being mistake for check results, by target matrix and original service tables of data
Auditor is sent to be modified;
Table update module 807 for receiving the amendment tables of data of auditor's return, and will correct tables of data as standard
Tables of data is saved into database.
Further, the tables of data processing unit further include:
Request receiving module 808, if the inquiry request for receiving user's transmission, obtains the inquiry in inquiry request
Identification information;
Enquiry module 809 is identified, for obtaining service identification information pair identical with inquiry identification information in the database
The target criteria tables of data answered;
Table display module 810, for showing target criteria tables of data.
Further, the tables of data processing unit further include:
Command reception module 811, if the tables of data export instruction for receiving user's transmission, obtains tables of data export
Export identification information in instruction;
Data obtaining module 812, for obtaining export mark corresponding with the identical service identification information of identification information is exported
Quasi- tables of data and target merge condition;
Initial table is carried out cell span, generates data by template generation module 813 for merging condition according to target
Table template;
Table export module 814, for service attribute field and service attribute field pair in normal data table will to be exported
The service attribute value answered imports in the corresponding cell of tables of data template, generates target and exports tables of data;
Output of for ms module 815, for exporting target export tables of data.
Specific about tables of data processing unit limits the restriction that may refer to above for tables of data processing method,
This is repeated no more.Modules in above-mentioned tables of data processing unit 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 9.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 saving tables of data.The network interface of the computer equipment is used to connect with external terminal by network
Connect letter.To realize a kind of tables of data processing method when the computer program is executed by processor.
In one embodiment, a kind of computer equipment is provided, including memory, processor and storage are on a memory
And the computer program that can be run on a processor, processor realize above-described embodiment data list processing when executing computer program
The step of method, such as step S1 shown in Fig. 2 to step S5.Alternatively, processor realizes above-mentioned reality when executing computer program
Apply the function of each module/unit of tables of data processing unit in example, such as module 801 shown in Fig. 8 is to the function of module 805.For
It avoids repeating, which is not described herein again.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated
Tables of data processing method in above method embodiment is realized when machine program is executed by processor, alternatively, the computer program is located
Manage the function that each module/unit in tables of data processing unit in above-mentioned apparatus embodiment is realized when device executes.To avoid repeating, this
In repeat no more.
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..
It is apparent to those skilled in the art that for convenience of description and succinctly, only with above-mentioned each function
Can unit, module division progress for example, in practical application, can according to need and by above-mentioned function distribution by different
Functional unit, module are completed, i.e., the internal structure of described device is divided into different functional unit or module, more than completing
The all or part of function of description.
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations;Although referring to aforementioned reality
Applying example, invention is explained in detail, those skilled in the art should understand that, it still can be to aforementioned each
Technical solution documented by embodiment is modified or equivalent replacement of some of the technical features;And these are modified
Or replacement, the spirit and scope for technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution should all
It is included within protection scope of the present invention.
Claims (10)
1. a kind of tables of data processing method, which is characterized in that the tables of data processing method includes:
Obtain primary data information (pdi), wherein the primary data information (pdi) include service identification information and with the service identification
The corresponding original service tables of data of information, the original service tables of data include service attribute field and the service attribute word
The corresponding service attribute value of section;
In preset condition set, merging condition corresponding with the service identification information is obtained;
In the service attribute field, the objective attribute target attribute field for meeting the merging condition is searched, and according to the merging item
Part merges the objective attribute target attribute field, obtains target matrix;
The target matrix is verified, check results are obtained;
If the check results be it is correct, using the target matrix as normal data table, and by the normal data table
It is stored in preset database.
2. tables of data processing method as described in claim 1, which is characterized in that it is described in preset condition set, obtain with
The corresponding merging condition of the service identification information includes:
It, will be described pre- if being concentrated in the preset condition and there is default merging condition corresponding with the service identification information
If the condition of merging is as the merging condition;
If the default merging condition corresponding with the service identification information is not present in the preset condition set,
The original service tables of data corresponding with the service identification information is sent to auditor;
It receives the audit that the auditor returns and merges condition, using the audit merging condition as the merging condition, and will
The audit merging condition preservation corresponding with the service identification information is into the preset condition set.
3. tables of data processing method as claimed in claim 1 or 2, which is characterized in that described to be carried out to the target matrix
Verification, obtaining check results includes:
Judge service attribute value in the target matrix and the service attribute value in the original service tables of data whether one
It causes;
If judging result be it is consistent, the check results be it is correct, otherwise, if judging result be inconsistent, the verification
It as a result is mistake.
4. tables of data processing method as claimed in claim 3, which is characterized in that carry out school to the target matrix described
It tests, after obtaining check results, the tables of data processing method further include:
If the check results are mistake, the target matrix and the original service tables of data are sent to described examine
Core person is modified;
The amendment tables of data that the auditor returns is received, and is saved using the amendment tables of data as normal data table to described
In database.
5. such as the described in any item tables of data processing methods of Claims 1-4, which is characterized in that if being tied in the verification
Fruit be it is correct, then using the target matrix as normal data table, and the normal data table is stored in preset data
After in library, the tables of data processing method further include:
If receiving the inquiry request of user's transmission, the inquiry identification information in the inquiry request is obtained;
The corresponding target criteria of identical with the inquiry identification information service identification information is obtained in the database
Tables of data;
Show the target criteria tables of data.
6. such as the described in any item tables of data processing methods of Claims 1-4, which is characterized in that if being tied in the verification
Fruit be it is correct, then using the target matrix as normal data table, and the normal data table is stored in preset data
After in library, the tables of data processing method further include:
If receiving the tables of data export instruction that the user sends, the export mark in the tables of data export instruction is obtained
Information;
Obtain the corresponding export normal data table of identical with the export identification information service identification information and target conjunction
And condition;
Merge condition according to the target, initial table is subjected to cell span, generates tables of data template;
By the service attribute field and the corresponding service attribute value of the service attribute field in the export normal data table, lead
Enter in the corresponding cell of the tables of data template, generates target and export tables of data;
Export the target export tables of data.
7. a kind of tables of data processing unit, which is characterized in that the tables of data processing unit includes:
Data acquisition module, for obtaining primary data information (pdi), wherein the primary data information (pdi) include service identification information with
And original service tables of data corresponding with the service identification information, the original service tables of data include service attribute field
Service attribute value corresponding with the service attribute field;
Condition obtains module, for obtaining merging condition corresponding with the service identification information in preset condition set;
Field merging module, for searching the objective attribute target attribute field for meeting the merging condition in the service attribute field,
And according to the merging condition, the objective attribute target attribute field is merged;
Table generation module saves as number of targets for the corresponding original service tables of data of objective attribute target attribute field after merging
According to table;
Table correction verification module obtains check results for verifying to the target matrix;
Table storage module, if for the check results be it is correct, using the target matrix as normal data table, and
The normal data table is stored in preset database.
8. tables of data processing unit as claimed in claim 7, which is characterized in that the condition obtains module and includes:
Condition query unit, if there is default conjunction corresponding with the service identification information for concentrating in the preset condition
And condition, then using the default merging condition as the merging condition;
Table transmission unit, if for institute corresponding with the service identification information to be not present in the preset condition set
Default merging condition is stated, then the original service tables of data corresponding with the service identification information is sent to auditor;
Condition reception unit merges condition for receiving the audit that the auditor returns, using the audit merging condition as
The merging condition, and save the audit merging condition is corresponding with the service identification information to the preset condition set
In.
9. a kind of computer equipment, including memory, processor and storage are in the memory and can be in the processor
The computer program of upper operation, which is characterized in that the processor realized when executing the computer program as claim 1 to
The step of any one of 6 tables of data processing method.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, and feature exists
In the step of realization tables of data processing method as described in any one of claim 1 to 6 when the computer program is executed by processor
Suddenly.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811008790.2A CN109254969A (en) | 2018-08-31 | 2018-08-31 | Tables of data processing method, device, equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811008790.2A CN109254969A (en) | 2018-08-31 | 2018-08-31 | Tables of data processing method, device, equipment and storage medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109254969A true CN109254969A (en) | 2019-01-22 |
Family
ID=65049458
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811008790.2A Pending CN109254969A (en) | 2018-08-31 | 2018-08-31 | Tables of data processing method, device, equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109254969A (en) |
Cited By (24)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110362569A (en) * | 2019-06-06 | 2019-10-22 | 口碑(上海)信息技术有限公司 | The method of calibration and device of tables of data, electronic equipment, storage medium |
CN110413614A (en) * | 2019-07-09 | 2019-11-05 | 北京三快在线科技有限公司 | A kind of method and device that tables of data generates |
CN110502519A (en) * | 2019-08-26 | 2019-11-26 | 北京启迪区块链科技发展有限公司 | A kind of method, apparatus of data aggregate, equipment and storage medium |
CN110737642A (en) * | 2019-09-05 | 2020-01-31 | 平安科技(深圳)有限公司 | Database information analysis method, database information analysis device, computer device and storage medium |
CN111046632A (en) * | 2019-11-29 | 2020-04-21 | 智器云南京信息科技有限公司 | Data extraction and conversion method, system, storage medium and electronic equipment |
CN111143355A (en) * | 2019-12-10 | 2020-05-12 | 北京字节跳动网络技术有限公司 | Data processing method and device |
CN111143401A (en) * | 2019-12-27 | 2020-05-12 | 中国银行股份有限公司 | Query information processing method and device |
CN111626882A (en) * | 2020-05-28 | 2020-09-04 | 泰康保险集团股份有限公司 | Data detection method and device, computer readable medium and electronic equipment |
CN112073174A (en) * | 2020-07-28 | 2020-12-11 | 广州骏伯网络科技有限公司 | Communication account decryption method, device, equipment, storage medium and information interaction system |
CN112099898A (en) * | 2020-11-06 | 2020-12-18 | 广州市玄武无线科技股份有限公司 | Form processing system and method based on Web front end |
WO2020253069A1 (en) * | 2019-06-17 | 2020-12-24 | 平安科技(深圳)有限公司 | Table data modification method and apparatus, and electronic device and storage medium |
CN112835904A (en) * | 2021-02-04 | 2021-05-25 | 北京电解智科技有限公司 | Data processing method and data processing device |
CN113239019A (en) * | 2021-06-03 | 2021-08-10 | 锋泾(中国)建材集团有限公司 | Data migration method and system between ERP systems, electronic device and medium |
CN113495805A (en) * | 2020-03-19 | 2021-10-12 | 阿里巴巴集团控股有限公司 | Data processing method, node determination method, device, equipment and medium |
CN113505575A (en) * | 2021-07-09 | 2021-10-15 | 中国工商银行股份有限公司 | Data processing method, device, equipment and storage medium |
CN113626439A (en) * | 2021-08-17 | 2021-11-09 | 未鲲(上海)科技服务有限公司 | Data processing method and device, data processing equipment and storage medium |
CN113792039A (en) * | 2021-03-15 | 2021-12-14 | 北京京东振世信息技术有限公司 | Data processing method and device, electronic equipment and storage medium |
CN114140122A (en) * | 2021-12-08 | 2022-03-04 | 工银科技有限公司 | Credit certificate transfer method and device |
CN114416700A (en) * | 2022-01-21 | 2022-04-29 | 中国银行股份有限公司 | Customer information management method and device |
CN114579583A (en) * | 2022-05-05 | 2022-06-03 | 杭州太美星程医药科技有限公司 | Form data processing method and device and computer equipment |
CN114756556A (en) * | 2022-06-15 | 2022-07-15 | 建信金融科技有限责任公司 | Method, device, electronic equipment and computer readable medium for processing account data |
CN114968827A (en) * | 2022-08-01 | 2022-08-30 | 江铃汽车股份有限公司 | Vehicle bus signal information checking method and system |
CN115328892A (en) * | 2022-10-14 | 2022-11-11 | 互联时刻(北京)信息科技有限公司 | Business form data structure processing method, system, electronic device and medium |
CN116303392A (en) * | 2023-03-02 | 2023-06-23 | 重庆市规划和自然资源信息中心 | Multi-source data table management method for real estate registration data |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050251733A1 (en) * | 2004-05-04 | 2005-11-10 | Oracle International Corporation | Data insertion from a database into a fixed electronic template form |
CN102323927A (en) * | 2011-07-29 | 2012-01-18 | 无锡永中软件有限公司 | Method for combining documents |
WO2015117429A1 (en) * | 2014-07-16 | 2015-08-13 | 中兴通讯股份有限公司 | Method and device for merging database contents |
CN106933899A (en) * | 2015-12-30 | 2017-07-07 | 远光软件股份有限公司 | Form processing method and device |
-
2018
- 2018-08-31 CN CN201811008790.2A patent/CN109254969A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050251733A1 (en) * | 2004-05-04 | 2005-11-10 | Oracle International Corporation | Data insertion from a database into a fixed electronic template form |
CN102323927A (en) * | 2011-07-29 | 2012-01-18 | 无锡永中软件有限公司 | Method for combining documents |
WO2015117429A1 (en) * | 2014-07-16 | 2015-08-13 | 中兴通讯股份有限公司 | Method and device for merging database contents |
CN106933899A (en) * | 2015-12-30 | 2017-07-07 | 远光软件股份有限公司 | Form processing method and device |
Cited By (33)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110362569A (en) * | 2019-06-06 | 2019-10-22 | 口碑(上海)信息技术有限公司 | The method of calibration and device of tables of data, electronic equipment, storage medium |
WO2020253069A1 (en) * | 2019-06-17 | 2020-12-24 | 平安科技(深圳)有限公司 | Table data modification method and apparatus, and electronic device and storage medium |
CN110413614A (en) * | 2019-07-09 | 2019-11-05 | 北京三快在线科技有限公司 | A kind of method and device that tables of data generates |
CN110502519A (en) * | 2019-08-26 | 2019-11-26 | 北京启迪区块链科技发展有限公司 | A kind of method, apparatus of data aggregate, equipment and storage medium |
CN110502519B (en) * | 2019-08-26 | 2022-04-29 | 北京启迪区块链科技发展有限公司 | Data aggregation method, device, equipment and storage medium |
CN110737642A (en) * | 2019-09-05 | 2020-01-31 | 平安科技(深圳)有限公司 | Database information analysis method, database information analysis device, computer device and storage medium |
CN110737642B (en) * | 2019-09-05 | 2022-09-02 | 平安科技(深圳)有限公司 | Database information analysis method, database information analysis device, computer device and storage medium |
CN111046632B (en) * | 2019-11-29 | 2023-11-10 | 智器云南京信息科技有限公司 | Data extraction and conversion method, system, storage medium and electronic equipment |
CN111046632A (en) * | 2019-11-29 | 2020-04-21 | 智器云南京信息科技有限公司 | Data extraction and conversion method, system, storage medium and electronic equipment |
CN111143355A (en) * | 2019-12-10 | 2020-05-12 | 北京字节跳动网络技术有限公司 | Data processing method and device |
CN111143355B (en) * | 2019-12-10 | 2023-04-25 | 北京字节跳动网络技术有限公司 | Data processing method and device |
CN111143401A (en) * | 2019-12-27 | 2020-05-12 | 中国银行股份有限公司 | Query information processing method and device |
CN113495805B (en) * | 2020-03-19 | 2024-06-07 | 阿里巴巴集团控股有限公司 | Data processing method, node determining method, device, equipment and medium |
CN113495805A (en) * | 2020-03-19 | 2021-10-12 | 阿里巴巴集团控股有限公司 | Data processing method, node determination method, device, equipment and medium |
CN111626882A (en) * | 2020-05-28 | 2020-09-04 | 泰康保险集团股份有限公司 | Data detection method and device, computer readable medium and electronic equipment |
CN112073174A (en) * | 2020-07-28 | 2020-12-11 | 广州骏伯网络科技有限公司 | Communication account decryption method, device, equipment, storage medium and information interaction system |
CN112073174B (en) * | 2020-07-28 | 2023-06-27 | 广州骏伯网络科技有限公司 | Communication account decryption method, device, equipment, storage medium and information interaction system |
CN112099898A (en) * | 2020-11-06 | 2020-12-18 | 广州市玄武无线科技股份有限公司 | Form processing system and method based on Web front end |
CN112099898B (en) * | 2020-11-06 | 2021-02-09 | 广州市玄武无线科技股份有限公司 | Form processing system and method based on Web front end |
CN112835904A (en) * | 2021-02-04 | 2021-05-25 | 北京电解智科技有限公司 | Data processing method and data processing device |
CN113792039A (en) * | 2021-03-15 | 2021-12-14 | 北京京东振世信息技术有限公司 | Data processing method and device, electronic equipment and storage medium |
CN113792039B (en) * | 2021-03-15 | 2024-03-01 | 北京京东振世信息技术有限公司 | Data processing method and device, electronic equipment and storage medium |
CN113239019A (en) * | 2021-06-03 | 2021-08-10 | 锋泾(中国)建材集团有限公司 | Data migration method and system between ERP systems, electronic device and medium |
CN113505575A (en) * | 2021-07-09 | 2021-10-15 | 中国工商银行股份有限公司 | Data processing method, device, equipment and storage medium |
CN113626439A (en) * | 2021-08-17 | 2021-11-09 | 未鲲(上海)科技服务有限公司 | Data processing method and device, data processing equipment and storage medium |
CN114140122A (en) * | 2021-12-08 | 2022-03-04 | 工银科技有限公司 | Credit certificate transfer method and device |
CN114416700A (en) * | 2022-01-21 | 2022-04-29 | 中国银行股份有限公司 | Customer information management method and device |
CN114579583A (en) * | 2022-05-05 | 2022-06-03 | 杭州太美星程医药科技有限公司 | Form data processing method and device and computer equipment |
CN114756556A (en) * | 2022-06-15 | 2022-07-15 | 建信金融科技有限责任公司 | Method, device, electronic equipment and computer readable medium for processing account data |
CN114968827A (en) * | 2022-08-01 | 2022-08-30 | 江铃汽车股份有限公司 | Vehicle bus signal information checking method and system |
CN115328892A (en) * | 2022-10-14 | 2022-11-11 | 互联时刻(北京)信息科技有限公司 | Business form data structure processing method, system, electronic device and medium |
CN116303392A (en) * | 2023-03-02 | 2023-06-23 | 重庆市规划和自然资源信息中心 | Multi-source data table management method for real estate registration data |
CN116303392B (en) * | 2023-03-02 | 2023-09-01 | 重庆市规划和自然资源信息中心 | Multi-source data table management method for real estate registration data |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109254969A (en) | Tables of data processing method, device, equipment and storage medium | |
CN108573371B (en) | Data approval method, device, computer equipment and storage medium | |
WO2020186786A1 (en) | File processing method and apparatus, computer device and storage medium | |
CN110163735B (en) | Tax-related data processing method and device, computer equipment and storage medium | |
CN109474578A (en) | Message method of calibration, device, computer equipment and storage medium | |
CN109558440A (en) | Batch data processing method, device, computer equipment and storage medium | |
CN111027295B (en) | Data processing method, device, computer equipment and storage medium | |
WO2020134989A1 (en) | Excel data import method and apparatus, and computer device and storage medium | |
CN111190901B (en) | Business data storage method and device, computer equipment and storage medium | |
CN109062925A (en) | Automatically generate the method, apparatus, computer equipment and storage medium of insert sentence | |
CN110147365B (en) | Method, device, equipment and medium for checking business data and financial data | |
CN108595276A (en) | Processing method, system, computer equipment and the storage medium of service logic | |
CN112286934A (en) | Database table importing method, device, equipment and medium | |
CN113191122B (en) | Service-oriented construction project electronic file and electronic file four-way detection method | |
CN107247767A (en) | A kind of method and device that database is imported by formatted data files | |
CN113220777A (en) | Service data processing method and device, computer equipment and storage medium | |
CN101272222A (en) | Restriction calibration method and device | |
CN109410069A (en) | Settlement data processing method, device, computer equipment and storage medium | |
CN114490664A (en) | Data verification method and device, computer equipment and storage medium | |
CN113504957A (en) | Table data processing method and device, computer equipment and storage medium | |
CN113434734A (en) | Method, device, equipment and storage medium for generating file and reading file | |
KR101737575B1 (en) | Method and device for verifying data based on sql sentences generated automatically | |
CN103150408A (en) | System and method for finding and accessing database in real-time databases according to roll call | |
CN112347095B (en) | Data table processing method, device and server | |
US20220100732A1 (en) | Big data regression verification method and big data regression verification apparatus |
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 |