mendevi.plot.extract

Define the functions that enable values to be extracted from a select query.

Classes

SqlLinker(*select)

Allow you to add an SQL query to an extractor.

Functions

`extract_act_duration`(raw)	Return the video processing activity duration in seconds.
`extract_bitrate`(raw)	Return the video bitrate in bit per second.
`extract_cores`(raw)	Return the average cumulative utilisation rate of logical cores.
`extract_effort`(raw)	Return the effort provided as a parameter to the encoder.
`extract_enc_scenario`(raw)	Return the unique string specific to the encoding scenario.
`extract_encoder`(raw)	Return the name of the encoder.
`extract_lpips`(raw)	Return the Learned Perceptual Image Patch Similarity (LPIPS) with alex.
`extract_lpips_alex`(raw)	Return the Learned Perceptual Image Patch Similarity (LPIPS) with alex.
`extract_lpips_vgg`(raw)	Return the Learned Perceptual Image Patch Similarity (LPIPS) with vgg.
`extract_profile`(raw)	Return the profile of the video.
`extract_psnr`(raw)	Return the Peak Signal to Noise Ratio (PSNR).
`extract_quality`(raw)	Return the quality level passed to the encoder.
`extract_src_vid`(raw)	Return the input video name.
`extract_ssim`(raw)	Return the Structural Similarity (SSIM).
`extract_threads`(raw)	Return the number of threads provided as a parameter to the encoder.
`extract_vmaf`(raw)	Return the Video Multi-Method Assessment Fusion (VMAF).
`extract_wattmeter_energy`(raw)	Return the total energy consumption in Joules.
`extract_wattmeter_power`(raw)	Return the average power consumption in Watts.

Details

class mendevi.plot.extract.SqlLinker(*select: str)[source]

Allow you to add an SQL query to an extractor.

Initialise the linker.

Parameters

selectargs[str]: The fields to be returned (juste after SELECT), with the optional alias.

mendevi.plot.extract.extract_act_duration(raw: dict[str]) → float[source]

Return the video processing activity duration in seconds.

SELECT t_act_activity.act_duration
FROM t_dec_decode
JOIN t_act_activity
    ON t_dec_decode.dec_act_id = t_act_activity.act_id

or, alternativaly

SELECT t_act_activity.act_duration
FROM t_enc_encode
JOIN t_act_activity
    ON t_enc_encode.enc_act_id = t_act_activity.act_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_bitrate(raw: dict[str]) → float[source]

Return the video bitrate in bit per second.

SELECT t_dst_video.vid_duration, t_dst_video.vid_size
FROM t_dec_decode
JOIN t_vid_video AS t_dst_video
    ON t_dec_decode.dec_vid_id = t_dst_video.vid_id

or, alternativaly

SELECT t_dst_video.vid_duration, t_dst_video.vid_size
FROM t_enc_encode
JOIN t_vid_video AS t_dst_video
    ON t_enc_encode.enc_dst_vid_id = t_dst_video.vid_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_cores(raw: dict[str]) → float[source]

Return the average cumulative utilisation rate of logical cores.

SELECT t_act_activity.act_ps_core, t_act_activity.act_ps_dt
FROM t_dec_decode
JOIN t_act_activity
    ON t_dec_decode.dec_act_id = t_act_activity.act_id

or, alternativaly

SELECT t_act_activity.act_ps_core, t_act_activity.act_ps_dt
FROM t_enc_encode
JOIN t_act_activity
    ON t_enc_encode.enc_act_id = t_act_activity.act_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_effort(raw: dict[str]) → str[source]

Return the effort provided as a parameter to the encoder.

SELECT t_enc_encode.enc_effort
FROM t_enc_encode

or, alternativaly

SELECT t_enc_encode.enc_effort
FROM t_dec_decode
JOIN t_enc_encode
    ON t_dec_decode.dec_vid_id = t_enc_encode.enc_dst_vid_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_enc_scenario(raw: dict[str]) → str[source]

Return the unique string specific to the encoding scenario.

SELECT t_enc_encode.enc_cmd, t_enc_encode.enc_vid_id, t_vid_video.vid_name
FROM t_enc_encode
JOIN t_vid_video
    ON t_enc_encode.enc_src_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_enc_encode.enc_cmd, t_enc_encode.enc_vid_id, t_vid_video.vid_name
FROM t_dec_decode
JOIN t_vid_video
    ON t_dec_decode.dec_vid_id = t_vid_video.vid_id
JOIN t_enc_encode
    ON t_dec_decode.dec_vid_id = t_enc_encode.enc_dst_vid_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_encoder(raw: dict[str]) → str[source]

Return the name of the encoder.

SELECT t_enc_encode.enc_encoder
FROM t_enc_encode

or, alternativaly

SELECT t_enc_encode.enc_encoder
FROM t_dec_decode
JOIN t_enc_encode
    ON t_dec_decode.dec_vid_id = t_enc_encode.enc_dst_vid_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_lpips(raw: dict[str]) → float[source]

Return the Learned Perceptual Image Patch Similarity (LPIPS) with alex.

SELECT t_met_metric.met_lpips_alex, t_met_metric.met_lpips_vgg
FROM t_met_metric

or, alternativaly

SELECT t_met_metric.met_lpips_alex, t_met_metric.met_lpips_vgg
FROM t_dec_decode
JOIN t_met_metric
    ON t_dec_decode.dec_vid_id = t_met_metric.met_dis_vid_id

or, alternativaly

SELECT t_met_metric.met_lpips_alex, t_met_metric.met_lpips_vgg
FROM t_enc_encode
JOIN t_met_metric
    ON t_enc_encode.enc_dst_vid_id = t_met_metric.met_dis_vid_id AND t_enc_encode.enc_src_vid_id = t_met_metric.met_ref_vid_id

or, alternativaly

SELECT t_met_metric.met_lpips_alex, t_met_metric.met_lpips_vgg
FROM t_vid_video
JOIN t_met_metric
    ON t_vid_video.vid_id = t_met_metric.met_dis_vid_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_lpips_alex(raw: dict[str]) → float[source]

Return the Learned Perceptual Image Patch Similarity (LPIPS) with alex.

SELECT t_met_metric.met_lpips_alex
FROM t_met_metric

or, alternativaly

SELECT t_met_metric.met_lpips_alex
FROM t_dec_decode
JOIN t_met_metric
    ON t_dec_decode.dec_vid_id = t_met_metric.met_dis_vid_id

or, alternativaly

SELECT t_met_metric.met_lpips_alex
FROM t_enc_encode
JOIN t_met_metric
    ON t_enc_encode.enc_dst_vid_id = t_met_metric.met_dis_vid_id AND t_enc_encode.enc_src_vid_id = t_met_metric.met_ref_vid_id

or, alternativaly

SELECT t_met_metric.met_lpips_alex
FROM t_vid_video
JOIN t_met_metric
    ON t_vid_video.vid_id = t_met_metric.met_dis_vid_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_lpips_vgg(raw: dict[str]) → float[source]

Return the Learned Perceptual Image Patch Similarity (LPIPS) with vgg.

SELECT t_met_metric.met_lpips_vgg
FROM t_met_metric

or, alternativaly

SELECT t_met_metric.met_lpips_vgg
FROM t_dec_decode
JOIN t_met_metric
    ON t_dec_decode.dec_vid_id = t_met_metric.met_dis_vid_id

or, alternativaly

SELECT t_met_metric.met_lpips_vgg
FROM t_enc_encode
JOIN t_met_metric
    ON t_enc_encode.enc_dst_vid_id = t_met_metric.met_dis_vid_id AND t_enc_encode.enc_src_vid_id = t_met_metric.met_ref_vid_id

or, alternativaly

SELECT t_met_metric.met_lpips_vgg
FROM t_vid_video
JOIN t_met_metric
    ON t_vid_video.vid_id = t_met_metric.met_dis_vid_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_profile(raw: dict[str]) → str[source]

Return the profile of the video.

SELECT t_vid_video.vid_width
FROM t_vid_video

or, alternativaly

SELECT t_vid_video.vid_width
FROM t_dec_decode
JOIN t_vid_video
    ON t_dec_decode.dec_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_width
FROM t_enc_encode
JOIN t_vid_video
    ON t_enc_encode.enc_src_vid_id = t_vid_video.vid_id

or, alternativaly

SELECT t_vid_video.vid_width
FROM t_met_metric
JOIN t_vid_video
    ON t_met_metric.met_dis_vid_id = t_vid_video.vid_id

The profile is determined based on the width of the video.

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_psnr(raw: dict[str]) → float[source]

Return the Peak Signal to Noise Ratio (PSNR).

SELECT t_met_metric.met_psnr
FROM t_met_metric

or, alternativaly

SELECT t_met_metric.met_psnr
FROM t_dec_decode
JOIN t_met_metric
    ON t_dec_decode.dec_vid_id = t_met_metric.met_dis_vid_id

or, alternativaly

SELECT t_met_metric.met_psnr
FROM t_enc_encode
JOIN t_met_metric
    ON t_enc_encode.enc_dst_vid_id = t_met_metric.met_dis_vid_id AND t_enc_encode.enc_src_vid_id = t_met_metric.met_ref_vid_id

or, alternativaly

SELECT t_met_metric.met_psnr
FROM t_vid_video
JOIN t_met_metric
    ON t_vid_video.vid_id = t_met_metric.met_dis_vid_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_quality(raw: dict[str]) → float[source]

Return the quality level passed to the encoder.

SELECT t_enc_encode.enc_quality
FROM t_enc_encode

or, alternativaly

SELECT t_enc_encode.enc_quality
FROM t_dec_decode
JOIN t_enc_encode
    ON t_dec_decode.dec_vid_id = t_enc_encode.enc_dst_vid_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_src_vid(raw: dict[str]) → str[source]

Return the input video name.

SELECT t_ref_video.enc_vid_name AS ref_vid_name
FROM t_dec_decode
JOIN t_enc_encode AS t_enc_from_dec
    ON t_dec_decode.dec_vid_id = t_enc_from_dec.enc_dst_vid_id JOIN t_vid_video AS t_ref_video
    ON t_enc_from_dec.enc_src_vid_id = t_ref_video.vid_id

or, alternativaly

SELECT t_ref_video.enc_vid_name AS ref_vid_name
FROM t_enc_encode
JOIN t_vid_video AS t_ref_video
    ON t_enc_encode.enc_src_vid_id = t_ref_video.vid_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_ssim(raw: dict[str]) → float[source]

Return the Structural Similarity (SSIM).

SELECT t_met_metric.met_ssim
FROM t_met_metric

or, alternativaly

SELECT t_met_metric.met_ssim
FROM t_dec_decode
JOIN t_met_metric
    ON t_dec_decode.dec_vid_id = t_met_metric.met_dis_vid_id

or, alternativaly

SELECT t_met_metric.met_ssim
FROM t_enc_encode
JOIN t_met_metric
    ON t_enc_encode.enc_dst_vid_id = t_met_metric.met_dis_vid_id AND t_enc_encode.enc_src_vid_id = t_met_metric.met_ref_vid_id

or, alternativaly

SELECT t_met_metric.met_ssim
FROM t_vid_video
JOIN t_met_metric
    ON t_vid_video.vid_id = t_met_metric.met_dis_vid_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_threads(raw: dict[str]) → int[source]

Return the number of threads provided as a parameter to the encoder.

SELECT t_enc_encode.enc_threads
FROM t_enc_encode

or, alternativaly

SELECT t_enc_encode.enc_threads
FROM t_dec_decode
JOIN t_enc_encode
    ON t_dec_decode.dec_vid_id = t_enc_encode.enc_dst_vid_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_vmaf(raw: dict[str]) → float[source]

Return the Video Multi-Method Assessment Fusion (VMAF).

SELECT t_met_metric.met_vmaf
FROM t_met_metric

or, alternativaly

SELECT t_met_metric.met_vmaf
FROM t_dec_decode
JOIN t_met_metric
    ON t_dec_decode.dec_vid_id = t_met_metric.met_dis_vid_id

or, alternativaly

SELECT t_met_metric.met_vmaf
FROM t_enc_encode
JOIN t_met_metric
    ON t_enc_encode.enc_dst_vid_id = t_met_metric.met_dis_vid_id AND t_enc_encode.enc_src_vid_id = t_met_metric.met_ref_vid_id

or, alternativaly

SELECT t_met_metric.met_vmaf
FROM t_vid_video
JOIN t_met_metric
    ON t_vid_video.vid_id = t_met_metric.met_dis_vid_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_wattmeter_energy(raw: dict[str]) → float[source]

Return the total energy consumption in Joules.

SELECT t_act_activity.act_wattmeter_dt, t_act_activity.act_wattmeter_power
FROM t_dec_decode
JOIN t_act_activity
    ON t_dec_decode.dec_act_id = t_act_activity.act_id

or, alternativaly

SELECT t_act_activity.act_wattmeter_dt, t_act_activity.act_wattmeter_power
FROM t_enc_encode
JOIN t_act_activity
    ON t_enc_encode.enc_act_id = t_act_activity.act_id

Parameters

rawdict[str]: The result line of select request.

mendevi.plot.extract.extract_wattmeter_power(raw: dict[str]) → float[source]

Return the average power consumption in Watts.

SELECT t_act_activity.act_wattmeter_dt, t_act_activity.act_wattmeter_power
FROM t_dec_decode
JOIN t_act_activity
    ON t_dec_decode.dec_act_id = t_act_activity.act_id

or, alternativaly

SELECT t_act_activity.act_wattmeter_dt, t_act_activity.act_wattmeter_power
FROM t_enc_encode
JOIN t_act_activity
    ON t_enc_encode.enc_act_id = t_act_activity.act_id

Parameters

rawdict[str]: The result line of select request.