search

fasterthanlime / cs322

CS-323 project
2 stars 1 forks source link

Import the data from the given CSV files into the created database. #4

Closed greut closed 12 years ago

greut commented 12 years ago

I think what's best is to go with bulk loader (LOAD DATA …) because it's blazzing fast and easy. The first step is to create clean CSV files.

What I don't know yet is how much the data must be sanitized, like DePaul and DePaul University in drafts.csv.

nddrylliog commented 12 years ago

(Note: the dataset is pretty small anyway so speed is not really an issue here)

I wouldn't even bother normalizing universities, it's just a text column , not a unique id = no biggie.

greut commented 12 years ago

I'm pretty sure they will be pita's about NF's.

greut commented 12 years ago

We're done for now ;-)