... | ... | @@ -14,8 +14,20 @@ After setting the path to the specific JDBC driver you can start using *Myriad* |
|
|
myriad-assistant compile:oligos -h [host] -P [port] -D [database] -u [username] -p [password] [schema]
|
|
|
```
|
|
|
|
|
|
Where `host` is the hostname of your database, `port` is the database port, `database` is the name of the database, `username` and `password` are the credentials used for authentication. The `schema` has the following syntax:
|
|
|
Where `host` is the hostname of your database, `port` is the database port, `database` is the name of the database, `username` and `password` are the credentials used for authentication. The `schema` states which columns should be profiled and has the following syntax (Backus Naur Form):
|
|
|
|
|
|
```bnf
|
|
|
COLUMN_SEQUENCE = COLUMN_ID {"," COLUMN_ID}
|
|
|
TABLE_DEFINITION = TABLE_ID ["(" COLUMN_SEQUENCE ")"]
|
|
|
TABLE_SEQUENCE = TABLE_DEFINITION {"," TABLE_DEFINITION}
|
|
|
SCHEMA_DEFINITION = SCHEMA_ID ["(" TABLE_SEQUENCE ")"]
|
|
|
|
|
|
SCHEMA = SCHEMA_DEFINITION {"," SCHEMA_DEFINITION}
|
|
|
```
|
|
|
|
|
|
A schema consists of at least a `SCHEMA_ID` which is the name of the schema you want to profile. A `SCHEMA_ID` is followed by an optional sequence of `TABLE_DEFINITIONs` enclosed in parentheses and separated by `,` (comma). Each `TABLE_DEFINITION` in turn contains a mandatory `TABLE_ID` (read: table name) and an optional sequence of `COLUMN_IDs`. If you omit a `TABLE_SEQUENCE` or `COLUMN_SEQUENCE` it is interpreted as wildcard and all tables, columns resp., are profiled.
|
|
|
|
|
|
<!-- graphical schema description
|
|
|
```
|
|
|
SCHEMA_A (
|
|
|
TABLE_A (
|
... | ... | @@ -29,9 +41,28 @@ SCHEMA_A ( |
|
|
SCHEMA_B,
|
|
|
...
|
|
|
```
|
|
|
-->
|
|
|
|
|
|
## Examples
|
|
|
|
|
|
### Reference Database
|
|
|
|
|
|
All of the following examples use the TPCH Schema. The schema is as follows:
|
|
|
![TPCH Schema](https://www.ki.informatik.hu-berlin.de/wbi/teaching/archive/sose04/fosem/tpch-schema.png/image)
|
|
|
|
|
|
It is assumed that the database is running on localhost on port 60000. The name of the database is TPCH and the default schema is DB2INST1. Furthermore the username is DB2INST1 and the password is mypass.
|
|
|
|
|
|
### Profile O_ORDERDATE and O_TOTALPRICE
|
|
|
```bash
|
|
|
myriad-assistant compile:oligos -h localhost -P 60000 -D TPCH -u DB2INST1 -p mypass DB2INST1 (ORDERS (O_ORDERDATE, O_TOTALPRICE))
|
|
|
```
|
|
|
|
|
|
### Profile ORDERS and CUSTOMER (complete)
|
|
|
```bash
|
|
|
myriad-assistant compile:oligos -h localhost -P 60000 -D TPCH -u DB2INST1 -p mypass DB2INST1 (ORDERS, CUSTOMER)
|
|
|
```
|
|
|
|
|
|
### Profile the entire TPCH Database
|
|
|
```bash
|
|
|
myriad-assistant compile:oligos -h localhost -P 60000 -D TPCH -u DB2INST1 -p mypass DB2INST1
|
|
|
``` |
|
|
\ No newline at end of file |