Using Sample Graph Data

The rpm installation of the graph server provides you with sample graph data which can be used for graph analysis.

1. Navigate to /opt/oracle/graph/data or <client_dir>/data directory.

   The bank_graph folder contains the following .sql files for setting up the sample graph data:- bank_graph.sql, bank_accounts.sql, and bank_transfers.sql.

2. Ensure that you have the required privileges to create a SQL property graph.

   See Granting System and Object Privileges for SQL Property Graphs for more information.

3. Run bank_graph.sql in the required schema.

   @/opt/oracle/graph/data/bank_graph/bank_graph.sql

   The script performs the following:

   • Creates the BANK_ACCOUNTS table, sets the primary key constraint, and populates the table with the graph vertex data.

   • Creates the BANK_TRANSFERS table, sets the primary and foreign key constraints, and populates the table with the graph edge data.

   • Creates a SQL property graph named bank_graph.