Invention Grant
US08346714B1 Transactiontime and validtime timestamping in an enterprise active data warehouse 有权
企业活动数据仓库中的交易时间和有效时间戳

Transactiontime and validtime timestamping in an enterprise active data warehouse
Abstract:
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.
Information query
Patent Agency Ranking
0/0