发明授权
- 专利标题: Database system that provides for history-enabled tables
- 专利标题(中): 提供启用历史记录的表的数据库系统
-
申请号: US11291446申请日: 2005-12-01
-
公开(公告)号: US08156083B2公开(公告)日: 2012-04-10
- 发明人: Jayanta Banerjee , Robert Hanckel , Siva Ravada
- 申请人: Jayanta Banerjee , Robert Hanckel , Siva Ravada
- 申请人地址: US CA Redwood Shores
- 专利权人: Oracle International Corporation
- 当前专利权人: Oracle International Corporation
- 当前专利权人地址: US CA Redwood Shores
- 代理机构: Vista IP Law Group, LLP
- 主分类号: G07F17/30
- IPC分类号: G07F17/30
摘要:
Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The start time field's value in a row of the history-enabled table indicates when the contents of the row last changed. The rows of the history table are copies of rows of the history-enabled table that have been deleted or updated. The rows include end time fields whose values indicate when the row was updated or deleted. A history table's row thus indicates a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table.
公开/授权文献
- US20070130226A1 Database system that provides for history-enabled tables 公开/授权日:2007-06-07