Techniques for managing what-if analysis of data managed by a relational database system
    1.
    发明授权
    Techniques for managing what-if analysis of data managed by a relational database system 有权
    用于管理由关系数据库系统管理的数据的假设分析的技术

    公开(公告)号:US06898608B2

    公开(公告)日:2005-05-24

    申请号:US10417732

    申请日:2003-04-16

    IPC分类号: G06F12/00 G06F17/30

    摘要: An analytical workspace includes a set of data on which what-if analysis is performed, which is stored persistently and managed in a relational database system. The data may be stored as a binary large object in relational tables, and may comprise a portion of a multidimensional cube. A series of commands on the analytical workspace is received by a database server. In response to the commands, changes are made to the data in temporary storage. Redo information is not generated at this time in association with such changes. Hence, these changes are not made permanent at this time. At some point, the server may receive an update command to make the changes permanent. In response to the update command, redo information is generated for the changes reflected in the temporary storage and the changes are made permanent, in accordance with relational database properties.

    摘要翻译: 分析工作区包括一组在其上执行假设分析的数据,这些数据在关系数据库系统中持续存储并进行管理。 数据可以作为二进制大对象存储在关系表中,并且可以包括多维立方体的一部分。 数据库服务器接收到分析工作区上的一系列命令。 响应命令,对临时存储中的数据进行更改。 此时不再生成重做信息与此类更改相关联。 因此,这些变化并不是永久性的。 在某些时候,服务器可能会收到一个更新命令,使更改永久。 响应于update命令,根据关系数据库属性,为临时存储中反映的更改生成重做信息,并将更改永久化。