CN108920547A - Based on full-service uniform data center data among heterogeneous databases library field type mapping boosts method - Google Patents
Based on full-service uniform data center data among heterogeneous databases library field type mapping boosts method Download PDFInfo
- Publication number
- CN108920547A CN108920547A CN201810615074.4A CN201810615074A CN108920547A CN 108920547 A CN108920547 A CN 108920547A CN 201810615074 A CN201810615074 A CN 201810615074A CN 108920547 A CN108920547 A CN 108920547A
- Authority
- CN
- China
- Prior art keywords
- type
- oracle
- source
- powerdesigner
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to full-service uniform data center data among heterogeneous databases library field type mapping boosts method is based on, source table structure is exported first with Oracle PL/SQL tool；In PowerDesigner software, table statement is built for Oracle for source, modifies its data source Oracle type, the table statement of building come will have been exported and imported into PowerDesigner software；Then by PowerDesigner software, to VARCHAR (4000), GEOMETRY special field type carries out Batch conversion, output sql sentence is carried out to the result after conversion, to promote synchronous efficiency.
Description
Technical field
The present invention relates to tables of data process field, it is especially a kind of based on full-service uniform data center heterogeneous database it
Spatial database field type mapping boosts method.
Background technique
According to《State Grid Corporation of China is about the notice for printing and distributing the center construction scheme of company's full-service uniform data》（State's household electrical appliances
Net letter is (2016) No. 509 logical）,《State Grid Corporation of China is about printing and distributing information New Communication Technology innovation and development action plan in 2016
The notice of implementation guideline》（National grid letter is (2016) No. 89 logical）Related request, to accelerate to implement 5 sets of core system data access
Work.In early December, 2016, State Grid Jibei Electric Power Co., Ltd.（Hereinafter referred to as：Ji Bei company）Power information is organized to adopt
Collection, scheduling D5000, sales service application, the concentrations such as PMS2.0 deployment business application system historical data and incremental data connect
Enter work.
The tables of data for being directed to traditional full-service uniform data center is all manual creation, and the table quantity being related to is more,
Type is complex, heavy workload, inefficiency.
Summary of the invention
In view of this, the purpose of the present invention is to propose to one kind based on number between the heterogeneous database of full-service uniform data center
According to library field type mapping boosts method, realizes from traditional artificial individual and build the jump that table builds to automatic batch table, mention significantly
The working efficiency for having risen the access of full-service data center, improves the accuracy of data access.
The present invention is realized using following scheme：One kind being based on full-service uniform data center data among heterogeneous databases library
Field type mapping boosts method, includes the following steps：
Step S1：Source table structure is exported using Oracle PL/SQL tool；In PowerDesigner software, it is for source
Oracle's builds table statement, modifies its data source Oracle type, will export the table statement of building come and has imported into
PowerDesigner software；
Step S2：By PowerDesigner software, to VARCHAR (4000), GEOMETRY special field type carries out batch
Conversion carries out output sql sentence to the result after conversion, to promote synchronous efficiency.
Further, step S1 further includes before exporting source table structure using Oracle PL/SQL tool：To former industry
The database VARCHAR (4000) of business system, GEOMETRY field are counted, and are counted to tables of data to be accessed, right
Table comprising VARCHAR (4000), GEOMETRY field is combed.
Further, the step S2 specifically includes following steps：
Step S21：Oracle is carried out to the target database MYSQL type that needs are converted by PowerDesigner software
The conversion of table statement is built to MySQL；
Step S22：It is mapped for source VARCHAR (4000) field, is substituted for TEXT type；
Step S23：It is mapped for source GEOMETRY field type, is substituted for TEXT type；
Step S24：Output target database MYSQL type builds table sql sentence.
The invention firstly uses Oracle PL/SQL tools to export source table structure, in PowerDesigner software, needle
Table statement is built for Oracle to source, modifies its data source Oracle type, the table statement of building come will have been exported and imported into
PowerDesigner software；Then by PowerDesigner software, to VARCHAR (4000), GEOMETRY special field
Type carries out Batch conversion, output sql sentence is carried out to the result after conversion, to promote synchronous efficiency.
Compared with prior art, the invention has the following beneficial effects：To in the process of construction of full-service uniform data center, source
The access of operation system data is able to solve the mapping of data among heterogeneous databases library field type not using method of the invention
Unanimously, not corresponding problem is realized from traditional artificial individual and builds the jump that table builds to automatic batch table, greatly improves full industry
The working efficiency of business data center access, improves the accuracy of data access.
Detailed description of the invention
Fig. 1 is that source data of embodiment of the present invention table Oracle PL/SQL exports tool schematic diagram；
Fig. 2 is PowerDesigner of embodiment of the present invention tool loads document flow schematic diagram；
Fig. 3 is that PowerDesigner of embodiment of the present invention tool loads select type of database schematic diagram；
Fig. 4 is that PowerDesigner of embodiment of the present invention tool loads file confirms interface schematic diagram；
Fig. 5 is the type of database flow diagram that PowerDesigner of the embodiment of the present invention changes target；
Fig. 6 is the type of database schematic diagram of PowerDesigner of embodiment of the present invention selection target；
Fig. 7 is PowerDesigner of embodiment of the present invention conversion database type success interface schematic diagram.
Specific embodiment
The present invention will be further described with reference to the accompanying drawings and embodiments.
It present embodiments provides a kind of based on full-service uniform data center data among heterogeneous databases library field type
Mapping boosts method, includes the following steps：
Step S1：Source table structure is exported using Oracle PL/SQL tool；In PowerDesigner software, it is for source
Oracle's builds table statement, modifies its data source Oracle type, will export the table statement of building come and has imported into
PowerDesigner software；
Step S2：By PowerDesigner software, to VARCHAR (4000), GEOMETRY special field type carries out batch
Conversion carries out output sql sentence to the result after conversion, to promote synchronous efficiency.
In the present embodiment, step S1 further includes before exporting source table structure using Oracle PL/SQL tool：It is right
The database VARCHAR (4000) of former operation system, GEOMETRY field are counted, and are united to tables of data to be accessed
Meter, combs the table comprising VARCHAR (4000), GEOMETRY field.
In the present embodiment, the step S2 specifically includes following steps：
Step S21：Oracle is carried out to the target database MYSQL type that needs are converted by PowerDesigner software
The conversion of table statement is built to MySQL；
Step S22：It is mapped for source VARCHAR (4000) field, is substituted for TEXT type；
Step S23：It is mapped for source GEOMETRY field type, is substituted for TEXT type；
Step S24：Output target database MYSQL type builds table sql sentence.
Particularly, the detailed step of the present embodiment is as follows：
1. sources operation system data dictionary batch exports：
By exporting source table structure using Oracle PL/SQL tool, as shown in Figure 1, table needed for selection, exports oracle
The sql of format builds table statement, is stored in local.
2.PowerDesigner tool loads sql builds table statement：
By opening PowerDesigner tool, the sql for opening export oracle format builds table statement, as shown in Fig. 2, selection
" reverse engineer " is opened " database ", local sql is selected to build table statement file, selects data source data library
Then type, such as Fig. 3 jump out loading page, confirmation path is errorless, click and determine, such as Fig. 4.
3.Oracle to MySQL builds the conversion of table statement：
Table statement is built for the sql loaded in PowerDesigner tool, modifies the data source to be converted, is opened
" database " menu of PowerDesigner tool selects " change current dbms " such as Fig. 5.What selection needed to modify
Type of database, such as Fig. 6 are clicked and are determined, convert it is errorless after export result such as Fig. 7, what display had been converted into MySQL builds predicative
Sentence.
4. special field type carries out specially treated：
Batch is carried out with UltraEdit tool and replaces specific type, and MySQL is built into table statement " VARCHAR (4000) ",
" GEOMETRY " types of batch is substituted for the text type of MYSQL database, saves file.
Tables of data is created in 5.MYSQL database
Table statement is built in the execution of the MYSQL database ultimately generated using navicat tool loads, realizes batch creation table knot
Structure ensure that the accuracy of table structure, build the success rate of table.
The foregoing is merely presently preferred embodiments of the present invention, all equivalent changes done according to scope of the present invention patent with
Modification, is all covered by the present invention.
Claims (3)
1. one kind is based on full-service uniform data center data among heterogeneous databases library field type mapping boosts method, special
Sign is：Include the following steps：
Step S1：Source table structure is exported using Oracle PL/SQL tool；In PowerDesigner software, it is for source
Oracle's builds table statement, modifies its data source Oracle type, will export the table statement of building come and has imported into
PowerDesigner software；
Step S2：By PowerDesigner software, to VARCHAR (4000), GEOMETRY special field type carries out batch
Conversion carries out output sql sentence to the result after conversion, to promote synchronous efficiency.
2. according to claim 1 a kind of based on full-service uniform data center data among heterogeneous databases library field class
Type mapping boosts method, it is characterised in that：Step S1 is also wrapped before exporting source table structure using Oracle PL/SQL tool
It includes：The database VARCHAR (4000) of former operation system, GEOMETRY field are counted, to tables of data to be accessed into
Row statistics, combs the table comprising VARCHAR (4000), GEOMETRY field.
3. according to claim 1 a kind of based on full-service uniform data center data among heterogeneous databases library field class
Type mapping boosts method, it is characterised in that：The step S2 specifically includes following steps：
Step S21：Oracle is carried out to the target database MYSQL type that needs are converted by PowerDesigner software
The conversion of table statement is built to MySQL；
Step S22：It is mapped for source VARCHAR (4000) field, is substituted for TEXT type；
Step S23：It is mapped for source GEOMETRY field type, is substituted for TEXT type；
Step S24：Output target database MYSQL type builds table sql sentence.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810615074.4A CN108920547A (en) | 2018-06-14 | 2018-06-14 | Based on full-service uniform data center data among heterogeneous databases library field type mapping boosts method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810615074.4A CN108920547A (en) | 2018-06-14 | 2018-06-14 | Based on full-service uniform data center data among heterogeneous databases library field type mapping boosts method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108920547A true CN108920547A (en) | 2018-11-30 |
Family
ID=64421559
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810615074.4A Pending CN108920547A (en) | 2018-06-14 | 2018-06-14 | Based on full-service uniform data center data among heterogeneous databases library field type mapping boosts method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108920547A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110362632A (en) * | 2019-07-22 | 2019-10-22 | 无限极（中国）有限公司 | A kind of method of data synchronization, device, equipment and computer readable storage medium |
| CN113157672A (en) * | 2021-05-17 | 2021-07-23 | 中国银行股份有限公司 | Method and device for modifying SQLServer database fields in batch |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170091298A1 (en) * | 2015-09-25 | 2017-03-30 | International Business Machines Corporation | Replicating structured query language (sql) in a heterogeneous replication environment |
| CN107357942A (en) * | 2017-09-04 | 2017-11-17 | 山东达创网络科技股份有限公司 | A kind of source code auxiliary Core Generator and its generation method |
| US20180137184A1 (en) * | 2016-11-15 | 2018-05-17 | Spirent Communications, Inc. | Sql interceptor for use with third party data analytics packages |
-
2018
- 2018-06-14 CN CN201810615074.4A patent/CN108920547A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170091298A1 (en) * | 2015-09-25 | 2017-03-30 | International Business Machines Corporation | Replicating structured query language (sql) in a heterogeneous replication environment |
| US20180137184A1 (en) * | 2016-11-15 | 2018-05-17 | Spirent Communications, Inc. | Sql interceptor for use with third party data analytics packages |
| CN107357942A (en) * | 2017-09-04 | 2017-11-17 | 山东达创网络科技股份有限公司 | A kind of source code auxiliary Core Generator and its generation method |
Non-Patent Citations (2)
| Title |
|---|
| CRAFT_007: "将sql文件导入PowerDesigner中的方法", 《HTTP://WWW.2CTO.COM/DATABASE/201210/161178.HTML》 * |
| 蓝SL羽DE薄情: "数据库迁移之pdm-数据库数据类型的批量修改", 《HTTPS://BLOG.CSDN.NET/U014225431/ARTICLE/DETAILS/56011292?UTM_MEDIUM=DISTRIBUTE.PC_RELEVANT.NONE-TASK-BLOG-BLOGCOMMENDFROMMACHINELEARNPAI2-4.CONTROL&DEPTH_1-UTM_SOURCE=DISTRIBUTE.PC_RELEVANT.NONE-TASK-BLOG-BLOGCOMMENDFROMMACHINELEARNPAI2-4.CONTROL》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110362632A (en) * | 2019-07-22 | 2019-10-22 | 无限极（中国）有限公司 | A kind of method of data synchronization, device, equipment and computer readable storage medium |
| CN113157672A (en) * | 2021-05-17 | 2021-07-23 | 中国银行股份有限公司 | Method and device for modifying SQLServer database fields in batch |
| CN113157672B (en) * | 2021-05-17 | 2024-01-19 | 中国银行股份有限公司 | Batch modification method and device for SQLServer database fields |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103309904B (en) | A kind of method and device generating data warehouse ETL code | |
| CN101763064B (en) | Numerical control machining process design system and method of aircraft complex components facing process object | |
| CN105574643A (en) | Real-time data center and big data platform fusion method for power grid | |
| CN102779156B (en) | Configuration method for database of communication device in digital substation | |
| CN102012945B (en) | User-oriented database management system | |
| CN112347071B (en) | Power distribution network cloud platform data fusion method and power distribution network cloud platform | |
| CN102508654A (en) | Method for designing ladder diagram editing software of embedded PLC (Programmable Logic Controller) | |
| CN107526806A (en) | The conversion method and device of data | |
| CN108920547A (en) | Based on full-service uniform data center data among heterogeneous databases library field type mapping boosts method | |
| CN104317864A (en) | Automatic identification method of information model based on IEC61850 logical nodes | |
| CN105279269A (en) | SQL generating method and system for supporting table free association | |
| CN104794203A (en) | System and method for alga enumeration data voice rapid inputting and report generation | |
| CN100589101C (en) | Data access method based on the Oracle relational database of routine call interface | |
| CN101706779B (en) | ORACLE-based umbrella data import/export method | |
| CN102377506A (en) | Test message processing system | |
| CN108628972A (en) | A kind of processing method of tables of data, device and storage medium | |
| CN108446145A (en) | A kind of distributed document loads MPP data base methods automatically | |
| CN114048188A (en) | Cross-database data migration system and method | |
| CN102023859A (en) | Digital development environment-oriented software integration method with reliability, maintainability and supportability | |
| CN105933396B (en) | A kind of each canalization interface of collaboration realizes the method and system of long flow | |
| CN104346441A (en) | Dynamic integration and interaction method for information data of power distribution network | |
| CN111026451A (en) | Parameter configuration method and configuration tool for transformer substation terminal interval | |
| CN102446164A (en) | Analytic method, device and operation system of report formula | |
| CN104731597A (en) | Method for applying SQL statements to engineering software compiling platform | |
| CN107729410A (en) | A kind of database engine suitable for power equipment big data |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20181130 |
|
| RJ01 | Rejection of invention patent application after publication |