公开(公告)号：US06999977B1

公开(公告)日：2006-02-14

申请号：US10140818

申请日：2002-05-09

申请人： William D. Norcott ,  Michael Brey ,  John Galanes ,  Paula Bingham ,  Raymond Guzman

发明人： William D. Norcott ,  Michael Brey ,  John Galanes ,  Paula Bingham ,  Raymond Guzman

IPC分类号： G06F17/30

CPC分类号： G06F17/30368 ,  G06F17/30563 ,  Y10S707/99943 ,  Y10S707/99954

摘要： A method of change data captured is disclosed, in which modifications made to on-line transaction processing (OLTP) tables (e.g. inserts, updates, and deletes) are maintained in a database object, referred to as a change table. The change data in the change table is then made available to analysis applications in a controlled manner, such as in accordance with a publication-subscription model.

摘要翻译： 公开了一种捕获的改变数据的方法，其中对在线事务处理（OLTP）表进行修改（例如，插入，更新和删除）被维护在被称为改变表的数据库对象中。 然后，更改表中的更改数据可以以受控的方式（例如根据发布预订模型）对分析应用程序可用。

公开(公告)号：US06334128B1

公开(公告)日：2001-12-25

申请号：US09224063

申请日：1998-12-28

申请人： William D. Norcott ,  Mohamed Ziauddin

发明人： William D. Norcott ,  Mohamed Ziauddin

IPC分类号： G06F700

CPC分类号： G06F17/30383 ,  Y10S707/99935 ,  Y10S707/99938 ,  Y10S707/99943

摘要： A method and apparatus for refreshing stale materialized views is provided. Prior to executing a query to refresh a materialized view from data in the base tables of the materialized view, the query is rewritten to refresh the materialized view from data in one or more other materialized views. To take advantage of the efficiency gained by refreshing a materialized view based on another materialized view, a refresh sequence is established based on the dependencies between materialized views in the database system. The dependencies indicate which materialized views can be refreshed from which other materialized views. When a materialized view can be refreshed based on any one of a number of eligible materialized views, the refresh sequence may additionally take into account the relative benefit associated with refreshing the materialized view with each of the eligible materialized views.

摘要翻译： 提供了一种用于刷新陈旧的物化视图的方法和装置。 在执行查询以从物化视图的基表中的数据中刷新物化视图之前，将重写该查询以从一个或多个其他物化视图中的数据刷新物化视图。 为了利用基于另一个物化视图刷新物化视图获得的效率，基于数据库系统中物化视图之间的依赖关系建立刷新序列。 依赖关系表明哪些物化视图可以从其他物化视图中刷新。 当物质化视图可以基于多个合格物化视图中的任何一个刷新时，刷新序列可另外考虑与每个合格实体化视图刷新物化视图相关联的相关利益。

公开(公告)号：US07657576B1

公开(公告)日：2010-02-02

申请号：US09863419

申请日：2001-05-24

申请人： William D. Norcott

发明人： William D. Norcott

IPC分类号： G06F12/00 ,  G06F17/30

CPC分类号： G06F17/30563 ,  Y10S707/99953

摘要： 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.

摘要翻译： 公开了一种用于改变数据捕获的方法和软件，其中从恢复日志中提取更改数据并将其存储在数据库对象中。 更改数据指示对OLTP系统上的源对象执行了哪些修改。 在本发明的一些实施例中，可以生成和执行数据库语句来提取和加载更改数据，并且恢复日志本身可以从OLTP系统发送到分段系统。

公开(公告)号：US06205451B1

公开(公告)日：2001-03-20

申请号：US09083643

申请日：1998-05-22

申请人： William D. Norcott ,  James Finnerty

发明人： William D. Norcott ,  James Finnerty

IPC分类号： G06F1730

CPC分类号： G06F17/30489 ,  G06F17/30457 ,  Y10S707/99942 ,  Y10S707/99953 ,  Y10S707/99955

摘要： A method and apparatus are provided for performing deferred incremental refresh of summary tables that are derived from two or more base tables. Incremental refresh is performed by assigning a hypothetical load sequence to the base tables of the summary table. For each base table that contains new data that affects the summary table, a join is performed between (1) the new data in the base table, (2) the pre-update state of base tables that follow the base table in the hypothetical load sequence, and (3) the post-update state of base tables the precede the base table in the hypothetical load sequence. The results of the join are then merged with the existing summary table to refresh the summary table. According to one aspect of the invention, efficiency is improved by performing the joins for the various base tables in parallel.

摘要翻译： 提供了一种方法和装置，用于执行从两个或多个基表导出的汇总表的延迟递增刷新。 通过将假设加载序列分配给汇总表的基表来执行增量刷新。 对于包含影响汇总表的新数据的每个基表，在（1）基表中的新数据之间执行连接，（2）假设负载中的基表之后的基表的更新前状态 序列，以及（3）基本表的更新后状态在假设加载序列中的基表之前。 然后将连接的结果与现有的摘要表合并，以刷新汇总表。 根据本发明的一个方面，通过并行地执行各个基表的联接来提高效率。

公开(公告)号：US07647354B2

公开(公告)日：2010-01-12

申请号：US10435703

申请日：2003-05-12

申请人： William D. Norcott

发明人： William D. Norcott

IPC分类号： G06F17/30

CPC分类号： G06F17/30592

摘要： A method and software for change data capture is described, in which change data is extracted from a recovery log in a single pass and stored into multiple database objects, such as change tables. The change data indicates modifications that has been performed to multiple source objects that correspond to the multiple database objects. In a preferred embodiment, this can be accomplished with a single multi-table insert SQL statement.

摘要翻译： 描述了用于改变数据捕获的方法和软件，其中在单次传递中从恢复日志中提取改变数据并将其存储到诸如变更表之类的多个数据库对象中。 更改数据表示对多个数据库对象对应的多个源对象执行的修改。 在优选实施例中，这可以通过单个多表插入SQL语句来实现。

公开(公告)号：US07111023B2

公开(公告)日：2006-09-19

申请号：US09863422

申请日：2001-05-24

申请人： William D. Norcott

发明人： William D. Norcott

IPC分类号： G06F17/30

CPC分类号： G06F17/30368 ,  Y10S707/99931 ,  Y10S707/99942 ,  Y10S707/99954

摘要： A synchronous change data capture system and methodology are described in which, for each statement of a transaction, a transaction identifier that uniquely identifies each transaction is recorded along with the change data. When the transaction is committed, the transaction identifier and a system change number for the commit is recorded in a transaction table. To identify the commit system change number for each statement in the change data, the transaction identifier in the change data is used to fetch the commit system change number from the transaction table.

公开(公告)号：US07970745B2

公开(公告)日：2011-06-28

申请号：US11471839

申请日：2006-06-21

申请人： William D. Norcott

发明人： William D. Norcott

IPC分类号： G06F17/00

CPC分类号： G06F17/30292 ,  G06F8/60 ,  G06F17/30309

摘要： Creating a relational database table that identifies at least one application as belonging to a logical group. All components that belong to the logical group are listed and a unique schema name is created for each component by combining a logical schema name of each component with a designated system name for the component. Each component co-exists in a single database instance.

摘要翻译： 创建将至少一个应用程序标识为属于逻辑组的关系数据库表。 列出属于逻辑组的所有组件，并通过将每个组件的逻辑模式名称与组件的指定系统名称组合，为每个组件创建唯一的模式名称。 每个组件共存在单个数据库实例中。

公开(公告)号：US20070299858A1

公开(公告)日：2007-12-27

申请号：US11471839

申请日：2006-06-21

申请人： William D. Norcott

发明人： William D. Norcott

IPC分类号： G06F7/00

CPC分类号： G06F17/30292 ,  G06F8/60 ,  G06F17/30309

摘要： Creating a relational database table that identifies at least one application as belonging to a logical group. All components that belong to the logical group are listed and a unique schema name is created for each component by combining a logical schema name of each component with a designated system name for the component. Each component co-exists in a single database instance.

摘要翻译： 创建将至少一个应用程序标识为属于逻辑组的关系数据库表。 列出属于逻辑组的所有组件，并通过将每个组件的逻辑模式名称与组件的指定系统名称组合，为每个组件创建唯一的模式名称。 每个组件共存在单个数据库实例中。

公开(公告)号：US07124141B2

公开(公告)日：2006-10-17

申请号：US10266074

申请日：2002-10-07

申请人： William D. Norcott

发明人： William D. Norcott

IPC分类号： G06F17/30

CPC分类号： G06F17/30306 ,  G06F17/30477 ,  Y10S707/954 ,  Y10S707/968 ,  Y10S707/99942 ,  Y10S707/99943

摘要： Fast purging of change data from a named change data database table by: (1) partitioning the table into partitions to separate data to be retained from data to be dropped and dropping the partition holding the data to be purged; or (2) creating a temporary change data database table and inserting the change data to be retained into a temporary table, dropping the named change data table, renaming the temporary table as the named table and inserting the change data within the temporary table into the renamed change table; or (3) creating a temporary change data table and copying data above a given value from the named table into the temporary database table, truncating the named table and inserting the data from the temporary into the named table and dropping the temporary table.

公开(公告)号：US5848405A

公开(公告)日：1998-12-08

申请号：US839190

申请日：1997-04-21

申请人： William D. Norcott

发明人： William D. Norcott

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  Y10S707/99931 ,  Y10S707/99943 ,  Y10S707/99953

摘要： A method and apparatus for identifying new data stored in data warehouses by storing the new data records at contiguous storage locations, and storing range data that specifies the range of the contiguous storage locations. New data is identified in the database by storing the start location and the end location of the contiguous range of data location, enabling server processes to access the new data records based on the stored range data, without needing to identify the new data records on a row-by-row basis. The arrangement for identifying new data is effective for updating existing summary information of existing data in view of the new data, for example, by generating a delta summary. The delta summary, representing summary information corresponding to the new data, can then be merged with the existing summary data to complete updating the summary data in view of the new data.

摘要翻译： 一种用于通过在连续的存储位置存储新的数据记录来识别存储在数据仓库中的新数据的方法和装置，以及存储指定连续存储位置的范围的范围数据。 通过存储数据位置的连续范围的起始位置和结束位置，在数据库中识别新数据，使得服务器进程可以基于存储的范围数据访问新的数据记录，而不需要在一个 逐行基础。 用于识别新数据的安排对于根据新数据更新现有数据的现有概要信息是有效的，例如通过生成增量摘要。 然后可以将与新数据相对应的摘要信息的增量摘要与现有摘要数据合并，以便根据新数据完成更新摘要数据。