公开(公告)号：US08051373B2

公开(公告)日：2011-11-01

申请号：US11326892

申请日：2006-01-06

申请人： Chad Rothschiller ,  Michael J. McCormack ,  Ramakrishnan Natarajan

发明人： Chad Rothschiller ,  Michael J. McCormack ,  Ramakrishnan Natarajan

IPC分类号： G06F17/00

CPC分类号： G06F17/227 ,  G06F17/2247 ,  G06F17/24 ,  Y10S707/99943

摘要： A method and system are provided for converting a hierarchical data structure into a flat data structure based on a schema. The format of the hierarchical data structure may be XML. A hierarchical data structure conforming to a schema is loaded into an application program. The data structure includes elements and attributes linked together in a parent-child relationship. The schema defines the hierarchical relationships between the elements and attributes in the hierarchical data structure. After the hierarchical data structure conforming to the schema has been loaded, a plurality of layout rules is applied to the hierarchical data based on the schema to create a flat data structure. The layout rules determine how the hierarchical data will be inserted in the flat data structure. The layout rules may be applied by identifying properties in the schema which identify occurrence requirements for elements defined in the schema. After the layout rules have been applied to the hierarchical data, the hierarchical data is rendered into a spreadsheet by inserting the data in rows and columns.

摘要翻译： 提供了一种基于模式将层次数据结构转换为平面数据结构的方法和系统。 层次数据结构的格式可以是XML。 符合模式的分层数据结构被加载到应用程序中。 数据结构包括在父子关系中链接在一起的元素和属性。 该模式定义了分层数据结构中的元素和属性之间的分层关系。 在已经加载了符合模式的分层数据结构之后，基于模式将多个布局规则应用于分层数据，以创建平面数据结构。 布局规则确定分层数据将如何插入平面数据结构中。 可以通过标识模式中的属性来识别布局规则，以识别模式中定义的元素的出现要求。 在将布局规则应用于层次数据之后，通过以数据行和列的形式插入数据，将分层数据呈现为电子表格。

公开(公告)号：US07640493B2

公开(公告)日：2009-12-29

申请号：US11337942

申请日：2006-01-23

申请人： Robert Collie ,  Chad Rothschiller ,  Ulrich Homann ,  Joseph Chirilov ,  Kelly J. Lynch ,  Ramakrishnan Natarajan ,  Eoin Burke ,  Juha Niemisto ,  Michael J. McCormack ,  Parul Dalia ,  Marise Chan ,  James Rivera

发明人： Robert Collie ,  Chad Rothschiller ,  Ulrich Homann ,  Joseph Chirilov ,  Kelly J. Lynch ,  Ramakrishnan Natarajan ,  Eoin Burke ,  Juha Niemisto ,  Michael J. McCormack ,  Parul Dalia ,  Marise Chan ,  James Rivera

IPC分类号： G06F15/00 ,  G06F17/21 ,  G06F17/24

CPC分类号： G06F17/2229 ,  Y10S707/99931 ,  Y10S707/99943

摘要： Extensible markup language data in an extensible markup language (such as XML) is associated with a schema file for defining data types and data type definitions for applying data to the document. A map is prepared that relates that any extensible markup data applied to the document back to corresponding elements or attributes defined in the associated schema file. When the document is imported into a spreadsheet application grid, the data map is parsed to find XPATHs which determine the location, data types and user data for each cell or list object in the document related to the schema file. The cells and lists are populated with the extensible markup data and user data, and rendered according to formatting dictated by the extensible markup data applied to the document. The document may be exported such that the extensible markup data is maintained for subsequent import and use.

摘要翻译： 可扩展标记语言（例如XML）中的可扩展标记语言数据与用于定义用于将数据应用于文档的数据类型和数据类型定义的模式文件相关联。 准备了将应用于文档的任何可扩展标记数据返回到相关模式文件中定义的相应元素或属性的映射。 当文档导入到电子表格应用程序网格中时，将解析数据映射以查找XPATH，以确定与模式文件相关的文档中每个单元格或列表对象的位置，数据类型和用户数据。 单元格和列表填充有可扩展标记数据和用户数据，并根据应用于文档的可扩展标记数据指定的格式呈现。 可以导出文档，以便维护可扩展标记数据以供以后导入和使用。

公开(公告)号：US20060112329A1

公开(公告)日：2006-05-25

申请号：US11328042

申请日：2006-01-09

申请人： Robert Collie ,  Chad Rothschiller ,  Ulrich Homann ,  Joseph Chirilov ,  Kelly Lynch ,  Ramakrishnan Natarajan ,  Eoin Burke ,  Juha Niemisto ,  Michael McCormack ,  Parul Dalia ,  Marise Chan ,  James Rivera

发明人： Robert Collie ,  Chad Rothschiller ,  Ulrich Homann ,  Joseph Chirilov ,  Kelly Lynch ,  Ramakrishnan Natarajan ,  Eoin Burke ,  Juha Niemisto ,  Michael McCormack ,  Parul Dalia ,  Marise Chan ,  James Rivera

IPC分类号： G06F17/21 ,  G06F17/24

CPC分类号： G06F17/2229 ,  Y10S707/99931 ,  Y10S707/99943

摘要： Methods and systems are provided for importing markup language formatted data into a spreadsheet document and for exporting markup language formatted data from a spreadsheet document. XML data is associated with an XML schema file defining XML data types and data type definitions for applying XML data to the document. An XML data map is prepared that relates that any XML data applied to the document back to corresponding XML elements or attributes defined in the associated schema file. When the document is imported into a spreadsheet application grid, the data map is parsed to find XPATHs in the imported spreadsheet document of XML data and the user entered data. Each XPATH is executed to determine the location, data types and user data for each cell or list object in the document that is related back to the associated schema file. The cells and lists are populated with the XML data and user data, and the data is rendered in the spreadsheet according to the formatting dictated by the XML data applied to the spreadsheet in association with the XML schema file. After an imported document has been edited, or after a document is created to include the application of XML data in association with a selected XML schema file, the document may be exported such that the XML data applied to the document is maintained for subsequent import and use of the document.

公开(公告)号：US08924314B2

公开(公告)日：2014-12-30

申请号：US13198560

申请日：2011-08-04

申请人： Parashuram Kulkarni ,  Abdelhalim Abbas ,  Michael Mathieson ,  Jingzhou Hua ,  Jon Degenhardt ,  Ramakrishnan Natarajan

发明人： Parashuram Kulkarni ,  Abdelhalim Abbas ,  Michael Mathieson ,  Jingzhou Hua ,  Jon Degenhardt ,  Ramakrishnan Natarajan

IPC分类号： G06F15/18 ,  G06F17/30

CPC分类号： G06F17/3053 ,  G06F17/30864 ,  G06N99/005

摘要： Various embodiments include systems and methods for search result ranking using machine learning. A goal model can be created using machine learning. Responsive to a search query, a plurality of data factors can be inputted into the goal model to create a model output. Search results can be presented to a user based on the model output.

摘要翻译： 各种实施例包括使用机器学习的搜索结果排序的系统和方法。 可以使用机器学习创建目标模型。 响应于搜索查询，可以将多个数据因子输入到目标模型中以创建模型输出。 搜索结果可以根据模型输出呈现给用户。

公开(公告)号：US07954046B2

公开(公告)日：2011-05-31

申请号：US11297978

申请日：2005-12-09

申请人： Robert Collie ,  Chad Rothschiller ,  Ulrich Homann ,  Joseph Chirilov ,  Kelly J. Lynch ,  Ramakrishnan Natarajan ,  Eoin Burke ,  Juha Niemisto ,  Michael J. McCormack ,  Parul Dalia ,  Marise Chan ,  James Rivera

发明人： Robert Collie ,  Chad Rothschiller ,  Ulrich Homann ,  Joseph Chirilov ,  Kelly J. Lynch ,  Ramakrishnan Natarajan ,  Eoin Burke ,  Juha Niemisto ,  Michael J. McCormack ,  Parul Dalia ,  Marise Chan ,  James Rivera

IPC分类号： G06F3/00 ,  G06F17/30

CPC分类号： G06F17/2229 ,  Y10S707/99931 ,  Y10S707/99943

摘要： XML data is associated with an XML schema file defining XML data types and data type definitions for applying XML data to the document. An XML data map is prepared that relates that any XML data applied to the document back to corresponding XML elements or attributes defined in the associated schema file. When the document is imported into a spreadsheet application grid, the data map is parsed to find XPATHs in the imported spreadsheet document of XML data and the user entered data. After an imported document has been edited, or after a document is created to include the application of XML data in association with a selected XML schema file, the document may be exported such that the XML data applied to the document is maintained for subsequent import and use of the document.

摘要翻译： XML数据与定义用于将XML数据应用于文档的XML数据类型和数据类型定义的XML模式文件相关联。 准备XML数据映射，将应用于该文档的任何XML数据与相关模式文件中定义的相应XML元素或属性相关联。 将文档导入电子表格应用程序网格时，将解析数据映射，以在导入的XML数据的电子表格文档中查找XPATH，并输入用户的数据。 在导入的文档被编辑之后，或在创建文档以包括与所选XML模式文件相关联的XML数据的应用程序之后，可以导出该文档，使得应用于该文档的XML数据被维护以供随后导入， 使用文件。

公开(公告)号：US07657571B2

公开(公告)日：2010-02-02

申请号：US11214676

申请日：2005-08-30

申请人： Daniel C. Battagin ,  Ramakrishnan Natarajan

发明人： Daniel C. Battagin ,  Ramakrishnan Natarajan

IPC分类号： G06F17/30 ,  G06F17/00

CPC分类号： G06F17/30893 ,  G06F21/6254

摘要： A snapshot of electronic data is generated to provide information about a file at a specific point in time. The snapshot may be shared between several users. The snapshot is generated based on the type of snapshot that is requested. The snapshot types include a static snapshot, a published item snapshot and an interactive snapshot. Each type of snapshot may hide a portion of the file data from requesting users such that sensitive information is not made available to the users. The static snapshot is generated by saving only static data associated with the file. The interactive snapshot is generated by saving static data associated with the file, but any links or references to dynamic file data are maintained. The published item snapshot includes specific file objects and static data associated with the specified objects.

摘要翻译： 生成电子数据的快照，以在特定时间点提供关于文件的信息。 快照可以在多个用户之间共享。 快照根据请求的快照类型生成。 快照类型包括静态快照，发布的项目快照和交互式快照。 每种类型的快照可能会隐藏文件数据的一部分，从而不向请求用户提供敏感信息，使用户无法使用该敏感信息。 通过仅保存与文件关联的静态数据来生成静态快照。 交互式快照是通过保存与文件关联的静态数据来生成的，但是维护任何链接或对动态文件数据的引用。 发布的项目快照包括与指定对象相关联的特定文件对象和静态数据。

公开(公告)号：US20070050416A1

公开(公告)日：2007-03-01

申请号：US11214676

申请日：2005-08-30

申请人： Daniel Battagin ,  Ramakrishnan Natarajan

发明人： Daniel Battagin ,  Ramakrishnan Natarajan

IPC分类号： G06F17/30

CPC分类号： G06F17/30893 ,  G06F21/6254

摘要： A snapshot of electronic data is generated to provide information about a file at a specific point in time. The snapshot may be shared between several users. The snapshot is generated based on the type of snapshot that is requested. The snapshot types include a static snapshot, a published item snapshot and an interactive snapshot. Each type of snapshot may hide a portion of the file data from requesting users such that sensitive information is not made available to the users. The static snapshot is generated by saving only static data associated with the file. The interactive snapshot is generated by saving static data associated with the file, but any links or references to dynamic file data are maintained. The published item snapshot includes specific file objects and static data associated with the specified objects.

摘要翻译： 生成电子数据的快照，以在特定时间点提供关于文件的信息。 快照可以在多个用户之间共享。 快照根据请求的快照类型生成。 快照类型包括静态快照，发布的项目快照和交互式快照。 每种类型的快照可能会隐藏文件数据的一部分，从而不向请求用户提供敏感信息，使用户无法使用这些敏感信息。 通过仅保存与文件关联的静态数据来生成静态快照。 交互式快照是通过保存与文件关联的静态数据来生成的，但是维护任何链接或对动态文件数据的引用。 发布的项目快照包括与指定对象相关联的特定文件对象和静态数据。

公开(公告)号：US20050108623A1

公开(公告)日：2005-05-19

申请号：US11006980

申请日：2004-12-08

申请人： Jesse Bedford ,  Matthew Gauthier ,  Tuan Huynh ,  Ramakrishnan NataraJan ,  Justin Maguire ,  Marcella Rader

发明人： Jesse Bedford ,  Matthew Gauthier ,  Tuan Huynh ,  Ramakrishnan NataraJan ,  Justin Maguire ,  Marcella Rader

IPC分类号： G06F7/00 ,  G06F15/00 ,  G06F17/24 ,  G06F17/30

CPC分类号： G06F17/246 ,  Y10S707/99942 ,  Y10S707/99943

摘要： The invention, in one embodiment, is a method and system for reporting the status of external references, or links, of a spreadsheet workbook. In an Edit Links dialog box, the user may view a list of links and their status. The user may select a Check Status button in the Edit Links dialog box to check the status of the links without updating the links because updating the links may require considerable time. A textual status message is displayed for each link in the Edit Links dialog box. The textual status message indicates to the user whether there is s possible problem with the link. As part of checking the status of a link, an analysis is made to determine whether any problems with the source file exist. For instance, it is determined whether the source file is open and whether it is valid. The results of this analysis determine what is displayed in the status column of the Edit Links dialog box.

公开(公告)号：US20120197758A1

公开(公告)日：2012-08-02

申请号：US13015362

申请日：2011-01-27

申请人： Qian Zhong ,  Ramakrishnan Natarajan ,  Parashuram Kulkarni ,  Abdelhalim Abbas ,  Zhigang Hua

发明人： Qian Zhong ,  Ramakrishnan Natarajan ,  Parashuram Kulkarni ,  Abdelhalim Abbas ,  Zhigang Hua

IPC分类号： G06Q30/00

CPC分类号： G06Q30/02 ,  G06Q30/0609 ,  G06Q50/01

摘要： A method and a system generate a reputation value for a user in a network-based community. A processor-implemented transaction data collector module collects transaction data of users of a network-based community. A processor-implemented transaction graph generator module generates a transaction graph based on the collected transaction data. The transaction graph has a transaction relationship between two users, and a weight corresponding to the transaction relationship. The weight is representative of a mutually reinforcing relationship between two users. A processor-implemented reputation generator module generates a reputation value for a user from the transaction graph.

摘要翻译： 方法和系统为基于网络的社区中的用户生成信誉值。 处理器实现的交易数据收集器模块收集基于网络的社区的用户的交易数据。 处理器实现的事务图生成器模块基于收集的事务数据生成事务图。 事务图具有两个用户之间的事务关系，并且与事务关系对应的权重。 这个权重代表了两个用户之间相互加强的关系。 处理器实现的信誉发生器模块从事务图形生成用户的信誉值。

公开(公告)号：US07467148B2

公开(公告)日：2008-12-16

申请号：US11006980

申请日：2004-12-08

申请人： Jesse Raymond Bedford ,  Matthew C. Gauthier ,  Tuan E. Huynh ,  Ramakrishnan NataraJan ,  Justin M. Maguire, III ,  Marcella C. S. Rader

发明人： Jesse Raymond Bedford ,  Matthew C. Gauthier ,  Tuan E. Huynh ,  Ramakrishnan NataraJan ,  Justin M. Maguire, III ,  Marcella C. S. Rader

IPC分类号： G06F17/30 ,  G06F7/00

CPC分类号： G06F17/246 ,  Y10S707/99942 ,  Y10S707/99943

摘要： The invention, in one embodiment, is a method and system for reporting the status of external references, or links, of a spreadsheet workbook. In an Edit Links dialog box, the user may view a list of links and their status. The user may select a Check Status button in the Edit Links dialog box to check the status of the links without updating the links because updating the links may require considerable time. A textual status message is displayed for each link in the Edit Links dialog box. The textual status message indicates to the user whether there is s possible problem with the link. As part of checking the status of a link, an analysis is made to determine whether any problems with the source file exist. For instance, it is determined whether the source file is open and whether it is valid. The results of this analysis determine what is displayed in the status column of the Edit Links dialog box.

摘要翻译： 在一个实施例中，本发明是用于报告电子表格工作簿的外部参考或链接的状态的方法和系统。 在“编辑链接”对话框中，用户可以查看链接列表及其状态。 用户可以在“编辑链接”对话框中选择“检查状态”按钮来检查链接的状态，而不更新链接，因为更新链接可能需要相当长的时间。 在“编辑链接”对话框中为每个链接显示文本状态消息。 文本状态消息向用户指示链接是否存在可能的问题。 作为检查链接状态的一部分，进行分析以确定源文件是否存在任何问题。 例如，确定源文件是否打开以及它是否有效。 此分析的结果确定“编辑链接”对话框的状态列中显示的内容。