Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
UDC/How is Usage Data Stored
< UDC
Revision as of 14:11, 22 September 2010 by Unnamed Poltroon (Talk) (New page: =Overview= Usage data is aggressively normalized on the server. Ultimately, the data is stored in multiple tables. =Tables= ==Profile== A record is created in the profile table, ''usag...)
Overview
Usage data is aggressively normalized on the server. Ultimately, the data is stored in multiple tables.
Tables
Profile
A record is created in the profile table, usagedata_profile for each workspace we encounter. When the UDC uploads data, it provides us with two identifiers (both are UUIDs generated by the UDC) representing the user and the workspace. The user identifier effectively represents an individual computer; the workspace identifier represents an individual workspace. This distinction was deemed necessary in order to account for users who run multiple Eclipse workspaces.
Table Description
The table contains an id field which is the primary key. This field is used as the target of the foreign-key reference from the Upload table.
+-------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | userId | char(40) | NO | MUL | | | | workspaceId | char(40) | NO | MUL | | | +-------------+------------------+------+-----+---------+----------------+