专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

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

2. 发明授权

US07590638B2 System and method for online analytical processing using dimension attributes and multiple hierarchies where first hierarchy has at least one attribute from the defined dimension not present in the second hierarchy 有权
标题翻译：使用维度属性和多层次结构的在线分析处理的系统和方法，其中第一层次具有至少一个不存在于第二层次中的定义维度的属性
公开(公告)号：US07590638B2
公开(公告)日：2009-09-15
申请号：US10603037
申请日：2003-06-24
申请人： Cristian Petculescu , Amir Netz , Mosha Pasumansky , Marius Dumitru , Alexander Berger , Paul Jonathon Sanders
发明人： Cristian Petculescu , Amir Netz , Mosha Pasumansky , Marius Dumitru , Alexander Berger , Paul Jonathon Sanders
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30333 , G06F17/30592 , Y10S707/99931 , Y10S707/99943
摘要： A data model for accessing data in a relational database in an OLAP system utilizes a multiple-hierarchy dimension. The dimension includes a set of attributes. Each attribute is bound to a column in the relational database. A logical structure is defined, indicating the relationships between the attributes. Hierarchies are defined. Each hierarchy includes a sequence of attributes. A hierarchy provides a common drill-down path that a database user can utilize to access the database. A hierarchy can include a single attribute or a combination of attributes. Both the relationships between the attributes and the sequence of attributes in a hierarchy are defined independent of any restrictions associated with the database.
摘要翻译：用于访问OLAP系统中的关系数据库中的数据的数据模型利用多层次维度。维度包含一组属性。每个属性绑定到关系数据库中的一列。定义了逻辑结构，指示属性之间的关系。定义层次结构。每个层次结构包括一系列属性。层次结构提供了数据库用户可以利用来访问数据库的通用的下拉路径。层次结构可以包括单个属性或属性的组合。属性和层次结构中的属性序列之间的关系都是独立于与数据库关联的任何限制来定义的。

3. 发明授权

US07287022B2 System and method for analytically modeling data organized according to related attributes 有权
标题翻译：根据相关属性组织分析建模数据的系统和方法
公开(公告)号：US07287022B2
公开(公告)日：2007-10-23
申请号：US10199913
申请日：2002-07-19
申请人： Amir Netz , Cristian Petculescu , Mosha Pasumansky , Richard R. Tkachuk , Alexander Berger , Paul J. Sanders
发明人： Amir Netz , Cristian Petculescu , Mosha Pasumansky , Richard R. Tkachuk , Alexander Berger , Paul J. Sanders
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , Y10S707/954 , Y10S707/957 , Y10S707/958 , Y10S707/99933 , Y10S707/99944
摘要： A system and method for analytically modeling data with related attributes is disclosed. A single dimension is used to provide data according to each of the related attributes, and, thus, may be said to play the role of each related attribute depending on a received query. The measure of the analytical data model is tied to the dimension according to both data attributes to allow the measure to be analyzed by the dimension according to both attributes.
摘要翻译：公开了一种用于对具有相关属性的数据进行分析建模的系统和方法。单个维度用于根据每个相关属性提供数据，并且因此可以被称为根据所接收的查询发挥每个相关属性的作用。分析数据模型的度量根据两个数据属性与维度相关联，以允许根据两个属性通过维度来分析度量。

4. 发明授权

US07275022B2 System and method for analytically modeling data organized according to non-referred attributes 有权
标题翻译：根据非参考属性组织的分析建模数据的系统和方法
公开(公告)号：US07275022B2
公开(公告)日：2007-09-25
申请号：US10199612
申请日：2002-07-19
申请人： Amir Netz , Cristian Petculescu , Mosha Pasumansky , Richard R. Tkachuk , Alexander Berger
发明人： Amir Netz , Cristian Petculescu , Mosha Pasumansky , Richard R. Tkachuk , Alexander Berger
IPC分类号： G06F17/10 , G06F7/60
CPC分类号： G06F17/30592 , Y10S707/99933 , Y10S707/99943
摘要： A system and method for analytically modeling data organized according to non-referred attributes is disclosed. Data stored in a first and a second relational data table is analytically modeled in a data cube. The first table organizes a first type according to a first attribute. The second table organizes a second type according to the first attribute and a second attribute. A first measure is modeled according to the first type of the first table. A first dimension is modeled according to the first attribute of the first and second tables. A second dimension is modeled according to the second attribute of the second table. The first measure is tied to the first dimension according to the first attribute of the first table to allow the first measure to be analyzed by the first dimension according to the first attribute. The first measure is tied to the second dimension by, for each entry of the first dimension, allocating the entry to each entry of the second dimension in a predetermined manner.
摘要翻译：公开了一种用于根据非参考属性组织的分析建模数据的系统和方法。存储在第一和第二关系数据表中的数据在数据立方体中被分析地建模。第一个表根据第一个属性组织第一个类型。第二表根据第一属性和第二属性组织第二类。第一个度量根据第一个表的第一个类型进行建模。根据第一和第二表的第一属性对第一维进行建模。根据第二表的第二属性对第二维进行建模。根据第一表的第一个属性，第一个度量与第一个维度相关联，以便根据第一个属性对第一个维度进行第一个维度的分析。对于第一维度的每个条目，第一尺度与第二维度相关联，以预定方式将条目分配给第二维度的每个条目。

5. 发明申请

US20060010139A1 System that facilitates database querying 有权
标题翻译：便于数据库查询的系统
公开(公告)号：US20060010139A1
公开(公告)日：2006-01-12
申请号：US11069693
申请日：2005-03-01
申请人： Amir Netz , Marius Dumitru , Mosha Pasumansky , Cristian Petculescu , Richard Tkachuk , Alexander Berger
发明人： Amir Netz , Marius Dumitru , Mosha Pasumansky , Cristian Petculescu , Richard Tkachuk , Alexander Berger
IPC分类号： G06F17/00
CPC分类号： G06F17/30539 , G06F17/30522 , G06F17/30592 , Y10S707/99943
摘要： A system that facilitates analyzing content of a multi-dimensional structure comprises a calculation component that receives statements in a declarative language relating to one or more of an assignment and calculation and executes such statements against a multi-dimensional structure. A pass generation component creates a pass in order to maintain content of the multi-dimensional structure as it existed prior to execution of the statement, the pass is accessible upon reference to such pass.
摘要翻译：便于分析多维结构的内容的系统包括计算组件，其以与分配和计算中的一个或多个相关的声明语言接收语句，并针对多维结构执行这些语句。通过生成组件创建一个通行证，以便在执行语句之前保持多维结构的内容，因为在参考此类通过时可以访问该通行证。

6. 发明授权

US07809678B2 Fact dimensions in multidimensional databases 有权
标题翻译：多维数据库中的事实维度
公开(公告)号：US07809678B2
公开(公告)日：2010-10-05
申请号：US11135718
申请日：2005-05-24
申请人： Alexander Berger , Edward Melomed , Amir Netz , Cristian Petculescu , Akshai M. Mirchandani , Mosha Pasumansky , Marius Dumitru , Richard R. Tkachuk
发明人： Alexander Berger , Edward Melomed , Amir Netz , Cristian Petculescu , Akshai M. Mirchandani , Mosha Pasumansky , Marius Dumitru , Richard R. Tkachuk
IPC分类号： G06F17/00 , G06F15/16
CPC分类号： G06F17/30592 , G06F17/30418
摘要： The subject invention pertains to systems and methods for interacting with fact dimensions. In particular, systems and methods are disclosed that optimize performance and scalability with respect to processing queries that involve fact dimensions. Furthermore, queries involving fact dimensions can be evaluated in distinct manners. For instance, queries can be processed such that regular dimensions restrict the scope of the data and only fact dimension members that are relevant to that scope are exposed.
摘要翻译：本发明涉及与事实维度相互作用的系统和方法。特别地，公开了关于处理涉及事实维度的查询的性能和可扩展性的系统和方法。此外，可以以不同的方式评估涉及事实维度的查询。例如，可以处理查询，使得常规维度限制数据的范围，并且仅暴露与该范围相关的事实维度成员。

7. 发明授权

US07650332B2 Database query tools 失效
标题翻译：数据库查询工具
公开(公告)号：US07650332B2
公开(公告)日：2010-01-19
申请号：US11069263
申请日：2005-03-01
申请人： Marius Dumitru , Amir Netz , Mosha Pasumansky , Cristian Petculescu , Richard R. Tkachuk , Alexander Berger , Irina G. Gorbach , Grzegorz Guzik
发明人： Marius Dumitru , Amir Netz , Mosha Pasumansky , Cristian Petculescu , Richard R. Tkachuk , Alexander Berger , Irina G. Gorbach , Grzegorz Guzik
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30522 , G06F17/30389 , G06F17/30592 , Y10S707/99933
摘要： A system that facilitates one or more of querying and updating a multi-dimensional structure comprises a component that receives a statement in a declarative language relating to a typed object associated with a multi-dimensional structure. A conversion component analyzes context associated with the statement and automatically converts the object to a disparate type as a function of the analysis. For example, an execution engine can comprise the conversion component, and the execution engine can be an Online Analytical Processing (OLAP) engine.
摘要翻译：促进查询和更新多维结构中的一个或多个的系统包括接收与与多维结构相关联的类型对象相关的声明语言的语句的组件。转换组件分析与语句相关联的上下文，并根据分析自动将对象转换为不同类型。例如，执行引擎可以包括转换组件，并且执行引擎可以是在线分析处理（OLAP）引擎。

8. 发明申请

US20060010113A1 Fact dimensions in multidimensional databases 有权
标题翻译：多维数据库中的事实维度
公开(公告)号：US20060010113A1
公开(公告)日：2006-01-12
申请号：US11135718
申请日：2005-05-24
申请人： Alexander Berger , Edward Melomed , Amir Netz , Cristian Petculescu , Akshai Mirchandani , Mosha Pasumansky , Marius Dumitru , Richard Tkachuk
发明人： Alexander Berger , Edward Melomed , Amir Netz , Cristian Petculescu , Akshai Mirchandani , Mosha Pasumansky , Marius Dumitru , Richard Tkachuk
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30418
摘要： The subject invention pertains to systems and methods for interacting with fact dimensions. In particular, systems and methods are disclosed that optimize performance and scalability with respect to processing queries that involve fact dimensions. Furthermore, queries involving fact dimensions can be evaluated in distinct manners. For instance, queries can be processed such that regular dimensions restrict the scope of the data and only fact dimension members that are relevant to that scope are exposed.
摘要翻译：本发明涉及与事实维度相互作用的系统和方法。特别地，公开了关于处理涉及事实维度的查询的性能和可扩展性的系统和方法。此外，可以以不同的方式评估涉及事实维度的查询。例如，可以处理查询，使得常规维度限制数据的范围，并且仅暴露与该范围相关的事实维度成员。

9. 发明申请

US20060007731A1 Database query tools 失效
标题翻译：数据库查询工具
公开(公告)号：US20060007731A1
公开(公告)日：2006-01-12
申请号：US11069263
申请日：2005-03-01
申请人： Marius Dumitru , Amir Netz , Mosha Pasumansky , Cristian Petculescu , Richard Tkachuk , Alexander Berger , Irina Gorbach , Grzegorz Guzik
发明人： Marius Dumitru , Amir Netz , Mosha Pasumansky , Cristian Petculescu , Richard Tkachuk , Alexander Berger , Irina Gorbach , Grzegorz Guzik
IPC分类号： G11C11/34
CPC分类号： G06F17/30522 , G06F17/30389 , G06F17/30592 , Y10S707/99933
摘要： A system that facilitates one or more of querying and updating a multi-dimensional structure comprises a component that receives a statement in a declarative language relating to a typed object associated with a multi-dimensional structure. A conversion component analyzes context associated with the statement and automatically converts the object to a disparate type as a function of the analysis. For example, an execution engine can comprise the conversion component, and the execution engine can be an Online Analytical Processing (OLAP) engine.
摘要翻译：促进查询和更新多维结构中的一个或多个的系统包括接收与与多维结构相关联的类型对象相关的声明语言的语句的组件。转换组件分析与语句相关联的上下文，并根据分析自动将对象转换为不同类型。例如，执行引擎可以包括转换组件，并且执行引擎可以是在线分析处理（OLAP）引擎。

10. 发明授权

US07873669B2 Direct write back systems and methodologies 有权
标题翻译：直接回写系统和方法
公开(公告)号：US07873669B2
公开(公告)日：2011-01-18
申请号：US11137232
申请日：2005-05-25
申请人： Amir Netz , Alexander Berger , Mosha Pasumansky , Richard R. Tkachuk , Cristian Petculescu
发明人： Amir Netz , Alexander Berger , Mosha Pasumansky , Richard R. Tkachuk , Cristian Petculescu
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30592
摘要： Provided are systems and methods that facilitate direct write back in a multi-dimensional database. The system includes a delta cache component that receives a user request to change an original cell value and determines a delta value based at least in part upon the changed cell value. Also included is a write back partition component that selectively updates a data cell based at least in part upon the delta value without updating corresponding data cell values. The system and methods allow attributes to be added to any dimension of a cube without affecting the write back data. Adding, modifying or removing a hierarchy has no affect on write back data nor does deleting a dimension that is not referenced by a write back.
摘要翻译：提供了便于在多维数据库中直接回写的系统和方法。该系统包括增量缓存组件，其接收用户请求以改变原始小区值，并且至少部分地基于所改变的小区值来确定增量值。还包括写回分区组件，其至少部分地基于增量值来选择性地更新数据单元，而不更新对应的数据单元值。系统和方法允许将属性添加到多维数据集的任何维度，而不会影响回写数据。添加，修改或删除层次结构对回写数据没有影响，也不会删除未被回写引用的维。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式