Complex query in hospital information system based on database intermediate table
10.7687/j.issn1003-8868.2018.01.037
- VernacularTitle:利用数据库中间表实现医院信息系统中复杂查询
- Author:
Han LI
1
Author Information
1. 解放军92医院信息科
- Keywords:
intermediate table;
hospital information;
complex query;
big data;
statistical requirements
- From:
Chinese Medical Equipment Journal
2018;39(1):37-40
- CountryChina
- Language:Chinese
-
Abstract:
Objective To improve the timeliness of complex query in hospital information system and to reduce excessive use of database resources.Methods Instead of using multi table joint query,an intermediate table was established to store the acquired results periodically,and the user realized complex query by accessing the intermediate table.Results Client inquiry software was used to execute query on statistical data,and it's found the inquiry speed was enhanced greatly after optimization by the intermediate table so that high-precision and-efficiency inquiry could be implemented in big data.Conclusion The intermediate table contributes to executing complex query in hospital information system,and thus is worthy promoting for the precision management in hospital data center.
