利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

11 条记录 (耗时 0.032 秒)

    Method and system for inferring a schema from a hierarchical data structure for use in a spreadsheet
    1.
    发明授权
    Method and system for inferring a schema from a hierarchical data structure for use in a spreadsheet 有权
    用于从电子表格中使用的分层数据结构推断模式的方法和系统

    公开(公告)号：US08086959B2

    公开(公告)日：2011-12-27

    申请号：US11326853

    申请日：2006-01-06

    申请人： Chad Rothschiller ,  Michael J. McCormack ,  Eoin Burke ,  Kelly J. Lynch ,  Roy E. Dumas

    发明人： Chad Rothschiller ,  Michael J. McCormack ,  Eoin Burke ,  Kelly J. Lynch ,  Roy E. Dumas

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

    CPC分类号： G06F17/30914

    摘要： A method and system are provided for inferring a schema from an electronic document containing hierarchical data for use in a spreadsheet application program. The electronic document containing the hierarchical data is received into an application program. The application program may be a spreadsheet application program. The format of the hierarchical data structure may be XML. The hierarchical data includes a set of nodes making up the structure of the hierarchical data. The nodes may be XML elements and attributes. The hierarchical data is then parsed to discover one of the nodes in the hierarchical data. Once the node has been discovered, content associated with the discovered node is saved to a memory location in the computer system. The content may include data associated with the discovered node and the type of data associated with the node. The hierarchical data is then parsed again to discover subsequent nodes until the content for all of the nodes has been saved to the memory location. Then a schema generator generates schema elements using complex rules based on the particular qualities of each discovered node for each discovered node until a schema is generated for the hierarchical data.

    摘要翻译： 提供了一种方法和系统，用于从包含用于电子表格应用程序的分层数据的电子文档推断模式。 包含分层数据的电子文档被接收到应用程序中。 应用程序可以是电子表格应用程序。 层次数据结构的格式可以是XML。 分层数据包括组成分层数据结构的一组节点。 节点可以是XML元素和属性。 然后解析分层数据以发现分层数据中的一个节点。 一旦节点被发现，与发现的节点相关联的内容被保存到计算机系统中的存储器位置。 内容可以包括与所发现的节点相关联的数据和与节点相关联的数据的类型。 然后再次分析分层数据以发现后续节点，直到所有节点的内容已经保存到存储器位置。 然后，模式生成器根据每个发现节点的每个发现节点的特定质量，使用复杂规则生成模式元素，直到为分层数据生成模式。

    Method and system for inferring a schema from a hierarchical data structure for use in a spreadsheet
    7.
    发明授权
    Method and system for inferring a schema from a hierarchical data structure for use in a spreadsheet 失效

    公开(公告)号：US06990632B2

    公开(公告)日：2006-01-24

    申请号：US10376781

    申请日：2003-02-28

    申请人： Chad Rothchiller ,  Michael J. McCormack ,  Eoin Burke ,  Kelly J. Lynch ,  Roy E. Dumas

    发明人： Chad Rothchiller ,  Michael J. McCormack ,  Eoin Burke ,  Kelly J. Lynch ,  Roy E. Dumas

    IPC分类号： G06F19/00

    CPC分类号： G06F17/30914

    摘要： A method and system are provided for inferring a schema from an electronic document containing hierarchical data for use in a spreadsheet application program. The electronic document containing the hierarchical data is received into an application program. The application program may be a spreadsheet application program. The format of the hierarchical data structure may be XML. The hierarchical data includes a set of nodes making up the structure of the hierarchical data. The nodes may be XML elements and attributes. The hierarchical data is then parsed to discover one of the nodes in the hierarchical data. Once the node has been discovered, content associated with the discovered node is saved to a memory location in the computer system. The content may include data associated with the discovered node and the type of data associated with the node. The hierarchical data is then parsed again to discover subsequent nodes until the content for all of the nodes has been saved to the memory location. Then a schema generator generates schema elements using complex rules based on the particular qualities of each discovered node for each discovered node until a schema is generated for the hierarchical data.

    Management of markup language data mappings available to a spreadsheet application workbook
    8.
    发明授权
    Management of markup language data mappings available to a spreadsheet application workbook 有权
    管理可用于电子表格应用程序工作簿的标记语言数据映射

    公开(公告)号：US07337182B2

    公开(公告)日：2008-02-26

    申请号：US11214222

    申请日：2005-08-29

    申请人： Chad Rothschiller ,  Kelly J. Lynch ,  Ramakrishnan Natarajan ,  Juha Niemisto ,  Marise Chan ,  Thibaut Vial

    发明人： Chad Rothschiller ,  Kelly J. Lynch ,  Ramakrishnan Natarajan ,  Juha Niemisto ,  Marise Chan ,  Thibaut Vial

    IPC分类号： G06F17/30

    CPC分类号： G06F17/272 ,  G06F17/2247 ,  G06F17/246 ,  G06F17/2725 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99945

    摘要： Methods and systems are provided for managing the application of one or more XML data mappings or one or more XML schema files to a spreadsheet application workbook. One or more XML schema files for associating to the spreadsheet workbook are obtained. Each schema file is iterated to determine if one or more additional schema files are identified in each of the obtained schema files. Each obtained schema is parsed to determine data definitions, elements, attributes, structure, and simple data content required by each schema file for valid XML data. All obtained schema files are combined to create a unified schema definition. A single root element is selected to serve as a root element for the generalized instance structure. A generalized instance structure of the unified schema definition is built representing all available elements, attributes or simple data content of the unified schema definition that may be applied to the spreadsheet application workbook. A tree view of the generalized instance structure is displayed for providing a visual representation of the instance structure of the unified schema definition representing elements, attributes, structure, and simple data content of the XML defined by the unified schema definition that may be validly applied to the spreadsheet workbook according to the generalized instance structure. Writing pointers to the XML map object expresses a relationship between workbook locations and XML elements.

    摘要翻译： 提供了用于管理一个或多个XML数据映射或一个或多个XML模式文件到电子表格应用程序工作簿的应用的方法和系统。 获得用于关联到电子表格工作簿的一个或多个XML模式文件。 迭代每个模式文件以确定在每个获取的模式文件中是否识别到一个或多个附加模式文件。 解析每个获取的模式以确定每个模式文件为有效的XML数据所需的数据定义，元素，属性，结构和简单数据内容。 所有获取的模式文件都被组合以创建统一的模式定义。 选择单个根元素作为广义实例结构的根元素。 构建统一模式定义的通用实例结构，代表可应用于电子表格应用程序工作簿的统一模式定义的所有可用元素，属性或简单数据内容。 显示广义实例结构的树视图，用于提供表示由统一模式定义定义的XML的元素，属性，结构和简单数据内容的统一模式定义的实例结构的可视化表示，可以有效地应用于 电子表格工作簿根据广义实例结构。 写入XML映射对象的指针表示工作簿位置和XML元素之间的关系。

    Markup language visual mapping
    9.
    发明授权
    Markup language visual mapping 失效
    标记语言视觉映射

    公开(公告)号：US07096422B2

    公开(公告)日：2006-08-22

    申请号：US10377256

    申请日：2003-02-28

    申请人： Chad Rothschiller ,  Robert Collie ,  Joseph Chirilov ,  Kelly J. Lynch ,  Ramakrishnan Natarajan ,  Juha Niemisto ,  Jianlan Song ,  James Rivera ,  Parul Dalia

    发明人： Chad Rothschiller ,  Robert Collie ,  Joseph Chirilov ,  Kelly J. Lynch ,  Ramakrishnan Natarajan ,  Juha Niemisto ,  Jianlan Song ,  James Rivera ,  Parul Dalia

    IPC分类号： G06F15/00

    CPC分类号： G06F17/30917 ,  G06F17/2247 ,  G06F17/227 ,  G06F17/246

    摘要： Methods and systems are provided for mapping markup language data and schema, such as eXtensible Markup Language (XML) data and XML schema, to selected fields (cells, columns, rows) of a spreadsheet application document. An XML schema file is associated with a spreadsheet application document by providing a mechanism of adding the schema definitions to the spreadsheet application document. Furthermore, XML schema constructs such as elements, attributes, and simple content are associated to regions in the spreadsheet application document by providing a tree view structure of a generalized instance of a given XML schema file. A user may drag and drop markup language nodes representing elements, attributes and simple data content, from the tree view structure of the generalized instance of the XML schema file onto a spreadsheet worksheet grid. Once a cell, column or row in worksheet grid accepts the dropped element or attribute, an association is made between the target location in the worksheet grid, and the definition, data type and rules associated with the dropped element or attribute by setting an XML path language (XPATH) marker to point the target location back to the selected element or attribute in the XML schema file. Having all or partially all desired markup language elements or attributes associated with desired target locations in the spreadsheet grid, a general mapping of marked-up locations in the spreadsheet grid and their associated elements and/or attributes in an associated XML schema file is created.

    摘要翻译： 提供了方法和系统，用于将标记语言数据和模式（如可扩展标记语言（XML）数据和XML模式）映射到电子表格应用程序文档的选定字段（单元格，列，行）。 通过提供将模式定义添加到电子表格应用程序文档的机制，将XML模式文件与电子表格应用程序文档相关联。 此外，XML模式构造（如元素，属性和简单内容）通过提供给定XML模式文件的通用实例的树视图结构与电子表格应用程序文档中的区域相关联。 用户可以将表示元素，属性和简单数据内容的标记语言节点从XML模式文件的广义实例的树状视图结构拖放到电子表格工作表网格上。 一旦工作表网格中的单元格，列或行接受删除的元素或属性，就会通过设置XML路径在工作表网格中的目标位置与与删除的元素或属性相关联的定义，数据类型和规则之间进行关联 语言（XPATH）标记将目标位置指向XML模式文件中所选的元素或属性。 具有与电子表格网格中的期望目标位置相关联的全部或部分所有期望的标记语言元素或属性，创建电子表格网格中的标记位置及其相关联的元素和/或相关联的XML模式文件中的属性的一般映射。

    Management of markup language data mappings available to a spreadsheet application workbook
    10.
    发明授权
    Management of markup language data mappings available to a spreadsheet application workbook 失效
    管理可用于电子表格应用程序工作簿的标记语言数据映射

    公开(公告)号：US07007033B1

    公开(公告)日：2006-02-28

    申请号：US10425189

    申请日：2003-04-28

    申请人： Chad Rothschiller ,  Kelly J. Lynch ,  Ramakrishnan Natarajan ,  Juha Niemisto ,  Marise Chan ,  Thibaut Vial

    发明人： Chad Rothschiller ,  Kelly J. Lynch ,  Ramakrishnan Natarajan ,  Juha Niemisto ,  Marise Chan ,  Thibaut Vial

    IPC分类号： G06F7/00

    CPC分类号： G06F17/272 ,  G06F17/2247 ,  G06F17/246 ,  G06F17/2725 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99945

    摘要： Methods and systems are provided for managing the application of one or more XML data mappings or one or more XML schema files to a spreadsheet application workbook. One or more XML schema files for associating to the spreadsheet workbook are obtained. Each schema file is iterated to determine if one or more additional schema files are identified in each of the obtained schema files. Each obtained schema is parsed to determine data definitions, elements, attributes, structure, and simple data content required by each schema file for valid XML data. All obtained schema files are combined to create a unified schema definition. A single root element is selected to serve as a root element for the generalized instance structure. A generalized instance structure of the unified schema definition is built representing all available elements, attributes or simple data content of the unified schema definition that may be applied to the spreadsheet application workbook. A tree view of the generalized instance structure is displayed for providing a visual representation of the instance structure of the unified schema definition representing elements, attributes, structure, and simple data content of the XML defined by the unified schema definition that may be validly applied to the spreadsheet workbook according to the generalized instance structure. Writing pointers to the XML map object expresses a relationship between workbook locations and XML elements.

    摘要翻译： 提供了用于管理一个或多个XML数据映射或一个或多个XML模式文件到电子表格应用程序工作簿的应用的方法和系统。 获得用于关联到电子表格工作簿的一个或多个XML模式文件。 迭代每个模式文件以确定在每个获取的模式文件中是否识别到一个或多个附加模式文件。 解析每个获取的模式以确定每个模式文件为有效的XML数据所需的数据定义，元素，属性，结构和简单数据内容。 所有获取的模式文件都被组合以创建统一的模式定义。 选择单个根元素作为广义实例结构的根元素。 构建统一模式定义的通用实例结构，代表可应用于电子表格应用程序工作簿的统一模式定义的所有可用元素，属性或简单数据内容。 显示广义实例结构的树视图，用于提供表示由统一模式定义定义的XML的元素，属性，结构和简单数据内容的统一模式定义的实例结构的可视化表示，可以有效地应用于 电子表格工作簿根据广义实例结构。 写入XML映射对象的指针表示工作簿位置和XML元素之间的关系。