Data ingestion into a polystore

A computer-implemented method, comprising:

• determining, based at least on a data analysis plan, at least one optimization for an ingestion of a dataset into a polystore that includes a first database management system and a second database management system, the data analysis plan including one or more analytical operations performed on at least a portion of the dataset being ingested into the polystore and/or stored in the polystore, and the ingestion of the dataset into the polystore including storing, in the first database management system and/or the second database management system, at least the portion of the dataset;
• modifying, based on the at least one optimization determined for the ingestion of the dataset into the polystore, the data analysis plan, the data analysis plan being modified by at least adding, removing, and/or reordering the one or more analytical operations included in the data analysis plan;
• and
• applying, during the ingestion of dataset into the polystore, the at least one optimization, the at least one optimization by at least routing, based on the at least one optimization, at least the portion of the dataset for storage at the first database management system and/or the second database management system.

A non-transitory computer-readable medium storing instructions, which when executed by at least one data processor, result in operations comprising:

• determining, based at least on a data analysis plan, at least one optimization for an ingestion of a dataset into a polystore that includes a first database management system and a second database management system, the data analysis plan including one or more analytical operations performed on at least a portion of the dataset being ingested into the polystore and/or stored in the polystore, and the ingestion of the dataset into the polystore including storing, in the first database management system and/or the second database management system, at least the portion of the dataset;
• modifying, based on the at least one optimization determined for the ingestion of the dataset into the polystore, the data analysis plan, the data analysis plan being modified by at least adding, removing, and/or reordering the one or more analytical operations included in the data analysis plan;
• and
• applying, during the ingestion of dataset into the polystore, the at least one optimization, the at least one optimization by at least routing, based on the at least one optimization, at least the portion of the dataset for storage at the first database management system and/or the second database management system.