Abstract: A method for a statistics collection framework includes receiving a schema defining a relational database for storing a plurality of statistics corresponding to a query, the relational database including a plurality of data tables relationally connected according to the schema, each data table of the plurality of data tables corresponding to a respective statistic. The method includes receiving a query corresponding to data at a data store. The method also includes executing the query. During execution of the query, the method includes collecting, from a query execution database, the plurality of statistics related to the query, each statistic of the plurality of statistics corresponding to a respective data table of the plurality of data tables of the relational database and, for each statistic of the plurality of statistics, storing the respective statistic at the respective data table according to the schema.

Abstract: A computer-implemented method for efficiently capturing statistics on long running queries includes obtaining a query and obtaining a linked list including a plurality of records, each record in the plurality of records including respective query execution statistics. The method includes executing the query and, during execution of the query, obtaining new query execution statistics associated with the executing query. The method includes creating a new record in the linked list, the new record including the new query execution statistics. The method includes determining that a query execution duration of the query satisfies a query execution threshold. Further, the method includes identifying each record in the linked list that corresponds to the query. The method includes storing, for each respective identified record in the linked list that corresponds to the query, the respective query execution statistics of the respective identified record in a statistics database.

Abstract: A method for a statistics collection framework includes receiving a schema defining a relational database for storing a plurality of statistics corresponding to a query, the relational database including a plurality of data tables relationally connected according to the schema, each data table of the plurality of data tables corresponding to a respective statistic. The method includes receiving a query corresponding to data at a data store. The method also includes executing the query. During execution of the query, the method includes collecting, from a query execution database, the plurality of statistics related to the query, each statistic of the plurality of statistics corresponding to a respective data table of the plurality of data tables of the relational database and, for each statistic of the plurality of statistics, storing the respective statistic at the respective data table according to the schema.

Abstract: A system and method to facilitate cache management and improve disk read performance for database systems with large memory and large disks. A contiguous read feature is employed to read multiple pseudo-contiguous data blocks in one large I/O from disk storage into cache memory. The contiguous read feature loads the disk area containing pseudo-contiguous data blocks by issuing a single disk read. A separate virtual space and memory page list is created for each data block, and the page lists are reunited to create one I/O. The pseudo-contiguity of two data blocks is determined by comparing the distance between them, i.e., the size of the hole between the two data blocks, with a predefined maximum distance, over which it is more effective to read the data blocks independently.