|
|
TODO |
|
|
\ No newline at end of file |
|
|
## About Oligos
|
|
|
|
|
|
*Oligos* is a profiling tool that extracts a generator specification from a given reference database. Therefore it make extensive use of stored database statistics. Oligos collects database statistics such as cardinalities, most frequent values, distribution statistics and many more, and uses this information to create a dense description of the profiled database. This information is then used to create a *Myriad* XML Specification. For more information about Oligos go to the [project homepage](https://bitbucket.org/carabolic/oligos).
|
|
|
|
|
|
## Using Oligos with Myriad
|
|
|
|
|
|
One way to generate a *Myriad* XML Specification is to use *Oligos* and a reference database. In order to do so you need to run the `compile:oligos` task. The only prerequisite to run the `compile:oligos` task is the specific JDBC driver for your database. There are two ways to the JDBC driver to your *Myriad* project
|
|
|
* Add the path to the `$CLASSPATH` environment variable, or
|
|
|
* Add the path to the `MYRIAD_OLIGOS_CP` property in the `$PROJECT-HOME/.myriad-settings` file
|
|
|
|
|
|
After setting the path to the specific JDBC driver you can start using *Myriad* with *Oligos*. The basic syntax of the `compile:oligos` is a follows
|
|
|
|
|
|
```
|
|
|
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:
|
|
|
|
|
|
```
|
|
|
SCHEMA_A (
|
|
|
TABLE_A (
|
|
|
COLUMN_A,
|
|
|
COLUMN_B,
|
|
|
....
|
|
|
),
|
|
|
TABLE_B,
|
|
|
...
|
|
|
),
|
|
|
SCHEMA_B,
|
|
|
...
|
|
|
```
|
|
|
|
|
|
## Examples
|
|
|
|
|
|
```
|
|
|
myriad-assistant compile:oligos -h localhost -P 60000 -D TPCH -u DB2INST1 -p mypass DB2INST1 (ORDERS, CUSTOMER)
|
|
|
``` |
|
|
\ No newline at end of file |