oltp database design

In many places, you will encounter such problems as:In an organization, from high-level leadership to middle-level leadership to ordinary workers, there is a hierarchical relationship, these relationships in the relational database in the expression, there is a special way.Some people set them up in separate tables, establish the corresponding relationship, although this is a solution, but if in the application, it will cause a lot of inconvenience to

Database Design Process and database Process Get started with user requirements Main functions of the software: Because users are divided into average users, operators, and administrators. The first column is the administrator's function, the second column is the operator's function, and the third column is the general user's function.

Curriculum needs, the need to develop a talent referral system, so designed this database, only for learning.This project has built up 11 tables, namely user table T_user, User Role table t_role, User Rights table T _permission, role and permission relation table t_role_permission, Department table t_department, function table t_job, resume table t _resume, recruitment information Form t_recruit, recruitment process table t_recommend, talent pool t_ta

8.5 use ViewContrary to the popular concept, a view is actually detrimental to performance-not necessarily because of the use of a view, but because of its common usage in a business environment. In the database model design stage, why not use the view as a performance adjustment tool? This book will explain from the perspective of database modeling.Tip:A view is

A series of best practices are used to design the entire enterprise database. The following are some best practices: The common module is used in the core library. Unified naming conventions and versions are used. Use unit tests during design Include infrastructure in all modules The Enterprise Library module includes the following models, including other m

database table Design optimization :Sometimes in order to improve the efficiency of the database, we can properly consider the inverse three paradigms, add redundant fields appropriately, and reduce multi-table to correlate queries . Use index :2.1 database table design sh

Atitit. database partition design attilax Summary1. partitioning is the principle of partitioning in different categories of folders (what) The basic principle of partitioning is to access a table or a small part of the index, rather than accessing the entire table and index, in order to improve the performance of the database. If you place different partitions i

[This article is transferred from http://hanbosun.blog.sohu.com/1285004.html] Source http://www.martinfowler.com/articles/evodb.html Original Name: Evolutionary Database Design Author: Martin Fowler, Pramod Sadalage Translation: winboy20 Keywords:Database Design agile method Evolutionary Design 0 IntroductionIn the

You do two things before you go to bed every day. the design of database tableA pair of many pairs of more than one one-on-one One-to-many or Many-to-many one: multiple parties plus foreign keys, describing the relationship of the data Many-to-many: Add an intermediate table to describe the relationship table Design (departments and employees) when a one-to-ma

between the system, should be avoided as far as possible. We should also abide by the same principle when we design the relationship between database tables, the separation of duties reduces coupling, but at the same time take into account the performance situation, so that proper redundancy does not lead to the complexity of the modification logic. Here are some examples of the most common posts and comme

Database Design(Database Design) Refers to the optimal construction of a given application environment.DatabaseModeTo create databases and their application systems so that they can effectively store data and meet the needs of various user applications.Requirement(Information Requirements and handling requirements ).

Tags: database design english Word data table underline nameDatabase naming rules:Named according to the actual meaning of the project.Data table naming rules:1. The names of the data tables are mostly in the plural form of nouns and are lowercase;2. Use the prefix "Table_" as far as possible;3. If the table name of the data table is made up of multiple words, try to connect it with an underscore, but do no

Yesterday listened to a public class, the class is a 10 years experience in the development of the architect, talking about the design of the database optimization and SQL statement optimization, speak very easy to understand, here first the database design optimization to share to everyone. 1. Moderate violations of

Database relational paradigm has "1NF", 2nf,3nf,4nf,5nf,bcnf 1NF: In the Design database relationship R, each property can not be decomposed into units, then R is 1NF. For example: name, telephone this is 1NF 2NF: in Relationship R (x,y), all attributes are entirely determined by a candidate keyword. Unique identification for the record 3NF: is a redundant con

. Consider downloading the application to the memory of the application once it is started and caching it. After obtaining the result set from the database, the program uses these cached table code table data to translate the table code fields instead of translating the fields through the relational query between the tables in the database. I often see some startling de