QUERY TEMPLATES FOR QUERIES IN DATA STREAM MANAGEMENT SYSTEMS

• US 20140082013A1
• Filed: 09/20/2012
• Published: 03/20/2014
• Est. Priority Date: 09/20/2012
• Status: Abandoned Application

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Wolf, Bernhard, Schramm, Arne, Preussner, Andre, Hartung, Raik
• Application Number:
  US13/623,682
• Publication Number:
  US 20140082013A1
• Time in Patent Office: Days
• US Class Current: 707/769
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/2453 Query optimisation

Abstract

A template manager may determine a query template for instantiation thereof to thereby obtain a query instance for application of the query instance against stream data of a data stream management system, the query template including placeholders. A value handler may be configured to replace the placeholders with corresponding substitution values to obtain the query instance. A query instance manager may be configured to deploy the query instance within the data stream management system for application against the stream data

Claims

1. A system including instructions recorded on a computer-readable medium and executable by at least one processor, the system comprising:

a template manager configured to cause the at least one processor to determine a query template for instantiation thereof to thereby obtain a query instance for application of the query instance against stream data of a data stream management system, the query template including placeholders;

a value handler configured to cause the at least one processor to replace the placeholders with corresponding substitution values to obtain the query instance; and

a query instance manager configured to cause the at least one processor to deploy the query instance within the data stream management system for application against the stream data.

2. The system of claim 1, wherein the placeholders are included at designated alterable fields of the query template.

3. The system of claim 1, wherein the template manager is configured to construct the query template including receiving user-designated, placeholder positions of the placeholders within the query template.

4. The system of claim 1, wherein the template manager is configured to identify the query template in response to a request from a user, from among a plurality of pre-stored query templates.

5. The system of claim 1, wherein the template manager is configured to relate a placeholder position for each of the placeholders within the query template to a type of substitution value associated therewith.

6. The system of claim 1, wherein the value handler is configured to determine an associated type of substitution value for each of the placeholders, and further configured to request and receive the corresponding substitution values of each placeholder from a user.

7. The system of claim 1, wherein the substitution values include input streams of data to be processed by the data stream management system, and/or output streams of data to be produced by the data stream management system.

8. The system of claim 1, wherein the substitution values include parameters characterizing operations to be executed by the data stream management system during the application of the query instance.

9. The system of claim 1, wherein the query instance manager is configured to receive the query template and associated substitution values from the template manager and the value handler, wherein each substitution value is associated with a position of a corresponding placeholder of the placeholders.

10. A computer-implemented method for executing instructions stored on a computer readable storage medium, the method comprising:

determining a query template for instantiation thereof to thereby obtain a query instance for application of the query instance against stream data of a data stream management system, the query template including placeholders;

replacing the placeholders with corresponding substitution values to obtain the query instance; and

deploying the query instance within the data stream management system for application against the stream data.

11. The method of claim 10, wherein a placeholder position for each of the placeholders within the query template is related to a type of substitution value associated therewith.

12. The method of claim 10, wherein replacing the placeholders comprises:

determining an associated type of substitution value for each of the placeholders; and

requesting and receiving the corresponding substitution values of each placeholder from a user.

13. The method of claim 10, wherein the substitution values include input streams of data to be processed by the data stream management system, and/or output streams of data to be produced by the data stream management system.

14. The method of claim 10, wherein the substitution values include parameters characterizing operations to be executed by the data stream management system during the application of the query instance.

15. A computer program product, the computer program product being tangibly embodied on a computer-readable storage medium and comprising instructions that, when executed, are configured to:

determine a query template for instantiation thereof to thereby obtain a query instance for application of the query instance against stream data of a data stream management system, the query template including placeholders;

replace the placeholders with corresponding substitution values to obtain the query instance; and

deploy the query instance within the data stream management system for application against the stream data.

16. The computer program product of claim 15, wherein the instructions, in being configured to determine the query template for instantiation thereof, are further configured to identify the query template in response to a request from a user, from among a plurality of pre-stored query templates.

17. The computer program product of claim 15, wherein the instructions, in being configured to replace the placeholders with corresponding substitution values, are further configured to determine an associated type of substitution value for each of the placeholders, and further configured to request and receive the corresponding substitution values of each placeholder from a user.

18. The computer program product of claim 15, wherein the query substitution values include input streams of data to be processed by the data stream management system, and/or output streams of data to be produced by the data stream management system.

19. The computer program product of claim 15, wherein the substitution values include parameters characterizing operations to be executed by the data stream management system during the application of the query instance.

20. The computer program product of claim 15, wherein each substitution value is associated with a position within the query template of a corresponding placeholder of the placeholders.