CN101241486A - Data replication process - Google Patents
Data replication process Download PDFInfo
- Publication number
- CN101241486A CN101241486A CNA2007100268301A CN200710026830A CN101241486A CN 101241486 A CN101241486 A CN 101241486A CN A2007100268301 A CNA2007100268301 A CN A2007100268301A CN 200710026830 A CN200710026830 A CN 200710026830A CN 101241486 A CN101241486 A CN 101241486A
- Authority
- CN
- China
- Prior art keywords
- data
- input
- comparisons
- field
- read
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a method of data duplication, applied in a computer system, the computer system includes at least one electronic file and a database, the method firstly reads the electronic file corresponding to one file identifying information of the computer system, the sort of the data output mapping table stored in the electronic file is judged according to a data identifying information in the computer system, then reading the names of all input fields in the data input mapping table, thereafter, the names of the storage fields corresponding to one data storage mapping table in the database is read according to the sort of the data input mapping table, if the name of each input field is accordance with each storage field respectively, in other words, reading the input data stored in each input field, and output the data in each storage field corresponding to the duplication, if so, the position of the data in the electronic file is directly copied in the database.
Description
[technical field]
The invention relates to the method that data are duplicated, refer to especially a kind of can be with the data in the electronic record stored in the computer system, in the corresponding database that copies in this computer system.
[background technology]
The world today is an Information technologyization, the epoch that electronic industry is flourish, various high-tech products of deriving by micro computer, the electronic equipment development rapidly, on the spot and brought greatest convenience for daily life, along with current various electronics technologies constantly research and development with progress greatly, people also relatively improve for the request for utilization of all types of electric consumers, enterprise more watches out for oneself with high-quality as standard to the requirement of self product whereby, just giving QC personnel and tester supervises product, the responsibility of test is to improve the good bad state of product and to be added up.
By QC personnel and tester when working every day, all need the situation of keyholed back plate product all the time, and note down the project testing related data content of product in a large number, for example: raw readings project management data, testing progress, the problem that test is produced, test report, minutes ... Deng, and the project testing related data of every kind of product all has fixing project, insert relevant content to provide QC personnel and tester to contrast each project name, make the content of project testing related data of every kind of product more attain in full and accurate complete, with in response in the future processing operation, general speech, QC personnel and tester arrive numerous and diverse project testing related data build file in its employed computer by electronics document softwares such as Excel or Word.
For making project testing related data content be able to effectively be used, and for integrating the test data of each measuring unit, QC personnel and tester remove to be needed numerous and diverse project testing related data build file in own employed computer, still need and in addition the project testing related data is placed in the database, by a large amount of test data of long-term accumulated, when any abnormal problem takes place in product, treatment people can see through the relevant data of database fast searching, unusual reason takes place by finding out product fast, to promote operating efficiency, shorten the issue handling time, make the quality keyholed back plate of product and product detect more efficient.
But, all there is every day bulk items to survey the formula related data, but removing, QC personnel and tester need item is estimated formula related data build file in PC, still need and re-enter a range estimation formula related data in addition in database, this kind secondary repeats the workflow of operation, not only quite waste of manpower, and take a large amount of time, therefore, how improving aforesaid workflow, is very urgent at present and an important topic that need to be resolved hurrily in fact.
[summary of the invention]
The method that provides a kind of data to duplicate is provided a purpose of the present invention, to improve aforementioned QC personnel and tester, need repeat to import identical item range estimation formula related data in shortcomings such as computer and databases.
A purpose of the present invention, the method that provides a kind of data to duplicate, be applied in the computer system, this computer system comprises at least one e-file and a database, this method is according to an archives identification information of depositing in this computer system, read the electronic record that conforms to this archives identification information, again according to a data identification information that stores in this computer system, to judge the classification of the data input table of comparisons that stores in this electronic record, read the title of input fields all in this data input table of comparisons again, and according to the classification of this data input table of comparisons, read the title of the storage field of the corresponding data storing table of comparisons in this database, if the title of each input field conforms to the title that each stores field respectively, promptly read stored input data in each input field, and copying in each storage field of this input data correspondence respectively.
Compared with prior art, archives identification information and the data identification information of the present invention in this computer system, reach the data input table of comparisons that duplicates this e-file stores the table of comparisons to this data of database purpose, after often writing data sheet with the engineering staff who avoids each department of intra-company, need on this computer system, write once again more in addition.
For making purpose of the present invention, structural attitude and function thereof are had further understanding, conjunction with figs. is described in detail as follows now:
[description of drawings]
Fig. 1 is the circuit box synoptic diagram of computer system of the present invention;
Fig. 2 is one of flow chart of steps of the present invention;
Fig. 3 is two of a flow chart of steps of the present invention;
Fig. 4 is the synoptic diagram of Word file or Txt shelves for electronic record of the present invention;
Fig. 5 is the synoptic diagram of Excel file for electronic record of the present invention.
[embodiment]
The method that the present invention duplicates for a kind of data, see also shown in Figure 1, be applied on the computer system 1, this computer system 1 comprises at least one electronic record 11 and a database 12, this electronic record 11 product item test related data of making wherein for each measuring unit, see also shown in Figure 2ly, this method is handled according to the following step:
(101) according to a stored archives identification information in this computer system 1, read the electronic record 11 that conforms to this archives identification information;
In a most preferred embodiment of the present invention, when this method when reading with electronic record 11 that this archives identification information conforms to, read several stored in this archives identification information extension name titles (for example doc, txt, xls earlier ... Deng), read the extension name of this electronic record 11 again, if judging the extension name of this electronic record 11 conforms to one of them extension name title, promptly represent this electronic record 11 for data can be copied to the object of this database 12, promptly read this electronic record 11.
(102), judge the classification of the data input table of comparisons 110 stored in this electronic record 11 according to a stored data identification information in this computer system 1;
In the present invention, see also shown in Figure 3ly, this method is judged the classification of this data input table of comparisons 110 according to the following step:
(201) read a stored class formative in this data identification information;
In this embodiment, this classification sign can be a character string (as: A, B, C ... Deng) or memory location numbering (as: the 1st row A row, the 1st row B row ... Deng).
(202) search this data input table of comparisons 110 according to this classification sign, judge in this data input table of comparisons 110 whether have this classification sign, if, promptly proceed step (203), otherwise, carry out step (207);
(203) read the pairing categorical data of this classification sign;
(204) read several stored item names in this data identification information;
(205) judge whether these classification data conform to one of them item name, if, promptly proceed step (206), otherwise, carry out step (207);
(206) proceed to read the step that these data are imported input fields all in table of comparisons 110 again; And
(207) classification of this electronic record 11 is judged in termination.
So, by the classification of judging this electronic record 11, can avoid unnecessary data is copied in this database 12.
(103) read the title that these data are imported input fields all in table of comparisons 110;
In the present invention, see also Fig. 1 again, Fig. 4 and shown in Figure 5, during the title of this method all input fields in reading this data input table of comparisons 110, earlier according to several field signs that store in this data identification information, search this data input table of comparisons 110, whether there are these field signs in this data input table of comparisons 110, if, promptly read the title of the pairing input field of these field signs, otherwise, stop to read the title of the pairing input field of these field signs, in addition, these field signs can be a mutually different character string (as: A, B, C ... Deng), or be mutually different memory location numbering (as: the 1st row A row, the 1st row B row ... Deng).
(104), read the title of the storage field of a corresponding data storing table of comparisons 120 in this database 12 according to the classification of this data input table of comparisons 110; And
In the present invention, see also Fig. 1, Fig. 4 and shown in Figure 5 again, this method is in reading each input field during stored input data, according to pairing at least one Data Labels of each field sign, search this data input table of comparisons 110 earlier, to judge in this data input table of comparisons 110 whether have this Data Labels, if, promptly read pairing these input data of this Data Labels, otherwise, stop to read pairing these input data of this Data Labels.
(105) if the title of each input field in this data input table of comparisons 110, conform to each title that stores field in this data storing table of comparisons 120 respectively, promptly read input data stored in each input field, and respectively in this data storing table of comparisons 120 each of copying to of this input data correspondence stores in field.
In the present invention, see also Fig. 4 and shown in Figure 5 again, this method reads these stored input data after the title of each input field, till reading an end mark (for example: space, Enter) in reading each input field during stored input data in regular turn.
So, through above-mentioned disclosed steps flow chart, can be by the archives identification information and the data identification information of 1 li of this computer system, reach the purpose that the data input table of comparisons 110 that duplicates this e-file arrives the data storing table of comparisons 1 20 of this database 12, after often writing data sheet with the engineering staff who avoids each department of intra-company, need on this computer system 1, to write again once more in addition, so, data sheet is incorporated on this computer system 1 function that can conveniently have access to for the engineering staff of each department in the future by this data copy method.
Now lift an instantiation to illustrate further method of the present invention, as Fig. 1 and shown in Figure 4, when this electronic record 11 is Word file or Txt shelves, after the user distinguishes the expansion doc by name or txt of this electronic record 11 through this computer system 1, just read this data input table of comparisons 110 in this electronic record 11, then judge the classification of this data input table of comparisons 110 in this electronic record 11 again, when in reading field, being " A ", the field interior " Bug tables of data " of promptly differentiating its rear is item name, and meet with one of them item name in the data storing table of comparisons 120 of this database 12, when in reading field, being " B " again, each field of promptly differentiating its rear delegation is a field name, be " Issue Date " in regular turn, " Brief ", " Description " reaches " Step ", and the field name in the data storing table of comparisons 120 corresponding and this database 12 is consistent, and the input data at " Issue Date " rear are " Data-1 " ... Deng, and then read " Data-1 " at " Issue Date " rear ... Deng input during data, in regular turn with " Data-1 " ... Deng the input data, corresponding read in this data storing table of comparisons 120 each and store in field, when reading null field, read " Data-2 " at " Brief " rear ... Deng input during data, in regular turn with " Data-2 " ... Deng the input data, corresponding read in this data storing table of comparisons 120 each and store in field, when reading null field, read " Data-3 " at " Description " rear ... Deng input during data, in regular turn with " Data-3 " ... Deng the input data, corresponding read in this data storing table of comparisons 120 each and store in field, when reading null field, read " Data-4 " at " Step " rear ... Deng input during data, in regular turn with " Data-4 " ... Deng the input data, corresponding read in this data storing table of comparisons 120 each and store in field, stop interpretation after the input data are Enter up to reading.
Now lift another instantiation again to illustrate further method of the present invention, as Fig. 1 and shown in Figure 5, when this electronic record 11 is the Excel file, the user sees through the expansion axles by name that this computer system 1 is distinguished this electronic record 11, xml ... Deng after, just read this electronic record 11, in this data input table of comparisons 110, then judge the classification of this data input table of comparisons 110 in this electronic record 11 again, when reading the pairing memory location of row 1 row A, " the Bug tables of data " promptly differentiated in the row 1 row A is item name, and row 2 row A, B, C, D ... pairing memory location is a field name, be respectively " Issue Date ", " Brief ", " Description " reaches " Step " ... Deng, and the field name in the data storing table of comparisons 120 corresponding and this database 12 is consistent, and row A capable 3,4 ... Deng, row B capable 3,4 ... Deng, row C capable 3,4 ... Deng and row D capable 3,4 ... etc. pairing memory location is " Issue Date ", " Brief ", when " Description " reaches the input data of " Step ", to be listed as A capable 3,4 ... Deng in this data storing table of comparisons 120 each of reading of input data correspondence store in field, to be listed as A capable 3,4 ... Deng the input data, corresponding read in this data storing table of comparisons 120 each and store in field, when reading blank memory location, to be listed as B capable 3,4 ... Deng the input data, corresponding read in this data storing table of comparisons 120 each and store in field, when reading blank memory location, to be listed as C capable 3,4 ... Deng the input data, corresponding read in this data storing table of comparisons 120 each and store in field, when reading blank memory location, to be listed as D capable 3,4 ... Deng the input data, corresponding read in this data storing table of comparisons 120 each and store in field, after reading blank memory location, stop interpretation.
In the present invention, make this data input table of comparisons 110 and these data storing table of comparisons 120 corresponding bindings by this computer system 1, and after this data input table of comparisons 110 copied to this data storing table of comparisons 120, can retrieve for the user, see through stored data in this data storing table of comparisons 120, can retrieve the related data that the user needs fast.
Claims (11)
1. the method that data are duplicated is applied on the computer system, and this computer system comprises at least one electronic record and a database, it is characterized in that this method comprises the steps:
Archives identification information according to stored in this computer system reads the electronic record that conforms to this archives identification information;
According to a data identification information stored in this computer system, judge the classification of the data input table of comparisons stored in this electronic record;
Read the title of input fields all in this data input table of comparisons;
According to the classification of this data input table of comparisons, read the title of the storage field of a corresponding data storing table of comparisons in this database; And
The title of each input field in this data input table of comparisons, conform to each title that stores field in this data storing table of comparisons respectively, promptly read input data stored in each input field, and respectively in this data storing table of comparisons each of copying to of this input data correspondence stores in field.
2. the method that data as claimed in claim 1 are duplicated is characterized in that this method when reading with electronic record that this archives identification information conforms to, more comprises the following steps:
Read several stored extension name titles in this archives identification information;
Read the extension name of this electronic record; And
When the extension name of this electronic record conforms to one of them extension name title, promptly read this electronic record.
3. the method that data as claimed in claim 1 are duplicated is characterized in that this method judges the classification of this data input table of comparisons according to the following step:
Search this data input table of comparisons according to a class formative stored in this data identification information, in this data input table of comparisons, exist such not indicate, promptly read the pairing categorical data of this classification sign;
Read several stored item names in this data identification information; And
When these classification data conform to one of them item name, promptly proceed to read the step of input fields all in this data input table of comparisons again.
4. the method that data as claimed in claim 3 are duplicated is characterized in that: this classification is masked as a character string.
5. the method that data as claimed in claim 3 are duplicated is characterized in that: this classification is masked as memory location numbering.
6. the method that data as claimed in claim 1 are duplicated, it is characterized in that: during the title of this method all input fields in reading this data input table of comparisons, earlier according to several field signs that store in this data identification information, search this data input table of comparisons, in this data input table of comparisons, there are these field signs, promptly read the title of the pairing input field of these field signs.
7. the method that data as claimed in claim 6 are duplicated is characterized in that: these field signs are respectively a mutually different character string.
8. the method that data as claimed in claim 6 are duplicated is characterized in that: these field signs are respectively mutually different memory location numbering.
9. the method that data as claimed in claim 6 are duplicated, it is characterized in that: this method is in reading each input field during stored input data, earlier according to pairing at least one Data Labels of each field sign, search this data input table of comparisons, in this data input table of comparisons, there is this Data Labels, promptly reads pairing these input data of this Data Labels.
10. the method that data as claimed in claim 9 are duplicated is characterized in that: this Data Labels is a memory location numbering.
11. the method that data as claimed in claim 6 are duplicated, it is characterized in that: this method is in reading each input field during stored input data, read these stored input data after the title of each input field in regular turn, till reading an end mark.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007100268301A CN101241486A (en) | 2007-02-08 | 2007-02-08 | Data replication process |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007100268301A CN101241486A (en) | 2007-02-08 | 2007-02-08 | Data replication process |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101241486A true CN101241486A (en) | 2008-08-13 |
Family
ID=39933023
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2007100268301A Pending CN101241486A (en) | 2007-02-08 | 2007-02-08 | Data replication process |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101241486A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103606075A (en) * | 2013-11-19 | 2014-02-26 | 杭州师范大学 | Method for processing mail attachment application form |
| CN104281501A (en) * | 2013-07-08 | 2015-01-14 | 联想(北京)有限公司 | Method and device for obtaining Snapshot and electronic device |
| CN104715359A (en) * | 2015-04-03 | 2015-06-17 | 广东中建普联科技有限公司 | Identity management method for material files and material data of structure construction industry |
| CN104881762A (en) * | 2015-06-25 | 2015-09-02 | 中铁四局集团有限公司 | Engineering quantity list decomposition method and system |
| CN104978307A (en) * | 2015-06-25 | 2015-10-14 | 中铁四局集团有限公司 | List processing method and apparatus |
| CN105069542A (en) * | 2015-06-25 | 2015-11-18 | 中铁四局集团有限公司 | Responsibility cost budget drafting method and system |
| CN105975452A (en) * | 2016-05-12 | 2016-09-28 | 中国电子科技集团公司第四十研究所 | Test form integrating method and system based on mapping configuration file and index template |
-
2007
- 2007-02-08 CN CNA2007100268301A patent/CN101241486A/en active Pending
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104281501A (en) * | 2013-07-08 | 2015-01-14 | 联想(北京)有限公司 | Method and device for obtaining Snapshot and electronic device |
| CN104281501B (en) * | 2013-07-08 | 2018-03-27 | 联想(北京)有限公司 | A kind of Snapshot implementation method, device and electronic equipment |
| CN103606075A (en) * | 2013-11-19 | 2014-02-26 | 杭州师范大学 | Method for processing mail attachment application form |
| CN104715359A (en) * | 2015-04-03 | 2015-06-17 | 广东中建普联科技有限公司 | Identity management method for material files and material data of structure construction industry |
| CN104715359B (en) * | 2015-04-03 | 2017-11-17 | 广东中建普联科技股份有限公司 | A kind of structuring construction industry material file and material data identification management method |
| CN104881762A (en) * | 2015-06-25 | 2015-09-02 | 中铁四局集团有限公司 | Engineering quantity list decomposition method and system |
| CN104978307A (en) * | 2015-06-25 | 2015-10-14 | 中铁四局集团有限公司 | List processing method and apparatus |
| CN105069542A (en) * | 2015-06-25 | 2015-11-18 | 中铁四局集团有限公司 | Responsibility cost budget drafting method and system |
| CN105975452A (en) * | 2016-05-12 | 2016-09-28 | 中国电子科技集团公司第四十研究所 | Test form integrating method and system based on mapping configuration file and index template |
| CN105975452B (en) * | 2016-05-12 | 2019-02-05 | 中国电子科技集团公司第四十一研究所 | Testing journal sheet's integration method and system based on Map Profile and indicator template |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101241486A (en) | Data replication process | |
| Li | Knowledge gathering and matching in heterogeneous databases | |
| US20080250073A1 (en) | Sql change tracking layer | |
| Lin | Higher education research methodology-literature method. | |
| Greenberg | A quantitative categorical analysis of metadata elements in image‐applicable metadata schemas | |
| CN108846102B (en) | Laboratory data management system and computer program for quality inspection center of medium-stored grains | |
| CN102768656A (en) | Method, system and device for processing reading record | |
| CN101536029A (en) | Failure countermeasure supporting system for mobile vehicle | |
| CN111125116B (en) | Method and system for positioning code field in service table and corresponding code table | |
| CN109871473A (en) | A kind of method of pair of project file and Database full-text search document | |
| CN101770503B (en) | File packing and unpacking method | |
| Ayres | Case studies in implementing functional requirements for bibliographic records [FRBR]: AustLit and MusicAustralia | |
| CN103309929B (en) | Storage and the method and system of retrieval data | |
| CA3110718A1 (en) | Data deduplication and data merging | |
| Kim | On three major holes in data warehousing today | |
| CN114372104A (en) | Electronic file metadata acquisition tool and method with good compatibility | |
| TW420777B (en) | A query method of dynamitic attribute database management | |
| CN216784257U (en) | Tobacco sale explicit code price marking tool box | |
| Coburn et al. | LIDO–Lightweight information describing objects | |
| Mayer et al. | Establishing context of digital objects’ creation, content and usage | |
| CN113435701B (en) | Method and device for processing consumption quality information | |
| US8285741B1 (en) | Technical order data type 1 dataset Builder | |
| TWI312964B (en) | ||
| CN101276340A (en) | Patent data retrieval system | |
| RU134679U1 (en) | AUTOMATED HISTORICAL DATABASE FORMATION SYSTEM BY THE HISTORY OF MEDICINE |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20080813 |