摘要
信息系统一般需要一个数据持久层来对系统中的信息进行存储和查询,而数据持久层所面临的慢查询问题会极大地影响系统的用户体验。目前的研究可以较好地解决由于数据量的增长所带来的慢查询问题,而对由业务分化带来的慢查询问题无能为力。当业务分化后,数据源将处于不同的业务部门,甚至不同公司的管理下,数据查询时连接操作大大增加。分析在实际生产环境中所面对的慢查询问题,创造性地提出一种使用搜索引擎技术用于改善数据持久层查询性能的系统。该系统具有低侵入性、快速开发、性能优良等优点。
Generally, there is a data persistence layer to store and query the information in any information system. The often faced slow-query problem will greatly affect the system＇s user experience. Present studies can solve some problems caused by the growth of the data quite well. But when facing the problem caused by the business differentiation, the present studies work bad. Usually, the data source will be under the management of different business divisions, even different companies, which caused the increase of join operations in data querying. Analyzes the slow-query problem faced in real production environment, and creatively puts forward a system using the search engine technology to improve query performance. The system has several advantages including： low invasive, agile development, good performance, etc.
关键词
慢查询
搜索引擎
查询优化
系统设计
Slow Query
Search Engine
Query Optimization
System Design
