About 视图 (View)

一直对视图都没有好好总结过 ， 之前跟高老师牛Oracle时候用得是比较上手了。只是时间流逝 自己也忘得差不多了
回顾了一下:
作用： 其实视图最大的作用无非就是集中多张主表的数据 包括统筹、运算等 方便客户端或前台开发人员直接调用。

PS:  View不支持Order by ，but Group by ...

---

posted @ 2006-01-09 08:28 Royman.Chen 阅读(62) 评论(0) 编辑

PetShop 3.0 Database structure

PetShop 3.0 Database structure

1. MSpetshop

 

 

2. petshop oders

 

download 1.5 pdf

27/12/05 by Royman

---

posted @ 2006-01-09 07:23 Royman.Chen 阅读(92) 评论(0) 编辑

Structure of "Net Tradding" by Kane

DB structure of Net Tradding by Kane

27/12/05 by Royman

---

posted @ 2006-01-09 07:21 Royman.Chen 阅读(47) 评论(0) 编辑

Muti-Tier application design

Muti-Tier application design

 

Presentation : like HTML / XML , CSS or JS for web

Business Tier : security (like SQL injured), business logic control , validation (like regular expressions) ...

Data Access Tier : supply some interfaces between BT and DB (like  decide to use procedure or SQL connecting string in the programme,use ado.net code to reat/write DB, to control the BT table object or class, CRUD-- create,read,update,delete )

DB Tier : Manage the database, write the procedure in order to improve the performance.

by Royman 29/12/05

---

posted @ 2006-01-09 07:18 Royman.Chen 阅读(62) 评论(0) 编辑

Wifi Royman!!

Cool!

288RMB = = D-Link DI-624+A  802.11b/g 2.4GHz Wifi Router

 

Of course need the password to access my apartment Wifi service!!!

posted @ 2006-01-09 07:16 Royman.Chen 阅读(151) 评论(0) 编辑