Caché数据库简单模糊查询的研究与分析

摘要

在医院信息系统中，后关系型数据库Caché以高效的性能而得到广泛应用。详细介绍了对医院药品字典的医嘱项别名进行模糊查询的四种方法。采用一种计算查询时间的方法对其执行效率进行了测试，并且结合每种方法的特性，分析了四种方法的优缺点，给出了每种查询方法的应用场合，为Caché数据库模糊查询提供了参考。%In the hospital information system, post-relational database Caché has been widely used for its high performance. This paper introduces four methods of fuzzy query for doctor's advice alias in hospital dictionary. A method for calculating query time is used to test the execution efficiency of these methods of fuzzy query, the advantages and disadvantages of each method are analyzed according to its characteristics, and the respective application scenario is given, which provides a reference for the fuzzy query of Caché Database.