Creatively parse JSON data to store it in a SQL database
$600
top 6
20
submissions
20
solutions max
Small pic json

You have a file containing JSON data on a computer and wish to load it into a SQL database. Assume the JSON data is an array of strings (e.g. ['test', 'foo', … ]) and that the database already has a table with the fields 'id' and 'text'. The goal is to load each string from the array into the database as 'text' with the array index as 'id'.

Deliverables

Design a system for parsing a small amount of JSON data into RAM, and then storing it in the database (pseudo code is fine, assume there's an 'insert(id, text)' function you can use to get the data into the database).

Facebook needs to use its hardware as efficiently as possible. The amount of data we want to parse might be much larger than the size of the system's available RAM (though the database can still store everything). How could you re-design your parser to still accomplish the task?

When you profile your code you find that the 'insert(id, text)' function is now your performance bottleneck. Why could that be? How could you re-write it to fix the issue? (SQL pseudocode is fine)

    Submissions will be graded on the following criteria:
  • Meets Deliverables
  • Creativity
  • Clarity
Leaderboard
Top 3 share $450 Next 3 share $150
$150.00 X University of Florida
$150.00 Square pic 60 profile Illinois Institute of Technology
$150.00 Square pic 60 01ffdde The Ohio State University
$50.00 Square pic 60 0c46ee9 Stanford University
$50.00 C Boston University
$50.00 J Massachusetts Institute of Technology
Submission questions
Drag and drop photos or image files into your solution 0 characters Average: 1729 characters
    Your solution must be at least 0 characters long