Getting Started with AnzoGraph

This brief tutorial introduces you to the AnzoGraph Query Console and gets you started with loading data and running SPARQL queries.

1. Log in to the Query Console
2. Load and Query Sample Data
3. Load and Query Your Own Data

Log in to the Query Console

Note	The AnzoGraph console supports the latest Safari, Google Chrome, and Mozilla Firefox browsers. Microsoft Edge and Internet Explorer are not supported at this time.

1. Depending on whether you deployed AnzoGraph using the Docker, Kubernetes with Helm, or 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.

     Note

     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.

   Note: 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.

   

2. On the log in screen, type admin as the user name and Passw0rd1 as the password, and then click Sign In. The browser displays the AnzoGraph End User License Agreement (EULA). See AnzoGraph Administration

   

3. Review the agreement, and then click Accept to agree to the EULA terms and proceed to the AnzoGraph Query Console.

   

   Note	When you log in with "admin" credentials, the user interface also displays an Admin tab. For information on the Admin Console, see Using the Admin Console.

   The left navigation pane of the Query Console shows 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. Click a query in the navigation pane to open the query in the main window. You can edit or overwrite the default queries, or you can click Add Query to create a new query from scratch. To run a query, click the Run button () at the top of the screen. The results display at the bottom of the screen.

Load and Query Sample Data

1. On the Query console, replace the default query with the following statement. This statement loads the sample Tickit data from the tickit.ttl.gz directory on the csi-sdl-data-tickit S3 bucket.

   LOAD WITH 'global' <s3://csi-notebook-datasets/MovieTicketAnalysis/20190217/tickit.ttl.gz> INTO GRAPH <tickit>

   This simple data set captures sales activity for a fictional Tickit website where people buy and sell tickets for sporting events, shows, and concerts.

2. Click the Run button () to run the query and load the data. When the load completes, the console displays an Update Successful message.
3. On the console, replace the load statement with the following simple query that counts the number of triples in the Tickit data set:

   SELECT (count(*) as ?number_of_triples)
   FROM <tickit>
   WHERE { ?s ?p ?o }

   For example:

   

If you want to continue to work with the Tickit data set and run more complex queries or view explanations of the query syntax, see Working with the Tickit Data.

Load and Query Your Own Data

This section provides guidance on quickly loading and analyzing some of your own data. AnzoGraph supports loading data from Turtle (.ttl), N-Triple (.n3 or .nt), N-Quad (.nq), TriG (.trig), and CSV files. You can load files that are hosted on Amazon S3 or other storage, the local or a mounted file system, or a web server.

Below are sample SPARQL LOAD statements. Follow these steps to load a file:

1. Copy the appropriate statement below, depending on the location of your load file. Paste the query into the AnzoGraph Query Console. 

   Load a TTL, N3, NQ, or TriG file in S3 storage:

   LOAD with 'global' <s3://bucket_name/path_to_file/file_name> INTO GRAPH <mydata>

   Load a TTL, N3, NQ, or TriG file on the local or mounted file system:

   LOAD <file:/path_to_file/file_name> INTO GRAPH <mydata>

   To load a CSV file, see Loading Tabular Files for instructions.

2. Edit the query in the console to supply the bucket_name and/or path_to_file and file_name for your load file. You can also change the graph name or remove the INTO GRAPH statement if you want to load a file that includes graph specifications.
3. Click the Run button () to run the query and load the data. When the load is complete, you can query your data using the Query Console.

For more detailed information about loading data and to review load file requirements and recommendations, see Loading and Unloading Data.

This brief tutorial introduces you to the AnzoGraph command line interface (CLI) and gets you started with loading data and running SPARQL queries.

1. Running the CLI
2. Load and Query a Sample Data Set
3. Load and Query Your Own Data

Running the CLI

The AnzoGraph command line client, azgi, uses SPARQL HTTP protocol to interact with the database. The client exists in the azg/bin directory. How do I access the AnzoGraph file system with Docker?

Running the following command displays the options that azgi supports:

./azg/bin/azgi -help 

To get started, the following list describes the most frequently used azgi options:

• azgi -c "command": Runs the command in the quotation marks. For example, the following command runs a SELECT query that returns the ?s ?p ?o triple patterns for a graph named graph:

  ./azg/bin/azgi -c "select * from <graph> where {?s ?p ?o}"

• azgi -f file.rq: Runs the query or queries in a file. For example, if a file called query.rq existed in the /tmp directory, the following command would run the query or queries in query.rq:

  ./azg/bin/azgi -f /tmp/query.rq

This tutorial guides you through using the azgi -c option to load data. For more information about the command line interface, see Using the AnzoGraph Command Line Interface.

Load and Query a Sample Data Set

The AnzoGraph installation includes two sample data sets on the file system:

• Tickit: This data set includes about 5.5 million triples and captures sales activity for the fictional Tickit website where people buy and sell tickets for sporting events, shows, and concerts. The data consists of person, venue, category, date, event, listing, and sales information.
• TPCH: This data set includes about 111 million triples and is similar to the SQL TPC-H Decision Support data, which Cambridge Semantics converted to the RDF graph model. The data set and queries model a use case where a vendors purchase parts from suppliers and sell them to customers.

The instructions below guide you through using the CLI to load the Tickit data set and run some sample queries.

1. Run the following command to load the Tickit Turtle files that are hosted on Amazon S3 into a graph named tickit:

   ./azg/bin/azgi -c "load <s3://csi-notebook-datasets/MovieTicketAnalysis/20190217/tickit.ttl.gz>
   into graph <tickit>"

   AnzoGraph loads the data from the files into memory, and the prompt returns when the load completes.

2. Run the following command to count the number of triples in the tickit graph:

   ./azg/bin/azgi -c "select (count(*) as ?number) from <tickit> where {?s ?p ?o}"

   number
   ---------
   5525739
   1 rows

If you want to continue to work with the Tickit data set and run more complex queries or view explanations of the query syntax, see Working with the Tickit Data.

Load and Query Your Own Data

AnzoGraph supports loading data from Turtle (.ttl), N-Triple (.n3 or .nt), N-Quad (.nq), TriG (.trig), and CSV files. You can load files that are hosted in the cloud, such as Amazon S3 or Google Cloud Platform, the local or a mounted file system on the AnzoGraph server, or a web server.

This section provides guidance on quickly loading and analyzing some of your own data by copying a file to the local file system and using the AnzoGraph CLI to load it. Follow these steps to load a file.

1. Copy a load file to the file system on the AnzoGraph host server.
2. Run the following command to load the file's contents:

   ./azg/bin/azgi -c "load <file:/path_to_file/filename> into graph <graph_name>"

   Note: Loading a tabular file, like a CSV file, requires alternate load statement syntax. For information about loading a CSV file, see Loading Tabular Files.

   AnzoGraph loads the data from the file into memory, and the prompt returns when the load completes.

3. Run the following command to count the number of triples in the new graph. Replace graph_name with the graph name that you typed in the previous step.

   ./azg/bin/azgi -c "select (count(*) as ?number) from <graph_name> where {?s ?p ?o}"

4. If you want to run an additional query to explore the data, such as to list the predicates in the data set, run the following command. Replace graph_name with the graph name that you typed in the previous step.

   ./azg/bin/azgi -c "select distinct ?p from <graph_name> where {?s ?p ?o} limit 100"

For more detailed information about loading data and to review load file requirements and recommendations, see Loading and Unloading Data.