会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 2. 发明授权
    • Transactiontime and validtime timestamping in an enterprise active data warehouse
    • 企业活动数据仓库中的交易时间和有效时间戳
    • US08346714B1
    • 2013-01-01
    • US12640103
    • 2009-12-17
    • Bhashyam RameshDonald Pederson
    • Bhashyam RameshDonald Pederson
    • G06F7/00G06F17/00
    • G06F17/30563G06F17/30345G06F17/30587G06F17/30592
    • A temporal table is present in an active data warehouse (“ADW”) on a massively parallel processing system (“MPP system”). The MPP system includes a plurality of units of parallelism. Each of the plurality of units of parallelism maintains its own moving system time separate from that of the other units of parallelism. A load-job for the ADW is accepted. The load-job includes a requested modification to an identified row. The identified row is stored in the temporal table on a first of the MPP system's units of parallelism. The requested modification is implemented on the identified row. The identified row is timestamped with the moving system time maintained by the first of the MPP system's units of parallelism at the time of the implementation of the modification.
    • 时间表存在于大规模并行处理系统(MPP系统)上的活动数据仓库(ADW)中。 MPP系统包括多个并行单元。 多个并行单元中的每一个将其自身的移动系统时间与其他并行单元的移动系统时间分开。 接受ADW的加载作业。 加载作业包括对所识别的行的请求的修改。 所识别的行存储在MPP系统的第一个并行单位的时间表中。 所请求的修改在识别的行上实现。 在实施修改时,识别的行是由MPP系统的第一个并行单元维护的移动系统时间的时间戳。
    • 5. 发明授权
    • Online incremental database dump
    • 在线增量数据库转储
    • US07849111B2
    • 2010-12-07
    • US11967711
    • 2007-12-31
    • Bill HuffmanDonald PedersonMay PedersonRichard Pogue
    • Bill HuffmanDonald PedersonMay PedersonRichard Pogue
    • G06F17/30
    • G06F17/30368
    • Various embodiments may include taking an initial dump of a database table and tracking changes to the database table, with regard to but outside of transactions, since a most recent full or partial dump has been taken. A partial dump, in such embodiments, may be taken since the most recent full or partial dump and used to create a data structure which may be used to update only those database table rows modified since a last full or partial dump. As a result, the dumps of a database table will include a single full dump and may include one or more partial dumps. These full and partial dumps may then be instantiated to create or update an instance of the database table. In some embodiments, dumps may be taken directly to a mirrored instance of a database table.
    • 由于采用了最近的全部或部分转储,各种实施方式可以包括对数据库表进行初始转储并且跟踪对数据库表的更改,但是在事务之外。 在这样的实施例中,可以采用部分转储,因为最近的完全或部分转储并且用于创建数据结构,该数据结构可用于仅更新自上次完全或部分转储以来修改的那些数据库表行。 因此,数据库表的转储将包含单个完整转储,并可能包含一个或多个部分转储。 然后可以将这些完整和部分转储实例化为创建或更新数据库表的实例。 在一些实施例中,可以将转储直接带到数据库表的镜像实例。
    • 8. 发明授权
    • Partitioned database system
    • 分区数据库系统
    • US07213025B2
    • 2007-05-01
    • US09981613
    • 2001-10-16
    • Paul L. SinclairDonald PedersonSteven Bart Cohen
    • Paul L. SinclairDonald PedersonSteven Bart Cohen
    • G06F7/00
    • G06F17/30339Y10S707/99942Y10S707/99945
    • Implementations of a partitioned database system and a method of using a database system are disclosed. One system implementation includes storage facilities. Each storage facility includes data from database table rows. The database table rows in each storage facility that correspond to a specific database table are logically ordered according to a row identifier (row ID). The row ID includes a first value that is based on one or more columns of the table. The row ID also includes a second value that is based on one or more columns of the table, which may be different from or the same as those on which the first value is based. The first value of the row ID is predominate in determining the order of the rows in the storage facilities. The second value determines the order of those rows with identical first values.
    • 公开了分区数据库系统的实现和使用数据库系统的方法。 一个系统实现包括存储设施。 每个存储设备都包括来自数据库表行的数据。 对应于特定数据库表的每个存储设施中的数据库表行根据行标识符(行ID)进行逻辑排序。 行ID包括基于该表的一列或多列的第一值。 行ID还包括基于表的一个或多个列的第二值,其可以与第一值所基于的那些不同或相同。 在确定存储设施中的行的顺序时,行ID的第一个值占主要地位。 第二个值确定具有相同的第一个值的那些行的顺序。
    • 10. 发明申请
    • ONLINE INCREMENTAL DATABASE DUMP
    • 在线增量数据库DUMP
    • US20090172051A1
    • 2009-07-02
    • US11967711
    • 2007-12-31
    • Bill HuffmanDonald PedersonMay PedersonRichard Pogue
    • Bill HuffmanDonald PedersonMay PedersonRichard Pogue
    • G06F17/30
    • G06F17/30368
    • Various embodiments may include taking an initial dump of a database table and tracking changes to the database table, with regard to but outside of transactions, since a most recent full or partial dump has been taken. A partial dump, in such embodiments, may be taken since the most recent full or partial dump and used to create a data structure which may be used to update only those database table rows modified since a last full or partial dump. As a result, the dumps of a database table will include a single full dump and may include one or more partial dumps. These full and partial dumps may then be instantiated to create or update an instance of the database table. In some embodiments, dumps may be taken directly to a mirrored instance of a database table.
    • 由于采用了最近的全部或部分转储,各种实施方式可以包括对数据库表进行初始转储并且跟踪对数据库表的更改,但是在事务之外。 在这样的实施例中,可以采用部分转储,因为最近的完全或部分转储并且用于创建数据结构,该数据结构可用于仅更新自上次完全或部分转储以来修改的那些数据库表行。 因此,数据库表的转储将包含单个完整转储,并可能包含一个或多个部分转储。 然后可以将这些完整和部分转储实例化为创建或更新数据库表的实例。 在一些实施例中,可以将转储直接带到数据库表的镜像实例。