ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Application Design Basics

Application Design Basics

原创 Linux操作系统 作者:wuxidba 时间:2011-03-01 11:10:28 0 删除 编辑
 

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 2NF and 3NF
请登录后发表评论 登录
全部评论

注册时间:2010-05-12

  • 博文量
    64
  • 访问量
    64555