CN108108478A - Conversion method of data format, system and electronic equipment - Google Patents
Conversion method of data format, system and electronic equipment Download PDFInfo
- Publication number
- CN108108478A CN108108478A CN201810007970.2A CN201810007970A CN108108478A CN 108108478 A CN108108478 A CN 108108478A CN 201810007970 A CN201810007970 A CN 201810007970A CN 108108478 A CN108108478 A CN 108108478A
- Authority
- CN
- China
- Prior art keywords
- file
- pending
- format
- converted
- specified
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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/11—File system administration, e.g. details of archiving or snapshots
- G06F16/116—Details of conversion of file system types or formats
-
- 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/13—File access structures, e.g. distributed indices
-
- 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/21—Design, administration or maintenance of databases
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Abstract
An embodiment of the present invention provides a kind of conversion method of data format, system and electronic equipment, the described method includes：Obtain multiple pending files；The original file format of each pending file is converted into the first specified file format；Multiple table spaces are established in the database, and for each table space, corresponding user name and sequence number are set；Each pending file for being converted into the first specified file format is directed into the database and is stored in corresponding table space；Each pending file in the database is exported, and the first specified file format of each pending file is converted into the second specified file format, each pending file for being converted into the second specified file format is exported., it can be achieved that the mass of data extracts and format conversion, and realizes the mass storage storage of data, the batch export and importing of data can operate and keep the file content of pending file constant the Data Format Transform scheme repeatedly.
Description
Technical field
The present invention relates to field of computer technology, in particular to a kind of conversion method of data format, system and electronics
Equipment.
Background technology
At present, that the content of grid directly stored application into database is less, and can support not yet
Data are directly converted and are stored to the mass handling implement of oracle database.If desired grid class file is converted and stored
It into database, can only be inserted by artificial mode, there are heavy workload, efficiency is low and easily drawbacks such as error.
The content of the invention
In view of this, it is an object of the invention to provide a kind of conversion method of data format, system and electronic equipment, with solution
The certainly above problem.
Presently preferred embodiments of the present invention provides a kind of conversion method of data format, the described method includes：
Obtain multiple pending files；
The original file format of each pending file is converted into the first specified file format；
Multiple table spaces are established in the database, and for each table space, corresponding user name and sequence number are set；
Each pending file for being converted into the first specified file format is directed into corresponding table space in the database
In stored；
Each pending file in the database is exported, and text is specified by the first of each pending file
Part format conversion is the second specified file format, and each pending file for being converted into the second specified file format is exported.
Optionally, in the above-mentioned methods, the original file format by each pending file is converted to the first finger
Before the step of determining file format, the method further includes：
The original file format of pending file is converted to the first specified file format and by pending file by configuration
The first specified file format be converted to the format converter tools of the second specified file format.
Optionally, in the above-mentioned methods, the original file format by each pending file is converted to the first finger
After the step of determining file format, the method further includes：
The pending file of the first specified file format in the database is extracted, detection is converted to the first specified file
Whether the file content of the pending file of form is identical with the file content of the pending file of original file format；
If differing, the configuration information of the format converter tools is changed, and is re-executed each pending text
The step of original file format of part is converted to the first specified file format, until what is extracted is converted to the first specified file lattice
Until the file content of the pending file of formula is identical with the file content of the pending file of original file format.
Optionally, in the above-mentioned methods, each pending file corresponds to different area informations, described to obtain multiple treat
The step of handling file, including：
Corresponding multiple regions information is found according to look-up command；
Corresponding storage root is found according to each area information, is extracted from the storage root from treating
Manage file.
Optionally, in the above-mentioned methods, the step of each pending file by the database is exported, bag
It includes：
It is found in the database and the export corresponding sequence number of instruction according to export instruction input by user
And user name；
Corresponding table space is found according to the sequence number and user name；
It extracts the pending file stored in the table space and exports.
Optionally, in the above-mentioned methods, each pending file for being converted into the first specified file format is directed into
After the step of being stored in the database in corresponding table space, the method further includes：
The file size data of each pending file is calculated, the file size data being calculated is preserved to each institute
It states in the corresponding table space of pending file.
Optionally, in the above-mentioned methods, the pending file include multiple subfiles, it is described be converted into first specify
Each pending file of file format is directed into the step of being stored in the database in corresponding table space, including：
The corresponding multiple pending files for being converted to the first specified file format are obtained according to instruction is imported；
It is empty that each subfile in each pending file of acquisition is directed into corresponding table in the database successively respectively
Between in stored.
Optionally, in the above-mentioned methods, the original file format be Word file form, the first specified file lattice
Formula is pdf document form, and second specified file format is DMP file formats.
Another preferred embodiment of the present invention provides a kind of format conversion system, and the format conversion system includes：
File acquisition module, for obtaining multiple pending files；
First modular converter, for the original file format of each pending file to be converted to the first specified file lattice
Formula；
Module is established, for establishing multiple table spaces in the database, corresponding user name is set for each table space
And sequence number；
Import modul, each pending file for being converted into the first specified file format are directed into the database
It is stored in corresponding table space；
Second modular converter for each pending file in the database to be exported, and described is waited to locate by each
First specified file format of reason file is converted to the second specified file format, is converted into respectively treating for the second specified file format
Processing file is exported.
Another preferred embodiment of the present invention provides a kind of electronic equipment, including memory, processor and is stored in storage
On device and the computer program that can run on a processor, the processor realize above-mentioned method step when performing described program
Suddenly.
Conversion method of data format provided in an embodiment of the present invention, system and electronic equipment, by by pending file
Original file format is converted to the first specified file format, and stores into the correspondence table space in the database pre-established,
Subsequently to directly invoke in corresponding table space pending file for needed for project.Pending file in database is exported
And its first specified file format is converted into the second specified file format, and exported, so as to not error-prone text
Part form is copied in other server databases.Data Format Transform scheme provided in an embodiment of the present invention is, it can be achieved that number
According to mass extraction and format conversion, and realize data mass storage storage, data batch export and import can be anti-
It operates again and keeps the file content of pending file constant.
For the above objects, features and advantages of the present invention is enable to be clearer and more comprehensible, preferred embodiment cited below particularly, and coordinate
Appended attached drawing, is described in detail below.
Description of the drawings
It in order to illustrate the technical solution of the embodiments of the present invention more clearly, below will be to needed in the embodiment attached
Figure is briefly described, it should be understood that the following drawings illustrates only certain embodiments of the present invention, therefore is not construed as pair
The restriction of scope, for those of ordinary skill in the art, without creative efforts, can also be according to this
A little attached drawings obtain other relevant attached drawings.
Fig. 1 is the structure diagram for a kind of electronic equipment that present pre-ferred embodiments provide.
Fig. 2 is the flow chart for the conversion method of data format that present pre-ferred embodiments provide.
Fig. 3 is the flow chart of the sub-step of step S101 in Fig. 2.
Fig. 4 is another flow chart for the conversion method of data format that present pre-ferred embodiments provide.
Fig. 5 is the flow chart of the sub-step of step S105 in Fig. 2.
Fig. 6 is the functional block diagram for the data conversion system that presently preferred embodiments of the present invention provides.
Icon：100- electronic equipments；110- Data Format Transform systems；111- file acquisition modules；112- first is converted
Module；113- establishes module；114- import moduls；The second modular converters of 115-；120- processors；130- memories.
Specific embodiment
In the prior art, only have the existing software support such as FME, adobe, MS OFFICE and realize partial data format conversion
Function, such as PDF common formats are converted to, but do not find and data conversion can be stored to the mass of oracle database
Science and engineering has.
Inventor it has been investigated that, the content data file of grid directly store into database current application compared with
It is few, the relative path of pdf document is normally only stored, so that user calls.If desired grid class file is stored as blob fields
The data of type can only be inserted by artificial mode, and heavy workload is inefficient, and easily malfunctions.With a Word
File search, opening, conversion, opening PDF verifications, deposit database, at least in terms of 1 minute, then 500000 files then need
50 clock, 347 man days (24 work when small), 1041 man days very much (8 work when small), it is seen that workload it is huge.
Based on the studies above, an embodiment of the present invention provides a kind of Data Format Transform schemes, pass through the mass of data
Extraction and format conversion, and realize the mass storage storage of data so that the batch of data is exported and imported and can operate repeatedly
And keep the content of data file constant.
Below in conjunction with attached drawing in the embodiment of the present invention, the technical solution in the embodiment of the present invention is carried out clear, complete
Ground describes, it is clear that described embodiment is only part of the embodiment of the present invention, instead of all the embodiments.Usually exist
The component of the embodiment of the present invention described and illustrated in attached drawing can configure to arrange and design with a variety of herein.Cause
This, the detailed description of the embodiment of the present invention to providing in the accompanying drawings is not intended to limit claimed invention below
Scope, but it is merely representative of the selected embodiment of the present invention.Based on the embodiment of the present invention, those skilled in the art are not doing
Go out all other embodiments obtained on the premise of creative work, belong to the scope of protection of the invention.
It should be noted that：Similar label and letter represents similar terms in following attached drawing, therefore, once a certain Xiang Yi
It is defined, then it further need not be defined and explained in subsequent attached drawing in a attached drawing.Meanwhile the present invention's
In description, unless otherwise clearly defined and limited, term " installation ", " setting ", " connection " should be interpreted broadly, for example, can
To be to be fixedly connected or be detachably connected or be integrally connected；Can be mechanical connection or electrical connection；It can
It to be to be connected directly, can also be indirectly connected by intermediary, can be the connection inside two elements.For this field
For those of ordinary skill, the concrete meaning of above-mentioned term in the present invention can be understood with concrete condition.
Referring to Fig. 1, the block diagram for electronic equipment 100 provided in an embodiment of the present invention.In the present embodiment, institute
Stating electronic equipment 100 includes Data Format Transform system 110, processor 120 and memory 130.Wherein, the memory
It is directly or indirectly electrically connected between 130 and processor 120, to realize the transmission of data or interaction.The data format turns
Change system 110 in the form of software or firmware can be stored in the memory 130 or be solidificated in the electricity including at least one
Software function module in the operating system of sub- equipment 100.The processor 120 be used for perform stored in memory 130 can
Execution module, such as the software function module or computer program that the Data Format Transform system 110 includes, with to data text
Part carries out mass processing.
In the present embodiment, the electronic equipment 100 may be, but not limited to, the terminal device with data-handling capacity,
Such as PC, laptop etc..
As shown in Fig. 2, it is a kind of data lattice applied to electronic equipment 100 shown in FIG. 1 provided in an embodiment of the present invention
The schematic flow chart of formula conversion method.It should be noted that method provided in this embodiment is not with Fig. 2 and as described below suitable
Sequence is limitation.Idiographic flow shown in Fig. 2 will be explained in detail below.
Step S101 obtains multiple pending files.
In the present embodiment, multiple pending files are stored in the electronic equipment 100, the pending file can be with
It is that user imports or obtained by network from other-end, server or high in the clouds, to this in the present embodiment not
It is restricted.Since the file format of the data in pending file is various and lack of standardization, storage to follow-up pending file and
Using bringing inconvenience, it is therefore desirable to the file format in pending file is converted, and configures corresponding storage application, with
Batch conversion and mass storage storage are carried out to pending file.
In the present embodiment, illustrated so that the pending file verifies performance data on the spot for mineral properties as an example.Its
In, each pending file corresponds to different area informations, such as each pending file summarizing for the performance data in different provinces
File.Referring to Fig. 3, in the specific implementation, it, can when being extracted to the multiple pending files to prestore in electronic equipment 100
It performs according to the following steps：
Step S1011 finds corresponding multiple regions information according to look-up command.
Step S1012 finds corresponding storage root according to each area information, from the storage root
Extract pending file.
In the present embodiment, the pending file of magnanimity is prestored in electronic equipment 100, each pending file carries not
Same area information, such as different province titles.User can input corresponding look-up command, which can wait to locate
Manage the corresponding area information of file.The corresponding storage catalogue of area information is found according to the area information that look-up command carries,
Corresponding multiple pending files are extracted from storage catalogue.
The original file format of each pending file is converted to the first specified file format by step S102.
In the present embodiment, the original file format of the pending file can be Word file form, and this text
The file of part form is susceptible to the mistakes such as form, content in subsequent storage and application, therefore need to be to pending file
Original file format is converted.
In the present embodiment, before the original file format to pending file is converted, the method further includes
Following steps：
The original file format of pending file is converted to the first specified file format and by pending file by configuration
The first specified file format be converted to the format converter tools of the second specified file format.
In the present embodiment, a data format converter tools are write in advance, to realize the file format of batch, automation
The hard work task of artificial treatment completion data conversion is replaced in conversion with this.In the present embodiment, pending file
Original file format can be Word file form, and the first specified file format of pending file can be pdf document form,
Second specified file format can be DMP file formats.
It in the present embodiment, can be by the way that the format converter tools be called automatically will after having configured format converter tools
Multiple pending files that user specifies carry out file format conversion, such as the original file format of pending file is converted to
First specified file format is pdf document form that is, by the Word file format conversion of pending file.Optionally, in this reality
It applies in example, conversion of the Word file form to pdf document form is completed on backstage.
Step S103 establishes multiple table spaces in the database, for each table space set corresponding user name and
Sequence number.
Optionally, it is contemplated that the file of magnanimity, which is stored in a table space, may trigger data copy, movement, standby
The problems such as part, in order to which each pending file that will convert into pdf document form carries out science storage, can establish more in the database
A table space can divide province information to set corresponding user name and sequence number for each table space, be follow-up PDF format file
Storage get out resource.The information such as the table space information wherein established and sequence number can be as shown in table 1.In addition, in order to ensure
All PDF format files can be preserved, also in the database can create the phases such as several interim table spaces, data table space more
Database object is closed, to tackle substantial amounts of data storage storage.In the present embodiment, the database can be Oracle numbers
According to storehouse.
Table 1
| Province | Number | User name | Password | Table space |
| Beijing | 110000 | TS_KYQSDHC11 | TS_KYQSDHC11 | TS_KYQSDHC11 |
| Tianjin | 120000 | TS_KYQSDHC12 | TS_KYQSDHC12 | TS_KYQSDHC12 |
| Hebei province | 130000 | TS_KYQSDHC13 | TS_KYQSDHC13 | TS_KYQSDHC13 |
| Shanxi Province | 140000 | TS_KYQSDHC14 | TS_KYQSDHC14 | TS_KYQSDHC14 |
| Inner Mongolia Autonomous Region | 150000 | TS_KYQSDHC15 | TS_KYQSDHC15 | TS_KYQSDHC15 |
| Liaoning Province | 210000 | TS_KYQSDHC21 | TS_KYQSDHC21 | TS_KYQSDHC21 |
| Other multiple provinces | …… | …… | …… | …… |
Step S104, each pending file for being converted into the first specified file format are directed into correspondence in the database
Table space in stored.
In the present embodiment, based on established database, exploitation can realize that PDF format file is automatically saved to data
Software tool in storehouse, to mitigate the operating pressure of staff.
In the present embodiment, each pending file includes multiple subfiles, for example, different province mineral properties on the spot
Verify the table of comparisons, single mineral properties situation supporting paper and graph supporting paper of performance data etc..In the present embodiment, will
Each pending file for being converted to pdf document form is directed into the corresponding table space in established database and is deposited
Storage.
It optionally, can be according to the pending file input by user for importing and instructing and obtaining and need to be directed into database.It will
Each subfile in the pending file obtained is directed into database successively respectively to be stored in corresponding table space.
It optionally, in the present embodiment, can also be in pending text in order to which the information to pending file is preserved comprehensively
Part is directed into after database, calculates the file size data of each pending file, and the file size data being calculated is protected
It deposits into the corresponding table space of each pending file.In the present embodiment, the Word format of pending file is converted to
PDF format is to subsequently when carrying out relevant item work, need to extract the PDF of preservation according to project from database
Each table of comparisons of form, single mineral properties situation supporting paper and graph supporting paper etc. are for needed for project.
In the present embodiment, by Word file format conversion for pdf document form and after storing storage, also need to keep treating
The file content of processing file does not find to change.Referring to Fig. 4, in the present embodiment, Word file form is being carried out to PDF texts
After the conversion of part form, the method is further comprising the steps of：
Step S201, extracts the pending file of the first specified file format in the database, and detection is converted to the
The file content of the pending file of one specified file format whether the file content with the pending file of original file format
It is identical.
Step S202, in the file content and original file format of the pending file for being converted to the first specified file format
The file content of pending file when differing, change the configuration information of the format converter tools, and re-execute will be each
The step of original file format of the pending file is converted to the first specified file format, until what is extracted is converted to the
The file content of the pending file of one specified file format is identical with the file content of the pending file of original file format
Until.
Step S105 exports each pending file in the database, and by each pending file
First specified file format is converted to the second specified file format, and is converted into each pending text of the second specified file format
Part is exported.
Optionally, referring to Fig. 5, in the present embodiment, step S105 can include step S1051, step S1052 and step
Tri- sub-steps of rapid S1053.
Step S1051 is found and the export instruction pair in the database according to export instruction input by user
The sequence number and user name answered.
Step S1052 finds corresponding table space according to the sequence number and user name.
Step S1053 extracts the pending file stored in the table space and exports.
It is in order to facilitate managing and operate, the pending file for preserving pdf document form in the database is whole with one
Body is exported, that is, province is divided to carry out data export.In the specific implementation, sequence number and user can be carried according to input by user
The sequence number and user name of corresponding table space are searched in the export instruction of name in the database.It is looked for according to the sequence number and user name
Go out corresponding storage table space, then the pending file of storage is extracted from the storage table space.Also, by derived PDF
The pending file of file format is converted to DMP file formats.In the present embodiment, DMP file formats derived from acquisition is each
The file size of pending file, and establish the derived information table of DMP file formats as follows.
Table 2
| Province | Number | Derived DMP file sizes (GB) |
| Beijing | 110000 | 0.24 |
| Tianjin | 120000 | 0.26 |
| Hebei province | 130000 | 3.01 |
| Shanxi Province | 140000 | 9.25 |
| Inner Mongolia Autonomous Region | 150000 | 5.45 |
| Liaoning Province | 210000 | 3.82 |
| Jilin Province | 220000 | 2.36 |
| Other multiple provinces | …… | …… |
In the present embodiment, DMP formatted files derived from Jiang Fen provinces are exported, to copy in other servers,
Such as in the server of information centre of Ministry of Land and Resources, then led respectively by the data base administrator of information centre of Ministry of Land and Resources
Enter into its database server, to be preserved to the pending file for being converted to DMP forms, for subsequent calls.
When DMP formatted files are directed into above-mentioned database server, can generate it is relevant importing daily record (to database connection into
Row judges, load/unload is carried out to tables of data, database object is handled, each database table data is criticized
Amount imports, operating result is prompted etc.).
Referring to Fig. 6, it is a kind of functional block diagram of Data Format Transform system 110 provided in an embodiment of the present invention.
The Data Format Transform system 110 is applied to above-mentioned electronic equipment 100, and the Data Format Transform system 110 includes text
Part acquisition module 111, the first modular converter 112 establish module 113,114 and second modular converter 115 of import modul.
The file acquisition module 111 is used to obtain multiple pending files.This document acquisition module 111 can be used for performing
Step S101 shown in Fig. 2, specific operating method can refer to the detailed description of step S101.
First modular converter 112 is specified for the original file format of each pending file to be converted to first
File format.First modular converter 112 can be used for performing step S102 shown in Fig. 2, and specific operating method can refer to
The detailed description of step S102.
It is described to establish module 113 for establishing multiple table spaces in the database, it is set for each table space corresponding
User name and sequence number.This is established module 113 and can be used for performing step S103 shown in Fig. 2, and specific operating method can
With reference to the detailed description of step S103.
Each pending file that the import modul 114 is used to be converted into the first specified file format is directed into the number
According to being stored in storehouse in corresponding table space.The import modul 114 can be used for performing step S104 shown in Fig. 2, specifically
Operating method can refer to the detailed description of step S104.
Second modular converter 115 is for each pending file in the database to be exported, and by each institute
The first specified file format for stating pending file is converted to the second specified file format, is converted into the second specified file format
Each pending file exported.Second modular converter 115 can be used for performing step S105 shown in Fig. 2, specifically
Operating method can refer to the detailed description of step S105.
In conclusion conversion method of data format provided in an embodiment of the present invention, system and electronic equipment 100, pass through by
The original file format of pending file is converted to the first specified file format, and stores to pair in the database pre-established
It answers in table space, subsequently to directly invoke in corresponding table space pending file for needed for project.By treating in database
Processing file exports and its first specified file format is converted to the second specified file format, and is exported, so as to
Not error-prone file format is copied in other server databases.Data Format Transform side provided in an embodiment of the present invention
Case is, it can be achieved that the mass of data extracts and format conversion, and realizes the mass storage storage of data, the batch export of data
And importing can operate and keep the file content of pending file constant repeatedly.
In embodiment provided herein, it should be understood that disclosed apparatus and method, it can also be by other
Mode realize.The apparatus embodiments described above are merely exemplary, for example, the flow chart and block diagram in attached drawing are shown
Devices in accordance with embodiments of the present invention, architectural framework in the cards, function and the behaviour of method and computer program product
Make.In this regard, each box in flow chart or block diagram can represent a part for a module, program segment or code, institute
The part for stating module, program segment or code includes the executable instruction that one or more is used to implement defined logic function.
It should also be noted that at some as in the realization method replaced, the function that is marked in box can also be to be different from attached drawing
The order marked occurs.For example, two continuous boxes can essentially perform substantially in parallel, they sometimes can also be by
Opposite order performs, this is depending on involved function.It is also noted that each box in block diagram and/or flow chart,
And the combination of the box in block diagram and/or flow chart, function as defined in performing or the dedicated of action can be used to be based on hardware
System realize or can be realized with the combination of specialized hardware and computer instruction.
It should be noted that herein, term " comprising ", "comprising" or its any other variant are intended to non-row
His property includes, so that process, method, article or equipment including a series of elements not only include those elements, and
And it further includes other elements that are not explicitly listed or further includes as this process, method, article or equipment institute inherently
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including institute
State in process, method, article or the equipment of element that also there are other identical elements.
The foregoing is only a preferred embodiment of the present invention, is not intended to limit the invention, for the skill of this field
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.It should be noted that：Similar label and letter exists
Similar terms is represented in following attached drawing, therefore, once being defined in a certain Xiang Yi attached drawing, is then not required in subsequent attached drawing
It is further defined and is explained.
The above description is merely a specific embodiment, but protection scope of the present invention is not limited thereto, any
Those familiar with the art in the technical scope disclosed by the present invention, can readily occur in change or replacement, should all contain
Lid is within protection scope of the present invention.Therefore, protection scope of the present invention should be based on the protection scope of the described claims.
Claims (10)
1. a kind of conversion method of data format, which is characterized in that the described method includes：
Obtain multiple pending files；
The original file format of each pending file is converted into the first specified file format；
Multiple table spaces are established in the database, and for each table space, corresponding user name and sequence number are set；
Be converted into the first specified file format each pending file be directed into the database in corresponding table space into
Row storage；
Each pending file in the database is exported, and by the first specified file lattice of each pending file
Formula is converted to the second specified file format, and each pending file for being converted into the second specified file format is exported.
2. conversion method of data format according to claim 1, which is characterized in that described by each pending file
Before original file format is converted to the step of the first specified file format, the method further includes：
Configuration by the original file format of pending file be converted to the first specified file format and by pending file the
One specified file format is converted to the format converter tools of the second specified file format.
3. conversion method of data format according to claim 2, which is characterized in that described to be converted into the first specified file
Each pending file of form is directed into after the step of being stored in the database in corresponding table space, the method
It further includes：
The pending file of the first specified file format in the database is extracted, detection is converted to the first specified file format
Pending file file content it is whether identical with the file content of the pending file of original file format；
If differing, the configuration information of the format converter tools is changed, and is re-executed each pending file
Original file format is converted to the step of the first specified file format, until what is extracted is converted to first specified file format
Until the file content of pending file is identical with the file content of the pending file of original file format.
4. conversion method of data format according to claim 1, which is characterized in that each pending file corresponds to different
Area information, it is described acquisition multiple pending files the step of, including：
Corresponding multiple regions information is found according to look-up command；
Corresponding storage root is found according to each area information, pending text is extracted from the storage root
Part.
5. conversion method of data format according to claim 1, which is characterized in that described respectively to be treated in the database
The step of processing file is exported, including：
It is found in the database and the export corresponding sequence number of instruction and use according to export instruction input by user
Name in an account book；
Corresponding table space is found according to the sequence number and user name；
It extracts the pending file stored in the table space and exports.
6. conversion method of data format according to claim 1, which is characterized in that described to be converted into the first specified file
Each pending file of form is directed into after the step of being stored in the database in corresponding table space, the method
It further includes：
The file size data of each pending file is calculated, the file size data being calculated is preserved to each and described is treated
It handles in the corresponding table space of file.
7. conversion method of data format according to claim 1, which is characterized in that the pending file includes multiple sons
File, each pending file for being converted into the first specified file format are directed into corresponding table space in the database
In the step of being stored, including：
The corresponding multiple pending files for being converted to the first specified file format are obtained according to instruction is imported；
Each subfile in each pending file of acquisition is directed into the database successively respectively in corresponding table space
It is stored.
8. conversion method of data format according to claim 1, which is characterized in that the original file format is Word texts
Part form, first specified file format are pdf document form, and second specified file format is DMP file formats.
9. a kind of format conversion system, which is characterized in that the format conversion system includes：
File acquisition module, for obtaining multiple pending files；
First modular converter, for the original file format of each pending file to be converted to the first specified file format；
Establish module, for establishing multiple table spaces in the database, for each table space set corresponding user name and
Sequence number；
Import modul, each pending file for being converted into the first specified file format are directed into the database corresponding
Table space in stored；
Second modular converter, for each pending file in the database to be exported, and by each pending text
First specified file format of part is converted to the second specified file format, is converted into each pending of the second specified file format
File is exported.
10. a kind of electronic equipment including memory, processor and stores the calculating that can be run on a memory and on a processor
Machine program, which is characterized in that the processor realizes the method step described in claim 1-8 any one when performing described program
Suddenly.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810007970.2A CN108108478B (en) | 2018-01-04 | 2018-01-04 | Data format conversion method and system and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810007970.2A CN108108478B (en) | 2018-01-04 | 2018-01-04 | Data format conversion method and system and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108108478A true CN108108478A (en) | 2018-06-01 |
| CN108108478B CN108108478B (en) | 2020-05-05 |
Family
ID=62219870
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810007970.2A Active CN108108478B (en) | 2018-01-04 | 2018-01-04 | Data format conversion method and system and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108108478B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109522277A (en) * | 2018-10-10 | 2019-03-26 | 江苏中威科技软件系统有限公司 | A kind of method and apparatus that multi-format document is read |
| CN112269761A (en) * | 2020-11-18 | 2021-01-26 | 首都经济贸易大学 | File format conversion method, device, medium and equipment based on symbolic link |
| WO2023061220A1 (en) * | 2021-10-13 | 2023-04-20 | International Business Machines Corporation | Managing proprietary structured objects |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8554806B2 (en) * | 2004-05-14 | 2013-10-08 | Oracle International Corporation | Cross platform transportable tablespaces |
| CN104217396A (en) * | 2014-09-11 | 2014-12-17 | 广西桂能软件有限公司 | DWG (drawing) file format conversion method |
| CN104881469A (en) * | 2015-05-27 | 2015-09-02 | 北京京东尚科信息技术有限公司 | Data exporting method and device |
| CN105760501A (en) * | 2016-02-22 | 2016-07-13 | 深圳市茁壮网络股份有限公司 | Document format conversion method and device |
| CN106776515A (en) * | 2016-12-16 | 2017-05-31 | 刘立 | The method and device of data processing |
| CN107329989A (en) * | 2017-06-05 | 2017-11-07 | 无锡雅座在线科技股份有限公司 | Export method, the apparatus and system of data |
-
2018
- 2018-01-04 CN CN201810007970.2A patent/CN108108478B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8554806B2 (en) * | 2004-05-14 | 2013-10-08 | Oracle International Corporation | Cross platform transportable tablespaces |
| CN104217396A (en) * | 2014-09-11 | 2014-12-17 | 广西桂能软件有限公司 | DWG (drawing) file format conversion method |
| CN104881469A (en) * | 2015-05-27 | 2015-09-02 | 北京京东尚科信息技术有限公司 | Data exporting method and device |
| CN105760501A (en) * | 2016-02-22 | 2016-07-13 | 深圳市茁壮网络股份有限公司 | Document format conversion method and device |
| CN106776515A (en) * | 2016-12-16 | 2017-05-31 | 刘立 | The method and device of data processing |
| CN107329989A (en) * | 2017-06-05 | 2017-11-07 | 无锡雅座在线科技股份有限公司 | Export method, the apparatus and system of data |
Non-Patent Citations (3)
| Title |
|---|
| 冯荷飞等: "将Word表格数据导入Oracle中的数据入库中间件", 《计算机与现代化》 * |
| 杨黎等: "EAST文档自动化的研究与实现", 《计算机应用与软件》 * |
| 龚澍: "《Oracle数据库基础及应用》", 31 August 2016, 广东高等教育出版社 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109522277A (en) * | 2018-10-10 | 2019-03-26 | 江苏中威科技软件系统有限公司 | A kind of method and apparatus that multi-format document is read |
| CN112269761A (en) * | 2020-11-18 | 2021-01-26 | 首都经济贸易大学 | File format conversion method, device, medium and equipment based on symbolic link |
| WO2023061220A1 (en) * | 2021-10-13 | 2023-04-20 | International Business Machines Corporation | Managing proprietary structured objects |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108108478B (en) | 2020-05-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108108478A (en) | Conversion method of data format, system and electronic equipment | |
| CN101661509B (en) | Method for generating major key field of database table and device thereof | |
| CN104102737A (en) | Historical data storage method and system | |
| CN104881466B (en) | The processing of data fragmentation and the delet method of garbage files and device | |
| Keshavarz et al. | Minimizing total completion time in the flexible flowshop sequence-dependent group scheduling problem | |
| WO2017040209A1 (en) | Data preparation for data mining | |
| CN109522332A (en) | Customer profile data merging method, device, equipment and readable storage medium storing program for executing | |
| CN106407442B (en) | A kind of mass text data processing method and device | |
| CN111858730A (en) | Data importing and exporting device, method, equipment and medium of graph database | |
| Sun et al. | An undecomposed approach to control design for a class of nonlinear descriptor systems | |
| CN102707948A (en) | Source code generation method | |
| Mormul | Multi-dimensional Cartan prolongation and special k-flags | |
| CN102624545A (en) | Data backup method, data backup device, data recovery method and data recovery device of network management system | |
| CN108108392B (en) | Commodity data management method, commodity data management device, computer equipment and storage medium | |
| Dagur et al. | Optimization of Queries in Database of Cloud Computing | |
| CN108053034A (en) | Model parameter processing method, device, electronic equipment and storage medium | |
| CN109446201A (en) | A kind of method for sorting, device and the equipment of Excel table endorsement information | |
| Dong et al. | Comparisons of typical algorithms in negative sequential pattern mining | |
| CN113065659B (en) | Method and apparatus for eliminating quantum noise, electronic device, and medium | |
| CN107038555A (en) | A kind of BOM tables introduction method and device | |
| US10977249B2 (en) | Method, system, and apparatus for performing flow-based processing using stored procedure | |
| CN107291923A (en) | Information processing method and device | |
| CN113553425A (en) | Data aggregation method, device, equipment and storage medium based on RPA and AI | |
| CN103123635B (en) | A kind of data search method and the electronic equipment using this method | |
| CN102609510B (en) | Chinese name data processing method and device |
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 |