Using the Query & Admin Console

This topic provides information about using the AnzoGraph frontend user interface, referred to here as the Query & Admin Console.

For instructions on using the Query & Admin Console to upgrade a license, see Upgrading an AnzoGraph License.

• Logging in to the Console
• A Brief Tour of the Console User Interface

Logging in to the Console

1. Depending on whether you deployed AnzoGraph using the Docker CE, Kubernetes with Helm, or the AWS CloudFormation options, follow the appropriate instructions below to access the user interface:
   • Docker Desktop for Mac or Windows: You can use the Docker Dashboard to open the AnzoGraph container in a browser, or open a browser and go to the following URL:

     http://127.0.0.1

     If you specified a port other than 80 for the host HTTP port when you deployed AnzoGraph, include that port in the URL. For example, http://127.0.0.1:8888.

   • Docker on Linux: If you are accessing Docker on a remote Linux host, note the IP address of the host, and then open a browser and go to the following URL:

     https://host_IP_address

     If you mapped the container's HTTPS (8443) port to port 443 on the host when you deployed AnzoGraph, you do not need to specify a port. If you specified a port other than 443, include the port in the URL. For example, https://10.100.0.1:8888.

     If you are using Docker locally on a Linux machine and need to know the IP address of the AnzoGraph container, you can run the following command:

     sudo docker inspect container_name | grep '"IPAddress"' | head -n 1

     For example:

     sudo docker inspect anzograph | grep '"IPAddress"' | head -n 1

     "IPAddress": "172.17.0.2"

   • Kubernetes with Helm deployments: Using the AnzoGraph Cluster IP or External IP from the kubectl get service command, open a browser and go to the following URL:

     https://IP_address

   • AWS CloudFormation deployments: In the Outputs section of the Stack Detail screen, click an AnzoGraph endpoint URL (AnzoGraphURL) to open the AnzoGraph Console.

   If you use the HTTPS endpoint, your browser may warn you that the connection is not private. The warning is normal behavior. AnzoGraph servers use self-signed certificates, and browsers automatically trust only the certificates from well-known certificate authorities. For more information about certificate warnings, see Security Certificate Errors on the DigiCert website. Depending on your browser, follow the appropriate instructions below to either bypass the warning and continue to the console or configure the browser to trust the certificate:

   • On Chrome, click the Advanced link at the bottom of the page and then click the Proceed to ip (unsafe) link.
   • On Safari, click the Show Details button and then click Visit Website to import the certificate.
   • On Firefox, click Advanced and then click Add Exception. On the next screen, click Add Security Exception to confirm the exception for the AnzoGraph endpoint.

   The browser displays the AnzoGraph log in screen.

   

On the log in screen, type admin as the user name and Passw0rd1 as the password, and then click Sign In. After successful authentication, the main Query & Admin Console web page opens, allowing you to execute AnzoGraph SPARQL queries as well as perform other AnzoGraph administration, data access, and analysis operations.

A Brief Tour of the Console User Interface

The Query & Admin Console application top menu bar provides two tab selections, Query Console and Admin. On the right side of the screen, the top menu provides the DB Status option, the Server Context drop-down menu, and the user drop-down menu:

• DB Status shows the status of the database. A check mark icon indicates that the database is running, and an X icon indicates the database is stopped. Click DB Status to access the options to start, stop, or restart the database:

  

• The Server Context menu enables you to manage the connections to multiple AnzoGraph instances. For information about setting up a server context, see Deploying the AnzoGraph Frontend Console Container.

  

• The user menu include options to log out of the console, view the product license, and access the Documentation Center (Help). The Settings option takes you to the Server Context manager, and the About option displays information about the current AnzoGraph database and front end (Query Console & Admin Console) versions running in your environment. The Product License option displays information about the current AnzoGraph license and allotted resources. In addition, this option provides links to request new or enhanced licenses and upload new license keys. See Upgrading an AnzoGraph License for more information about licensing options and requesting a new license.

  

The Query Console Page

When you open the Query Console tab, the left sidebar navigation pane, labeled Query List, displays a number of predefined menu options and groups.

The Console provides two default queries, Count Statements and Total Statements. The Count Statements query returns a list of each named graph and the number of statements or triples in the graph. The Total Statements query returns the total number of statements in all named graphs.

Clicking the Add Query button lets you enter and run new queries and other SPARQL statements. The Add Group button lets to define new menu option groups to organize queries, and the More button lets you import from and export queries to your local file system environment. Clicking on the three-stacked dot icon () next to an existing query lets you rename, export, or delete the query.

In the right side window, the Console provides an editing and display window along with various button, checkboxes, and windows, pertaining to your current sidebar menu or query selection. For example, if you've already loaded the sample tickit graph into AnzoGraph, selecting the Count Statements option would display the following:

At the top of the right-side window, the Console displays the Server Context drop-down menu, the Auto Clear Results checkbox and Run, Settings, and Copy buttons, which let you run the displayed query or perform other actions. If you choose the Add Query option, the Console clears the right-side query window, allowing you to enter a new query or SPARQL query.

Below the SPARQL query window, the Console displays the results from running a query, along with options to control the results format, limits to page size, and so on. You can toggle between Table and Response options, to show the query result in either a tabular format, or when you click Response, view the query result in the specified format, by default, JSON.

The Admin Page

When you open the Admin tab page, the left sidebar navigation panel displays a variety of different menu options pertaining to the many common operations that an AnzoGraph administrator or analyst might perform. This section provides a basic description of each option of the Admin tab sidebar panel as well as references to additional information that might be available to perform specific tasks.

General

The General tab selection displays the database and console version information, database start time, and license status. It also provides details such as the number of cores utilized on the AnzoGraph server or cluster, memory usage, and total memory resources available to AnzoGraph.

Clicking the Upgrade License button takes you to the AnzoGraph License Offerings web site, allowing you to view various product download and licensing options. For instructions on upgrading the license, see Upgrading an AnzoGraph License.

Graphs

The Graphs menu option displays a list of the graphs in memory as well as a count of the number of triples that each graph contains. For example:

If you want to delete a graph from the database, click the trash can icon () in the row for the graph that you want to drop. The console displays a dialog box to confirm that you want to delete the graph. Click OK to remove the graph.

Views

The Views menu option displays a list of the views that have currently been defined in AnzoGraph. For example:

For each view, the display shows the view name, the type (materialized or non-materialized), and the query on which the view was defined. If you want to delete a view from the database, click the trash can icon () in the row for the view that you want to delete. The console displays a dialog box to confirm that you want to delete the view. Click OK to remove the view.

Queries

The Admin Queries menu option provides access to the query history log, which shows a list of the queries that have been run against AnzoGraph. To view the list, select the Queries menu option. The following display hows the query history and provides the option to cancel all running queries. For example:

For each query, the screen shows the query ID, label, and status, as well as the start time and duration in milliseconds. The last column shows the query text. You can click the new window icon () next to a query to copy that query into the Query editing window where you can edit and/or re-run the query.

OData (Preview)

AnzoGraph provides a "Data on Demand" service that allows users to define RESTful API endpoints using Open Data Protocol (OData)-based data feeds, which allow web-based access to AnzoGraph graph data. The RESTful API endpoints allow web clients to use simple HTTP messages to publish and edit resources that are identified using URLs and are defined in a data model.

The Admin OData (Preview) menu option lets you view existing Data on Demand endpoints as well as create new endpoints. The following screen shows an example of a Data on Demand endpoint that provides access to a Tickit graph.

For more information and instructions on creating Data on Demand endpoints from the Console, see Accessing Data Using OData Protocol (Preview).

Query Contexts

The Admin Query Contexts menu option lets you manage query contexts, which define sensitive data source connection details like keys, tokens, and user credentials. Queries that are run against a source can simply reference the keys in a context to avoid including sensitive information in the request. The following screen shows the display of currently defined query contexts and the options to add new context configurations as well as edit or delete contexts.

For more information and instructions on creating Query Contexts, see Using Query Contexts.

Diagnostics

The Admin Diagnostics menu option displays and lets you download any existing Xray snapshot diagnostic files that AnzoGraph has generated in response to an error or database crash. When Cambridge Semantics Support requests AnzoGraph diagnostic files for troubleshooting an issue, you can quickly retrieve the files here.

There are two types of AnzoGraph diagnostic files:

• Xray: Xrays are generated on-demand. If you encounter an error and the database remains running, you generate an Xray to produce the diagnostic files.
• Crash: If you encounter an error that crashes the database, AnzoGraph automatically generates a crash file that contains diagnostic information about the crash.

To retrieve an Xray file:

1. Select the Diagnostics menu option from the Admin sidebar panel. The console displays the available options. For example:

   

2. If you want to retrieve an xray, click the Download Xray snapshot link. AnzoGraph creates the xray and produces a tarball with a .xray extension. The console downloads the .xray file to your computer.
3. If you want to retrieve a crash dump, click the Refresh button to refresh the list of available crash dump .xray files. Click the file name that you want to download. The console downloads the .xray file to your computer.

   Xray and crash dump files that you download are already compressed. Do not compress the files before sending them to Cambridge Semantics when they are requested for troubleshooting an issue.

Extension Library

The Admin Extensions menu option provides a display of extension libraries and individual extensions currently installed in AnzoGraph. From the list of libraries, you can expand or collapse library items to show all the extensions defined within those libraries. For example:

For the library and extension display, you can click the Info icon next to an item to obtain additional information about that library or extension.

Related Topics

• Loading Data from Files
• Sample Data, Tutorials, and Benchmarks