开源软件供应链点亮计划2020,任务列表
中文版本(待更新)
项目题目 | 项目描述 | 难度 | 导师名称/联系方式 | 项目产出要求 | 项目技术要求 | 相关仓库地址 | 报名学生 |
---|---|---|---|---|---|---|---|
官网优化 | 根据项目团队要求,重新设计并实现新的官网。 | 中 | 张亮 |
|
| https://github.com/apache/shardingsphere/tree/master/docs | |
完善SQL语法解析模块 | 参考PostgreSQL数据库的SQL语法,完善Sharding Parser模块有关PostgreSQL的语法定义 | 高 |
潘娟 |
|
| https://github.com/apache/shardingsphere | ||||||
基于Catalyst Optimizer实现SQL查询优化器 | 参考Spark SQL的查询优化器基于Catalyst Optimizer实现ShardingSphere的查询优化器提高ShardingSphere SQL查询性能 | 高 | 蒋晓峰 | 1.基于ShardingSphere Parser模块利用Rule Based(基于经验规则RBO)/Cost Based(基于代价CBO)的优化方法,对逻辑执行计划进行优化 2.ShardingSphere SQL查询性能有一定程度的提高 | 1.熟悉关系代数 2.熟悉常见的查询优化技术:查询重用(ReuseSubquery/ReuseExchange等)/RBO/CBO 3.熟悉Catalyst Optimizer | https://github.com/apache/shardingsphere | |
English Version
Task | Description | Difficulty | Mentor | Output | Tech. Requirements | Repo | Candidate |
---|---|---|---|---|---|---|---|
Official Website Optimization | Redesign and reimplement the website by following the project requirements. | Medium | Liang Zhang |
|
| https://github.com/apache/shardingsphere/tree/master/docs | |
Proofread the SQL definitions of Sharding Parser | It is designed to proofread SQL definitions of Sharding Parser concerning PostgreSQL database | High | Juan Pan |
|
| https://github.com/apache/shardingsphere | |
Implementation of SQL query optimizer based on Catalyst Optimizer | Refer to Spark SQL's query optimizer based on Catalyst Optimizer to implement ShardingSphere's query optimizer to improve ShardingSphere SQL query performance | High | Xiaofeng Jiang | 1. Based on the ShardingSphere Parser module using Rule Based (based on experience rule RBO) | 1. Familiar with relational algebra 2. Familiar with common query optimization techniques: query reuse (ReuseSubquery / ReuseExchange, etc.) / RBO / CBO 3. Familiar with Catalyst Optimizer | https://github.com/apache/shardingsphere | |
...