How do you establish a database and a three-tier architecture?

Databases are basically available in every system, and the three-tier architecture is an important framework for us to build a system model. how can we build databases more easily and quickly, and quickly build a three-tier architecture? Here I recommend two software for you: powerdesigner and dynamic software code generator.

I. powerdesigner is a powerful modeling tool. I think it can be comparable to the familiar rose. Rose is a modeling tool dedicated to object models. Later I want to develop a database. Powerdesegner, on the contrary, started with database modeling and developed into a comprehensive modeling tool.
Next I will briefly talk about his functions, and then focus on database establishment.

1. You can build a medium 7 model:

Business Program Model (BPM), conceptual data model
(CDM), enterprise architecture model (EAM), Information Flow Model (ILM), Logical Data Model (LDM), object-oriented model (OOM), physical data model (PDM ). Correspond to the graph in sequence:

2,
Here I will focus on the physical data model, that is, the database model we create. Others are also very important, such as Oom, which is an object-oriented model, in fact, we can build nine UML diagrams like Rose, including example diagrams, class diagrams, and sequence diagrams. We can try it when using it. Let's see how to use it to create a database.

After reading this link, we have clearly established a database (at the beginning, I just looked at the operation ):

Http://www.cnblogs.com/huangcong/archive/2010/06/14/1757957.html

 

Http://www.cnblogs.com/langtianya/archive/2013/03/08/2949118.html

 

These are all very basic operations, and they are also a very quick way to create a database. They are more convenient and convenient than writing SQL statements in the database or using the resource manager, in this way, the SQL statement script is exported. Of course, the more powerful function is that it can convert several other models:

This facilitates various operations.

In fact, powerdesigner, retional rose, and EA are both modeling tools and have very powerful functions and are very similar, but some focus on different directions. In my opinion, powerdesigner focuses on establishing various models from databases and retional
Rose focuses on object-oriented input and various system architectures. Ea focuses more on the conversion between documents, diagrams, and codes.

 

 

2. Of course, after we have created a database, we need to establish a system framework based on the database content. How can we establish it? We usually write code step by step, which is too slow and inefficient. In addition, for some simple work, it is a repetitive job, and it is truly a code farmer. Here, the dynamic software generator is of great help to us.

1. Introduction: the dynamic software code generator is developed by the dynamic software Excellence (Beijing) Technology Co., Ltd. The predecessor of the software is the self-developed by Mr. Li Tianping, which has been improved and updated for a long time, software copyright has been obtained. I think this is amazing. It is worth learning to write our own software that is especially suitable for us!

2. Software learning. Here I will introduce its main functions. It is very easy to get started because it is Chinese. He mainly generates three-tier architecture code based on the database. here we need to first connect to the database table we want to use:

After selecting the database we want to use, we can perform operations on the right, such as generating database scripts and generating database documents, which are frequently used. The last four are the highlights of code generation. Note that the C # language is built on the ASP. NET platform.

We can see the batch generation:

After this is generated, it is very easy to build the architecture. This is a full set of architectures. We can also generate a single template or a corresponding template. If it is so powerful, we can also create a template to generate it ourselves:

This operation is very convenient for a table. Several other functions are designed to assist in the production of code. You can take a look at them by yourself. This is probably some of the main functions. For more detailed operations, you can refer to this tutorial and write it in great detail. This is a favorite of beginners:

 

Http://wenku.baidu.com/view/3be1af19227916888486d73c.html

 

In this way, the database and architecture of a system have been established, which is also the most important part. Of course, this is far from enough for some complicated and large systems. The database design is convenient for us, and the code generation speeds up our compilation and implementation. I think it is very useful.

But for beginners, I think we can learn to use these software. For dynamic software code generators, we need to learn the advantages of the code structure, encapsulation, and implementation. We can't use it as a tool for convenience without coding. We still need to knock on the Code to increase our code affinity. When can we use this code to "knock" it out without thinking about it.

All in all, software is designed to help us better implement our ideas. If we use it well, it will help us a lot. For beginners, we need to use these software to make up for what we are learning. After all, these are the hard work of some technical experts!