-
公开(公告)号:US20180067853A1
公开(公告)日:2018-03-08
申请号:US15257754
申请日:2016-09-06
Applicant: Oracle International Corporation
Inventor: Niloy Mukherjee , Tirthankar Lahiri , Juan R. Loaiza , Jesse Kamp , Prashant Gaharwar , Hariharan Lakshmanan , Dhruvil Shah
CPC classification number: G06F12/08 , G06F3/0604 , G06F3/0638 , G06F3/0647 , G06F3/067 , G06F17/30289 , G06F17/30312 , G06F2212/1016
Abstract: Techniques related to efficient data storage and retrieval using a heterogeneous main memory are disclosed. A database includes a set of persistent format (PF) data that is stored on persistent storage in a persistent format. The database is maintained on the persistent storage and is accessible to a database server. The database server converts the set of PF data to sets of mirror format (MF) data and stores the MF data in a hierarchy of random-access memories (RAMs). Each RAM in the hierarchy has an associated latency that is different from a latency associated with any other RAM in the hierarchy. Storing the sets of MF data in the hierarchy of RAMs includes (1) selecting, based on one or more criteria, a respective RAM in the hierarchy to store each set of MF data and (2) storing said each set of MF data in the respective RAM.
-
公开(公告)号:US11354252B2
公开(公告)日:2022-06-07
申请号:US16144926
申请日:2018-09-27
Applicant: Oracle International Corporation
Inventor: Hariharan Lakshmanan , Dhruvil Shah , Prashant Gaharwar , Shasank K. Chavan , Tirthankar Lahiri , Saraswathy Narayan
IPC: G06F12/12 , G06F16/24 , G06F12/126 , G06F16/22 , G06F16/2455 , G06F16/172
Abstract: Techniques related to automatic cache management are disclosed. In some embodiments, one or more non-transitory storage media store instructions which, when executed by one or more computing devices, cause performance of an automatic cache management method when a determination is made to store a first set of data in a cache. The method involves determining whether an amount of available space in the cache is less than a predetermined threshold. When the amount of available space in the cache is less than the predetermined threshold, a determination is made as to whether a second set of data has a lower ranking than the first set of data by at least a predetermined amount. When the second set of data has a lower ranking than the first set of data by at least the predetermined amount, the second set of data is evicted. Thereafter, the first set of data is cached.
-
公开(公告)号:US20190095346A1
公开(公告)日:2019-03-28
申请号:US16144926
申请日:2018-09-27
Applicant: Oracle International Corporation
Inventor: Hariharan Lakshmanan , Dhruvil Shah , Prashant Gaharwar , Shasank K. Chavan , Tirthankar Lahiri , Saraswathy Narayan
IPC: G06F12/126 , G06F17/30
Abstract: Techniques related to automatic cache management are disclosed. In some embodiments, one or more non-transitory storage media store instructions which, when executed by one or more computing devices, cause performance of an automatic cache management method when a determination is made to store a first set of data in a cache. The method involves determining whether an amount of available space in the cache is less than a predetermined threshold. When the amount of available space in the cache is less than the predetermined threshold, a determination is made as to whether a second set of data has a lower ranking than the first set of data by at least a predetermined amount. When the second set of data has a lower ranking than the first set of data by at least the predetermined amount, the second set of data is evicted. Thereafter, the first set of data is cached.
-
公开(公告)号:US10133667B2
公开(公告)日:2018-11-20
申请号:US15257754
申请日:2016-09-06
Applicant: Oracle International Corporation
Inventor: Niloy Mukherjee , Tirthankar Lahiri , Juan R. Loaiza , Jesse Kamp , Prashant Gaharwar , Hariharan Lakshmanan , Dhruvil Shah
Abstract: Techniques related to efficient data storage and retrieval using a heterogeneous main memory are disclosed. A database includes a set of persistent format (PF) data that is stored on persistent storage in a persistent format. The database is maintained on the persistent storage and is accessible to a database server. The database server converts the set of PF data to sets of mirror format (MF) data and stores the MF data in a hierarchy of random-access memories (RAMs). Each RAM in the hierarchy has an associated latency that is different from a latency associated with any other RAM in the hierarchy. Storing the sets of MF data in the hierarchy of RAMs includes (1) selecting, based on one or more criteria, a respective RAM in the hierarchy to store each set of MF data and (2) storing said each set of MF data in the respective RAM.
-
5.
公开(公告)号:US20170116232A1
公开(公告)日:2017-04-27
申请号:US14922086
申请日:2015-10-23
Applicant: Oracle International Corporation
Inventor: Vineet Marwah , Amit Ganesh , Hariharan Lakshmanan , Prashant Gaharwar , Dhruvil Shah
IPC: G06F17/30
CPC classification number: G06F16/217
Abstract: A method, apparatus, and system for periodic performance optimization through heatmap based management of an in-memory area are provided. A heatmap is maintained to track database accesses, and a sliding most recent time window of the heatmap is externalized to a desired granularity level to provide access statistics regarding candidate elements to be possibly placed in the in-memory area. Initially and on a periodic basis, an appropriate knapsack algorithm is chosen based on an analysis on the computational costs versus the benefits of applying various knapsack algorithms for the candidate elements. Using the chosen algorithm in conjunction with a selected performance model, an optimized configuration of the in-memory area is determined. The optimized configuration indicates a set of elements chosen from the candidate elements, optionally specified with compression levels. A task scheduler then schedules the appropriate tasks, working in a coordinated fashion, to reconfigure the in-memory area according to the optimized configuration.
-
-
-
-