IP Library Granted Patent US 11,907,246
Granted Patent B2
US 11,907,246 · App. 16/038,408 · Granted Feb 20, 2024

Methods, systems, and computer readable mediums for performing a free-form query

Inventors: Rajesh Nandyalam (Whitinsville, MA); Geoffrey David Bourne (Allen, TX); Joseph K. Malek (Seattle, WA)
Assignee: EMC IP Holding Company LLC
G06F16/258G06F16/8358G06F16/9535
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,907,246
App. No.
16/038,408
Granted
Feb 20, 2024
Kind
B2
Abstract

Methods, systems, and computer readable mediums for performing a free-form query are disclosed. According to one exemplary embodiment, a method for performing a free-form query includes receiving free-form information for requesting information about a computing system, converting the free-form information into at least one compatible query for querying at least one data set, querying, using the at least one compatible query, the at least one data set for the information about the computing system, and providing the information about the computing system.

Claims (32)

1. A method for performing a free-form query, the method comprising:

at a query engine implemented using a hardware-based processor:

receiving, from an operator, free-form information for requesting information about a computing system comprising a converged infrastructure system (CIS) managed by the operator;

converting the free-form information into at least one compatible query for querying at least one data set, wherein converting the free-form information includes generating, using a grammar parser, a parsing tree representing the free-form information, wherein the parsing tree is independent of a first data management system and a second data management system, and generating, using the parsing tree, the at least one compatible query that is understandable by at least the first data management system managing the at least one data set, wherein generating the at least one compatible query includes performing, using the parsing tree, a query analysis for identifying additional information to obtain for generating the at least one compatible query and requesting and receiving, via a graphical user interface, the additional information, wherein the at least one compatible query includes a query for querying a management information base (MIB) or a query for querying a JavaScript object notation (JSON) object;

querying, using the at least one compatible query, the at least one data set for the information about the computing system, wherein querying, using the at least one compatible query, the at least one data set for the information about the computing system includes generating a second query using the at least one compatible query or results from querying the at least one data set, wherein the at least one compatible query or the results indicate a CIS element of the CIS and querying, using the second query, a graph related data structure for identifying adjacent data elements associated with a first data element comprising data about the CIS element, wherein one adjacent data element to the first data element is based on information obtained from the first data management system and a different adjacent data element to the first data element is based on information obtained from the second data management system; and

providing the information about the computing system.

2. The method of claim 1 wherein the free-form information includes a natural language or semi-natural language query.

3. The method of claim 1 wherein converting the free-form information includes generating, using the parsing tree, at least one compatible query that is understandable by the second data management system.

4. The method of claim 1 wherein querying, using the at least one compatible query, the at least one data set for the information about the computing system includes utilizing the graph related data structure for obtaining contextually relevant information associated with the information about the computing system.

5. The method of claim 4 wherein the contextually relevant information includes at least one member selected from a group consisting of statistics based on the information about the computing system, a maximum of a set of values, a minimum of a set of values, an average of a set of values, an aggregation of a set of values, a derived value using information from one or more sources, and information stored in at least one adjacent element to an element storing the information about the computing system in the graph related data structure.

6. The method of claim 4 wherein the at least one data set and the graph related data structure are associated with one or more data management systems.

7. The method of claim 1 wherein the information about the computing system includes information about at least one member selected from a group consisting of a computing platform, a computing device, a virtual machine, a hypervisor, a compute component, a network component, a storage component, software, an operating system, firmware, hardware, a physical resource, and a virtual resource.

8. A system for performing a free-form query, the system comprising:

a hardware-based processor; and

a query engine implemented using the hardware-based processor, wherein the query engine is configured to receive, from an operator, free-form information for requesting information about a computing system comprising a converged infrastructure system (CIS) managed by the operator, to convert the free-form information into at least one compatible query for querying at least one data set, wherein converting the free-form information includes generating, using a grammar parser, a parsing tree representing the free-form information, wherein the parsing tree is independent of a first data management system and a second data management system, and generating, using the parsing tree, the at least one compatible query that is understandable by at least the first data management system managing the at least one data set, wherein generating the at least one compatible query includes performing, using the parsing tree, a query analysis for identifying additional information to obtain for generating the at least one compatible query and requesting and receiving, via a graphical user interface, the additional information, wherein the at least one compatible query includes a query for querying a management information base (MIB) or a query for querying a JavaScript object notation (JSON) object, to query, using the at least one compatible query, the at least one data set for the information about the computing system, wherein querying, using the at least one compatible query, the at least one data set for the information about the computing system includes generating a second query using the at least one compatible query or results from querying the at least one data set, wherein the at least one compatible query or the results indicate a CIS element of the CIS and querying, using the second query, a graph related data structure for identifying adjacent data elements associated with a first data element comprising data about the CIS element, wherein one adjacent data element to the first data element is based on information obtained from the first data management system and a different adjacent data element to the first data element is based on information obtained from a second data management system, and to provide the information about the computing system.

9. The system of claim 8 wherein the free-form information includes a natural language or semi-natural language query.

10. The system of claim 8 wherein the query engine is configured to generate, using the parsing tree, at least one compatible query that is understandable by the second data management system.

11. The system of claim 8 wherein the query engine is configured to utilize a graph related data structure for obtaining at the graph related data structure for obtaining contextually relevant information associated with the information about the computing system.

12. The system of claim 11 wherein the contextually relevant information includes at least one member selected from a group consisting of statistics based on the information about the computing system, a maximum of a set of values, a minimum of a set of values, an average of a set of values, an aggregation of a set of values, a derived value using information from one or more sources, and information stored in at least one adjacent element to an element storing the information about the computing system in the graph related data structure.

13. The system of claim 11 wherein the at least one data set and the graph related data structure are associated with one or more data management systems.

14. The system of claim 8 wherein the information about the computing system includes information about at least one member selected from a group consisting of a computing platform, a computing device, a virtual machine, a hypervisor, a compute component, a network component, a storage component, software, an operating system, firmware, hardware, a physical resource, and a virtual resource.

15. A non-transitory computer readable medium having stored thereon executable instructions which, when executed by a processor of a computer, cause the computer to perform steps comprising:

at a query engine implemented using a hardware-based processor:

receiving, from an operator, free-form information for requesting information about a computing system comprising a converged infrastructure system (CIS) managed by the operator;

converting the free-form information into at least one compatible query for querying at least one data set, wherein converting the free-form information includes generating, using a grammar parser, a parsing tree representing the free-form information, wherein the parsing tree is independent of a first data management system and a second data management system, and generating, using the parsing tree, the at least one compatible query that is understandable by at least the first data management system managing the at least one data set, wherein generating the at least one compatible query includes performing, using the parsing tree, a query analysis for identifying additional information to obtain for generating the at least one compatible query and requesting and receiving, via a graphical user interface, the additional information, wherein the at least one compatible query includes a query for querying a management information base (MIB) or a query for querying a JavaScript object notation (JSON) object;

querying, using the at least one compatible query, the at least one data set for the information about the computing system, wherein querying, using the at least one compatible query, the at least one data set for the information about the computing system includes generating a second query using the at least one compatible query or results from querying the at least one data set, wherein the at least one compatible query or the results indicate a CIS element of the CIS and querying, using the second query, a graph related data structure for identifying adjacent data elements associated with a first data element comprising data about the CIS element, wherein one adjacent data element to the first data element is based on information obtained from the first data management system and a different adjacent data element to the first data element is based on information obtained from a second data management system; and

providing the information about the computing system.

16. The non-transitory computer readable medium of claim 15 wherein the free-form information includes a natural language or semi-natural language query.

17. The non-transitory computer readable medium of claim 15 wherein converting the free-form information includes generating, using the parsing tree, at least one compatible query that is understandable by the second data management system.

18. The non-transitory computer readable medium of claim 15 wherein querying, using the at least one compatible query, the at least one data set for the information about the computing system includes utilizing the graph related data structure for obtaining the graph related data structure for obtaining contextually relevant information associated with the information about the computing system.

19. The non-transitory computer readable medium of claim 18 wherein the contextually relevant information includes at least one member selected from a group consisting of statistics based on the information about the computing system, a maximum of a set of values, a minimum of a set of values, an average of a set of values, an aggregation of a set of values, a derived value using information from one or more sources, and information stored in at least one adjacent element to an element storing the information about the computing system in the graph related data structure.

20. The non-transitory computer readable medium of claim 18 wherein the at least one data set and the graph related data structure are associated with one or more data management systems.

Assignments (10)
RELEASE OF SECURITY INTEREST IN PATENTS PREVIOUSLY RECORDED AT REEL/FRAME (053546/0001) Recorded Jun 23, 2022
From: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS NOTES COLLATERAL AGENT
To: DELL MARKETING L.P. (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO CREDANT TECHNOLOGIES, INC.); DELL INTERNATIONAL L.L.C.; DELL PRODUCTS L.P.; DELL USA L.P.; EMC CORPORATION; DELL MARKETING CORPORATION (SUCCESSOR-IN-INTEREST TO FORCE10 NETWORKS, INC. AND WYSE TECHNOLOGY L.L.C.); EMC IP HOLDING COMPANY LLC
Reel/Frame 071642/0001 →
RELEASE OF SECURITY INTEREST IN PATENTS PREVIOUSLY RECORDED AT REEL/FRAME (047648/0422) Recorded May 20, 2022
From: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS NOTES COLLATERAL AGENT
To: DELL PRODUCTS L.P.; EMC CORPORATION; EMC IP HOLDING COMPANY LLC
Reel/Frame 060160/0862 →
RELEASE OF SECURITY INTEREST AT REEL 047648 FRAME 0346 Recorded Nov 2, 2021
From: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH
To: DELL PRODUCTS L.P.; EMC CORPORATION; EMC IP HOLDING COMPANY LLC
Reel/Frame 058298/0510 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jul 15, 2020
From: VCE COMPANY, LLC
To: VCE IP HOLDING COMPANY LLC
Reel/Frame 053217/0436 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 30, 2020
From: NANDYALAM, RAJESH; BOURNE, GEOFFREY DAVID; MALEK, JOSEPH
To: VCE COMPANY, LLC
Reel/Frame 053091/0251 →
SECURITY AGREEMENT Recorded Apr 22, 2020
From: CREDANT TECHNOLOGIES INC.; DELL INTERNATIONAL L.L.C.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL USA L.P.; EMC CORPORATION; FORCE10 NETWORKS, INC.; WYSE TECHNOLOGY L.L.C.; EMC IP HOLDING COMPANY LLC
To: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A.
Reel/Frame 053546/0001 →
MERGER Recorded Mar 26, 2020
From: VCE IP HOLDING COMPANY LLC
To: EMC IP HOLDING COMPANY LLC
Reel/Frame 052236/0497 →
SECURITY AGREEMENT Recorded Mar 21, 2019
From: CREDANT TECHNOLOGIES, INC.; DELL INTERNATIONAL L.L.C.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL USA L.P.; EMC CORPORATION; FORCE10 NETWORKS, INC.; WYSE TECHNOLOGY L.L.C.; EMC IP HOLDING COMPANY LLC
To: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A.
Reel/Frame 049452/0223 →
PATENT SECURITY AGREEMENT (CREDIT) Recorded Oct 12, 2018
From: DELL PRODUCTS L.P.; EMC CORPORATION; EMC IP HOLDING COMPANY LLC
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
Reel/Frame 047648/0346 →
PATENT SECURITY AGREEMENT (NOTES) Recorded Oct 12, 2018
From: DELL PRODUCTS L.P.; EMC CORPORATION; EMC IP HOLDING COMPANY LLC
To: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS COLLATERAL AGENT
Reel/Frame 047648/0422 →