The first article about the database needs to know

1, the database field design for A1,A2,... This, with the field name is all Chinese, more want to laugh at that?

2, do you remember to index, knowledge about the index you know what?

This is important, you know what's going on?

3. Do you consider using stored procedures, pure JDBC, or ORM frameworks?

Stored procedures: The best performance, the development speed is slow, maintenance up, change the stored procedure, change the code call .....

Pure JDBC: Better performance than ORM, development speed, center

Use the ORM Framework: fast development, slightly worse performance.

4, accidentally, cross-database, how can things be used?

SQL stored procedures can be used, and code can implement things.

5, the first demo or database design? Let's draw a demo and look at the plug.

6. What major databases do you know? What sort?

Relationship Type: SQL server,mysql

NOSQL: Listen to MongoDB

7, about SQL tuning, you know what?

Well, I'll go and have a look.

The first article about the database needs to know