Best practices for combining VGs and Materialization

Support
1

Dear all,

I have the following scenario.

  1. Data source 1: Oracle.
  2. Data source 2: MS SQL Server
  3. Data source 3: CSV
  4. Data source 4: Oracle

I'm working in semantically harmonizing and integrating these data sources and I need to make this in a scalable way. I have the requirement to materialize as much as possible the results. I use the VGs to ensure that competency questions are being answered on top of each data source separately and also combined.

What would be the best practice to follow here?

  • Creating a VG for each data source and then materialize then in the Default Graph using a central query that reads data from the VGs?
  • Creating a VG for each data source and then materialize then in specific Named Graphs using one query for each VG?

Would love to hear your opinions, guidelines, suggestion here since I need to ensure that we have a robust pipeline.

Best,
Irlan

1 Like