Hi,
I have the following problem:
I want to store a list of events e_1 to e_n in one table, and in a second table I would like to
store sequences of these events so that later I can ask questions like:
In what sequence has event e_5 happened as the third event.
My more or less trivial solution would be to have
an events table
table events event_key description of event
and a sequence table
table sequences
sequenceid
numberofevents
event_key1
event_key2
event_key3
...
event_keyN
,
with some predefined maximum number of events. Lets say N_max =10
Now if a sequence happens to contains only 3 events. How do I calculate the 'correct',
normalizable sequenceID. One way would be a string concatenation of the event keys.
to define as the primary key.
Any hints
Thanks Alex
-- Dr. rer. nat. Alexander Hannemann (Diplom-Chemiker) MPI f. Festkörperforschung Stuttgart Heisenbergstr. 1 70569 Stuttgart Tel: 0711-689-1366 Fax: 0711-689-1502 Email:[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
