search

vazexqi / CodingSpectator

Watches and analyzes code edits in the Eclipse IDE non-invasively
http://codingspectator.cs.illinois.edu
Other
20 stars 14 forks source link

Import the CSV file into a SQL database #254

Closed reprogrammer closed 13 years ago

reprogrammer commented 13 years ago

Import the collected data into a database to easily execute different queries.

reprogrammer commented 13 years ago

Currently, the program will throw an exception if the database is not cleaned up. We need to fix this problem. But, for the time being, you just need to delete HSQLDB files prior to running the program.

vazexqi commented 13 years ago

Given that our original data is in XML format, we would need to convert XML into a flat RDBMS. What was inadequate about using XQuery? Preserving the data in XML format also allows us to use it with Tableau. Tableau also supports RDBMS but only in the paid version.

reprogrammer commented 13 years ago

@rajkuma1 is good at writing SQL queries. So, he imported the CSV into an RDB and quickly wrote a few queries to find the answers to some of our research goals. We can still use XQuery if we find it better for writing certain queries.