SQL generation for assert, update and delete relational trees

Invention Grant

US09317554B2 SQL generation for assert, update and delete relational trees 有权

Title translation: 用于断言，更新和删除关系树的SQL生成

Please log in to see more content

Patent Title: SQL generation for assert, update and delete relational trees
Patent Title (中): 用于断言，更新和删除关系树的SQL生成
Application No.: US13627786

Application Date: 2012-09-26
Publication No.: US09317554B2

Publication Date: 2016-04-19
Inventor: Srinath Shankar , Rimma Nehme
Applicant: Microsoft Corporation
Applicant Address: US WA Redmond
Assignee: Microsoft Technology Licensing, LLC
Current Assignee: Microsoft Technology Licensing, LLC
Current Assignee Address: US WA Redmond
Agent Aneesh Mehta; Kate Drakos; Micky Minhas
Main IPC: G06F17/30
IPC: G06F17/30

SQL generation for assert, update and delete relational trees

Abstract:

Presented is a system and method for evaluating relational database queries in a distributed system. An optimized query plan is received by a control node. The query plan is decoded to a SQL statement that is semantically equivalent to the query plan, even though the query plan contains elements that have no direct analog in SQL. The decoded SQL is transmitted to a compute node for execution.

Abstract(Chinese):

提出了一种用于评估分布式系统中关系数据库查询的系统和方法。优化的查询计划由控制节点接收。查询计划被解码为在语义上等同于查询计划的SQL语句，即使查询计划包含在SQL中没有直接模拟的元素。解码的SQL被传送到计算节点以供执行。

Public/Granted literature

US20140089294A1 SQL GENERATION FOR ASSERT, UPDATE AND DELETE RELATIONAL TREES Public/Granted day:2014-03-27

Information query

Espacenet