CN104408045A - Implementation method of ECLIPSE plugins for data model management and application - Google Patents
Implementation method of ECLIPSE plugins for data model management and application Download PDFInfo
- Publication number
- CN104408045A CN104408045A CN201410574491.0A CN201410574491A CN104408045A CN 104408045 A CN104408045 A CN 104408045A CN 201410574491 A CN201410574491 A CN 201410574491A CN 104408045 A CN104408045 A CN 104408045A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- data model
- management
- model
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
Abstract
The invention relates to the technical field of data model management and application and particularly relates to an implementation method of ECLIPSE plugins for data model management and application. The implementation method of the ECLIPSE plugins for data model management and application is capable of realizing data model design, metadata information collection, database table structure creation and maintenance and development code production by virtue of an Eclipse Tool. By virtue of adopting the tool, integrated operation of data model design and development and database maintenance can be realized, the development time is saved, the consistency of database design and database maintenance is kept, and metadata information and data model modification logs are simultaneously collected.
Description
Technical field
The present invention relates to data model Management and application technical field, particularly a kind of implementation method of ECLIPSE plug-in unit of data model Management and application.
Background technology
Data model (Data Model) is the abstract of data characteristics, is the instructional mode framework of data base administration.In order to provide information to represent the form framework with operational means in Database Systems.Data model comprises the constraint condition of the structure division of database data, the operation part of database data and database data.
Eclipse is an open source code, easily extensible development platform based on Java.In itself, it is a framework and one group of service, for making up environment by plug in component.Eclipse has attached the plug set of a standard, comprises Java developing instrument (Java Development Kit, JDK).
Under prior art, the data model many times designed and actual database structure are difficult to be consistent, and not safeguarding relevant document, causing the real data model of project neither one because of directly have adjusted database structure sometimes.
Summary of the invention
In order to solve the problem of prior art, the invention provides a kind of implementation method of ECLIPSE plug-in unit of data model Management and application, it can realize the production of the design of data model, the collection of metadata information, the establishment of database table structure and maintenance, exploitation code by an Eclipse instrument.
The technical solution adopted in the present invention is as follows: a kind of implementation method of ECLIPSE plug-in unit of data model Management and application, comprises the method for system background data management and the method for Data Model Designing, wherein:
The method of described system background data management comprises: restrictive condition during Database Modeling and the maintenance of Rule Information, data type contrast, Database Modeling key word are safeguarded;
The method of described Data Model Designing specifically comprises the following steps:
A, configuration platform data source;
B, according to operation system numbering import operation system;
C, configuration service DSN;
D, model of creation view;
E, creation database model;
F, according to operation produce corresponding SQL statement perform in platform database and operation system database respectively.
Restrictive condition during Database Modeling comprises data object: table, view, field, major key, the restriction of outer key length.
Data type contrast refers to that database management tools has pre-established the data type of a set of unified database, then by contrasting function this sets of data type, the data type of each database self in correspondence; When generating database SQL statement according to the SQL statement setting contrast relationship and automatically create corresponding data.
The ECLIPSE plug-in unit of data model Management and application realize a system, comprising: (1) data management system; (2) Data Model Designing instrument; (3) metadata information collection and list structure safeguard assembly; (4) assembly mating interface is produced with code; Wherein, described data management system, adopts B/S mode to develop, the restrictive condition during Database Modeling needed during service data modelling and the maintenance of Rule Information, data type contrast, Database Modeling key word maintenance function; Described Data Model Designing instrument, adopts eclipse plug-in unit mode, the visual design of implementation model, and according to model creation database structure, record metadata information, record logging feature; The docking of realization and the code tool of production can directly according to data model production development code.
The implementation method of the ECLIPSE plug-in unit of a kind of data model Management and application of the present invention, achieve the integration operation of the design of data model, exploitation, database maintenance, keep the consistance of modelling and database structure, data model modification process can be reviewed.
The beneficial effect that technical scheme provided by the invention is brought is:
(1) consistance of data model and database structure is ensured;
(2) the overall process record of data model amendment;
(3) the automatic collection of metadata information;
(4) integrated with the code tool of production, improves development efficiency.
Adopt this instrument can realize the integration operation of the design of data model, exploitation, database maintenance, saved the development time, keep the consistance of database design and database maintenance, gather the daily record that lower metadata information and data model are revised simultaneously.
Accompanying drawing explanation
In order to be illustrated more clearly in the technical scheme in the embodiment of the present invention, below the accompanying drawing used required in describing embodiment is briefly described, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is the method flow diagram of the Data Model Designing of the implementation method of the ECLIPSE plug-in unit of a kind of data model Management and application of the present invention.
Fig. 2 is the Directory of Features structural drawing of the database management tools of the implementation method of the ECLIPSE plug-in unit of a kind of data model Management and application of the present invention.
Embodiment
For making the object, technical solutions and advantages of the present invention clearly, below in conjunction with accompanying drawing, embodiment of the present invention is described further in detail.
Embodiment one
An implementation method for the ECLIPSE plug-in unit of data model Management and application, comprises the method for system background data management and the method for Data Model Designing, wherein:
The method of described system background data management comprises: restrictive condition during Database Modeling and the maintenance of Rule Information, data type contrast, Database Modeling key word are safeguarded;
The method of described Data Model Designing specifically comprises the following steps:
A, configuration platform data source;
B, according to operation system numbering import operation system;
C, configuration service DSN;
D, model of creation view;
E, creation database model;
F, according to operation produce corresponding SQL statement perform in platform database and operation system database respectively.
Restrictive condition during Database Modeling comprises data object: table, view, field, major key, the restriction of outer key length.
Data type contrast refers to that database management tools has pre-established the data type of a set of unified database, then by contrasting function this sets of data type, the data type of each database self in correspondence; When generating database SQL statement according to the SQL statement setting contrast relationship and automatically create corresponding data.
Embodiment two:
The ECLIPSE plug-in unit of data model Management and application realize a system, comprising: (1) data management system; (2) Data Model Designing instrument; (3) metadata information collection and list structure safeguard assembly; (4) assembly mating interface is produced with code; Wherein, described data management system, adopts B/S mode to develop, the restrictive condition during Database Modeling needed during service data modelling and the maintenance of Rule Information, data type contrast, Database Modeling key word maintenance function; Described Data Model Designing instrument, adopts eclipse plug-in unit mode, the visual design of implementation model, and according to model creation database structure, record metadata information, record logging feature; The docking of realization and the code tool of production can directly according to data model production development code.
The system of the present embodiment adopts the eclipse inserter tool of java statement exploitation, simultaneously the backstage management function that provides web apply, data information memory at database layer, the Sybases such as database support Oracle, DB2, MySQL.Main performing step:
(1) data management system: restrictive condition when mainly comprising Database Modeling and the maintenance of Rule Information, data type contrast, Database Modeling key word are safeguarded.
Restrictive condition cardinal index during Database Modeling is according to object: the length restriction of table, view, field, major key, external key etc.; This rule will formulate two parts, and a part is that the rule of database management tools oneself definition can meet the public rule of types of databases, and a part is the rule of types of databases personalization.We make public rule some conventional rational conditions, some database personalized objects are adopted the rule of database oneself itself; Namely facilitate developer only to need to understand set of rule, do not lose again some sexual functions of database.
Data type contrast refers to that database management tools has pre-established the data type of a set of unified database, then by contrasting function this sets of data type, the data type of each database self in correspondence; When generating database SQL statement according to the SQL statement setting contrast relationship and automatically create corresponding data.
Database Modeling key word maintenance function provides the key word for all types of data to safeguard, the avoiding of the change that database management tools is maximum uses these key words as object oriented etc. when data modeling.
(2) Data Model Designing instrument is most important ingredient in database management tools module, and database model management is by visually carrying out that database model establishment, database model are synchronous, database model performs and the function such as to check of historical operation record is integrated unified, synchronous, standardized modeling tool by pulling on client developing instrument.Main flow process is with reference to the operational flowchart of accompanying drawing 1; Directory of Features is with reference to the bibliographic structure figure of accompanying drawing 2.
The foregoing is only preferred embodiment of the present invention, not in order to limit the present invention, within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (4)
1. an implementation method for the ECLIPSE plug-in unit of data model Management and application, comprises the method for system background data management and the method for Data Model Designing, wherein:
The method of described system background data management comprises: restrictive condition during Database Modeling and the maintenance of Rule Information, data type contrast, Database Modeling key word are safeguarded;
The method of described Data Model Designing specifically comprises the following steps:
A, configuration platform data source;
B, according to operation system numbering import operation system;
C, configuration service DSN;
D, model of creation view;
E, creation database model;
F, according to operation produce corresponding SQL statement perform in platform database and operation system database respectively.
2. the implementation method of the ECLIPSE plug-in unit of a kind of data model Management and application according to claim 1, is characterized in that, restrictive condition during described Database Modeling comprises data object: table, view, field, major key, the restriction of outer key length.
3. the implementation method of the ECLIPSE plug-in unit of a kind of data model Management and application according to claim 1, it is characterized in that, described data type contrast refers to that database management tools has pre-established the data type of a set of unified database, then by contrasting function this sets of data type, the data type of each database self in correspondence; When generating database SQL statement according to the SQL statement setting contrast relationship and automatically create corresponding data.
4. data model Management and application ECLIPSE plug-in unit realize a system, comprising: (1) data management system; (2) Data Model Designing instrument; (3) metadata information collection and list structure safeguard assembly; (4) assembly mating interface is produced with code; Wherein, described data management system, adopts B/S mode to develop, the restrictive condition during Database Modeling needed during service data modelling and the maintenance of Rule Information, data type contrast, Database Modeling key word maintenance function; Described Data Model Designing instrument, adopts eclipse plug-in unit mode, the visual design of implementation model, and according to model creation database structure, record metadata information, record logging feature; The docking of realization and the code tool of production can directly according to data model production development code.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410574491.0A CN104408045A (en) | 2014-10-24 | 2014-10-24 | Implementation method of ECLIPSE plugins for data model management and application |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410574491.0A CN104408045A (en) | 2014-10-24 | 2014-10-24 | Implementation method of ECLIPSE plugins for data model management and application |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104408045A true CN104408045A (en) | 2015-03-11 |
Family
ID=52645677
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410574491.0A Pending CN104408045A (en) | 2014-10-24 | 2014-10-24 | Implementation method of ECLIPSE plugins for data model management and application |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104408045A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107169022A (en) * | 2017-04-07 | 2017-09-15 | 广东精点数据科技股份有限公司 | A kind of system and method for realizing data warehouse automatic modeling |
| CN108255904A (en) * | 2017-05-04 | 2018-07-06 | 平安科技（深圳）有限公司 | table structure modelling method and server |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060253495A1 (en) * | 2002-04-02 | 2006-11-09 | Png Teck H | Metadata database management system and method therefor |
| CN103399904A (en) * | 2013-07-26 | 2013-11-20 | 浙江吉利汽车研究院有限公司 | Data processing method and data processing system |
| CN103559189A (en) * | 2013-08-22 | 2014-02-05 | 国家电网公司 | Power simulation training resource management system and method based on metadata integration model |
| CN103729460A (en) * | 2014-01-10 | 2014-04-16 | 中国南方电网有限责任公司 | Graphical data model managing method and system based on metadata |
-
2014
- 2014-10-24 CN CN201410574491.0A patent/CN104408045A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060253495A1 (en) * | 2002-04-02 | 2006-11-09 | Png Teck H | Metadata database management system and method therefor |
| CN103399904A (en) * | 2013-07-26 | 2013-11-20 | 浙江吉利汽车研究院有限公司 | Data processing method and data processing system |
| CN103559189A (en) * | 2013-08-22 | 2014-02-05 | 国家电网公司 | Power simulation training resource management system and method based on metadata integration model |
| CN103729460A (en) * | 2014-01-10 | 2014-04-16 | 中国南方电网有限责任公司 | Graphical data model managing method and system based on metadata |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107169022A (en) * | 2017-04-07 | 2017-09-15 | 广东精点数据科技股份有限公司 | A kind of system and method for realizing data warehouse automatic modeling |
| CN108255904A (en) * | 2017-05-04 | 2018-07-06 | 平安科技（深圳）有限公司 | table structure modelling method and server |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106873987B (en) | Modelica-based multi-person collaborative modeling system | |
| JP2021519964A (en) | Learning ETL rules by example | |
| CN104200402A (en) | Publishing method and system of source data of multiple data sources in power grid | |
| CN104504094A (en) | Various data source integrated management method for oil and gas field | |
| CN102902777B (en) | Across data source query device with across data source query method | |
| CN103853821A (en) | Method for constructing multiuser collaboration oriented data mining platform | |
| CN103903086A (en) | Method and system for developing management information system based on service model driving | |
| US20140358492A1 (en) | Systems and methods for synchronizing geographic information system (gis) network models | |
| CN109933416A (en) | A kind of moving method, device and storage medium using data | |
| CN104598233A (en) | Code generation method | |
| CN100561471C (en) | Data base automatic operation method based on web service | |
| CN103365777B (en) | A kind of method for generating test case and system | |
| CN103207783A (en) | Software development engine system based on browser/server mode and building method thereof | |
| CN104408045A (en) | Implementation method of ECLIPSE plugins for data model management and application | |
| CN110941422B (en) | Code automatic generation method, code generator and readable storage medium | |
| CN104951312A (en) | Business function customization system based on model drive | |
| CN116029648A (en) | Relationship modeling management method, device and system based on product BOM structure | |
| CN106682230A (en) | Information service system based on HTML5 and CSS3 mobile display technological architecture | |
| WO2011156118A3 (en) | Cogeneration of database applications and their databases | |
| CN104199675A (en) | System capable of quick system development based on database parameter utilization | |
| Liu et al. | Research on middle platform construction and large data analysis of power enterprises based on Aliyun | |
| CN104573960A (en) | Novel electric power dispatching statement solution | |
| Zhang et al. | Integration application system of Chinese wooden architecture heritages based on BIM | |
| Jiang | Investigation on the construction of urban intelligent emergency management system based on data mining technology | |
| CN106022944B (en) | Data volume conversion method and device for conventional and streamline models in numerical reservoir simulation |
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: 20150311 |
|
| WD01 | Invention patent application deemed withdrawn after publication |