February 19, 2006
Originally published at https://digitalhistoryhacks.blogspot.com/2006/02/text-mining-dcb-part-5.html
My original plan for this series of posts was to show how it is relatively simple to spider an online historical collection like the Dictionary of Canadian Biography1, scrape out some information, and use it to make possibly novel inferences. Up until now, we’ve been storing information in text files, which is OK for a simple demo but unwieldy if we want to try something more ambitious.
As a result I’ve decided to make a few modifications so that we can store information in a relational database2 instead. Eventually, I will probably implement something open source on a server, like MySQL3. In the meantime, however, I already have MS Access4 installed on my computer so that is what I am going to use. It shouldn’t be too hard to port5 later.
In my next post I will describe the intial data tables and the way we get Perl to talk to our database…
Tags: dictionary of canadian biography6 | digital history7 | relational databases8 | text mining9
Previous: Historiographical Process(ing)
Next: Brief Hiatus
Back to the blog archive
http://www.biographi.ca/EN ↩
http://en.wikipedia.org/wiki/Relational_databases ↩
http://www.mysql.com/ ↩
http://office.microsoft.com/en-us/FX010857911033.aspx ↩
http://en.wikipedia.org/wiki/Porting ↩
http://technorati.com/tag/dictionary+of+canadian+biography ↩
http://technorati.com/tag/digital+history ↩
http://technorati.com/tag/relational+databases ↩
http://technorati.com/tag/text+mining ↩