Question
Ephraim Malane · Jul 15

Data Quality Manager rebuild Cubes

Hi guys,

Does rebuilding of Data Quality Manager cubes affect patient index linkage definition data?

What I want to understand is, does DQM have any negative impact on the data each time you rebuild the cubes. 

Additionally, if I make changes to the cube and rebuild it..will this have any impact on the original data?

Product version: IRIS 2020.2
$ZV: HealthShare 2020.2 [HealthShare Modules: Active Analytics:20.0.8620 + Core:20.0.8620 + Patient Index:20.0.8620] - IRIS for UNIX (Red Hat Enterprise Linux for x86-64) 2020.1 (Build 217_1_20418U) Tue Nov 17 2020 15:48:44 EST
0
0 170
Discussion (6)1
Log in or sign up to continue

Absolutely not.

During SYNC or REBUILD events Data Quality Manager cubes would only read patient index linkage definition data.

There's no way for cubes to modify patient index linkage definition data.

That said, reads, cube data writes, and additional cpu load during SYNC or REBUILD events might impact the running system, since there's a limited amount of resources available. You might want to schedule SYNCs and especially REBUILDs for low-load times (at nights or weekends depending on your usage patterns).

Using async reporting mirror for cubes would completely remove the impact on the patient index.

Thanks Eduard,

From your response, even if I extend a cube with additional property and rebuild it won't affect the linkage definition data right?

Yes. Cube builds don't modify source data.

Cubes copy all source data into an entirely separate set of tables.

Hi Eduard,

I have enabled Data Quality Manager in our production environment and I am picking up a massive increase in memory utilization and CPU utilization. Database size keeps increasing,is it normal?

 
Logs

Yes? Cubes need space to store thier copy of the facts and CPU is needed to build it all.

As I said above, using async reporting mirror for cubes would completely remove the impact on the patient index.

Thanks Eduard,

I will look into implementing an async reporting mirror for cubes.

Regards,