METHOD, COMPUTER PROGRAM PRODUCT, AND SYSTEM OF OPTIMIZED DATA TRANSLATION FROM RELATIONAL DATA STORAGE TO HIERARCHICAL STRUCTURE
    1.
    发明申请
    METHOD, COMPUTER PROGRAM PRODUCT, AND SYSTEM OF OPTIMIZED DATA TRANSLATION FROM RELATIONAL DATA STORAGE TO HIERARCHICAL STRUCTURE 有权
    方法,计算机程序产品和从关系数据存储到分层结构的优化数据转换系统

    公开(公告)号:US20070118553A1

    公开(公告)日:2007-05-24

    申请号:US11623840

    申请日:2007-01-17

    IPC分类号: G06F7/00

    摘要: A tagging tree that defines a hierarchical output data structure and relational database query operations that retrieve the data to be included in each hierarchical section is accepted and processed. A query optimizer analyzes the tagging tree to determine database query operations that can be combined into a single query command. An outer-union query command is generated to allow efficient combination of multiple query commands, some of which are predicates to others. The tagging tree is modified to replace the database queries that were combined into the outer-union query to extract data from the results set produced by the outer-union query as opposed to submitting queries to the database manager. The optimized queries can be reused an arbitrary number of times to leverage the optimizing resources that were used in their creation.

    摘要翻译: 定义分层输出数据结构的标记树和检索要包含在每个分层部分中的数据的关系数据库查询操作被接受和处理。 查询优化器分析标记树以确定可以组合成单个查询命令的数据库查询操作。 生成一个外联合查询命令,以允许多个查询命令的有效组合,其中一些查询命令是其他命令的谓词。 标记树被修改为将组合到外联合查询中的数据库查询替换为从外联合查询生成的结果集中提取数据,而不是向数据库管理器提交查询。 优化的查询可以重复使用任意次数,以利用其创建中使用的优化资源。

    Method, computer program product, and system converting relational data into hierarchical data structure based upon tagging trees
    2.
    发明申请
    Method, computer program product, and system converting relational data into hierarchical data structure based upon tagging trees 失效
    方法,计算机程序产品和系统将关系数据转换为基于标记树的分层数据结构

    公开(公告)号:US20050138052A1

    公开(公告)日:2005-06-23

    申请号:US10788141

    申请日:2004-02-26

    IPC分类号: G06F17/00 G06F17/30

    摘要: Tagging trees are generated and used to facilitate transforming data from relational databases into hierarchical formats, such as in XML documents. Tagging trees contain both XML hierarchical structure information as well a query information that is needed to access different data sources, e.g., databases, to retrieve the information to be placed in the hierarchical structure. A designer optionally creates a mapping script that specifies the transformation from relational databases to the hierarchical format. A tagging tree is created by either parsing that mapping script or by other means. A runtime environment then processes the tagging tree by a depth first traversal. The runtime environment is able to be configured to output a hierarchical data object, such as an XML document, or pipelined to control, for example, SAX processing.

    摘要翻译: 生成标记树以便于将数据从关系数据库转换为分层格式,如XML文档。 标记树包含XML层次结构信息以及访问不同数据源(例如数据库)以检索要放置在分层结构中的信息所需的查询信息。 设计人员可以选择创建一个映射脚本,该脚本指定从关系数据库到分层格式的转换。 标记树通过解析该映射脚本或其他方式来创建。 然后,运行时环境通过深度优先遍历处理标记树。 运行时环境能够被配置为输出分层数据对象,例如XML文档,或流水线控制,例如SAX处理。

    Converting recursive hierarchical data to relational data
    3.
    发明申请
    Converting recursive hierarchical data to relational data 审中-公开
    将递归分层数据转换为关系数据

    公开(公告)号:US20070143321A1

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

    申请号:US11303432

    申请日:2005-12-16

    IPC分类号: G06F7/00

    CPC分类号: G06F16/86

    摘要: A system and method of converting a recursive XML document into a relational schema comprises providing a recursive XML document; parsing an external mapping script specifying a mapping from the recursive XML document to a relational table format; building a recursive shredding tree based on the external mapping script and the relational table format; and shredding the mapped recursive XML document into a relational table. The system and method further comprise detecting whether any of a XML schema and a DTD document is recursive, wherein the detecting comprises building a directed graph comprising element names; corresponding elements names as nodes in the directed graph; forming arcs from every element parent node to every element child node of the element parent node; and checking for cycles in the directed graph. The system and method further comprise identifying all recursive cursor nodes and a recursive degree corresponding to the recursive shredding tree.

    摘要翻译: 将递归XML文档转换为关系模式的系统和方法包括提供递归XML文档; 解析指定从递归XML文档到关系表格式的映射的外部映射脚本; 基于外部映射脚本和关系表格式构建递归切割树; 并将映射的递归XML文档切割成关系表。 所述系统和方法还包括检测XML模式和DTD文档中的任何一个是递归的,其中所述检测包括构建包括元素名称的有向图; 相应的元素名称作为有向图中的节点; 从每个元素父节点到元素父节点的每个元素子节点形成弧; 并检查有向图中的周期。 该系统和方法还包括识别所有递归光标节点和对应于递归粉碎树的递归度。

    Method, computer program product, and system of optimized data translation from relational data storage to hierarchical structure
    4.
    发明申请
    Method, computer program product, and system of optimized data translation from relational data storage to hierarchical structure 失效
    方法,计算机程序产品和从关系数据存储到分层结构的优化数据转换系统

    公开(公告)号:US20050138073A1

    公开(公告)日:2005-06-23

    申请号:US10744424

    申请日:2003-12-22

    IPC分类号: G06F17/00 G06F17/30

    摘要: A tagging tree that defines a hierarchical output data structure and relational database query operations that retrieve the data to be included in each hierarchical section is accepted and processed. A query optimizer analyzes the tagging tree to determine database query operations that can be combined into a single query command. An outer-union query command is generated to allow efficient combination of multiple query commands, some of which are predicates to others. The tagging tree is modified to replace the database queries that were combined into the outer-union query to extract data from the results set produced by the outer-union query as opposed to submitting queries to the database manager. The optimized queries can be reused an arbitrary number of times to leverage the optimizing resources that were used in their creation.

    摘要翻译: 定义分层输出数据结构的标记树和检索要包含在每个分层部分中的数据的关系数据库查询操作被接受和处理。 查询优化器分析标记树以确定可以组合成单个查询命令的数据库查询操作。 生成一个外联合查询命令,以允许多个查询命令的有效组合,其中一些查询命令是其他命令的谓词。 标记树被修改为将组合到外联合查询中的数据库查询替换为从外联合查询生成的结果集中提取数据,而不是向数据库管理器提交查询。 优化的查询可以重复使用任意次数,以利用其创建中使用的优化资源。

    Memory efficient XML shredding with partial commit
    5.
    发明申请
    Memory efficient XML shredding with partial commit 有权
    具有部分提交功能的内存高效的XML切割

    公开(公告)号:US20060184552A1

    公开(公告)日:2006-08-17

    申请号:US11058020

    申请日:2005-02-15

    IPC分类号: G06F17/00

    摘要: A method and system that allows efficient shredding of large instances of hierarchical data structures into relational data structures. Large instances of hierarchical data structures, which are able to be larger than the random access storage of a computer used to shred them into relational data structures, are incrementally shredded into a temporary storage. When the amount of data shredded into the temporary storage reaches or exceeds a predetermined commit count, the data in the temporary storage is transferred to a relational data structure maintained by a relational database manager. A Document Type Description annotation is provided to allow the end user to specify execution order for SQL commands and to specify commit count values.

    摘要翻译: 一种方法和系统,允许将大型实例的分层数据结构高效地分解成关系数据结构。 能够比用于将它们分割成关系数据结构的计算机的随机存取存储器更大的分级数据结构的大型实例被递增地切割成临时存储器。 当切入临时存储器的数据量达到或超过预定提交计数时,临时存储器中的数据被传送到由关系数据库管理器维护的关系数据结构。 文档类型说明注释用于允许最终用户指定SQL命令的执行顺序并指定提交计数值。

    Enabling automatic business processes using state transfer diagram and abstraction
    6.
    发明申请
    Enabling automatic business processes using state transfer diagram and abstraction 审中-公开
    启用使用状态转移图和抽象的自动业务流程

    公开(公告)号:US20070204169A1

    公开(公告)日:2007-08-30

    申请号:US11364376

    申请日:2006-02-28

    IPC分类号: G06F12/14

    CPC分类号: G06Q30/02 G06F9/44505

    摘要: An application specific framework is generated from configuration information contained in a configuration file. The application specific framework comprises a state transformation diagram. Application specific plug-in code is generated from the configuration information for attaching application programs to the framework. External events trigger navigation of the state transformation diagram according to rules derived from user profile and user state information. Navigation of the state transformation exercises function of the attached application programs. Modification of the function of the framework is accomplished by simply modifying the configuration information as needed.

    摘要翻译: 应用程序特定框架是从配置文件中包含的配置信息生成的。 应用程序特定框架包括状态转换图。 应用程序特定的插件代码是从用于将应用程序附加到框架的配置信息生成的。 外部事件根据从用户配置文件和用户状态信息导出的规则触发状态转换图的导航。 导航的状态转换练习函数附加的应用程序。 通过简单地根据需要修改配置信息来实现对框架功能的修改。

    Method and system for instant messaging bots specification using state transition methodology and XML
    7.
    发明申请
    Method and system for instant messaging bots specification using state transition methodology and XML 失效
    使用状态转换方法和XML的即时消息机器人规范的方法和系统

    公开(公告)号:US20050138132A1

    公开(公告)日:2005-06-23

    申请号:US10744425

    申请日:2003-12-22

    IPC分类号: G06F15/16 H04L12/58

    CPC分类号: H04L51/04

    摘要: A framework for creating instant messaging Bots that autonomously operate within an instant messaging sessions to respond to requests from other user(s) or Bot(s). Bot operation is defined by a state machine with one or more states that are described in XML documents. These XML documents abide by the grammar of a Bot Transition Definition Language (BTDL) that is defined in an XML schema. A Bot developer creates a state transition diagram via a Graphical User Interface. The state transition diagram defines states, transitions between states, and conditions for each of those state transitions and methods to be performed upon each state transition. An XML document that conforms to BTDL format is created from the state transition definition diagram. Both stateful and stateless Bots are defined using XML documents abiding to a BTDL format. A runtime environment implements the Bots, accepts runtime inputs and generates responses.

    摘要翻译: 用于创建即时消息的框架在即时消息会话中自动运行以响应来自其他用户或Bot的请求的博客。 Bot操作由具有在XML文档中描述的一个或多个状态的状态机定义。 这些XML文档遵守在XML模式中定义的Bot Transition Definition Language(BTDL)的语法。 Bot开发者通过图形用户界面创建状态转换图。 状态转换图定义状态,状态之间的转换,以及在每个状态转换时要执行的每个状态转换和方法的条件。 符合BTDL格式的XML文档是从状态转换定义图创建的。 有状态和无状态的Bots都是使用遵循BTDL格式的XML文档定义的。 运行时环境实现Bots,接受运行时输入并生成响应。

    METHOD AND APPARATUS FOR END-TO-END CONTENT PUBLISHING SYSTEM USING XML WITH AN OBJECT DEPENDENCY GRAPH
    8.
    发明申请
    METHOD AND APPARATUS FOR END-TO-END CONTENT PUBLISHING SYSTEM USING XML WITH AN OBJECT DEPENDENCY GRAPH 失效
    使用XML与对象依赖图的端到端内容发布系统的方法和装置

    公开(公告)号:US20060294459A1

    公开(公告)日:2006-12-28

    申请号:US11460133

    申请日:2006-07-26

    IPC分类号: G06F15/00

    摘要: The system for end-to-end content publishing using XML with an object dependency graph is based on the following two design principles: First, separation of content and style: Information stored in the content management system is independent on how it is going to be presented. The presentation style is encapsulated elsewhere and can be used to customize the look and feel based on the end-user preferences as well as the delivery methods and devices. Second, reusability of information content: By encapsulating common information in fragments and subfragments and making these fragments insertable in other fragments, thereby avoid scattering and duplication of information. This enables a user to restrict the edit operations to a limited number of relevant fragments, to affect global changes. In addition, the present invention provides data consistency and data integrity in the content management.

    摘要翻译: 使用XML与对象依赖关系图进行端到端内容发布的系统基于以下两个设计原则:第一,内容和样式的分离:存储在内容管理系统中的信息将独立于如何 呈现。 演示风格被封装在其他地方,可用于根据最终用户偏好以及投放方式和设备自定义外观。 第二,信息内容的可重用性:通过将通用信息封装在片段和子片段中,并使这些片段可插入其他片段,从而避免散布和重复信息。 这使得用户能够将编辑操作限制为有限数量的相关片段,以影响全局更改。 此外,本发明在内容管理中提供数据一致性和数据完整性。

    Universal format transformation between relational database management systems and extensible markup language using XML relational transformation
    10.
    发明申请
    Universal format transformation between relational database management systems and extensible markup language using XML relational transformation 审中-公开
    关系数据库管理系统与可扩展标记语言之间的通用格式转换,采用XML关系转换

    公开(公告)号:US20050010896A1

    公开(公告)日:2005-01-13

    申请号:US10614664

    申请日:2003-07-07

    IPC分类号: G06F9/44 G06F17/30

    CPC分类号: G06F16/86

    摘要: A program product, system and method for transforming data between an XML representation and a relational database system wherein a mapping description is created in a mark-up language such as XML and XSL. The mapping description specifying a set of conditions for source data to satisfy. When mapping to XML, an XML output format is specified in the mapping description and the data is formatted accordingly. When mapping to a RDBMS, actions to be executed on the RDBMS tables are specified in the mapping description and the actions are perfomed.

    摘要翻译: 用于在XML表示和关系数据库系统之间转换数据的程序产品,系统和方法,其中以诸如XML和XSL的标记语言创建映射描述。 指定源数据满足条件的映射描述。 映射到XML时,在映射描述中指定了XML输出格式,并相应地格式化了数据。 当映射到RDBMS时,在映射描述中指定要在RDBMS表上执行的操作,并且执行操作。