Recently (today or sometime today) we had our third checkpoint for our CSE 241 final project due. The first two checkpoints were focused on the design of our databases. For our third checkpoint, we were required to actually populate our databases. This might not sound that bad, but it could potentially take days if you do it the wrong way. For scope, if I had just ten tables that had perhaps five attributes, I would have a total of fifty attributes that would need to be populated. We are required to have about a hundred tuples in each table, so we would basically need 5000 different pieces of data. The most basic way to insert data into a SQL database is to write a SQL statement to insert the specific thing you want in the table. An example of this state would be something like “INSERT into table(column) VALUES(some_value)”. In order to populate your entire database this way , you would need to write 5000 different SQL statements. One of the easier things to do is to write java code that will automate this populating process. However, I believe I have found one of the easiest ways to populate my database. There is a website that will automatically generate the values of the table that I ask for (things like names and objects) and will essentially write the SQL statement that I need to run to insert all the values into my database; the SQL statement is really long, but since I don’t write it, it doesn’t matter to me. Finding this website saved me quite a bit of time because I do not know how long it would have taken me to write code to automate the data population.
About The BlogThe official student blog for the Electrical and Computer Engineering and Computer Science at Lehigh University.
VIEW MORE >
Blogs I Follow