利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

9 条记录 (耗时 0.038 秒)

    Multidimensional data cubes with high-cardinality attributes
    5.
    发明授权
    Multidimensional data cubes with high-cardinality attributes 有权
    具有高基数属性的多维数据立方体

    公开(公告)号：US08380748B2

    公开(公告)日：2013-02-19

    申请号：US12042674

    申请日：2008-03-05

    申请人： Alexander Berger ,  Mosha Pasumansky ,  Amir Netz ,  Akshai M. Mirchandani ,  Marius Dumitru ,  Cristian Petculescu

    发明人： Alexander Berger ,  Mosha Pasumansky ,  Amir Netz ,  Akshai M. Mirchandani ,  Marius Dumitru ,  Cristian Petculescu

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

    CPC分类号： G06F17/30592

    摘要： Computer-readable media, systems, and methods for building a multidimensional data cube having one or more high-cardinality attributes are described. In embodiments, data is extracted from one or more databases. It is determined that one or more instances of the data are fact data and one or more instances of the data are dimension data. Each member of the fact data is one instance of a dimension and each instance of the dimension data includes an attribute for grouping the fact data. Moreover, in embodiments it is determined that one or more instances of the dimension data are high-cardinality attributes. The one or more high-cardinality attributes are processed with fact data and stored in fact tables on a computer storage medium.

    摘要翻译： 描述了用于构建具有一个或多个高基数属性的多维数据立方体的计算机可读介质，系统和方法。 在实施例中，从一个或多个数据库提取数据。 确定数据的一个或多个实例是事实数据，并且数据的一个或多个实例是尺寸数据。 事实数据的每个成员是维度的一个实例，维数据的每个实例包括用于对事实数据进行分组的属性。 此外，在实施例中，确定尺寸数据的一个或多个实例是高基数属性。 一个或多个高基数属性用事实数据处理并存储在计算机存储介质上的事实表中。

    Multidimensional data space queries with expression evaluation
    6.
    发明授权
    Multidimensional data space queries with expression evaluation 有权
    具有表达式求值的多维数据空间查询

    公开(公告)号：US08229923B2

    公开(公告)日：2012-07-24

    申请号：US12239695

    申请日：2008-09-26

    申请人： Akshai M. Mirchandani ,  Marius Dumitru ,  Mosha Pasumansky ,  Irina G. Gorbach

    发明人： Akshai M. Mirchandani ,  Marius Dumitru ,  Mosha Pasumansky ,  Irina G. Gorbach

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

    CPC分类号： G06F17/30592 ,  Y10S707/957

    摘要： A system and techniques for executing queries of a sparse multidimensional data space in the presence of expressions. A dimension is associated with a set of data references, which reference stored data items. A query expression has dimension or a data reference as an operand. A result space with one or more result dimensions is defined based on the query. A plan is built and executed for retrieving the stored data items associated with the result dimensions, and forming “calculated data items” by evaluating the expression. Executing the plan produces a stream of data tuples, each having a set of data components storing the retrieved data items and/or the calculated data items. Data components are either empty or have data values. An iterative algorithm is employed on the stream to locate the data tuples that are empty at the intersection of each result dimension.

    摘要翻译： 用于在存在表达式的情况下执行稀疏多维数据空间的查询的系统和技术。 维度与一组数据引用相关联，引用存储的数据项。 查询表达式具有维或数据引用作为操作数。 基于查询定义具有一个或多个结果维度的结果空间。 构建并执行用于检索与结果维度相关联的存储数据项的计划，并通过评估表达式形成“计算的数据项”。 执行该计划产生一组数据元组，每个数据流都具有存储检索到的数据项和/或计算的数据项的一组数据组件。 数据组件为空或具有数据值。 在流上采用迭代算法来定位在每个结果维度的交集处为空的数据元组。

    MULTIDIMENSIONAL DATA SPACE QUERIES WITH EXPRESSION EVALUATION
    7.
    发明申请
    MULTIDIMENSIONAL DATA SPACE QUERIES WITH EXPRESSION EVALUATION 有权
    具有表达式评估的多维数据空间查询

    公开(公告)号：US20100082577A1

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

    申请号：US12239695

    申请日：2008-09-26

    申请人： Akshai M. Mirchandani ,  Marius Dumitru ,  Mosha Pasumansky ,  Irina G. Gorbach

    发明人： Akshai M. Mirchandani ,  Marius Dumitru ,  Mosha Pasumansky ,  Irina G. Gorbach

    IPC分类号： G06F7/06 ,  G06F17/30

    CPC分类号： G06F17/30592 ,  Y10S707/957

    摘要： A system and techniques for executing queries of a sparse multidimensional data space in the presence of expressions. A dimension is associated with a set of data references, which reference stored data items. A query expression has dimension or a data reference as an operand. A result space with one or more result dimensions is defined based on the query. A plan is built and executed for retrieving the stored data items associated with the result dimensions, and forming “calculated data items” by evaluating the expression. Executing the plan produces a stream of data tuples, each having a set of data components storing the retrieved data items and/or the calculated data items. Data components are either empty or have data values. An iterative algorithm is employed on the stream to locate the data tuples that are empty at the intersection of each result dimension.

    摘要翻译： 用于在存在表达式的情况下执行稀疏多维数据空间的查询的系统和技术。 维度与一组数据引用相关联，引用存储的数据项。 查询表达式具有维或数据引用作为操作数。 基于查询定义具有一个或多个结果维度的结果空间。 构建并执行用于检索与结果维度相关联的存储数据项的计划，并通过评估表达式形成“计算的数据项”。 执行该计划产生一组数据元组，每个数据流都具有存储检索到的数据项和/或计算的数据项的一组数据组件。 数据组件为空或具有数据值。 在流上采用迭代算法来定位在每个结果维度的交集处为空的数据元组。

    Custom grouping for dimension members
    8.
    发明授权
    Custom grouping for dimension members 有权
    维度成员的自定义分组

    公开(公告)号：US07562086B2

    公开(公告)日：2009-07-14

    申请号：US11167413

    申请日：2005-06-27

    申请人： Akshai M. Mirchandani ,  Alexander Berger ,  Thomas P. Conlon ,  Edward Melomed

    发明人： Akshai M. Mirchandani ,  Alexander Berger ,  Thomas P. Conlon ,  Edward Melomed

    IPC分类号： G06F7/00

    CPC分类号： G06F17/30592 ,  Y10S707/99942

    摘要： Custom grouping for dimension members of an On-Line Analytical Processing (OLAP) cube is facilitated by an interface component that receives a grouping from a user. A modification component alters an attribute of a session OLAP data cube or a virtual OLAP multi-dimensional data cube so that the change becomes readily available without the time-consuming delay associated with rebuilding or reprocessing the underlying structure. A data scheme generation component produces a data definition language (DDL) definition of a user defined attribute executed by an execution component to affect the change to a data cube. Custom groupings can provide an intermediate dimension level for drill down and/or drill up or roll-up between a level with few members and a level with numerous members. A separate dimensional attribute or level can be created and a group defined comprising or mapping a set or collection of discrete members.

    摘要翻译： 由在线分析处理（OLAP）多维数据集的维度成员进行自定义分组，该接口组件从用户接收分组。 修改组件更改会话OLAP数据立方体或虚拟OLAP多维数据立方体的属性，以便更改变得容易获得，而不需要与重建或重新处理底层结构相关的耗时的延迟。 数据方案生成组件产生由执行组件执行的用户定义属性的数据定义语言（DDL）定义，以影响对数据立方体的更改。 自定义分组可以提供中间维度级别，用于在具有少量成员的级别和具有众多成员的级别之间进行深入和/或钻取或汇总。 可以创建单独的维度属性或级别，并且定义的组包括或映射离散成员的集合或集合。

    System that facilitates maintaining business calendars
    9.
    发明授权
    System that facilitates maintaining business calendars 失效
    有助于维护业务日历的系统

    公开(公告)号：US07533348B2

    公开(公告)日：2009-05-12

    申请号：US11054302

    申请日：2005-02-09

    申请人： Thierry D'Hers ,  Aleksandar Juric ,  Akshai M. Mirchandani

    发明人： Thierry D'Hers ,  Aleksandar Juric ,  Akshai M. Mirchandani

    IPC分类号： G06F3/048 ,  G06F17/00

    CPC分类号： G06Q10/109 ,  Y10S707/99943 ,  Y10S707/99945 ,  Y10S715/963

    摘要： A calendar customization system comprises an interface component that receives responses to one or more questions relating to a calendar. A execution automatically generates a multi-dimensional structure for the calendar, the structure generated as a function of the responses. For example, the multi-dimensional structure can relate to a Gregorian calendar, a fiscal calendar, a reporting calendar, a manufacturing calendar, and/or an ISO8601 calendar.

    摘要翻译： 日历定制系统包括接收对与日历相关的一个或多个问题的响应的接口组件。 执行自动为日历生成多维结构，该结构作为响应的函数生成。 例如，多维结构可以涉及公历，会计日历，报告日历，制造日历和/或ISO8601日历。