摘要
为了提高不同场景下面向多表连接、分组、排序、聚合等组合后的数据库复杂查询的效率,设计了一个基于MySQL的Neo4j的混合存储系统。系统定义了一种类SQL查询语言C-SQL来连接两个数据库,并提供统一数据访问接口;基于动态成本模型进行查询优化,将用户查询转化成可并发执行的枚举查询;通过对查询响应时间的度量,确定最优查询计划,进而提高复杂查询的效率。最后通过解析MySQL的Binlog日志解决了从MySQL到Neo4j的数据同步问题。
In order to improve the efficiency of complex queries oriented to the combination of multi-table join, grouping, sorting, aggregation in different scenarios, a MySQL-based Neo4 j hybrid storage system was designed.A type of SQL query language C-SQL was defined to connect the two databases and a unified data access interface was provided.Based on the dynamic cost model for query optimization, the user queries were converted into enumeration queries that can be executed concurrently.Through the measurement of query response time, the best query plan was selected to improve the efficiency of complex queries.Finally, the data synchronization between MySQL and Neo4 j was achieved by parsing MySQL′s Binlog log.
作者
王宁
张伟
王佳慧
马利民
WANG Ning;ZHANG Wei;WANG Jiahui;MA Limin(Computer School,Beijing Information Science&Technology University,Beijing 100101,China;Beijing Advanced Innovation Center for Materials Genome Engineering,Beijing Information Science&Technology University,Beijing 100101,China;Information and Network Security Department,National Information Center,Beijing 100045,China)
出处
《北京信息科技大学学报（自然科学版）》
2022年第1期58-64,70,共8页
Journal of Beijing Information Science and Technology University
基金
北京材料基因工程高精尖创新中心项目。
