Abstract: A method may include generating, based at least on an analysis plan, a logical plan, the analysis plan specifying one or more operations performed on data stored in a polystore that includes a first database management system and a second database management system. The logical plan may include a sequence of logical operators corresponding to the operators specified by the analysis plan. The generating of the logical plan may include rewriting the sequence of logical operators by at least reordering, replacing, and/or combining one or more logical operators in the sequence of logical operators. Candidate physical plans may be generated based on the logical plan. The analysis plan may be executed based on a physical plan selected from the candidate physical plans. Related systems and articles of manufacture are also provided.

Abstract: A method may include determining, based on a data analysis plan that includes analytical operations performed on at least a portion of the dataset being ingested into and/or stored in the polystore, an optimization for the ingestion of the dataset into the polystore. The ingestion of the dataset includes storing, in a first database management system and/or a second database management system in the polystore, the portion of the dataset. The analysis plan may be modified, based on the optimization, by adding, removing, and/or reordering one or more analytical operations included in the data analysis plan. During the ingestion of the dataset, the optimization may be applied by routing, based on the optimization, the portion of the dataset for storage at the first database management system and/or the second database management system. Related systems and articles of manufacture are also provided.

Abstract: A method may include generating, based at least on an analysis plan, a logical plan, the analysis plan specifying one or more operations performed on data stored in a polystore that includes a first database management system and a second database management system. The logical plan may include a sequence of logical operators corresponding to the operators specified by the analysis plan. The generating of the logical plan may include rewriting the sequence of logical operators by at least reordering, replacing, and/or combining one or more logical operators in the sequence of logical operators. Candidate physical plans may be generated based on the logical plan. The analysis plan may be executed based on a physical plan selected from the candidate physical plans. Related systems and articles of manufacture are also provided.

Abstract: A method may include determining, based on a data analysis plan that includes analytical operations performed on at least a portion of the dataset being ingested into and/or stored in the polystore, an optimization for the ingestion of the dataset into the polystore. The ingestion of the dataset includes storing, in a first database management system and/or a second database management system in the polystore, the portion of the dataset. The analysis plan may be modified, based on the optimization, by adding, removing, and/or reordering one or more analytical operations included in the data analysis plan. During the ingestion of the dataset, the optimization may be applied by routing, based on the optimization, the portion of the dataset for storage at the first database management system and/or the second database management system. Related systems and articles of manufacture are also provided.