Abstract: A method includes receiving a database query requesting a database to conditionally return one or more data blocks. The database is stored on memory hardware in communication with the data processing hardware and the database query includes a plurality of parameters characterizing the database query. The method includes generating a set of query plans. Each query plan in the set of query plans is configured to execute the database query using a different order of operations. The method includes training a model using historical database queries and generating, using the trained model, a query plan score for each query plan in the set of query plans. The method includes selecting, using the query plan score of each query plan in the set of query plans, a query plan from the set of query plans. The method also includes executing the database query using the selected query plan.

Abstract: A method includes receiving a database query requesting a database to conditionally return one or more data blocks. The database is stored on memory hardware in communication with the data processing hardware and the database query includes a plurality of parameters characterizing the database query. The method includes generating a set of query plans. Each query plan in the set of query plans is configured to execute the database query using a different order of operations. The method includes training a model using historical database queries and generating, using the trained model, a query plan score for each query plan in the set of query plans. The method includes selecting, using the query plan score of each query plan in the set of query plans, a query plan from the set of query plans. The method also includes executing the database query using the selected query plan.

Abstract: Aspects of the disclosure are directed to generating cache configurations for caching data for a database. A database management system (DBMS) can search for column data to cache in a database cache to improve performance of the DBMS in resolving queries. Column data selection can be performed automatically and in the background of a deployed DBMS. Periodically, the DBMS can assess the performance benefit of having certain data cached in the database cache and select data for caching based on the assessed performance benefit. The DBMS can also determine the performance benefit of cached data when not cached, as well as select some portions of data to cache over others. The DBMS can also select data for caching based on different degrees of compression, to further improve query resolution performance.

Abstract: In an example, a flexible schema table may be schematized. Records from the flexible schema table may be queried and, for keys in the records, a data type is estimated for each key. View columns may then be selected from the keys based on a predetermined condition. A view of the flexible schema table may be created from the selected view columns, wherein the view includes the view columns and the data types for the view columns.

Abstract: A computer-implemented process to assess the raw size of a compressed database involves sampling a subset of the cells of the database. The raw sizes of the sampled cells in the subset are assessed. The raw size of the database is determined based on the raw sizes of the sampled cells.

Abstract: In an example, a flexible schema table may be schematized. Records from the flexible schema table may be queried and, for keys in the records, a data type is estimated for each key. View columns may then be selected from the keys based on a predetermined condition. A view of the flexible schema table may be created from the selected view columns, wherein the view includes the view columns and the data types for the view columns.

Abstract: A method for object dependency management for historical access includes assigning versions to states of a structure for storing objects, and assigning the versions to dependency changes between the objects. The method further includes managing historical access to the objects based on an analysis of the versions and the dependency changes between the objects.

Abstract: Data elements are stored at a plurality of nodes. Each data element is a member data element of one of a plurality of layouts. Each layout indicates a unique subset of nodes. All member data elements of the layout are stored on each node in the unique subset of nodes. A stored dependency list includes every layout that has member data elements. The dependency list is used to determine availability of data elements based on ability to access data from nodes from the plurality of nodes.

Abstract: A computer-implemented process (200) for assessing the raw size of a compressed database involves sampling (201) a subset of the cells of the database. The raw sizes of the sampled cells in the subset are assessed (202). The raw size of the database is determined (203) based on the raw sizes of the sampled cells.

Abstract: Data elements are stored at a plurality of nodes. Each data element is a member data element of one of a plurality of layouts. Each layout indicates a unique subset of nodes. All member data elements of the layout are stored on each node in the unique subset of nodes. A stored dependency list includes every layout that has member data elements. The dependency list is used to determine availability of data elements based on ability to access data from nodes from the plurality of nodes.