oltp database design

Tags: blog http java using OS IO file dataThis article reproduced: http://www.cnblogs.com/olartan/archive/2009/12/02/1615131.htmlChapter 1th IntroductionWhen the amount of data is large, the multiple tables are divided into different db first, then the data is distributed to different databases according to the key columns. After the library distribution, the system query, IO and other operations can have a group of multiple machines together to complete. This article is mainly aimed at, the mas

Get the analysis finished product demand is the line design UML (with class diagram) or the first design database? Reply content: Get the analysis finished product demand is the line design UML (with class diagram) or the first design

The structure of a database (such as tables, relationships, views, and triggers) is called a database schema . You can use SQL statements to create these elements and arrange them in the way you want, but it can be confusing if you don't use graphical tools. PowerDesigner provides a graphical representation of the structure of a database. You can better modify th

follow the normalization of the appropriate table to split, about what is normalization, will be described in detail.2. Excessive use of the paradigm design causes too many table associationsThe design of the database over the use of the paradigm of the design of the idea, for any query to be associated with many tabl

The structure of a database (such as tables, relationships, views, and triggers) is called a database schema . You can use SQL statements to create these elements and arrange them in the way you want, but it can be confusing if you don't use graphical tools. PowerDesigner provides a graphical representation of the structure of a database. You can better modify th

The structure of a database (such as tables, relationships, views, and triggers) is called a database Mode。 You can use SQL statements to create these elements and arrange them in the way you want, but it can be confusing if you don't use graphical tools. PowerDesigner provides a graphical representation of the structure of a database. You can better modify the s

Com.guodiantong.mvc.domain.Customer; Import Com.guodiantong.mvc.impl.CustomerDaoJdbcImpl; public class Customerservlet extends HttpServlet {Customerdao customerdao=new customerdaojdbcimpl (); @Override protected void doget (HttpServletRequest req, HttpServletResponse resp) throws Servletexception, IOException {DoPost (req, resp); } @Override protected void DoPost (HttpServletRequest req, HttpServletResponse resp) throws Servletexception, Ioexcep tion {String servletpath=req.getservletp

user sign in with the mobile phone number. The user provides the home address as the default shipping address. User key information is the phone number and address.2, product few but good. To have high-quality pictures and text introduction. Including the origin, nutrition, whether the season, suitable for the crowd, eating, how to choose and other information. Of course, information can be constantly perfected.3, the user orders, the background response to delivery, customer receipt confirmati

the use of meaningless fields (logical primary key) or meaningful fields (business primary key). Individuals tend to "logical primary key", the reason is that the design of the database model structure clear, the relationship between clear, often more in line with the "third paradigm" (although not intentional, hehe). And it's easier to avoid "federated primary Keys", and you can use index-efficient field