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

21. 发明申请

US20060020933A1 Multidimensional database query extension systems and methods 有权
标题翻译：多维数据库查询扩展系统和方法
公开(公告)号：US20060020933A1
公开(公告)日：2006-01-26
申请号：US11116924
申请日：2005-04-28
申请人： Mosha Pasumansky , Irina Gorbach , Alexander Balikov , Alexander Berger , Marius Dumitru , Thomas Conlon
发明人： Mosha Pasumansky , Irina Gorbach , Alexander Balikov , Alexander Berger , Marius Dumitru , Thomas Conlon
IPC分类号： G06F9/45
CPC分类号： G06F17/30592 , Y10S707/957
摘要： The subject invention pertains to the integration of an object model and a multidimensional database query language such as MDX. In particular, multidimensional declarative query language entities can be exposed through objects in an object model. The object model enables generation and employment of procedural language functions, routines, or procedures that interact with multidimensional database data. This effectively provides an extension for multidimensional query languages. For example, procedures can be stored and invoked from a declarative language query. Furthermore, the object model disclosed herein can expose a context object to enable conditional procedures based on the context of execution.
摘要翻译：本发明涉及对象模型和诸如MDX的多维数据库查询语言的集成。特别地，可以通过对象模型中的对象来公开多维声明式查询语言实体。对象模型可以生成和使用与多维数据库数据交互的过程语言函数，例程或过程。这有效地为多维查询语言提供了扩展。例如，可以从声明性语言查询中存储和调用过程。此外，本文公开的对象模型可以暴露上下文对象以基于执行的上下文来启用条件过程。

22. 发明授权

US07958122B2 Data domains in multidimensional databases 有权
标题翻译：多维数据库中的数据域
公开(公告)号：US07958122B2
公开(公告)日：2011-06-07
申请号：US12042707
申请日：2008-03-05
申请人： Mosha Pasumansky , Alexander Berger , Dmitry Berger , Irina Gorbach , Marius Dumitru
发明人： Mosha Pasumansky , Alexander Berger , Dmitry Berger , Irina Gorbach , Marius Dumitru
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30592
摘要： Systems and method for creating multidimensional data cubes containing data domains for analyzing large amounts of data are provided. Data domains may be included in the major object of a multidimensional data cube. Further embodiments of the present invention provide methods for querying multidimensional data cubes having data domains. Embodiments of the present invention provide for defining data domains by any object in the major object model and for defining parent and child data domains.
摘要翻译：提供了用于创建包含用于分析大量数据的数据域的多维数据立方体的系统和方法。数据域可以包含在多维数据立方体的主要对象中。本发明的另外的实施例提供了用于查询具有数据域的多维数据立方体的方法。本发明的实施例提供了通过主要对象模型中的任何对象定义数据域并且用于定义父和子数据域。

23. 发明申请

US20060053091A1 Extensions for query persistence across requests with dynamic update for writeback 有权
标题翻译：用于回写动态更新的请求之间的查询持久性扩展
公开(公告)号：US20060053091A1
公开(公告)日：2006-03-09
申请号：US10922517
申请日：2004-08-20
申请人： Marius Dumitru , Mosha Pasumansky , Raman Iyer , Thomas Conlon
发明人： Marius Dumitru , Mosha Pasumansky , Raman Iyer , Thomas Conlon
IPC分类号： G06F17/30
CPC分类号： G06F17/3048 , G06F17/30433 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： A method is described herein for causing an analytical database server to store query results in a memory. In the method, a first header element and a request to query an analytical database is received. The first header element indicates that a query result should be stored. The analytical database is queried according to the request, and the query result is stored. An identifier associated with the query result and a second header element corresponding to the identifier is then transmitted.
摘要翻译：本文描述了一种使分析数据库服务器将查询结果存储在存储器中的方法。在该方法中，接收第一标题元素和查询分析数据库的请求。第一个头元素表示应该存储查询结果。根据请求查询分析数据库，并存储查询结果。然后发送与查询结果相关联的标识符和对应于标识符的第二标题元素。

24. 发明授权

US07328207B2 Extensions for query persistence across requests with dynamic update for writeback 有权
标题翻译：用于回写动态更新的请求之间的查询持久性扩展
公开(公告)号：US07328207B2
公开(公告)日：2008-02-05
申请号：US10922517
申请日：2004-08-20
申请人： Marius Dumitru , Mosha Pasumansky , Raman Iyer , Thomas P. Conlon
发明人： Marius Dumitru , Mosha Pasumansky , Raman Iyer , Thomas P. Conlon
IPC分类号： G06F17/30 , G06F15/16
CPC分类号： G06F17/3048 , G06F17/30433 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： A method is described herein for causing an analytical database server to store query results in a memory. In the method, a first header element and a request to query an analytical database is received. The first header element indicates that a query result should be stored. The analytical database is queried according to the request, and the query result is stored. An identifier associated with the query result and a second header element corresponding to the identifier is then transmitted.
摘要翻译：本文描述了一种使分析数据库服务器将查询结果存储在存储器中的方法。在该方法中，接收第一标题元素和查询分析数据库的请求。第一个头元素表示应该存储查询结果。根据请求查询分析数据库，并存储查询结果。然后发送与查询结果相关联的标识符和对应于标识符的第二标题元素。

25. 发明申请

US20060020921A1 Data cube script development and debugging systems and methodologies 有权
标题翻译：数据立方体脚本开发和调试系统和方法
公开(公告)号：US20060020921A1
公开(公告)日：2006-01-26
申请号：US11133557
申请日：2005-05-20
申请人： Mosha Pasumansky , Marius Dumitru , Robert Zare , Andriy Garbuzov , Richard Tkachuk
发明人： Mosha Pasumansky , Marius Dumitru , Robert Zare , Andriy Garbuzov , Richard Tkachuk
IPC分类号： G06F9/44
CPC分类号： G06F11/3636
摘要： The subject invention pertains to systems and methods that facilitate development and debugging of calculations in a multidimensional data environment or model. Data cube calculation scripts, including those provided in MDX (Multidimensional Expressions), can be executed or applied incrementally. Breakpoints can be set with respect to a calculation script and the cube state can be viewed and queried via a user interface. Users are enabled by the subject systems and methods to step through calculation scripts, identify the effects on a cube, and alter the script if the desired results failed to occur. In addition to debugging, the systems and methods can be employed for initial development of scripts.
摘要翻译：本发明涉及促进在多维数据环境或模型中计算的开发和调试的系统和方法。包括MDX（多维表达式）中提供的数据立方体计算脚本可以逐步执行或应用。可以针对计算脚本设置断点，并且可以通过用户界面查看和查询多维数据集状态。用户通过主题系统和方法来启用逐步计算脚本，识别对多维数据集的影响，如果所需的结果未能发生，则更改脚本。除了调试之外，系统和方法可以用于脚本的初始开发。

26. 发明授权

US09275031B2 Data analysis expressions 有权
标题翻译：数据分析表达式
公开(公告)号：US09275031B2
公开(公告)日：2016-03-01
申请号：US12576254
申请日：2009-10-09
申请人： Howard J. Dickerman , Marius Dumitru , Akshai Mirchandani , Yutong (Jeffrey) Wang , Amir Netz , Paul J. Sanders
发明人： Howard J. Dickerman , Marius Dumitru , Akshai Mirchandani , Yutong (Jeffrey) Wang , Amir Netz , Paul J. Sanders
IPC分类号： G06F17/00 , G06F17/24
CPC分类号： G06F17/246
摘要： Methods and systems are disclosed for receiving and processing data analysis expressions. A particular method includes receiving a data analysis expression at a pivot table of a spreadsheet. The data analysis expression is executed for a particular cell of the pivot table by determining a context associated with the particular cell, calculating a value of the data analysis expression based on the context, and outputting the calculated value at the particular cell.
摘要翻译：公开了接收和处理数据分析表达式的方法和系统。特定的方法包括在电子表格的枢轴表处接收数据分析表达式。通过确定与特定小区关联的上下文，基于上下文计算数据分析表达式的值，并且在特定小区处输出计算的值，对于枢纽表的特定小区执行数据分析表达式。

27. 发明申请

US20110087954A1 DATA ANALYSIS EXPRESSIONS 有权
标题翻译：数据分析表达
公开(公告)号：US20110087954A1
公开(公告)日：2011-04-14
申请号：US12576254
申请日：2009-10-09
申请人： Howard J. Dickerman , Marius Dumitru , Akshai Mirchandani , Yutong (Jeffrey) Wang , Amir Netz , Paul J. Sanders
发明人： Howard J. Dickerman , Marius Dumitru , Akshai Mirchandani , Yutong (Jeffrey) Wang , Amir Netz , Paul J. Sanders
IPC分类号： G06F17/00 , G06F12/02
CPC分类号： G06F17/246
摘要： Methods and systems are disclosed for receiving and processing data analysis expressions. A particular method includes receiving a data analysis expression at a pivot table of a spreadsheet. The data analysis expression is executed for a particular cell of the pivot table by determining a context associated with the particular cell, calculating a value of the data analysis expression based on the context, and outputting the calculated value at the particular cell.
摘要翻译：公开了接收和处理数据分析表达式的方法和系统。特定的方法包括在电子表格的枢轴表处接收数据分析表达式。通过确定与特定小区关联的上下文，基于上下文计算数据分析表达式的值，并且在特定小区处输出计算的值，对于枢纽表的特定小区执行数据分析表达式。

28. 发明申请

US20160232203A1 SPECIFICATION OF DATABASE TABLE RELATIONSHIPS FOR CALCULATION 审中-公开
标题翻译：数据表规格表计算关系
公开(公告)号：US20160232203A1
公开(公告)日：2016-08-11
申请号：US15134124
申请日：2016-04-20
申请人： Howard Dickerman , Vjacheslav Min , Marius Dumitru
发明人： Howard Dickerman , Vjacheslav Min , Marius Dumitru
IPC分类号： G06F17/30
CPC分类号： G06F17/30421 , G06F17/3056 , G06F17/30595 , G06F17/30955
摘要： A relationship amongst multiple relationships between database tables can be specified independent of a query. More specifically, a function (USERELATIONSHIP) can be introduced to the DAX language (Data Analysis Expressions), which provides a way to author formulas that are not evaluated immediately, but that can be evaluated dynamically and concurrently in many different contexts. The function enables a single relationship to be specified in the calculation formula away from the query. This provides a mechanism within the formula that specifies specific relationship(s) that are to be followed when the dynamic expression is evaluated.
摘要翻译：可以独立于查询来指定数据库表之间的多个关系之间的关系。更具体地说，可以将DAX语言（数据分析表达式）中的函数（USERELATIONSHIP）引入到数据分析表达式中，该方法可以为不能立即评估的公式进行编写，但可以在许多不同的上下文中动态和并发地进行评估。该功能可以在计算公式中指定单个关系，远离查询。这提供了公式中的机制，指定了在评估动态表达式时要遵循的特定关系。

29. 发明授权

US08645346B2 Composable SQL query generation 有权
标题翻译：可组合的SQL查询生成
公开(公告)号：US08645346B2
公开(公告)日：2014-02-04
申请号：US13161522
申请日：2011-06-16
申请人： Marius Dumitru , Jeffrey Wang
发明人： Marius Dumitru , Jeffrey Wang
IPC分类号： G06F17/30
CPC分类号： G06F17/30427 , G06F17/30545
摘要： A system and method for facilitating querying one or more data sources. A system provides mechanisms to enable flexible specification of user queries and generation of one or more SQL queries that correspond closely to corresponding user queries. An operator tree and a logical operator tree may be created as intermediate steps to generate the one or more SQL queries. Capabilities of data sources are determined and used to generate remotable SQL queries for composable queries, to reduce an amount of post-processing that is performed on result sets. The system enables user queries that extend beyond those defined by a data model.
摘要翻译：一种便于查询一个或多个数据源的系统和方法。系统提供了使用户能够灵活地指定用户查询并生成与相应用户查询密切对应的一个或多个SQL查询的机制。可以创建运算符树和逻辑运算符树作为生成一个或多个SQL查询的中间步骤。确定数据源的能力并用于为可组合查询生成可远程SQL查询，以减少对结果集执行的后处理量。该系统允许超出数据模型定义的用户查询。

30. 发明授权

US08108399B2 Filtering of multi attribute data via on-demand indexing 有权
标题翻译：通过按需索引过滤多个属性数据
公开(公告)号：US08108399B2
公开(公告)日：2012-01-31
申请号：US11750754
申请日：2007-05-18
申请人： Marius Dumitru , Eric DeVerne Jacobsen
发明人： Marius Dumitru , Eric DeVerne Jacobsen
IPC分类号： G06F7/00
CPC分类号： G06F17/30312 , G06F17/30336
摘要： Systems and methods that employ auxiliary data structures in form of indexes (e.g., slice indexes) to process incoming queries in query retrieval systems (e.g., Online Analytical Processing (OLAP) environments.) The indexing component analyzes attributes involved in predicate conditions of filter requests to form slice indexes for same filtering criteria, wherein resulting data set share the same filtering criteria in form of attributes. The indexes of the subject innovation can be created on-the-fly, and typically without intervention by system administrators.
摘要翻译：采用索引形式的辅助数据结构（例如片段索引）来处理查询检索系统中的传入查询（例如在线分析处理（OLAP）环境）的系统和方法）。索引组件分析过滤器请求的谓词条件中涉及的属性以形成相同过滤条件的切片索引，其中生成的数据集以属性的形式共享相同的过滤标准。可以即时创建主题创新的指标，通常不需要系统管理员的干预。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式