taais/script/sql/postgresql/update20241113/algorithm_config.sql

DROP TABLE
IF
	EXISTS common_algorithm_config;
CREATE TABLE common_algorithm_config (
	id SERIAL PRIMARY KEY,-- 自增长的主键
	tool VARCHAR ( 100 ) NOT NULL,-- 工具，长度限制为 100
	module VARCHAR ( 100 ) NOT NULL,-- 模块，长度限制为 100
	algorithm_name VARCHAR ( 100 ) NOT NULL,-- 算法名称，长度限制为 100
	start_api VARCHAR ( 255 ),-- 开始接口，长度限制为 255
	pause_api VARCHAR ( 255 ),-- 暂停接口，长度限制为 255
	terminate_api VARCHAR ( 255 ),-- 终止接口，长度限制为 255
	parameters JSONB,-- 参数，使用 JSONB 类型存储结构化数据
	create_by INT,-- 创建者 ID
	create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,-- 创建时间
	update_by INT,-- 更新者 ID
	update_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,-- 更新时间
	remarks VARCHAR ( 500 ),-- 备注，长度限制为 500
	del_flag SMALLINT NOT NULL DEFAULT 0,-- 删除标志，0 表示未删除
	tenant_id INT,-- 租户 ID
	version INT -- 版本号

);


INSERT INTO common_algorithm_config ( tool, module, algorithm_name, start_api, terminate_api, parameters, remarks, tenant_id )
VALUES
	( '目标精确捕获技术设计支撑工具', '数据增强', '图像增强', 'http://127.0.0.1:11003/qushachen', 'http://127.0.0.1:11003/qushachen_stop',
	 '[{
      		"name": "中值滤波器核大小",
      		"agName": "s_v",
      		"value": "",
      		"validate": "",
      		"defaultValue": "41",
      		"required": true,
      		"index": 1,
      		"prompt": "正奇数范围（0~100）；终止滤波器核大小应当随着图片大小适当改变，当图片像素值增加时，应适当增加滤波器核大小参数。"
      	},
      	{
      		"name": "混合比例",
      		"agName": "ratio",
      		"value": "",
      		"validate": "",
      		"defaultValue": "0.33",
      		"required": true,
      		"index": 2,
      		"prompt": "正数范围（0~1）；将两种算法结果进行融合，当混合比例增加时，图片越接近原始灰度图像，当混合比例减小时，图片会凸显目标。"
      	}
      ]',
	 '图像增强算法配置', 0 );
INSERT INTO common_algorithm_config ( tool, module, algorithm_name, start_api, terminate_api, parameters, remarks, tenant_id )
VALUES
	( '目标精确捕获技术设计支撑工具', '数据增强', '图像逆光', 'http://127.0.0.1:11004/niguang', 'http://127.0.0.1:11002/niguang_stop',
	'[{
           		"name": "光照强度",
           		"agName": "light",
           		"value": "",
           		"validate": "",
           		"defaultValue": "48",
           		"required": true,
           		"index": 1,
           		"prompt": "正整数范围（40~60）；光照强度应随着图片亮度适当进行改变，即当逆光图像过暗时，应适当减小光照强度以提升算法效果。"
           	},
           	{
           		"name": "灰度对比拉伸参数",
           		"agName": "alpha",
           		"value": "",
           		"validate": "",
           		"defaultValue": "0.6",
           		"required": true,
           		"index": 2,
           		"prompt": "正数范围（0~1）；当图像对比度较低时，应适当增加拉伸参数以增强图像对比度。"
           	},
           	{
                "name": "灰度拉伸参数",
                "agName": "beta",
                "value": "",
                "validate": "",
                "defaultValue": "-20",
                "required": true,
                "index": 3,
                "prompt": "负整数范围（-30~-10）；当生成图像亮度过大，应适当减少参数以防止过度曝光。"
            }
           ]',
           '图像逆光算法配置', 0);
INSERT INTO common_algorithm_config ( tool, module, algorithm_name, start_api, terminate_api, parameters, remarks, tenant_id )
VALUES
	( '目标精确捕获技术设计支撑工具', '图像拼接', '侦察图像拼接算法_sift', 'http://127.0.0.1:11006/imageMosaic', 'http://127.0.0.1:11006/imageMosaic_stop', '[]', '侦察图像拼接算法_sift配置', 0 );
INSERT INTO common_algorithm_config ( tool, module, algorithm_name, start_api, terminate_api, parameters, remarks, tenant_id )
VALUES
	( '目标精确捕获技术设计支撑工具', '图像拼接', '侦察图像拼接算法_coordinate', 'http://127.0.0.1:11006/imageMosaic', 'http://127.0.0.1:11006/imageMosaic_stop', '[]', '侦察图像拼接算法_coordinate配置', 0 );
INSERT INTO common_algorithm_config ( tool, module, algorithm_name, start_api, terminate_api, parameters, remarks, tenant_id )
VALUES
	( '目标精确捕获技术设计支撑工具', '多目标跟踪', '多目标跟踪', 'http://127.0.0.1:10029/targetTrack', 'http://127.0.0.1:10029/targetTrack_stop',
	'[{
            "name": "模型权重",
            "agName": "yolo_model",
            "value": "",
            "validate": "",
            "defaultValue": "yolov8__best.pt",
            "required": true,
            "index": 1,
            "prompt": "使用yolov8进行目标检测时采用的模型权重，用户在给定的不同模型权重里选取。给定的模型权重为:[yolov8__best.pt, yolov8_best.pt, yolov8_best_new.pt, yolov8__best_new.pt]"
        },
        {
            "name": "跟踪方法",
            "agName": "tracking_method",
            "value": "",
            "validate": "",
            "defaultValue": "bytetrack",
            "required": true,
            "index": 2,
            "prompt": "在检测基础上跟踪目标时采用的跟踪方法，用户在给定的不同跟踪方法里选取。给定的跟踪方法为:[botsort, strongsort, bytetrack, ocsort, imprassoc, deepocsort]"
        },
        {
          "name": "视频帧宽度",
          "agName": "imgsz",
          "value": "",
          "validate": "",
          "defaultValue": "960",
          "required": true,
          "index": 3,
          "prompt": "输入视频的帧宽度，单位为像素，大于0的整数。"
        },
        {
            "name": "置信阈值",
            "agName": "conf",
            "value": "",
            "validate": "",
            "defaultValue": "0.5",
            "required": true,
            "index": 4,
            "prompt": "大于0小于1的浮点数。"
        },
        {
          "name": "交并比阈值",
          "agName": "交并比阈值",
          "value": "",
          "validate": "",
          "defaultValue": "0.7",
          "required": true,
          "index": 5,
          "prompt": "大于0小于1的浮点数。"
        }
     ]',
	 '多目标跟踪算法配置', 0 );
INSERT INTO common_algorithm_config ( tool, module, algorithm_name, start_api, terminate_api, parameters, remarks, tenant_id )
VALUES
	( '目标精确捕获技术设计支撑工具', '目标毁伤模块', '目标毁伤评估', 'http://localhost:11009/targetDamageAssessment', 'http://localhost:11009/targetDamageAssessment_stop', '[]', '目标毁伤评估算法配置', 0 );


INSERT INTO common_algorithm_config ( tool, module, algorithm_name, start_api, terminate_api, parameters, remarks, tenant_id )
VALUES
	( '目标精确捕获技术设计支撑工具', '多目标选择', '多源信息融合', '127.0.0.1:10027/objTrace', '127.0.0.1:10027/objTrace_stop',
	'[{
            "name": "输出宽度",
            "agName": "pic_width",
            "value": "",
            "validate": "",
            "defaultValue": "16.0",
            "required": false,
            "index": 1,
            "prompt": "输出图像宽度与DPI之比，大于0的浮点数，影响结果分辨率。"
        },
        {
            "name": "输出高度",
            "agName": "pic_height",
            "value": "",
            "validate": "",
            "defaultValue": "9.0",
            "required": false,
            "index": 2,
            "prompt": "输出图像的高度与DPI之比，其他同输出宽度。"
        },
        {
          "name": "DPI",
          "agName": "pic_dpi",
          "value": "",
          "validate": "",
          "defaultValue": "150",
          "required": false,
          "index": 3,
          "prompt": "输出图像的DPI，大于0的整数，同样影响输出结果的分辨率。"
        },
        {
            "name": "格式",
            "agName": "pic_type",
            "value": "",
            "validate": "",
            "defaultValue": ".png",
            "required": false,
            "index": 4,
            "prompt": "输出图像的格式，默认为png格式。"
        }
     ]',
	 '多源信息融合算法配置', 0 );


   INSERT INTO common_algorithm_config ( tool, module, algorithm_name, start_api, terminate_api, parameters, remarks, tenant_id )
VALUES
	( '目标精确捕获技术设计支撑工具', '多目标选择', '异源图像匹配定位', '127.0.0.1:10028/imgMatch', '127.0.0.1:10028/imgMatch_stop',
	'[{
            "name": "裁剪半径1",
            "agName": "cutsize",
            "value": "",
            "validate": "",
            "defaultValue": "200",
            "required": false,
            "index": 1,
            "prompt": "配准前的方形裁剪半径，单位为像素，范围由0到原图像半径（整数），避免调整过小。"
        },
        {
            "name": "裁剪半径2",
            "agName": "loc_cut_size",
            "value": "",
            "validate": "",
            "defaultValue": "50",
            "required": false,
            "index": 2,
            "prompt": "定位前的方形裁剪半径，避免调整过大，其他同裁剪半径1。"
        },
        {
          "name": "缩放比例1",
          "agName": "resize_scale",
          "value": "",
          "validate": "",
          "defaultValue": "1.0",
          "required": false,
          "index": 3,
          "prompt": "配准前裁剪结果的缩放比例，大于0的浮点数，影响结果中目标的大小。"
        },
        {
            "name": "缩放比例2",
            "agName": "loc_resize_scale",
            "value": "",
            "validate": "",
            "defaultValue": "2.0",
            "required": false,
            "index": 4,
            "prompt": "定位前裁剪结果的缩放比例，不改变结果目标大小，其他同缩放比例1。"
        },
        {
            "name": "阈值1",
            "agName": "threshold1",
            "value": "",
            "validate": "",
            "defaultValue": "5",
            "required": false,
            "index": 5,
            "prompt": "Canny边缘检测的低阈值，单位是强度，范围由0到最大强度（整数）。"
        },
        {
            "name": "阈值2",
            "agName": "threshold2",
            "value": "",
            "validate": "",
            "defaultValue": "15",
            "required": false,
            "index": 6,
            "prompt": "Canny边缘检测的高阈值，其他同阈值1。"
        },
        {
            "name": "阈值处理比例",
            "agName": "percent",
            "value": "",
            "validate": "",
            "defaultValue": "0.99",
            "required": false,
            "index": 7,
            "prompt": "按百分比进行阈值处理的比例，大于0小于1的浮点数，在合理范围内越大则可能去除更多干扰。"
        },
        {
            "name": "输出宽度",
            "agName": "pic_width",
            "value": "",
            "validate": "",
            "defaultValue": "9.0",
            "required": false,
            "index": 8,
            "prompt": "输出图像宽度与DPI之比，大于0的浮点数，影响结果分辨率。"
        },
        {
            "name": "输出高度",
            "agName": "pic_height",
            "value": "",
            "validate": "",
            "defaultValue": "9.0",
            "required": false,
            "index": 9,
            "prompt": "输出图像的高度与DPI之比，其他同输出宽度。"
        },
        {
          "name": "DPI",
          "agName": "pic_dpi",
          "value": "",
          "validate": "",
          "defaultValue": "150",
          "required": false,
          "index": 10,
          "prompt": "输出图像的DPI，大于0的整数，同样影响输出结果的分辨率。"
        },
        {
            "name": "格式",
            "agName": "pic_type",
            "value": "",
            "validate": "",
            "defaultValue": ".png",
            "required": false,
            "index": 11,
            "prompt": "输出图像的格式，默认为png格式。"
        }
     ]',
	 '异源图像匹配定位算法配置', 0 );