QUERY PROCESSING PIPELINES WITH SINGLE-ITEM AND MULTIPLE-ITEM QUERY OPERATORS
    44.
    发明申请
    QUERY PROCESSING PIPELINES WITH SINGLE-ITEM AND MULTIPLE-ITEM QUERY OPERATORS 有权
    具有单项和多项查询操作者的查询处理管道

    公开(公告)号:US20090319498A1

    公开(公告)日:2009-12-24

    申请号:US12144639

    申请日:2008-06-24

    IPC分类号: G06F7/06 G06F17/30

    CPC分类号: G06F17/30427

    摘要: Queries against data sources (such as language-integrated queries to be applied against relational databases) may be prepared for processing by a query processing pipeline. This pipeline performs services including transforming the query into a form more easily applied by the data source, e.g., into SQL, by matching query terms with query operators configured to handle various query operations. Many query processing pipelines include single-item query operators that perform individual operations (e.g., an updating query operator that specifies an updating of individual records of a table.) An integrated query pipeline may be devised that includes both single-item query operators and multiple-item query operators that specify operations on sets of data items. An integrated query processing pipeline may analyze the query to determine whether a single-item or multiple-item operation is specified in order to select an appropriate query operator, which may improve the efficiency and performance of the data source querying.

    摘要翻译: 可以准备对数据源的查询(例如针对关系数据库应用的语言集成查询),以供查询处理流水线进行处理。 该流水线执行服务,包括通过将查询项与配置为处理各种查询操作的查询操作符相匹配,将查询转换成数据源更容易应用的形式,例如SQL转换。 许多查询处理流水线包括执行单独操作的单项查询运算符(例如,指定表的各个记录的更新的更新查询运算符)。可以设计一个综合查询流水线,其包括单项查询运算符和多个 - 用于指定数据项集合操作的目标查询运算符。 综合查询处理流水线可以分析查询以确定单项目或多项目操作是否被指定以便选择适当的查询运算符,这可以提高数据源查询的效率和性能。

    Automated client/server operation partitioning
    45.
    发明授权
    Automated client/server operation partitioning 有权
    自动客户端/服务器操作分区

    公开(公告)号:US08364751B2

    公开(公告)日:2013-01-29

    申请号:US12145523

    申请日:2008-06-25

    IPC分类号: G06F7/06 G06F17/30

    摘要: An operation (such as a relational query) may be processed on a processing engine (such as a relational database server) on behalf of a client. A conventional processing involves the delivery of the operation to the processing engine, which executes the entire operation to completion and returns a result data set. It may be more efficient to allocate part of the operation to be performed on the client, but a developer may be unable or unavailable to rewrite the operation in a distributed manner. Instead, the operation may be automatically partitioned into a pre-engine client portion, a processing engine portion, and a client portion, and the instructions of each portion may be automatically allocated respectively to the client, the server, and the client. The partitioning may be adjusted to conserve computing resources, such as bandwidth and storage, and the instructions may be reordered to improve the processing of the operation.

    摘要翻译: 可以在处理引擎(例如关系数据库服务器)上代表客户端处理操作(例如关系查询)。 常规处理涉及将操作传递到处理引擎,该处理引擎执行整个操作以完成并返回结果数据集。 分配要在客户端上执行的部分操作可能更有效,但开发人员可能无法或不可以以分布式方式重写操作。 相反,可以将操作自动分割为预引擎客户端部分,处理引擎部分和客户端部分,并且可以将每个部分的指令分别自动分配给客户端,服务器和客户端。 可以调整分区以节省诸如带宽和存储的计算资源,并且可以重新排序指令以改进操作的处理。

    Query processing pipelines with single-item and multiple-item query operators
    46.
    发明授权
    Query processing pipelines with single-item and multiple-item query operators 有权
    使用单项和多项查询运算符查询处理流水线

    公开(公告)号:US08375044B2

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

    申请号:US12144639

    申请日:2008-06-24

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30427

    摘要: Queries against data sources (such as language-integrated queries to be applied against relational databases) may be prepared for processing by a query processing pipeline. This pipeline performs services including transforming the query into a form more easily applied by the data source, e.g., into SQL, by matching query terms with query operators configured to handle various query operations. Many query processing pipelines include single-item query operators that perform individual operations (e.g., an updating query operator that specifies an updating of individual records of a table.) An integrated query pipeline may be devised that includes both single-item query operators and multiple-item query operators that specify operations on sets of data items. An integrated query processing pipeline may analyze the query to determine whether a single-item or multiple-item operation is specified in order to select an appropriate query operator, which may improve the efficiency and performance of the data source querying.

    摘要翻译: 可以准备对数据源的查询(例如针对关系数据库应用的语言集成查询),以供查询处理流水线进行处理。 该流水线执行服务,包括通过将查询项与配置为处理各种查询操作的查询操作符相匹配,将查询转换成数据源更容易应用的形式,例如SQL转换。 许多查询处理流水线包括执行单独操作的单项查询运算符(例如,指定表的各个记录的更新的更新查询运算符)。可以设计一个综合查询流水线,其包括单项查询运算符和多个 - 用于指定数据项集合操作的目标查询运算符。 综合查询处理流水线可以分析查询以确定单项目或多项目操作是否被指定以便选择适当的查询运算符,这可以提高数据源查询的效率和性能。

    Dynamically typed unsafe variance
    47.
    发明授权
    Dynamically typed unsafe variance 有权
    动态类型不安全差异

    公开(公告)号:US07694274B2

    公开(公告)日:2010-04-06

    申请号:US11193692

    申请日:2005-07-29

    IPC分类号: G06F9/44 G06F9/45

    CPC分类号: G06F9/44589 G06F9/45516

    摘要: A program execution engine that facilitates generic type variance verification is provided. The execution engine receives a program executable in the form of intermediate language (IL). The program executable can be based on code that includes expression(s) with generic type(s) which have been identified as requiring variance verification (e.g., covariance and/or contra-variance). The execution engine includes a variance verification component that dynamically determines whether value(s) associated with the generic type(s) identified as requiring variance verification comply with the particular variance verification requirement. The variance verification component can provide error information (e.g., throw an exception), if the specified variance is not safely compliant. Variance verification can be based on static checking which places the burden on a source language compiler to emit the run-time checks in intermediate language (IL), if run-time checked variance is required. Additionally, language(s) that do not support variance can treat generic type(s) as non-variant.

    摘要翻译: 提供了促进通用类型方差验证的程序执行引擎。 执行引擎以中间语言(IL)的形式接收可执行的程序。 程序可执行程序可以基于包括已经被识别为需要方差验证(例如协方差和/或反差)的通用类型的表达式的代码。 执行引擎包括方差验证组件,其动态地确定与被识别为需要方差验证的通用类型相关联的值是否符合特定方差验证要求。 方差验证组件可以提供错误信息(例如,抛出异常),如果指定的方差不能安全地符合。 方差验证可以基于静态检查,如果需要运行时检查方差,那么将源语言编译器的负担放在中间语言(IL)中发出运行时检查。 另外,不支持差异的语言可以将通用类型视为非变体。

    AUTOMATED CLIENT/SERVER OPERATION PARTITIONING
    50.
    发明申请
    AUTOMATED CLIENT/SERVER OPERATION PARTITIONING 有权
    自动客户端/服务器操作分区

    公开(公告)号:US20090327220A1

    公开(公告)日:2009-12-31

    申请号:US12145523

    申请日:2008-06-25

    IPC分类号: G06F7/06 G06F17/30

    摘要: An operation (such as a relational query) may be processed on a processing engine (such as a relational database server) on behalf of a client. A conventional processing involves the delivery of the operation to the processing engine, which executes the entire operation to completion and returns a result data set. It may be more efficient to allocate part of the operation to be performed on the client, but a developer may be unable or unavailable to rewrite the operation in a distributed manner. Instead, the operation may be automatically partitioned into a pre-engine client portion, a processing engine portion, and a client portion, and the instructions of each portion may be automatically allocated respectively to the client, the server, and the client. The partitioning may be adjusted to conserve computing resources, such as bandwidth and storage, and the instructions may be reordered to improve the processing of the operation.

    摘要翻译: 可以在处理引擎(例如关系数据库服务器)上代表客户端处理操作(例如关系查询)。 常规处理涉及将操作传递到处理引擎,该处理引擎执行整个操作以完成并返回结果数据集。 分配要在客户端上执行的部分操作可能更有效,但开发人员可能无法或不可以以分布式方式重写操作。 相反,可以将操作自动分割为预引擎客户端部分,处理引擎部分和客户端部分,并且可以将每个部分的指令分别自动分配给客户端,服务器和客户端。 可以调整分区以节省诸如带宽和存储的计算资源,并且可以重新排序指令以改进操作的处理。