Data query translating into mixed language data queries
    1.
    发明授权
    Data query translating into mixed language data queries 有权
    数据查询转换为混合语言数据查询

    公开(公告)号:US08819046B2

    公开(公告)日:2014-08-26

    申请号:US12144630

    申请日:2008-06-24

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30451 G06F17/30427

    摘要: Data source queries may be specified in various languages, such as SQL, XQuery, and object-oriented languages, and each language may have various linguistic features that enable different types of queries. It may be advantageous to formulate mixed language queries having portions specified in a first language and portions specified in a second language, and to provide mixed language query evaluation components that can parse portions of queries of different languages. It may also be advantageous to permit the translation of single language queries into multiple languages to be parsed by such mixed language query evaluation components. Such techniques may permit queries to utilize linguistic features and processing techniques of one language that are less efficient, less direct, or simply unavailable in another language.

    摘要翻译: 数据源查询可以用各种语言来指定,例如SQL,XQuery和面向对象的语言,并且每个语言可以具有各种各样的语言特征,从而实现不同类型的查询。 制定具有以第一语言指定的部分和以第二语言指定的部分的混合语言查询可能是有利的,并且提供可以解析部分不同语言的查询的混合语言查询评估组件。 允许将单个语言查询转换成由这种混合语言查询评估组件解析的多种语言也是有利的。 这样的技术可以允许查询利用一种语言的语言特征和处理技术,该语言特征和处理技术在另一种语言中效率较低,较不直接或者简单地不可用。

    DATA QUERY TRANSLATING INTO MIXED LANGUAGE DATA QUERIES
    2.
    发明申请
    DATA QUERY TRANSLATING INTO MIXED LANGUAGE DATA QUERIES 有权
    数据查询翻译成混合语言数据查询

    公开(公告)号:US20090319496A1

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

    申请号:US12144630

    申请日:2008-06-24

    IPC分类号: G06F7/06 G06F17/30

    CPC分类号: G06F17/30451 G06F17/30427

    摘要: Data source queries may be specified in various languages, such as SQL, XQuery, and object-oriented languages, and each language may have various linguistic features that enable different types of queries. It may be advantageous to formulate mixed language queries having portions specified in a first language and portions specified in a second language, and to provide mixed language query evaluation components that can parse portions of queries of different languages. It may also be advantageous to permit the translation of single language queries into multiple languages to be parsed by such mixed language query evaluation components. Such techniques may permit queries to utilize linguistic features and processing techniques of one language that are less efficient, less direct, or simply unavailable in another language.

    摘要翻译: 数据源查询可以用各种语言来指定,例如SQL,XQuery和面向对象的语言,并且每个语言可以具有各种各样的语言特征,从而实现不同类型的查询。 制定具有以第一语言指定的部分和以第二语言指定的部分的混合语言查询可能是有利的,并且提供可以解析部分不同语言的查询的混合语言查询评估组件。 允许将单个语言查询转换成由这种混合语言查询评估组件解析的多种语言也是有利的。 这样的技术可以允许查询利用一种语言的语言特征和处理技术,该语言特征和处理技术在另一种语言中效率较低,较不直接或者简单地不可用。

    Query processing with specialized query operators
    3.
    发明授权
    Query processing with specialized query operators 有权
    使用专门的查询运算符进行查询处理

    公开(公告)号:US08713048B2

    公开(公告)日:2014-04-29

    申请号:US12144670

    申请日:2008-06-24

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30436

    摘要: Queries targeting various data sources are processed in a query processing pipeline that parses the query into a set of operations (e.g., an expression tree or a translated SQL query) using a set of query operators, each handling a particular type of operation. The query operators are often designed in an unspecialized manner, such that each query operator handles one query operation in an atomic, generic manner (e.g., sorting generic data items for an ORDER BY clause.) More efficient queries may be devised by including specialized queries that operate in common but special cases, such as a sorting of a particular data type (e.g., a floating-point number sort) or a sequence of two or more operations that are often performed together (e.g., a WHERE test of an attribute followed by a SELECT of the same attribute.) The use of specialized operators may result in the formulation of more efficient queries.

    摘要翻译: 定位各种数据源的查询在查询处理流水线中处理,该查询处理流水线使用一组查询运算符(每个处理特定类型的操作)将查询解析为一组操作(例如,表达式树或翻译的SQL查询)。 查询运算符通常以非特定方式进行设计,使得每个查询运算符以原子,通用方式处理一个查询操作(例如,排序ORDER BY子句的通用数据项)。可以通过包括专门的查询来设计更有效的查询 其在常见但特殊的情况下操作,诸如特定数据类型的排序(例如,浮点数排序)或经常一起执行的两个或更多个操作的序列(例如,跟随的属性的WHERE测试 通过具有相同属性的SELECT)。使用专门的运算符可能会导致更有效的查询的编制。

    QUERY PROCESSING WITH SPECIALIZED QUERY OPERATORS
    4.
    发明申请
    QUERY PROCESSING WITH SPECIALIZED QUERY OPERATORS 有权
    具有专业查询操作员的查询处理

    公开(公告)号:US20090319499A1

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

    申请号:US12144670

    申请日:2008-06-24

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30436

    摘要: Queries targeting various data sources are processed in a query processing pipeline that parses the query into a set of operations (e.g., an expression tree or a translated SQL query) using a set of query operators, each handling a particular type of operation. The query operators are often designed in an unspecialized manner, such that each query operator handles one query operation in an atomic, generic manner (e.g., sorting generic data items for an ORDER BY clause.) More efficient queries may be devised by including specialized queries that operate in common but special cases, such as a sorting of a particular data type (e.g., a floating-point number sort) or a sequence of two or more operations that are often performed together (e.g., a WHERE test of an attribute followed by a SELECT of the same attribute.) The use of specialized operators may result in the formulation of more efficient queries.

    摘要翻译: 定位各种数据源的查询在查询处理流水线中处理,该查询处理流水线使用一组查询运算符(每个处理特定类型的操作)将查询解析为一组操作(例如,表达式树或翻译的SQL查询)。 查询运算符通常以非特定方式进行设计,使得每个查询运算符以原子,通用方式处理一个查询操作(例如,排序ORDER BY子句的通用数据项)。可以通过包括专门的查询来设计更有效的查询 其在常见但特殊的情况下操作,诸如特定数据类型的排序(例如,浮点数排序)或经常一起执行的两个或更多个操作的序列(例如,跟随的属性的WHERE测试 通过具有相同属性的SELECT)。使用专门的运算符可能会导致更有效的查询的编制。

    Automated translation of service invocations for batch processing
    5.
    发明授权
    Automated translation of service invocations for batch processing 有权
    自动翻译服务调用批量处理

    公开(公告)号:US08364750B2

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

    申请号:US12144634

    申请日:2008-06-24

    IPC分类号: G06F15/16

    CPC分类号: G06F9/547

    摘要: The utilization of data services (such as web services) may involve the invocation of services, which may reduce performance and overburden the server. In some scenarios, the invocation may be specified in a language that does not support batch invocation, but it may not be feasible to re-code the invocations in a language that supports batching. Instead, the service invocations may be automatically translated into a batch logic specified in a batch-capable language and sent to the service as a batch. For example, a local proxy may receive a language-integrated query having two or more service invocations, compile the query into an expression tree including the two or more invocations, and send the expression tree to the service host to achieve the batch processing of the service invocations.

    摘要翻译: 数据服务(如Web服务)的使用可能涉及服务的调用,这可能会降低服务器的性能和负担。 在某些情况下,可以使用不支持批量调用的语言来指定调用,但以支持批处理的语言重新编码调用可能不可行。 相反,服务调用可以自动转换为以批处理语言指定的批处理逻辑,并作为批处理发送到服务。 例如,本地代理可以接收具有两个或多个服务调用的语言集成查询,将查询编译成包括两个或更多个调用的表达式树,并将表达式树发送到服务主机以实现批处理 服务调用。

    AUTOMATED CLIENT/SERVER OPERATION PARTITIONING
    6.
    发明申请
    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.

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

    Automated client/server operation partitioning
    7.
    发明授权
    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.

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

    AUTOMATED TRANSLATION OF SERVICE INVOCATIONS FOR BATCH PROCESSING
    8.
    发明申请
    AUTOMATED TRANSLATION OF SERVICE INVOCATIONS FOR BATCH PROCESSING 有权
    自动翻译用于批处理的服务协议

    公开(公告)号:US20090319497A1

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

    申请号:US12144634

    申请日:2008-06-24

    IPC分类号: G06F17/30

    CPC分类号: G06F9/547

    摘要: The utilization of data services (such as web services) may involve the invocation of services, which may reduce performance and overburden the server. In some scenarios, the invocation may be specified in a language that does not support batch invocation, but it may not be feasible to re-code the invocations in a language that supports batching. Instead, the service invocations may be automatically translated into a batch logic specified in a batch-capable language and sent to the service as a batch. For example, a local proxy may receive a language-integrated query having two or more service invocations, compile the query into an expression tree including the two or more invocations, and send the expression tree to the service host to achieve the batch processing of the service invocations.

    摘要翻译: 数据服务(如Web服务)的使用可能涉及服务的调用,这可能会降低服务器的性能和负担。 在某些情况下,可以使用不支持批量调用的语言来指定调用,但以支持批处理的语言重新编码调用可能不可行。 相反,服务调用可以自动转换为以批处理语言指定的批处理逻辑,并作为批处理发送到服务。 例如,本地代理可以接收具有两个或多个服务调用的语言集成查询,将查询编译成包括两个或更多个调用的表达式树,并将表达式树发送到服务主机以实现批处理 服务调用。

    QUERY PROCESSING PIPELINES WITH SINGLE-ITEM AND MULTIPLE-ITEM QUERY OPERATORS
    9.
    发明申请
    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转换。 许多查询处理流水线包括执行单独操作的单项查询运算符(例如,指定表的各个记录的更新的更新查询运算符)。可以设计一个综合查询流水线,其包括单项查询运算符和多个 - 用于指定数据项集合操作的目标查询运算符。 综合查询处理流水线可以分析查询以确定单项目或多项目操作是否被指定以便选择适当的查询运算符,这可以提高数据源查询的效率和性能。

    Query processing pipelines with single-item and multiple-item query operators
    10.
    发明授权
    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转换。 许多查询处理流水线包括执行单独操作的单项查询运算符(例如,指定表的各个记录的更新的更新查询运算符)。可以设计一个综合查询流水线,其包括单项查询运算符和多个 - 用于指定数据项集合操作的目标查询运算符。 综合查询处理流水线可以分析查询以确定单项目或多项目操作是否被指定以便选择适当的查询运算符,这可以提高数据源查询的效率和性能。