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

1. 发明申请

US20120101997A1 DATABASE DATA RECOVERY SYSTEM AND METHOD 有权
标题翻译：数据库数据恢复系统和方法
公开(公告)号：US20120101997A1
公开(公告)日：2012-04-26
申请号：US13339077
申请日：2011-12-28
申请人： Michael J. Zwilling , Gregory A. Smith , Rajeev B. Rajan , Jakub Kulesza , Peter Byrne , Shashikant Brijmohan Khandelwal , Mark S. Wistrom
发明人： Michael J. Zwilling , Gregory A. Smith , Rajeev B. Rajan , Jakub Kulesza , Peter Byrne , Shashikant Brijmohan Khandelwal , Mark S. Wistrom
IPC分类号： G06F17/30
CPC分类号： G06F11/2097 , G06F11/1451 , G06F11/1469 , G06F11/1471 , G06F2201/80 , G06F2201/82 , G06F2201/84
摘要： The present invention relates to a system and method of data restoration, for instance, after the occurrence of a user error. In particular, snapshot database can be maintained that stores a copy of database data. The snapshot database does not have to store a complete copy of all data on a source database, but rather shares data that is common to both but not necessarily identical. If an error occurs on the primary database then the database can be reverted back to a point in time prior to the error by replacing source database files with snapshot files. Additionally, an undo component can be employed in conjunction with the snapshot to approach an error to a finer grained point in time. In brief, the present invention can restore a database much faster and simpler, while utilizing less space and resources than conventional data restoration technologies.
摘要翻译：本发明涉及数据恢复的系统和方法，例如在用户错误发生之后。特别地，可以维护存储数据库数据的副本的快照数据库。快照数据库不必在源数据库上存储所有数据的完整副本，而是共享两者共同但不一定相同的数据。如果主数据库发生错误，则数据库可以通过将源数据库文件替换为快照文件来恢复到错误之前的时间点。另外，一个撤销组件可以与快照一起使用，以将错误接近一个更精细的粒度点。简而言之，本发明可以比传统的数据恢复技术更少和更少地使用更少的空间和资源来更快速和简单地恢复数据库。

2. 发明授权

US07912819B2 Systems and methods for versioning based triggers 有权
标题翻译：基于版本控制的触发器的系统和方法
公开(公告)号：US07912819B2
公开(公告)日：2011-03-22
申请号：US11696166
申请日：2007-04-03
申请人： Gang He , Michael J. Zwilling
发明人： Gang He , Michael J. Zwilling
IPC分类号： G06F17/00 , G06F7/00
CPC分类号： G06F17/3051 , G06F17/30309 , Y10S707/99953 , Y10S707/99954 , Y10S707/99955
摘要： A system and/or methodology to track and organize database application data in response to a delete, insert or update procedure. More specifically, a system and/or methodology that employs a version-based retention and linkage approach with respect to triggering implementations is provided.
摘要翻译：响应于删除，插入或更新过程来跟踪和组织数据库应用程序数据的系统和/或方法。更具体地，提供了一种采用基于版本的保持和链接方法相对于触发实现的系统和/或方法。

3. 发明授权

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.
摘要翻译：公开了在检测到腐败事件时便于提供页面级数据库恢复功能的系统和方法。对数据库中的数据页的更新可以触发数据页快照的生成，并且可以维护存储与页面更新相关的信息的更新日志。随后的快照可以以预定的间隔生成并且可以触发日志段的截断和新的日志段的启动。在检测到页面损坏时，可以识别损坏的页面的最新的不破坏的快照，将其复制到数据库中的损坏页面的位置，并根据与非破坏快照关联的日志段进行修改，以使页面当前为的破坏事件，所有这些都可以执行以恢复数据库，而不必使数据库脱机。

4. 发明申请

US20090216768A1 DATABASE SANDBOX 有权
标题翻译：数据库SANDBOX
公开(公告)号：US20090216768A1
公开(公告)日：2009-08-27
申请号：US12035548
申请日：2008-02-22
申请人： Michael J. Zwilling , Raul Garcia , Ruslan Pavlovich Ovechkin
发明人： Michael J. Zwilling , Raul Garcia , Ruslan Pavlovich Ovechkin
IPC分类号： G06F17/30
CPC分类号： G06F17/30557
摘要： Systems and methods that qualify and/or restrict access of codes associated with a database to objects located outside thereof and in other databases—even though a person executing such code does in fact have permission to interact with the object that the code is attempting to access. A sandbox component can regulate access from one database to another database, by managing authenticator permission and/or trust permission levels. Hence, the set of privileges assigned to security execution context of an executable module (procedure, trigger, computed column) in an un-trusted database is restricted not to exceed a privilege set assigned to database owner.
摘要翻译：限定和/或限制与数据库相关联的代码访问位于其外部和其他数据库中的对象的系统和方法 - 即使执行此类代码的人实际上具有与代码尝试访问的对象交互的权限。沙箱组件可以通过管理身份验证者权限和/或信任权限级别来限制从一个数据库到另一个数据库的访问。因此，分配给不可信数据库中可执行模块（过程，触发器，计算列）的安全执行上下文的权限集被限制为不超过分配给数据库所有者的权限集。

5. 发明授权

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.
摘要翻译：为了提供更有效的持久存储设备，一个或多个长期存储介质与非易失性存储器一起被包括在内。在一个实施例中，非易失性存储器的一部分用作写入缓冲器和用于对长期存储介质的写入和读取的读高速缓存。提供了用于控制非易失性存储器作为写缓冲器和读缓存的使用的接口。此外，非易失性存储器的一部分用于为长期存储介质的特定扇区提供直接映射。关于永久存储设备的描述性数据被存储在非易失性存储器的另一部分中。

6. 发明授权

US07801866B1 Systems and methods for reading only durably committed data in a system that otherwise permits lazy commit of transactions 有权
标题翻译：在系统中只读取持久地提交的数据的系统和方法，否则允许延迟交易
公开(公告)号：US07801866B1
公开(公告)日：2010-09-21
申请号：US10782988
申请日：2004-02-20
申请人： Vishal Kathuria , Hanumantha Kodavalla , Michael J. Zwilling
发明人： Vishal Kathuria , Hanumantha Kodavalla , Michael J. Zwilling
IPC分类号： G06F17/30
CPC分类号： G06F17/30348 , G06F11/1471 , G06F17/30368 , G06F17/30377
摘要： A “lazy commit” allows database transactions to be committed faster by not waiting for log records of the transaction to be written to disk. When a system crash occurs during the commit process, transactions may be lost because the log data is not available to recreate the transaction. While lazy commits speed up processing, they also increase the potential for data inconsistency. This invention introduces the concept of “durable reads”—transactions that require isolation from lazy commit transactions and which must be guaranteed to read only durably committed data. When durable read transaction attempts to read data changed by a lazy commit transaction, the system ensures the lazy commit transaction's changes are first made durable.
摘要翻译： “lazy commit”允许通过不等待要写入磁盘的事务的日志记录来更快地提交数据库事务。在提交过程中发生系统崩溃时，事务可能会丢失，因为日志数据不可用于重新创建事务。虽然懒惰加速处理，但它们也增加了数据不一致的可能性。本发明介绍了需要与延迟提交事务隔离的“持久读取” - 交易的概念，必须保证只读持久地提交的数据。当持久读取事务尝试读取数据由延迟提交事务更改时，系统将确保延迟提交事务的更改首先变得持久。

7. 发明授权

US07702637B2 Systems and methods for fragment-based serialization 有权
标题翻译：基于片段的序列化的系统和方法
公开(公告)号：US07702637B2
公开(公告)日：2010-04-20
申请号：US11154496
申请日：2005-06-15
申请人： F. Soner Terek , Ajay Kalhan , Nagavamsi Ponnekanti , Srikumar Rangarajan , Michael J. Zwilling
发明人： F. Soner Terek , Ajay Kalhan , Nagavamsi Ponnekanti , Srikumar Rangarajan , Michael J. Zwilling
IPC分类号： G06F17/00 , G06F7/00
CPC分类号： G06F17/30988 , G06F9/4493
摘要： A method and system for fragment-based serialization places one or more object members in fragments. Fragments may comprise a header and a payload. A header can provide useful information about the fragment, such as an indication of fragment type and an indication of fragment length. A payload may comprise one or more members of an object. Primitive members may be stored in a Binary Fragment with a record format payload. LOB and FS members may be stored in fragments that have a Value Type field for setting forth additional properties of the fragment. Collections may be stored in a series of fragments, a first fragment to indicate a start of a collection, one or more second fragments to serialize collection elements, and a Terminator Fragment to indicate the end of a collection. Fragment-serialized objects minimize storage overhead while providing fast instantiation and low-cost location and updating.
摘要翻译：用于基于片段的序列化的方法和系统将一个或多个对象成员放置在片段中。片段可以包括报头和有效载荷。头可以提供关于片段的有用信息，例如片段类型的指示和片段长度的指示。有效载荷可以包括对象的一个或多个成员。原始成员可以存储在具有记录格式有效载荷的二进制片段中。 LOB和FS成员可以存储在具有值类型字段的片段中，用于设置片段的附加属性。集合可以存储在一系列片段中，第一片段指示集合的开始，用于序列化集合元素的一个或多个第二片段以及用于指示集合结束的终止符片段。片段序列化的对象可以最大限度地减少存储开销，同时提供快速实例化和低成本的位置和更新。

8. 发明授权

US07395278B2 Transaction consistent copy-on-write database 有权
标题翻译：事务一致的写时复制数据库
公开(公告)号：US07395278B2
公开(公告)日：2008-07-01
申请号：US10611774
申请日：2003-06-30
申请人： Michael J. Zwilling , Lewis S. Bruck , Sameet H. Agarwal , Kangrong Yan
发明人： Michael J. Zwilling , Lewis S. Bruck , Sameet H. Agarwal , Kangrong Yan
IPC分类号： G06F12/00 , G06F9/34
CPC分类号： G06F17/30595 , G06F11/1451 , G06F17/30492 , G06F17/30551 , G06F2201/80 , Y10S707/99952 , Y10S707/99953
摘要： A database view of a database is created which provides a transaction-consistent view of an existing database at a previous time. Each database view contains all the information needed to, along with the primary database, determine the contents of the primary database at a previous time. The database view consists of a side file corresponding to each data file in the primary database. The side files contain a copy of all data from the corresponding data file which has been changed since the database view was created. Sparse files may be used for the side files in order to conserve space. Page table data is kept in order to allow a quick determination as to whether the page from the primary database has been modified and the old version stored in the database view side file.
摘要翻译：创建数据库的数据库视图，该数据库视图在以前的时间提供了现有数据库的事务一致视图。每个数据库视图包含与主数据库一起确定先前时间的主数据库的内容所需的所有信息。数据库视图包含与主数据库中每个数据文件对应的副文件。副文件包含自创建数据库视图以来已更改的相应数据文件的所有数据的副本。为了节省空间，稀疏文件可能用于侧面文件。保留页表数据以便快速确定来自主数据库的页面是否已被修改，并且旧版本存储在数据库视图侧文件中。

9. 发明授权

US09405693B2 Non-volatile memory cache performance improvement 有权
标题翻译：非易失性内存缓存性能提升
公开(公告)号：US09405693B2
公开(公告)日：2016-08-02
申请号：US13555803
申请日：2012-07-23
申请人： Cenk Ergan , Clark D. Nicholson , Daniel 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 , Daniel 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/08 , G06F3/06
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. 发明授权

US08396831B2 Optimistic serializable snapshot isolation 有权
标题翻译：乐观的可序列化快照隔离
公开(公告)号：US08396831B2
公开(公告)日：2013-03-12
申请号：US12641961
申请日：2009-12-18
申请人： Per-Ake Larson , Cristian Diaconu , Michael J. Zwilling , Craig Steven Freedman
发明人： Per-Ake Larson , Cristian Diaconu , Michael J. Zwilling , Craig Steven Freedman
IPC分类号： G06F17/00
CPC分类号： G06F17/30353 , G06F9/466 , G06F17/30356
摘要： The subject disclosure relates to a concurrency control technique that ensures isolation among concurrently execution transactions optimistically in a multiversion database by applying two optional tests at the end of a read-write transaction: validating the visibility of the read set of the read-write transaction(s) and phantom detection by re-scanning and confirming no new version have appeared in the view. Depending on desired level of isolation, both, one or none of the test are applied. Each version of a data record in an applicable database can be assigned two timestamps indicating the lifetime the version. The value of a version timestamp, though assigned, may be conditional on a transaction committing.
摘要翻译：本公开涉及一种并发控制技术，其通过在读写事务结束时应用两个可选测试来确保在多版本数据库中乐观地同时执行事务之间的隔离：验证读写事务的读取集的可见性（ s）和幻影检测通过重新扫描和确认没有新版本出现在视图中。根据所需的隔离度，两者都应用一个或者没有一个测试。可以为适用的数据库中的每个版本的数据记录分配两个表示该版本的生命周期的时间戳。版本时间戳的值（尽管已分配）可能以事务提交为条件。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式