-
31.发明授权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
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系统中的关系数据库中的数据的数据模型利用多层次维度。 维度包含一组属性。 每个属性绑定到关系数据库中的一列。 定义了逻辑结构，指示属性之间的关系。 定义层次结构。 每个层次结构包括一系列属性。 层次结构提供了数据库用户可以利用来访问数据库的通用的下拉路径。 层次结构可以包括单个属性或属性的组合。 属性和层次结构中的属性序列之间的关系都是独立于与数据库关联的任何限制来定义的。
-
32.发明授权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.
摘要翻译： 公开了一种用于对具有相关属性的数据进行分析建模的系统和方法。 单个维度用于根据每个相关属性提供数据，并且因此可以被称为根据所接收的查询发挥每个相关属性的作用。 分析数据模型的度量根据两个数据属性与维度相关联，以允许根据两个属性通过维度来分析度量。
-
33.发明授权System and method for analytically modeling data organized according to non-referred attributes 有权根据非参考属性组织的分析建模数据的系统和方法公开(公告)号：US07275022B2
公开(公告)日：2007-09-25
申请号：US10199612
申请日：2002-07-19
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.
摘要翻译： 公开了一种用于根据非参考属性组织的分析建模数据的系统和方法。 存储在第一和第二关系数据表中的数据在数据立方体中被分析地建模。 第一个表根据第一个属性组织第一个类型。 第二表根据第一属性和第二属性组织第二类。 第一个度量根据第一个表的第一个类型进行建模。 根据第一和第二表的第一属性对第一维进行建模。 根据第二表的第二属性对第二维进行建模。 根据第一表的第一个属性，第一个度量与第一个维度相关联，以便根据第一个属性对第一个维度进行第一个维度的分析。 对于第一维度的每个条目，第一尺度与第二维度相关联，以预定方式将条目分配给第二维度的每个条目。
-
34.发明申请公开(公告)号：US20060024653A1
公开(公告)日：2006-02-02
申请号：US10903568
申请日：2004-07-30
申请人： Daniel Battagin , Liviu Asnash , Shahar Prish , Eran Megiddo , Amir Netz , Cristian Petculescu
发明人： Daniel Battagin , Liviu Asnash , Shahar Prish , Eran Megiddo , Amir Netz , Cristian Petculescu
IPC分类号： G09B3/00
CPC分类号： G06F17/246 , G06F3/04883 , G06F17/30592 , Y10S707/99943
摘要： A method, system, and apparatus are provided for exposing and utilizing workbooks as server data sources. The system includes a client computer capable of executing a spreadsheet application program for creating a workbook including one or more worksheets. The workbook may be published to a server computer where the contents of the workbook are exposed as a multi-dimensional data source. The server computer allows client applications to discover and connect to the workbook as a multi-dimensional, data source, such as a cube.
摘要翻译： 提供了一种方法，系统和装置，用于将工作簿作为服务器数据源进行曝光和利用。 该系统包括能够执行用于创建包括一个或多个工作表的工作簿的电子表格应用程序的客户端计算机。 工作簿可以被发布到服务器计算机，其中工作簿的内容作为多维数据源被公开。 服务器计算机允许客户端应用程序作为多维数据源（如多维数据集）发现和连接到工作簿。
-
35.发明授权Efficient large-scale filtering and/or sorting for querying of column based data encoded structures 有权用于查询基于列的数据编码结构的高效大规模过滤和/或排序公开(公告)号：US08478775B2
公开(公告)日：2013-07-02
申请号：US12363637
申请日：2009-01-30
CPC分类号： G06F17/30501 , G06F17/30315 , G06F17/30448
摘要： The subject disclosure relates to querying of column based data encoded structures enabling efficient query processing over large scale data storage, and more specifically with respect to complex queries implicating filter and/or sort operations for data over a defined window. In this regard, in various embodiments, a method is provided that avoids scenarios involving expensive sorting of a high percentage of, or all, rows, either by not sorting any rows at all, or by sorting only a very small number of rows consistent with or smaller than a number of rows associated with the size of the requested window over the data. In one embodiment, this is achieved by splitting an external query request into two different internal sub-requests, a first one that computes statistics about distribution of rows for any specified WHERE clauses and ORDER BY columns, and a second one that selects only the rows that match the window based on the statistics.
摘要翻译： 主题公开涉及查询基于列的数据编码结构，其能够在大规模数据存储上进行有效的查询处理，更具体地涉及涉及在定义的窗口上涉及数据的过滤器和/或排序操作的复杂查询。 在这方面，在各种实施例中，提供了一种方法，其避免了通过不对任何行进行排序的方式来避免高百分比或全部行的昂贵排序的情况，或者仅通过仅排列非常小数量的与 或小于与数据上所请求的窗口大小相关联的行数。 在一个实施例中，这是通过将外部查询请求分割成两个不同的内部子请求来实现的，第一个是根据任何指定的WHERE子句和ORDER BY列计算关于行的分布的统计信息，第二个仅选择行 根据统计信息匹配窗口。
-
公开(公告)号：US08185817B2
公开(公告)日：2012-05-22
申请号：US12141114
申请日：2008-06-18
CPC分类号： G06F17/246
摘要： Various technologies and techniques are disclosed for utilizing spreadsheet references with grouped aggregate views. A grouped aggregate view feature enables a user to create a grouped aggregate view of data. A calculation feature enables the user to calculations for the grouped aggregate view of data that are based upon relative or absolute references to data in the grouped aggregate view. Input is received from a user to write a calculation within a first cell in a grouped aggregate view. Input is received from the user to select a second cell to reference when writing the calculation. The user is presented with available references that are relevant to data contained in the second cell. Input is received from the user to select one of the available references that are relevant for the second cell. The selected one of the available references is placed into the first cell.
摘要翻译： 公开了利用具有分组聚集视图的电子表格引用的各种技术和技术。 分组的聚合视图功能使用户能够创建数据的分组聚合视图。 计算功能使用户能够对分组的聚合视图数据进行计算，该视图基于分组聚合视图中对数据的相对或绝对引用。 从用户接收输入以在分组聚合视图中的第一个单元格内写入计算。 从用户接收到输入，以便在写入计算时选择第二个单元格进行参考。 向用户呈现与第二小区中包含的数据相关的可用参考。 从用户接收输入以选择与第二小区相关的可用参考之一。 所选择的一个可用参考被放入第一个单元格中。
-
公开(公告)号：US07873669B2
公开(公告)日：2011-01-18
申请号：US11137232
申请日：2005-05-25
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.
摘要翻译： 提供了便于在多维数据库中直接回写的系统和方法。 该系统包括增量缓存组件，其接收用户请求以改变原始小区值，并且至少部分地基于所改变的小区值来确定增量值。 还包括写回分区组件，其至少部分地基于增量值来选择性地更新数据单元，而不更新对应的数据单元值。 系统和方法允许将属性添加到多维数据集的任何维度，而不会影响回写数据。 添加，修改或删除层次结构对回写数据没有影响，也不会删除未被回写引用的维。
-
38.发明授权Method, system, and apparatus for exposing workbook ranges as data sources 有权用于将工作簿范围暴露为数据源的方法，系统和装置公开(公告)号：US07664804B2
公开(公告)日：2010-02-16
申请号：US10858175
申请日：2004-06-01
CPC分类号： G06F17/246 , G06F17/30592
摘要： A method, system, and apparatus are provided for exposing and utilizing workbook ranges as server data sources. The system includes a client computer capable of executing a spreadsheet application program for creating a workbook including a range that includes data objects. The workbook may be published to a server computer where the specified data objects are exposed as server data sources. The server computer allows client applications to discover and connect to the data objects contained within the workbook as server data sources.
摘要翻译： 提供了一种用于将工作簿范围作为服务器数据源进行曝光和利用的方法，系统和装置。 该系统包括能够执行用于创建包括包括数据对象的范围的工作簿的电子表格应用程序的客户端计算机。 工作簿可能会被发布到服务器计算机，其中指定的数据对象作为服务器数据源公开。 服务器计算机允许客户端应用程序发现并连接到工作簿中包含的数据对象作为服务器数据源。
-
公开(公告)号：US07660811B2
公开(公告)日：2010-02-09
申请号：US11069693
申请日：2005-03-01
申请人： Amir Netz , Marius Dumitru , Mosha Pasumansky , Cristian Petculescu , Richard R. Tkachuk , Alexander Berger
发明人： Amir Netz , Marius Dumitru , Mosha Pasumansky , Cristian Petculescu , Richard R. Tkachuk , Alexander Berger
IPC分类号： G06F7/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.
摘要翻译： 便于分析多维结构的内容的系统包括计算组件，其以与分配和计算中的一个或多个相关的声明语言接收语句，并针对多维结构执行这些语句。 通过生成组件创建一个通行证，以便在执行语句之前保持多维结构的内容，因为在参考此类通过时可以访问该通行证。
-
公开(公告)号：US20090319880A1
公开(公告)日：2009-12-24
申请号：US12141114
申请日：2008-06-18
IPC分类号： G06F17/00
CPC分类号： G06F17/246
摘要： Various technologies and techniques are disclosed for utilizing spreadsheet references with grouped aggregate views. A grouped aggregate view feature enables a user to create a grouped aggregate view of data. A calculation feature enables the user to calculations for the grouped aggregate view of data that are based upon relative or absolute references to data in the grouped aggregate view. Input is received from a user to write a calculation within a first cell in a grouped aggregate view. Input is received from the user to select a second cell to reference when writing the calculation. The user is presented with available references that are relevant to data contained in the second cell. Input is received from the user to select one of the available references that are relevant for the second cell. The selected one of the available references is placed into the first cell.
摘要翻译： 公开了利用具有分组聚集视图的电子表格引用的各种技术和技术。 分组的聚合视图功能使用户能够创建数据的分组聚合视图。 计算功能使用户能够对分组的聚合视图数据进行计算，该视图基于分组聚合视图中对数据的相对或绝对引用。 从用户接收输入以在分组聚合视图中的第一个单元格内写入计算。 从用户接收到输入，以便在写入计算时选择第二个单元格进行参考。 向用户呈现与第二小区中包含的数据相关的可用参考。 从用户接收输入以选择与第二小区相关的可用参考之一。 所选择的一个可用参考被放入第一个单元格中。
-
-
-
-
-
-
-
-
-
搜索结果
84 条记录 (耗时 0.027 秒)
