Techniques for efficient integration of text searching with queries over XML data
    5.
    发明授权
    Techniques for efficient integration of text searching with queries over XML data 有权
    通过XML数据高效集成文本搜索与查询的技术

    公开(公告)号:US07305414B2

    公开(公告)日:2007-12-04

    申请号:US11099918

    申请日:2005-04-05

    IPC分类号: G06F17/30

    摘要: A method and apparatus for rewriting a database command containing an embedded XML expression such that the rewritten database command recites a text function, in lieu of the embedded XML expression, is provided. Advantageously, a DBMS may take advantage of the efficiencies in storing XML data within the database, while avoiding the generation of unnecessary XML elements in processing the query when the XML elements contribute nothing to the outcome of the query. Cost-base or rule-based analysis may be performed to determine how to rewrite a received database command. The database server may functionally evaluate the text function or may use an index defined on a column of the database. The text function may function as a primary filter or may reference a column upon which an index is defined, wherein the index operates at the same or higher level than a column being referenced in the embedded XML expression.

    摘要翻译: 提供一种用于重写包含嵌入式XML表达式的数据库命令的方法和装置,使得重写的数据库命令背景文本功能代替嵌入的XML表达。 有利地,DBMS可以利用在数据库中存储XML数据的效率,同时避免在XML元素对查询的结果没有贡献时在处理查询时生成不必要的XML元素。 可以执行基于成本或基于规则的分析来确定如何重写接收到的数据库命令。 数据库服务器可以在功能上评估文本功能,或者可以使用在数据库的列上定义的索引。 文本函数可以用作主过滤器,或者可以引用定义索引的列,其中索引在与嵌入式XML表达式中引用的列相同或更高的级别上操作。

    TECHNIQUES FOR PROVIDING XQUERY ACCESS USING WEB SERVICES
    6.
    发明申请
    TECHNIQUES FOR PROVIDING XQUERY ACCESS USING WEB SERVICES 有权
    使用WEB服务提供XQUERY ACCESS的技术

    公开(公告)号:US20110113061A1

    公开(公告)日:2011-05-12

    申请号:US13009712

    申请日:2011-01-19

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30923 G06F17/30861

    摘要: An XQuery access API is described, for providing access to XML data from a data source, using the XQuery language. A requestor can request, from a server, performance of an operation on XML data, wherein request messages and response messages conform to the Simple Object Access Protocol (SOAP). Request and response messages can be transmitted using Hypertext Transfer Protocol (HTTP) or Hypertext Transfer Protocol over Secure Socket Layer (HTTPS). The format of the request and response messages is specified in a definition of a Web service, where the definition conforms to the Web Service Description Language (WSDL).

    摘要翻译: 描述了一个XQuery访问API,用于使用XQuery语言提供从数据源访问XML数据。 请求者可以从服务器请求执行对XML数据的操作,其中请求消息和响应消息符合简单对象访问协议(SOAP)。 请求和响应消息可以使用超文本传输​​协议(HTTP)或超文本传输​​协议通过安全套接字层(HTTPS)传输。 请求和响应消息的格式在Web服务的定义中指定,其中定义符合Web服务描述语言(WSDL)。

    Technique of using XMLType tree as the type infrastructure for XML
    7.
    发明授权
    Technique of using XMLType tree as the type infrastructure for XML 有权
    使用XMLType树作为XML类型基础设施的技术

    公开(公告)号:US07685137B2

    公开(公告)日:2010-03-23

    申请号:US11044472

    申请日:2005-01-26

    IPC分类号: G06F7/00

    CPC分类号: G06F17/2247

    摘要: A universal format is used to create a type representation of XMLType instances that are generated in various ways from various sources. An XMLType Type Tree is represented as a hierarchy of nodes, including leaf item node, composite item node, operator node, aggregate node, referred to herein as an XMLType Type Tree. An XMLType Type Tree serves as a digest of the type structure of XMLType, no matter the source of the XMLType instance or its manner of its generation and it creates one uniform abstraction of the type structure of XMLType for the data-typing analysis of XPath and XQuery during query compile time.

    摘要翻译: 通用格式用于创建以各种方式生成的XMLType实例的类型表示形式。 XMLType类型树被表示为节点的层次结构,包括叶项目节点,复合项目节点,运营商节点,聚合节点,这里称为XMLType类型树。 XMLType类型树作为XMLType的类型结构的摘要,无论XMLType实例的来源或其生成方式如何,它都会为XPath的数据类型分析创建XMLType类型结构的一个统一抽象, 查询编译期间的XQuery。

    Techniques of rewriting descendant and wildcard XPath using combination of SQL OR, UNION ALL, and XMLConcat() construct
    8.
    发明申请
    Techniques of rewriting descendant and wildcard XPath using combination of SQL OR, UNION ALL, and XMLConcat() construct 有权
    使用SQL OR,UNION ALL和XMLConcat()构造的组合重写后代和通配符XPath的技术

    公开(公告)号:US20070299834A1

    公开(公告)日:2007-12-27

    申请号:US11474038

    申请日:2006-06-23

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30935

    摘要: A method for processing queries is provided. A first representation of a query is generated, where the query includes a certain operator that is to be performed based on an XPath expression that is expandable into multiple location paths. The first representation of the query is rewritten into a second representation that corresponds to an equivalent query, where rewriting the first representation includes expanding the XPath expression into the plurality of location paths and, based on the certain operator, including a plurality of operators in the second representation, where the plurality of operators include: a first set of operators that is to be performed based on each of the plurality of location paths, and a second set of operators that is to be performed based on data returned from at least one operator included in the first set of operators. The query may thereafter be executed based on the second representation. The second representation may be further rewritten to third representation depending on the physical storage of XML.

    摘要翻译: 提供了一种处理查询的方法。 生成查询的第一个表示形式,其中查询包含一个基于可扩展到多个位置路径的XPath表达式执行的某个运算符。 查询的第一表示被重写成对应于等效查询的第二表示,其中重写第一表示包括将XPath表达式扩展到多个位置路径中,并且基于特定运算符,包括多个运算符 第二表示,其中所述多个运算符包括:将基于所述多个位置路径中的每一个来执行的第一组运算符,以及将基于从至少一个运算符返回的数据来执行的第二组运算符 包含在第一组运算符中。 此后可以基于第二表示来执行查询。 取决于XML的物理存储,第二表示可以进一步重写为第三表示。

    Effectively and efficiently supporting XML sequence type and XQuery sequence natively in a SQL system
    9.
    发明授权
    Effectively and efficiently supporting XML sequence type and XQuery sequence natively in a SQL system 有权
    在SQL系统中有效高效地支持XML序列类型和XQuery序列

    公开(公告)号:US08463801B2

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

    申请号:US11098887

    申请日:2005-04-04

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30917

    摘要: Techniques for effectively and efficiently supporting XML sequence type and XQuery sequence natively in a SQL system are described. According to one aspect, SQL functions that correctly handle XML sequences are provided. Thus, XML sequences are handled effectively. According to another aspect, rules for simplifying an abstract syntax tree (AST) that represents one or more such SQL functions are provided. For each such SQL function that is represented in an AST that represents a SQL query, one or more rules that are relevant to that SQL function are determined. Relevant rules are applied to the representation of the SQL function within the AST. Through the application of the rules to the representations of the SQL functions within the AST, the AST is modified in a manner that simplifies the AST prior to the evaluation of the AST at query execution time. Thus, XML sequences are handled efficiently.

    摘要翻译: 描述了在SQL系统中有效和高效地支持XML序列类型和XQuery序列本身的技术。 根据一个方面,提供了正确处理XML序列的SQL函数。 因此,XML序列被有效地处理。 根据另一方面,提供了简化表示一个或多个这样的SQL函数的抽象语法树(AST)的规则。 对于表示SQL查询的AST中表示的每个这样的SQL函数,确定与该SQL函数相关的一个或多个规则。 相关规则适用于AST中SQL函数的表示。 通过将规则应用于AST中的SQL函数的表示,AST以在查询执行时评估AST之前简化AST的方式进行修改。 因此,XML序列被有效地处理。

    Techniques for providing XQuery access using web services
    10.
    发明授权
    Techniques for providing XQuery access using web services 有权
    使用Web服务提供XQuery访问的技术

    公开(公告)号:US07908286B2

    公开(公告)日:2011-03-15

    申请号:US11007894

    申请日:2004-12-08

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30923 G06F17/30861

    摘要: An XQuery access API is described, for providing access to XML data from a data source, using the XQuery language. A requestor can request, from a server, performance of an operation on XML data, wherein request messages and response messages conform to the Simple Object Access Protocol (SOAP). Request and response messages can be transmitted using Hypertext Transfer Protocol (HTTP) or Hypertext Transfer Protocol over Secure Socket Layer (HTTPS). The format of the request and response messages is specified in a definition of a Web service, where the definition conforms to the Web Service Description Language (WSDL).

    摘要翻译: 描述了一个XQuery访问API,用于使用XQuery语言提供从数据源访问XML数据。 请求者可以从服务器请求执行对XML数据的操作,其中请求消息和响应消息符合简单对象访问协议(SOAP)。 请求和响应消息可以使用超文本传输​​协议(HTTP)或超文本传输​​协议通过安全套接字层(HTTPS)传输。 请求和响应消息的格式在Web服务的定义中指定,其中定义符合Web服务描述语言(WSDL)。