Application Design Basics

 

Data Normalization:

  OLTP – 3NF

  DSS – 2NF

 

Data Type Selection:

  Choose Correct Data Types Right from the beginning 

  Reduce SQL manipulation and data conversion in queries

 

Referential Integrity:

  Use PK-FK relationships wisely

  Do not use a PK which is subject to updates

 

Indexing:

  Understand principles of indexing – PK, don’t forget to index FK

  Understand new types of indexes – Bitmap, Reverse Key

 

SQL DML:

  Understand New Oracle 9i Features

 

Database Backend

  Separate Data and Indexes into different tablespaces 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23895263/viewspace-688159/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23895263/viewspace-688159/