CN103177119A - Data type automatic conversion system and method based on database - Google Patents
Data type automatic conversion system and method based on database Download PDFInfo
- Publication number
- CN103177119A CN103177119A CN2013101214732A CN201310121473A CN103177119A CN 103177119 A CN103177119 A CN 103177119A CN 2013101214732 A CN2013101214732 A CN 2013101214732A CN 201310121473 A CN201310121473 A CN 201310121473A CN 103177119 A CN103177119 A CN 103177119A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- data type
- configuration file
- target software
- 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)
- Stored Programmes (AREA)
Abstract
The invention discloses a data type automatic conversion system and a data type automatic conversion method based on a database. The method comprises the following steps of: establishing a mapping table of a standard input document format field and a source database field, which are defined by target software in a configuration document; checking all configuration documents, and automatically reading a configuration document list; automatically connecting a corresponding source database according to the configuration documents, and reading corresponding data; and automatically generating a standard input text format document in accordance with the target software from data read from the corresponding source database according to the mapping table in the configuration document. According to the invention, by adopting the analysis function of the intelligent configuration documents, when novel data type conversion is increased, corresponding configuration documents are increased, the rapid data type conversion is realized automatically, and requirements to follow-up maintaining personnel are lowered greatly.
Description
Technical field
The present invention particularly relates to a kind of data type automated conversion system and method for based on database about a kind of data type automated conversion system and method.
Background technology
Klarity ACE is a kind of semiconductor Yield lmproved software, and is most important in semi-conductive manufacturing and production.At present, all data that import in Klarity ACE all must meet ACE SIFF (Standard Input File Format, standard files input form) form, the namely standard data format of ACE.And all data to be imported are all from MES (Manufacturing Execution System at present, what obtain manufacturing execution system) is kept at the aerial data of data, just must increase a data type transducer to these data importings in the ACE system.Due to the ACE use is Unix operating system and ORACLE database, data type converter must be used PRO*C mixed C language compilation, requirement to the author is relatively very high, construction cycle is also long, a kind of data of every increase just must rewrite to the ACE database and write and compile a brand-new data type converter, exploitation and the cost of safeguarding are all very high, and efficient is but very low.
Summary of the invention
The deficiency that exists for overcoming above-mentioned prior art, the present invention's purpose is to provide a kind of data type automated conversion system and method for based on database, it is by adopting the analytical capabilities of intelligent configuration file, when increasing new data type conversion, increase corresponding configuration file, automatically realize data type conversion fast, greatly reduced the requirement to the follow-up maintenance personnel.
For reaching above-mentioned and other purpose, the present invention proposes a kind of data type automated conversion system of based on database, comprises at least:
Mapping table is set up module, is used for setting up at configuration file the mapping table of a target software defined standard files input form field and source database field;
Configuration file reads module, is used for automatically reading each configuration file;
Database read delivery group from the corresponding source database that is dynamically connected, and is obtained corresponding data according to each configuration file; And
Normal data generates module, and the data that automatically will read from source database according to corresponding mapping table generate the standard files input formatted file that meets target software.
Further, this target software is Klarity ACE.
Further, after this database read delivery composition merit is connected to source database, obtain corresponding data according to every delegation shown data name of first row of configuration file.
Further, secondary series represents whether these data can be sky, if second classifies OPITIONAL as, these row can be sky, and second classify REQUIRED as, and these row can not be thought sky, otherwise think that there is mistake in these data, ignore this data, relevant information is recorded in journal file, continue to read the next column data.
For reaching above-mentioned and other purpose, the present invention also provides a kind of data type automatic switching method of based on database, comprises the steps:
Step 1 is set up the mapping table of a target software defined standard files input form field and database field in configuration file;
Step 2 checks all configuration files, automatically reads the profile list;
Step 3 from the corresponding source database that is dynamically connected, and reads corresponding data according to configuration file; And
Step 4, the data that automatically will read from the respective sources database according to the mapping table in configuration file generate the standard files input formatted file that meets target software.
Further, this target software is Klarity ACE.
Further, in step 3, after successfully being connected to source database, obtain corresponding data according to every delegation shown data name of first row of configuration file.
Further, secondary series represents whether these data can be sky, if second classifies OPITIONAL as, these row can be sky, and second classify REQUIRED as, and these row can not be thought sky, otherwise think that there is mistake in these data, ignore this data, relevant information is recorded in journal file, continue to read the next column data.
Compared with prior art, the data type automated conversion system of a kind of based on database of the present invention and method are by utilizing intelligent configuration file analytical capabilities, when increasing new data type conversion, only need to increase corresponding configuration file, just can realize fast data type conversion, greatly reduce the requirement to the follow-up maintenance personnel, only need to set configuration file according to the configuration file format of standard just can solve all problems for anyone.
Description of drawings
Fig. 1 is the system architecture diagram of the data type automated conversion system of a kind of based on database of the present invention;
Fig. 2 is the flow chart of steps of the data type automatic switching method of a kind of based on database of the present invention;
Fig. 3 is the process flow diagram of preferred embodiment of the data type automatic switching method of a kind of based on database of the present invention.
Embodiment
Below by specific instantiation and accompanying drawings embodiments of the present invention, those skilled in the art can understand other advantage of the present invention and effect easily by content disclosed in the present specification.The present invention also can be implemented or be used by other different instantiation, and the every details in this instructions also can be based on different viewpoints and application, carries out various modifications and change under spirit of the present invention not deviating from.
Fig. 1 is the system architecture diagram of the data type automated conversion system of a kind of based on database of the present invention.As shown in Figure 1, the data type automated conversion system of a kind of based on database of the present invention, be used for automatically data importing with dissimilar source database to target software, in preferred embodiment of the present invention, this target software is Klarity ACE, and the data type automated conversion system of this based on database comprises: mapping table is set up module 101, configuration file reads module 102, database read delivery group 103 and normal data and generates module 104.
Wherein, mapping table is set up the mapping table that module 101 is used for setting up at configuration file defined standard files input form (SIFF) field of target software and source database field; Configuration file reads module 102 and is used for automatically reading each configuration file that comprises mapping table; Database read delivery group 103 is used for according to each configuration file from being dynamically connected corresponding source database, and reads corresponding data; Normal data generates module 104 and is used for the data that read in source database being generated SIFF (standard files input form) file of standard according to the mapping table of configuration file.
in preferred embodiment of the present invention, ACE SIFF (Standard Input File Format) has defined the concrete form of each data, these data separate with comma, data of each line display, ACE inducting device (Loader) is resolved to every data line in the corresponding field of database automatically, for need to carrying out the SIFF data that data-switching converts standard to from other data base querying data, the field of the field of database and SIFF definition is one to one, therefore, in the present invention, need to set up the mapping table of a SIFF field and database field in configuration file, read module 102 by configuration file and automatically read configuration file, just can allow database read delivery group 103 read automatically corresponding database, and generate module 104 with the SIFF file of its generation standard by normal data, and no longer need just to develop the data type converter of a correspondence to the ACE database as often newly increasing class data in prior art.
Configuration file format is as follows:
With the Inline data instance, only need to place the file of inline.cfg by name in the catalogue of appointment, file content is as follows:
Wherein title and the user name password of the first behavior database that will connect.
After the present invention successfully is connected to database, obtain corresponding data according to every delegation shown data name of first row afterwards, secondary series represents whether these data can be sky, if second classifies OPITIONAL as these row can be sky, second classify as REQUIRED these row can not think sky, otherwise think that there is mistake in these data, ignore this data, relevant information is recorded in journal file, continues to read the next column data.
Fig. 2 is the flow chart of steps of the data type automatic switching method of a kind of based on database of the present invention.As shown in Figure 2, the data type automatic switching method of a kind of based on database of the present invention comprises the steps:
Fig. 3 is the process flow diagram of preferred embodiment of the data type automatic switching method of a kind of based on database of the present invention.As shown in Figure 3, the data type automatic switching method of the present invention's based on database comprises the steps:
Step 3.1, the user confirms to begin spanned file;
Step 3.2 checks all the .cfg files in specified folder, obtains the profile list;
Step 3.3, whether All Files is disposed, if be disposed, finishes; Otherwise enter step 3.4;
Step 3.4, the reading out data library information;
Step 3.5, the connection data storehouse;
Step 3.6 reads column information in configuration file;
Step 3.7, the related data in reading database generates the SIFF normal data.
As seen, in preferred embodiment of the present invention, when needs increase the data type conversion of new SIFF file, the engineering staff only needs to increase corresponding configuration file in the catalogue of appointment, automatically title and the content generation according to configuration file meets accordingly the data of SIFF standard and is saved in the file of appointment, no longer need any code development, saved a large amount of human resources, greatly shortened time and cycle that new data imports to ace server.
In sum, the data type automated conversion system of a kind of based on database of the present invention and method are by utilizing intelligent configuration file analytical capabilities, when increasing new data type conversion, only need to increase corresponding configuration file, just can realize fast data type conversion, greatly reduce the requirement to the follow-up maintenance personnel, only need to set configuration file according to the configuration file format of standard just can solve all problems for anyone.
Above-described embodiment is illustrative principle of the present invention and effect thereof only, but not is used for restriction the present invention.Any those skilled in the art all can under spirit of the present invention and category, modify and change above-described embodiment.Therefore, the scope of the present invention should be as listed in claims.
Claims (8)
1. the data type automated conversion system of a based on database comprises at least:
Mapping table is set up module, is used for setting up at configuration file the mapping table of a target software defined standard files input form field and source database field;
Configuration file reads module, is used for automatically reading each configuration file;
Database read delivery group from the corresponding source database that is dynamically connected, and is obtained corresponding data according to each configuration file; And
Normal data generates module, and the data that automatically will read from source database according to corresponding mapping table generate the standard files input formatted file that meets target software.
2. the data type automated conversion system of a kind of based on database as claimed in claim 1, it is characterized in that: this target software is Klarity ACE.
3. the data type automated conversion system of a kind of based on database as claimed in claim 1, it is characterized in that: after this database read delivery composition merit is connected to source database, obtain corresponding data according to every delegation shown data name of first row of configuration file.
4. the data type automated conversion system of a kind of based on database as claimed in claim 3, it is characterized in that: secondary series represents whether these data can be sky, if second classifies OPITIONAL as, these row can be sky, and second classify REQUIRED as, and these row can not be thought sky, otherwise think that there is mistake in these data, ignore this data, relevant information is recorded in journal file, continue to read the next column data.
5. the data type automatic switching method of a based on database, comprise the steps:
Step 1 is set up the mapping table of a target software defined standard files input form field and source database field in configuration file;
Step 2 checks all configuration files, automatically reads the profile list;
Step 3 from the corresponding source database that is dynamically connected, and reads corresponding data according to configuration file; And
Step 4, the data that automatically will read from the respective sources database according to the mapping table in configuration file generate the standard files input formatted file that meets target software.
6. the data type automatic switching method of a kind of based on database as claimed in claim 5, it is characterized in that: this target software is Klarity ACE.
7. the data type automatic switching method of a kind of based on database as claimed in claim 5, is characterized in that: in step 3, after successfully being connected to source database, obtain corresponding data according to every delegation shown data name of first row of configuration file.
8. the data type automatic switching method of a kind of based on database as claimed in claim 7, it is characterized in that: secondary series represents whether these data can be sky, if second classifies OPITIONAL as, these row can be sky, and second classify REQUIRED as, and these row can not be thought sky, otherwise think that there is mistake in these data, ignore this data, relevant information is recorded in journal file, continue to read the next column data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013101214732A CN103177119A (en) | 2013-04-09 | 2013-04-09 | Data type automatic conversion system and method based on database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013101214732A CN103177119A (en) | 2013-04-09 | 2013-04-09 | Data type automatic conversion system and method based on database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103177119A true CN103177119A (en) | 2013-06-26 |
Family
ID=48636980
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013101214732A Pending CN103177119A (en) | 2013-04-09 | 2013-04-09 | Data type automatic conversion system and method based on database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103177119A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105095518A (en) * | 2015-09-18 | 2015-11-25 | 中国农业银行股份有限公司 | Data conversion method and device |
| CN105681152A (en) * | 2016-03-08 | 2016-06-15 | 长沙博为软件技术股份有限公司 | Method for carrying out data forwarding in different networks |
| CN109783074A (en) * | 2018-12-11 | 2019-05-21 | 平安科技（深圳）有限公司 | The data type conversion method of programming, electronic equipment |
| CN111190860A (en) * | 2019-12-31 | 2020-05-22 | 中国银行股份有限公司 | Database configuration method and device |
| CN111367975A (en) * | 2018-12-25 | 2020-07-03 | 中国移动通信集团浙江有限公司 | Multi-protocol data conversion processing method and device |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5708828A (en) * | 1995-05-25 | 1998-01-13 | Reliant Data Systems | System for converting data from input data environment using first format to output data environment using second format by executing the associations between their fields |
| WO1998055946A1 (en) * | 1997-06-06 | 1998-12-10 | Madison Information Technologies, Inc. | System and method for transferring data between data sets |
| US5897645A (en) * | 1996-11-22 | 1999-04-27 | Electronic Data Systems Corporation | Method and system for composing electronic data interchange information |
| CN1704936A (en) * | 2004-05-31 | 2005-12-07 | 深圳宇龙计算机通信科技（深圳）有限公司 | Data conversion or synchronization method between data bases |
| CN101452450A (en) * | 2007-11-30 | 2009-06-10 | 上海市电力公司 | Multiple source data conversion service method and apparatus thereof |
| CN101739452A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Data exchange interface and realizing method thereof |
| CN101789021A (en) * | 2010-02-24 | 2010-07-28 | 浪潮通信信息系统有限公司 | Universal configurable database data migration method |
-
2013
- 2013-04-09 CN CN2013101214732A patent/CN103177119A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5708828A (en) * | 1995-05-25 | 1998-01-13 | Reliant Data Systems | System for converting data from input data environment using first format to output data environment using second format by executing the associations between their fields |
| US5897645A (en) * | 1996-11-22 | 1999-04-27 | Electronic Data Systems Corporation | Method and system for composing electronic data interchange information |
| WO1998055946A1 (en) * | 1997-06-06 | 1998-12-10 | Madison Information Technologies, Inc. | System and method for transferring data between data sets |
| CN1704936A (en) * | 2004-05-31 | 2005-12-07 | 深圳宇龙计算机通信科技（深圳）有限公司 | Data conversion or synchronization method between data bases |
| CN101452450A (en) * | 2007-11-30 | 2009-06-10 | 上海市电力公司 | Multiple source data conversion service method and apparatus thereof |
| CN101739452A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Data exchange interface and realizing method thereof |
| CN101789021A (en) * | 2010-02-24 | 2010-07-28 | 浪潮通信信息系统有限公司 | Universal configurable database data migration method |
Non-Patent Citations (1)
| Title |
|---|
| 袁成立: "基于XML的海洋环境信息数据格式转换", 《CNKI中国优秀硕士学位论文全文数据库》, 15 November 2009 (2009-11-15) * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105095518A (en) * | 2015-09-18 | 2015-11-25 | 中国农业银行股份有限公司 | Data conversion method and device |
| CN105095518B (en) * | 2015-09-18 | 2018-10-16 | 中国农业银行股份有限公司 | A kind of data transfer device and device |
| CN105681152A (en) * | 2016-03-08 | 2016-06-15 | 长沙博为软件技术股份有限公司 | Method for carrying out data forwarding in different networks |
| CN109783074A (en) * | 2018-12-11 | 2019-05-21 | 平安科技（深圳）有限公司 | The data type conversion method of programming, electronic equipment |
| CN111367975A (en) * | 2018-12-25 | 2020-07-03 | 中国移动通信集团浙江有限公司 | Multi-protocol data conversion processing method and device |
| CN111367975B (en) * | 2018-12-25 | 2023-11-03 | 中国移动通信集团浙江有限公司 | Multi-protocol data conversion processing method and device |
| CN111190860A (en) * | 2019-12-31 | 2020-05-22 | 中国银行股份有限公司 | Database configuration method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| TWI698813B (en) | Method and device for data storage and query based on blockchain | |
| KR102317535B1 (en) | Methods and systems for implementing data tracking with software development kits | |
| CN104133772B (en) | Automatic test data generation method | |
| CN102968306B (en) | A kind of code automatic generation method based on data model driving and system | |
| CN107644286B (en) | Workflow processing method and device | |
| CN102722372B (en) | Method and system for automatically generating codes through classification and configuration | |
| CN103425468B (en) | Plug-in type software integrating method and device | |
| WO2020233330A1 (en) | Batch testing method, apparatus, and computer-readable storage medium | |
| CN101739390B (en) | Data transformation based on a technical design document | |
| CN103177119A (en) | Data type automatic conversion system and method based on database | |
| CN103019684A (en) | Dynamic template-based business page configuring method | |
| CN107357593A (en) | Source code file construction method, device, electric terminal and readable storage medium storing program for executing | |
| CN103995698A (en) | Application form agile development method and system oriented to business | |
| CN104915262A (en) | Calibration system and method based on EXCEL data structure | |
| CN108073688B (en) | Data migration method and device | |
| US8577848B2 (en) | Converting two-tier resource mapping to one-tier resource mapping | |
| EP3444725A1 (en) | Man-machine interaction method and device therefor | |
| CN104216961A (en) | Method and device for data processing | |
| CN103955361A (en) | Modular development and publishing system for automatic compiling and establishing of web front-end codes | |
| CN105278961A (en) | Method and system for generating database table structure document | |
| CN105760172A (en) | Statement generation method based on itext | |
| CN103678396A (en) | Data backup method and device based on data models | |
| CN104991810A (en) | Method and processing system for automatically adding APK into Android system | |
| CN102073688A (en) | Device for converting client form to Web page and method thereof | |
| CN104462631A (en) | Circuit diagram generating device and circuit diagram generating method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20130626 |
|
| WD01 | Invention patent application deemed withdrawn after publication |