MySQL Database Design notes and summaries (3) Physical design

"The work of physical design"

① Choosing the Right Database management system: Oracle,sqlserve,mysql,pgsql

② defining naming conventions for databases, tables, and fields

③ Select the appropriate field type according to the selected DBMS system

④ Anti-Normalization design-consider reading efficiency and adding appropriate redundancy in some tables (space change time)

"Database Selection"

"MySQL Common Storage Engine"

Note: Archive is primarily used to store logs; the Ndb cluster is the storage engine used by the MySQL cluster (memory-based cluster).

"Naming rules for tables and fields"

"Establishing database and table structure--Selection principle of field type"

(Personal experience, choose datetime convenient to view, while DateTime can also directly compare size)

Note: TIMESTAMP maximum 2037 years.

"Select field type"

A fixed length of data, such as a social security number or a telephone, can be stored using char.

MySQL Database Design notes and summaries (3) Physical design