You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

开源软件供应链点亮计划2020，任务列表

中文版本（待更新）

项目题目

项目描述

难度

导师名称/联系方式

项目产出要求

项目技术要求

相关仓库地址

报名学生

官网优化根据项目团队要求，重新设计并实现新的官网。中

张亮

zhangliang@apache.org


  1. 符合Apache的页面要求
  2. 官网首页支持内容滑动
  3. 支持官方文档PDF导出
  4. 重新设计社区和下载页面
  5. 能够使用Hugo编译成为静态网站
  6. 仅允许使用开源的风格资源，或自主设计
  7. 支持Markdown风格的博客和文章
  8. 支持第三方视频、音频资源
  1. 美工设计
  2. 页面布局
  3. Hugo
  4. Markdown
https://github.com/apache/shardingsphere/tree/master/docs
完善SQL语法解析模块参考PostgreSQL数据库的SQL语法，完善Sharding Parser模块有关PostgreSQL的语法定义高

潘娟

panjuan@apache.org


  1. 符合ShardingSphere SQL语法定义风格
  2. 依据PostgreSQL官网的DCL SQL语法定义，校对Sharding Parser的语法定义
  3. 依据PostgreSQL官网的DAL SQL语法定义，校对Sharding Parser的语法定义
  4. 依据PostgreSQL官网的DDL SQL语法定义，校对Sharding Parser的语法定义
  5. 依据PostgreSQL官网的DML SQL语法定义，校对Sharding Parser的语法定义
  1. 能够使用Java编程语言
  2. 熟悉正则表达式
  3. 了解Antlr基本运行原理
  4. 了解如何编写Antlr的g4语法文件
https://github.com/apache/shardingsphere
基于Catalyst Optimizer实现SQL查询优化器参考Spark SQL的查询优化器基于Catalyst Optimizer实现ShardingSphere的查询优化器提高ShardingSphere SQL查询性能高

蒋晓峰

nicholasjiang@apache.org


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 OptimizationRedesign and reimplement the website by following the project requirements.Medium

Liang Zhang

zhangliang@apache.org

  1. Follow all Apache Foundation requirements
  2. Homepage support slidable contents
  3. Support document export to PDF
  4. Redesign community/download pages. 
  5. Hugo based website build process
  6. Only use open source or new design materials(css, images, etc.)
  7. Support blogs and articles in markdown
  8. Support Video and Audio hosted on the 3rd party platform
  1. UI Design
  2. Website Layout
  3. Hugo
  4. Markdown
https://github.com/apache/shardingsphere/tree/master/docs
Proofread the SQL definitions of Sharding ParserIt is designed to proofread SQL definitions of Sharding Parser concerning PostgreSQL databaseHigh

Juan Pan

panjuan@apache.org


  1. Follow the SQL definition style of ShardingSphere
  2. Proofread the DCL SQL definitions of Sharding Parser referring to PostgreSQL document
  3. Proofread the DAL SQL definitions of Sharding Parser referring to PostgreSQL document
  4. Proofread the DDL SQL definitions of Sharding Parser referring to PostgreSQL document
  5. Proofread the DML SQL definitions of Sharding Parser referring to PostgreSQL document
  1. Be able to program with Java
  2. Be familiar with regular expression
  3. Basically learn how Antlr works
  4. Know how to write g4 file of Antlr
https://github.com/apache/shardingsphere
Implementation of SQL query optimizer based on Catalyst OptimizerRefer to Spark SQL's query optimizer based on Catalyst Optimizer to implement ShardingSphere's query optimizer to improve ShardingSphere SQL query performanceHigh

Xiaofeng Jiang

nicholasjiang@apache.org


1. Based on the ShardingSphere Parser module using Rule Based (based on experience rule RBO) 
/ Cost Based (based on cost CBO) optimization method to optimize the logic execution plan
2. ShardingSphere SQL query performance has been improved to a certain extent

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! :-)

社区介绍示例

  1. 社区名称：Apache ShardingSphere社区
  2. 社区官方网址：https://shardingsphere.apache.org/
  3. 社区Logo文件：http://www.apache.org/logos/?#shardingsphere
  4. 社区描述：Apache软件基金会顶级项目。分布式数据库中间件，提供标准化的数据分片、分布式事务和数据库治理功能，可适用于如Java同构、异构语言、云原生等各种多样化的应用场景。
  5. 社区邮件列表：dev@shardingsphere.apache.org。 订阅方式，发送邮件到dev-subscribe@shardingsphere.apache.org，根据回复操作。网页版本查看方式，https://lists.apache.org/list.html?dev@shardingsphere.apache.org.
  6. 社区官方公共邮箱：dev@shardingsphere.apache.org。建议订阅后发送。要求，使用英文。或联系个任务导师邮箱。
  7. 技术标签：Apache, java, database, sql, transaction
  8. 专注领域：数据库中间件，分布式治理，SQL解析，分布式事务
  • No labels