[SERVER-85028] Generate normalized data and queries for small scale TPC-H benchmark Created: 14/Oct/21  Updated: 12/Jan/24  Resolved: 25/Nov/21

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major - P3
Reporter: Alya Berciu Assignee: Alya Berciu
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Sprint: QO 2021-11-15, QO 2021-11-29
Participants:

 Description   
  1. For a small scale, generate the data and queries using dbgen, and upload the SQL queries.
  2. Convert the data into a mongo-friendly format, create appropriate indexes, and provide a bson archive for use in PERF tests.
  3. Convert and upload as many queries as possible using the BI connector. There may be follow up work to convert the remainder.


 Comments   
Comment by Alya Berciu [ 25/Nov/21 ]

This was done. The MQL query shapes are listed in the design doc appendix, and the data will be uploaded to an S3 bucket so it can be accessed in DSI for the workload.

Generated at Thu Feb 08 06:56:38 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.