In this section Hide
Source database tables are the Oracle tables or views that store prepared safety data, which has been cleaned and transformed for data mining. To prepare source database tables, you can use standard Oracle tools or any application that enables you to work with Oracle tables. In preparing the analysis tables, you must:
The base tables are as follows:
DEMO table:
CASE_ID |
GENDER |
COUNTRY |
REPORT_DATE |
BIRTH_DATE |
123 |
M |
US |
12/01/2001 |
01/16/1954 |
138 |
F |
France |
01/05/2000 |
07/01/1965 |
147 |
M |
Japan |
09/17/2001 |
03/11/1942 |
154 |
F |
US |
10/04/1999 |
09/07/1966 |
ANTIGENS table:
CASE_ID |
VAX_NAME |
ANTIGEN |
VAX_LOT |
123 |
VAX A |
ANTIGEN 1 |
15HR34 |
123 |
VAX A |
ANTIGEN 2 |
15HR34 |
138 |
VAX B |
ANTIGEN 3 |
49J3 |
147 |
VAX C |
ANTIGEN 4 |
97WEO |
147 |
VAX C |
ANTIGEN 2 |
97WEO |
154 |
VAX D |
ANTIGEN 3 |
D90477F6 |
SYMPTOMS table:
CASE_ID |
SYMPTOM |
START |
STOP |
SEVERITY |
NARRATIVE |
123 |
Rash |
10/30/01 |
11/25/01 |
Moderate |
Red weeping rash on left side of neck extending from left back of neck over shoulder to left clavicle. |
138 |
Hearing loss |
11/14/00 |
12/05/00 |
Severe |
Total hearing loss, both ears. |
147 |
Rash |
09/01/01 |
09/03/01 |
Mild |
Red weeping rash on right forearm. |
154 |
Vertigo |
09/30/99 |
10/03/99 |
Severe |
After walking block, patient experienced abrupt feeling of spinning and almost fell down. |
Suppose that the following data is needed for data mining:
To prepare source database tables, you can do the following:
The resulting source database tables (or views) might look like this:
DEMO_ANALYSIS view:
RPT_ID |
GENDER |
RCVD_YEAR |
AGE_GROUP |
123 |
M |
2001 |
40-49 |
154 |
F |
1999 |
30-39 |
VACCINES_ANALYSIS view:
RPT_ID |
VACCINE |
ANTIGEN |
LOT_NO |
123 |
VAX A |
ANTIGEN 1 |
15HR34 |
123 |
VAX A |
ANTIGEN 2 |
15HR34 |
154 |
VAX D |
ANTIGEN 3 |
D90477F6 |
SYMPTOMS_ANALYSIS view:
RPT_ID |
SYMPTOM |
DUR_DAYS |
SEVERITY |
123 |
Rash |
27 |
Moderate |
154 |
Vertigo |
4 |
Severe |
DRILLDOWN view:
RPT_ ID |
GENDER |
VACCINE |
SYMPTOM |
DUR_ DAYS |
SEVERITY |
AGE_ GROUP |
NARRATIVE |
123 |
M |
VAX A |
Rash |
27 |
Moderate |
40-49 |
Red weeping rash on left side of neck extending from left back of neck over shoulder to left clavicle. |
154 |
F |
VAX D |
Vertigo |
4 |
Severe |
30-39 |
After walking a block, patient experienced abrupt feeling of spinning and almost fell down. |