Oracle GoldenGate @ Fluvius.pdf

1、Fluvius:GoldenGateGoldenGateFluvius Fluvius is a Belgian grid operator that covers the Flanders Region.We build and manage the public utility lines in the street that brings electricity,natural gas,sewerage and heat to our customers.We build and manage the public utility lines in the street that bri

2、ng electricity,natural gas,sewerage and heat to our customers.Since 2017 we run our databases on Oracle Engineered Systems(X7 X8M X10M ZFS ZDRLA)Some Examples:-Geo-database-Energy Capacity pricing-Smart Meters Smart Meters Gradual rollout-ELEC:4 million meters -15 meters reads-GAS:2,5 million meters

3、 Data retention=10 years datacompression(HCC)after 3 years Estimated database size end 2037 approx 390 TB!(with compression active)Number inserted row per second:21.105 in 2028 (24*7)Move Oracle&MS-SQL data to DataLake Continuously data movement from Oracle DB(Geo/Energy Capacity/Digital meters/.)&M

4、S-SQL DB to our DataLake(currently in Parquet format)Solution needs to be:-Independent of the database structure-Impactless on production DB queries-Without additonal sw installation on DB servers-Able to ingest data in different DataLakes-Able to filter sensitive data depending on targets-Able to perform data enrichments(lookup tables)