![]() |
EAR 4.2.1
EAR Reference Manual
|
The main tables in the database Report and each of their rows are:
- Applications: Contains basic information about where the application was executed (node_id) and the id's of the executed job and the final computated application signature. - Jobs: Contains the information about a job execution [user_id, app_id,start_time, end_time], as well as the EAR parameters defined executon (policy, threshold) and node information (procs, def_f). - Signatures: Contains the information of an application signature computed and used by EAR. - Loops: Contains the information of an application loop, its identifying characteristics (type of event, size, level and total iterations), the job it belongs to and the computed signature of the loop. - Power_signatures: Contains power metrics of an application. - Periodic_metrics: Contains information about a node's energy consumption with the purpose of monitoring it. - Periodic_aggregations: Contains the same information as Periodic_metrics but aggregated by periods of time, not of each node individually. - Learning_[tables]: The tables that begin with the "Learning_" prefix contain the same as their counterparts without prefix, but are used exclusively for the learning phase of the EAR library.
-The relationship between the tables can be seen in the adjunct diagram, as well as the general equivalent of their MySQL types.
Other tables are: