Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Multi-step query execution in SQL server

A technology for querying sub and step sets, which is applied in the fields of instrumentation, computing, electrical digital data processing, etc.

Pending Publication Date: 2021-05-14
MICROSOFT TECH LICENSING LLC
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] Methods, systems, and computer readable memory devices are provided that solve problems related to the efficient execution of graph queries and other types of queries in relational database systems by providing multi-step sequential query plan operators

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Multi-step query execution in SQL server
  • Multi-step query execution in SQL server
  • Multi-step query execution in SQL server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] I. Introduction

[0031] The specification and drawings disclose one or more embodiments that incorporate the features of the disclosed embodiments. The scope of the embodiments is not limited only to the aspects disclosed herein. The disclosed embodiments are merely illustrative of the intended scope and modified versions of the disclosed embodiments are also intended to be encompassed. Embodiments are defined by the appended claims.

[0032] References in the specification to "an aspect," "an embodiment," "example embodiment," etc. indicate that the described embodiments may include a particular feature, structure, or characteristic, but that each embodiment may not necessarily include the particular feature, structure, or characteristic. structure or feature. Moreover, such phrases are not necessarily referring to the same embodiment. Further, when a particular feature, structure or characteristic is described in conjunction with an embodiment, it can be consider...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

Methods, systems, and computer program products are provided that construct and execute multi-step query plans in a database application. A database application accepts a query such as, for example, a graph query. The database application generates a physical query plan comprising a set of execution steps that perform the query. The set of execution steps comprises at least an initial step, an intermediate step and a final step. The database executes the query by passing control to the initial step that, when complete, passes execution control to some other step. The intermediate step executes and when complete, may pass execution control to any other step including itself. Steps may be configured to communicate arbitrary data between steps. The generated query plan may also comprise multiple multi-step sequences, and such sequences may be configured to execute in the alternative based on intermediate query results, or a parameter included in the query.

Description

Background technique [0001] The modern digital world is experiencing exponential growth in the volume of data associated with every aspect of business and personal life. Solutions for efficiently storing and recalling such information are urgently needed. Businesses in particular need to transform collected and stored data into actionable intelligence. Relational database systems, and applications written to utilize such systems, are traditional tools for describing, storing and retrieving business information. Recently, however, the demand for graph database systems has increased. [0002] Instead of the traditional columns and rows of relational database tables, graph databases store data in the form of nodes and edges. Nodes represent distinct data values ​​or collections of related values, and edges connect nodes to represent relationships therebetween. An edge may also have one or more associated values ​​(eg the duration of the relationship). For example, data relat...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/2453
CPCG06F16/24542G06F16/2246G06F16/24535
Inventor C·S·弗雷德曼C·卡迪亚姆D·L·里德D·G·沙尔
Owner MICROSOFT TECH LICENSING LLC
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com