公开(公告)号：US08892905B2

公开(公告)日：2014-11-18

申请号：US11726428

申请日：2007-03-21

申请人： Adam Y. Lee ,  Varun Malhotra ,  Daniel ManHung Wong ,  Tirthankar Lahiri ,  Kiran Goyal ,  Juan R. Loaiza ,  Paul Youn

发明人： Adam Y. Lee ,  Varun Malhotra ,  Daniel ManHung Wong ,  Tirthankar Lahiri ,  Kiran Goyal ,  Juan R. Loaiza ,  Paul Youn

IPC分类号： G06Q30/02 ,  H04L9/08

CPC分类号： H04L9/0894

摘要： One embodiment of the present invention provides a system for performing selective encryption/decryption in a data storage system. During operation, the system receives a data block from a storage medium at an input/output layer, wherein the input/output layer serves as an interface between the storage medium and a buffer cache. Next, the system determines whether the data block is an encrypted data block. If not, the system stores the data block in the buffer cache. Otherwise, if the data block is an encrypted data block, the system retrieves a storage-key, wherein the storage-key is associated with a subset of storage, which is associated with the encrypted data block. Using the storage-key, the system then decrypts the encrypted data block to produce a decrypted data block. Finally, the system stores the decrypted data block in the buffer cache, wherein the data block remains encrypted in the storage medium.

摘要翻译： 本发明的一个实施例提供一种用于在数据存储系统中执行选择性加密/解密的系统。 在操作期间，系统在输入/输出层从存储介质接收数据块，其中输入/输出层用作存储介质和缓冲器高速缓存之间的接口。 接下来，系统确定数据块是否是加密数据块。 如果没有，系统将数据块存储在缓冲区高速缓存中。 否则，如果数据块是加密数据块，则系统检索存储密钥，其中存储密钥与与加密数据块相关联的存储子集相关联。 使用存储密钥，系统然后解密加密的数据块以产生解密的数据块。 最后，系统将解密的数据块存储在缓冲器高速缓存中，其中数据块在存储介质中保持加密。

公开(公告)号：US07991775B2

公开(公告)日：2011-08-02

申请号：US12244640

申请日：2008-10-02

申请人： Neil MacNaughton ,  Tirthankar Lahiri ,  Varun Malhotra

发明人： Neil MacNaughton ,  Tirthankar Lahiri ,  Varun Malhotra

IPC分类号： G06F17/30

CPC分类号： G06F17/30362 ,  Y10S707/99933 ,  Y10S707/99935

摘要： Described herein are techniques for generating a global checkpoint system change number and computing a snapshot query using the global checkpoint system change number without a need to acquire global locks. In many cases, the need to acquire global locks is eliminated, thereby saving the overhead attendant to processing global locks.

摘要翻译： 这里描述了用于生成全局检查点系统改变号码并使用全局检查点系统改变号码计算快照查询而不需要获取全局锁的技术。 在许多情况下，消除了获取全局锁的需求，从而节省了处理全局锁的开销。

公开(公告)号：US20110072217A1

公开(公告)日：2011-03-24

申请号：US12562928

申请日：2009-09-18

申请人： Chi Hoang ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang ,  John Miller ,  Dilys Thomas ,  Nagender Bandi ,  Susan Cheng

发明人： Chi Hoang ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang ,  John Miller ,  Dilys Thomas ,  Nagender Bandi ,  Susan Cheng

IPC分类号： G06F12/08 ,  G06F12/00

CPC分类号： G06F17/30312 ,  G06F12/084

摘要： A plurality of mid-tier databases form a single, consistent cache grid for data in a one or more backend data sources, such as a database system. The mid-tier databases may be standard relational databases. Cache agents at each mid-tier database swap in data from the backend database as needed. Consistency in the cache grid is maintained by ownership locks. Cache agents prevent database operations that will modify cached data in a mid-tier database unless and until ownership of the cached data can be acquired for the mid-tier database. Cache groups define what backend data may be cached, as well as a general structure in which the backend data is to be cached. Metadata for cache groups is shared to ensure that data is cached in the same form throughout the entire grid. Ownership of cached data can then be tracked through a mapping of cached instances of data to particular mid-tier databases.

摘要翻译： 多个中间层数据库形成用于一个或多个后端数据源（例如数据库系统）中的数据的单一，一致的高速缓存网格。 中间层数据库可以是标准关系数据库。 每个中间层数据库的缓存代理根据需要从后端数据库交换数据。 高速缓存网格中的一致性由所有权锁定维护。 高速缓存代理阻止数据库操作，将修改中间层数据库中的缓存数据，除非可以为中间层数据库获取缓存数据的所有权。 缓存组定义可以缓存哪些后端数据，以及要缓存后端数据的一般结构。 共享缓存组的元数据，以确保数据在整个网格中以相同的格式进行缓存。 然后可以通过将缓存的数据实例映射到特定中间层数据库来跟踪缓存数据的所有权。

公开(公告)号：US07467279B2

公开(公告)日：2008-12-16

申请号：US11395613

申请日：2006-03-30

申请人： Tirthankar Lahiri ,  Bharat C V Baddepudi ,  Poojan Kumar

发明人： Tirthankar Lahiri ,  Bharat C V Baddepudi ,  Poojan Kumar

IPC分类号： G06F12/06

CPC分类号： G06F17/3048

摘要： A method for starting up a database system, comprising allocating memory spaces for three buffers; initializing two of the buffers; partially initializing the third buffer where the third buffer is larger than the other two; instructing the memory manager to initialize the remainder of the third buffer in the background process; performing recovery operations; and opening the database system for use. The database is operated in an open phase while the remainder of the third buffer is initialized in the background and ran in parallel to the recovery operation that may extend beyond the completion of opening the database. Thus opening the database prior to completion of full initialization and initializing the third buffer in the background improves the startup time of the database which becomes significant when the size of the third buffer is very large (e.g., 500 GB+).

摘要翻译： 一种用于启动数据库系统的方法，包括为三个缓冲器分配存储器空间; 初始化两个缓冲区; 部分地初始化第三缓冲器，其中第三缓冲器大于其他缓冲器; 指示存储器管理器在后台进程中初始化第三缓冲器的剩余部分; 执行恢复操作; 并打开数据库系统使用。 数据库处于开放阶段，而第三个缓冲区的其余部分在后台进行初始化，并且与恢复操作并行运行，该恢复操作可能超出打开数据库的完成时间。 因此，在完成初始化并在后台初始化第三缓冲区之前打开数据库改善了当第三缓冲器的大小非常大（例如，500GB +））时数据库的启动时间变得显着。

公开(公告)号：US07376682B2

公开(公告)日：2008-05-20

申请号：US10775513

申请日：2004-02-09

申请人： Mark Ramacher ,  Graham S. Wood ,  Juan Loaiza ,  Tirthankar Lahiri ,  Karl Dias

发明人： Mark Ramacher ,  Graham S. Wood ,  Juan Loaiza ,  Tirthankar Lahiri ,  Karl Dias

IPC分类号： G06F17/30

CPC分类号： G06F17/30008 ,  Y10S707/99957

摘要： Quantifying the impact of wasteful operations on a database system is provided. One or more operations that are determined to be wasteful are received. The impact of the wasteful operations on performance in a database may then be quantified. The database is monitored to determine when a wasteful operation is being performed. When a wasteful operation is detected, a time value is recorded of the time spent on processing the wasteful operation. The time value is stored and used to quantify an impact of a performance problem in a database. The time value may be stored and associated with other time values that are recorded for the same wasteful operation. Thus, the impact of wasteful operations that are performed and processed in a database may be determined.

摘要翻译： 提供了浪费操作对数据库系统的影响。 接收到被确定为浪费的一个或多个操作。 然后可以量化浪费操作对数据库中的性能的影响。 监视数据库以确定何时执行浪费的操作。 当检测到浪费的操作时，记录处理浪费操作花费的时间的时间值。 时间值被存储并用于量化数据库中性能问题的影响。 时间值可以被存储并且与为相同的浪费操作记录的其他时间值相关联。 因此，可以确定在数据库中执行和处理的浪费操作的影响。

公开(公告)号：US20140280373A1

公开(公告)日：2014-09-18

申请号：US13842843

申请日：2013-03-15

申请人： John Raitto ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang

发明人： John Raitto ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/30292 ,  G06F17/30442 ,  G06F17/30463 ,  G06F17/30575

摘要： A method, apparatus, and system for automatically determining an optimal database subsection is provided. A database subsection is selected to optimize certain benefits when the database subsection is translated, transferred, and cached on an alternative database system, which may utilize a different technology or database engine that provides certain performance benefits compared to the original database system. Algorithms such as multi-path greedy selection and/or dynamic programming may provide optimal or near-optimal results. A host for the alternative database server may be shared with or otherwise located in close physical proximity to improve latency for a database application or client layer. Once the database subsection analysis is completed, a report may be generated and presented to the user, and an implementation script may also be created to automatically configure a client host to function as a cache or replacement system according various cache size configurations described in the report.

摘要翻译： 提供了一种用于自动确定最佳数据库子部分的方法，装置和系统。 当数据库部分被翻译，传输和缓存在替代数据库系统上时，选择数据库子部分来优化某些优点，替代数据库系统可以利用与原始数据库系统相比提供某些性能优势的不同技术或数据库引擎。 诸如多路径贪心选择和/或动态规划的算法可以提供最佳或接近最佳的结果。 替代数据库服务器的主机可以与物理接近处于共享状态或以其他方式设置，以改善数据库应用程序或客户端层的延迟。 一旦完成了数据库子部分分析，就可以生成报告并呈现给用户，还可以创建实现脚本，以便根据报告中描述的各种缓存大小配置自动配置客户端主机作为缓存或替换系统。 。

公开(公告)号：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.

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

公开(公告)号：US20080232592A1

公开(公告)日：2008-09-25

申请号：US11726428

申请日：2007-03-21

申请人： Adam Y. Lee ,  Varun Malhotra ,  Daniel ManHung Wong ,  Tirthankar Lahiri ,  Kiran Goyal ,  Juan R. Loaiza ,  Paul Youn

发明人： Adam Y. Lee ,  Varun Malhotra ,  Daniel ManHung Wong ,  Tirthankar Lahiri ,  Kiran Goyal ,  Juan R. Loaiza ,  Paul Youn

IPC分类号： H04L9/00

CPC分类号： H04L9/0894

摘要： One embodiment of the present invention provides a system for performing selective encryption/decryption in a data storage system. During operation, the system receives a data block from a storage medium at an input/output layer, wherein the input/output layer serves as an interface between the storage medium and a buffer cache. Next, the system determines whether the data block is an encrypted data block. If not, the system stores the data block in the buffer cache. Otherwise, if the data block is an encrypted data block, the system retrieves a storage-key, wherein the storage-key is associated with a subset of storage, which is associated with the encrypted data block. Using the storage-key, the system then decrypts the encrypted data block to produce a decrypted data block. Finally, the system stores the decrypted data block in the buffer cache, wherein the data block remains encrypted in the storage medium.

摘要翻译： 本发明的一个实施例提供一种用于在数据存储系统中执行选择性加密/解密的系统。 在操作期间，系统在输入/输出层从存储介质接收数据块，其中输入/输出层用作存储介质和缓冲器高速缓存之间的接口。 接下来，系统确定数据块是否是加密数据块。 如果没有，系统将数据块存储在缓冲区高速缓存中。 否则，如果数据块是加密数据块，则系统检索存储密钥，其中存储密钥与与加密数据块相关联的存储子集相关联。 使用存储密钥，系统然后解密加密的数据块以产生解密的数据块。 最后，系统将解密的数据块存储在缓冲器高速缓存中，其中数据块在存储介质中保持加密。

公开(公告)号：US20080098041A1

公开(公告)日：2008-04-24

申请号：US11876679

申请日：2007-10-22

申请人： Lakshminarayanan CHIDAMBARAN ,  Mehul BASTAWALA ,  Srinath KRISHNASWAMY ,  Tirthankar LAHIRI ,  Juan LOAIZA ,  Bipul SINHA ,  Srinivas VEMURI

发明人： Lakshminarayanan CHIDAMBARAN ,  Mehul BASTAWALA ,  Srinath KRISHNASWAMY ,  Tirthankar LAHIRI ,  Juan LOAIZA ,  Bipul SINHA ,  Srinivas VEMURI

IPC分类号： G06F17/30

CPC分类号： G06F17/3056

摘要： A method, system, and computer program product is disclosed for interacting with a client supported by a client-side cache. Embodiments of a method, a system, and a computer program product are disclosed that retrieve a first snapshot, indicating a state of the database after a last database request by the client, associated with the client, determine any number of invalid cached results for the client based on the first snapshot, and transmit the any number of invalid cached results and a second snapshot, an update for the first snapshot.

摘要翻译： 公开了一种方法，系统和计算机程序产品，用于与由客户端缓存支持的客户端进行交互。 公开了一种方法，系统和计算机程序产品的实施例，其检索在与客户端相关联的客户端的最后数据库请求之后指示数据库的状态的第一快照，以确定用于该客户端的任何数量的无效高速缓存结果 客户端基于第一个快照，并传送任何数量的无效缓存结果和第二个快照，第一个快照的更新。

公开(公告)号：US10296629B2

公开(公告)日：2019-05-21

申请号：US11876679

申请日：2007-10-22

申请人： Lakshminarayanan Chidambaran ,  Mehul Dilip Bastawala ,  Srinath Krishnaswamy ,  Tirthankar Lahiri ,  Juan R. Loaiza ,  Bipul Sinha ,  Srinivas S. Vemuri

发明人： Lakshminarayanan Chidambaran ,  Mehul Dilip Bastawala ,  Srinath Krishnaswamy ,  Tirthankar Lahiri ,  Juan R. Loaiza ,  Bipul Sinha ,  Srinivas S. Vemuri

IPC分类号： G06F7/00 ,  G06F17/30 ,  G06F17/00

摘要： A method, system, and computer program product is disclosed for interacting with a client supported by a client-side cache. Embodiments of a method, a system, and a computer program product are disclosed that retrieve a first snapshot, indicating a state of the database after a last database request by the client, associated with the client, determine any number of invalid cached results for the client based on the first snapshot, and transmit the any number of invalid cached results and a second snapshot, an update for the first snapshot.