Data dictionary generation tool journey (1): helpful for Generating tools
Recently, we found a very low efficiency when doing our company's demand. When creating a table, we need to use our own modeling tools to create a table, copying and pasting a field is unacceptable. So I developed a tool to solve this inefficiency. As the opening part, we will preview the entire overview of the tool!
Reading directory
- Start
- Good start
- What problems does the tool solve?
- Features & architecture
- Download tool source code
- Learning and using
It is helpful to go back to the top and start
I have been developing a data dictionary generation tool for some time. Currently, the use of data dictionary generation tools in the company is not bad, so I plan to make a summary of this series. As the beginning, let's first understand what data dictionary generation tools are? What problems can be solved. You are also welcome to join147425783 QQ GroupJoin us!
What problems does the tool back on top solve?
Scenario 1: A new version of the product is coming soon. You have to organize a document for modifying the table structure for reference or study by other members. But when you think of creating a table in WORD, copying a field from a field in a table in Chinese or English is a waste of time. How can I generate a data dictionary document for a table with product upgrades?
Scenario 2:I am a new employee. Do I have database design instructions? I have to look up the table every time to help me find and learn.
Scenario 3:We are currently working on interface requirements and need to interact with third parties, but they do not understand our data structure design and hope we can provide a relevant document
Scenario 4:Recently I am working on the porting requirement, but I cannot find the upgrade statement created in the previous table structure, and I have to re-create the table again, which is really troublesome.
Scenario 5:The Database Design Instruction for Word document structure is very worried. First, there are so many red underscores in the table that narrow the width. I want to change the style. What is the HTML format? It looks pretty clear.
Scenario 6:Can I create a table structure in EXECL or WORD and import it directly to generate an SQL statement? Can I use the PD (PowerDesign) file to export the SQL statement used to create a table (although PD supports exporting SQL statements, the function is not satisfactory)
After reading the above six scenarios, I believe everyone knows what the tool is. The next article will introduce you in detail!
Go back to top features & architecture Introduction
First, you can intuitively understand the entire program architecture through graphs.
The Read File converts the file information into a recognizable List <T> object through the format conversion layer. After processing the template file, the List <T> object is converted to the desired file.
Go back to the top tool source code for download
Currently, a total of seven versions have been upgraded and the latest version is available.
Data dictionary generation tool V2.0 Installer |
Latest Installer |
Source code of the data dictionary generation tool |
Latest source code |
Go back to the top
If you have used this tool or want to learn it, join this group to discuss the data dictionary generation tool and make it easier to use it.147425783 QQ Group.
For more information about the data dictionary generation tool, click the data dictionary generation tool topic.
GB/T 202581 basic geographic information element data dictionary
Uploaded to Baidu Library ,:
Wenku.baidu.com/...3.html
How to provide an example of an 8-bit pure digital dictionary starting with 7 and 8
Pinxuan dictionary Generator