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

Background: Scabies is the second most common cause of disability among skin diseases in the Philippines as of 2019. There is no large nationwide study describing the epidemiologic profile of scabies in the country. Objective. This study aimed to describe the demographic, seasonal, and geographic profile of scabies in the Philippines. Methods: We compared secondary data of two local patient registries (Philippine Dermatological Society, PDS, 2010 to 2021; and Philippine Pediatric Society, PPS, 2009 to 2021) for reported cases of scabies in the Philippines. We reported the frequency and percentage distribution according to age, sex, month, year, and type of diagnosis, and region. Results: The median annual frequency of scabies cases (mostly outpatient) for PDS (from year 2010) was 4087 (range ([QR], 342-6422 [3271.5]), while it was 183 (range [IQR], 64-234 [96.5]) (all inpatient) for PPS (from year 2009). There was a reduction to one-third (PDS) and one-fourth (PPS) of pre-pandemic numbers during the pandemic years (2020- 2021). The peak months for scabies cases were the cooler months: January (median, 12.1% of annual cases; range [IQR], 2.6%-31.4% [3.6%]) to February (median, 10.0% of annual cases; range [IQR], 1.5%-27.8% [2.5%]) based on PDS data, and November (median, 10.0% of annual cases; range [IQR], 0.0%-24.3% [7.0%]) to January (median, 9.0% of annual cases; range [IQR], 0.0%-24.3% [6.6%]) for PPS data. Overall, for PDS, age 1-4 years is the most affected age group (median, PDS, 17.5% of annual cases; range [IQR], 11.9%-25.4% [8.1%]), while it was the less than 1-yearolds (median annual cases, 48.9%; range [IQR], 29.1%-67.3% [13.20%]) among PPS pediatric population aged 0 to 18 years. Males (median, 53.9% of annual cases; range [IQR], 45.0%-67.2% [8.8%]) were more affected than females in PPS. While for PDS during earlier years (prior to 2015), males (median, 51.6% of annual cases from 2010 to 2014; range [IQR], 47.4%-52.9% [0.2%]) were more affected than females. However, males became less affected than females with median, 44.7% of annual cases from 2015 onwards (range [IQR], 43.4%-46.5% [1.2%]). NCR was the region with the highest frequency of cases in PPS (median, 52.6% of annual cases; range [IQR], 22.7%-75.0% [20.4%]). The 2nd most affected regions were Central/Eastern Visayas (34.2%, 2009-2013; range [IQR], 17.9%-54.1% [5.3%]), Bicol region (12%; 2014 to 2018; range [IQR], 17.9%-54.1% [7.4%]), Central Luzon (18%; 2019), Central/Eastern Visayas (29%, 2020), and Northern/Central Mindanao (17%, 2021). Conclusion Scabies was commonly seen in the younger age group, slightly more in females in the PDS, while slightly more among males in the PPS, in the cooler months of the year, and in the urbanized NCR.
Scabies ; Philippines ; Epidemiology ; Database ; Registries

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

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

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

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

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