... | ... | @@ -61,21 +61,21 @@ Take a look at the following examples of some concrete calls of the `compile:oli |
|
|
|
|
|
<center>![TPCH Schema](https://www.ki.informatik.hu-berlin.de/wbi/teaching/archive/sose04/fosem/tpch-schema.png/image)</center>
|
|
|
|
|
|
We assume that the database is running on localhost on port 60000, the name of the database is `TPCH`, and both the username and the default user schema are `DB2INST1`.
|
|
|
We assume that the database is running IBM DB2 on localhost on port 60000, the name of the database is `TPCH`, and both the username and the default user schema are `DB2INST1`.
|
|
|
|
|
|
The first example will generate a data generator specification only for the `O_ORDERDATE` and `O_TOTALPRICE` columns from the `ORDERS` table:
|
|
|
|
|
|
```bash
|
|
|
myriad-assistant compile:oligos -h localhost -P 60000 -D TPCH -u DB2INST1 -p "DB2INST1(ORDERS(O_ORDERDATE,O_TOTALPRICE))"
|
|
|
myriad-assistant compile:oligos -j db2 -h localhost -P 60000 -D TPCH -u DB2INST1 -p "DB2INST1(ORDERS(O_ORDERDATE,O_TOTALPRICE))"
|
|
|
```
|
|
|
The next example will generate a specification for the `ORDERS` and `CUSTOMER` tables using all columns in these two tables:
|
|
|
|
|
|
```bash
|
|
|
myriad-assistant compile:oligos -h localhost -P 60000 -D TPCH -u DB2INST1 -p mypass "DB2INST1 (ORDERS, CUSTOMER)"
|
|
|
myriad-assistant compile:oligos -j db2 -h localhost -P 60000 -D TPCH -u DB2INST1 -p mypass "DB2INST1 (ORDERS, CUSTOMER)"
|
|
|
```
|
|
|
|
|
|
The third example gives the most general schema specification, where Oligos will consider all tables and all columns located in the `DB2INST1`:
|
|
|
|
|
|
```bash
|
|
|
myriad-assistant compile:oligos -h localhost -P 60000 -D TPCH -u DB2INST1 -p mypass "DB2INST1"
|
|
|
myriad-assistant compile:oligos -j db2 -h localhost -P 60000 -D TPCH -u DB2INST1 -p mypass "DB2INST1"
|
|
|
``` |
|
|
\ No newline at end of file |