oltp database design

Database paradigm-Easy to understand "turn" database paradigm is an essential knowledge in database design, without the understanding of the paradigm, can not design a high-efficiency, elegant database. Even

,,What is the design principle of nosql? Is there a paradigm similar to that of relational databases? I also found an article:Http://www.cnblogs.com/AllenDang/p/3507821.html! CommentsBasically, the design idea is what I mentioned above: Put the blog and comments together.This reduces the number of queries.However, a problem occurs if the user's nickname changes.Isn't every blog commented by this user going

Article tags design method, article tags database design method examples The following we take WordPress and Sablog as an example, said that WordPress and Sablog in the tag database structure design and procedures of the differences, I hope we can learn from the article labe

on the parent table. The primary key of the parent table is included in the primary key of the child table. Non-identity relationship--the child table does not depend on the parent table, so the child table is the primary key of the parent table as a foreign key, not as part of the primary key of the child table. dependent entities or tables--coauthor tables depend on the author and publication tables. A dependent table exists for a table that has an identity relationship to the parent

1. Access method: This step includes storing and retrieving records from a file.2. Alias (alias): Another name for a property. In SQL, you can replace the table name with an alias.3. Alternate keys (alternate key, er/relationship model): Candidate keys for the primary health are not selected in the Entity/table.4. Anomalies (exception) See Update anomalies5. Application design: A phase of the database appli

database design. Rule 1: Figure out what is the nature of the application that will be developed (OLTP or OPAP)? When you want to start designing a database, you should first analyze what type of application you are designing for, is It "transactional" (transactional) or "analytic" (analytical)? You'll find that many

database design. Rule 1: Figure out what is the nature of the application that will be developed (OLTP or OPAP)? When you want to start designing a database, you should first analyze what type of application you are designing for, is It "transactional" (transactional) or "analytic" (analytical)? You'll find that many

High-quality code design patterns for large. NET ERP Systems1 Cached cacheIn the system, a large number of cache design patterns are used to cache the data unchanged after the system is logged in, and not read directly from the database. Consuming some memory is much more cost-effective than reading data again from SQL Server. The basic

a primary key(because it has no descendants), but must have a foreign key (because it has a father).The design of primary key and foreign key plays an important role in the design of global database. When the global database design is complete, there is an American

Introduction: Before you start reading this article, I have to tell you clearly that I am not a master of database design. The 11 points listed below are the personal insights I have learned from my own experience in project practice and reading. I personally think they have provided a great help to my database design.