search

h2rashee / RefScheduler

http://csclub.uwaterloo.ca/~h2rashee/refScheduler/docs/
MIT License
0 stars 0 forks source link

Roster Table Architecture #15

Closed h2rashee closed 10 years ago

h2rashee commented 10 years ago

How to store and work with the referee roster table?

This is a table storing an average of 20 records in the context of the intended scenario. There are plenty of considerations for the appropriate data structure and how this data can be quickly and efficiently read in and stored again.

h2rashee commented 10 years ago

It was a consideration suggested by szbokhar to use an in-memory database like SleepyCat/BerkeleyDB to allow for quick querying operations. It was quickly determined that I wouldn't need to run many complex queries on the dataset and so it might be too powerful for what is intended.

h2rashee commented 10 years ago

After reviewing OpenCSV package available for Java and further browsing, I realised that a CSV file with one function used for reading the entire file into memory may suffice for our purposes.