Methods and system are disclosed that optimize memory consumed, by sharing datasets between workspaces. In one aspect, multiple workspaces may be instantiated by retrieving multiple datasets from multiple data sources. An input to execute transformations on the multiple datasets may be received. Based on a determination of execution of a transformation on the multiple datasets, a dataset context analyzer may be executed to analyze a current context of data in the multiple datasets. Based on a result of execution of the dataset context analyzer, a transformation graph analyzer may be executed to compute a current context of transformations on the multiple datasets. Based on the determined current context of data and the current context of the transformations on the dataset, memory consumed may be optimized by sharing the multiple datasets between the multiple workspaces.