Yuanning Gao , Ph.D. advised by Prof. Xiaofeng Gao Advanced Network Laboratory (SEIEE) at Shanghai Jiao Tong University (SJTU) No. 800 Dongchuan Rd., Shanghai, China Office: SEIEE 3-328 gyuanning(-AT-)sjtu.edu.cn Google Scholar, CV (Chinese, English)

Education

• Sep. 2017 – Aug. 2022: Ph.D. in Computer Science, Shanghai Jiao Tong University

• Sep. 2013 – June 2017: B.Eng. in Computer Science, Ocean University of China

Research

• Indexing and Query processing for Large Scale Distributed Systems.

• Optimization and Application of Information Systems.

• Machine Learning for Systems.

Papers

• Yuanning Gao, Xiuqi Huang, Xuanhe Zhou, Xiaofeng Gao, Guoliang Li, and Guihai Chen, DBAugur: An Adversarial-based Trend Forecasting System for Diversified Workloads,
  The 39th IEEE International Conference on Data Engineering (ICDE), California, USA, April 3-7, 2023.

• Yuanning Gao, Xiaofeng Gao, Ruisi Zhang, and Guihai Chen, An End-to-End Learning Based Metadata Management Approach for Distributed File Systems,
  IEEE Transactions on Computers (TC), Volume 71, Issue 5, pp.1021-1034, 2022.

• Yuanning Gao, Xiaofeng Gao, Xianyue Li, Bin Yao, and Guihai Chen, An Embedded GRASP-VNS based Two-Layer Framework for Tour Recommendation,
  IEEE Transactions on Services Computing (TSC), Volume 15, Issue 2, pp.847-859, 2022..

• Xiuqi Huang, Shiyi Cao, Yuanning Gao, Xiaofeng Gao, and Guihai Chen, LightPro: Lightweight Probabilistic Workload Prediction Framework for Database-as-a-Service ,
  The 20th International Conference on Web Services (ICWS), Barcelona, Spain, July 11-16, 2022.

• Yuanning Gao, Xiaofeng Gao, and Guihai Chen, MetisRL: A Reinforcement Learning Approach for Dynamic Routing in Data Center Networks ,
  The 27th International Conference on Database Systems for Advanced Applications (DASFAA), Hyderabad, India, April 11-14, 2022.

• Xiuqi Huang, Yuanning Gao, Xiaofeng Gao, and Guihai Chen, NETR-Tree: An Efficient Framework for Social-Based Time-Aware Spatial Keyword Query ,
  The 19th International Conference on Web Services (ICWS), Online Virtual Congress, September 5-10, 2021.

• Yucen Gao, Yuanning Gao, Yuhao Li, Xiaofeng Gao, Xiang Li, and Guihai Chen, An Attention-Based Bi-GRU for Route Planning and Order Dispatch of Bus-Booking Platform ,
  The 26th International Conference on Database Systems for Advanced Applications (DASFAA), Taipei, Taiwan, April 11-14, 2021.

• Yuanning Gao, Jinbiao Ye, Nianzu Yang, Xiaofeng Gao, and Guihai Chen, A Middle Layer Based Scalable Learned Index Scheme,
  Journal of Software (软件学报), Volume 31, Issue 3, pp.620-633, 2020.

• Chenzhengyi Liu, Weibo Mao, Yuanning Gao, Xiaofeng Gao, Shifu Li, and Guihai Chen, Adaptive Recollected RNN for Workload Forecasting in Database-as-a-Service,
  The 18th International Conference on Service Oriented Computing (ICSOC), Dubai, UAE, December 14-17, 2020.

• Yuanning Gao, Xiaofeng Gao, Xiaochun Yang, Jiaxi Liu, and Guihai Chen, An Efficient Ring-Based Metadata Management Policy for Large-Scale Distributed File Systems,
  IEEE Transactions on Parallel and Distributed Systems (TPDS), Volume 30, Issue 9, pp.1962-1974, 2019.

• Xiaofeng Gao, Yuanning Gao, Yichen Zhu, and Guihai Chen, U2-Tree: A Universal Two-Layer Distributed Indexing Scheme for Cloud Storage System,
  IEEE/ACM Transactions on Networking (TON), Volume 27, Issue 1, pp.201-213, 2019.

• Yuanning Gao, Xiaofeng Gao, Yichen Zhu, and Guihai Chen, An Efficient and Scalable Multi-Dimensional Indexing Scheme for Modular Data Centers,
  Data & Knowledge Engineering (DKE), Volume 123, 2019.

• Yuanning Gao, Xiaofeng Gao, and Guihai Chen, DeepHash: An End-to-End Learning Approach for Metadata Management in Distributed File Systems,
  The 48th International Conference on Parallel Processing (ICPP), Kyoto, Japan, August 5-8, 2019.

• Shiyi Cao, Yuanning Gao, Xiaofeng Gao, and Guihai Chen, AdaM: An Adaptive Fine-Grained Scheme for Distributed Metadata Management,
  The 48th International Conference on Parallel Processing (ICPP), Kyoto, Japan, August 5-8, 2019.

• Zhaorui Li, Yuanning Gao, Xiaofeng Gao, and Guihai Chen, LearningTour: A Machine Learning Approach for Tour Recommendation based on Users' Historical Travel Experience,
  The 24th International Conference on Database Systems for Advanced Applications (DASFAA), Chiang Mai, Thailand, April 22-25, 2019.

• Chunwei Wang, Yuanning Gao, Xiaofeng Gao, Bin Yao, and Guihai Chen, eTOUR: A Two-Layer Framework for Tour Recommendation with Super-POIs,
  The 16th International Conference on Service Oriented Computing (ICSOC), Hangzhou, Zhejiang, China, November 12-15, 2018.

• Lingyun Zhou, Kaiwei Wu, Hanzhi Liu, Yuanning Gao, and Xiaofeng Gao, CIRD-F: Spread and Influence of COVID-19 in China,
  Journal of Shanghai Jiao Tong University (Science), Volume 25, Issue 2, pp.147-156, 2020.

• Chenzhengyi Liu, Jingwei Zhao, Guohang Liu, Yuanning Gao, and Xiaofeng Gao, D2EA: Depict the Epidemic Picture of COVID-19,
  Journal of Shanghai Jiao Tong University (Science), Volume 25, Issue 2, pp.165-176, 2020.

Talks

• Metadata Management for Distributed File Systems, Excellent Doctoral Forum in CCF Annual Conference on Distributed and Parallel Computing Symposium (DPCS 2020).

Projects

• Jan. 2019 – present: Machine Learning Algorithm for Indexing Design

• Jul. 2018 – Dec. 2018: Deep Reinforcement Learning for Distributed Metadata Management

• Jan. 2018 – Dec. 2018: Learned Locality Preserving Hashing for Distributed Metadata Management

• Apr. 2017 – Nov. 2018: General Model for Distributed Indexing Design

• Mar. 2017 – Jan. 2019: Ring-Based hashing Scheme for Distributed Metadata Management

Awards ad Honors

• Huawei Scholarship, 2020

• Yang Jiachi Scholarship, 2019

• First Prize, China Graduate Mathematical Contest in Modeling, 2019

• Third Prize, China Graduate Mathematical Contest in Modeling, 2018

• Outstanding Graduates of Shandong province (Top 2% in department), 2017

• National Scholarship (Top 2% in department, the highest scholarship for Chinese students), 2016

• National Encouragement scholarship (Twice, Top 4% in department), 2015 and 2014

• Class A Scholarship in Ocean University of China (Thrice, Top 5% in department), 2016, 2015, and 2014

Academic Service

• PC member: ECML-PKDD 2020

• Reviewer: COCOA 2017, AAIM 2019

• Conference Organization: COCOA 2017, ISCO 2018, SKA 2018

Teaching Assistance

• Operating Systems at Shanghai Jiao Tong University - CS307 Spring 2018, Tutor: Fan Wu

Datasets of Real-World Database Query Workload

• Tiramisu-Sample: BusTracker workload trace

• SDSS: Logs of queries and requests submitted to SDSS (Sloan Digital Sky Survey) servers

• SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment