最终 GAN 比例:0.75
验证集精度:85.2%
FID Score:25.6
对抗攻击成功率:12.3%
平均精度:84.5%
-- 获取核心指标数据
SELECT
(SELECT AVG(metric_value) FROM `autonomous_driving`.`view_gan_data_quality` WHERE metric_name = 'KL散度') AS kl_divergence,
(SELECT COUNT(*) FROM `autonomous_driving`.`corner_case_definitions`) AS corner_case_count;
-- 获取GAN数据质量监控数据
SELECT
metric_name,
metric_value
FROM
`autonomous_driving`.`view_gan_data_quality`
WHERE
evaluation_timestamp >= DATE_SUB(NOW(), INTERVAL 1 DAY);
-- 获取Corner Case 场景覆盖度数据
SELECT
risk_level,
COUNT(*) AS count
FROM
`autonomous_driving`.`corner_case_definitions`
GROUP BY
risk_level;
-- 创建statistics 表
CREATE TABLE `autonomous_driving`.`statistics` (
`id` INT NOT NULL AUTO_INCREMENT,
`total_kl_divergence` DECIMAL(10,2) NULL,
`total_corner_cases` INT NULL,
`last_updated` TIMESTAMP NULL,
PRIMARY KEY (`id`));
-- 创建触发器
CREATE TRIGGER update_statistics
AFTER INSERT ON autonomous_driving.model_evaluations
FOR EACH ROW
BEGIN
UPDATE autonomous_driving.statistics
SET total_kl_divergence = (SELECT AVG(metric_value) FROM autonomous_driving.view_gan_data_quality WHERE metric_name = 'KL散度'),
total_corner_cases = (SELECT COUNT(*) FROM autonomous_driving.corner_case_definitions),
last_updated = NOW()
WHERE id = 1;
END;
-- 初始数据初始化
INSERT INTO autonomous_driving.statistics (id) VALUES (1);
// 后端 API 接口(示例)
app.get('/api/core_metrics', async (req, res) => {
try {
// 模拟数据库查询
const data = {
kl_divergence: 0.52,
corner_case_count: 125
};
res.json(data);
} catch (error) {
console.error(error);
res.status(500).json({error: 'Internal Server Error'});
}
});
-- 创建statistics 表
CREATE TABLE `autonomous_driving`.`statistics` (
`id` INT NOT NULL AUTO_INCREMENT,
`total_kl_divergence` DECIMAL(10,2) NULL,
`total_corner_cases` INT NULL,
`last_updated` TIMESTAMP NULL,
PRIMARY KEY (`id`));
-- 创建触发器
CREATE TRIGGER update_statistics
AFTER INSERT ON autonomous_driving.model_evaluations
FOR EACH ROW
BEGIN
UPDATE autonomous_driving.statistics
SET total_kl_divergence = (SELECT AVG(metric_value) FROM autonomous_driving.view_gan_data_quality WHERE metric_name = 'KL散度'),
total_corner_cases = (SELECT COUNT(*) FROM autonomous_driving.corner_case_definitions),
last_updated = NOW()
WHERE id = 1;
END;
-- 初始数据初始化
INSERT INTO autonomous_driving.statistics (id) VALUES (1);