Storage system query mechanism and techniques

• US 10,296,618 B1
• Filed: 05/20/2014
• Issued: 05/21/2019
• Est. Priority Date: 05/20/2013
• Status: Active Grant

• Current Assignee: Emc IP Holding Company LLC (Dell Technologies Inc.)
• Original Assignee: Emc IP Holding Company LLC (Dell Technologies Inc.)
• Inventors: Liubovich, Ilya, Michel, Ruben, Suryanarayan, Satish, Zeliger, Ohad
• Primary Examiner(s): Corrielus, Jean M
• Application Number:
  US14/282,599
• Time in Patent Office: 1,827 Days
• Field of Search: 707769, 707602, 707722
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

A storage system query mechanism and corresponding techniques for implementing queries are provided. Queries can be created on a client and server, where the client and the server are based on different programming languages, by providing a server-side meta-model and client-side meta-model. A base meta-model is provided having a plurality of base classes and a domain-specific injection point to allow domain specific meta-models to be injected into the base meta-model. Domain-specific query executors can be employed to process a query. Techniques are also provided for caching control path data in a storage array using one or more façade data classes and a refresh service to listen to refresh events that impact a validity of the cached data objects. Applications can optionally register domain specific query executors, object model providers and/or class loaders. Query results can be presented on a client device by providing a declarative data grid component as part of a graphical user interface.

Claims

1. A method for presenting query results on a client device, comprising:

providing, using at least one processing device, a data grid component as part of a graphical user interface to display data on said client device, wherein population of a data table is specified declaratively by a query service query, wherein said query service query is developed such that when a given object type is specified, a list of at least one or more of authorized attributes and authorized methods is presented to a programmer during query development and wherein a validity of one or more object types of said query service query is evaluated at a compile time of said query service query;

executing, using said at least one processing device, said validated query service query based on one or more predefined user interactions with said graphical user interface; and

populating, using said at least one processing device, said data table with results of said executed query service query.

2. The method of claim 1, wherein said one or more predefined user interactions comprise one or more of a user scrolling, a user selecting a column in said data table, a user invoking an action through a contextual menu, and a user invoking an action through one or more contextual dashboard buttons.

3. The method of claim 1, wherein said query service query returns only a predefined number of rows for said data table.

4. The method of claim 3, further comprising the step of requesting a new range of rows in said query result from a server to obtain one or more additional rows of data if said user selects a row outside a boundary identified by said predefined number of rows.

5. The method of claim 1, wherein said results of said query service query are converted to data transfer objects for presentation on said client device.

6. The method of claim 5, wherein said client device and a server device are based on different programming languages and wherein said query results are translated into a language of said client device using said data transfer objects.

7. The method of claim 1, further comprising the step of executing an additional query service query to obtain one or more additional columns of data for one or more rows if said user performs one or more contextual operations for at least one row of data.

8. The method of claim 1, wherein one or more of scrolling and sorting said results of said query service query are performed by a server device.

9. The method of claim 1, wherein a width of one or more columns in said data table are determined based on a content of said one or more columns by said client.

10. The method of claim 9, wherein said column width determination is based on one or more predefined style guides.

11. The method of claim 1, further comprising the step of updating said data table when a view is one or more of created and refreshed.

12. The method of claim 1, further comprising the step of synthesizing an additional query service query to sort said data table by a given column of data if a user selects said given column, wherein said additional query service query comprises as a first sort criterion sorting dictated by said given column based on said initial query service query.

13. The method of claim 1, further comprising the step of executing an additional query service query to interactively identify one or more devices within a storage array satisfying one or more predefined criteria when a user updates a predicate statement for said one or more devices.

14. The method of claim 1, wherein said data grid component provides a plurality of comparator types for sorting columns in said data table.

15. The method of claim 1, wherein said data grid component supports a presenter populated data grid mode wherein a presenter in a Model-View-Presenter (MVP) architecture procedurally populates said data table.

16. The method of claim 1, wherein said data grid component executing said query service query based on a total cost of roundtrips between said client device and a server device and network traffic.

43. The method of claim 1, wherein said query service query is gradually populated with query data until said query service query is executed, wherein one or more components of said query data are selected from only valid options for said one or more components.

17. A computer program product for presenting query results on a client device, comprising a tangible machine-readable storage medium having encoded therein executable code of one or more software programs, wherein the one or more software programs when executed by at least one processing device perform the following steps:

providing, using at least one processing device, a data grid component as part of a graphical user interface to display data on said client device, wherein population of a data table is specified declaratively by a query service query, wherein said query service query is developed such that when a given object type is specified, a list of at least one or more of authorized attributes and authorized methods is presented to a programmer during query development and wherein a validity of one or more object types of said query service query is evaluated at a compile time of said query service query;

executing, using said at least one processing device, said validated query service query based on one or more predefined user interactions with said graphical user interface; and

populating, using said at least one processing device, said data table with results of said executed query service query.

18. The computer program product of claim 17, wherein said one or more predefined user interactions comprise one or more of a user scrolling, a user selecting a column in said data table a user invoking an action through a contextual menu, and a user invoking an action through one or more contextual dashboard buttons.

19. The computer program product of claim 17, wherein said query service query returns only a predefined number of rows for said data table and further comprising the step of requesting a new range of rows in said query result from a server to obtain one or more additional rows of data if said user selects a row outside a boundary identified by said predefined number of rows.

20. The computer program product of claim 17, wherein said results of said query service query are converted to data transfer objects for presentation on said client device and wherein said client device and a server device are based on different programming languages and wherein said query results are translated into a language of said client device using said data transfer objects.

21. The computer program product of claim 17, further comprising the step of executing an additional query service query to obtain one or more additional columns of data for one or more rows if said user performs one or more contextual operations for at least one row of data.

22. The computer program product of claim 17, wherein one or more of scrolling and sorting said results of said query service query are performed by a server device.

23. The computer program product of claim 17, wherein a width of one or more columns in said data table are determined based on a content of said one or more columns by said client and wherein said column width determination is based on one or more predefined style guides.

24. The computer program product of claim 17, further comprising the step of updating said data table when a view is one or more of created and refreshed.

25. The computer program product of claim 17, further comprising the step of synthesizing an additional query service query to sort said data table by a given column of data if a user selects said given column, wherein said additional query service query comprises as a first sort criterion sorting dictated by said given column based on said initial query service query.

26. The computer program product of claim 17, further comprising the step of executing an additional query service query to interactively identify one or more devices within a storage array satisfying one or more predefined criteria when a user updates a predicate statement for said one or more devices.

27. The computer program product of claim 17, wherein said data grid component provides a plurality of comparator types for sorting columns in said data table.

28. The computer program product of claim 17, wherein said data grid component supports a presenter populated data grid mode wherein a presenter in a Model-View-Presenter (MVP) architecture procedurally populates said data table.

29. The computer program product of claim 17, wherein said data grid component executing said query service query based on a total cost of roundtrips between said client device and a server device and network traffic.

30. A system for presenting query results on a client device, comprising:

a memory; and

at least one processing device, coupled to the memory, operative to implement the following steps;

providing, using said at least one processing device, a data grid component as part of a graphical user interface to display data on said client device, wherein population of a data table is specified declaratively by a query service query, wherein said query service query is developed such that when a given object type is specified, a list of at least one or more of authorized attributes and authorized methods is presented to a programmer during query development and wherein a validity of one or more object types of said query service query is evaluated at a compile time of said query service query;

executing, using said at least one processing device, said validated query service query based on one or more predefined user interactions with said graphical user interface; and

populating, using said at least one processing device, said data table with results of said executed query service query.

31. The system of claim 30, wherein said one or more predefined user interactions comprise one or more of a user scrolling, a user selecting a column in said data table a user invoking an action through a contextual menu, and a user invoking an action through one or more contextual dashboard buttons.

32. The system of claim 30, wherein said query service query returns only a predefined number of rows for said data table and further comprising the step of requesting a new range of rows in said query result from a server to obtain one or more additional rows of data if said user selects a row outside a boundary identified by said predefined number of rows.

33. The system of claim 30, wherein said results of said query service query are converted to data transfer objects for presentation on said client device and wherein said client device and a server device are based on different programming languages and wherein said query results are translated into a language of said client device using said data transfer objects.

34. The system of claim 30, further comprising the step of executing an additional query service query to obtain one or more additional columns of data for one or more rows if said user performs one or more contextual operations for at least one row of data.

35. The system of claim 30, wherein one or more of scrolling and sorting said results of said query service query are performed by a server device.

36. The system of claim 30, wherein a width of one or more columns in said data table are determined based on a content of said one or more columns by said client and wherein said column width determination is based on one or more predefined style guides.

37. The system of claim 30, further comprising the step of updating said data table when a view is one or more of created and refreshed.

38. The system of claim 30, further comprising the step of synthesizing an additional query service query to sort said data table by a given column of data if a user selects said given column, wherein said additional query service query comprises as a first sort criterion sorting dictated by said given column based on said initial query service query.

39. The system of claim 30, further comprising the step of executing an additional query service query to interactively identify one or more devices within a storage array satisfying one or more predefined criteria when a user updates a predicate statement for said one or more devices.

40. The system of claim 30, wherein said data grid component provides a plurality of comparator types for sorting columns in said data table.

41. The system of claim 30, wherein said data grid component supports a presenter populated data grid mode wherein a presenter in a Model-View-Presenter (MVP) architecture procedurally populates said data table.

42. The system of claim 30, wherein said data grid component executing said query service query based on a total cost of roundtrips between said client device and a server device and network traffic.

44. The system of claim 30, wherein said query service query is gradually populated with query data until said query service query is executed, wherein one or more components of said query data are selected from only valid options for said one or more components.