开源软件供应链点亮计划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 | |
Apache ShardingSphere项目基本情况介绍
Hello, everyone!
The distributed database or middleware is so popular these days. If you are interested in this topic, welcome on board!
Apache ShardingSphere is an open-source ecosystem consisted of a set of distributed database middleware solutions. Based on that, I promise you will acquire a deep understanding of the distributed database and middleware.
Moreover, as an Apache TLP (Top level project), this community is open, diverse, and internationalized, which means you can enter into an entire open-source world and start your Apache community journey!
Last but not least, our mentors are experienced at the distributed system, new SQL, and Java programming, since they worked or are working large-scale enterprises. Presently, they are preparing plenty of work for your coming! :-)
社区介绍示例
- 社区名称:Apache ShardingSphere社区
- 社区官方网址:https://shardingsphere.apache.org/
- 社区Logo文件:http://www.apache.org/logos/?#shardingsphere
- 社区描述:Apache软件基金会顶级项目。分布式数据库中间件,提供标准化的数据分片、分布式事务和数据库治理功能,可适用于如Java同构、异构语言、云原生等各种多样化的应用场景。
- 社区邮件列表:dev@shardingsphere.apache.org。 订阅方式,发送邮件到dev-subscribe@shardingsphere.apache.org,根据回复操作。网页版本查看方式,https://lists.apache.org/list.html?dev@shardingsphere.apache.org.
- 社区官方公共邮箱:dev@shardingsphere.apache.org。建议订阅后发送。要求,使用英文。或联系个任务导师邮箱。
- 技术标签:Apache, java, database, sql, transaction
- 专注领域:数据库中间件,分布式治理,SQL解析,分布式事务