Background: Big data in healthcare must be exploited to achieve a substantial increase in efficiency and competitiveness. Especially the analysis of patient-related data possesses huge potential to considerably improve decision-making processes in the healthcare sector. Most analytical approaches used today are highly time- and resource-consuming. The presented software solution Conquery is an open source software tool providing advanced, but intuitive data analysis without the need for specialized statistical training. Results: Conquery is a column-oriented distributed timeseries database and analysis platform. Its main application is the analysis of per-person medical records by non-technical medical professionals. Complex analyses are realized in the Conquery frontend by dragging tree nodes into the query editor. Queries are evaluated by a bespoke distributed query-engine for medical records in a column-oriented fashion. We present a custom compression scheme to facilitate low response times that uses online calculated as well as precomputed metadata and data statistics. Conclusions: Conquery is an efficient and intuitive open source software for performant and secure data analysis and aims at supporting decision-making processes in the healthcare sector.

中文翻译：

---

Conquery：一个用于分析高内涵医疗保健数据的开源应用程序

背景：必须利用医疗保健中的大数据来大幅提高效率和竞争力。特别是对患者相关数据的分析具有极大的潜力，可以显着改善医疗保健领域的决策过程。目前使用的大多数分析方法都非常耗费时间和资源。所提供的软件解决方案 Conquery 是一种开源软件工具，可提供高级但直观的数据分析，无需专门的统计培训。结果：Conquery 是一个面向列的分布式时间序列数据库和分析平台。它的主要应用是非技术医疗专业人员对每个人的病历进行分析。通过将树节点拖到查询编辑器中，在 Conquery 前端实现复杂分析。查询由定制的分布式查询引擎以面向列的方式对医疗记录进行评估。我们提出了一种自定义压缩方案，以促进使用在线计算以及预先计算的元数据和数据统计信息的低响应时间。结论：Conquery 是一种高效、直观的开源软件，用于高性能和安全的数据分析，旨在支持医疗保健领域的决策过程。