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

1. 发明授权

US07693860B2 Method and system to associate cell and item metadata 失效
标题翻译：关联单元格和项目元数据的方法和系统
公开(公告)号：US07693860B2
公开(公告)日：2010-04-06
申请号：US11083492
申请日：2005-03-18
申请人： Alexander A. Babanov , Charles D. Ellis , Howard J. Dickerman , Robert G. Hawking
发明人： Alexander A. Babanov , Charles D. Ellis , Howard J. Dickerman , Robert G. Hawking
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/246 , G06F17/241
摘要： The present invention generally relates to new and improved embodiments of methods and systems for capturing and providing arbitrarily rich data to be stored or manipulated within a spreadsheet. In one embodiment of the present invention, a method for creating spreadsheet metadata comprises receiving an item in a spreadsheet, receiving item metadata about the item, and associating the item metadata with the item to create spreadsheet metadata.
摘要翻译：本发明一般涉及用于捕获并提供要在电子表格内存储或操纵的任意丰富的数据的方法和系统的新的和改进的实施例。在本发明的一个实施例中，用于创建电子表格元数据的方法包括：接收电子表格中的项目，接收关于该项目的项目元数据，以及将该项目元数据与该项目相关联以创建电子表格元数据。

2. 发明授权

US07584265B2 Instant messaging session invite for arranging peer-to-peer communication between applications 失效
标题翻译：即时消息会话邀请，用于安排应用程序之间的对等通信
公开(公告)号：US07584265B2
公开(公告)日：2009-09-01
申请号：US11751556
申请日：2007-05-21
申请人： Howard J. Dickerman , Benjamin A. Mejia
发明人： Howard J. Dickerman , Benjamin A. Mejia
IPC分类号： G06F15/16
CPC分类号： H04L67/22 , H04L51/04 , H04L67/14
摘要： Arrangements and procedures for arranging peer-to-peer communications sessions between applications are described. In one implementation, a first application executing at a first device utilizes online presence information of an instant messaging service to select a second application with which to engage in the peer-to-peer session. The second application is associated with a second device and registered with the instant messaging service as being peer-to-peer session invite capable. The first application arranges the peer-to-peer session via components of the instant messaging service. The arranged peer-to-peer session is functionally independent of the instant messaging service.
摘要翻译：描述了在应用程序之间安排对等通信会话的安排和步骤。在一个实现中，在第一设备上执行的第一应用利用即时消息接发服务的在线呈现信息来选择与其进行对等会话的第二应用。第二应用与第二设备相关联，并且与即时消息服务一起注册为具有对等会话邀请能力。第一个应用程序通过即时消息服务的组件来排列对等会话。安排的对等会话在功能上独立于即时消息服务。

3. 发明授权

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.
摘要翻译：公开了接收和处理数据分析表达式的方法和系统。特定的方法包括在电子表格的枢轴表处接收数据分析表达式。通过确定与特定小区关联的上下文，基于上下文计算数据分析表达式的值，并且在特定小区处输出计算的值，对于枢纽表的特定小区执行数据分析表达式。

4. 发明申请

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.
摘要翻译：公开了接收和处理数据分析表达式的方法和系统。特定的方法包括在电子表格的枢轴表处接收数据分析表达式。通过确定与特定小区关联的上下文，基于上下文计算数据分析表达式的值，并且在特定小区处输出计算的值，对于枢纽表的特定小区执行数据分析表达式。

5. 发明申请

US20100312748A1 MULTIDIMENSIONAL CUBE FUNCTIONS 审中-公开
标题翻译：多维CUBE功能
公开(公告)号：US20100312748A1
公开(公告)日：2010-12-09
申请号：US12852235
申请日：2010-08-06
申请人： Howard J. Dickerman , Brian W. Boon , Charles D. Ellis , Kaicheng Hu , Robert G. Hawking
发明人： Howard J. Dickerman , Brian W. Boon , Charles D. Ellis , Kaicheng Hu , Robert G. Hawking
IPC分类号： G06F17/30
CPC分类号： G06F17/246 , G06F16/283
摘要： Cube functions may be used to obtain data from a multidimensional database. The cube functions may be contained within one or more cells of a spreadsheet. These cube functions behave similarly to the standard functions that may be included within a spreadsheet. Exemplary cube functions include obtaining: a cube member, a cube value, a cube set, a ranked member, a KPI, a member property and a count relating to a set. The cube functions within the spreadsheet may access the cube data from one or more multidimensional databases. Using the cube formulas in individual cells allows the user to add/delete rows and/or columns from within the spreadsheet.
摘要翻译：多维数据集函数可用于从多维数据库获取数据。多维数据集函数可以包含在电子表格的一个或多个单元格内。这些立方体函数的行为与可能包含在电子表格中的标准函数类似。示例性立方体功能包括获得：立方体成员，立方体值，多维数据集，排名成员，KPI，成员属性和与集合有关的计数。电子表格中的多维数据集功能可以从一个或多个多维数据库访问多维数据集数据。在单个单元格中使用多维数据集公式允许用户从电子表格中添加/删除行和/或列。

6. 发明授权

US07792847B2 Converting structured reports to formulas 失效
标题翻译：将结构化报告转换为公式
公开(公告)号：US07792847B2
公开(公告)日：2010-09-07
申请号：US11268048
申请日：2005-11-07
申请人： Howard J. Dickerman , Kaicheng Hu , Robert G. Hawking
发明人： Howard J. Dickerman , Kaicheng Hu , Robert G. Hawking
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/246 , G06F17/30554 , G06F17/30592 , Y10S707/957
摘要： Data corresponding to a structured report or multi-dimensional presentation is converted to formulas within cells of a spreadsheet. The cell formulas operate on a multi-dimension database that was the data source for the structured report. Therefore the layout of the data in the cells is similar to the layout of the data in structured report. The user is able to move the formulas around in the spreadsheet resulting in any custom layout the user desires. Because the data is no longer in a structured report, it is no longer subject to the layout restrictions of the report.
摘要翻译：与结构化报表或多维表现相对应的数据将转换为电子表格单元格内的公式。单元格公式在作为结构化报表的数据源的多维数据库上运行。因此，单元格中的数据布局与结构化报表中数据的布局相似。用户能够在电子表格中移动公式，导致用户期望的任何自定义布局。由于数据不再在结构化报表中，因此不再受报表的布局限制。

7. 发明申请

US20070168323A1 Query aggregation 审中-公开
标题翻译：查询聚合
公开(公告)号：US20070168323A1
公开(公告)日：2007-07-19
申请号：US11325372
申请日：2006-01-03
申请人： Howard J. Dickerman , Kaicheng Hu
发明人： Howard J. Dickerman , Kaicheng Hu
IPC分类号： G06F17/30
CPC分类号： G06F16/24556
摘要： An aggregated query is used to fetch data from a multidimensional database, such as an OLAP cube. The aggregated query combines individual queries that are used to fetch data from the multidimensional database into a single query. A determination is made as to what dimensions and hierarchies of the multidimensional database are used by the queries that are contained as cube functions within formulas in cells of a spreadsheet. Based on the dimensions and hierarchies that are used within the multidimensional database, a tuple for each of the individual queries is created that has the same dimensionality. These tuples having the same dimensionality are then combined to create the aggregated query.
摘要翻译：聚合查询用于从多维数据库（如OLAP多维数据集）中提取数据。聚合查询将用于从多维数据库中获取数据的单个查询组合成单个查询。确定在电子表格的单元格中的公式中作为多维数据集函数包含的查询使用多维数据库的维度和层次结构。基于在多维数据库中使用的维度和层次结构，创建具有相同维度的每个单独查询的元组。然后组合具有相同维度的这些元组以创建聚合查询。

8. 发明授权

US07233979B2 Instant messaging session invite for arranging peer-to-peer communication between applications 失效
标题翻译：即时消息会话邀请，用于安排应用程序之间的对等通信
公开(公告)号：US07233979B2
公开(公告)日：2007-06-19
申请号：US10172716
申请日：2002-06-14
申请人： Howard J. Dickerman , Benjamin A. Mejia
发明人： Howard J. Dickerman , Benjamin A. Mejia
IPC分类号： G06F15/16
CPC分类号： H04L67/22 , H04L51/04 , H04L67/14
摘要： Arrangements and procedures for arranging peer-to-peer communications sessions between applications are described. In one implementation, a first application executing at a first device utilizes online presence information of an instant messaging service to select a second application with which to engage in the peer-to-peer session. The second application is associated with a second device and registered with the instant messaging service as being peer-to-peer session invite capable. The first application arranges the peer-to-peer session via components of the instant messaging service. The arranged peer-to-peer session is functionally independent of the instant messaging service.
摘要翻译：描述了在应用程序之间安排对等通信会话的安排和步骤。在一个实现中，在第一设备上执行的第一应用利用即时消息接发服务的在线呈现信息来选择与其进行对等会话的第二应用。第二应用与第二设备相关联，并且与即时消息服务一起注册为具有对等会话邀请能力。第一个应用程序通过即时消息服务的组件来排列对等会话。安排的对等会话在功能上独立于即时消息服务。

9. 发明授权

US08234293B2 Autocompleting with queries to a database 有权
标题翻译：自动完成对数据库的查询
公开(公告)号：US08234293B2
公开(公告)日：2012-07-31
申请号：US11222928
申请日：2005-09-08
申请人： Alexander Martynov , David F. Gainer , Howard J. Dickerman
发明人： Alexander Martynov , David F. Gainer , Howard J. Dickerman
IPC分类号： G06F17/30 , G06F17/00 , G06F17/20
CPC分类号： G06F17/3064 , G06F17/246 , G06F17/276
摘要： An autocomplete method and system provides suggested completions for partial data entries based upon predefined coordinates, operands and/or commands. In one embodiment, the partial data entry may be in an active cell of a spreadsheet and the predefined coordinates may be queried from a separate, preconfigured, multi-dimensional database linked to the active cell or the spreadsheet.
摘要翻译：自动完成方法和系统根据预定义的坐标，操作数和/或命令提供部分数据条目的建议完成。在一个实施例中，部分数据条目可以在电子表格的活动单元中，并且可以从链接到活动单元或电子表格的单独的，预配置的多维数据库中查询预定坐标。

10. 发明授权

US07805433B2 Multidimensional cube functions 有权
标题翻译：多维立方体函数
公开(公告)号：US07805433B2
公开(公告)日：2010-09-28
申请号：US11251598
申请日：2005-10-14
申请人： Howard J. Dickerman , Brian W. Boon , Charles D. Ellis , Kaicheng Hu , Robert G. Hawking
发明人： Howard J. Dickerman , Brian W. Boon , Charles D. Ellis , Kaicheng Hu , Robert G. Hawking
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30592 , G06F17/246
摘要： Cube functions may be used to obtain data from a multidimensional database. The cube functions may be contained within one or more cells of a spreadsheet. These cube functions behave similarly to the standard functions that may be included within a spreadsheet. Exemplary cube functions include obtaining: a cube member, a cube value, a cube set, a ranked member, a KPI, a member property and a count relating to a set. The cube functions within the spreadsheet may access the cube data from one or more multidimensional databases. Using the cube formulas in individual cells allows the user to add/delete rows and/or columns from within the spreadsheet.
摘要翻译：多维数据集函数可用于从多维数据库获取数据。多维数据集函数可以包含在电子表格的一个或多个单元格内。这些立方体函数的行为与可能包含在电子表格中的标准函数类似。示例性立方体功能包括获得：立方体成员，立方体值，多维数据集，排名成员，KPI，成员属性和与集合有关的计数。电子表格中的多维数据集功能可以从一个或多个多维数据库访问多维数据集数据。在单个单元格中使用多维数据集公式允许用户从电子表格中添加/删除行和/或列。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式