CN109933628A - A kind of ETL designer and its Photographing On-line method based on mxgraph - Google Patents
A kind of ETL designer and its Photographing On-line method based on mxgraph Download PDFInfo
- Publication number
- CN109933628A CN109933628A CN201910203241.9A CN201910203241A CN109933628A CN 109933628 A CN109933628 A CN 109933628A CN 201910203241 A CN201910203241 A CN 201910203241A CN 109933628 A CN109933628 A CN 109933628A
- Authority
- CN
- China
- Prior art keywords
- component
- etl
- designer
- mxgraph
- photographing
- 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
- 238000000034 method Methods 0.000 title claims abstract description 43
- 230000015572 biosynthetic process Effects 0.000 claims abstract description 4
- 238000010422 painting Methods 0.000 claims description 21
- 238000012217 deletion Methods 0.000 claims description 7
- 230000037430 deletion Effects 0.000 claims description 7
- 238000006243 chemical reaction Methods 0.000 description 8
- 230000000712 assembly Effects 0.000 description 2
- 238000000429 assembly Methods 0.000 description 2
- 238000012938 design process Methods 0.000 description 2
- 238000007689 inspection Methods 0.000 description 2
- 238000004321 preservation Methods 0.000 description 2
- 235000013399 edible fruits Nutrition 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
Abstract
The invention discloses a kind of ETL designer and its Photographing On-line method based on mxgraph, belongs to Photographing On-line technical field of tools.ETL designer based on mxgraph of the invention, including component area, operating space and journal displaying area, the component area is for selecting component, component is dragged to operating space, formation component is clicked in operating space and is saved, and the setting of operating space is saved, original data processing is formed into treated data, run succeeded the logged result executed in the display of journal displaying area.The ETL designer based on mxgraph of the invention is not necessarily to install in the machine, directly uses in a browser, realizes definition, drag and drop, line and the editting function of component, has good application value.
Description
Technical field
The present invention relates to Photographing On-line technical field of tools, specifically provide a kind of ETL designer based on mxgraph and
Its Photographing On-line method.
Background technique
Mxgraph is that a JavaScript charting component is applicable to design/editor Workflow/ in webpage
BPM flow chart, chart, network and generic graphic web application.Magraph is rendered using SVG and HTML, no
Using third party software, it does not need plug-in unit, is almost desirably integrated into any frame.Kettle is a external open source
ETL tool, pure java write, and can run in kinds of platform, data pick-up function efficient stable.
ETL designer first models ETL conversion and operation, saves after modeling and gives kettle engine fortune
Row, the final extraction conversion function realized to data.But ETL designer cannot directly in a browser in the prior art
It uses, cannot flexibly realize the functions such as scaling, operation, stopping, inspection, the preservation of ETL designer, there is certain limitation
Property.
Summary of the invention
Technical assignment of the invention is in view of the above problems, to provide a kind of be not necessarily in the machine installation, directly clear
Look in device and use, realize the definition of component, drag and drop, line and editting function the ETL designer based on mxgraph.
The further technical assignment of the present invention is to provide a kind of Photographing On-line side of ETL designer based on mxgraph
Method.
To achieve the above object, the present invention provides the following technical scheme that
A kind of ETL designer based on mxgraph, the designer include component area, operating space and journal displaying area, institute
Component area is stated for selecting component, dragging component to operating space, formation component is clicked in operating space and saved, by setting for operating space
Preservation is set, original data processing is formed into treated data, run succeeded the log knot executed in the display of journal displaying area
Fruit.
The ETL designer further includes toolbar.
First from component area, component (such as " table input " component) is selected to pin mouse drag component to operating space, release
Mouse action area will generate a component, and the properties dialog of component can be opened by double-clicking component, according to the difference of component, belong to
Property also can be different, need to be configured according to concrete scene.The multiple components of dragging be can according to need to operating space.
A line can be pulled out by pressing mouse in the central point of component, and line can arbitrarily connect other assemblies, work as mesh
The mark greeny selected state of module frame can discharge mouse, and connection is completed.Finally realize a complete data conversion
ETL conversion.Certainly occur maloperation in the design process the functions such as can be reformed and be restored by the revocation of toolbar.
After the completion of ETL Process Design, all settings in operating space can be saved by clicking save button, be saved
ETL conversion can be run after success, initial data will be read by ETL engine and be converted according to the setting of user, clearly
It washes, polymerize, the processes such as classification, the data that ultimately form that treated can show this day executed in log area after running succeeded
Will result.
A kind of Photographing On-line method of the ETL designer based on mxgraph, this method are dragged from the component area of designer
Component forms ETL component, increases double click event for ETL component, open component property frame, setting group by double-clicking to operating space
Part attribute simultaneously saves, and operation note is saved, final to save into database, opens the page and reads parsing use from database
The attribute of family setting, shows on painting canvas.
Preferably, this method specifically includes the following steps:
S1, creation painting canvas container and component area；
S2, initialization component；
S3, different patterns is added for different types of component；
S4, increase dragging event, deletion event for component and open dialog box component；
S5, component save event；
S6, assembly operating are realized.
In step S6, when clicking operation button, designer first checks for whether component is all legal, and illegal operation stops
Only.Inspection starts to start after passing through, and the id of this ETL process and title are passed to backstage at this time, and kettle engine receives fortune
After row signal, all information of ETL process storage is got according to id, is loaded parameter and is brought into operation.After end of run, engine
The log that operation generates is returned, designer receives log information, this running log is shown in log region, knot
Beam operational process.
Preferably, an element of page China is initialized to painting canvas in step S1, and the background of painting canvas is set,
Securing component area carries out classification displaying according to type, forms component area.
Preferably, in step S2, the parameter of component is set, including display icon, width, height, pattern, title and
Type, and mxcell object is generated according to parameter.
Preferably, global pattern, font color, font size, text water including component is arranged in step S3
Square formula, alignment thereof, the color of background picture size and line, after setting completed, the type by group valence is true for global style
Determine component background.
Preferably, in step S4, when dragging event occurs, designer obtains mouse in the coordinate position of painting canvas, according to
The component type of dragging is replicated, and the group valence to copy assigns new coordinate position, new name is generated, in painting canvas
It shows.
Preferably, when deletion event occurs, designer obtains the component being selected in current painting canvas in step S4, adjust
With component destroying method, component is deleted.
Preferably, after setting completed, designer collects a data of all components to component, and checks in step S5
Whether component is legal, regathers the line between component and is related to another array, information passes through network request after collecting
Module information is sent to background process, is saved in database.
Compared with prior art, the Photographing On-line method of the ETL designer of the invention based on mxgraph has following
It is outstanding the utility model has the advantages that the Photographing On-line method of the ETL designer based on mxgraph in the machine without installing, directly
It uses in a browser, realizes the scaling of designer, run, stop, checking, save, publication, the functions such as attribute realize
Definition, drag and drop, line and the edition function of component have good application value.
Detailed description of the invention
Fig. 1 is the flow chart of the ETL designer of the present invention based on mxgraph and its Photographing On-line method.
Specific embodiment
Below in conjunction with drawings and examples, to the ETL designer and its Photographing On-line of the invention based on mxgraph
Method is described in further detail.
Embodiment
ETL designer based on mxgraph of the invention, including component area, operating space and journal displaying area, described group
For selecting component, dragging component to operating space, formation component is clicked in operating space and is saved in part area, and the setting of operating space is protected
It deposits, original data processing is formed into treated data, run succeeded the logged result executed in the display of journal displaying area.It should
ETL designer further includes toolbar.
First from component area, component (such as " table input " component) is selected to pin mouse drag component to operating space, release
Mouse action area will generate a component, and the properties dialog of component can be opened by double-clicking component, according to the difference of component, belong to
Property also can be different, need to be configured according to concrete scene.The multiple components of dragging be can according to need to operating space.
A line can be pulled out by pressing mouse in the central point of component, and line can arbitrarily connect other assemblies, work as mesh
The mark greeny selected state of module frame can discharge mouse, and connection is completed.Finally realize a complete data conversion
ETL conversion.Certainly occur maloperation in the design process the functions such as can be reformed and be restored by the revocation of toolbar.
After the completion of ETL Process Design, all settings in operating space can be saved by clicking save button, be saved
ETL conversion can be run after success, initial data will be read by ETL engine and be converted according to the setting of user, clearly
It washes, polymerize, the processes such as classification, the data that ultimately form that treated can show this day executed in log area after running succeeded
Will result.
A kind of Photographing On-line method of the ETL designer based on mxgraph, this method are dragged from the component area of designer
Component forms ETL component, increases double click event for ETL component, open component property frame, setting group by double-clicking to operating space
Part attribute simultaneously saves, and operation note is saved, final to save into database, opens the page and reads parsing use from database
The attribute of family setting, shows on painting canvas.
Preferably, this method specifically includes the following steps:
S1, creation painting canvas container and component area.
An element in the page is initialized to painting canvas, and the background of painting canvas is set, securing component area according to type into
Row classification is shown, forms component area.It is as follows to run code:
S2, initialization component.
The parameter of component, including display icon, width, height, pattern, title and type are set, and generated according to parameter
Mxcell object.It is as follows to run code:
S3, different patterns is added for different types of component.
Global pattern, font color, font size, text horizontal mode including component, alignment thereof, back are set
The color of scape picture size and line, global style determine component background after setting completed, by the type of group valence.Run generation
Code is as follows:
S4, increase dragging event, deletion event for component and open dialog box component.
When dragging event occurs, designer obtains mouse in the coordinate position of painting canvas, is carried out according to the component type of dragging
Duplication, the group valence to copy assign new coordinate position, generate new name, show in painting canvas.
When deletion event occurs, designer obtains the component being selected in current painting canvas, and invocation component destroying method is deleted
Except component.
Designer monitors the double-click movement of mouse, when double-clicking component, gets the information of component and passes through component type
It determines and opens component dialog box, the parameter of component is set in component dialog box.
The operation code of the process is as follows:
S5, component save event.
After setting completed, designer collects a data of all components to component, and whether legal, then receive if checking component
Line between collection component is related to another array, and module information is sent to after collecting by network request by information
Background process is saved in database.It is as follows to run code:
S6, assembly operating are realized.
When clicking operation button, designer first checks for whether component is all legal, and illegal operation stops.It checks logical
Later start to start, the id of this ETL process and title are passed to backstage at this time, after kettle engine receives run signal,
The all information of ETL process storage is got according to id, is loaded parameter and is brought into operation.After end of run, engine generates operation
Log return, designer receives log information, this running log is shown in log region, operational process is terminated.
It is as follows to run code:
Embodiment described above, the only present invention more preferably specific embodiment, those skilled in the art is at this
The usual variations and alternatives carried out within the scope of inventive technique scheme should be all included within the scope of the present invention.
Claims (9)
1. a kind of ETL designer based on mxgraph, it is characterised in that: the designer includes that component area, operating space and log are aobvious
Show area, for selecting component, dragging component to operating space, formation component is clicked in operating space and saved, will operate in the component area
The setting in area saves, and the original data processing data that form that treated run succeeded the day executed in the display of journal displaying area
Will result.
2. a kind of Photographing On-line method of the ETL designer based on mxgraph, it is characterised in that: group of this method from designer
Part area drags component to operating space, forms ETL component, increases double click event for ETL component, opens component property by double-clicking
Frame is arranged component property and saves, operation note is saved, final to save into database, opens the page and reads from database
The attribute for taking parsing user setting, shows on painting canvas.
3. the Photographing On-line method of the ETL designer according to claim 2 based on mxgraph, it is characterised in that: the party
Method specifically includes the following steps:
S1, creation painting canvas container and component area；
S2, initialization component；
S3, different patterns is added for different types of component；
S4, increase dragging event, deletion event for component and open dialog box component；
S5, component save event；
S6, assembly operating are realized.
4. the Photographing On-line method of the ETL designer according to claim 3 based on mxgraph, it is characterised in that: step
An element of page China is initialized to painting canvas in S1, and the background of painting canvas is set, securing component area is carried out according to type
Classification is shown, forms component area.
5. the Photographing On-line method of the ETL designer according to claim 4 based on mxgraph, it is characterised in that: step
In S2, the parameter of component, including display icon, width, height, pattern, title and type are set, and generate according to parameter
Mxcell object.
6. the Photographing On-line method of the ETL designer according to claim 5 based on mxgraph, it is characterised in that: step
In S3, global pattern, font color, font size, text horizontal mode including component, alignment thereof, Background are set
The color of piece size and line, global style determine component background after setting completed, by the type of group valence.
7. the Photographing On-line method of the ETL designer according to claim 6 based on mxgraph, it is characterised in that: step
In S4, when dragging event occurs, designer obtains mouse in the coordinate position of painting canvas, is answered according to the component type of dragging
System, the group valence to copy assign new coordinate position, generate new name, show in painting canvas.
8. the Photographing On-line method of the ETL designer according to claim 7 based on mxgraph, it is characterised in that: step
In S4, when deletion event occurs, designer obtains the component being selected in current painting canvas, invocation component destroying method, deletion group
Part.
9. the Photographing On-line method of the ETL designer according to claim 8 based on mxgraph, it is characterised in that: step
After setting completed, designer collects a data of all components to component, and checks whether component is legal, regathers component in S5
Between line be related to another array, module information is sent at from the background after collecting by network request by information
Reason, is saved in database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910203241.9A CN109933628A (en) | 2019-03-18 | 2019-03-18 | A kind of ETL designer and its Photographing On-line method based on mxgraph |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910203241.9A CN109933628A (en) | 2019-03-18 | 2019-03-18 | A kind of ETL designer and its Photographing On-line method based on mxgraph |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109933628A true CN109933628A (en) | 2019-06-25 |
Family
ID=66987405
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910203241.9A Pending CN109933628A (en) | 2019-03-18 | 2019-03-18 | A kind of ETL designer and its Photographing On-line method based on mxgraph |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109933628A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110618815A (en) * | 2019-09-19 | 2019-12-27 | 北京天地和兴科技有限公司 | Construction method of industrial system network topological graph |
| CN111538498A (en) * | 2020-04-14 | 2020-08-14 | 北京宝兰德软件股份有限公司 | Application creation method and device, electronic equipment and storage medium |
| CN113407078A (en) * | 2021-06-07 | 2021-09-17 | 远光软件股份有限公司 | Method and device for editing character icon, storage medium and terminal |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102375734A (en) * | 2010-08-23 | 2012-03-14 | 中国移动通信集团公司 | Application product development system, method and device and operation system, method and device |
| US20160095188A1 (en) * | 2014-09-29 | 2016-03-31 | Koninklijke Philips N.V. | Systems and methods for managing environmental conditions |
| CN108268494A (en) * | 2016-12-30 | 2018-07-10 | 中移(苏州)软件技术有限公司 | The ETL dispatching methods and device that a kind of data processing is detached with control logic |
-
2019
- 2019-03-18 CN CN201910203241.9A patent/CN109933628A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102375734A (en) * | 2010-08-23 | 2012-03-14 | 中国移动通信集团公司 | Application product development system, method and device and operation system, method and device |
| US20160095188A1 (en) * | 2014-09-29 | 2016-03-31 | Koninklijke Philips N.V. | Systems and methods for managing environmental conditions |
| CN108268494A (en) * | 2016-12-30 | 2018-07-10 | 中移(苏州)软件技术有限公司 | The ETL dispatching methods and device that a kind of data processing is detached with control logic |
Non-Patent Citations (3)
| Title |
|---|
| 吕岩: "基于ETL的异构数据源集成和转换系统的设计与实现", 《中国优秀博硕士学位论文全文数据库 (硕士) (信息科技辑)》 * |
| 蔡玉宝等: "数据处理平台的研究与实现", 《计算机工程与设计》 * |
| 郭丹等: "基于ETL-KETTLE的贵州卷烟营销大数据分析及可视化", 《计算机系统应用》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110618815A (en) * | 2019-09-19 | 2019-12-27 | 北京天地和兴科技有限公司 | Construction method of industrial system network topological graph |
| CN111538498A (en) * | 2020-04-14 | 2020-08-14 | 北京宝兰德软件股份有限公司 | Application creation method and device, electronic equipment and storage medium |
| CN113407078A (en) * | 2021-06-07 | 2021-09-17 | 远光软件股份有限公司 | Method and device for editing character icon, storage medium and terminal |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Antkiewicz et al. | FeaturePlugin: Feature modeling plug-in for Eclipse | |
| CN103218225B (en) | A kind of unified survey sends out control software development system | |
| CN109933628A (en) | A kind of ETL designer and its Photographing On-line method based on mxgraph | |
| CN101387946B (en) | Electronic file archiving method and system | |
| CN106909610A (en) | Visualization based on browser pulls the method and system of inquiry data | |
| US20120102451A1 (en) | Computationally efficient system for developing configurable, extensible business application product lines using model-driven techniques | |
| US20100306730A9 (en) | Customizable asset governance for a distributed reusable software library | |
| US8572563B2 (en) | User interfaces and software reuse in model based software systems | |
| CN1395193A (en) | Method fro producing dynamic form which can be edited on web page | |
| WO1996028778A1 (en) | Automation of tasks using graphical and multimedia macros | |
| CN109062567A (en) | Information management system quick development platform based on B/S structure | |
| CN112567373A (en) | CAD collaborative design system | |
| US20110276927A1 (en) | System and method for dynamic linking between graphic documents and comment data bases | |
| CN113553269B (en) | Page embedded point reporting method and related device | |
| US8819619B2 (en) | Method and system for capturing user interface structure in a model based software system | |
| CN101021789A (en) | Method for realizing newly-increased information stream management function in application software system | |
| JP2022041865A (en) | Online working system for template-based excel documents | |
| CN101980205A (en) | Universal page generating method | |
| EP2251796A2 (en) | Storage and processing of spreadsheets | |
| CN1924906A (en) | Product data statistics of flowing production line and management method | |
| CN105912740A (en) | CAE distributed cooperative work method based on cloud calculation | |
| US20120078967A1 (en) | Integration of a Framework Application and a Task Database | |
| US20110161846A1 (en) | Highlighting changes on computer diagrams | |
| CN109725973B (en) | Data processing method and data processing device | |
| CN111949267B (en) | UI front end generation 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 |