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

1. From the point of view of the hierarchical principle of logical architecture

Association relations represent business rules / logic. Unconstrained use of association queries means that a large number of business rules and logic are executed in the database. The database consumes cpu, memory, io and other resources for association operations, which is actually doing what the application should do.

two。 From the perspective of resource utilization

In most scenarios, not all the results of associated queries are used effectively. For example, the list interface managed by the background is usually displayed in pages. For the result set of the associated query, only the data of the current page is used, and the rest is useless, but the database needs to consume additional resources to get all the result sets. And get the current page data from it.

3. In terms of the scalability of the architecture

A large number of associated queries will make it difficult to transform a centralized database architecture into a distributed architecture, and it is difficult to optimize in terms of scalability.

Advantages and disadvantages:

The association query is convenient and fast, and the development efficiency is relatively good. It can be used if the system and database can fully meet the performance requirements through some vertical optimization means, such as the internal management system of small and medium-sized enterprises.

Not using associated query has many advantages at the architecture level, but it requires high ability of system analysis, design and development. Generally speaking, in the case of a large number of users such as the Internet industry, it is best to pay attention to this aspect.

In theory, there are no complex scenarios, and you can't meet the requirements without using the associated query of the database. The giant ERP system SAP, basically the whole system function is realized by single table query.

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.