Shulou(Shulou.com)05/31 Report--

This article shows you what problems should be paid attention to in the design of the website database, the content is concise and easy to understand, it can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

To realize the optimization of sql server database, we must first have a good database design scheme. In practice, many sql server schemes often have poor performance due to poor database design. Today, the editor will show you how to achieve good database design:

1. Normalization of logical database

In general, logical database design meets the first three levels of normalization:

Specification 1: no duplicate groups or multi-valued columns

Specification 2: each non-key field must depend on the primary keyword, not on some components of a combined primary keyword

Specification 3: one non-key field cannot depend on another non-key field.

Database designs that follow these rules result in fewer columns and more tables, thus reducing data redundancy and pages used to store data.

two。 Generate a physical database

In order to choose the basic physical implementation strategy correctly, we must understand and make good use of the database access format and the operation characteristics of hardware resources, especially the memory and disk subsystem iUnio. Here are some common techniques:

The data type associated with each table column should reflect the minimum storage space required for the data, especially for indexed columns. For example, if you can use the smallint type, don't use the integer type, so that the index fields can be read more quickly, and more rows of data can be placed on a data page, thus reducing the number of integer operations.

Performance can be improved by placing a table on a physical device and then placing its unclustered index on a different physical device through the segments of the sql server. Especially when the system uses multiple intelligent disk controllers and data separation technology, the benefits are more obvious.

Performance can also be improved by splitting a frequently used large table with a sql server segment and placing it on multiple database devices of separate intelligent disk controllers. Because there are multiple heads looking, data separation can also improve performance.

Using sql server segments to store data from text or image columns on a separate physical device can improve performance. A special intelligent controller can further improve the performance.

The above content is the website database design should pay attention to what problems, you have learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are 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.