Query View

Used to query the space using SQL statements and view the resulting data set in tabular format.

The Query view allows you to query the space using SQL statements and to get the full resulting data set in tabular format.

The Query view includes the following options:

• Result set table – the query results are displayed in a table at the lower part of the Service View, where each row represents Entry data, and each column represents class attribute data. Non-native types' attribute data is displayed using the toString returned value.

• Exporting result set data into HTML, XML or CSV – to export the restored result set data, click the export button (). This displays the export dialog, which requires you to follow 2 simple steps, and then save the file to disk.

• Entry UID is displayed for each object data – when the SQL query includes the UID as part of the select statement (select uid,\* from person), the first column in the result set table displays the Entry UID.

• Space Where GigaSpaces data is stored. It is the logical cache that holds data objects in memory and might also hold them in layered in tiering. Data is hosted from multiple SoRs, consolidated as a unified data model. classes list query – to query the space for the classes it stores run the following query:

  SELECT * FROM SYSTABLES

• Class meta data information – to get the class meta data information, click the meta data button (). This displays a table in which each row includes information about the table column's meta data. This displays a translation of the relevant class attribute type into its SQL equivalent:

  

  Scroll right to see more attributes:

  

  

• SQL queries can be saved to a file. Right-click the top of the Service View panel and click Save to file:

  

• Inspecting objects using the Object Inspector or the Object Snapshot Inspector.