活动类数据查询模板

最新推荐文章于 2024-07-25 11:26:35 发布
最新推荐文章于 2024-07-25 11:26:35 发布
阅读量374 收藏
点赞数
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/hyh22222/article/details/48543919
活跃用户名单
select o.b_user_id,b.address,b.display_name,b.phone,count(o.b_user_id) as c from TP_ORDER o INNER JOIN TP_BUYER b on 
o.b_user_id = b.user_id where o.order_dt between str_to_date('2015-07-15','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-07','%Y-%m-%d %H:%i:%s') and o.`status` not in (0,6,7,8) and GROUP BY o.b_user_id ORDER BY c desc limit 50

新用户名单
select o.b_user_id,b.address,b.display_name,b.phone,count(o.b_user_id) as c from TP_ORDER o INNER JOIN TP_BUYER b on 
o.b_user_id = b.user_id where b.createTime between str_to_date('2015-07-15','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-07','%Y-%m-%d %H:%i:%s') and o.`status` not in (0,6,7,8) and GROUP BY o.b_user_id ORDER BY c desc limit 50

新注册用户
select count(*) from TP_BUYER b
where b.createdTime between str_to_date('2015-08-05','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-07','%Y-%m-%d %H:%i:%s') 

新增下单用户数
select count(DISTINCT o.b_user_id) from TP_ORDER o INNER JOIN TP_BUYER b on o.b_user_id = b.user_id
where o.order_dt between
str_to_date('2015-08-09','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-11','%Y-%m-%d %H:%i:%s')  and
b.createdTime between str_to_date('2015-08-09','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-11','%Y-%m-%d %H:%i:%s')  and o.`status` not in (0,6,7,8)

 下单数
select count(*) from TP_ORDER o
where o.order_dt between
str_to_date('2015-08-05','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-07','%Y-%m-%d %H:%i:%s')  and o.`status` not in (0,6,7,8)

品类数据
select COUNT(DISTINCT o.order_id) as sum  from TP_ORDER o 
where
o.order_id in (select d.order_id as order_id from TP_ORDER_PROD d INNER JOIN TP_PROD pd on d.prod_id = pd.id
where pd.fcategory_id in (1) ) and 
 o.order_dt between str_to_date('2015-08-05','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-07','%Y-%m-%d %H:%i:%s') and o.`status` not in (0,6,7,8)

品类区分新注册用户
select COUNT(DISTINCT o.order_id) as sum  from TP_ORDER o  INNER JOIN TP_BUYER b on o.b_user_id = b.user_id
where
o.order_id in (select d.order_id as order_id from TP_ORDER_PROD d INNER JOIN TP_PROD pd on d.prod_id = pd.id
where pd.fcategory_id in (1989,5,6) ) and
 o.order_dt between str_to_date('2015-08-02','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-09','%Y-%m-%d %H:%i:%s') and o.`status` not in (0,6,7,8)  and
b.createdTime between str_to_date('2015-07-26','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-02','%Y-%m-%d %H:%i:%s') 

品类订单金额数据
select SUM(d.prod_num*d.prod_price)  from TP_ORDER_PROD d INNER JOIN TP_ORDER o on d.order_id = o.order_id 
INNER JOIN TP_PROD pd on d.prod_id = pd.id 
 where pd.fcategory_id in (1) and
 o.order_dt between str_to_date('2015-08-02','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-09','%Y-%m-%d %H:%i:%s') and o.`status` not in (0,6,7,8)

当周活跃用户数
select count(*) from (select DISTINCT o.b_user_id,count(o.order_id) as sum from TP_ORDER o 
where o.order_dt between
str_to_date('2015-08-02','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-09','%Y-%m-%d %H:%i:%s')  and `status` not in (0,6,7,8) GROUP BY o.b_user_id ) ss where ss.sum>1

上周活跃在本周继续活跃用户数量
select count(DISTINCT oo.b_user_id) from TP_ORDER oo  
where oo.b_user_id in (
select ss.b_user_id from (select DISTINCT o.b_user_id,count(o.order_id) as sum from TP_ORDER o 
where o.order_dt between
str_to_date('2015-07-26','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-02','%Y-%m-%d %H:%i:%s')  and o.`status` not in (0,6,7,8) GROUP BY o.b_user_id ) ss where ss.sum>1 )
and oo.order_dt between
str_to_date('2015-08-02','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-09','%Y-%m-%d %H:%i:%s')  and oo.`status` not in (0,6,7,8)

上周新用户在上周未下单 但是本周下单数量
select count(DISTINCT oo.b_user_id) from TP_ORDER oo INNER JOIN TP_BUYER b on oo.b_user_id = b.user_id 
where oo.b_user_id not in (
select o.b_user_id from TP_ORDER o where o.order_dt between
str_to_date('2015-08-02','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-09','%Y-%m-%d %H:%i:%s')  and o.`status` not in (0,6,7,8)
) 
and oo.order_dt between
str_to_date('2015-08-09','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-16','%Y-%m-%d %H:%i:%s')  and oo.`status` not in (0,6,7,8) and 
b.createdTime between str_to_date('2015-08-02','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-09','%Y-%m-%d %H:%i:%s')

上周活跃本周无下单的用户数
select count(DISTINCT oo.user_id) from TP_BUYER oo  
where oo.user_id in (
select ss.b_user_id from (select DISTINCT o.b_user_id,count(o.order_id) as sum from TP_ORDER o
where o.order_dt between
str_to_date('2015-08-02','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-09','%Y-%m-%d %H:%i:%s')  and o.`status` not in (0,6,7,8) GROUP BY o.b_user_id ) ss where ss.sum>1 )
and oo.user_id not in (
select o.b_user_id from TP_ORDER o where o.order_dt between
str_to_date('2015-08-09','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-16','%Y-%m-%d %H:%i:%s')  and o.`status` not in (0,6,7,8)
)


肉类下单用户名单
select o.b_user_id,COUNT(DISTINCT o.order_id) as sum,b.display_name,b.phone,o.recevier_name,o.address 
from TP_ORDER o INNER JOIN TP_BUYER b on o.b_user_id = b.user_id  
where
o.order_id in (select d.order_id as order_id from TP_ORDER_PROD d INNER JOIN TP_PROD pd on d.prod_id = pd.id
where pd.fcategory_id in (2) ) and
 o.order_dt between str_to_date('2015-08-02','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-09','%Y-%m-%d %H:%i:%s') and o.`status` not in (0,6,7,8) group by o.b_user_id ORDER BY sum desc

在线支付用户名单
select o.b_user_id,COUNT(DISTINCT o.order_id) as sum,b.display_name,b.phone,o.recevier_name,o.address 
from TP_ORDER o INNER JOIN TP_BUYER b on o.b_user_id = b.user_id  
where
 o.order_dt between str_to_date('2015-08-02','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-09','%Y-%m-%d %H:%i:%s') and o.`status` not in (0,6,7,8) 
and o.pay_type = 0
group by o.b_user_id ORDER BY sum desc

新注册用户名单
select b.user_id,b.display_name,b.phone,b.shop_name,b.createdTime,cc.display_name  
from TP_BUYER b 
LEFT JOIN (select c.user_id,c.marketer_id,m.login_name,m.display_name from TP_CRM_CUSTOMER c
INNER JOIN TP_USER m on c.marketer_id = m.user_id where c.del=0 ) cc on b.user_id = cc.user_id
where 
 b.createdTime between str_to_date('2015-08-02','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-09','%Y-%m-%d %H:%i:%s')

销售补贴金额
select cc.marketer_id,cc.display_name,o.order_id,o.order_dt,o.b_user_id,b.display_name as aname,
o.mny,o.pay_type,o.coupon_mny 
  from TP_ORDER o 
INNER JOIN TP_BUYER b on o.b_user_id = b.user_id 
INNER JOIN (select c.user_id,c.marketer_id,m.login_name,m.display_name,c.buyer_category from TP_CRM_CUSTOMER c
INNER JOIN TP_USER m on c.marketer_id = m.user_id where c.del=0 and c.user_type = 1) cc on o.b_user_id = cc.user_id 
where
 o.order_dt between str_to_date('2015-08-05','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-11','%Y-%m-%d %H:%i:%s') and o.`status` not in (0,6,7,8) 

销售按品类补贴金额
select cc.marketer_id,cc.display_name,sum(o.mny),sum(o.coupon_mny) 
  from TP_ORDER o 
INNER JOIN TP_BUYER b on o.b_user_id = b.user_id 
INNER JOIN (select c.user_id,c.marketer_id,m.login_name,m.display_name,c.buyer_category from TP_CRM_CUSTOMER c
INNER JOIN TP_USER m on c.marketer_id = m.user_id where c.del=0 and c.user_type = 1) cc on o.b_user_id = cc.user_id 
where o.order_id in (select d.order_id as order_id from TP_ORDER_PROD d INNER JOIN TP_PROD pd on d.prod_id = pd.id
where pd.fcategory_id in (1989,5,6) ) and  
 o.order_dt between str_to_date('2015-08-05','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-11','%Y-%m-%d %H:%i:%s') and o.`status` not in (0,6,7,8) group by cc.marketer_id order by cc.marketer_id 


流失用户名单
select * from TP_BUYER oo  
where oo.user_id in (
select ss.b_user_id from (select DISTINCT o.b_user_id,count(o.order_id) as sum from TP_ORDER o
where o.order_dt between
str_to_date('2015-07-01','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-01','%Y-%m-%d %H:%i:%s')  and o.`status` not in (0,6,7,8) GROUP BY o.b_user_id ) ss where ss.sum>4 )
and oo.user_id NOT in (
select o.b_user_id from TP_ORDER o
where o.order_dt between
str_to_date('2015-08-01','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-13','%Y-%m-%d %H:%i:%s')  and o.`status` not in (0,6,7,8) )


买家订单名单
select o.order_id,b.user_id,cc.display_name,o.recevier_name,b.display_name,b.phone,o.address,o.order_dt   
from TP_ORDER o INNER JOIN TP_BUYER b on o.b_user_id = b.user_id 
INNER JOIN TP_BUY_ADDR d on b.user_id = d.user_id 
LEFT JOIN (select c.user_id,c.marketer_id,m.login_name,m.display_name from TP_CRM_CUSTOMER c
INNER JOIN TP_USER m on c.marketer_id = m.user_id where c.del=0 ) cc on b.user_id = cc.user_id
where
 o.order_dt between str_to_date('2015-08-01','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-13','%Y-%m-%d %H:%i:%s') and o.status not in (0,6,7,8)


买家订单
SELECT o.b_user_id,sum(o.mny),count(o.order_id),b.display_name,b.phone,MAX(o.order_dt),ad.address,o.s_user_id    
FROM TP_ORDER o INNER JOIN TP_BUYER b on o.b_user_id = b.user_id 
INNER JOIN TP_BUY_ADDR ad on o.b_user_id = ad.user_id 
where o.s_user_id = 219  
and o.order_dt between
str_to_date('2015-07-01','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-14','%Y-%m-%d %H:%i:%s')  and o.`status` not in (0,6,7,8) GROUP BY o.b_user_id



SELECT o.b_user_id,sum(o.mny),count(o.order_id),b.display_name,b.phone,MAX(o.order_dt),ad.address,o.s_user_id    
FROM TP_ORDER o INNER JOIN TP_BUYER b on o.b_user_id = b.user_id 
INNER JOIN TP_SALER s on s.user_id = o.s_user_id 
INNER JOIN TP_BUY_ADDR ad on o.b_user_id = ad.user_id
where o.b_user_id in (10311,10337,10362,10368,10378,10386,10388,
10418,10425,10439,10443,10357,10302,10300,10299,10290,10284,10268,10245,10194,10172,10135
)
and o.order_dt between
str_to_date('2015-07-01','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-15','%Y-%m-%d %H:%i:%s')  and o.`status` not in (0,6,7,8) GROUP BY o.b_user_id  
order by o.b_user_id desc


select * from TP_BUYER oo  INNER JOIN TP_BUY_ADDR ad on ad.user_id = oo.user_id 
INNER JOIN (select c.user_id,c.marketer_id,m.login_name,m.display_name,c.buyer_category from TP_CRM_CUSTOMER c
INNER JOIN TP_USER m on c.marketer_id = m.user_id where c.del=0 and c.user_type = 1 and c.marketer_id = 7) cc 
on oo.user_id = cc.user_id 
where oo.user_id in (
select ss.b_user_id from (select DISTINCT o.b_user_id,count(o.order_id) as sum from TP_ORDER o
where o.order_dt between
str_to_date('2015-06-01','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-15','%Y-%m-%d %H:%i:%s')  and o.`status` not in (0,6,7,8) GROUP BY o.b_user_id ) ss where ss.sum>0 ) 


生鲜类下单
select count(DISTINCT p.order_id) from TP_ORDER_PROD p INNER JOIN TP_PROD d on p.prod_id = d.id INNER JOIN TP_ORDER o on o.order_id = p.order_id 
INNER JOIN (select c.user_id,c.marketer_id,m.login_name,m.display_name,c.buyer_category from TP_CRM_CUSTOMER c
INNER JOIN TP_USER m on c.marketer_id = m.user_id where c.del=0 and c.user_type = 1 and c.marketer_id = 37) cc
on o.b_user_id = cc.user_id 
where d.fcategory_id in (1,2) and 
o.order_dt between
str_to_date('2015-08-01','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-15','%Y-%m-%d %H:%i:%s')  and o.`status` not in (0,6,7,8) 


下单大于5次的某个班客户数据
select * from TP_BUYER oo  INNER JOIN TP_BUY_ADDR ad on ad.user_id = oo.user_id
INNER JOIN (select c.user_id,c.marketer_id,m.login_name,m.display_name,c.buyer_category from TP_CRM_CUSTOMER c
INNER JOIN TP_USER m on c.marketer_id = m.user_id where c.del=0 and c.user_type = 1 and c.marketer_id 
in (3,4,48,130,144,155,160,163) ) cc
on oo.user_id = cc.user_id
where oo.user_id in (
select ss.b_user_id from (select DISTINCT o.b_user_id,count(o.order_id) as sum from TP_ORDER o
where o.order_dt between
str_to_date('2015-07-01','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-19','%Y-%m-%d %H:%i:%s')  and o.`status` not in (0,6,7,8) GROUP BY o.b_user_id ) ss where ss.sum>4 ) 
GROUP BY oo.user_id

下给某个卖家在某段时间以后无下单的用户
select DISTINCT o.b_user_id,MAX(o.order_dt),b.display_name,b.address,b.phone,cc.display_name,ad.address from TP_ORDER o 
INNER JOIN TP_BUYER b on o.b_user_id = b.user_id 
LEFT JOIN TP_BUY_ADDR ad on o.b_user_id = ad.user_id 
LEFT JOIN  (select c.user_id,c.marketer_id,m.login_name,m.display_name,c.buyer_category from TP_CRM_CUSTOMER c
INNER JOIN TP_USER m on c.marketer_id = m.user_id where c.del=0 and c.user_type = 1  ) cc
on o.b_user_id = cc.user_id 
where s_user_id in (167,179,279,469,245,493,255,37,40,41,42,44,125,36,158,227,687,126,48,728,32,33,34,35,38,43,45,39) 
AND b_user_id NOT IN (SELECT oo.b_user_id FROM TP_ORDER oo where oo.order_dt between
str_to_date('2015-07-15','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-21','%Y-%m-%d %H:%i:%s') ) GROUP BY o.b_user_id

卖家接单数
select o.s_user_id,s.display_name,count(o.order_id) from TP_ORDER o INNER JOIN TP_SALER s on o.s_user_id = s.user_id 
where o.order_dt between
str_to_date('2015-08-16','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-23','%Y-%m-%d %H:%i:%s') and o.`status` not in (6,7,8) GROUP BY o.s_user_id 


select o.s_user_id,s.display_name,count(o.order_id),s.category from TP_ORDER o INNER JOIN TP_SALER s on o.s_user_id = s.user_id 
where o.s_user_id in (select user_id from TP_SALE_CID c where c.cid in (3,4,5,6,1988,1989)) and 
o.order_dt between
str_to_date('2015-08-16','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-23','%Y-%m-%d %H:%i:%s') and o.`status` not in (6,7,8) GROUP BY o.s_user_id 


按品类查卖家
select sum(d.prod_num*d.prod_price)  from TP_ORDER_PROD d INNER JOIN TP_ORDER o on d.order_id = o.order_id
INNER JOIN TP_PROD pd on d.prod_id = pd.id
 where pd.fcategory_id in (1) and
 o.order_dt between str_to_date('2015-08-23','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-30','%Y-%m-%d %H:%i:%s') and o.`status` not in (0,6,7,8)

区分新增
select o.s_user_id,count(d.order_id) AS summ from TP_ORDER_PROD d INNER JOIN TP_ORDER o on d.order_id = o.order_id 
INNER JOIN TP_PROD pd on d.prod_id = pd.id 
INNER JOIN TP_SALER s on s.user_id = o.s_user_id 
 where pd.fcategory_id in (1989,5,6) and
 o.order_dt between str_to_date('2015-08-23','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-30','%Y-%m-%d %H:%i:%s') and o.`status` not in (0,6,7,8) 
and s.createdTime between
str_to_date('2015-08-23','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-30','%Y-%m-%d %H:%i:%s') 
GROUP BY o.s_user_id ORDER BY summ desc


select DISTINCT s.user_id  from TP_ORDER_PROD d INNER JOIN TP_ORDER o on d.order_id = o.order_id
INNER JOIN TP_PROD pd on d.prod_id = pd.id 
INNER JOIN TP_SALER s on o.s_user_id = s.user_id 
 where pd.fcategory_id in (1989,5,6) and
 o.order_dt between str_to_date('2015-08-16','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-23','%Y-%m-%d %H:%i:%s') and o.`status` not in (0,6,7,8) 
and o.s_user_id not in (select oo.s_user_id from TP_ORDER oo where oo.order_dt 
between str_to_date('2015-08-23','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-08-30','%Y-%m-%d %H:%i:%s'))


卖家有交易的数量
select count(DISTINCT o.s_user_id) from TP_ORDER o WHERE  o.order_dt between str_to_date('2015-08-30','%Y-%m-%d %H:%i:%s') and
   str_to_date('2015-09-06','%Y-%m-%d %H:%i:%s') and o.`status` not in (0,6,7,8)
数据统计查询系统网站模板
04-02
数据统计查询系统网站模板
高级查询示例数据库
11-13
这个是今天要用的数据库，是mdf格式的。大家可以下载练习一下
数据查询基础模板
weixin_34001430的博客
10-07 203
    /// <summary>     /// 数据查询业务逻辑基础类     /// </summary>     /// <typeparam name="T">条件类型</typeparam>     /// <typeparam name="E">实体对象类型</typeparam>
SQL常用查询模板（个人在公司最常用的）
micleng的博客
01-20 8709
sql server t-sql高级查询 新增字段： alter table [表名] add [字段名] nvarchar (50) null alter table [表名] alter column [字段名] varchar(100) not null --删除字段： alter table [表名] drop column [字段名] --修改字段： alte...
jsp单页面数据库查询模板:支持分页、排序、简单搜索、设置每页显示页数功能
cetinlo的博客
06-02 2983
show.jsp（显示页面） [java] view plain copy  print? @page import="java.sql.ResultSet"%>   @page import="java.sql.PreparedStatement"%>   @page import="analysis.JDBCUtils"%>   @page im
十万字数据结构笔记
少说，多做。
03-26 5万+
上次发操作系统笔记，很快浏览上万，这次数据结构比上次硬核的多哦，同样的会发超硬核代码，关注吧。
数据安全管理之分类分级
武天旭的博客
06-06 4199
数据分类分级是为了加强企业对数据的安全管理而对数据进行类别划分与级别划分的一种管理措施。它是数据安全管理的关键部分，是建立统一、完善、准确的数据安全架构的基础。同时也是一个理论上很简单，但实际操作起来非常复杂的事情，本文主要介绍数据分类分级的实践。单从数据分类分级工作本身来说，其在数据安全管理中产生的价值并不大，它的真正价值在于将数据分类分级的结果输入给其他安全管理平台，其他安全管理平台就可以根据分类分级的结果，对不同类别、不同级别数据实施不同的安全管理措施，从而开展差异化的数据安全管理。
金融数据安全分类分级解决方案
数据安全学习分享
04-02 7151
《数据安全法》的第二十一条“国家建立数据分类分级保护制度，根据数据在经济社会发展中的重要程度，以及一旦遭到篡改、破坏、泄露或者非法获取、非法利用，对国家安全、公共利益或者个人、组织合法权益造成的危害程度，对数据实行分类分级保护”。...
html实现酷炫美观的可视化大屏(十种风格示例，附源码)
热门推荐
优快云博客专家，系统架构师，有合作、疑惑请私信博主。
07-25 20万+
html实现酷炫美观的可视化大屏(十种风格示例，附源码)，大屏源码，可视化大屏模板源码，html可视化大屏源码下载，内含十种不同风格的大屏可视化代码，详细的讲解，酷炫的线条，美观的设计，让图文图表结合的更融洽。兼容各种大屏，调整页面到合适的分辨率，F12全屏观看。各种风格都有，代码上手简单，代码独立，可以直接使用。也可直接预览效果。
数据安全风险评估报告模板
12-16
- **数据处理活动风险**：揭示在数据处理过程中存在的安全问题。 - **平台自身数据安全风险**：评估系统的安全性，包括硬件、软件和配置。 报告的其他部分可能还包括风险优先级排序、风险缓解计划、推荐的改进...
Discuz x3.x 迪恩 Kids育儿亲子母婴商业版门户类整站带演示数据+模板 GBK.zip
12-03
迪恩 Kids育儿亲子母婴商业版门户类整站是一款专为育儿、亲子和母婴行业设计的网站系统，它基于知名的社区论坛软件Discuz x3.x进行开发，集成了丰富的功能和精美模板，旨在打造一个全面、专业且用户友好的在线平台。...
2023最新测试用例模板、缺陷报告模板、数据分析模板和案例分享
06-12
本资源包提供了2023年的最新测试用例模板、缺陷报告模板以及数据分析模板，这些工具和方法对于测试人员，特别是初入行业的新人来说，是非常有价值的参考资料。 首先，测试用例是测试活动中的一项核心文档，它详细...
淘宝店数据分析报告模板.doc
12-24
主要工作（左娜） 后台功能开发需求和新增需求 外部咨询或者调查报告的采购 组织执行相关调查统计 提出相关资料或者信息收集的方案 信息分类和分析 ----------------------- 淘宝店数据分析报告模板全文共1页，...
蓝色营销型类网站织梦手机模板（即时同步数据）.zip
10-13
蓝色营销型类网站织梦手机模板（即时同步数据）的设计初衷是为了满足企业在移动营销上的迫切需求。该模板采用了蓝色为主色调，蓝色通常与专业、可靠和信任相关联，非常适合用于打造品牌形象。模板设计采用简洁明了的...
数据库入门之常用模板汇总
lzjsqn的专栏
01-13 5967
Oracle脚本案例-- 01 创建表空间 -- 注意表空间的路径 根据实际安装环境进行调整 CREATE TABLESPACE ts_myscott01 LOGGING DATAFILE '/home/oracle/ts_myscott01.dbf' SIZE 10M EXTENT MANAGEMENT LOCAL;CREATE TABLESPACE ts_mysco
mysql部分常用函数DATE_FORMAT(a.Created_time,'%Y-%m-%d%H
NCTU_to_prove_safety的博客
05-27 3万+
mysql部分常用函数 　　DATE_FORMAT(a.Created_time,'%Y-%m-%d %H:%i:%S') as c_time 　　有人告诉说1代表的是索引字段，和数组一样，1的话就是第二个字段带索引！那统计这个字段count(1)比count(*)快！如果不带索引，那么count(*)比count(1)快！？ 　　DATE_FORMAT(max(b.time),
最全的数据查询网站
爱上统计学
12-05 5万+
1、国家数据——主要用户：社会情况研究人员 国家统计局开设网站，公布我国各个领域的宏观经济情况，权威度高 2、中国裁判文书网——主要用户：法律从业/学习/爱好者 中国最高人民法院开设，权威可信，可用于查询国内裁判文书，可作数据统计来源 3、中国互联网数据平台——主要用户：互联网研究人员 经国家主管部门批准组建的管理和服务机构，经常发布一些有价值的互联网信息报告 4、中国信通院——主要用户：互...
优化算法基于四则运算的算术优化算法原理与Python实现：面向图像分割的全局寻优方法研究
最新发布
09-06
内容概要：本文系统介绍了算术优化算法（AOA）的基本原理、核心思想及Python实现方法，并通过图像分割的实际案例展示了其应用价值。AOA是一种基于种群的元启发式算法，其核心思想来源于四则运算，利用乘除运算进行全局勘探，加减运算进行局部开发，通过数学优化器加速函数（MOA）和数学优化概率（MOP）动态控制搜索过程，在全局探索与局部开发之间实现平衡。文章详细解析了算法的初始化、勘探与开发阶段的更新策略，并提供了完整的Python代码实现，结合Rastrigin函数进行测试验证。进一步地，以Flask框架搭建前后端分离系统，将AOA应用于图像分割任务，展示了其在实际工程中的可行性与高效性。最后，通过收敛速度、寻优精度等指标评估算法性能，并提出自适应参数调整、模型优化和并行计算等改进策略。; 适合人群：具备一定Python编程基础和优化算法基础知识的高校学生、科研人员及工程技术人员，尤其适合从事人工智能、图像处理、智能优化等领域的从业者；; 使用场景及目标：①理解元启发式算法的设计思想与实现机制；②掌握AOA在函数优化、图像分割等实际问题中的建模与求解方法；③学习如何将优化算法集成到Web系统中实现工程化应用；④为算法性能评估与改进提供实践参考； 阅读建议：建议读者结合代码逐行调试，深入理解算法流程中MOA与MOP的作用机制，尝试在不同测试函数上运行算法以观察性能差异，并可进一步扩展图像分割模块，引入更复杂的预处理或后处理技术以提升分割效果。
【微信小程序源码】图文信息；欢迎页面，音乐控制.zip
09-06
资源说明： 1：本资料仅用作交流学习参考，请切勿用于商业用途。 2：一套精品实用微信小程序源码资源，无论是入门练手还是项目复用都超实用，省去重复开发时间，让开发少走弯路！ 更多精品资源请访问 https://blog.youkuaiyun.com/ashyyyy/article/details/146464041
全面指南：数据分级分类与安全管控模板
数据分级分类是指根据数据的性质、价值、使用情况和安全性要求，将数据分成不同级别和类别的一种管理活动。其目的在于为数据提供适当的保护措施，防止数据泄露、篡改和滥用，同时也帮助企业在数据管理和合规性方面...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值