Department of Medical Informatics and Biomedical Engineering, Shiga University of Medical Science, Japan.
J Med Syst. 2012 Dec;36(6):3533-41. doi: 10.1007/s10916-012-9822-6. Epub 2012 Mar 3.
With the advancement of pharmaceutical development, drug interactions have become increasingly complex. As a result, a computer-based drug interaction search system is required to organize the whole of drug interaction data. To overcome problems faced with the existing systems, we developed a drug interaction search system using a hash table, which offers higher processing speeds and easier maintenance operations compared with relational databases (RDB). In order to compare the performance of our system and MySQL RDB in terms of search speed, drug interaction searches were repeated for all 45 possible combinations of two out of a group of 10 drugs for two cases: 5,604 and 56,040 drug interaction data. As the principal result, our system was able to process the search approximately 19 times faster than the system using the MySQL RDB. Our system also has several other merits such as that drug interaction data can be created in comma-separated value (CSV) format, thereby facilitating data maintenance. Although our system uses the well-known method of a hash table, it is expected to resolve problems common to existing systems and to be an effective system that enables the safe management of drugs.
随着药物研发的进步,药物相互作用变得越来越复杂。因此,需要一个基于计算机的药物相互作用搜索系统来组织整个药物相互作用数据。为了克服现有系统面临的问题,我们开发了一个使用哈希表的药物相互作用搜索系统,与关系数据库(RDB)相比,它提供了更高的处理速度和更简单的维护操作。为了比较我们的系统和 MySQL RDB 在搜索速度方面的性能,对 10 种药物中的两种药物的所有 45 种可能组合进行了药物相互作用搜索,这两种情况的药物相互作用数据分别为 5604 和 56040。作为主要结果,我们的系统能够处理搜索的速度大约比使用 MySQL RDB 的系统快 19 倍。我们的系统还具有其他几个优点,例如可以以逗号分隔值(CSV)格式创建药物相互作用数据,从而方便数据维护。虽然我们的系统使用了众所周知的哈希表方法,但它有望解决现有系统的常见问题,并成为一种有效的系统,能够安全管理药物。