EXPANDABLE AD HOC DOMAIN SPECIFIC QUERY FOR SYSTEM MANAGEMENT

• US 20150220553A1
• Filed: 01/31/2014
• Published: 08/06/2015
• Est. Priority Date: 01/31/2014
• Status: Active Grant

• Current Assignee: Dell Products LP (Dell Technologies Inc.)
• Original Assignee: Dell Products LP (Dell Technologies Inc.)
• Inventors: Poon, Stanley K., Silva, Ferdinand N., Lu, Yao, Shah, Praharsh S., Tripathi, Prabhat D., Milkey, Raymond
• Granted Patent: US 10,114,861 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2452 Query translation

Abstract

A system for performing an ad hoc query comprising a query service operating on a processor and configured to receive an ad hoc query in a domain-specific language. A query parsing service operating on the processor and configured to receive a validate request and a parse request from the query service and to return a query object to the query service. A queryable interface operating on the processor and configured to receive the query object and to transmit the query object to one or more framework services for execution. New domain key words can be introduced dynamically and matched to registered queryable services to process queries containing those key words.

Claims

1. A system for performing an ad hoc query comprising:

a query service operating on a processor and configured to receive an ad hoc query in a domain-specific language;

a query parsing service operating on the processor and configured to receive a validate request and a parse request from the query service and to return a query object to the query service; and

a queryable interface operating on the processor and configured to receive the query object and to transmit the query object to one or more framework services for execution, wherein the ad hoc query contains one or more new key words and the query parsing service and the queryable interface are configured to add the one or more new key words if they are located in an associated model in the framework services.

2. The system of claim 1 further comprising a persistence service configured to receive the query object and to respond to the query object with one or more fields in a query language syntax.

3. The system of claim 1 wherein the query object comprises one or more fields in a query language syntax.

4. The system of claim 1 wherein the query object comprises a SELECT clause comprising a distinct field designator that causes a unique set of objects to be returned.

5. The system of claim 1 wherein the query object comprises a FROM clause that identifies a persistable model class.

6. The system of claim 5 wherein the query object comprises a JOIN clause configured to join to entities related to the persistable model class in the FROM clause.

7. The system of claim 6 wherein the query object comprises an ON clause that is configured to specify one or more JOIN clause conditions.

8. The system of claim 1 wherein the query object comprises a WHERE clause that is configured to specify one or more conditional expressions to filter objects that do not satisfy the conditional expressions.

9. A method for performing an ad hoc query comprising:

electronically receiving an ad hoc query in a domain-specific language;

electronically receiving a validate request and a parse request from a query service operating on a processor returning a query object to the query service; and

electronically receiving the query object and transmitting the query object to one or more framework services operating on a processor for execution, wherein the ad hoc query contains one or more new key words and the query service is configured to add the one or more new key words if they are located in an associated model in the framework services.

10. The method of claim 9 further comprising receiving the query object and responding to the query object with one or more fields in a query language syntax.

11. The method of claim 9 wherein electronically receiving the query object comprises electronically receiving one or more fields in a query language syntax.

12. The method of claim 9 wherein electronically receiving the query object comprises electronically receiving a SELECT clause comprising a distinct field designator that causes a unique set of objects to be returned.

13. The method of claim 9 wherein electronically receiving the query object comprises electronically receiving a FROM clause that identifies a persistable model class.

14. The method of claim 13 wherein electronically receiving the query object comprises electronically receiving a JOIN clause configured to join to entities related to the persistable model class in the FROM clause.

15. The method of claim 14 wherein electronically receiving the query object comprises electronically receiving an ON clause that is configured to specify one or more JOIN clause conditions.

16. The method of claim 9 wherein electronically receiving the query object comprises electronically receiving a WHERE clause that is configured to specify one or more conditional expressions to filter objects that do not satisfy the conditional expressions.