OBJECTIVE: Clinical trials are the most time-consuming and expensive part of the drug development process. Clinical Trial Management Systems (CTMSs) help sponsors of clinical trials manage all aspects of planning, performance, and reporting. Most conventional systems provide data processing functions using database management system (DBMS) procedures, which cause DBMS dependency problems. Thus, it is hard to handle the system by researchers who are unfamiliar with database. It is also difficult to share Electronic Case Report Forms (eCRFs) between institutions because conventional systems rely on specific software. METHODS: PhactaManager was developed for solving these problems by introducing an XML Layer in the application tier using an Entity-Attribute-Value model in the database tier. RESULTS: PhactaManager is a three-tier clinical trial management system that has an XML layer. The XML Layer provides a common DBMS independent eCRF document processing platform. Also we developed XML based eCRF Grammar to describe eCRF documents. The XML data elements described by eCRF grammar was constitute to eCRF by PhactaDesigner which an eCRF document design program. CONCLUSION: We achieved DBMS independency by implementing the XML Layer in PhactaManager. The Development of the eCRF Grammar enables the standardization of eCRF design, data correction and data sharing in multicenter clinical trial.
Database Management Systems ; Information Dissemination

PURPOSE: Although many useful articles appear in the journals published in Korea, they are not always cited by researchers mainly due to absence of efficient searching system. The authors made a program with 6 predefined filtering forms to detect published articles rapidly and accurately. MATERIALS: The program was coded using database management system CA-Clipper Version 5.2 (Computer Associates International, Inc.) through preliminary work for 1 year. We used 486 DX II (8 Mbyte RAM, VGA, 200 MByte Hard Disk), Ink-jet Printer (Hewlett Packard Company), and MS-DOS Version 5.0 (Microsoft Co.). We inputed total of 1986 articles published in the Journal of the Korean Radiological Society from 1981 to 1993. METHODS AND RESULTS: The searching time was 10 to 15 seconds for each use. We had very flexible user interfaces and simplified searching methods, but more complicated filterings could also be performed. CONCLUSION: Although the previous version have had some bugs, this upgrade version resolved the problems and fitted in searching articles. The program would be valuable for radiologist in searching articles published not only in the Journal of the Korean Radiological Society, but also in the Journal of the Korean Society of Medical Ultrasound and the Korean Journal of Nuclear Medicine.
Database Management Systems ; Humans ; Korea ; Microcomputers* ; Nuclear Medicine ; Ultrasonography

PURPOSE: To implement the database system of oral and maxillofacial radiological images using a commercial medical image management software with personally developed classification code. MATERIALS AND METHODS: The image database was built using a slightly modified commercial medical image management software, Dr. Image v.2.1 (Bit Computer Co., Korea). The function of wild card "*" was added to the search function of this program. Diagnosis classification codes were written as the number at the first three digits, and radiographic technique classification codes as the alphabet right after the diagnosis code. 449 radiological films of 218 cases from January, 2000 to December, 2000, which had been specially stored for the demonstration and education at Dept. of OMF Radiology of Dankook University Dental Hospital, were scanned with each patient information. RESULTS: Cases could be efficiently accessed and analyzed by using the classification code. Search and statistics results were easily obtained according to sex, age, disease diagnosis and radiographic technique. CONCLUSION: Efficient image management was possible with this image database system. Application of this system to other departments or personal image management can be made possible by utilizing the appropriate classification code system.
Classification ; Database Management Systems ; Diagnosis ; Education ; Humans ; Radiography

PURPOSE: To implement the database system of oral and maxillofacial radiological images using a commercial medical image management software with personally developed classification code. MATERIALS AND METHODS: The image database was built using a slightly modified commercial medical image management software, Dr. Image v.2.1 (Bit Computer Co., Korea). The function of wild card "*" was added to the search function of this program. Diagnosis classification codes were written as the number at the first three digits, and radiographic technique classification codes as the alphabet right after the diagnosis code. 449 radiological films of 218 cases from January, 2000 to December, 2000, which had been specially stored for the demonstration and education at Dept. of OMF Radiology of Dankook University Dental Hospital, were scanned with each patient information. RESULTS: Cases could be efficiently accessed and analyzed by using the classification code. Search and statistics results were easily obtained according to sex, age, disease diagnosis and radiographic technique. CONCLUSION: Efficient image management was possible with this image database system. Application of this system to other departments or personal image management can be made possible by utilizing the appropriate classification code system.
Classification ; Database Management Systems ; Diagnosis ; Education ; Humans ; Radiography

This study was designed to develop a basic plan for computerization of nursing records. The subjects were 7 nursing record forms, 58 charts, 23 nurses, 2 nurses managers, a nurse and computer specialist, 16 master course students and 3 professors. Data collection was conducted through questionnaire, observation and interview. The collected data were analyzed for problems, plan of improvement and needs for computerization. Based upon these results, it is recommended that nursing record computerization was needed a basic plan to integrate needs of nursing record computerization. The basic plan as follows: 1. To illustrate a data flow path of nursing record and data dictionary that show nurse's work and record process. 2. To establish a system in order to use multi-tasking and graphic user interface. 3. To establish hardware and software in order to embody integrated management of computer based system through structured walk through. 4. To choose effective database management system and to achieve Log as record unit.
Surveys and Questionnaires ; Database Management Systems ; Humans ; Nursing Records* ; Nursing* ; Specialization

This study was designed to develop a basic plan for computerization of nursing records. The subjects were 7 nursing record forms, 58 charts, 23 nurses, 2 nurses managers, a nurse and computer specialist, 16 master course students and 3 professors. Data collection was conducted through questionnaire, observation and interview. The collected data were analyzed for problems, plan of improvement and needs for computerization. Based upon these results, it is recommended that nursing record computerization was needed a basic plan to integrate needs of nursing record computerization. The basic plan as follows: 1. To illustrate a data flow path of nursing record and data dictionary that show nurse's work and record process. 2. To establish a system in order to use multi-tasking and graphic user interface. 3. To establish hardware and software in order to embody integrated management of computer based system through structured walk through. 4. To choose effective database management system and to achieve Log as record unit.
Surveys and Questionnaires ; Database Management Systems ; Humans ; Nursing Records* ; Nursing* ; Specialization

We developed a program to estimate an examinee s ability in order to provide freely available access to a web-based computerized adaptive testing (CAT) program. We used PHP and Java Script as the program languages, PostgresSQL as the database management system on an Apache web server and Linux as the operating system. A system which allows for user input and searching within inputted items and creates tests was constructed. We performed an ability estimation on each test based on a Rasch model and 2- or 3-parametric logistic models. Our system provides an algorithm for a web-based CAT, replacing previous personal computer-based ones, and makes it possible to estimate an examinee's ability immediately at the end of test.
Animals ; APACHE ; Cats ; Database Management Systems ; Humans ; Indonesia ; Logistic Models

There is increasing need for network connecting personal computers(PC) together. Thus Local Area Network(LAN) emerged, which was designed to allow multiple computers to access and share multiple files and programs and expensive peripheral devices and to communicate with each user. We built PC-LAN in our department that consisted of 1) hardware-9 sets of personal computers(IBM compatible 80386 DX, 1 set:80286 AT, 8sets) and cables and network interface cards (Ethernet compatible, 16bits) that connected PC and peripheral devices 2) software - network operating system and database management system. We managed this network for 6 months. The benefits of PC-LAN were 1) multiuser (share multiple files and programs, peripheral devices) 2) real time data processing 3) excellent expandibility and flexibility, compatibility, easy connectivity 4) single cable for networking ) rapid data transmission 6) simple and easy installation and management 7) using conventional PC's software running under DOS(Disk Operating System) without transformation 8) low networking cost. In conclusion, PC-LAN provides an easier and more effective way to manage multiuser database system needed at hospital departments instead of more expensive and complex network of minicomputer or mainframe.
Database Management Systems ; Hospital Departments ; Humans ; Microcomputers* ; Minicomputers ; Pliability ; Running

A diet habit, which is developed in childhood, lasts for a life time. In this sense, nutrition education and early exposure to healthy menus in childhood is important. Children these days have easy access to the internet. Thus, a web-based nutrition education program for children is an effective tool for nutrition education of children. This site provides the material of the nutrition education for children with characters which are personified nutrients. The 151 menus are stored in the site together with video script of the cooking process. The menus are classified by the criteria based on age, menu type and the ethnic origin of the menu. The site provides a search function. There are three kinds of search conditions which are key words, menu type and "between" expression of nutrients such as calorie and other nutrients. The site is developed with the operating system Windows 2003 Server, the web server ZEUS 5, development language JSP, and database management system Oracle 10 g.
Child ; Cooking ; Database Management Systems ; Food Habits ; Humans ; Internet

OBJECTIVESTo study methodologies and relevant data-element specifications for basic dataset development in China public health information system construction

METHODSThe goals and scopes were determined through data-viewing analysis, while the function model was developed through information viewing analysis. The components and the structure of the data sets were also identified to distill data elements.

RESULTS50 basic datasets were developed and 1513 data elements were determined in 8 main domains and one public domain in China's public health information system. The 8 domains included Expanded Immunization Program (including 7 Basic Datasets and 326 data elements), Occupational Health and Poisoning (5 Basic Datasets and 158 data elements developed), Laboratory Management (9 Basic Datasets and 118 data elements included), Public Health Emergencies (including 3 Basic Datasets and 47 data elements), Infectious Disease Surveillance (4 Basic Datasets and 177 data elements developed), Non-Chronic Disease Surveillance (3 Basic Datasets and 64 data elements developed), Maternal and Child Health (totally 8 Basic Datasets and 368 data elements developed) and Environment Health (including 4 Basic Datasets and 72 data elements). One common domain consisted of 7 basic datasets and 183 data elements.

CONCLUSIONStandardizing basic datasets in public health information systems is an essential foundation in facilitating information system planning and the effective utilization of resources.