Version 9, last updated by alc28 at 07 May 17:32 UTC
database structure
The IOTA mysql database structure is simple. It has two tables right now. The primary table where the metrics are stored is 'oq'. (Note: In the user interface 'source vendor' = 'origin' and 'source database' = 'sid'.)
| Field | Type | Example value |
| id | int (autoincrement) | 815721 |
| logsource | varchar (50) | cornell |
| year | year (4) | 2009 |
| quarter | varchar (10) | q1 |
| origin | varchar (250) | ams |
| sid | varchar (250) | ams:mathscinet |
| metric | varchar (30) | atitle |
| openurltype | varhchar (15) | article|book|other |
| count | int | 527 |
| timestamp | date | 2010-03-17 |
There is a second table called 'patterns'. This table is used to store information needed for linking the user interface.
| Field | Type | Example vaue |
| id | int (autoincrement) | 2 |
| metric | varchar (50) | atitle_colon |
| category | varchar (20) | atitle |
| regex | varchar (50) | /^.+:.+$/ |
| note | varchar (50) | NULL |
| timestamp | timestamp |