Database Design Patterns-Overview

What is the database design model?

Simply put, a pattern is similar to a definite pattern, which is a fixed solution used when the same problem occurs repeatedly. Friends of GO games may be familiar with the term "Regular Expression", which includes the basic principles of the next method, urgent work, handbands, and life and death in various situations when playing chess, for example, Star, small-eye, and edge patterns. The more patterns you know, the better the GO games.

So is it true that the more database design patterns you know, the more perfect the design work?

In theory, this is the case, but here, you can see only four database design modes.

• Many-to-many
• NAME value
• Master/Slave (one-to-many)
• Primary extension (one-to-one)

Why are there only four instead of more? From time to time, is there a saying: "concentrated is the essence "!

In the subsequent articles, you will see the numerous design examples, but they are all designed using these four basic models. "Yi Chuan · Department of Speech" said: "Yi youtai Chi, is the birth of two, the birth of four, four Xiang gossip ." Lao Tzu also said in the Tao Sutra: "Tao Sheng Yi, his life is two, his life is three, and everything is three ."

There is no need for many design patterns. A complete database model can be derived as long as you master the key components and combine them with actual business needs.