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/，如需轉載，請註明出處，否則將追究法律責任。