╨╧рб▒с>■  CE■   B                                                                                                                                                                                                                                                                                                                                                                                                                                                ье┴S °┐Ы!bjbjзз 2x═x═w#      lЎЎЎЎЎЎЎ 6668nВ в2кLЎЎЎЎЎЎЎ!######$╘ ЇдGЎЎЎЎЎЎGRЎЎЎЎ\RRRЎ:ЎЎЎЎ!RЎ!RР RтVI@ЎЎ ЎЮ а╜/%ь┴ ,60"Й r0вХxШRШ R  ЎЎЎЎ┘Database Management Project Proposal: Online Medical History Database Application Team members Bill Chen  HYPERLINK "mailto:bchen03@gsm.uci.edu" bchen03@gsm.uci.edu Tina Chuang  HYPERLINK "mailto:tchuang03@gsm.uci.edu" tchuang03@gsm.uci.edu Diana Lai  HYPERLINK "mailto:dlai03@gsm.uci.edu" dlai03@gsm.uci.edu Geoffrey Lim  HYPERLINK "mailto:glim02@gsm.uci.edu" glim02@gsm.uci.edu Identify the Enterprise Our goal in this project is to replace the current paper-based or stand-alone legacy medical history database system in medical institutions with a web-based database system so that doctors, medical researchers, medical institutions, and patients will be benefited from data collection and information sharing efficiency. During the initial stage of the project, we will only focus on a subset of our target end-user, UCI Medical Center, and gradually expand the span of our project to include all UC medical centers. Our vision is to eventually link all other major (private) medical institutions in the US to our network of online medical history database so that doctors, researchers, and patients can freely exchange patientsТ medical history information much easier, faster, and safer. Identify the EC Business Models Transformation: Workflow automation via Web-based DBM services or process interactions. Streamline, reengineer or make business processes Web accessible. Do legacy business processes/services in new ways. Under the current US medical system, most doctors and medical institutions still use papers and folders as the main media to store patientsТ medical history information. Some of the more technologically advanced doctors and medical institutions use stand-alone information storage system but such systems cannot communicate with each other. Not only will our system automate the data collection and storage process, but it will also transform the paper-based or stand-alone systems into a web-based real time database system. Integration: Create integrated views, access or transactions to disparate information sources. Pull together disparate capabilities/products into a coherent framework that realized economies of scale and scope. Make a market niche from untapped fragments. The current medical industry is very fragmented in terms of how doctors and medical institutions store patientsТ medical history information. The success of the project depends on our ability to migrate and integrate the current paper-based or stand-alone systems into our web-based system. A standardized format will be essential for this mass integration of data. Market Exclusivity: Develop, acquire, or possess unique DB content, or more quality content than competitors. Being first, being best, being the only choice, being able to easily defend oneТs market position. Identify, capture, and dominate a niche. Since a standardized digital form of storing patientsТ medical information system does not exist in the market yet, our system will be the first, the best, and the only choice to our target users once it is widely acceptable. Even if there are competitors in the future, there will be a high switching cost associated (i.e. convenience, reliable and comprehensive database, large volume) for those who use another similar site. Identify the DBM Application Portal: Our system will act as a DB-centered information sharing service for doctors, medical researchers, medical institutions, and patients to freely share medical history information. Any of these registered* users can log into our system to either enter or gather any medical information of their interests based on their accessing privilege. * Registration can be based on physician license #, medical institution code, patient social security #, research facility code; and this will be used as one of the access codes needed to use insure confidentiality and proper use of the database. Business Intelligence, Surveillance & Reconnaissance (ISR) Ц More appropriately, it should be Medical Intelligence, Research and Cure (IRC) With our online medical history database system, doctors and researchers can easily query and analyze medical history information with much higher speed, security, and ease. Our web-based database system allows users to log into it anywhere with an Internet connection. Such system will greatly cut down information entering and gathering time because they are in digital format. A highly sophisticated security-protection mechanism needs to be implemented into the system. Protection of the system can prevent data tampering from hackers and ensure the data integrity. Identify Issues Pertaining to Collecting & Managing Data The most challenging aspect of this project is data collection. Without agreements from a majority of patients and medical and/or research institutions involved in this project, we wonТt be able to build a useful system. Initial resistances, especially those from patients, due to security concerns and privacy issues can be expected. Therefore, our abilities to carefully design the security mechanism and to convince the resisters about the safety issues are extremely crucial to the success of this project. One possibility is assigning Уpatient record numbersФ to each patient so they remain anonymous, and this number will be used of all transactions on this database. Identify What Type of Data Model will be Used in the DB Relational: Related tables will be used to stored information about patientsТ medical history. There will be two major sets of tables - personal related and medical related. The personal-related tables will be used to store personal information such as name, age, gender, residence, etc. The medical-related tables will be used to store information such as patientТs medical history, family disease history, allergies, medications/treatments, etc. Identify the Types of Data Stores in the DB Information in the personal-related tables such as patientsТ name, address, telephone numbers, social security numbers will be mostly text based (either string or numbers). On the other hand, information in the medical-related tables will be more multimedia. For example, in addition to text description of patientsТ medical history, graphic images (i.e. X-rays, pathology slides), video files of doctorsТ discussion about the disease can also be saved in patientsТ record. Estimate the Size of the Target DB The ultimate database may contain medical history information up to the amount for the entire American population of 200+ million. Thus, our initial estimate is that we will need about 100-TB of disk space to store all this information. OTHER THINGS TO CONSIDER Internet Patients can communicate with each other (i.e. Уchat roomФ to discuss their treatment for diabetes) Create a virtual community of patients, physicians, and researchers globally. Links Drug updates Research articles Current clinical trials or research projects (i.e. patients can volunteer for them) Key word search for related sites (i.e. through yahoo, google, or medline?) Medical dictionary/Reference sites Services Users want to get articles released/posted immediately УforwardedФ to their email possibly as a link (i.e. patient wants to read about current articles on diabetics while physicians want the latest advances in diabetes treatment) Users know who has utilized their info and for what purposes via a notification function. Users are provided with 24/7 technical services via toll free number hotline. F274 DBM Scacchi April 24, 2002 S_jkУФХий╕╣уфх·√./0BCST{|}ПРТй╞цїЎ╡ ╞ ╥ ╙ ╚ <OP8ц Wу'_?@KL/0  /09:C·ўЁўцЁсЁўЁў╫ЁсЁўЁў═ЁсЁўЁў├ЁсЁў┐ў┐╣┐▓ў╣┐▓ў╣┐▓ў┐╣ў┐ў┐ў┐ў╣┐ў┐ўў┐ў·ўо>*CJ 6БCJ\Б]Б 5Б>*CJ5БCJБj}CJUБjоCJUБj╙CJU0JCJБjCJU jCJUCJ 5БCJ\БD&RS`№СТк┼╞ц╡ ┼ ╞ ╚ ;<8хц_VWуc%&¤¤√ЎЎ√ЎЎЎЎЎЎЎЎЎЎЎЎЎЎЎЎЎЎЎЎЎЎ$a$w!Ъ!¤¤&'`@0  09:CзїЎ№ o╗▀рщ········°··°ЎЎЎёёЎЎьььььЎЎ & F & F$a$CЎ№рщF!O!w!Ш!Ъ!Ы!¤∙¤∙¤є¤Ё¤CJ 5БCJ\Б>*CJCJ щ╧ )!w!Ш!Щ!Ъ!Ы!···єёё· ╞└!Р$ & F░╨/ ░р=!░а"░а#Ра$Ра%░╙D╨╔ъy∙║╬МВкKй bchen03@gsm.uci.eduр╔ъy∙║╬МВкKй 6mailto:bchen03@gsm.uci.edu█D╨╔ъy∙║╬МВкKй tchuang03@gsm.uci.eduр╔ъy∙║╬МВкKй :mailto:tchuang03@gsm.uci.edu╧D╨╔ъy∙║╬МВкKй dlai03@gsm.uci.eduр╔ъy∙║╬МВкKй 4mailto:dlai03@gsm.uci.edu╧D╨╔ъy∙║╬МВкKй glim02@gsm.uci.eduр╔ъy∙║╬МВкKй 4mailto:glim02@gsm.uci.edu i0@ё 0 Normal_HmH sH tH <A@Є б< Default Paragraph Font.>@Є. Title$a$ 5Б>*CJ0B@0 Body Text$a$CJ,@, Header  ╞р└!, @", Footer  ╞р└!&)@в1& Page Number.U@вA. Hyperlink >*B*ph >V@вQ> FollowedHyperlink >*B* phААЫ2    &RS`№СТк┼╞ц╡┼╞╚; < 8 х ц  _VWуc%&'`@0  09:CзїЎ№ o╗▀рщ╧)wШЩЬШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ@0ААШ0ААШ0ААШ@0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААШ0ААЪ0ААШ0ААШ0ААШ 0ААШ 0ААШ0ААШ0ААШ 0ААШ 0ААШ 0ААШ 0ААШ 0ААШ0ААШ0ААШ 0ААШ 0ААШ 0ААЪ@0ААШ@0АА 0"""""%CЫ!&щЫ!Ъ!jФи╕ф·/BS|ПЫX АX ДX ДX А░╢НР▐сwЩЬ8wЩЬ   Geoffrey Lim~C:\Documents and Settings\glim\My Documents\geoffreylim\GSM\Internet Marketing\Online Medical History Database Application.doc Geoffrey LimyC:\Documents and Settings\glim\My Documents\geoffreylim\GSM\DB Management\Online Medical History Database Application.doc Geoffrey LimyC:\Documents and Settings\glim\My Documents\geoffreylim\GSM\DB Management\Online Medical History Database Application.doc Geoffrey LimyC:\Documents and Settings\glim\My Documents\geoffreylim\GSM\DB Management\Online Medical History Database Application.doc Geoffrey LimyC:\Documents and Settings\glim\My Documents\geoffreylim\GSM\DB Management\Online Medical History Database Application.doc Default User_D:\Documents and Settings\tchuang03\Desktop\Data Mgmt\Online Medical History DB Application.doc Default UserВD:\Documents and Settings\tchuang03\Application Data\Microsoft\Word\AutoRecovery save of Online Medical History DB Application.asd Default UserВD:\Documents and Settings\tchuang03\Application Data\Microsoft\Word\AutoRecovery save of Online Medical History DB Application.asd Default UserВD:\Documents and Settings\tchuang03\Application Data\Microsoft\Word\AutoRecovery save of Online Medical History DB Application.asdK_Ё√м          .Єи╢[         М$&tfыxЛ         h Д╨ДШ■╞╨^Д╨`ДШ■OJQJo(oРh ДаДШ■╞а^Да`ДШ■OJQJo(oРh ДpДШ■╞p^Дp`ДШ■OJQJo(зЁРh Д@ ДШ■╞@ ^Д@ `ДШ■OJQJo(╖ЁРh ДДШ■╞^Д`ДШ■OJQJo(oРh ДрДШ■╞р^Др`ДШ■OJQJo(зЁРh Д░ДШ■╞░^Д░`ДШ■OJQJo(╖ЁРh ДАДШ■╞А^ДА`ДШ■OJQJo(oРh ДPДШ■╞P^ДP`ДШ■OJQJo(зЁh Д╨ДШ■╞╨^Д╨`ДШ■OJQJo(oРh ДаДШ■╞а^Да`ДШ■OJQJo(oРh ДpДШ■╞p^Дp`ДШ■OJQJo(зЁРh Д@ ДШ■╞@ ^Д@ `ДШ■OJQJo(╖ЁРh ДДШ■╞^Д`ДШ■OJQJo(oРh ДрДШ■╞р^Др`ДШ■OJQJo(зЁРh Д░ДШ■╞░^Д░`ДШ■OJQJo(╖ЁРh ДАДШ■╞А^ДА`ДШ■OJQJo(oРh ДPДШ■╞P^ДP`ДШ■OJQJo(зЁh Д╨ДШ■╞╨^Д╨`ДШ■OJQJo(oРh ДаДШ■╞а^Да`ДШ■OJQJo(oРh ДpДШ■╞p^Дp`ДШ■OJQJo(зЁРh Д@ ДШ■╞@ ^Д@ `ДШ■OJQJo(╖ЁРh ДДШ■╞^Д`ДШ■OJQJo(oРh ДрДШ■╞р^Др`ДШ■OJQJo(зЁРh Д░ДШ■╞░^Д░`ДШ■OJQJo(╖ЁРh ДАДШ■╞А^ДА`ДШ■OJQJo(oРh ДPДШ■╞P^ДP`ДШ■OJQJo(зЁK_М$&t.                                           vЬ▌ @АЇЫtЫА@  Unknown            GРЗz А Times New Roman5РАSymbol3&Р Зz А Arial?5Р Зz А Courier New;РАWingdings"qИЁ╨hV╝dFх─df @CK 3!Ёе└┤┤Аr0d╒№ 2ГQЁ▀  %Database Management Project Proposal: Geoffrey Lim Default User■ рЕЯЄ∙OhлС+'│┘0ШРШ╚╘ь° ,8 T ` lxАИРф&Database Management Project Proposal:t ata Geoffrey LimgemeofeofNormaly Default Usergem12aMicrosoft Word 9.0 @А╤Ё@D┌ &ы┴@ю=ь┴CK■ ╒═╒Ь.УЧ+,∙оD╒═╒Ь.УЧ+,∙оT hpАИРШ аи░╕ └ ЄфFBCSb3 ╒ &Database Management Project Proposal: Title° 8@ _PID_HLINKSфA░ h mailto:glim02@gsm.uci.educmailto:dlai03@gsm.uci.edu6Mmailto:tchuang03@gsm.uci.eduH3mailto:bchen03@gsm.uci.edu ■    !■   #$%&'()*+,-./01■   3456789■   ;<=>?@A■   ¤   D■   ■   ■                                                                                                                                                                                                                                       Root Entry         └F@уU%ь┴FАData             1Table        "ШWordDocument    2SummaryInformation(            2DocumentSummaryInformation8        :CompObj    jObjectPool            @уU%ь┴@уU%ь┴■                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           ■       └FMicrosoft Word Document MSWordDocWord.Document.8Ї9▓q