Atitit Database hierarchy Schema table and knowledge Point Attilax Summary

Atitit Database hierarchy Schema table and knowledge point attilax Summary

The first stage, probably the theory (35 days

database type, mesh, hierarchy, tree-shaped database, kv database. Oodb

er model    Span style= "Font-family:calibri" >sql concurrency control and   acid database integrity relational model

1NF,2NF,3NF , and BCNF database paradigm stored Procedures Trigger View Constraints

Phase II Project Use (work started to about three years

database connection pool,SQL LINQ

The relational database currently used in our project is the main

There are also a few nosql databases,oo databases, tree-shaped databases ,

Orm ,UI form mapping:

Chapter 10 Copy

Phase III Project Summary (start of work usually takes about 5 years)

principles of database composition, storage engine, index engine, transaction engine, SQL engine

The Linq query engine. redo with undo Lock and latch with concurrency control

Distributed Data Processing divide the table into separate libraries

index btree,hash Full-text index aggregation operation

database meta Information Databasemeta Data ,information schema

Database link gc prevents deadlocks

Synchronization of database structure and data

Atitit. Custom JDBC Drive

Execution plan

atitit. Cross-language database DB API compatibility JDBC ODBC ADO OLE DB

Fourth Stage Theoretical Innovation ( start of work It usually takes about ten years

Oodb Big Data SQL Standardization Draft

Focus on the new technology characteristics of the major databases

join for multi-table retrieval principle

Sub-query principle

Fifth Stage Philosophy Art of Data management ( more than ten years

" Mysql Technical Insider (section 5 edition)" ([ beauty " Paul Dibois ( Paul DuBois "Introduction _ book review Span style= "Font-family:calibri" >_ online reading - when book .html

the high-performance MySQL(Version 3 )("Us" Schwartz (Schwartz)"Introduction _ Book Review _ online reading " - when book . HTML

author::  Nickname :Old Wow's claws( Full Name::AttilaxAkbar Al Rapanui Attilaksachanui) 

Kanji Name: Etila ( Ayron) , email:[email protected]

reprint Please indicate source: http://www.cnblogs.com/attilax/

Atiend

Atitit Database hierarchy Schema table and knowledge Point Attilax Summary