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

21. 发明申请

US20100030748A1 EFFICIENT LARGE-SCALE PROCESSING OF COLUMN BASED DATA ENCODED STRUCTURES 有权
标题翻译：基于列的数据编码结构的有效的大规模处理
公开(公告)号：US20100030748A1
公开(公告)日：2010-02-04
申请号：US12270872
申请日：2008-11-14
申请人： Amir Netz , Cristian Petculescu
发明人： Amir Netz , Cristian Petculescu
IPC分类号： G06F7/06 , G06F17/30
CPC分类号： G06F17/30492
摘要： The subject disclosure relates to efficient query processing over large scale data storage. An exemplary process includes retrieving a subset of columns implicated by a query as integer encoded and compressed sequences of values corresponding to different columns of data, defining query processing buckets that span over the subset of columns based on changes of compression type occurring in the integer encoded and compressed sequences of values of the subset of data and processing the query in memory on a bucket by bucket basis and processing the query based on type of current bucket when processing the integer encoded and compressed sequences of values. The column based organization of the data, and the application of a hybrid run length encoding and bit packing technique, enable a highly efficient and speedy query response in real-time.
摘要翻译：本公开涉及对大规模数据存储的有效查询处理。示例性过程包括：将查询所涉及的列的子集作为对应于不同数据列的整数编码和压缩的值序列，基于经整数编码的压缩类型的变化定义跨越列的子集的查询处理桶以及数据子集的值的压缩序列，并且逐桶地处理存储器中的查询，并且当处理整数编码和压缩的值序列时，基于当前存储桶的类型来处理查询。数据的基于列的组织以及混合运行长度编码和位打包技术的应用实现了高效和快速的查询响应。

22. 发明授权

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系统中的关系数据库中的数据的数据模型利用多层次维度。维度包含一组属性。每个属性绑定到关系数据库中的一列。定义了逻辑结构，指示属性之间的关系。定义层次结构。每个层次结构包括一系列属性。层次结构提供了数据库用户可以利用来访问数据库的通用的下拉路径。层次结构可以包括单个属性或属性的组合。属性和层次结构中的属性序列之间的关系都是独立于与数据库关联的任何限制来定义的。

23. 发明授权

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.
摘要翻译：公开了一种用于根据非参考属性组织的分析建模数据的系统和方法。存储在第一和第二关系数据表中的数据在数据立方体中被分析地建模。第一个表根据第一个属性组织第一个类型。第二表根据第一属性和第二属性组织第二类。第一个度量根据第一个表的第一个类型进行建模。根据第一和第二表的第一属性对第一维进行建模。根据第二表的第二属性对第二维进行建模。根据第一表的第一个属性，第一个度量与第一个维度相关联，以便根据第一个属性对第一个维度进行第一个维度的分析。对于第一维度的每个条目，第一尺度与第二维度相关联，以预定方式将条目分配给第二维度的每个条目。

24. 发明申请

US20060024653A1 Method, system, and apparatus for exposing workbooks as data sources 有权
标题翻译：用于将工作簿暴露为数据源的方法，系统和装置
公开(公告)号：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.
摘要翻译：提供了一种方法，系统和装置，用于将工作簿作为服务器数据源进行曝光和利用。该系统包括能够执行用于创建包括一个或多个工作表的工作簿的电子表格应用程序的客户端计算机。工作簿可以被发布到服务器计算机，其中工作簿的内容作为多维数据源被公开。服务器计算机允许客户端应用程序作为多维数据源（如多维数据集）发现和连接到工作簿。

25. 发明申请

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.
摘要翻译：便于分析多维结构的内容的系统包括计算组件，其以与分配和计算中的一个或多个相关的声明语言接收语句，并针对多维结构执行这些语句。通过生成组件创建一个通行证，以便在执行语句之前保持多维结构的内容，因为在参考此类通过时可以访问该通行证。

26. 发明授权

US08626725B2 Efficient large-scale processing of column based data encoded structures 有权
标题翻译：基于列的数据编码结构的高效大规模处理
公开(公告)号：US08626725B2
公开(公告)日：2014-01-07
申请号：US12270872
申请日：2008-11-14
申请人： Amir Netz , Cristian Petculescu
发明人： Amir Netz , Cristian Petculescu
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30492
摘要： The subject disclosure relates to efficient query processing over large scale data storage. An exemplary process includes retrieving a subset of columns implicated by a query as integer encoded and compressed sequences of values corresponding to different columns of data, defining query processing buckets that span over the subset of columns based on changes of compression type occurring in the integer encoded and compressed sequences of values of the subset of data and processing the query in memory on a bucket by bucket basis and processing the query based on type of current bucket when processing the integer encoded and compressed sequences of values. The column based organization of the data, and the application of a hybrid run length encoding and bit packing technique, enable a highly efficient and speedy query response in real-time.
摘要翻译：本公开涉及对大规模数据存储的有效查询处理。示例性过程包括：将查询所涉及的列的子集作为对应于不同数据列的整数编码和压缩的值序列，基于经整数编码的压缩类型的变化来定义跨越列的子集的查询处理桶以及数据子集的值的压缩序列，并且逐桶地处理存储器中的查询，并且当处理整数编码和压缩的值序列时，基于当前存储桶的类型来处理查询。数据的基于列的组织以及混合运行长度编码和位打包技术的应用实现了高效和快速的查询响应。

27. 发明授权

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.
摘要翻译：本发明涉及与事实维度相互作用的系统和方法。特别地，公开了关于处理涉及事实维度的查询的性能和可扩展性的系统和方法。此外，可以以不同的方式评估涉及事实维度的查询。例如，可以处理查询，使得常规维度限制数据的范围，并且仅暴露与该范围相关的事实维度成员。

28. 发明申请

US20100030796A1 EFFICIENT COLUMN BASED DATA ENCODING FOR LARGE-SCALE DATA STORAGE 有权
标题翻译：基于高效数据编码的大规模数据存储
公开(公告)号：US20100030796A1
公开(公告)日：2010-02-04
申请号：US12270873
申请日：2008-11-14
申请人： Amir Netz , Cristian Petculescu , Ioan Bogdan Crivat
发明人： Amir Netz , Cristian Petculescu , Ioan Bogdan Crivat
IPC分类号： G06F17/00
CPC分类号： G06F17/30501 , G06F17/30315 , H03M7/30 , H03M7/48
摘要： The subject disclosure relates to column based data encoding where raw data to be compressed is organized by columns, and then, as first and second layers of reduction of the data size, dictionary encoding and/or value encoding are applied to the data as organized by columns, to create integer sequences that correspond to the columns. Next, a hybrid greedy run length encoding and bit packing compression algorithm further compacts the data according to an analysis of bit savings. Synergy of the hybrid data reduction techniques in concert with the column-based organization, coupled with gains in scanning and querying efficiency owing to the representation of the compact data, results in substantially improved data compression at a fraction of the cost of conventional systems.
摘要翻译：本公开涉及基于列的数据编码，其中待压缩的原始数据由列组织，然后作为数据大小的第一和第二层缩减，字典编码和/或值编码被应用于由列，以创建与列相对应的整数序列。接下来，混合贪婪跑步长度编码和位打包压缩算法根据比特节省的分析进一步压缩数据。混合数据简化技术与基于列的组织协调一致，加上由于表示紧凑数据而在扫描和查询效率方面的增益，导致数据压缩大大提高了传统系统成本的一小部分。

29. 发明授权

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）引擎。

30. 发明授权

US07117218B2 System and method for expressing and calculating a relationship between measures 有权
标题翻译：用于表达和计算措施之间关系的系统和方法
公开(公告)号：US07117218B2
公开(公告)日：2006-10-03
申请号：US10607087
申请日：2003-06-26
申请人： Richard Tkachuk , Cristian Petculescu , Amir Netz
发明人： Richard Tkachuk , Cristian Petculescu , Amir Netz
IPC分类号： G06F7/00
CPC分类号： G06F17/30333 , Y10S707/99933
摘要： A measure expression may include a relationship between measures defined by an arithmetic operation. A query may request a calculation of the measure expression over a selected range of attributes. The request may be processed by retrieving all rows comprising data within the selected range of attributes for each measure in the expression through a single access to an associated table.
摘要翻译：测量表达式可以包括由算术运算定义的度量之间的关系。查询可以请求在所选范围的属性上计算度量表达式。该请求可以通过对表达式中的每个度量的所选范围的属性中包含数据的单个访问来检索所有行。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式