Abstract: A computer implemented method of providing suggestions of related columns for a table operation in a data management system is provided. In one embodiment, the method includes storing, by a processor, a table having a plurality of rows and a plurality of columns, metadata associated with the plurality of columns, and data stored within the plurality of rows and the plurality of columns; receiving, by a processor, a table operation selected by a system or user; processing, by a processor, at least one of the data stored in the plurality of columns and the metadata associated with plurality columns based on a type of the selected table operation to determine at least one relationship between at least two columns of the plurality of columns; and generating, by the processor, dialog data that presents the at least one relationship between the at least two columns to a system or user for use in the table operation.

Abstract: An online system manages data by determining relevance of data dimensions to users. The online system determines which data dimensions a user is likely to be interested in. If a user requests to access a data set that includes data of different dimensions, the online system analyzes the dimensions' relevance to the user before providing the data set to the user. The online system provides the data to the user by prioritizing data dimensions that are more relevant to the user. As such, the online system improves the user experience by allowing users to conveniently and quickly locate relevant data and minimizing the distraction caused by irrelevant data. The online system may create and provide a user interface to present data dimensions that are determined to be relevant.

Abstract: A computer implemented method of providing suggestions of related columns for a table operation in a data management system is provided. In one embodiment, the method includes storing, by a processor, a table having a plurality of rows and a plurality of columns, metadata associated with the plurality of columns, and data stored within the plurality of rows and the plurality of columns; receiving, by a processor, a table operation selected by a system or user; processing, by a processor, at least one of the data stored in the plurality of columns and the metadata associated with plurality columns based on a type of the selected table operation to determine at least one relationship between at least two columns of the plurality of columns; and generating, by the processor, dialog data that presents the at least one relationship between the at least two columns to a system or user for use in the table operation.

Abstract: An online system manages data by determining relevance of data dimensions to users. The online system determines which data dimensions a user is likely to be interested in. If a user requests to access a data set that includes data of different dimensions, the online system analyzes the dimensions' relevance to the user before providing the data set to the user. The online system provides the data to the user by prioritizing data dimensions that are more relevant to the user. As such, the online system improves the user experience by allowing users to conveniently and quickly locate relevant data and minimizing the distraction caused by irrelevant data. The online system may create and provide a user interface to present data dimensions that are determined to be relevant.