Shulou(Shulou.com)06/01 Report--

This article mainly shows you the "appearance and practicality of the database modeling tool Chiner how to use", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "appearance and practicality of database modeling tool Chiner how to use" this article.

1. Introduction of chiner

Before the advent of chiner, database modeling and design was done most of the time using PowerDesigner. To tell the truth is basically secretly used, because we all know that PD is paid software, everywhere and domestic manufacturers to file lawsuits. Not only that, PowerDesigner's old-fashioned design interface is almost unbearable, and I have been looking for a replacement for PD.

Recently, when I saw my colleague designing the database, I found that he used a very good-looking tool. He was very fond of it at first glance. My colleague said that the software is very easy to use and is open source, called Chiner (pronounced: [ka designer n roomr]). With regard to this appearance, to tell you the truth, it belongs to the "honorable king" kind of data modeling software, and it is super capable. Just because I took a look at you in the crowd, I can never forget your face!

Because Chiner is developed using electron, windows, Linux major distributions, and MacOS can all be installed.

I won't write how to install this software. I don't want to give you a list of how to use it step by step, how to build a new project, and so on. I don't think it makes much sense. The user interface of this software is still very friendly, so there is basically no learning cost. In addition, there is a very detailed operation manual, after opening the software, click the "operation manual" button shown in the following figure, you can jump to a very detailed operation manual interface.

2. Functional points worth paying attention to

Without mentioning the procedure, what shall we talk about? I would like to tell you what functions this software has, what use these functions are for us, and what is good about it.

2.1. Compatible with data modeling files in various formats

Support the import of data modeling documents in PDMan format. PDman is the predecessor of Chiner and can be understood as the design document of Chiner1.0.

Support for importing CHER files, cher format files are the current version 3.0 export files can be saved independently, after export can be imported from here.

Support for importing PowerDesigner files, that is, if we used PD to do database modeling in vain, we can still import and use it in chiner.

Import from the database, by establishing a database connection, reverse engineering the tables in the database to form a database modeling document.

Import DDL, that is, it can be imported into the project through some table-building statements, view-building statements and so on.

2.2. Support for multiple databases and code generation

The following picture is for the database table table structure design interface, very friendly, I believe that students who have studied the database will use it.

Take a look at the following diagram, which can help us automatically generate table building statements for various databases after the completion of table structure modeling.

Not only that, you can also generate entity class code related to database tables for JAVA and C #. Yes, it is not only a data modeling tool, but also a code generator.

2.3. Support logical view and physical view design

In the process of database design, we usually need to use an ER diagram (logical view) to represent the relationship between the entities corresponding to each table in the database in the initial stage. The entities of ER diagrams can be: one-to-many, one-to-one, many-to-many. As shown in the picture, I use red to mark the "one" in the logical relationship, and blue to mark the "many" in the logical relationship. Examples are as follows:

A class corresponds to multiple students, a college has multiple classes, and a student corresponds to multiple examinations.

By looking at the picture, I think this relationship is very clear and obvious.

After looking at the logical view, and then look at the physical view, the physical view is to give the specific information of the physical structure of the database table on the basis of the logical view.

2.4. Automatically generate database documents

After all the designs are completed, we usually need to output a "database design document". In the past, this document usually needs to be handwritten by ourselves, but with chiner, we can generate it automatically. The following menu bar exports, exports WORD (that is, "Export database design document")!

Take a look at the effect of the exported database word documents, does it save you 80% of your workload? Awesome!

The presentation structure of the generated database table is as follows.

These are all the contents of this article entitled "how to use Chiner, a database modeling tool with both appearance and practicality". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.