Apparatus and method for capturing and propagating changes from an
operational database to data marts
    4.
    发明授权
    Apparatus and method for capturing and propagating changes from an operational database to data marts 失效
    用于从操作数据库捕获和传播变化到数据集市的装置和方法

    公开(公告)号:US06032158A

    公开(公告)日:2000-02-29

    申请号:US850490

    申请日:1997-05-02

    IPC分类号: G06F17/30

    摘要: A method for updating a target table of a data mart in response to changes made by a transaction to data stored in a source table of an operational database. Data that was changed in the source table by the transaction is stored in a dynamic image table of a change capture database. Data that was not changed in the source table by the transaction, but which is nevertheless required to be mapped to the target table, is stored in a static image table of the change capture database. The change capture database also contains relevant information regarding the transaction. Once the dynamic and static image tables are properly staged, the changes are propagated from the change capture database to the target tables of the data marts. In other words, data is extracted from the change capture database and subsequently transformed and loaded, thereby minimizing the impact to the operational database. Thereupon, the tables of the change capture database are truncated to discard data which is now no longer needed.

    摘要翻译: 一种用于响应于由事务对存储在操作数据库的源表中的数据所做的改变来更新数据集市的目标表的方法。 由事务在源表中更改的数据存储在更改捕获数据库的动态映像表中。 在事务处理源表中未被更改但仍需要映射到目标表的数据存储在变更捕获数据库的静态映像表中。 更改捕获数据库还包含有关事务的相关信息。 一旦动态和静态映像表被正确地分级,更改将从更改捕获数据库传播到数据集市的目标表。 换句话说,从变更捕获数据库中提取数据,随后进行变换和加载,从而最小化对操作数据库的影响。 因此,更改捕获数据库的表被截断以丢弃现在不再需要的数据。

    Software Map
    5.
    发明申请
    Software Map 有权
    软件地图

    公开(公告)号:US20120096425A1

    公开(公告)日:2012-04-19

    申请号:US12905122

    申请日:2010-10-15

    IPC分类号: G06F9/44 G06F3/00

    摘要: In one embodiment a method is provided for rendering a software map. The method includes storing, in an electronic database, information associated with a software development project, the information including start and end dates of particular efforts made in connection with the software development project and dates of specific events associated with the software development project, rendering on a display a timeline, and rendering on the display a software map, wherein the software map includes horizontal lines representing the particular efforts that extend between endpoints defined, substantially, by the start and end dates, and that are aligned with a time scale of the timeline, and vertically or substantially vertical extending lines between and connecting pairs of horizontal lines, wherein each vertically or substantially vertically extending line represents one of the specific events associated with the software development project.

    摘要翻译: 在一个实施例中,提供了一种用于渲染软件映射的方法。 该方法包括在电子数据库中存储与软件开发项目相关联的信息,所述信息包括与软件开发项目相关的特定努力的开始和结束日期以及与软件开发项目相关联的特定事件的日期, 显示时间线,以及在显示器上呈现软件地图,其中软件地图包括水平线,其表示在基本上由开始和结束日期定义的端点之间延伸的特定努力,并且它们与 时间线,以及垂直或基本上垂直的延伸线和连接的水平线对之间,其中每个垂直或基本上垂直延伸的线表示与软件开发项目相关联的特定事件之一。

    Real time sessions in an analytic application
    6.
    发明授权
    Real time sessions in an analytic application 有权
    分析应用程序中的实时会话

    公开(公告)号:US06789096B2

    公开(公告)日:2004-09-07

    申请号:US09891818

    申请日:2001-06-25

    IPC分类号: G06F1730

    摘要: A method and system thereof for performing real time transformations of dynamically increasing databases is described. A session, identified as a real time session, is initialized. The real time session repeatedly executes a persistent (e.g., continually running) data transport pipeline of the analytic application. The data transport pipeline extracts data from a changing database, transforms the data, and writes the transformed data to storage (e.g., a data warehouse or data mart). The data transport pipeline is executed at the end of each time interval in a plurality of contiguous time intervals occurring during the real time session. The data transport pipeline remains running after it is executed, until the real time session is completed. Accordingly, new data are transformed in a timely manner, and processing resources are not consumed by having to repeatedly re-establish (re-initialize) the data transport pipeline.

    摘要翻译: 描述了一种用于执行动态增加数据库的实时变换的方法和系统。 被识别为实时会话的会话被初始化。 实时会话重复执行分析应用程序的持续(例如,不断运行)的数据传输管线。 数据传输管线从改变的数据库中提取数据,转换数据,并将变换的数据写入存储(例如,数据仓库或数据集市)。 在实时会话期间发生的多个连续时间间隔中,在每个时间间隔结束时执行数据传输流水线。 数据传输管道在执行后保持运行,直到实时会话完成。 因此,及时地转换新的数据,不必重复地重新建立(重新初始化)数据传送管线,而不消耗处理资源。

    Method and apparatus of universal cross connect
    9.
    发明授权
    Method and apparatus of universal cross connect 有权
    通用交叉连接的方法和装置

    公开(公告)号:US07327752B1

    公开(公告)日:2008-02-05

    申请号:US10256525

    申请日:2002-09-26

    IPC分类号: H04B7/212 H04L12/66

    CPC分类号: H04L12/66

    摘要: Methods and apparatus for achieving universal cross connect for Time Domain Modulated (TDM) data between a first and second data streams each having a corresponding time slot assignment are disclosed. Cross connect may be achieved through the use of a time slot assignment table.

    摘要翻译: 公开了在具有对应的时隙分配的第一和第二数据流之间实现时域调制(TDM)数据的通用交叉连接的方法和装置。 可以通过使用时隙分配表来实现交叉连接。

    Software map to represent information regarding software development events
    10.
    发明授权
    Software map to represent information regarding software development events 有权
    软件地图,用于表示有关软件开发事件的信息

    公开(公告)号:US08910111B2

    公开(公告)日:2014-12-09

    申请号:US12905122

    申请日:2010-10-15

    IPC分类号: G06F9/44 G06Q10/06

    摘要: In one embodiment a method is provided for rendering a software map. The method includes storing, in an electronic database, information associated with a software development project, the information including start and end dates of particular efforts made in connection with the software development project and dates of specific events associated with the software development project, rendering on a display a timeline, and rendering on the display a software map, wherein the software map includes horizontal lines representing the particular efforts that extend between endpoints defined, substantially, by the start and end dates, and that are aligned with a time scale of the timeline, and vertically or substantially vertical extending lines between and connecting pairs of horizontal lines, wherein each vertically or substantially vertically extending line represents one of the specific events associated with the software development project.

    摘要翻译: 在一个实施例中,提供了一种用于渲染软件映射的方法。 该方法包括在电子数据库中存储与软件开发项目相关联的信息,所述信息包括与软件开发项目相关的特定努力的开始和结束日期以及与软件开发项目相关联的特定事件的日期, 显示时间线,以及在显示器上呈现软件地图,其中软件地图包括水平线,其表示在基本上由开始和结束日期定义的端点之间延伸的特定努力,并且它们与 时间线,以及垂直或基本上垂直的延伸线和连接的水平线对之间,其中每个垂直或基本上垂直延伸的线表示与软件开发项目相关联的特定事件之一。