会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 1. 发明授权
    • Reorganization of data under continuous workload
    • 在连续工作量下重组数据
    • US09009112B2
    • 2015-04-14
    • US12723696
    • 2010-03-15
    • Bruno H. M. DenuitTomas Talius
    • Bruno H. M. DenuitTomas Talius
    • G06F17/30
    • G06F17/30584G06F17/30174
    • Architecture that provides the capability to automatically (e.g., dynamically) reorganize (repartition) an existing partition by dividing (splitting) or recombining (merging) logical databases. This reorganization can be performed to logical databases belonging to the same customer, and based on the partitioning of the tables in these databases. This can include not only splitting secondary replicas of a partition or merging secondary replicas of the partition, but also splitting off secondary replicas of the partition to create a new partition and merging two partitions into one partition. Moreover, these operations can occur while the logical databases are accepting workload (online).
    • 提供通过划分(分割)或重组(合并)逻辑数据库来自动(例如,动态地)重新组织(重新分配)现有分区的能力的架构。 可以对属于同一客户的逻辑数据库执行此重组,并且基于这些数据库中的表的分区。 这不仅可以分割分区的次要副本或合并分区的副副本,还可以分割分区的辅助副本,以创建新分区,并将两个分区合并成一个分区。 而且,当逻辑数据库接受工作负载(在线)时,可能会发生这些操作。
    • 7. 发明申请
    • DATABASE POINT-IN-TIME RESTORE AND AS-OF QUERY
    • DATABASE POINT-IN-TIME RESTORE和AS-OF QUERY
    • US20130212068A1
    • 2013-08-15
    • US13370125
    • 2012-02-09
    • Tomas TaliusRobin Dhananjay DhamankarHanumantha R. Kodavalla
    • Tomas TaliusRobin Dhananjay DhamankarHanumantha R. Kodavalla
    • G06F7/00
    • G06F17/30144G06F17/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顺序扫描事务日志,并撤消所有页面修改。 撤消反转重新分配的页面,表截断和/或表删除,以及模式,元数据值和/或系统表的页面级修改。 使用从稀疏页面文件中的页面处理一个查询。 如果稀疏页面文件尚未包含响应页面,则会创建它们并将其添加到其中。