Techniques of XML query optimization over dynamic heterogeneous XML containers
    32.
    发明申请
    Techniques of XML query optimization over dynamic heterogeneous XML containers 审中-公开
    动态异构XML容器的XML查询优化技术

    公开(公告)号:US20080016088A1

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

    申请号:US11486798

    申请日:2006-07-13

    IPC分类号: G06F7/00

    CPC分类号: G06F16/86

    摘要: A method and apparatus for optimizing XML queries over heterogeneous XML tables is provided. A query that targets a container (e.g. table or collection) that contains a plurality of XML documents is received, wherein at least two XML documents in the plurality do not conform to the same schema. Based on the received query, a plurality of execution plans is generated. Each execution plan is associated with a different XML schema. An execution plan is used to execute the query relative to those XML documents that conform to the XML schema associated with the execution plan.

    摘要翻译: 提供了一种用于在异构XML表上优化XML查询的方法和装置。 接收到针对包含多个XML文档的容器(例如表或集合)的查询,其中多个中的至少两个XML文档不符合相同的模式。 基于接收到的查询,生成多个执行计划。 每个执行计划与不同的XML模式相关联。 执行计划用于执行相对于符合与执行计划相关联的XML模式的那些XML文档的查询。

    Techniques of optimizing XQuery functions using actual argument type information
    33.
    发明授权
    Techniques of optimizing XQuery functions using actual argument type information 有权
    使用实际参数类型信息优化XQuery函数的技术

    公开(公告)号:US07913241B2

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

    申请号:US11452769

    申请日:2006-06-13

    IPC分类号: G06F9/45 G06F7/00

    CPC分类号: G06F17/30935 G06F8/437

    摘要: A method for optimizing functions is described. A query including an invocation of a function is received. A function declaration indicates that the function is associated with a first set of datatypes. At compile-time, static type-checking is performed on the query. During the static type-checking, a second set of datatypes is determined for the function. The second set of datatypes includes the datatype of each argument of the function that is specified in the invocation. The query is compiled, where compiling the query includes compiling the function with the second set of datatypes.

    摘要翻译: 描述了优化功能的方法。 收到包含函数调用的查询。 函数声明指示该函数与第一组数据类型相关联。 在编译时,对查询执行静态类型检查。 在静态类型检查期间,为函数确定第二组数据类型。 第二组数据类型包括在调用中指定的函数的每个参数的数据类型。 该查询被编译,其中编译查询包括使用第二组数据类型编译该函数。

    Techniques of XML query optimization over static and dynamic heterogeneous XML containers
    34.
    发明授权
    Techniques of XML query optimization over static and dynamic heterogeneous XML containers 有权
    基于静态和动态异构XML容器的XML查询优化技术

    公开(公告)号:US07577642B2

    公开(公告)日:2009-08-18

    申请号:US11486794

    申请日:2006-07-13

    IPC分类号: G06F7/00

    摘要: A method and apparatus for optimizing XML queries over heterogeneous XML tables is provided. A query that targets a container (e.g. table or collection) that contains a plurality of XML documents is received, wherein at least two XML documents in the plurality do not conform to the same schema. Based on the received query, a plurality of execution plans is generated. Each execution plan is associated with a different XML schema. An execution plan is used to execute the query relative to those XML documents that conform to the XML schema associated with the execution plan.

    摘要翻译: 提供了一种用于在异构XML表上优化XML查询的方法和装置。 接收到针对包含多个XML文档的容器(例如表或集合)的查询,其中多个中的至少两个XML文档不符合相同的模式。 基于接收到的查询,生成多个执行计划。 每个执行计划与不同的XML模式相关联。 执行计划用于执行相对于符合与执行计划相关联的XML模式的那些XML文档的查询。

    Techniques of using a relational caching framework for efficiently handling XML queries in the mid-tier data caching
    35.
    发明授权
    Techniques of using a relational caching framework for efficiently handling XML queries in the mid-tier data caching 有权
    使用关系缓存​​框架在中层数据缓存中有效处理XML查询的技术

    公开(公告)号:US07499909B2

    公开(公告)日:2009-03-03

    申请号:US11481159

    申请日:2006-07-03

    IPC分类号: G06F17/30

    摘要: A method and apparatus for processing queries is provided. A query is received at a mid-tier node of a multi-tier system. The mid-tier node includes a mid-tier cache that is configured to cache relational tables from one or more databases managed by a database server in a database tier of the multi-tier system. At the mid-tier node, a determination is made whether the received query includes an operator for requesting data of an XML datatype from the database server, where the XML datatype is supported as a native datatype by the database server. If a determination is made that the query includes such operator, then one or more portions of one or more relational tables are retrieved from the database server and stored in the mid-tier cache. The one or more relational tables store, in the one or more portions, index information associated with the requested data of the XML datatype. The received query is rewritten into a relational query against at least the one or more portions of the one or more relational tables that are stored in the mid-tier cache.

    摘要翻译: 提供了一种用于处理查询的方法和装置。 在多层系统的中间层节点处接收到查询。 中间层节点包括中间层缓存,其被配置为从多层系统的数据库层中的数据库服务器管理的一个或多个数据库缓存关系表。 在中间层节点,确定接收到的查询是否包括用于从数据库服务器请求数据类型的数据的操作员,其中数据库服务器将XML数据类型支持为本机数据类型。 如果确定查询包括这样的运算符,则从数据库服务器检索一个或多个关系表的一个或多个部分,并存储在中间层缓存中。 所述一个或多个关系表在一个或多个部分中存储与所述XML数据类型的所请求的数据相关联的索引信息。 所接收的查询根据至少存储在中间层高速缓存中的一个或多个关系表的一个或多个部分重写到关系查询中。

    Techniques of using a relational caching framework for efficiently handling XML queries in the mid-tier data caching
    36.
    发明申请
    Techniques of using a relational caching framework for efficiently handling XML queries in the mid-tier data caching 有权
    使用关系缓存​​框架在中层数据缓存中有效处理XML查询的技术

    公开(公告)号:US20080005093A1

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

    申请号:US11481159

    申请日:2006-07-03

    IPC分类号: G06F17/30

    摘要: A method and apparatus for processing queries is provided. A query is received at a mid-tier node of a multi-tier system. The mid-tier node includes a mid-tier cache that is configured to cache relational tables from one or more databases managed by a database server in a database tier of the multi-tier system. At the mid-tier node, a determination is made whether the received query includes an operator for requesting data of an XML datatype from the database server, where the XML datatype is supported as a native datatype by the database server. If a determination is made that the query includes such operator, then one or more portions of one or more relational tables are retrieved from the database server and stored in the mid-tier cache. The one or more relational tables store, in the one or more portions, index information associated with the requested data of the XML datatype. The received query is rewritten into a relational query against at least the one or more portions of the one or more relational tables that are stored in the mid-tier cache.

    摘要翻译: 提供了一种用于处理查询的方法和装置。 在多层系统的中间层节点处接收到查询。 中间层节点包括中间层缓存,其被配置为从多层系统的数据库层中的数据库服务器管理的一个或多个数据库缓存关系表。 在中间层节点,确定接收到的查询是否包括用于从数据库服务器请求数据类型的数据的操作员,其中数据库服务器将XML数据类型支持为本机数据类型。 如果确定查询包括这样的运算符,则从数据库服务器检索一个或多个关系表的一个或多个部分,并存储在中间层缓存中。 所述一个或多个关系表在一个或多个部分中存储与所述XML数据类型的所请求的数据相关联的索引信息。 所接收的查询根据存储在中间层高速缓存中的至少一个或多个关系表的一个或多个部分重写到关系查询中。

    Techniques of XML query optimization over static heterogeneous XML containers
    37.
    发明申请
    Techniques of XML query optimization over static heterogeneous XML containers 有权
    关于静态异构XML容器的XML查询优化技术

    公开(公告)号:US20080016122A1

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

    申请号:US11486794

    申请日:2006-07-13

    IPC分类号: G06F17/30

    摘要: A method and apparatus for optimizing XML queries over heterogeneous XML tables is provided. A query that targets a container (e.g. table or collection) that contains a plurality of XML documents is received, wherein at least two XML documents in the plurality do not conform to the same schema. Based on the received query, a plurality of execution plans is generated. Each execution plan is associated with a different XML schema. An execution plan is used to execute the query relative to those XML documents that conform to the XML schema associated with the execution plan.

    摘要翻译: 提供了一种用于在异构XML表上优化XML查询的方法和装置。 接收到针对包含多个XML文档的容器(例如表或集合)的查询,其中多个中的至少两个XML文档不符合相同的模式。 基于接收到的查询,生成多个执行计划。 每个执行计划与不同的XML模式相关联。 执行计划用于执行相对于符合与执行计划相关联的XML模式的那些XML文档的查询。

    Optimizing XSLT based on input XML document structure description and translating XSLT into equivalent XQuery expressions
    38.
    发明授权
    Optimizing XSLT based on input XML document structure description and translating XSLT into equivalent XQuery expressions 有权
    基于输入XML文档结构描述优化XSLT,并将XSLT转换为等价的XQuery表达式

    公开(公告)号:US07949941B2

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

    申请号:US11261684

    申请日:2005-10-28

    IPC分类号: G06F17/27

    CPC分类号: G06F17/227 G06F17/2247

    摘要: Transformation of a set of XML documents via an XSLT stylesheet is made more efficient by rewriting the stylesheet at compile-time, based on the structural description of the set of XML documents, into an optimized stylesheet containing fewer dynamic template-matching calls than the original stylesheet. This rewritten stylesheet can be further rewritten into a set of XQuery expressions. At compile-time, the particular transformation templates that are appropriate for transforming the particular nodes contained in the set of XML documents are determined, and XSLT calls to the templates are converted to calls to corresponding XQuery user-defined functions. Determination of the appropriate transformation templates may be based on the structural description of the input set of XML documents, such as an XML Schema or Document Type Definition. The data from each template is translated into corresponding XQuery constructors, instructions from the template are translated into XQuery expressions, and the XQuery functions are inlined if possible.

    摘要翻译: 通过XSLT样式表转换一组XML文档通过将编译时的样式表(基于XML文档集的结构描述)重写为优化样式表,使其具有比原始文本更少的动态模板匹配调用 样式表。 这个重写的样式表可以进一步重写成一组XQuery表达式。 在编译时,确定适合于转换XML文档集中的特定节点的特定转换模板,并将XSLT对模板的调用转换为对相应XQuery用户定义函数的调用。 确定适当的转换模板可以基于XML文档的输入集合的结构描述,例如XML模式或文档类型定义。 来自每个模板的数据被转换为相应的XQuery构造函数,模板中的指令将被转换为XQuery表达式,如果可能的话XQuery函数是内联的。

    Processing XML data stream(s) using continuous queries in a data stream management system
    39.
    发明申请
    Processing XML data stream(s) using continuous queries in a data stream management system 审中-公开
    在数据流管理系统中使用连续查询来处理XML数据流

    公开(公告)号:US20080120283A1

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

    申请号:US11601415

    申请日:2006-11-17

    IPC分类号: G06F17/30

    CPC分类号: G06F16/83

    摘要: A computer is programmed to accept queries over streams of, data structured as per a predetermined syntax (e.g. defined in XML). The computer is further programmed to execute such queries continually (or periodically) on data streams of tuples containing structured data that conform to the same predetermined syntax. In many embodiments, the computer includes an engine that exclusively processes only structured data, quickly and efficiently. The computer invokes the structured data engine in two different ways depending on the embodiment: (a) directly on encountering a structured data operator, or (b) indirectly by parsing operands within the structured data operator which contain path expressions, creating a new source to supply scalar data extracted from structured data, and generating additional trees of operators that are natively supported, followed by invoking the structured data engine only when the structured data operator in the query cannot be fully implemented by natively supported operators.

    摘要翻译: 计算机被编程为接受根据预定语法(例如以XML定义)结构化的数据流的查询。 计算机还被编程为在包含符合相同预定语法的结构化数据的元组的数据流上持续地(或周期性地)执行这样的查询。 在许多实施例中,计算机包括仅仅快速有效地处理结构化数据的引擎。 根据实施例,计算机以两种不同的方式调用结构化数据引擎:(a)直接遇到结构化数据运算符,或(b)间接地通过解析包含路径表达式的结构化数据运算符中的操作数,创建新的源 提供从结构化数据中提取的标量数据,并产生本机支持的操作符的附加树,之后仅当查询中的结构化数据运算符不能由本机支持的运算符完全实现时调用结构化数据引擎。

    Techniques of optimizing XQuery functions using actual argument type information
    40.
    发明申请
    Techniques of optimizing XQuery functions using actual argument type information 有权
    使用实际参数类型信息优化XQuery函数的技术

    公开(公告)号:US20070288429A1

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

    申请号:US11452769

    申请日:2006-06-13

    IPC分类号: G06F17/30 G06F7/00

    CPC分类号: G06F17/30935 G06F8/437

    摘要: A method for optimizing functions is described. A query including an invocation of a function is received. A function declaration indicates that the function is associated with a first set of datatypes. At compile-time, static type-checking is performed on the query. During the static type-checking, a second set of datatypes is determined for the function. The second set of datatypes includes the datatype of each argument of the function that is specified in the invocation. The query is compiled, where compiling the query includes compiling the function with the second set of datatypes.

    摘要翻译: 描述了优化功能的方法。 收到包含函数调用的查询。 函数声明指示该函数与第一组数据类型相关联。 在编译时,对查询执行静态类型检查。 在静态类型检查期间,为函数确定第二组数据类型。 第二组数据类型包括在调用中指定的函数的每个参数的数据类型。 该查询被编译,其中编译查询包括使用第二组数据类型编译该函数。