Abstract: An administrator of an enterprise storage set may be tasked with storing a large number and variety of data sets on a large number and variety of storage components. However, the manual selection of a physical schema by an administrator may be time-consuming, may generate inefficient physical schemata, and may not be easily reevaluated as the data sets and storage set change. Presented herein are techniques for automatically determining a physical schema by comparing the storage factors of each data set (e.g., data size, relationships with other data sets, and usages of the data set by users) with the storage capabilities of the storage components, selecting a suitable storage component, and implementing the storage of the data set on the storage component. An embodiment of these techniques may thereby achieve an automated identification of a physical schema with improved efficiency and flexibility of the physical schema while conserving administrative resources.

Abstract: An administrator of an enterprise storage set may be tasked with storing a large number and variety of data sets on a large number and variety of storage components. However, the manual selection of a physical schema by an administrator may be time-consuming, may generate inefficient physical schemata, and may not be easily reevaluated as the data sets and storage set change. Presented herein are techniques for automatically determining a physical schema by comparing the storage factors of each data set (e.g., data size, relationships with other data sets, and usages of the data set by users) with the storage capabilities of the storage components, selecting a suitable storage component, and implementing the storage of the data set on the storage component. An embodiment of these techniques may thereby achieve an automated identification of a physical schema with improved efficiency and flexibility of the physical schema while conserving administrative resources.

Abstract: Queries to obtain data from an OLAP cube are consolidated. Queries are consolidated to reduce the number of database hits to retrieve data from an OLAP cube. Instead of querying the OLAP cube for each cell in a free-form report, a consolidated query is used to obtain the desired information. The consolidated query may contain requests for data from different dimensions within the OLAP cube. The cells in the spreadsheet are parsed to determine the dimensions of the OLAP cube that are used within the spreadsheet cell. A list of dimensions accessed by the spreadsheet cells is compiled and the query is constructed by adding default dimensions to each cell as necessary to complete the query.