发明授权
- 专利标题： Asynchronous change capture for data warehousing
- 专利标题（中）： 用于数据仓库的异步更改捕获
-
申请号： US09863419申请日： 2001-05-24
-
公开(公告)号： US07657576B1公开(公告)日： 2010-02-02
- 发明人: William D. Norcott
- 申请人： William D. Norcott
- 申请人地址： US CA Redwood Shores
- 专利权人： Oracle International Corporation
- 当前专利权人： Oracle International Corporation
- 当前专利权人地址： US CA Redwood Shores
- 代理机构： Hanify & King, P.C.
- 主分类号： G06F12/00
- IPC分类号： G06F12/00 ; G06F17/30
摘要：
A method and software for change data capture are disclosed, in which change data is extracted from a recovery log and stored in a database object. The change data indicates what modification has been performed to a source object on the OLTP system. In some embodiments of the present invention, a database statement may be generated and executed to extract and load the change data, and the recovery log itself may be shipped from an OLTP system to a staging system.
信息查询
