SQL anti-Pattern Learning Note 1 Opening

What is "anti-pattern"

Anti-patterns are a way of trying to solve a problem, but they often cause other problems at the same time.

Anti-Pattern classification

(1) Logical Database design anti-pattern

Before you begin coding, you need to decide what information is stored in the database and how best to organize and correlate the data.

This includes tables, fields, and relationships for how to design a database.

(2) Physical Database design anti-pattern

Once you have identified what data you need to store, you can implement database management as efficiently as possible using the RDBMS relational database technology features you know.

This includes defining tables and indexes, and selecting data types. It also needs to be a "data definition language" for SQL, such as the CREATE TABLE statement.

(3) Query anti-pattern

SQL queries are done using the data manipulation language, such as Insert, Select, UPDATE, and DELETE statements.

(4) Application development anti-pattern

SQL should be used in applications built in Java,. Net, C + +, and PHP, and the way SQL is used in applications is good and bad.

Anti-pattern decomposition

(1) Purpose

This is the task you may want to try to solve. Intent to use anti-patterns to provide solutions, but usually ends up with more problems.

(2) Anti-pattern

This section describes the nature of the solutions that are commonly used, and shows the consequences that are not foreseen, which make these solutions anti-patterns.

(3) How to identify anti-patterns

Some fixed ways will help you identify the anti-patterns used in your project. The special obstacles you encounter, or the things you say to yourself and others,

Can make you recognize the anti-pattern in advance.

(4) Rational use of anti-patterns

There are always exceptions to the rules. In some cases, the design that was supposed to be anti-patterns might be justified, or at least the most plausible of all.

(5) Solutions

Describes the best solution of choice, not only to solve existing problems, but also not to cause new problems caused by anti-patterns.

SQL anti-Pattern Learning Note 1 Opening