New Datatypes
A Sample Table in a Relational Database:
HIVTable
| ID |
Screen I |
Screen II |
| DY-30000 |
0 |
0 |
| DY-30001 |
0 |
0 |
| DY-30002 |
1 |
0 |
SQL: Select ID from
HIVTable
ID DY-30000
ID DY-30001
ID DY-30002
A Sample Table in an Object Relational Database:
HIVTable
| Molecule |
Screen I |
Screen II |
| CC(=O)C(=Cc1ccc(cc1)c2ccccc2)C(=O)C |
0 |
0 |
| Nc1ncnc2n(C=C=CCO)cnc12 |
0 |
0 |
| CC1(O)CCC2(CCC1C2O)C#N |
1 |
0 |
SQL: Select Molecule from HIVTable
Molecule CC(=O)C(=Cc1ccc(cc1)c2ccccc2)C(=O)C
Molecule Nc1ncnc2n(C=C=CCO)cnc12
Molecule CC1(O)CCC2(CCC1C2O)C#N
