Custom-made database enabling a quick search for patients fulfilling specific criteria. A simple and effective tool for clinical data collection for scientific purposes
Introduction: Every evidence-based scientific work requires precise and reliable data. In clinical medicine, this means searching for patients fulfilling specific criteria. Unfortunately, most hospital-operated information systems are designed to process data concerning treatment of specific patient...
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Medical Communications Sp. z o.o.
2018-11-01
|
| Series: | Aktualności Neurologiczne |
| Subjects: | |
| Online Access: | http://www.neurologia.com.pl/index.php/issues/2018-vol-18-no-3/custom-made-database-enabling-a-quick-search-for-patients-fulfilling-specific-criteria-a-simple-and-effective-tool-for-clinical-data-collection-for-scientific-purposes?aid=1004 |
| _version_ | 1819268091355332608 |
|---|---|
| author | Paweł Daszkiewicz Zuzanna Daszkiewicz Piotr Daszkiewicz |
| author_facet | Paweł Daszkiewicz Zuzanna Daszkiewicz Piotr Daszkiewicz |
| author_sort | Paweł Daszkiewicz |
| collection | DOAJ |
| description | Introduction: Every evidence-based scientific work requires precise and reliable data. In clinical medicine, this means searching for patients fulfilling specific criteria. Unfortunately, most hospital-operated information systems are designed to process data concerning treatment of specific patients, mainly in its medical and administrative aspects, while a crosssectional search for patients with a specific pathology at a specific location is difficult if not impossible. Therefore, most of these databases are essentially useless for scientific purposes. Material and method: Based on medical records of all patients treated at our facility, we have created a simple database enabling a quick search for patients fulfilling specific criteria. We used Microsoft® Office Access® software installed on a standard PC. Structure and the use of database are described in detail. Results: Our database contains basic information about 16,126 patients treated over 38 years and occupies 5.19 MB. To date, 48 queries have been performed, providing reliable scientific material. Conclusion: This is an effective and comprehensive tool for the search of patients or items fulfilling specific criteria. To the best of our knowledge, such a tool for the management of clinical data has not been described to-date. After introducing appropriate modifications, a similar database will be very useful in every clinical centre. |
| first_indexed | 2024-12-23T21:27:33Z |
| format | Article |
| id | doaj.art-32d7f171a99540ddb518303e41712b81 |
| institution | Directory Open Access Journal |
| issn | 1641-9227 2451-0696 |
| language | English |
| last_indexed | 2024-12-23T21:27:33Z |
| publishDate | 2018-11-01 |
| publisher | Medical Communications Sp. z o.o. |
| record_format | Article |
| series | Aktualności Neurologiczne |
| spelling | doaj.art-32d7f171a99540ddb518303e41712b812022-12-21T17:30:34ZengMedical Communications Sp. z o.o.Aktualności Neurologiczne1641-92272451-06962018-11-0118311311610.15557/AN.2018.0015Custom-made database enabling a quick search for patients fulfilling specific criteria. A simple and effective tool for clinical data collection for scientific purposesPaweł Daszkiewicz0Zuzanna Daszkiewicz1Piotr Daszkiewicz2Department of Neurosurgery, The Children’s Memorial Health Institute, Warsaw, PolandStudent; Warsaw Medical University, Warsaw, PolandGeneral Medical Practice “Poradnia Lekarza POZ,” Ząbki, PolandIntroduction: Every evidence-based scientific work requires precise and reliable data. In clinical medicine, this means searching for patients fulfilling specific criteria. Unfortunately, most hospital-operated information systems are designed to process data concerning treatment of specific patients, mainly in its medical and administrative aspects, while a crosssectional search for patients with a specific pathology at a specific location is difficult if not impossible. Therefore, most of these databases are essentially useless for scientific purposes. Material and method: Based on medical records of all patients treated at our facility, we have created a simple database enabling a quick search for patients fulfilling specific criteria. We used Microsoft® Office Access® software installed on a standard PC. Structure and the use of database are described in detail. Results: Our database contains basic information about 16,126 patients treated over 38 years and occupies 5.19 MB. To date, 48 queries have been performed, providing reliable scientific material. Conclusion: This is an effective and comprehensive tool for the search of patients or items fulfilling specific criteria. To the best of our knowledge, such a tool for the management of clinical data has not been described to-date. After introducing appropriate modifications, a similar database will be very useful in every clinical centre.http://www.neurologia.com.pl/index.php/issues/2018-vol-18-no-3/custom-made-database-enabling-a-quick-search-for-patients-fulfilling-specific-criteria-a-simple-and-effective-tool-for-clinical-data-collection-for-scientific-purposes?aid=1004medical recordsdatabasesearch criteria |
| spellingShingle | Paweł Daszkiewicz Zuzanna Daszkiewicz Piotr Daszkiewicz Custom-made database enabling a quick search for patients fulfilling specific criteria. A simple and effective tool for clinical data collection for scientific purposes Aktualności Neurologiczne medical records database search criteria |
| title | Custom-made database enabling a quick search for patients fulfilling specific criteria. A simple and effective tool for clinical data collection for scientific purposes |
| title_full | Custom-made database enabling a quick search for patients fulfilling specific criteria. A simple and effective tool for clinical data collection for scientific purposes |
| title_fullStr | Custom-made database enabling a quick search for patients fulfilling specific criteria. A simple and effective tool for clinical data collection for scientific purposes |
| title_full_unstemmed | Custom-made database enabling a quick search for patients fulfilling specific criteria. A simple and effective tool for clinical data collection for scientific purposes |
| title_short | Custom-made database enabling a quick search for patients fulfilling specific criteria. A simple and effective tool for clinical data collection for scientific purposes |
| title_sort | custom made database enabling a quick search for patients fulfilling specific criteria a simple and effective tool for clinical data collection for scientific purposes |
| topic | medical records database search criteria |
| url | http://www.neurologia.com.pl/index.php/issues/2018-vol-18-no-3/custom-made-database-enabling-a-quick-search-for-patients-fulfilling-specific-criteria-a-simple-and-effective-tool-for-clinical-data-collection-for-scientific-purposes?aid=1004 |
| work_keys_str_mv | AT pawełdaszkiewicz custommadedatabaseenablingaquicksearchforpatientsfulfillingspecificcriteriaasimpleandeffectivetoolforclinicaldatacollectionforscientificpurposes AT zuzannadaszkiewicz custommadedatabaseenablingaquicksearchforpatientsfulfillingspecificcriteriaasimpleandeffectivetoolforclinicaldatacollectionforscientificpurposes AT piotrdaszkiewicz custommadedatabaseenablingaquicksearchforpatientsfulfillingspecificcriteriaasimpleandeffectivetoolforclinicaldatacollectionforscientificpurposes |