公开(公告)号：US08099577B2

公开(公告)日：2012-01-17

申请号：US11726060

申请日：2007-03-20

申请人： Bharat C. V. Baddepudi ,  Tirthankar Lahiri ,  Kiran B. Goyal ,  Benoit Dageville ,  Siddhartha Roychowdhury ,  Brian Hirano ,  Balasubramanian Narasimhan

发明人： Bharat C. V. Baddepudi ,  Tirthankar Lahiri ,  Kiran B. Goyal ,  Benoit Dageville ,  Siddhartha Roychowdhury ,  Brian Hirano ,  Balasubramanian Narasimhan

IPC分类号： G06F12/00

CPC分类号： G06F12/0284 ,  G06F9/52

摘要： A method and apparatus for auto-tuning memory is provided. Memory on a computer system comprises at least one shared memory area and at least one private memory area. Addresses in the shared memory area are accessible to multiple processes. Addresses in the private memory area are dedicated to individual processes. Initially, a division in the amount of memory is established between the shared and private memory areas. Subsequently, a new division is determined. Consequently, memory from one memory area is “given” to the other memory area. In one approach, such sharing is achieved by causing the shared and private memory areas to be physically separate from each other both before and after a change in the division. The division of the amount of memory may be changed to a new division by deallocating memory from one of the memory areas and allocating that memory to the other of the memory areas.

摘要翻译： 提供了一种用于自动调谐存储器的方法和装置。 计算机系统上的存储器包括至少一个共享存储器区域和至少一个专用存储器区域。 共享内存区域中的地址可以访问多个进程。 专用内存区域中的地址专用于各个进程。 最初，在共享和专用存储区之间建立了存储量的划分。 随后，确定了一个新的部门。 因此，来自一个存储器区域的存储器被“给予”另一个存储器区域。 在一种方法中，这种共享是通过使分区和专用存储器区域在分区改变之前和之后彼此物理上分开来实现的。 通过从存储区域之一释放存储器并将该存储器分配给存储区域中的另一个，可以将存储量的划分改变为新的划分。

公开(公告)号：US10430338B2

公开(公告)日：2019-10-01

申请号：US12691146

申请日：2010-01-21

申请人： Kothanda Umamageswaran ,  Juan R. Loaiza ,  Umesh Panchaksharaiah ,  Alexander Tsukerman ,  Timothy L. Shetler ,  Bharat C. V. Baddepudi ,  Boris Erlikhman ,  Kiran B. Goyal ,  Nilesh Choudhury ,  Susy Fan ,  Poojan Kumar ,  Selcuk Aya ,  Sue-Kyoung Lee

发明人： Kothanda Umamageswaran ,  Juan R. Loaiza ,  Umesh Panchaksharaiah ,  Alexander Tsukerman ,  Timothy L. Shetler ,  Bharat C. V. Baddepudi ,  Boris Erlikhman ,  Kiran B. Goyal ,  Nilesh Choudhury ,  Susy Fan ,  Poojan Kumar ,  Selcuk Aya ,  Sue-Kyoung Lee

IPC分类号： G06F12/08 ,  G06F12/084 ,  G06F16/2455 ,  G06F12/0888 ,  G06F12/0811 ,  G06F12/0866

摘要： Techniques are provided for using an intermediate cache to provide some of the items involved in a scan operation, while other items involved in the scan operation are provided from primary storage. Techniques are also provided for determining whether to service an I/O request for an item with a copy of the item that resides in the intermediate cache based on factors such as a) an identity of the user for whom the I/O request was submitted, b) an identity of a service that submitted the I/O request, c) an indication of a consumer group to which the I/O request maps, d) whether the I/O request is associated with an offloaded filter provided by the database server to the storage system, or e) whether the intermediate cache is overloaded. Techniques are also provided for determining whether to store items in an intermediate cache in response to the items being retrieved, based on logical characteristics associated with the requests that retrieve the items.

公开(公告)号：US08868831B2

公开(公告)日：2014-10-21

申请号：US12631985

申请日：2009-12-07

申请人： Kiran Badrinarain Goyal ,  Neil J. S. Macnaughton ,  Eugene Ho ,  Adam Y. Lee ,  Vipin Gokhale ,  Wei-Ming Hu ,  Juan R. Loaiza ,  Kothanda Umamageswaran ,  Bharat C. V. Baddepudi ,  Boris Erlikhman ,  Alexander Tsukerman ,  Selcuk Aya ,  Roger Hansen ,  Adrian Ng

发明人： Kiran Badrinarain Goyal ,  Neil J. S. Macnaughton ,  Eugene Ho ,  Adam Y. Lee ,  Vipin Gokhale ,  Wei-Ming Hu ,  Juan R. Loaiza ,  Kothanda Umamageswaran ,  Bharat C. V. Baddepudi ,  Boris Erlikhman ,  Alexander Tsukerman ,  Selcuk Aya ,  Roger Hansen ,  Adrian Ng

IPC分类号： G06F12/08 ,  G06F17/30

CPC分类号： G06F12/0866 ,  G06F12/084 ,  G06F12/0888 ,  G06F12/0897 ,  G06F17/30312 ,  G06F17/3048 ,  G06F2212/283 ,  G06F2212/311 ,  G06F2212/312 ,  G06F2212/465

摘要： Techniques are provided for using an intermediate cache between the shared cache of a database server and the non-volatile storage of a storage system. The intermediate cache may be local to the machine upon which the database server is executing, or may be implemented within the storage system. In one embodiment, the database system includes both a DB server-side intermediate cache, and a storage-side intermediate cache. The caching policies used to populate the intermediate cache are intelligent, taking into account factors that may include which database object an item belongs to, the item type of the item, a characteristic of the item; or the database operation in which the item is involved.

摘要翻译： 提供了在数据库服务器的共享缓存和存储系统的非易失性存储之间使用中间缓存的技术。 中间缓存可以是数据库服务器在其上执行的机器的本地，或者可以在存储系统内实现。 在一个实施例中，数据库系统包括DB服务器侧中间缓存和存储侧中间缓存。 用于填充中间缓存的缓存策略是智能的，考虑到可能包括项目属于哪个数据库对象的因素，项目的项目类型，项目的特征; 或涉及项目的数据库操作。