Mapping of data from XML to SQL
    1.
    发明申请
    Mapping of data from XML to SQL 有权
    将数据从XML映射到SQL

    公开(公告)号:US20080208879A1

    公开(公告)日:2008-08-28

    申请号:US12073511

    申请日:2008-03-06

    IPC分类号: G06F17/00

    摘要: A method, an apparatus and a computer program product for converting an XML encoded dataset into a minimal set of SQL tables and provided. In the method, a hierarchical structure in the XML encoded dataset is identified. A node element set for the XML encoded dataset is determined, wherein each node element in the node element set is a discrete level of the hierarchical structure of the dataset. One or more nodes of the XML encoded dataset are determined, each node being an instance of a node element. A unique node identifier is allocated to each node. Then, an SQL node table containing one or more records is generated, each record corresponding to a respective one of the allocated node identifiers. An SQL ancestry table is optionally generated to define the inter-relationships among nodes of the identified hierarchical structure of the XML encoded dataset.

    摘要翻译: 一种用于将XML编码数据集转换成最小的SQL表并提供的方法,装置和计算机程序产品。 在该方法中,识别XML编码数据集中的层次结构。 确定针对XML编码数据集的节点元素集,其中节点元素集合中的每个节点元素是数据集的分层结构的离散级别。 确定XML编码数据集的一个或多个节点,每个节点是节点元素的实例。 唯一的节点标识符被分配给每个节点。 然后,生成包含一个或多个记录的SQL节点表,每个记录对应于所分配的节点标识符中的相应一个。 可选地生成SQL祖先表以定义所识别的XML编码数据集的层次结构的节点之间的相互关系。

    Mapping of data from XML to SQL
    2.
    发明授权
    Mapping of data from XML to SQL 有权
    将数据从XML映射到SQL

    公开(公告)号:US08204913B2

    公开(公告)日:2012-06-19

    申请号:US12073511

    申请日:2008-03-06

    IPC分类号: G06F17/30

    摘要: A method, an apparatus and a computer program product for converting an XML encoded dataset into a minimal set of SQL tables and provided. In the method, a hierarchical structure in the XML encoded dataset is identified. A node element set for the XML encoded dataset is determined, wherein each node element in the node element set is a discrete level of the hierarchical structure of the dataset. One or more nodes of the XML encoded dataset are determined, each node being an instance of a node element. A unique node identifier is allocated to each node. Then, an SQL node table containing one or more records is generated, each record corresponding to a respective one of the allocated node identifiers. An SQL ancestry table is optionally generated to define the inter-relationships among nodes of the identified hierarchical structure of the XML encoded dataset.

    摘要翻译: 一种用于将XML编码数据集转换成最小的SQL表并提供的方法,装置和计算机程序产品。 在该方法中,识别XML编码数据集中的层次结构。 确定针对XML编码数据集的节点元素,其中节点元素集合中的每个节点元素是数据集的分层结构的离散级别。 确定XML编码数据集的一个或多个节点,每个节点是节点元素的实例。 唯一的节点标识符被分配给每个节点。 然后,生成包含一个或多个记录的SQL节点表,每个记录对应于所分配的节点标识符中的相应一个。 可选地生成SQL祖先表以定义所识别的XML编码数据集的层次结构的节点之间的相互关系。

    Mapping of data from XML to SQL
    3.
    发明授权
    Mapping of data from XML to SQL 有权
    将数据从XML映射到SQL

    公开(公告)号:US08396901B2

    公开(公告)日:2013-03-12

    申请号:US13473207

    申请日:2012-05-16

    IPC分类号: G06F17/30

    摘要: A method, an apparatus and a computer program product for converting an XML encoded dataset into a minimal set of SQL tables and provided. In the method, a hierarchical structure in the XML encoded dataset is identified. A node element set for the XML encoded dataset is determined, wherein each node element in the node element set is a discrete level of the hierarchical structure of the dataset. One or more nodes of the XML encoded dataset are determined, each node being an instance of a node element. A unique node identifier is allocated to each node. Then, an SQL node table containing one or more records is generated, each record corresponding to a respective one of the allocated node identifiers. An SQL ancestry table is optionally generated to define the inter-relationships among nodes of the identified hierarchical structure of the XML encoded dataset.

    摘要翻译: 一种用于将XML编码数据集转换成最小的SQL表并提供的方法,装置和计算机程序产品。 在该方法中,识别XML编码数据集中的层次结构。 确定针对XML编码数据集的节点元素集,其中节点元素集合中的每个节点元素是数据集的分层结构的离散级别。 确定XML编码数据集的一个或多个节点,每个节点是节点元素的实例。 唯一的节点标识符被分配给每个节点。 然后,生成包含一个或多个记录的SQL节点表,每个记录对应于所分配的节点标识符中的相应一个。 可选地生成SQL祖先表以定义所识别的XML编码数据集的层次结构的节点之间的相互关系。

    Mapping of data from XML to SQL
    4.
    发明授权
    Mapping of data from XML to SQL 有权
    将数据从XML映射到SQL

    公开(公告)号:US07363310B2

    公开(公告)日:2008-04-22

    申请号:US10233991

    申请日:2002-09-03

    IPC分类号: G06F17/00 G06F7/00

    摘要: A method, an apparatus and a computer program product for converting an XML encoded dataset into a minimal set of SQL tables are provided. In the method, a hierarchical structure in the XML encoded dataset is identified. A node element set for the XML encoded dataset is determined, wherein each node element in the node element set is a discrete level of the hierarchical structure of the dataset. One or more nodes of the XML encoded dataset are determined, each node being an instance of a node element. A unique node identifier is allocated to each node. Then, an SQL node table containing one or more records is generated, each record corresponding to a respective one of the allocated node identifiers. An SQL ancestry table is optionally generated to define the inter-relationships among nodes of the identified hierarchical structure of the XML encoded dataset.

    摘要翻译: 提供了一种用于将XML编码数据集转换成最小SQL表的方法,装置和计算机程序产品。 在该方法中,识别XML编码数据集中的层次结构。 确定针对XML编码数据集的节点元素集,其中节点元素集合中的每个节点元素是数据集的分层结构的离散级别。 确定XML编码数据集的一个或多个节点,每个节点是节点元素的实例。 唯一的节点标识符被分配给每个节点。 然后,生成包含一个或多个记录的SQL节点表,每个记录对应于所分配的节点标识符中的相应一个。 可选地生成SQL祖先表以定义所识别的XML编码数据集的层次结构的节点之间的相互关系。

    Maltweb multi-axis viewing interface and higher level scoping
    5.
    发明授权
    Maltweb multi-axis viewing interface and higher level scoping 有权
    Maltweb多轴观察界面和更高级别的范围

    公开(公告)号:US07293228B1

    公开(公告)日:2007-11-06

    申请号:US09689927

    申请日:2000-10-12

    IPC分类号: G06F17/21 G06F17/24

    摘要: A method, apparatus and computer program product for navigating in a multi-dimensional space containing an electronic publication formed from predefined portions of text-based data encoded using a markup language are disclosed. A selected predefined portion is displayed in a first display region. A point on a primary axis of the multi-dimensional space corresponding to the displayed pre-defined portion is also displayed. Also, a method, apparatus and computer program product for publishing an electronic publication formed from predefined portions of text-based data encoded using a markup language are also disclosed. Predefined portions are stored in terminal nodes. Higher level nodes are provided for organizing the terminal nodes into an hierarchical structure embodied in said electronic publication. Each higher level node contains the identity of a parent node, a position indicator for the higher level node and an associated identifier.

    摘要翻译: 公开了用于在包含由使用标记语言编码的基于文本的数据的预定义部分形成的电子出版物的多维空间中导航的方法,装置和计算机程序产品。 所选择的预定义部分显示在第一显示区域中。 还显示与显示的预定义部分对应的多维空间的主轴上的点。 此外,还公开了一种用于发布由使用标记语言编码的基于文本的数据的预定义部分形成的电子出版物的方法,装置和计算机程序产品。 预定义部分存储在终端节点中。 提供了较高级节点,用于将终端节点组织成体现在所述电子出版物中的层次结构。 每个较高级节点包含父节点的身份,高级节点的位置指示符和相关联的标识符。

    Maintenance of a markup language document in a database
    6.
    发明授权
    Maintenance of a markup language document in a database 有权
    在数据库中维护标记语言文档

    公开(公告)号:US07281206B2

    公开(公告)日:2007-10-09

    申请号:US10294384

    申请日:2002-11-14

    IPC分类号: G06F15/00

    CPC分类号: G06F17/30917

    摘要: A method, an apparatus and a computer program product for converting an XML encoded document into an equivalent SQL table are provided. An arbitrary XML DTD may be converted into an equivalent form by means of which individual node documents stored in the SQL table may be directly accessed. The SQL table is able to be converted back into an XML document of similar structure to the original document from which the table was derived. A set of operations which can be performed on the SQL table is also disclosed. An arbitrarily complex XML document may be broken into suitably sized portions, each of which can be managed independently as a standalone XML document without compromising the validity of the document as a whole. The management of these portions takes advantage of the speed, robustness and maturity of RDBMS systems, while maintaining the hierarchical structure inherent in all XML documents.

    摘要翻译: 提供了一种用于将XML编码的文档转换成等价的SQL表的方法,装置和计算机程序产品。 可以将任意的XML DTD转换成等效形式,借此可以直接访问存储在SQL表中的各个节点文档。 SQL表能够转换为与从其导出表格的原始文档类似结构的XML文档。 还可以在SQL表上执行一组可以执行的操作。 任意复杂的XML文档可以被分成适当大小的部分,每个部分可以独立地作为独立的XML文档进行管理,而不会影响整个文档的有效性。 这些部分的管理利用RDBMS系统的速度,鲁棒性和成熟度,同时保持所有XML文档中固有的层次结构。

    Mapping of Data From XML to SQL
    7.
    发明申请
    Mapping of Data From XML to SQL 有权
    将数据从XML映射到SQL

    公开(公告)号:US20120226720A1

    公开(公告)日:2012-09-06

    申请号:US13473207

    申请日:2012-05-16

    IPC分类号: G06F7/00 G06F17/30

    摘要: A method, an apparatus and a computer program product for converting an XML encoded dataset into a minimal set of SQL tables and provided. In the method, a hierarchical structure in the XML encoded dataset is identified. A node element set for the XML encoded dataset is determined, wherein each node element in the node element set is a discrete level of the hierarchical structure of the dataset. One or more nodes of the XML encoded dataset are determined, each node being an instance of a node element. A unique node identifier is allocated to each node. Then, an SQL node table containing one or more records is generated, each record corresponding to a respective one of the allocated node identifiers. An SQL ancestry table is optionally generated to define the inter-relationships among nodes of the identified hierarchical structure of the XML encoded dataset.

    摘要翻译: 一种用于将XML编码数据集转换成最小的SQL表并提供的方法,装置和计算机程序产品。 在该方法中,识别XML编码数据集中的层次结构。 确定针对XML编码数据集的节点元素集,其中节点元素集合中的每个节点元素是数据集的分层结构的离散级别。 确定XML编码数据集的一个或多个节点,每个节点是节点元素的实例。 唯一的节点标识符被分配给每个节点。 然后,生成包含一个或多个记录的SQL节点表,每个记录对应于所分配的节点标识符中的相应一个。 可选地生成SQL祖先表以定义所识别的XML编码数据集的层次结构的节点之间的相互关系。

    Maltweb multi-axis viewing interface and higher level scoping
    8.
    发明申请
    Maltweb multi-axis viewing interface and higher level scoping 有权
    Maltweb多轴观察界面和更高级别的范围

    公开(公告)号:US20070074107A1

    公开(公告)日:2007-03-29

    申请号:US11600778

    申请日:2006-11-17

    IPC分类号: G06F17/00 G06F17/30

    摘要: A method, apparatus and computer program product for navigating in a multi-dimensional space containing an electronic publication formed from predefined portions of text-based data encoded using a markup language are disclosed. A selected predefined portion is displayed in a first display region. A point on a primary axis of the multi-dimensional space corresponding to the displayed pre-defined portion is also displayed. Also, a method, apparatus and computer program product for publishing an electronic publication formed from predefined portions of text-based data encoded using a markup language are also disclosed. Predefined portions are stored in terminal nodes. Higher level nodes are provided for organising the terminal nodes into an hierarchical structure embodied in said electronic publication. Each higher level node contains the identity of a parent node, a position indicator for the higher level node and an associated identifier.

    摘要翻译: 公开了一种用于在包含由使用标记语言编码的基于文本的数据的预定义部分形成的电子出版物的多维空间中导航的方法,装置和计算机程序产品。 所选择的预定义部分显示在第一显示区域中。 还显示与显示的预定义部分对应的多维空间的主轴上的点。 此外,还公开了一种用于发布由使用标记语言编码的基于文本的数据的预定义部分形成的电子出版物的方法,装置和计算机程序产品。 预定义部分存储在终端节点中。 提供了较高级节点,用于将终端节点组织成体现在所述电子出版物中的层次结构。 每个较高级节点包含父节点的身份,高级节点的位置指示符和相关联的标识符。

    System for electronic publishing
    9.
    发明授权
    System for electronic publishing 失效
    电子出版系统

    公开(公告)号:US06233592B1

    公开(公告)日:2001-05-15

    申请号:US09108999

    申请日:1998-07-01

    IPC分类号: G06F1721

    摘要: The present invention relates to a method, apparatus and system for publishing electronic information. The system includes a plurality of predefined portions of data with each predefined portion being encoded with at least one linking means. For each predefined portion, each predefined portion is stored and, where such predefined portion has been modified, each such modified predefined portion is stored. Further, the system has a plurality of attributes. Each attribute is a point on an axis of a multidimensional space for organizing the data. The plurality of predefined portions of the data may be encoded using Standard Generalized Markup Language (SGML) OR XML. Still further, the data is encoded using one or more Document Type Definitions (DTD) or Style Sheet Mechanisms (SSM).

    摘要翻译: 本发明涉及发布电子信息的方法,装置和系统。 该系统包括多个预定义的数据部分,每个预定义部分被至少一个链接装置编码。 对于每个预定义部分,存储每个预定义部分,并且在已经修改了这种预定义部分的情况下,存储每个这样的修改的预定义部分。 此外,该系统具有多个属性。 每个属性是用于组织数据的多维空间轴上的一个点。 可以使用标准通用标记语言(SGML)OR XML来对数据的多个预定义部分进行编码。 此外,使用一个或多个文档类型定义(DTD)或样式表机制(SSM)对数据进行编码。

    Maintenance of a markup language document in a database
    10.
    发明申请
    Maintenance of a markup language document in a database 审中-公开
    在数据库中维护标记语言文档

    公开(公告)号:US20080021916A1

    公开(公告)日:2008-01-24

    申请号:US11892907

    申请日:2007-08-28

    IPC分类号: G06F7/00 G06F17/00

    CPC分类号: G06F16/86

    摘要: A method, an apparatus and a computer program product for converting an XML encoded document into an equivalent SQL table are provided. An arbitrary XML DTD may be converted into an equivalent form by means of which individual node documents stored in the SQL table may be directly accessed. The SQL table is able to be converted back into an XML document of similar structure to the original document from which the table was derived. A set of operations which can be performed on the SQL table is also disclosed. An arbitrarily complex XML document may be broken into suitably sized portions, each of which can be managed independently as a standalone XML document without compromising the validity of the document as a whole. The management of these portions takes advantage of the speed, robustness and maturity of RDBMS systems, while maintaining the hierarchical structure inherent in all XML documents.

    摘要翻译: 提供了一种用于将XML编码的文档转换成等价的SQL表的方法,装置和计算机程序产品。 可以将任意的XML DTD转换成等效形式,借此可以直接访问存储在SQL表中的各个节点文档。 SQL表能够转换为与从其导出表格的原始文档类似结构的XML文档。 还可以在SQL表上执行一组可以执行的操作。 任意复杂的XML文档可以分成适当大小的部分,每个部分可以独立地作为独立的XML文档进行管理,而不会影响整个文档的有效性。 这些部分的管理利用RDBMS系统的速度,鲁棒性和成熟度,同时保持所有XML文档中固有的层次结构。