CODEWITHSUNDEEP
oracle-databaseproperty-graph
Mohammad Esmaili
Mohammad Esmaili

Reputation: 11

Auto-update Property Graph (view or table) from original table

In the property graph is it possible to refresh the created graph table or view it by PGQL automatically from a relational table or RDBMS when the original tables change? the original table which the graph was created from. When we add a new record in the original edge table, Changes in the property graph table may consist of vertices, if vertices are new or only add a new edge between two existing nodes along with properties.

I did my search in Oracle documents but my question still remains. I am expecting a solution on how to auto-refresh the graph table or view.

Upvotes: 0

Views: 49

Answers (1)

kpatenge
kpatenge

Reputation: 146

You can run PGQL queries against the Oracle DB (2-tier architecture). This is the easiest way to ensure transactional consistency.

In case you already use an Oracle DB 23c you also have the option to directly create, maintain, and query property graphs using SQL.

Feel free to reach out to me for help.

Upvotes: 0

Related Questions