首页> 外国专利> HARMONIZED STRUCTURED QUERY LANGUAGE AND NON-STRUCTURED QUERY LANGUAGE QUERY PROCESSING

HARMONIZED STRUCTURED QUERY LANGUAGE AND NON-STRUCTURED QUERY LANGUAGE QUERY PROCESSING

机译：统一的结构化查询语言和非结构化的查询语言处理

页面导航

摘要
著录项
相似文献

摘要

A method can include: generating a query execution plan for a query including a plurality of operations that operate on data from a relational database and data from a non-structured query language (NoSQL) database, the generating comprising optimizing the query by: identifying a first operation that operate on data from the relational database and an intermediate result output by a second operation, the second operation outputting the intermediate result by operating on the data from the NoSQL database; and determining a fixed datatype for the intermediate result, an indication of the fixed datatype being included in the query execution plan; and executing, based on the query execution plan, the query, the executing of the query comprising converting the intermediate result to the fixed datatype, the converting enabling the first operation to operate on the intermediate result output by the second operation along with the data from the relational database.

机译：一种方法可以包括：为查询生成查询执行计划，该查询执行计划包括对来自关系数据库的数据和来自非结构化查询语言（NoSQL）数据库的数据进行操作的多个操作，该生成包括通过以下步骤来优化查询：对来自关系数据库的数据进行操作的第一操作和由第二操作输出的中间结果，第二操作通过对来自NoSQL数据库的数据进行操作来输出中间结果;确定中间结果的固定数据类型，该固定数据类型的指示包括在查询执行计划中;基于查询执行计划，执行查询，查询的执行包括将中间结果转换为固定数据类型，该转换使得第一操作可以对第二操作输出的中间结果以及来自第二操作的数据进行操作。关系数据库。

著录项

公开/公告号US2018293276A1

专利类型
公开/公告日2018-10-11

原文格式PDF
申请/专利权人 SAP SE;
展开▼

申请/专利号US201715483690
发明设计人 JIN UK BAE;KI HONG KIM;TAEHYUNG LEE;CHRISTIAN BENSBERG;JAEYUN NOH;DI WU;STEFAN BAEUERLE;STEFFEN GEISSINGER;LONG ZHANG;
展开▼

申请日2017-04-10
分类号G06F17/30;
国家 US
入库时间 2022-08-21 13:02:53

相似文献

专利
外文文献
中文文献