Compare Proposal

Nothing to compare.

General Purpose Denormalized Database Normalization Tool

  • Posted at : 3 months ago
  • Post Similar Project
10

Budget
2
Proposals
24
Views
Awarded
Status
Skills Required

Posted By -

KL

4.8
Projects Posted : 53
Projects Paid : 13
Services Purchased : 2
Total Spent :
234
Feedbacks : 87 %

Project Details show (+) hide (-)

https://www.kaggle.com/openfoodfacts/world-food-facts has a retarded sparse matrix structure with the nutrients as columns.

I need this normalized properly.  The columns should probably be something like ProductID, NutrientID, value, units.

It would be ideal to have a general purpose scrpt, preferably PHP, but maybe SQL, to do this.  If PHP it has to make the database connection, and take the table name, as around 5 configuration variables, along with a way to assign the column names, values, units to database fields in the new table.  I can do a lot of this in PHPMyAdmin, I don't need a lot of magic.

In both cases, the column list can pretty easily be gleaned from Information_Schema.

Your Job Feed