online shopping database design

Tags: schema change high concurrency balanced data migration split infinite load balancing delayThe design of database extensibility Architecture Http://mp.weixin.qq.com/s/gI6j_TyjJ4jEb-i8HstFawProblems and solutions to be considered in the sub-list of http://www.jianshu.com/p/32b3e91aa22cInfinite Capacity Database architecture

program | stored Procedure | design | data | Database This article explains how to use DBMS stored procedures. Describes the basic and advanced features of using stored procedures, such as returning resultset. This article assumes that you are already familiar with the DBMS and JDBC, and that you can read the code written in other languages without any hindrance (that is, not the Java language), but it does

Original address: http://blog.sina.com.cn/s/blog_5014663501007n40.htmlin the design of the database, choose the right data type, often can avoid a lot of problems, correctly understand the type of database, for storage space planning, application performance adjustment will be very helpful, here is my personal summary:1. CharFixed-length format string, stored in

Relational database: The principle of relational pattern design1. Paradigm and redundancy of dataFrom 0NF to 1NF, 2NF, 3NF, BCNF, 4NF, 5NF?The process of database design is a split table, the purpose of the split is to reduce the data redundancy.the lower the redundancy of the data, the shorter the transaction duration (it does not require additional operations t

Label: First, draw ER diagram E-r graphs are also called entities - contact Diagrams (Entity Relationship Diagram), which provide methods for representing entity types, attributes, and connections. A conceptual model used to describe the real world. Drawing method: ⑴ determining all the entity collections ⑵ Select the attributes that the entity set should contain ⑶ determining the linkage between entity sets ⑷ determines the keywords for the entity set, using underscores to indicate the attribu