CN110569230A - Method, system and equipment for interconversion between database design model and design document - Google Patents
Method, system and equipment for interconversion between database design model and design document Download PDFInfo
- Publication number
- CN110569230A CN110569230A CN201910811934.6A CN201910811934A CN110569230A CN 110569230 A CN110569230 A CN 110569230A CN 201910811934 A CN201910811934 A CN 201910811934A CN 110569230 A CN110569230 A CN 110569230A
- Authority
- CN
- China
- Prior art keywords
- design
- database
- model
- document
- data format
- 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.)
- Withdrawn
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
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
according to the method, the system and the equipment for mutually converting the database design model and the design document, the pdm format file of the data design model can be converted into an excel file for archiving by using a database model design tool; meanwhile, the method can reversely generate a pdm format file of a data design model from the archived excel file for development and database design. Therefore, the rapid and accurate conversion from the database model to the design document is realized in the development process, and the aim of improving the working efficiency is fulfilled.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a method, a system and equipment for mutual conversion of a database design model and a design document.
background
with the rapid development of cloud computing, more and more enterprises begin to deploy cloud computing management platforms, and the development amount of the cloud computing management platforms is larger and larger. The current development process is to design a database model by using a database model design tool, then compile a design document, and then perform coding work.
However, the cloud platform involves a large number of database tables, the writing workload from the database design model to the design document is large, and if the design document is modified, the database design model needs to be modified synchronously, which results in a high probability of errors occurring when the cloud platform and the database design model are converted.
Disclosure of Invention
in view of the above problems, an object of the present invention is to provide a method, a system, and a device for mutual conversion between a database design model and a design document, which implement fast and accurate conversion from the database model to the design document in a development process, thereby achieving the purpose of improving work efficiency.
in order to achieve the purpose, the invention is realized by the following technical scheme: a method for interconversion of a database design model with a design document, comprising:
After a developer finishes designing a database model in a design stage, generating a design document by using a database model design tool for the finished database model;
And judging whether the design document is modified or not, and if so, reversely generating the database design model from the design document by using a database model design tool.
Further, the generating a design document from the completed database design model using the database model design tool and the reversely generating a database design model from the design document using the database model design tool both include: reading the configuration file, and determining a target format of data format conversion and a data format conversion algorithm list according to the content of the configuration file;
acquiring original data of data format conversion;
and converting the original data format into the target data in the target format by using the data format conversion algorithm in the data format conversion algorithm list.
further, before converting the original data format into the target data in the target format according to the data format conversion mode, the method further includes:
Determining the encoding mode of the original data according to the content of the configuration file;
and decoding the original data according to the encoding mode of the original data.
Further, the generating a design document of the completed database design model using the database model design tool includes:
Importing a pdm-format configuration file generated by a database design model into a database model design tool, and automatically analyzing database design information recorded in the configuration file by the database model design tool, wherein the database design information comprises a database table name, a database field name, a data format and a field size;
And the database model design tool sets the target format as an excel format and generates an excel document according to the analyzed database design information.
further, importing a database design document in an excel format into a database model design tool, and automatically reading database design information recorded in an excel file by the database model design tool;
and the database model design tool converts the read database design information into a configuration file in a pdm format of the database design model.
further, the database model design tool adopts a PowerDesigner tool.
Correspondingly, the invention also discloses a system for mutually converting the database design model and the design document, which comprises the following steps:
The first conversion unit is used for generating a design document by using a database model design tool to the finished database design model;
a judging unit configured to judge whether or not modification of the design document is performed;
and the second conversion unit is used for reversely generating the database design model from the design document by using the database model design tool.
Further, the first conversion unit and the second conversion unit each include:
The configuration file reading module is used for reading the configuration file and determining a target format of data format conversion and a data format conversion algorithm list according to the content of the configuration file;
The original data acquisition module is used for acquiring original data of data format conversion;
And the target data format conversion module is used for converting the original data format into the target data in the target format by using the data format conversion algorithm in the data format conversion algorithm list.
further, the encoding mode determining module is used for determining the encoding mode of the original data according to the content of the configuration file before the original data format is converted into the target data in the target format by using the data format conversion algorithm in the data format conversion algorithm list;
And the original data decoding module is used for decoding the original data according to the encoding mode of the original data.
correspondingly, the invention also discloses a device for mutual conversion between the database design model and the design document, which comprises:
a memory for storing a computer program;
a processor for implementing the method steps of interconversion of a database design model and a design document as described in any preceding claim when executing said computer program.
Compared with the prior art, the invention has the beneficial effects that: the invention provides a method, a system and equipment for mutual conversion between a database design model and a design document, wherein a database model design tool can be used for converting a pdm format file of the data design model into an excel file for archiving; meanwhile, the method can reversely generate a pdm format file of a data design model from the archived excel file for development and database design. Therefore, the rapid and accurate conversion from the database model to the design document is realized in the development process, and the aim of improving the working efficiency is fulfilled.
Therefore, compared with the prior art, the invention has prominent substantive features and remarkable progress, and the beneficial effects of the implementation are also obvious.
drawings
in order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
FIG. 1 is a flow chart of the method of the present invention.
Fig. 2 is a system block diagram of the present invention.
Detailed Description
the following description of the embodiments of the present invention will be made with reference to the accompanying drawings.
as shown in FIG. 1, the present invention provides a method for interconversion between a database design model and a design document, comprising:
after the developer finishes designing the database model in the design stage, the configuration file in the pdm format generated by the database design model is imported into the PowerDesigner tool.
The PowerDesigner tool automatically parses the database design information recorded in the configuration file. The database design information comprises a database table name, a database field name, a data format and a field size.
The PowerDesigner tool sets the target format to an excel format, and generates an excel document from the parsed database design information.
And judging whether the design document is modified, and if so, importing the modified excel format database design document into a database model design tool.
the PowerDesigner tool automatically reads the database design information recorded in the excel file.
And the PowerDesigner tool converts the read database design information into a pdm format configuration file of a database design model.
The method comprises a conversion process of an excel format file and a pdm format configuration file, and specifically comprises the following steps:
step 1: and reading the configuration file, and determining a target format of data format conversion and a data format conversion algorithm list according to the content of the configuration file.
Step 2: and acquiring the original data of the data format conversion.
And step 3: and converting the original data format into the target data in the target format by using the data format conversion algorithm in the data format conversion algorithm list.
And 4, step 4: and determining the encoding mode of the original data according to the content of the configuration file.
And 5: and decoding the original data according to the encoding mode of the original data.
Correspondingly, as shown in fig. 2, the present invention also discloses a system for mutual conversion between a database design model and a design document, comprising:
the first conversion unit is used for generating a design document by using a database model design tool to the finished database design model;
a judging unit configured to judge whether or not modification of the design document is performed;
and the second conversion unit is used for reversely generating the database design model from the design document by using the database model design tool.
The first conversion unit and the second conversion unit each include:
The configuration file reading module is used for reading the configuration file and determining a target format of data format conversion and a data format conversion algorithm list according to the content of the configuration file;
The original data acquisition module is used for acquiring original data of data format conversion;
The target data format conversion module is used for converting the original data format into target data in a target format by using a data format conversion algorithm in the data format conversion algorithm list;
the encoding mode determining module is used for determining the encoding mode of the original data according to the content of the configuration file before converting the original data format into the target data of the target format by using the data format conversion algorithm in the data format conversion algorithm list;
And the original data decoding module is used for decoding the original data according to the encoding mode of the original data.
Correspondingly, the invention also discloses a device for mutual conversion between the database design model and the design document, which comprises the following steps:
a memory for storing a computer program;
A processor for implementing the method steps of interconversion of a database design model and a design document as described in any preceding claim when executing said computer program.
those skilled in the art will readily appreciate that the techniques of the embodiments of the present invention may be implemented as software plus a required general purpose hardware platform. Based on such understanding, the technical solutions in the embodiments of the present invention may be embodied in the form of a software product, where the computer software product is stored in a storage medium, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and the like, and the storage medium can store program codes, and includes instructions for enabling a computer terminal (which may be a personal computer, a server, or a second terminal, a network terminal, and the like) to perform all or part of the steps of the method in the embodiments of the present invention. The same and similar parts in the various embodiments in this specification may be referred to each other. Especially, for the terminal embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant points can be referred to the description in the method embodiment.
In the embodiments provided by the present invention, it should be understood that the disclosed system, system and method can be implemented in other ways. For example, the above-described system embodiments are merely illustrative, and for example, the division of the units is only one logical functional division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, systems or units, and may be in an electrical, mechanical or other form.
the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional modules in the embodiments of the present invention may be integrated into one processing unit, or each module may exist alone physically, or two or more modules are integrated into one unit.
similarly, each functional unit in the embodiments of the present invention may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one unit.
the invention is further described with reference to the accompanying drawings and specific embodiments. It should be understood that these examples are for illustrative purposes only and are not intended to limit the scope of the present invention. Further, it should be understood that various changes or modifications of the present invention may be made by those skilled in the art after reading the teaching of the present invention, and these equivalents also fall within the scope of the present application.
Claims (10)
1. A method for interconversion between a database design model and a design document, comprising:
after a developer finishes designing a database model in a design stage, generating a design document by using a database model design tool for the finished database model;
and judging whether the design document is modified or not, and if so, reversely generating the database design model from the design document by using a database model design tool.
2. The method of claim 1, wherein the generating a design document from the completed database design model using a database model design tool and the generating a database design model from the design document in reverse using a database model design tool each comprises:
reading the configuration file, and determining a target format of data format conversion and a data format conversion algorithm list according to the content of the configuration file;
acquiring original data of data format conversion;
and converting the original data format into the target data in the target format by using the data format conversion algorithm in the data format conversion algorithm list.
3. The method of claim 2, wherein the database design model and the design document are transformed into each other: before converting the original data format into the target data in the target format according to the data format conversion mode, the method further comprises the following steps:
Determining the encoding mode of the original data according to the content of the configuration file;
and decoding the original data according to the encoding mode of the original data.
4. The method of claim 1, wherein generating a design document from the completed database design model using a database model design tool comprises:
importing a pdm-format configuration file generated by a database design model into a database model design tool, and automatically analyzing database design information recorded in the configuration file by the database model design tool, wherein the database design information comprises a database table name, a database field name, a data format and a field size;
And the database model design tool sets the target format as an excel format and generates an excel document according to the analyzed database design information.
5. The method of claim 1 or 4, wherein the inverse generating of the database design model from the design document using the database model design tool comprises:
importing a database design document in an excel format into a database model design tool, and automatically reading database design information recorded in an excel file by the database model design tool;
and the database model design tool converts the read database design information into a configuration file in a pdm format of the database design model.
6. The method of claim 1, wherein the database design model and the design document are transformed into each other by a PowerDesigner tool.
7. a system for interconversion of a database design model with a design document, comprising:
the first conversion unit is used for generating a design document by using a database model design tool to the finished database design model;
A judging unit configured to judge whether or not modification of the design document is performed;
And the second conversion unit is used for reversely generating the database design model from the design document by using the database model design tool.
8. the system of claim 7, wherein the first conversion unit and the second conversion unit each comprise:
the configuration file reading module is used for reading the configuration file and determining a target format of data format conversion and a data format conversion algorithm list according to the content of the configuration file;
The original data acquisition module is used for acquiring original data of data format conversion;
And the target data format conversion module is used for converting the original data format into the target data in the target format by using the data format conversion algorithm in the data format conversion algorithm list.
9. The system of claim 8, wherein the first and second conversion units further comprise:
the encoding mode determining module is used for determining the encoding mode of the original data according to the content of the configuration file before converting the original data format into the target data of the target format by using the data format conversion algorithm in the data format conversion algorithm list;
And the original data decoding module is used for decoding the original data according to the encoding mode of the original data.
10. An apparatus for interconversion of a database design model with a design document, comprising:
A memory for storing a computer program;
a processor for implementing the method steps of interconversion of a database design model and a design document as claimed in any one of claims 1 to 6 when said computer program is executed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910811934.6A CN110569230A (en) | 2019-08-30 | 2019-08-30 | Method, system and equipment for interconversion between database design model and design document |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910811934.6A CN110569230A (en) | 2019-08-30 | 2019-08-30 | Method, system and equipment for interconversion between database design model and design document |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110569230A true CN110569230A (en) | 2019-12-13 |
Family
ID=68776889
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910811934.6A Withdrawn CN110569230A (en) | 2019-08-30 | 2019-08-30 | Method, system and equipment for interconversion between database design model and design document |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110569230A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112395852A (en) * | 2020-12-22 | 2021-02-23 | 江西金格科技股份有限公司 | Comparison method of multi-file format layout document |
| WO2021238563A1 (en) * | 2020-05-28 | 2021-12-02 | 平安科技（深圳）有限公司 | Enterprise operation data analysis method and apparatus based on configuration algorithm, and electronic device and medium |
| CN113792027A (en) * | 2021-08-23 | 2021-12-14 | 浙江金惠科技有限公司 | Universal database conversion device |
-
2019
- 2019-08-30 CN CN201910811934.6A patent/CN110569230A/en not_active Withdrawn
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021238563A1 (en) * | 2020-05-28 | 2021-12-02 | 平安科技（深圳）有限公司 | Enterprise operation data analysis method and apparatus based on configuration algorithm, and electronic device and medium |
| CN112395852A (en) * | 2020-12-22 | 2021-02-23 | 江西金格科技股份有限公司 | Comparison method of multi-file format layout document |
| CN113792027A (en) * | 2021-08-23 | 2021-12-14 | 浙江金惠科技有限公司 | Universal database conversion device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101719149B (en) | Data synchronization method and device | |
| CN110569230A (en) | Method, system and equipment for interconversion between database design model and design document | |
| CN111367886A (en) | Method and device for data migration in database | |
| CN114417408B (en) | Data processing method, device, equipment and storage medium | |
| CN103677821A (en) | Method and device for publishing software development tool code | |
| CN113672204A (en) | Interface document generation method, system, electronic equipment and storage medium | |
| CN111143446A (en) | Data structure conversion processing method and device of data object and electronic equipment | |
| CN110737594A (en) | Database standard conformance testing method and device for automatically generating test cases | |
| CN111858730A (en) | Data importing and exporting device, method, equipment and medium of graph database | |
| CN103226510B (en) | Resolve the method and apparatus of vmcore file | |
| CN112818457A (en) | BIM (building information modeling) model intelligent generation method and system based on CAD (computer-aided design) drawing | |
| CN110888972A (en) | Sensitive content identification method and device based on Spark Streaming | |
| CN109271456A (en) | Host data library file deriving method and device | |
| CN112948247A (en) | Processing method, system, device and medium for operation playback of application program | |
| CN113010542A (en) | Service data processing method and device, computer equipment and storage medium | |
| CN107038022B (en) | Deserialization method and deserialization device | |
| CN110941658A (en) | Data export method, device, server and storage medium | |
| CN115617673A (en) | Test case configuration method based on Cosim platform and application | |
| CN110569243B (en) | Data query method, data query plug-in and data query server | |
| CN114171107A (en) | Detection method, device, equipment and storage medium for VPD information of solid state disk | |
| CN114356454A (en) | Account checking data processing method, account checking data processing device, account checking data storage medium and program product | |
| CN114881913A (en) | Image defect detection method and device, electronic equipment and storage medium | |
| CN109062797B (en) | Method and device for generating information | |
| CN109543079B (en) | Data query method and device, computing equipment and storage medium | |
| CN112101000A (en) | Information consistency test method, device, equipment and computer readable storage medium |
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 | ||
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20191213 |