做这个项目有一段时间了，决定对数据库设计进行一些总结，大概如下：
1.数据库设计之字符集的选择
2.数据库设计之主键的选择
3.数据库设计之设计合理的表结构
4.数据库设计之建模工具的选择与使用
5.数据库设计之避免丢失更新
6.数据库设计之评估数据库规模
7.数据库设计之命名规范
8.数据库设计之存储规划
9.数据库设计之SQL Tuning
10.数据库设计之初始化参数设定
暂定这么多，呵呵
搜索本站
站点日历
订阅本站
文章分类
- upgrade
- 一些事
- 2010第一贴
- 用BBED修复坏块
- 93分
- 没有眼镜真不方便
- 还是换了
- 如何看到本站的图片
- 有图有真相
- 坚持跑步
- try 1 try
- ANS1312E (RC12) Server media mount not possible
- ORA-12528: TNS:listener: all appropriate instances are blocking new connections
- 项目介绍：一客户MES系统升级
- ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
最新日志
- expdp常见用法 (6,600)
- IMP-00010: 不是有效的导出文件，标题验证失败 (5,351)
- ORA-12500: TNS: 监听程序无法启动专用服务器进程 (4,093)
- ORA-01102: cannot mount database in EXCLUSIVE mode (3,827)
- 一则ora-03113错误的解决 (3,789)
- Checking monitor:must be configured to display at least 256 colors (3,498)
- ORA-12545:Connect failed because target host or object does not exist (3,431)
- CRS无法启动的解决过程 (3,015)
- ORA-02019: connection description for remote database not found (2,682)
- ORA-12535: TNS: 操作超时 (2,366)
- 【ZT】Oracle分布式事务故障处理 (2,281)
- ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid (2,258)
- ORA-00600: internal error code, arguments: [17285], [0x2A97446380], [4294967295], [0x1DD7B1238] (2,209)
- 苏州圆融时代广场 (2,012)
- WARNING: inbound connection timed out (ORA-3136) (2,008)
- Oracle CRS log (1,998)
- Choosing an I/O Scheduler for Red Hat® Enterprise Linux® 4 and the 2.6 Kernel (1,989)
- ORA-12528: TNS:listener: all appropriate instances are blocking new connections (1,955)
- Oracle RAC升级问题记录 (1,741)
- 主键约束引起ORA-02429错误 (1,646)
No Comments
Be the first to comment on this entry.
Leave a comment
Fields in bold are required. Email addresses are never published or distributed.
Some HTML code is allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>URLs must be fully qualified (eg: http://www.dbifan.com),and all tags must be properly closed.
Line breaks and paragraphs are automatically converted.
Please keep comments relevant. Off-topic, offensive or inappropriate comments may be edited or removed.