CN108009190A - A kind of data export method, data guiding system and computer installation - Google Patents
A kind of data export method, data guiding system and computer installation Download PDFInfo
- Publication number
- CN108009190A CN108009190A CN201710706107.1A CN201710706107A CN108009190A CN 108009190 A CN108009190 A CN 108009190A CN 201710706107 A CN201710706107 A CN 201710706107A CN 108009190 A CN108009190 A CN 108009190A
- Authority
- CN
- China
- Prior art keywords
- export
- attribute
- data
- file
- name
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 47
- 238000009434 installation Methods 0.000 title claims abstract description 11
- 238000004590 computer program Methods 0.000 claims description 12
- 238000012163 sequencing technique Methods 0.000 claims description 6
- 230000008676 import Effects 0.000 claims description 5
- 239000002699 waste material Substances 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 20
- 238000004321 preservation Methods 0.000 description 6
- 230000008901 benefit Effects 0.000 description 3
- 239000000463 material Substances 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
- G06F16/164—File meta data generation
- G06F16/166—File name conversion
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention, which proposes a kind of data export method, data guiding system, computer installation and computer-readable recording medium, data export method, to be included：Receive export condition；According to export condition generation export name；Judge that export saves contents down with the presence or absence of the file with export name；When export saves contents down there is no during the file with export name, file of the foundation with export name, data are write into file, then the data in file are exported；When export save contents it is lower exist with export name file when, directly by file data export.It can be prevented by the present invention under the same terms, identical data be performed a plurality of times the write operation of data base querying and file, the waste of resource can be avoided.
Description
Technical field
The present invention relates to data to export technical field, in particular to a kind of data export method, data export system
System, computer installation and computer-readable recording medium.
Background technology
In correlation technique, financial settlement report that data system includes, income statement etc. are directed to leading for report data
Go out, and derived data volume is relatively large, and occur that a large amount of identical datas export multiple situation, and data volume is larger
Situation can increase the load of server, system and database, easily slow down it is other request processing times, can also reduce
How the handling capacity of system, therefore, prevent from performing identical data under the same terms multiple data base querying and file write-in behaviour
Making, avoid the waste of resource becomes urgent problem to be solved.
The content of the invention
It is contemplated that at least solve one of technical problem present in the prior art or correlation technique.
For this reason, one aspect of the present invention is to propose a kind of data export method.
Another aspect of the present invention is to propose a kind of data guiding system.
Another aspect of the invention is to propose a kind of computer installation.
An additional aspect of the present invention is to propose a kind of computer-readable recording medium.
In view of this, according to an aspect of the present invention, it proposes a kind of data export method, including：Receive export bar
Part；According to export condition generation export name；Judge that export saves contents down to whether there is with export name
File；When export saves contents down there is no during the file with export name, foundation has the text of export name
Part, data are write into file, then the data in file are exported；When export save contents it is lower exist there is export
During the file of name, directly the data in file are exported.
Above-mentioned data export method according to the present invention, can also have following technical characteristic：
In any of the above-described technical solution, it is preferable that according to the step of export condition generation export name, specific bag
Include：According to export condition generation export unique encodings；According to export unique encodings generation export name.
In any of the above-described technical solution, it is preferable that according to the step of export condition generation export unique encodings, specific bag
Include：The attribute set in export condition is obtained, attribute set includes multiple attributes；All properties are ranked up；Circulation time
Go through all properties generation export unique encodings.
In any of the above-described technical solution, it is preferable that all properties are ranked up, are specifically included：According to Property Name
All properties are ranked up.
In any of the above-described technical solution, it is preferable that the step of generation of searching loop all properties exports unique encodings, tool
Body includes：Obtain the property value of the first attribute in all properties；The volume of the first attribute is obtained according to the property value of the first attribute
Code；Obtain the property value of next attribute；The coding of next attribute is obtained according to the property value of next attribute, until all properties
Coding is all obtained and completed；Export unique encodings are calculated according to the coding of all properties.
In any of the above-described technical solution, it is preferable that according to the property value of the first attribute obtain the first attribute coding and/
Or the step of coding of next attribute obtained according to the property value of next attribute, specifically include：Judge the property value of the first attribute
And/or whether the property value of next attribute is empty；When the property value of the first attribute and/or the property value of next attribute are empty,
It is 0 by the encoding setting of the coding of the first attribute and/or next attribute；Property value and/or next attribute when the first attribute
When property value is not empty, the coding of the first attribute and/or the coding of next attribute are obtained.
In any of the above-described technical solution, it is preferable that the step of calculating export unique encodings according to the coding of all properties, tool
Body includes：According to the coding of all properties, export unique encodings are calculated by formula；Formula is
Wherein, D is export unique encodings, and M is preset value, and n is the number of all properties, and S is the coding of attribute, 0≤i≤n, D0=0.
In any of the above-described technical solution, it is preferable that the data export method in any of the above-described, according to export only
One coding generation export name, specifically includes：According to export unique encodings, export name is generated according to preset format.
In any of the above-described technical solution, it is preferable that preset format is export unique encodings _ report form type file suffixes.
According to another aspect of the present invention, it is proposed that a kind of data guiding system, including：Receiving unit, for receiving
Export condition；Generation unit, for according to export condition generation export name；First judging unit, for judging export text
Part saves contents down with the presence or absence of the file with export name；Import unit, for saving contents down not when export
During in the presence of file with export name, the file with export name is established, data are write into file；Export is single
Member, for the data in file to be exported；Lead-out unit, be additionally operable to when export save contents it is lower exist there is export
During the file of name, directly the data in file are exported.
Above-mentioned data guiding system according to the present invention, can also have following technical characteristic：
In any of the above-described technical solution, it is preferable that generation unit, is specifically used for：According to export condition generation export only
One coding；And according to export unique encodings generation export name.
In any of the above-described technical solution, it is preferable that generation unit, including：First acquisition unit, bar is exported for obtaining
Attribute set in part, attribute set include multiple attributes；Sequencing unit, for being ranked up to all properties；Generation is single
Member, export unique encodings are generated for searching loop all properties.
In any of the above-described technical solution, it is preferable that sequencing unit, specifically for according to Property Name to all properties into
Row sequence.
In any of the above-described technical solution, it is preferable that generation unit, further includes：Second acquisition unit, it is all for obtaining
The property value of the first attribute in attribute；The coding of the first attribute is obtained according to the property value of the first attribute；Obtain next attribute
Property value；The coding of next attribute is obtained according to the property value of next attribute, until the coding of all properties has all obtained
Into；Computing unit, for calculating export unique encodings according to the coding of all properties.
In any of the above-described technical solution, it is preferable that second acquisition unit, is specifically used for：Judge the attribute of the first attribute
Whether the property value of value and/or next attribute is empty；When the property value of the first attribute and/or the property value of next attribute are sky
When, it is 0 by the encoding setting of the coding of the first attribute and/or next attribute；Property value and/or next attribute when the first attribute
Property value for it is empty when, obtain the coding of the first attribute and/or the coding of next attribute.
In any of the above-described technical solution, it is preferable that computing unit, is specifically used for：According to the coding of all properties, pass through
Formula calculates export unique encodings；Formula isWherein, D is export unique encodings, and M is default
Value, n be all properties number, S be attribute coding, 0≤i≤n, D0=0.
In any of the above-described technical solution, it is preferable that generation unit, is specifically used for：According to export unique encodings, according to pre-
If form generates export name.
In any of the above-described technical solution, it is preferable that preset format is export unique encodings _ report form type file suffixes.
According to a further aspect of the invention, it is proposed that a kind of computer installation, including memory, processor and be stored in
On memory and the computer program that can run on a processor, processor realize such as any of the above-described when performing computer program
In data export method the step of.
According to a further aspect of the invention, it is proposed that a kind of computer-readable recording medium, is stored thereon with computer
Program, is realized when computer program is executed by processor such as the step of data export method in any of the above-described.
The present invention is not present in the case where export saves contents and phase (is obtained) by exporting unique encodings with export name
With file when first establish and carry out data export after file storage data again, realize the automatic name of export, improve work
Make efficiency.It is then that the data in this file are straight when there is the file identical with export name under the catalogue that export preserves
Export is connect, can prevent from identical data being performed under the same terms for users to use the write-in of multiple data base querying and file
Operation, mitigates the burden of database loads and system, shortens the time of other request processing, mitigates the occupancy of server resource.
The additional aspect and advantage of the present invention will become obvious in following description section, or the practice by the present invention
Recognize.
Brief description of the drawings
The above-mentioned and/or additional aspect and advantage of the present invention will become in the description from combination accompanying drawings below to embodiment
Substantially and it is readily appreciated that, wherein：
Fig. 1 shows the flow diagram of the data export method of one embodiment of the present of invention；
Fig. 2 shows the flow diagram of the data export method of an alternative embodiment of the invention；
Fig. 3 shows the flow diagram of the data export method of an alternative embodiment of the invention；
Fig. 4 shows the flow diagram of the data export method of an alternative embodiment of the invention；
Fig. 5 shows the flow diagram of the data export method of an alternative embodiment of the invention；
Fig. 6 shows the schematic block diagram of the data guiding system of one embodiment of the present of invention；
Fig. 7 a show the schematic block diagram of the data guiding system of an alternative embodiment of the invention；
Fig. 7 b show the schematic block diagram of the data guiding system of an alternative embodiment of the invention；
Fig. 8 shows the export unique encodings generating algorithm flow diagram of the specific embodiment of the present invention；
Fig. 9 shows the schematic block diagram of the computer installation of one embodiment of the present of invention.
Embodiment
It is to better understand the objects, features and advantages of the present invention, below in conjunction with the accompanying drawings and specific real
Mode is applied the present invention is further described in detail.It should be noted that in the case where there is no conflict, the implementation of the application
Feature in example and embodiment can be mutually combined.
Many details are elaborated in the following description to facilitate a thorough understanding of the present invention, still, the present invention may be used also
To be implemented using other different from other modes described here, therefore, protection scope of the present invention is not limited to following public affairs
The limitation for the specific embodiment opened.
The embodiment of first aspect present invention, proposes a kind of data export method, and Fig. 1 shows the implementation of the present invention
The flow diagram of the data export method of example.Wherein, this method includes：
Step 102, export condition is received；
Step 104, according to export condition generation export name；
Step 106, judge that export saves contents down with the presence or absence of the file with export name；
Step 108, when export saves contents down there is no during the file with export name, establishing has export
The file of filename, data are write into file, then the data in file are exported；
Step 110, when export save contents it is lower exist with export name file when, directly by file
Data export.
Data export method provided by the invention, first user submit export condition, the export condition submitted according to user
The unique filename for wanting export of generation, judges that export saves contents down and whether there is with export name
File because the file of export is entitled unique, unduplicated, when export save contents it is lower not with export
During the identical file of filename, the export save contents it is lower establish the file with the export name, and will want
Derived data write this document；Finally the data in the file of preservation are exported with for users to use.Pass through the present invention, user
Wanted data can be easily exported, the automatic name of export can also be realized, improve work efficiency.When judging to lead
Go out under the catalogue of file preservation when there is the file identical with export name, the data in this file are directly exported for
Family uses, and can prevent from performing identical data under the same terms the write operation of multiple data base querying and file, mitigate number
According to storehouse load and the burden of system, shorten the time that other requests are handled, mitigate the occupancy of server resource.
Fig. 2 shows the flow diagram of the data export method of an alternative embodiment of the invention.Wherein, this method bag
Include：
Step 202, export condition is received；
Step 204, according to export condition generation export unique encodings, according to export unique encodings generation export name；
Step 206, judge that export saves contents down with the presence or absence of the file with export name, work as export
Save contents when lower presence has the file of export name and be directly entered step 210；
Step 208, when export saves contents down there is no during the file with export name, establishing has export
The file of filename, and data are write into file；
Step 210, the data in file are exported.
In this embodiment, after user submits export condition, all conditions is arranged and calculate the unique volume of export
Code；Export name is generated by rule by the export unique encodings calculated, that is, exports unique encodings _ report form type files
Suffix, such as：1234567890_ income statement .xlsx, filename can be automatically generated by the export unique encodings calculated,
The mode manually inputted without user is derived file designation, saves the operating time of user, improves work effect
Rate.
Fig. 3 shows the flow diagram of the data export method of an alternative embodiment of the invention.Wherein, this method bag
Include：
Step 302, export condition is received；
Step 304, the attribute set in export condition is obtained, attribute set includes multiple attributes；According to Property Name
All properties are ranked up；Searching loop all properties generation export unique encodings；
Step 306, according to export unique encodings generation export name；
Step 308, judge that export saves contents down with the presence or absence of the file with export name, work as export
Save contents when lower presence has the file of export name and enter step 312；
Step 310, when export saves contents down there is no during the file with export name, establishing has export
The file of filename, and data are write into file；
Step 312, the data in file are exported.
In this embodiment, the step of calculating export unique encodings according to export condition includes：Initialization export is unique to compile
Code, makes Unique Code (export unique encodings)=0；All properties set is obtained, all properties are arranged by Property Name
Sequence obtains attribute set, and all properties in cycle attribute set calculate generation export unique encodings.By to user setting
Export condition is arranged to obtain export unique encodings, and guarantee is provided for the name of the export of generation.
Fig. 4 shows the flow diagram of the data export method of an alternative embodiment of the invention.Wherein, this method bag
Include：
Step 402, export condition is received；
Step 404, the attribute set in export condition is obtained, attribute set includes multiple attributes；According to Property Name
All properties are ranked up；
Step 406, the property value of the first attribute in all properties is obtained；First is obtained according to the property value of the first attribute
The coding of attribute；Obtain the property value of next attribute；The coding of next attribute is obtained according to the property value of next attribute, until institute
The coding for having attribute, which all obtains, to be completed；Export unique encodings are calculated according to the coding of all properties；
Step 408, according to export unique encodings generation export name；
Step 410, judge that export saves contents down with the presence or absence of the file with export name, work as export
Save contents when lower presence has the file of export name and enter step 414；
Step 412, when export saves contents down there is no during the file with export name, establishing has export
The file of filename, and data are write into file；
Step 414, the data in file are exported.
In this embodiment, the first attribute listed all properties first and found out according to putting in order in all properties
Property value, the first attribute can be the attribute to put in order as first, then be worth to first by the attribute of the first attribute
The coding of attribute；Obtain the property value of next attribute successively according still further to identical mode, and be worth to according to next attribute next
The coding of property value, until the coding of the property value of all properties is all obtained；Finally calculated according to the coding of all properties
Export unique encodings.By traveling through all properties, achieve the purpose that cycle attribute set, obtain the coding and then reality of each attribute
Now calculate export unique encodings.
Fig. 5 shows the flow diagram of the data export method of an alternative embodiment of the invention.Wherein, this method bag
Include：
Step 502, export condition is received；
Step 504, the attribute set in export condition is obtained, attribute set includes multiple attributes, according to Property Name
All properties are ranked up；
Step 506, the property value of the first attribute in all properties is obtained；
Step 508, judge whether the property value of the first attribute and/or the property value of next attribute are empty；
Step 510, when the property value of the first attribute and/or the property value of next attribute are empty, by the volume of the first attribute
The encoding setting of code and/or next attribute is 0；
Step 512, when the property value of the first attribute and/or the property value of next attribute are not empty, the first attribute is obtained
Coding and/or next attribute coding；
Step 514, completed when the coding of all properties all obtains；The unique volume of export is calculated according to the coding of all properties
Code；
Step 516, according to export unique encodings generation export name；
Step 518, judge that export saves contents down with the presence or absence of the file with export name, work as export
Save contents when lower presence has the file of export name and enter step 522；
Step 520, when export saves contents down there is no during the file with export name, establishing has export
The file of filename, and data are write into file；
Step 522, the data in file are exported.
In this embodiment, it is necessary first to property value is judged, when property value is empty, just by the volume of the property value
Code is arranged to 0, otherwise directly acquires the coding of the property value, and the correspondence of property value and coding is previously stored with system.
By judging the property value of all properties, the coding of the property value of all properties is obtained, is the premise of generation export unique encodings.
In one embodiment of the invention, it is preferable that the step of export unique encodings are calculated according to the coding of all properties,
Specifically include：According to the coding of all properties, export unique encodings are calculated by formula；Formula is
Wherein, D is export unique encodings, and M is preset value, and n is the number of all properties, and S is the coding of attribute, 0≤i≤n, D0=0.
In this embodiment, formula is passed throughCalculate the volume of the property value of each attribute
Code, for example, when preset value is 31, the export unique encodings D that is calculated by the coding of first property value1=D0×31+
S1, the export unique encodings being calculated by the coding of second property value are D2=(D0+D1)×31+S1, and so on, finally
All export unique encodings are superimposed to obtain final export unique encodings, and then realize unique life of same data file
Name, multiple situation is exported so as to avoid identical data.
In one embodiment of the invention, it is preferable that the data export method in any of the above-described, according to export
Unique encodings generate export name, specifically include：According to export unique encodings, export name is generated according to preset format.
In this embodiment, export name is generated according to rule according to export unique encodings, passes through the export calculated
Unique encodings can automatically generate filename, and the mode manually inputted without user is derived file designation, is saved
The operating time of user, improve work efficiency.
In one embodiment of the invention, it is preferable that after preset format is export unique encodings _ report form type file
Sew.
In this embodiment, after the name form of the export name of generation is export unique encodings _ report form type file
Sew, such as：1234567890_ income statement .xlsx, realize same data file by this naming method and uniquely name.
The embodiment of second aspect of the present invention, proposes a kind of data guiding system, and Fig. 6 shows the implementation of the present invention
The schematic block diagram of the data guiding system 600 of example.Wherein, which includes：
Receiving unit 602, for receiving export condition；
Generation unit 604, for according to export condition generation export name；
First judging unit 606, for judging that export saves contents down with the presence or absence of the text with export name
Part；
Import unit 608, for when export saves contents down and the file with export name is not present, establishing
File with export name, and data are write into file；
Lead-out unit 610, for the data in file to be exported；
Lead-out unit 610, be additionally operable to when export save contents it is lower exist with export name file when, directly
Data in file are exported.
Data guiding system 600 provided by the invention, after receiving unit 602 receives the export condition that user submits, passes through
The export condition that generation unit 604 is submitted according to user generates unique export name, and the first judging unit 606 judges export
File saves contents down with the presence or absence of the file with export name, because the file of export is entitled uniquely, does not weigh
Multiple, so when export saves contents the lower not file identical with export name, mesh is preserved in the export
Record is lower to establish the file with the export name, and derived data will be wanted to write this document；Lead-out unit 610 will preserve
File in data export with for users to use.By the present invention, user can easily export wanted data, can also be real
The automatic name of existing export, improves work efficiency.
Lead-out unit 610 when judge export preserve catalogue under there is the file identical with export name when,
Data in this file are directly exported, can prevent from performing multiple data to identical data under the same terms for users to use
The write operation of library inquiry and file, mitigates the burden of database loads and system, shortens the time of other request processing, mitigates
The occupancy of server resource.
In one embodiment of the invention, it is preferable that generation unit 604, is specifically used for：Led according to the generation of export condition
Go out unique encodings；And according to export unique encodings generation export name.
In this embodiment, after user submits export condition, generation unit 604 is arranged and calculated to all conditions
Export unique encodings；Export name is generated by rule by the export unique encodings calculated, that is, exports unique encodings _ report
Type file suffixes, such as：1234567890_ income statement .xlsx, can be given birth to automatically by the export unique encodings calculated
Into filename, the mode manually inputted without user is derived file designation, saves the operating time of user, lifting
Work efficiency.
Fig. 7 a show the schematic block diagram of the data guiding system 700 of one embodiment of the present of invention.Wherein, the system bag
Include：
Receiving unit 702, for receiving export condition；
Generation unit 704, including：First acquisition unit 7042, for obtaining the attribute set in export condition, property set
Conjunction includes multiple attributes；Sequencing unit 7044, for being ranked up according to Property Name to all properties；
Generation unit 704, export unique encodings are generated for searching loop all properties；
First judging unit 706, for judging that export saves contents down with the presence or absence of the text with export name
Part；
Import unit 708, for when export saves contents down and the file with export name is not present, establishing
File with export name, and data are write into file；
Lead-out unit 710, for the data in file to be exported；Lead-out unit 710, is additionally operable to when export preserves mesh
When there is the file with export name under record, directly the data in file are exported.
In this embodiment, generation unit 704, export unique encodings are generated for searching loop all properties, including：The
One acquiring unit 7042, specifically, calculating the step of exporting unique encodings according to export condition includes：Initialization export is unique to compile
Code, makes Unique Code=0, obtains all properties set, all properties are ranked up by Property Name to obtain property set
Close, all properties in cycle attribute set calculate generation export unique encodings.The present invention passes through the export bar to user setting
Part is arranged to obtain export unique encodings, and guarantee is provided for the name of the export of generation.
Fig. 7 b show the schematic block diagram of the data guiding system 700 of one embodiment of the present of invention.Wherein, the system bag
Include：
Receiving unit 702, for receiving export condition；
Generation unit 704, specifically includes：First acquisition unit 7042, for obtaining the attribute set in export condition, belongs to
Property set includes multiple attributes；Sequencing unit 7044, for being ranked up according to Property Name to all properties；Second obtains
Unit 7046, for obtaining the property value of the first attribute in all properties；First is obtained according to the property value of the first attribute to belong to
The coding of property；Obtain the property value of next attribute；The coding of next attribute is obtained according to the property value of next attribute, until all
The coding of attribute is all obtained and completed；Computing unit 7048, for calculating export unique encodings according to the coding of all properties；It is raw
Into unit 704, specifically for according to export condition generation export unique encodings；And led according to export unique encodings generation
Go out filename.
First judging unit 706, for judging that export saves contents down with the presence or absence of the text with export name
Part；
Import unit 708, for when export saves contents down and the file with export name is not present, establishing
File with export name, and data are write into file；
Lead-out unit 710, for the data in file to be exported；Lead-out unit 710, is additionally operable to when export preserves mesh
When there is the file with export name under record, directly the data in file are exported.
In this embodiment, generation unit 704, further include：Second acquisition unit 7046, for obtaining in all properties
The property value of first attribute, specifically, lists all properties and the first category found out according to putting in order in all properties first
The property value of property, the first attribute can be the attribute to put in order as first, be then worth to by the attribute of the first attribute
The coding of first attribute；Obtain the property value of next attribute successively according still further to identical mode, and be worth to according to next attribute
The coding of next property value, until the coding of the property value of all properties is all obtained.Computing unit, for according to all categories
Property coding calculate export unique encodings.By traveling through all properties, achieve the purpose that cycle attribute set, obtain each attribute
Coding so that realization calculate export unique encodings.
In one embodiment of the invention, it is preferable that second acquisition unit 7046, is specifically used for：Judge the first attribute
Property value and/or the property value of next attribute whether be empty；When the property value of the first attribute and/or the property value of next attribute
For sky when, by the encoding setting of the coding of the first attribute and/or next attribute be 0；When the property value of the first attribute and/or next
When the property value of attribute is not empty, the coding of the first attribute and/or the coding of next attribute are obtained.
In this embodiment, second acquisition unit 7046 judges firstly the need of to property value, when property value is empty,
Just be 0 by the encoding setting of the property value, otherwise directly acquire the coding of the property value, be previously stored with system property value with
The correspondence of coding.By judging the property value of all properties, the coding of the property value of all properties is obtained, is generation export
The premise of unique encodings.
In one embodiment of the invention, it is preferable that computing unit 7048, is specifically used for：According to the volume of all properties
Code, export unique encodings are calculated by formula；Formula isWherein, D is to export unique encodings, M
For preset value, n is the number of all properties, and S is the coding of attribute, 0≤i≤n, D0=0.
In this embodiment, computing unit 7048, export unique encodings for calculating, specifically, pass through formulaThe coding of the property value of each attribute is calculated, for example, when preset value is 31, by first
The export unique encodings D that the coding of a property value is calculated1=D0×31+S1, it is calculated by the coding of second property value
Export unique encodings be D2=(D0+D1)×31+S1, and so on, finally all export unique encodings are superimposed to obtain most
Whole export unique encodings, and then realize unique name of same data file, multiple so as to avoid identical data export
Situation.
In one embodiment of the invention, it is preferable that generation unit 704, is specifically used for：According to export unique encodings,
Export name is generated according to preset format.
In this embodiment, generation unit 704, for generating export name, specifically, are pressed according to export unique encodings
Export name is generated according to rule.Filename can be automatically generated by the export unique encodings calculated, is passed through without user
The mode being manually entered is derived file designation, saves the operating time of user, improves work efficiency.
In one embodiment of the invention, it is preferable that after preset format is export unique encodings _ report form type file
Sew.
In this embodiment, after the name form of the export name of generation is export unique encodings _ report form type file
Sew, such as：1234567890_ income statement .xlsx, realize same data file by this naming method and uniquely name.
Fig. 8 shows the export unique encodings generating algorithm flow diagram of the specific embodiment of the present invention.Wherein,
The algorithm performs process is as follows：
Unique encodings are initialized first, make Unique Code (export unique encodings)=0；Then reflected by Java
To all properties set, all properties are ranked up by Property Name to obtain attribute set；Attribute set is recycled, specifically
Ground, obtains property value, determines whether sky, if the Hash Code (Hash codes)=0 of null attribute value, then reset Unique
The Hash Code of Code, otherwise first computation attribute value, then reset Unique Code；Finally it is required for returning to Unique Code,
Terminate to calculate generation export unique encodings.
The embodiment of third aspect present invention, proposes a kind of computer installation, and Fig. 9 shows one embodiment of the present of invention
Computer installation 900 schematic block diagram.Wherein, which includes：
Memory 902, processor 904 and it is stored in the computer journey that can be run on memory 902 and on processor 904
The step of sequence, processor 904 realizes the data export method in such as any of the above-described when performing computer program.
Computer installation 900 provided by the invention, when processor 904 performs computer program, user submits export condition,
The unique filename for wanting export of export condition generation submitted according to user, judging that export saves contents down is
It is no to there is the file with export name, because the file of export is entitled unique, unduplicated, when export text
Part save contents the lower not file identical with export name when, the export save contents it is lower foundation there is the export
The file of filename, and derived data will be wanted to write this document；Finally by the file of preservation data export for
Family uses.By the present invention, user can easily export wanted data, can also realize the automatic name of export, carry
High work efficiency.When judging to there is the file identical with export name under the catalogue of export preservation, by this text
Data in part are directly exported, can prevent from performing multiple data base querying to identical data under the same terms for users to use
With the write operation of file, mitigate the burden of database loads and system, shorten the time of other request processing, mitigate server
The occupancy of resource.
The embodiment of fourth aspect present invention, proposes a kind of computer-readable recording medium, is stored thereon with computer journey
Sequence, is realized when computer program is executed by processor such as the step of data export method in any of the above-described.
Computer-readable recording medium provided by the invention, when processor performs computer program, user submits export bar
Part, the unique filename for wanting export of export condition generation submitted according to user, judges that export saves contents
It is lower to whether there is the file with export name, because the file of export is entitled unique, unduplicated, works as and lead
Go out file save contents the lower not file identical with export name when, the export save contents it is lower establish have should
The file of export name, and derived data will be wanted to write this document；Finally by the file of preservation data export with
For users to use.By the present invention, user can easily export wanted data, can also realize the automatic life of export
Name, improves work efficiency., will when judging to there is the file identical with export name under the catalogue of export preservation
Data in this file are directly exported, can prevent from performing multiple database to identical data under the same terms for users to use
Inquiry and the write operation of file, mitigate the burden of database loads and system, shorten the time of other request processing, mitigate clothes
The occupancy for device resource of being engaged in.
In the description of this specification, the description of term " one embodiment ", " some embodiments ", " specific embodiment " etc.
Mean to combine at least one reality that the particular features, structures, materials, or characteristics that the embodiment or example describe are contained in the present invention
Apply in example or example.In the present specification, schematic expression of the above terms is not necessarily referring to identical embodiment or reality
Example.Moreover, description particular features, structures, materials, or characteristics can in any one or more embodiments or example with
Suitable mode combines.
The foregoing is only a preferred embodiment of the present invention, is not intended to limit the invention, for the skill of this area
For art personnel, the invention may be variously modified and varied.Within the spirit and principles of the invention, that is made any repaiies
Change, equivalent substitution, improvement etc., should all be included in the protection scope of the present invention.
Claims (20)
- A kind of 1. data export method, it is characterised in that including：Receive export condition；Export name is generated according to the export condition；Judge that export saves contents down with the presence or absence of the file with the export name；When the export saves contents down there is no during the file with the export name, foundation has the export The file of filename, data are write into the file, then the data in the file are exported；When the export save contents it is lower exist with the export name file when, directly by the file Data export.
- 2. data export method according to claim 1, it is characterised in that described according to export condition generation The step of export name, specifically include：Export unique encodings are generated according to the export condition；The export name is generated according to the export unique encodings.
- 3. data export method according to claim 2, it is characterised in that described generated according to the export condition exports The step of unique encodings, specifically include：The attribute set in the export condition is obtained, the attribute set includes multiple attributes；All attributes are ranked up；All attributes of searching loop generate the export unique encodings.
- 4. data export method according to claim 3, it is characterised in that described pair of all attributes are ranked up, Specifically include：All attributes are ranked up according to Property Name.
- 5. data export method according to claim 3, it is characterised in that all attribute generations of searching loop The step of export unique encodings, specifically include：Obtain the property value of the first attribute in all attributes；The coding of first attribute is obtained according to the property value of first attribute；Obtain the property value of next attribute；The coding of next attribute is obtained according to the property value of next attribute, until the coding of all attributes is whole Obtain and complete；The export unique encodings are calculated according to the coding of all attributes.
- 6. data export method according to claim 5, it is characterised in that the property value according to first attribute Obtain the coding of first attribute and/or the coding that next attribute is obtained according to the property value of next attribute The step of, specifically include：Judge whether the property value of first attribute and/or the property value of next attribute are empty；When the property value of first attribute and/or the property value of next attribute are empty, by the volume of first attribute The encoding setting of code and/or next attribute is 0；When the property value of first attribute and/or the property value of next attribute are not empty, first attribute is obtained Coding and/or next attribute coding.
- 7. data export method according to claim 5, it is characterised in that the volume according to all attributes Code calculates the step of export unique encodings, specifically includes：According to the coding of all attributes, the export unique encodings are calculated by formula；The formula isWherein, D is the export unique encodings, and M is preset value, and n is all The number of the attribute, S be the attribute coding, 0≤i≤n, D0=0.
- 8. the data export method according to any one of claim 2 to 7, it is characterised in that described according to the export Unique encodings generate the export name, specifically include：According to the export unique encodings, the export name is generated according to preset format.
- 9. data export method according to claim 8, it is characterised in that the preset format for export unique encodings _ Report form type file suffixes.
- A kind of 10. data guiding system, it is characterised in that including：Receiving unit, for receiving export condition；Generation unit, for generating export name according to the export condition；First judging unit, for judging that export saves contents down with the presence or absence of the file with the export name；Import unit, for when the export saves contents down and the file with the export name is not present, building The vertical file with the export name, data are write into the file；Lead-out unit, for the data in the file to be exported；The lead-out unit, be additionally operable to when the export save contents it is lower exist with the export name file When, directly the data in the file are exported.
- 11. data guiding system according to claim 10, it is characterised in that the generation unit, is specifically used for：Export unique encodings are generated according to the export condition；AndThe export name is generated according to the export unique encodings.
- 12. data guiding system according to claim 11, it is characterised in that the generation unit, including：First acquisition unit, for obtaining the attribute set in the export condition, the attribute set includes multiple attributes；Sequencing unit, for being ranked up to all attributes；The generation unit, the export unique encodings are generated for all attributes of searching loop.
- 13. data guiding system according to claim 12, it is characterised in that the sequencing unit, specifically for according to Property Name is ranked up all attributes.
- 14. data guiding system according to claim 12, it is characterised in that the generation unit, further includes：Second acquisition unit, for obtaining the property value of the first attribute in all attributes；According to first attribute Property value obtains the coding of first attribute；Obtain the property value of next attribute；Obtained according to the property value of next attribute The coding of next attribute is taken, is completed until the coding of all attributes all obtains；Computing unit, for calculating the export unique encodings according to the coding of all attributes.
- 15. data guiding system according to claim 14, it is characterised in that the second acquisition unit, is specifically used for：Judge whether the property value of first attribute and/or the property value of next attribute are empty；When the property value of first attribute and/or the property value of next attribute are empty, by the volume of first attribute The encoding setting of code and/or next attribute is 0；When the property value of first attribute and/or the property value of next attribute are not empty, first attribute is obtained Coding and/or next attribute coding.
- 16. data guiding system according to claim 14, it is characterised in that the computing unit, is specifically used for：According to the coding of all attributes, the export unique encodings are calculated by formula；The formula isWherein, D is the export unique encodings, and M is preset value, and n is all The number of the attribute, S be the attribute coding, 0≤i≤n, D0=0.
- 17. the data guiding system according to any one of claim 11 to 16, it is characterised in that the generation unit, It is specifically used for：According to the export unique encodings, the export name is generated according to preset format.
- 18. data guiding system according to claim 17, it is characterised in that the preset format is compiled for export is unique Code _ report form type file suffixes.
- 19. a kind of computer installation, including memory, processor and it is stored on the memory and can be on the processor The computer program of operation, it is characterised in that the processor realizes such as claim 1 to 9 when performing the computer program Any one of data export method the step of.
- 20. a kind of computer-readable recording medium, is stored thereon with computer program, it is characterised in that the computer program The step of data export method as claimed in any one of claims 1-9 wherein is realized when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710706107.1A CN108009190B (en) | 2017-08-17 | 2017-08-17 | Data export method, data export system and computer device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710706107.1A CN108009190B (en) | 2017-08-17 | 2017-08-17 | Data export method, data export system and computer device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108009190A true CN108009190A (en) | 2018-05-08 |
| CN108009190B CN108009190B (en) | 2020-09-29 |
Family
ID=62050883
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710706107.1A Active CN108009190B (en) | 2017-08-17 | 2017-08-17 | Data export method, data export system and computer device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108009190B (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1925588A (en) * | 2005-09-01 | 2007-03-07 | 南京Lg同创彩色显示系统有限责任公司 | Automatic document storing method in digital multimedia device |
| CN101026635A (en) * | 2006-02-21 | 2007-08-29 | 南京中兴软创科技有限责任公司 | Method for dynamically accessing resource code or name |
| US20090094273A1 (en) * | 2007-10-05 | 2009-04-09 | Canon Kabushiki Kaisha | Information processing apparatus and control method thereof, and document verification apparatus and control method thereof |
| CN101770512A (en) * | 2010-01-20 | 2010-07-07 | 何吴迪 | Cloud stored hypertext file storage and framework method of WEB window expression thereof |
| CN103838742A (en) * | 2012-11-21 | 2014-06-04 | 新奥特（北京）视频技术有限公司 | Method and device for processing compression parameters of multimedia files |
| CN105354179A (en) * | 2015-11-02 | 2016-02-24 | 武汉钢铁(集团)公司 | Coke dry quenching report generation method |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN106446001A (en) * | 2016-07-29 | 2017-02-22 | 北京北信源软件股份有限公司 | Method and system for storing files in computer storage mediums |
-
2017
- 2017-08-17 CN CN201710706107.1A patent/CN108009190B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1925588A (en) * | 2005-09-01 | 2007-03-07 | 南京Lg同创彩色显示系统有限责任公司 | Automatic document storing method in digital multimedia device |
| CN101026635A (en) * | 2006-02-21 | 2007-08-29 | 南京中兴软创科技有限责任公司 | Method for dynamically accessing resource code or name |
| US20090094273A1 (en) * | 2007-10-05 | 2009-04-09 | Canon Kabushiki Kaisha | Information processing apparatus and control method thereof, and document verification apparatus and control method thereof |
| CN101770512A (en) * | 2010-01-20 | 2010-07-07 | 何吴迪 | Cloud stored hypertext file storage and framework method of WEB window expression thereof |
| CN103838742A (en) * | 2012-11-21 | 2014-06-04 | 新奥特（北京）视频技术有限公司 | Method and device for processing compression parameters of multimedia files |
| CN105354179A (en) * | 2015-11-02 | 2016-02-24 | 武汉钢铁(集团)公司 | Coke dry quenching report generation method |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN106446001A (en) * | 2016-07-29 | 2017-02-22 | 北京北信源软件股份有限公司 | Method and system for storing files in computer storage mediums |
Non-Patent Citations (1)
| Title |
|---|
| 张云: "滚动直线导轨副精度保持性检测与试验研究", 《中国优秀硕士学位论文全文数据库 工程科技Ⅰ辑》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108009190B (en) | 2020-09-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20130332467A1 (en) | Linking Data Elements Based on Similarity Data Values and Semantic Annotations | |
| Danielson et al. | Augmenting ordinal methods of attribute weight approximation | |
| US8849837B2 (en) | Configurable dynamic matching system | |
| CN110457666B (en) | Report generation method, system, electronic equipment and storage medium | |
| CN107454105A (en) | A kind of multidimensional network safety evaluation method based on AHP and grey correlation | |
| CN111865895B (en) | Data secret transmission method and system based on cloud platform | |
| WO2022142001A1 (en) | Target object evaluation method based on multi-score card fusion, and related device therefor | |
| US20200320216A1 (en) | Systems and methods for determining database permissions | |
| CN115454561A (en) | Customized interface display method, device, equipment and storage medium | |
| CN115510249A (en) | Knowledge graph construction method and device, electronic equipment and storage medium | |
| CN114118985A (en) | Resource information management method, system, medium, and computer device | |
| CN108009190A (en) | A kind of data export method, data guiding system and computer installation | |
| CN112925914A (en) | Data security classification method, system, device and storage medium | |
| CN110442636B (en) | Data reading and writing method and device and data reading and writing equipment | |
| CN110245688B (en) | Data processing method and related device | |
| CN102855278A (en) | Simulation method and system | |
| US7716646B2 (en) | Loading a chain of processors from an XML file | |
| CN111680478B (en) | Report generation method, device, equipment and storage medium based on configuration software | |
| CN115543428A (en) | Simulated data generation method and device based on strategy template | |
| CN110378479A (en) | Picture input method, device and terminal device based on deep learning | |
| CN105426183A (en) | Form verification method | |
| CN115292516A (en) | Block chain-based distributed knowledge graph construction method, device and system | |
| CN114268625B (en) | Feature selection method, device, equipment and storage medium | |
| KR20220152505A (en) | Managing method for EHR based on block chain | |
| CN110807599A (en) | Method, device, server and storage medium for deciding electrochemical energy storage scheme |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP01 | Change in the name or title of a patent holder |
Address after: Unit 819, Block D, Building 8, Wangjing Dongyuan District 4, Chaoyang District, Beijing 100102 Patentee after: BEIJING CHJ AUTOMOTIVE TECHNOLOGY Co.,Ltd. Address before: Unit 819, Block D, Building 8, Wangjing Dongyuan District 4, Chaoyang District, Beijing 100102 Patentee before: Beijing Chehejia Information Technology Co.,Ltd. |
|
| CP01 | Change in the name or title of a patent holder | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20211123 Address after: Room 103, building 1, yard 4, Hengxing Road, Gaoliying Town, Shunyi District, Beijing Patentee after: Beijing Rockwell Technology Co.,Ltd. Address before: Unit 819, Block D, Building 8, Wangjing Dongyuan District 4, Chaoyang District, Beijing 100102 Patentee before: BEIJING CHJ AUTOMOTIVE TECHNOLOGY Co.,Ltd. |
|
| TR01 | Transfer of patent right |