2.3.6 Create Graph Schema

This section describes how to create Graph Schema.

Note:

• This section is applicable only for Graph use case.
• The graph schema should be created based on which graph would be used:
  • For the BD graph, you should create a BD schema in the same database where the BD Atomic schema is present.
  • For the ECM graph, you should create an ECM schema in the same database where the ECM Atomic schema is present.
  • If both graphs are intended to be used, then the Graph, ECM and BD Atomic schemas should be on the same database.

Graph schema is a database schema where business data from either BD/ECM are extracted, transformed, and loaded (ETL) after the graph pipeline execution. The Compliance Studio installer requires the graph schema during the installation process; hence user should create the graph schema before the installation process.

If you are generating graph from business data of the BD application, then it is called as BD graph and similarly; if you are generating graph from business data of the ECM application, then it is called as ECM graph.

To create a graph schema, create a new Oracle Database schema user using the following script:

CREATE USER <GRAPH SCHEMA USER> IDENTIFIED BY <PASSWORD> DEFAULT TABLESPACE <GRAPH_SCHEMA_TS>;
ALTER USER <GRAPH SCHEMA USER> QUOTA 2000M ON <GRAPH_SCHEMA_TS>;
For example:
ALTER USER GRAPH_SCHEMA_USER QUOTA 500M ON GRAPH_SCHEMA_TS;

Note:

The tablespace and quota sizes should be defined based on the size of the data.

A new Oracle Database schema (Graph schema) is created.