Proposed Solution

How can we solve this problems to avoid future data irregularities and errors?

Since the data in both production and staging are not reproducible because of google places API and lack of APOC plugin compatible with those version of the DB, We can create a SandBox db and export useful data gradually or in batches for proper cleaning and restructuring. Test against backend codebase for code breaking in data querying.

• Data irregularities in both DB : We focus on only the production DB

• No documentation on data processing for reproducibility

• Incompatibility of APOC plugin on the DBs version for total data export

Issues	Solutions	Remarks
Data irregularities in both DB	Focus only on production DB	Less data but useful
No Data Processing Documentation	Give brief description on each batch data processing	Increases reproducibilities chances
Incompatibility of APOC plugin on the DBs version for total data export	The new DB must be APOC compatible	Good for total data export in the case of DB migration in future.