Schemas

A schema defines the datasources to be captured, stored and used throughout the system. Schemas should be added to schema groups so they can be organized and easily assigned to processes.

Add a schema group (monCore) and the following schemas:

monCPU (CPU usage).
monMem (memory usage).
monDisk (disk usage).
monAvgLoad (aggregated view of above statistics).

Create schema group

Right-click on KxWarehouse Package and select New > Schema Group from the context menu.

A dialog will appear. Enter the name monCore and press the Add button.

The schema group editor will open with the schema group.
For now, save the schema group by clicking on the Save button on the right side of the editor.
The schema group will appear in the tree.

Add schemas

monMem

Right-click on the monCore schema group and select New > Schema from the context menu

A dialog will appear. Enter monMem and click the Add button.

A schema editor will open with the Schema Details subtab displayed. Enter a description into the text field.

Make the monMem part of the monCore schema group by adding it to the selected groups.

Now provide the column definitions for the monMem table. Column names and ordering are important. Enter the following column names, types, descriptions, and attributes into the schema definition:

Info box

To apply a timestamp to the data, add an initial field of type timestamp as the first column in the table.

Once the schema definition is complete, click Save

monCPU

Follow the steps above to create the monCPU schema using the meta below.

Column Name	Type
time	Timestamp
sym	Symbol
usage	Float

monDisk

Now create the monDisk schema using the meta below.

Column Name	Type
time	Timestamp
sym	Symbol
usage	Float

monAvgLoad

Create and define the last schema and name it monAvgLoad.

Column Name	Type
time	Timestamp
sym	Symbol
avgCPU	Float
avgMemV	Float
avgMemP	Float
avgDisk	Float

The updated tree will look like: