遠距會診中人員與會診的管理上必須遵循某些安全機制,因此資料庫設計在遠距系統中扮演十分重要的技術.本論文在探討如何設計一個資料庫來管理遠距會診系統中的人員與會診資訊.為了安全性與靈活度的考量,會診系統定義三種人員身份分別為member, invited member,與potential member.不同的參與人員擁有不同的存取權限,例如:預約會診,觀摩會診,與重播會診.此外亦可針對會診需求設定不同的屬性,如：是否開放觀摩,會診內容是否儲存.會診所需記錄的資訊包含,會診參與人員,會診起始時間,會診主題以及所需的醫療影像,本論文主要在設計一個資料庫系統來管理這些資訊.為了提升資料庫效能與安全性,在設計上我們考量資料表的設計,資料表的正規劃,以及資料庫觸發程式的規劃.

Database design plays one essential technique in a Tele-consultation system, particularly if the persons and the discussion sessions are to be managed appropriately following some security restriction. This thesis describes the design approach of the database for managing the personal and sessions in a Tele-consultation system. For security and flexibility considerations, this Tele-consultation system defines three types of personal in the system, including the potential members, members, and invited members. Various types of personal have their own right in access the system, such as whether they can reserve a discussion session from the system, whether they can ask for observing the process of a discussion session, whether they can review a discussion session. In this system a discussion session are allowed to be set with different properties, such as whether it is opened for others to attend in-observe, whether it will be stored for later review. Associated with each discussion session is also the information about the attendee of the session, the session start time, the discussion topic, and the referred medical images. In order to properly manage the system regarding all the sessions, the personals, a database is designed in this thesis. In order to have the database properly designed regarding the performance, efficiently, and security, several design concerns such as the relational table entries, the normalization, and suitably using the procedure triggers are also discussed in this thesis.

[1] Oracle 9i Database, http://www.oracle.com/ip/deploy/database/oracle9i/
[2] Oracle Technology Network, http://www.oracle.com/forums/homepage.jsp?
pgm=otn&uid=1031119674406
[3] N. Fumai, C. Collet, M. Petroni, K, Roger,A.S. Malowany,F,A. Carnevale,R.D. Gottesman,and A.Rousseau,”Evaluatuon of a database for an instensive care unit patient data management system,” Proc. Canadian Conference on Electrical and Computer Engineering,pp.3.4.1-3.4.4,Ottawa,Ont.,Canada,Sept.1190.
[4] N.Fumai, C. Collect, M. Petroni, A.S. Malowany, F.A. Carnevale, R.D.Gottesman, and A. Rousseau, “The design of a simulator for an intensive care unit patient data management system,”Proc. of Third Annual IEEE Symposium on Computer-Baesd Medical Systems,pp.454-461.Chapel-Hill,NC.,June 1990.
[5] K.Roger,C.Collet,N,Fumai,M.Petroni,A.S.Malowany,F.A.Carnvale,R.D.Gottes-man,
and A.Rousseau,”A new bedside data entry system for a patient data management system,”Proc.Canadian Conference an Electrical and Computer Engineering ,pp.75.3.1-75.3.4,Ottawa,Ont.,Canada,Sept. 19690.
[6] F., Borko, "Multimedia System: An Overview," IEEE Multimedia”, VOL 11, pp.47-59, Spring. 1994.
[7] C., Diot, W., Dabbous, J., Crowcroft, "Multipoint Communication: Survey of Pro-
tocols, Functions, and Mechanism," IEEE Journal on Selected Areas in Communi-
cations, VOL. 15, No. 3, pp. 277-290, 1997.
[8] A., Watson, M.A., Sasse, "Multimedia conferencing via multicast: determining the
quality of service required by the end user. Proc. AVSPN'97.
[9] H., Vicky, A.S., Martina, K., Isidor, "Successful multiparty audio communication
over the Internet," Communications of ACM, VOL. 41, No 5, pp. 74-80, May 1998.
[10] C., Diot, W., Dabbous, J., Crowcroft, J., "Multipoint communication: a survey of
protocols, functions, and mechanisms," IEEE Journal on Selected Areas in Commu-
nications, VOL. 15, pp. 277-290, April 1997.
[11] H., Schulzrinne, S., Casner, R., Frederick, V., Jacobson, "RTP: A Transport Protocol
for Real-Time Applications," RFC 1889, 1996.
[12] T., Turletti, C., Huitema, "RTP Payload format for H.261 video streams," RFC 2032,
October 1996.
[13] A., Gersho, "Advances in Speech and Audio Compression," Proceedings of IEEE,
VOL. 82, NO. 6, pp. 900-918, June 1994.