Abstract: A database system provides a non-volatile cache memory layer for caching pages for a set of database from the database system. The non-volatile cache memory layer may include a non-volatile cache for caching pages for a database from the set of database on the database system. The non-volatile cache may be configured through invoking a configuring stored procedure persistent on the database system. A request is received at the non-volatile cache memory layer for performing an operation on a page from the database on the database system. Based on the received request and an identification of the page, a caching operation is performed on the non-volatile cache memory layer. The caching operation is associated with the request. Data associated with the requested operation on the page is stored and organized on the NV cache memory layer.

Abstract: A database system provides a non-volatile cache memory layer for caching pages for a set of database from the database system. The non-volatile cache memory layer may include a non-volatile cache for caching pages for a database from the set of database on the database system. The non-volatile cache may be configured through invoking a configuring stored procedure persistent on the database system. A request is received at the non-volatile cache memory layer for performing an operation on a page from the database on the database system. Based on the received request and an identification of the page, a caching operation is performed on the non-volatile cache memory layer. The caching operation is associated with the request. Data associated with the requested operation on the page is stored and organized on the NV cache memory layer.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for managing data storage as an in-memory database in a database management system (DBMS) are provided. In an embodiment, a specialized database type is provided as a parameter of a native DBMS command. A database hosted entirely in-memory of the DBMS is formed when the specialized database type is specified.

Abstract: A technique for handling stranded file opens for DCOM utility requests in a NSK. In one example embodiment, this is achieved by selecting a source file to be compressed in a disk by the DCOM utility. The source file includes one or more non-contiguous disk file extents and each non-contiguous disk file extent includes multiple blocks. A temporary file is then crated to copy the source file. The multiple blocks in a current non-contiguous disk file extent are then copied from the source file by the DCOM utility by transferring data to the disk as a function of a NSK net transfer data limit size. A current file descriptor of the source file is then stored in an offset field of the temporary file and a current value is then set in the offset field of a source file control block of the source file as a function of whether all of the multiple blocks in the current non-contiguous disk file extent were copied to the disk.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for managing data storage as an in-memory database in a database management system (DBMS) are provided. In an embodiment, a specialized database type is provided as a parameter of a native DBMS command. A database hosted entirely in-memory of the DBMS is formed when the specialized database type is specified.

Abstract: A method for temporarily storing data objects in memory of a distributed system comprising a plurality of servers sharing access to data comprises steps of: reserving memory at each of the plurality of servers as a default data cache for storing data objects; in response to user input, allocating memory of at least one of the plurality of servers as a named cache reserved for storing a specified type of data object; in response to an operation at a particular server requesting a data object, determining whether the requested data object is of the specified type corresponding to the named cache at the particular server; if the data object is determined to be of the specified type corresponding to the named cache, storing the requested data object in the named cache at the particular server; and otherwise, using the default data cache for storing the requested data object.

Abstract: System providing methodology for optimizing data transfer in a distributed environment is described.

Abstract: A method for temporarily storing data objects in memory of a distributed system comprising a plurality of servers sharing access to data comprises steps of: reserving memory at each of the plurality of servers as a default data cache for storing data objects; in response to user input, allocating memory of at least one of the plurality of servers as a named cache reserved for storing a specified type of data object; in response to an operation at a particular server requesting a data object, determining whether the requested data object is of the specified type corresponding to the named cache at the particular server; if the data object is determined to be of the specified type corresponding to the named cache, storing the requested data object in the named cache at the particular server; and otherwise, using the default data cache for storing the requested data object.

Abstract: System providing methodology for optimizing data transfer in a distributed environment is described.

Abstract: A technique for handling stranded file opens for DCOM utility requests in a NSK. In one example embodiment, this is achieved by selecting a source file to be compressed in a disk by the DCOM utility. The source file includes one or more non-contiguous disk file extents and each non-contiguous disk file extent includes multiple blocks. A temporary file is then crated to copy the source file. The multiple blocks in a current non-contiguous disk file extent are then copied from the source file by the DCOM utility by transferring data to the disk as a function of a NSK net transfer data limit size. A current file descriptor of the source file is then stored in an offset field of the temporary file and a current value is then set in the offset field of a source file control block of the source file as a function of whether all of the multiple blocks in the current non-contiguous disk file extent were copied to the disk.