This server is a standard MySQL database. In the ASL database, it
accepts its connections from the local machine, not over the internet.
The MySQL database video files are not stored directly in the
database. Rather, the videos are stored in the file system. The
mySQL database contains paths to the videos and descriptions of each
video in a relational database format. Descriptions of the contents
tables are available in [1].
| Location data | |
| maintainer | Robot Vision Lab |
| machine | rvl2.ecn.purdue.edu |
| executable | /usr/local/libexec/mysqld |
| database files | /home/rvl2/a/mysql/ |
| database | asldatabase |
| users | asldata |
| readonly | |
| tables | Main |
| Glosses | |
| Paragrahs | |
| Subjects | |
| log file | /tmp/mysqld.log |
Users coming in from the web are made to be user 'readonly'.
The vidoes in the database are each named
xx-y-zz-u.avi
where the codes are given in the following table.
| Video file naming conventions | ||
| Signer code | xx |
01-14 |
| Type | y |
M (for motion), H (for handshapes), A (for alphabet), N (for number), P (for paragraph) |
| File number | zz |
1-43 (for motion), 1-10 (for paragraphs), 1-20 (for handshapes) |
| Lighting | u |
D(iffuse), C(ontrast) |
| Examples | |
| 01-M-01-C | Subject 1, Motion 1, Contrast lighting |
| 01-A-D | Subject 1, Alphabet, Diffuse lighting |