专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US10756759B2 Column domain dictionary compression 有权
公开(公告)号：US10756759B2
公开(公告)日：2020-08-25
申请号：US13224327
申请日：2011-09-02
申请人： Tirthankar Lahiri , Chi-Kim Hoang , Dina Thomas , Kirk Meredith Edson , Subhradyuti Sarkar , Mark McAuliffe , Marie-Anne Neimat , Chih-Ping Wang
发明人： Tirthankar Lahiri , Chi-Kim Hoang , Dina Thomas , Kirk Meredith Edson , Subhradyuti Sarkar , Mark McAuliffe , Marie-Anne Neimat , Chih-Ping Wang
IPC分类号： H03M7/42 , H03M7/30 , G06F16/22
摘要： In column domain dictionary compression, column values in one or more columns are tokenized by a single dictionary. The domain of the dictionary is the entire set of columns. A dictionary may not only map a token to a tokenized value, but also to a count (“token count”) of the number of occurrences of the token and corresponding tokenized value in the dictionary's domain. Such information may be used to compute queries on the base table.

2. 发明授权

US09697253B2 Consistent client-side cache 有权
公开(公告)号：US09697253B2
公开(公告)日：2017-07-04
申请号：US11875782
申请日：2007-10-19
申请人： 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分类号： G06F17/30
CPC分类号： G06F17/3048
摘要： A method, system, and computer program product is disclosed for caching results in a client-side cache. Embodiments of a method, a system, and a computer program product are disclosed that associate a first snapshot of a database with a client that indicates a state of the database after a last database request by the client, and indicate any number of invalid cached results in the client cache for the client based upon the first snapshot. In some embodiments, the method further includes receiving a second snapshot that indicates a state of the database upon receipt of a database server request by the client, and updating the first snapshot with the second snapshot.

3. 发明授权

US08401994B2 Distributed consistent grid of in-memory database caches 有权
标题翻译：分布式一致的内存数据库缓存网格
公开(公告)号：US08401994B2
公开(公告)日：2013-03-19
申请号：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分类号： G06F17/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.
摘要翻译：多个中间层数据库形成用于一个或多个后端数据源（例如数据库系统）中的数据的单一，一致的高速缓存网格。中间层数据库可以是标准关系数据库。每个中间层数据库的缓存代理根据需要从后端数据库交换数据。高速缓存网格中的一致性由所有权锁定维护。高速缓存代理阻止数据库操作，将修改中间层数据库中的缓存数据，除非可以为中间层数据库获取缓存数据的所有权。缓存组定义可以缓存哪些后端数据，以及要缓存后端数据的一般结构。共享缓存组的元数据，以确保数据在整个网格中以相同的格式缓存。然后可以通过将缓存的数据实例映射到特定中间层数据库来跟踪缓存数据的所有权。

4. 发明授权

US07734580B2 Readable physical storage replica and standby database system 有权
标题翻译：可读物理存储副本和备用数据库系统
公开(公告)号：US07734580B2
公开(公告)日：2010-06-08
申请号：US11818975
申请日：2007-01-29
申请人： Tirthankar Lahiri , Kiran Goyal , Jia Shi , Wei-Ming Hu , Neil MacNaughton , Jaebock Lee , Bharat Baddepudi , Yunrui Li , J. William Lee , Vipin Gokhale , Mark Dilman , Niloy Mukherjee , Vinay Srihari , Kumar Rajamani , Hochak Hung
发明人： Tirthankar Lahiri , Kiran Goyal , Jia Shi , Wei-Ming Hu , Neil MacNaughton , Jaebock Lee , Bharat Baddepudi , Yunrui Li , J. William Lee , Vipin Gokhale , Mark Dilman , Niloy Mukherjee , Vinay Srihari , Kumar Rajamani , Hochak Hung
IPC分类号： G06F17/30
CPC分类号： G06F11/2097 , G06F11/2035 , G06F11/2048 , G06F12/0815
摘要： A standby database system or another replica data system replicates changes, made to data blocks at a source database system or another primary data copy, to replicas of the data blocks at the standby database system or other replica. While replicating the changes to the data blocks thereof, the standby database system (or other replica) receives queries (or reads) issued thereto and computes the queries based on data read from the data blocks thereof.
摘要翻译：备用数据库系统或其他副本数据系统将对源数据库系统或其他主数据副本上的数据块进行的更改复制到备用数据库系统或其他副本上的数据块的副本。在对其数据块进行复制的同时，备用数据库系统（或其他副本）接收对其发出的查询（或读取），并根据从其数据块读取的数据来计算查询。

5. 发明申请

US20080235291A1 Readable physical storage replica and standby database system 有权
标题翻译：可读物理存储副本和备用数据库系统
公开(公告)号：US20080235291A1
公开(公告)日：2008-09-25
申请号：US11818975
申请日：2007-01-29
申请人： Tirthankar Lahiri , Kiran Goyal , Jia Shi , Wei-Ming Hu , Neil MacNaughton , Jaebock Lee , Bharat Baddepudi , Yunrui Li , J. William Lee , Vipin Gokhale , Mark Dilman , Niloy Mukherjee , Vinay Srihari , Kumar Rajamani , Hochak Hung
发明人： Tirthankar Lahiri , Kiran Goyal , Jia Shi , Wei-Ming Hu , Neil MacNaughton , Jaebock Lee , Bharat Baddepudi , Yunrui Li , J. William Lee , Vipin Gokhale , Mark Dilman , Niloy Mukherjee , Vinay Srihari , Kumar Rajamani , Hochak Hung
IPC分类号： G06F17/30
CPC分类号： G06F11/2097 , G06F11/2035 , G06F11/2048 , G06F12/0815
摘要： A standby database system or another replica data system replicates changes, made to data blocks at a source database system or another primary data copy, to replicas of the data blocks at the standby database system or other replica. While replicating the changes to the data blocks thereof, the standby database system (or other replica) receives queries (or reads) issued thereto and computes the queries based on data read from the data blocks thereof.
摘要翻译：备用数据库系统或其他副本数据系统将对源数据库系统或其他主数据副本上的数据块进行的更改复制到备用数据库系统或其他副本上的数据块的副本。在对其数据块进行复制的同时，备用数据库系统（或其他副本）接收对其发出的查询（或读取），并根据从其数据块读取的数据来计算查询。

6. 发明申请

US20080098173A1 CONSISTENT CLIENT-SIDE CACHE 有权
标题翻译：一致的客户端缓存
公开(公告)号：US20080098173A1
公开(公告)日：2008-04-24
申请号：US11875782
申请日：2007-10-19
申请人： 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分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/3048
摘要： A method, system, and computer program product is disclosed for caching results in a client-side cache. Embodiments of a method, a system, and a computer program product are disclosed that associate a first snapshot of a database with a client that indicates a state of the database after a last database request by the client, and indicate any number of invalid cached results in the client cache for the client based upon the first snapshot. In some embodiments, the method further includes receiving a second snapshot that indicates a state of the database upon receipt of a database server request by the client, and updating the first snapshot with the second snapshot.
摘要翻译：公开了用于在客户端缓存中缓存结果的方法，系统和计算机程序产品。公开了一种方法，系统和计算机程序产品的实施例，其将数据库的第一快照与客户端相关联，客户端在客户端的最后一个数据库请求之后指示数据库的状态，并指示任何数量的无效缓存结果在基于第一个快照的客户端缓存中。在一些实施例中，该方法还包括接收第二快照，其指示在客户端收到数据库服务器请求时指示数据库的状态，以及使用第二快照更新第一快照。

7. 发明申请

US20080098169A1 Cost based analysis of direct I/O access 有权
标题翻译：直接I / O访问的基于成本的分析
公开(公告)号：US20080098169A1
公开(公告)日：2008-04-24
申请号：US11584255
申请日：2006-10-20
申请人： Sanjay Kaluskar , Varun Malhotra , Tirthankar Lahiri , Juan Loaiza , Sumanta Chatterjee , Dmitry Potapov , Margaret Susairaj , Hakan Jakobsson
发明人： Sanjay Kaluskar , Varun Malhotra , Tirthankar Lahiri , Juan Loaiza , Sumanta Chatterjee , Dmitry Potapov , Margaret Susairaj , Hakan Jakobsson
IPC分类号： G06F12/00
CPC分类号： G06F12/0866 , G06F17/30306
摘要： A method, system, and computer program product forcost based analysis for data access in a database management system. In one approach, the method, system, and computer program productperforms identifying data to access, determining a first cost for direct I/O storage access and a second cost for cache access, performing a comparison between the first cost and the second cost, and accessing a first portion of identified data based upon the comparison.
摘要翻译：一种用于数据库管理系统中数据访问的方法，系统和计算机程序产品forcost based analysis。在一种方法中，方法，系统和计算机程序产品实现识别要访问的数据，确定用于直接I / O存储访问的第一成本和用于高速缓存访问的第二成本，执行第一成本和第二成本之间的比较，以及基于比较来访问所识别的数据的第一部分。

8. 发明申请

US20060224594A1 Methods and systems for identifying highly contended blocks in a database 审中-公开
标题翻译：用于识别数据库中高度竞争的块的方法和系统
公开(公告)号：US20060224594A1
公开(公告)日：2006-10-05
申请号：US11099272
申请日：2005-04-04
申请人： Kiran Goyal , Tudor Bosman , Tirthankar Lahiri
发明人： Kiran Goyal , Tudor Bosman , Tirthankar Lahiri
IPC分类号： G06F17/30
CPC分类号： G06F16/2308
摘要： A computer-implemented method of generating a list of K most frequently accessed ones of a plurality of data blocks in a database may include steps of selecting the number K; building the list of K blocks by storing an identification of and maintaining a running count for up to selected K ones of the data blocks by iteratively carrying out a single step for each of the plurality of data blocks, the single step being selected from an incrementing step to increment the count, a decrementing step to decrement the count, an adding step to add a data block to the list and to set a count of the added data block and a replacing step to replace an existing data block of the list with a new data block and to set a count of the new data block, and providing the list of K most frequently accessed blocks.
摘要翻译：在数据库中生成多个数据块中最频繁访问的K的列表的计算机实现的方法可以包括选择数字K的步骤; 通过对多个数据块中的每一个迭代地执行单个步骤，通过存储对于所选数据块中所选择的K个数据块的运行计数的识别和维持来建立K个块的列表，该单个步骤从增量逐步增加计数，减少计数的递减步骤，添加步骤，将数据块添加到列表中，并设置添加的数据块的计数，以及替换步骤，用一个替换步骤来替换该列表的现有数据块新数据块并设置新数据块的计数，并提供K个最常访问块的列表。

9. 发明申请

US20060143187A1 Integrating tablespaces with different block sizes 审中-公开
标题翻译：集成具有不同块大小的表空间
公开(公告)号：US20060143187A1
公开(公告)日：2006-06-29
申请号：US11347644
申请日：2006-02-02
申请人： Sreedhar Mukkamalla , Arvind Nithrakashyap , Tirthankar Lahiri , Alok Pareek , Juan Loaiza , J. Lee , Gary Ngai
发明人： Sreedhar Mukkamalla , Arvind Nithrakashyap , Tirthankar Lahiri , Alok Pareek , Juan Loaiza , J. Lee , Gary Ngai
IPC分类号： G06F17/30
CPC分类号： G06F16/283 , G06F16/00 , G06F16/9017 , Y10S707/99938 , Y10S707/99942 , Y10S707/99955
摘要： Provided herein is a mechanism that allows a given database system to access data blocks from another database system, where data blocks from the given database system and data blocks from the other database system have different sizes. According to an aspect of the present invention, a tablespace in the other database system contained the data blocks. The tablespace is detached from the other database system and integrated into the given database, which is capable of processing data stored in data blocks of different sizes.
摘要翻译：这里提供了允许给定数据库系统从另一个数据库系统访问数据块的机制，其中来自给定数据库系统的数据块和来自其他数据库系统的数据块具有不同的大小。根据本发明的一个方面，其他数据库系统中的表空间包含数据块。表空间与其他数据库系统分离，并集成到给定的数据库中，该数据库能够处理存储在不同大小的数据块中的数据。

10. 发明申请

US20050055672A1 Time model 有权
标题翻译：时间模型
公开(公告)号：US20050055672A1
公开(公告)日：2005-03-10
申请号：US10775513
申请日：2004-02-09
申请人： Mark Ramacher , Graham Wood , Juan Loaiza , Tirthankar Lahiri , Karl Dias
发明人： Mark Ramacher , Graham Wood , Juan Loaiza , Tirthankar Lahiri , Karl Dias
IPC分类号： G06F9/44
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.
摘要翻译：提供了浪费操作对数据库系统的影响。接收到被确定为浪费的一个或多个操作。然后可以量化浪费操作对数据库中的性能的影响。监视数据库以确定何时执行浪费的操作。当检测到浪费的操作时，记录处理浪费操作花费的时间的时间值。时间值被存储并用于量化数据库中性能问题的影响。时间值可以被存储并且与为相同的浪费操作记录的其他时间值相关联。因此，可以确定在数据库中执行和处理的浪费操作的影响。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式