Invention Grant
US08346714B1 Transactiontime and validtime timestamping in an enterprise active data warehouse
有权
企业活动数据仓库中的交易时间和有效时间戳
- Patent Title: Transactiontime and validtime timestamping in an enterprise active data warehouse
- Patent Title (中): 企业活动数据仓库中的交易时间和有效时间戳
-
Application No.: US12640103Application Date: 2009-12-17
-
Publication No.: US08346714B1Publication Date: 2013-01-01
- Inventor: Bhashyam Ramesh , Donald Pederson
- Applicant: Bhashyam Ramesh , Donald Pederson
- Applicant Address: US OH Dayton
- Assignee: Teradota US, Inc.
- Current Assignee: Teradota US, Inc.
- Current Assignee Address: US OH Dayton
- Agent Howard Speight
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

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