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

1. 发明申请

US20110145201A1 DATABASE MIRRORING 审中-公开
标题翻译：数据库镜像
公开(公告)号：US20110145201A1
公开(公告)日：2011-06-16
申请号：US12635763
申请日：2009-12-11
申请人： Marcel van der Holst , Robin D. Dhamankar , Hanumantha R. Kodavalla , Srikumar Rangarajan
发明人： Marcel van der Holst , Robin D. Dhamankar , Hanumantha R. Kodavalla , Srikumar Rangarajan
IPC分类号： G06F17/00 , G06F12/00
CPC分类号： G06F11/2074 , G06F11/2064 , G06F2201/80 , G06F2201/855
摘要： Methods, systems, and computer-readable media of database mirroring are disclosed. A particular method includes initiating a transaction that modifies one or more pages of a first database. Each page includes a structure modification operation (SMO) bit and initiating the transaction includes setting the SMO bit of each of the one or more pages to a first value. One or more first records are created at a transaction log of the first database. The transaction log is useable at a second database to mirror the transaction. Each first record indicates the setting of a SMO bit of a particular page to the first value. The database transaction is performed, and the SMO bit of each of the one or more pages is set to a second value. One or more second records are created at the transaction log, each second record indicating the setting of a SMO bit of a particular page to the second value. The method includes committing the transaction.
摘要翻译：披露了数据库镜像的方法，系统和计算机可读介质。一种特定方法包括启动修改第一数据库的一个或多个页面的事务。每个页面包括结构修改操作（SMO）位，并且启动事务包括将一个或多个页面中的每一个的SMO位设置为第一值。在第一个数据库的事务日志中创建一个或多个第一个记录。事务日志在第二个数据库中可用于镜像事务。每个第一个记录指示将特定页面的SMO位设置为第一个值。执行数据库事务，并且将一个或多个页面中的每一个的SMO位设置为第二值。在事务日志中创建一个或多个第二记录，每个第二记录指示将特定页的SMO位设置为第二值。该方法包括提交交易。

2. 发明授权

US07814057B2 Page recovery using volume snapshots and logs 有权
标题翻译：使用卷快照和日志进行页面恢复
公开(公告)号：US07814057B2
公开(公告)日：2010-10-12
申请号：US11099021
申请日：2005-04-05
申请人： Vishal Kathuria , Michael J Zwilling , Hanumantha R Kodavalla , Steven R Schmidt , Martin J Sleeman , Rajeev B Rajan , Artem A Oks
发明人： Vishal Kathuria , Michael J Zwilling , Hanumantha R Kodavalla , Steven R Schmidt , Martin J Sleeman , Rajeev B Rajan , Artem A Oks
IPC分类号： G06F7/00
CPC分类号： G06F11/1471 , G06F2201/80 , G06F2201/84
摘要： Systems and methods are disclosed that facilitate providing page-level database restore functionality upon detection of a corruption event. Updates to a data page in a database can trigger generation of a snapshot of the data page, and an update log can be maintained that stores information related to page updates. Subsequent snapshots can be generated at predetermined intervals and can trigger truncation of a log segment and initiation of a new log segment. Upon detection of page corruption, a most-recent uncorrupt snapshot of the corrupt page can be identified, copied to the location of the corrupt page in the database, and modified according to the log segment associated with the uncorrupt snapshot to make the page current as of the corrupting event, all of which can be performed to restore the database without having to take the database offline.
摘要翻译：公开了在检测到腐败事件时便于提供页面级数据库恢复功能的系统和方法。对数据库中的数据页的更新可以触发数据页快照的生成，并且可以维护存储与页面更新相关的信息的更新日志。随后的快照可以以预定的间隔生成并且可以触发日志段的截断和新的日志段的启动。在检测到页面损坏时，可以识别损坏的页面的最新的不破坏的快照，将其复制到数据库中的损坏页面的位置，并根据与非破坏快照关联的日志段进行修改，以使页面当前为的破坏事件，所有这些都可以执行以恢复数据库，而不必使数据库脱机。

3. 发明授权

US08527462B1 Database point-in-time restore and as-of query 有权
标题翻译：数据库时间点恢复和查询
公开(公告)号：US08527462B1
公开(公告)日：2013-09-03
申请号：US13370125
申请日：2012-02-09
申请人： Tomas Talius , Robin Dhananjay Dhamankar , Hanumantha R. Kodavalla
发明人： Tomas Talius , Robin Dhananjay Dhamankar , Hanumantha R. Kodavalla
IPC分类号： G06F17/30
CPC分类号： G06F17/30144 , G06F17/30088
摘要： A database is queried as of any wall-clock time within a retention period, via undo that uses database snapshots and a list of page level modifications. The snapshot is user-identified, automatically generated, or extracted from a backup. The list is maintained in a transaction log by persisting page content before a page is re-used, persisting deleted rows before they are moved, persisting compensation log record undo information, and/or logging a full page. To rewind an entire database, the undo scans the transaction log in reverse LSN order and undoes all page modifications. Undo reverses reallocated pages, table truncation, and/or table deletion, as well as page-level modifications of a schema, metadata values, and/or system tables. An as-of query is handled using as-of page(s) from a sparse page file. If the sparse page file does not already contain the responsive page(s), they are created and added to it.
摘要翻译：通过使用数据库快照和页面级修改列表的撤销，在保留期内的任何挂钟时间查询数据库。快照是用户标识，自动生成或从备份中提取的。该列表通过在重新使用页面之前持久页面内容来维护事务日志，在删除的行移动之前保留已删除的行，持久化补偿日志记录撤销信息和/或记录完整页面。要倒退整个数据库，undo以反向LSN顺序扫描事务日志，并撤消所有页面修改。撤消反转重新分配的页面，表截断和/或表删除，以及模式，元数据值和/或系统表的页面级修改。使用从稀疏页面文件中的页面处理一个查询。如果稀疏页面文件尚未包含响应页面，则会创建它们并将其添加到其中。

4. 发明申请

US20110219020A1 COLUMNAR STORAGE OF A DATABASE INDEX 有权
标题翻译：数据库索引的存储
公开(公告)号：US20110219020A1
公开(公告)日：2011-09-08
申请号：US12719015
申请日：2010-03-08
申请人： Artem A. Oks , Per-Ake Larson , Srikumar Rangarajan , Michael James Zwilling , Jose A. Blakeley , Hanumantha R. Kodavalla
发明人： Artem A. Oks , Per-Ake Larson , Srikumar Rangarajan , Michael James Zwilling , Jose A. Blakeley , Hanumantha R. Kodavalla
IPC分类号： G06F17/30
CPC分类号： G06F17/30315 , G06F17/30 , G06F17/30303 , G06F17/30589
摘要： Methods, systems, and computer-readable media of columnar storage of a database index are disclosed. A particular columnar index includes a column store that stores rows of the columnar index in a column-wise fashion and a delta store that stores rows of the columnar index in a row-wise fashion. The column store also includes an absence flag array. The absence flag array includes entries that indicate whether certain rows have been logically deleted from the column store.
摘要翻译：公开了数据库索引的柱状存储的方法，系统和计算机可读介质。特定的柱状索引包括列存储，其以列方式存储列索引的行，以及以行方式存储列索引的行的增量存储。列存储还包括不存在标志数组。缺席标志数组包括表示某些行是否已经从列存储中被逻辑删除的条目。

5. 发明授权

US07689607B2 Database page mirroring 有权
标题翻译：数据库页面镜像
公开(公告)号：US07689607B2
公开(公告)日：2010-03-30
申请号：US11107527
申请日：2005-04-15
申请人： Artem Oks , Hanumantha R Kodavalla , Martin J Sleeman
发明人： Artem Oks , Hanumantha R Kodavalla , Martin J Sleeman
IPC分类号： G06F7/00 , G06F17/30 , G06F12/00 , G06F13/00 , G06F13/28 , G06F11/00
CPC分类号： G06F11/1461 , G06F11/1456 , G06F11/1469 , G06F11/1471 , G06F2201/80
摘要： Systems and methods are presented that facilitate automatic database backup and restore for databases resident in personal computing devices, and which are transparent to a user, utilizing database page mirroring. Modifications to a data page in a data file can be validated and written to a backup, or mirror, database and then subsequently written to an original database after a predetermined time. An I/O latch on a mirrored data page can be limited to a duration of a single I/O write operation to facilitate sequential data page writing to each of the databases while mitigating potential for both databases to be written simultaneously, which can detrimentally affect data quality during a recovery operation.
摘要翻译：提出了系统和方法，其便于对驻留在个人计算设备中的数据库的自动数据库备份和恢复，并且对于用户来说是透明的，利用数据库页面镜像。可以对数据文件中的数据页进行修改，并将其写入备份或镜像数据库，然后在预定时间后将其写入原始数据库。镜像数据页面上的I / O锁存器可以限制在单个I / O写操作的持续时间，以便顺序数据页写入每个数据库，同时减轻两个数据库的同时写入的可能性，这可能不利地影响恢复操作期间的数据质量。

6. 发明授权

US08255645B2 Non-volatile memory cache performance improvement 有权
标题翻译：非易失性内存缓存性能提升
公开(公告)号：US08255645B2
公开(公告)日：2012-08-28
申请号：US13231088
申请日：2011-09-13
申请人： Cenk Ergan , Clark D. Nicholson , Dan Teodosiu , Dean L. DeWhitt , Emily Nicole Hill , Hanumantha R. Kodavalla , Michael J. Zwilling , John M. Parchem , Michael R. Fortin , Nathan Steven Obr , Rajeev Y. Nagar , Surenda Verma , Therron Powell , William J. Westerinen , Mark Joseph Zbikowski , Patrick L. Stemen
发明人： Cenk Ergan , Clark D. Nicholson , Dan Teodosiu , Dean L. DeWhitt , Emily Nicole Hill , Hanumantha R. Kodavalla , Michael J. Zwilling , John M. Parchem , Michael R. Fortin , Nathan Steven Obr , Rajeev Y. Nagar , Surenda Verma , Therron Powell , William J. Westerinen , Mark Joseph Zbikowski , Patrick L. Stemen
IPC分类号： G06F12/02
CPC分类号： G06F12/0866 , G06F3/061 , G06F3/0656 , G06F3/0679 , G06F12/08 , G06F2212/1016 , G06F2212/222 , G06F2212/281 , G06F2212/305 , G06F2212/312 , G06F2212/313 , Y02D10/13
摘要： In order to provide a more efficient persistent storage device, one or more long-term storage media are included along with a non-volatile memory. In one embodiment, one portion of the non-volatile memory is used as a write buffer and a read cache for writes and reads to the long-term storage media. Interfaces are provided for controlling the use of the non-volatile memory as a write buffer and a read cache. Additionally, a portion of the non-volatile memory is used to provide a direct mapping for specified sectors of the long-term storage media. Descriptive data regarding the persistent storage device is stored in another portion of the non-volatile memory.
摘要翻译：为了提供更有效的持久存储设备，一个或多个长期存储介质与非易失性存储器一起被包括在内。在一个实施例中，非易失性存储器的一部分用作写入缓冲器和用于对长期存储介质的写入和读取的读高速缓存。提供了用于控制非易失性存储器作为写缓冲器和读缓存的使用的接口。此外，非易失性存储器的一部分用于为长期存储介质的特定扇区提供直接映射。关于永久存储设备的描述性数据被存储在非易失性存储器的另一部分中。

7. 发明申请

US20120290785A1 Non-Volatile Memory Cache Performance Improvement 有权
公开(公告)号：US20120290785A1
公开(公告)日：2012-11-15
申请号：US13555803
申请日：2012-07-23
申请人： Cenk Ergan , Clark D. Nicholson , Dan Teodosiu , Dean L. DeWhitt , Emily Nicole Hill , Hanumantha R. Kodavalla , Michael J. Zwilling , John M. Parchem , Michael R. Fortin , Nathan Steven Obr , Rajeev Y. Nagar , Surenda Verma , Therron Powell , William J. Westerinen , Mark Joseph Zbikowski , Patrick L. Stemen
发明人： Cenk Ergan , Clark D. Nicholson , Dan Teodosiu , Dean L. DeWhitt , Emily Nicole Hill , Hanumantha R. Kodavalla , Michael J. Zwilling , John M. Parchem , Michael R. Fortin , Nathan Steven Obr , Rajeev Y. Nagar , Surenda Verma , Therron Powell , William J. Westerinen , Mark Joseph Zbikowski , Patrick L. Stemen
IPC分类号： G06F12/00 , G06F12/08
CPC分类号： G06F12/0866 , G06F3/061 , G06F3/0656 , G06F3/0679 , G06F12/08 , G06F2212/1016 , G06F2212/222 , G06F2212/281 , G06F2212/305 , G06F2212/312 , G06F2212/313 , Y02D10/13
摘要： In order to provide a more efficient persistent storage device, one or more long-term storage media are included along with a non-volatile memory. In one embodiment, one portion of the non-volatile memory is used as a write buffer and a read cache for writes and reads to the long-term storage media. Interfaces are provided for controlling the use of the non-volatile memory as a write buffer and a read cache. Additionally, a portion of the non-volatile memory is used to provide a direct mapping for specified sectors of the long-term storage media. Descriptive data regarding the persistent storage device is stored in another portion of the non-volatile memory.

8. 发明授权

US08176021B2 Optimized reverse key indexes 有权
标题翻译：优化的反向关键指标
公开(公告)号：US08176021B2
公开(公告)日：2012-05-08
申请号：US12131906
申请日：2008-06-02
申请人： Hanumantha R. Kodavalla , Pravin Mittal , Srikumar Rangarajan
发明人： Hanumantha R. Kodavalla , Pravin Mittal , Srikumar Rangarajan
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30327
摘要： Aspects of the subject matter described herein relate to optimized reverse key indexes. In aspects, a dispersion function disperses index values such that they are distributed across multiple pages of an index. The dispersion function utilizes a dispersion factor that indicates to what extent the index values are dispersed. Because the index values are dispersed, contention regarding inserts may be reduced or eliminated and other advantages realized.
摘要翻译：本文描述的主题的方面涉及优化的反向关键指标。在一些方面，色散函数分散索引值，使得它们分布在索引的多个页面上。色散函数利用分散因子，指示指数值在多大程度上分散。由于索引值分散，可能会减少或消除与插入有关的争用，从而实现了其他优点。

9. 发明授权

US07644239B2 Non-volatile memory cache performance improvement 有权
标题翻译：非易失性内存缓存性能提升
公开(公告)号：US07644239B2
公开(公告)日：2010-01-05
申请号：US10837986
申请日：2004-05-03
申请人： Cenk Ergan , Clark D. Nicholson , Dan Teodosiu , Dean L. DeWhitt , Emily Nicole Hill , Hanumantha R. Kodavalla , Michael J. Zwilling , John M. Parchem , Michael R. Fortin , Nathan Steven Obr , Rajeev Y. Nagar , Surenda Verma , Therron Powell , William J. Westerinen , Mark Joseph Zbikowski , Patrick L. Stemen
发明人： Cenk Ergan , Clark D. Nicholson , Dan Teodosiu , Dean L. DeWhitt , Emily Nicole Hill , Hanumantha R. Kodavalla , Michael J. Zwilling , John M. Parchem , Michael R. Fortin , Nathan Steven Obr , Rajeev Y. Nagar , Surenda Verma , Therron Powell , William J. Westerinen , Mark Joseph Zbikowski , Patrick L. Stemen
IPC分类号： G06F13/14
CPC分类号： G06F12/0866 , G06F3/061 , G06F3/0656 , G06F3/0679 , G06F12/08 , G06F2212/1016 , G06F2212/222 , G06F2212/281 , G06F2212/305 , G06F2212/312 , G06F2212/313 , Y02D10/13
摘要： In order to provide a more efficient persistent storage device, one or more long-term storage media are included along with a non-volatile memory. In one embodiment, one portion of the non-volatile memory is used as a write buffer and a read cache for writes and reads to the long-term storage media. Interfaces are provided for controlling the use of the non-volatile memory as a write buffer and a read cache. Additionally, a portion of the non-volatile memory is used to provide a direct mapping for specified sectors of the long-term storage media. Descriptive data regarding the persistent storage device is stored in another portion of the non-volatile memory.
摘要翻译：为了提供更有效的持久存储设备，一个或多个长期存储介质与非易失性存储器一起被包括在内。在一个实施例中，非易失性存储器的一部分用作写入缓冲器和用于对长期存储介质的写入和读取的读高速缓存。提供了用于控制非易失性存储器作为写缓冲器和读缓存的使用的接口。此外，非易失性存储器的一部分用于为长期存储介质的特定扇区提供直接映射。关于永久存储设备的描述性数据被存储在非易失性存储器的另一部分中。

10. 发明申请

US20090300013A1 Optimized Reverse Key Indexes 有权
标题翻译：优化的反向键索引
公开(公告)号：US20090300013A1
公开(公告)日：2009-12-03
申请号：US12131906
申请日：2008-06-02
申请人： Hanumantha R. Kodavalla , Pravin Mittal , Srikumar Rangarajan
发明人： Hanumantha R. Kodavalla , Pravin Mittal , Srikumar Rangarajan
IPC分类号： G06F17/30
CPC分类号： G06F17/30327
摘要： Aspects of the subject matter described herein relate to optimized reverse key indexes. In aspects, a dispersion function disperses index values such that they are distributed across multiple pages of an index. The dispersion function utilizes a dispersion factor that indicates to what extent the index values are dispersed. Because the index values are dispersed, contention regarding inserts may be reduced or eliminated and other advantages realized.
摘要翻译：本文描述的主题的方面涉及优化的反向关键指标。在一些方面，色散函数分散索引值，使得它们分布在索引的多个页面上。色散函数利用分散因子，指示指数值在多大程度上分散。由于索引值分散，可能会减少或消除与插入有关的争用，从而实现其他优点。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式