The project was initiated and maintained by SRI's Artificial Intelligence Center, which is known best for its DARPA related projects. SRI, or the Stanford Research Institute is one of the world's largest contract research institutes.
Publichouse can easily complete at least one quarter of one's data mining 'curriculum'. This is based on a very rough estimate of the time publichouse is saving me for one of my research projects. Whilst their SQL server is indeed quite fast -though 'demanded' at times, to put it mildly- their user frontend and webserver has seen better days. On the menu of web-interfaces is phpMyAdmin, which is quite wasteful with application-resources to begin with.
|Fig 1.a showing an excerpt (ca ~8%) of the relational database tables of publichouse|
Click here to view the Database as png (1.9MB)
Click here to download/view the Database as svg.gz (1.9MB)
Click here to download/view the Database as svg (5MB)
Click here to download/view the Database as pdf with captions (2MB)
Click here to download/view the Database as pdf without captions (2MB)
Note: There is a minor bug in MySQL workbench. When changing the model settings, you will have to change the Model>Relationship Notation in order to 'commit' the change, and then revert back to your Relationship Notation of choice.
Crow'S foot's Notation is used:
|Fig 1.b overview of the most important relationship symbols in crow's foot notation of (RDB) tables. (Adapted from http://ironbark.bendigo.latrobe.edu.au/subjects/IS/sem12007 )|