Abstract: Disclosed herein are system, method, and computer program product embodiments for providing index and storage management for multi-tiered databases. An embodiment operates by receiving a request to create an index on a multi-tiered database including both an in-memory store and a disk store. A multi-store table associated with the index is determined, wherein the multi-store table includes both a first set of data stored on the memory store and a second set of data stored on the disk store. Either the first set of data or the second set of data on which to create the index is selected based on the request. The index for the selected set of data of the multi-store table is generated. The index is stored on either the disk store or the memory store as corresponding to the selected set of data for which the index was generated.

Abstract: Disclosed herein are system, method, and computer program product embodiments for providing a lock-free parallel log replay and synchronization scheme to support asynchronous table replication. By synchronizing a replica table with the server-side data and conducting subsequent updates using transaction logs via a replayer, locking of tables may be avoided. A consistent transactional state may be maintained by employing a replayer to mark the table as enabled instead of a synchronizer. The replayer may also deduce transitive closures among transactions and replay the transactions in parallel based on the deduced transitive closures to optimize playback. These techniques provide enhanced data availability and minimize database blocking and deadlocking while improving query performance.

Abstract: Disclosed herein are system, method, and computer program product embodiments for appropriately routing requests for data stored in multiple storage mediums. An embodiment operates by maintaining a first and second data stored on a first storage medium in communication with a second storage medium. Thereafter, a replicate of the first data stored in the first storage medium may be created for the second storage medium to store a replica data mirroring the first data. Subsequently, a request for retrieval of the first data may be received. Afterward, a previous update time of the second storage medium in receiving the replicate of the first data stored in the first storage medium may be determined. Lastly, based on the previous update time, the request may be forwarded to the first storage medium or second storage medium.

Abstract: Disclosed herein are system, method, and computer program product embodiments for providing a lock-free parallel log replay and synchronization scheme to support asynchronous table replication. By synchronizing a replica table with the server-side data and conducting subsequent updates using transaction logs via a replayer, locking of tables may be avoided. A consistent transactional state may be maintained by employing a replayer to mark the table as enabled instead of a synchronizer. The replayer may also deduce transitive closures among transactions and replay the transactions in parallel based on the deduced transitive closures to optimize playback. These techniques provide enhanced data availability and minimize database blocking and deadlocking while improving query performance.

Abstract: Disclosed herein are system, method, and computer program product embodiments for appropriately routing requests for data stored in multiple storage mediums. An embodiment operates by maintaining a first and second data stored on a first storage medium in communication with a second storage medium. Thereafter, a replicate of the first data stored in the first storage medium may be created for the second storage medium to store a replica data mirroring the first data. Subsequently, a request for retrieval of the first data may be received. Afterward, a previous update time of the second storage medium in receiving the replicate of the first data stored in the first storage medium may be determined. Lastly, based on the previous update time, the request may be forwarded to the first storage medium or second storage medium.

Abstract: Disclosed herein are system, method, and computer program product embodiments for providing index and storage management for multi-tiered databases. An embodiment operates by receiving a request to create an index on a multi-tiered database including both an in-memory store and a disk store. A multi-store table associated with the index is determined, wherein the multi-store table includes both a first set of data stored on the memory store and a second set of data stored on the disk store. Either the first set of data or the second set of data on which to create the index is selected based on the request. The index for the selected set of data of the multi-store table is generated. The index is stored on either the disk store or the memory store as corresponding to the selected set of data for which the index was generated.