SSB基准测试-Apache Doris

最新推荐文章于 2024-05-16 15:36:57 发布
最新推荐文章于 2024-05-16 15:36:57 发布
阅读量678 收藏 2
点赞数 1
分类专栏： ssb基准测试 文章标签： apache doris
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/docsz/article/details/127573411
版权

1、SSB数据生成器

1.1、编译ssb-poc工具包

wget http://dorisdb-public.oss-cn-zhangjiakou.aliyuncs.com/ssb-poc-0.9.zip
unzip ssb-poc-0.9.zip
cd ssb-poc
make && make install
#所有相关工具安装到output目录

1.2、生成数据文件

cd output 
# 运行生成数据的脚本
bin/gen-ssb.sh 50 data_dir

1.3、Doris建表

create table if not exists `lineorder` (
  `lo_orderkey` int(11) not null comment "",
  `lo_linenumber` int(11) not null comment "",
  `lo_custkey` int(11) not null comment "",
  `lo_partkey` int(11) not null comment "",
  `lo_suppkey` int(11) not null comment "",
  `lo_orderdate` int(11) not null comment "",
  `lo_orderpriority` varchar(16) not null comment "",
  `lo_shippriority` int(11) not null comment "",
  `lo_quantity` int(11) not null comment "",
  `lo_extendedprice` int(11) not null comment "",
  `lo_ordtotalprice` int(11) not null comment "",
  `lo_discount` int(11) not null comment "",
  `lo_revenue` int(11) not null comment "",
  `lo_supplycost` int(11) not null comment "",
  `lo_tax` int(11) not null comment "",
  `lo_commitdate` int(11) not null comment "",
  `lo_shipmode` varchar(11) not null comment ""
) engine=olap
duplicate key(`lo_orderkey`)
comment "olap"
distributed by hash(`lo_orderkey`) buckets 96
properties (
"replication_num" = "1",
"colocate_with" = "group1",
"in_memory" = "false",
"storage_format" = "default"
);
  
  
create table if not exists `customer` (
  `c_custkey` int(11) not null comment "",
  `c_name` varchar(26) not null comment "",
  `c_address` varchar(41) not null comment "",
  `c_city` varchar(11) not null comment "",
  `c_nation` varchar(16) not null comment "",
  `c_region` varchar(13) not null comment "",
  `c_phone` varchar(16) not null comment "",
  `c_mktsegment` varchar(11) not null comment ""
) engine=olap
duplicate key(`c_custkey`)
comment "olap"
distributed by hash(`c_custkey`) buckets 12
properties (
"replication_num" = "1",
"colocate_with" = "groupa2",
"in_memory" = "false",
"storage_format" = "default"
);
  
  
create table if not exists `dates` (
  `d_datekey` int(11) not null comment "",
  `d_date` varchar(20) not null comment "",
  `d_dayofweek` varchar(10) not null comment "",
  `d_month` varchar(11) not null comment "",
  `d_year` int(11) not null comment "",
  `d_yearmonthnum` int(11) not null comment "",
  `d_yearmonth` varchar(9) not null comment "",
  `d_daynuminweek` int(11) not null comment "",
  `d_daynuminmonth` int(11) not null comment "",
  `d_daynuminyear` int(11) not null comment "",
  `d_monthnuminyear` int(11) not null comment "",
  `d_weeknuminyear` int(11) not null comment "",
  `d_sellingseason` varchar(14) not null comment "",
  `d_lastdayinweekfl` int(11) not null comment "",
  `d_lastdayinmonthfl` int(11) not null comment "",
  `d_holidayfl` int(11) not null comment "",
  `d_weekdayfl` int(11) not null comment ""
) engine=olap
duplicate key(`d_datekey`)
comment "olap"
distributed by hash(`d_datekey`) buckets 1
properties (
"replication_num" = "1",
"in_memory" = "false",
"colocate_with" = "groupa3",
"storage_format" = "default"
);
  
create table if not exists `supplier` (
  `s_suppkey` int(11) not null comment "",
  `s_name` varchar(26) not null comment "",
  `s_address` varchar(26) not null comment "",
  `s_city` varchar(11) not null comment "",
  `s_nation` varchar(16) not null comment "",
  `s_region` varchar(13) not null comment "",
  `s_phone` varchar(16) not null comment ""
) engine=olap
duplicate key(`s_suppkey`)
comment "olap"
distributed by hash(`s_suppkey`) buckets 12
properties (
"replication_num" = "1",
"colocate_with" = "groupa4",
"in_memory" = "false",
"storage_format" = "default"
);
  
create table if not exists `part` (
  `p_partkey` int(11) not null comment "",
  `p_name` varchar(23) not null comment "",
  `p_mfgr` varchar(7) not null comment "",
  `p_category` varchar(8) not null comment "",
  `p_brand` varchar(10) not null comment "",
  `p_color` varchar(12) not null comment "",
  `p_type` varchar(26) not null comment "",
  `p_size` int(11) not null comment "",
  `p_container` varchar(11) not null comment ""
) engine=olap
duplicate key(`p_partkey`)
comment "olap"
distributed by hash(`p_partkey`) buckets 12
properties (
"replication_num" = "1",
"colocate_with" = "groupa5",
"in_memory" = "false",
"storage_format" = "default"
);
  
create table if not exists `lineorder_flat` (
  `lo_orderkey` int(11) not null comment "",
  `lo_orderdate` date not null comment "",
  `lo_linenumber` tinyint(4) not null comment "",
  `lo_custkey` int(11) not null comment "",
  `lo_partkey` int(11) not null comment "",
  `lo_suppkey` int(11) not null comment "",
  `lo_orderpriority` varchar(100) not null comment "",
  `lo_shippriority` tinyint(4) not null comment "",
  `lo_quantity` tinyint(4) not null comment "",
  `lo_extendedprice` int(11) not null comment "",
  `lo_ordtotalprice` int(11) not null comment "",
  `lo_discount` tinyint(4) not null comment "",
  `lo_revenue` int(11) not null comment "",
  `lo_supplycost` int(11) not null comment "",
  `lo_tax` tinyint(4) not null comment "",
  `lo_commitdate` date not null comment "",
  `lo_shipmode` varchar(100) not null comment "",
  `c_name` varchar(100) not null comment "",
  `c_address` varchar(100) not null comment "",
  `c_city` varchar(100) not null comment "",
  `c_nation` varchar(100) not null comment "",
  `c_region` varchar(100) not null comment "",
  `c_phone` varchar(100) not null comment "",
  `c_mktsegment` varchar(100) not null comment "",
  `s_name` varchar(100) not null comment "",
  `s_address` varchar(100) not null comment "",
  `s_city` varchar(100) not null comment "",
  `s_nation` varchar(100) not null comment "",
  `s_region` varchar(100) not null comment "",
  `s_phone` varchar(100) not null comment "",
  `p_name` varchar(100) not null comment "",
  `p_mfgr` varchar(100) not null comment "",
  `p_category` varchar(100) not null comment "",
  `p_brand` varchar(100) not null comment "",
  `p_color` varchar(100) not null comment "",
  `p_type` varchar(100) not null comment "",
  `p_size` tinyint(4) not null comment "",
  `p_container` varchar(100) not null comment ""
) engine=olap
duplicate key(`lo_orderkey`)
comment "olap"
distributed by hash(`lo_orderkey`) buckets 192
properties (
"replication_num" = "1",
"colocate_with" = "groupxx1",
"in_memory" = "false",
"storage_format" = "default"
);

1.4、导入数据

通过stream load

curl --location-trusted -u root:Abcd*520 -H "column_separator:|" -T /data/ssb-poc/output/data_dir/customer.tbl http://192.166.111.111:8030/api/changxin/customer/_stream_load

curl --location-trusted -u root:Abcd*520 -H "column_separator:|" -T /data/ssb-poc/output/data_dir/dates.tbl http://192.166.111.111:8030/api/changxin/dates/_stream_load

curl --location-trusted -u root:Abcd*520 -H "column_separator:|" -T /data/ssb-poc/output/data_dir/part.tbl http://192.166.111.111:8030/api/changxin/part/_stream_load

curl --location-trusted -u root:Abcd*520 -H "column_separator:|" -T /data/ssb-poc/output/data_dir/supplier.tbl http://192.166.111.111:8030/api/changxin/supplier/_stream_load

curl --location-trusted -u root:Abcd*520 -H "column_separator:|" -T /data/ssb-poc/output/data_dir/lineorder.tbl.1 http://192.166.111.111:8030/api/changxin/lineorder/_stream_load

1.5、生成lineorder_flat单表数据

insert into lineorder_flat select `lo_orderkey` , `lo_orderdate` , `lo_linenumber` , `lo_custkey` , `lo_partkey` , `lo_suppkey` , `lo_orderpriotity` , `lo_shippriotity` , `lo_quantity` , `lo_extendedprice` , `lo_ordtotalprice` , `lo_discount` , `lo_revenue` , `lo_supplycost` , `lo_tax` , `lo_commitdate` , `lo_shipmode` , `c_name` , `c_address` , `c_city` , `c_nation` , `c_region` , `c_phone` , `c_mktsegment` , `s_name` , `s_address` , `s_city` , `s_nation` , `s_region` , `s_phone` , `p_name` , `p_mfgr` , `p_category` , `p_brand` , `p_color` , `p_type` , `p_size` , `p_container` from lineorder l inner join customer c on (c.c_custkey = l.lo_custkey)  inner join supplier s on (s.s_suppkey = l.lo_suppkey)  inner join part p on  (p.p_partkey = l.lo_partkey) where year(lo_orderdate) in (1992, 1993);

insert into lineorder_flat select `lo_orderkey` , `lo_orderdate` , `lo_linenumber` , `lo_custkey` , `lo_partkey` , `lo_suppkey` , `lo_orderpriotity` , `lo_shippriotity` , `lo_quantity` , `lo_extendedprice` , `lo_ordtotalprice` , `lo_discount` , `lo_revenue` , `lo_supplycost` , `lo_tax` , `lo_commitdate` , `lo_shipmode` , `c_name` , `c_address` , `c_city` , `c_nation` , `c_region` , `c_phone` , `c_mktsegment` , `s_name` , `s_address` , `s_city` , `s_nation` , `s_region` , `s_phone` , `p_name` , `p_mfgr` , `p_category` , `p_brand` , `p_color` , `p_type` , `p_size` , `p_container` from lineorder l inner join customer c on (c.c_custkey = l.lo_custkey)  inner join supplier s on (s.s_suppkey = l.lo_suppkey)  inner join part p on  (p.p_partkey = l.lo_partkey) where year(lo_orderdate) in (1994, 1995);

insert into lineorder_flat select `lo_orderkey` , `lo_orderdate` , `lo_linenumber` , `lo_custkey` , `lo_partkey` , `lo_suppkey` , `lo_orderpriotity` , `lo_shippriotity` , `lo_quantity` , `lo_extendedprice` , `lo_ordtotalprice` , `lo_discount` , `lo_revenue` , `lo_supplycost` , `lo_tax` , `lo_commitdate` , `lo_shipmode` , `c_name` , `c_address` , `c_city` , `c_nation` , `c_region` , `c_phone` , `c_mktsegment` , `s_name` , `s_address` , `s_city` , `s_nation` , `s_region` , `s_phone` , `p_name` , `p_mfgr` , `p_category` , `p_brand` , `p_color` , `p_type` , `p_size` , `p_container` from lineorder l inner join customer c on (c.c_custkey = l.lo_custkey)  inner join supplier s on (s.s_suppkey = l.lo_suppkey)  inner join part p on  (p.p_partkey = l.lo_partkey) where year(lo_orderdate) in (1996, 1997);

insert into lineorder_flat select `lo_orderkey` , `lo_orderdate` , `lo_linenumber` , `lo_custkey` , `lo_partkey` , `lo_suppkey` , `lo_orderpriotity` , `lo_shippriotity` , `lo_quantity` , `lo_extendedprice` , `lo_ordtotalprice` , `lo_discount` , `lo_revenue` , `lo_supplycost` , `lo_tax` , `lo_commitdate` , `lo_shipmode` , `c_name` , `c_address` , `c_city` , `c_nation` , `c_region` , `c_phone` , `c_mktsegment` , `s_name` , `s_address` , `s_city` , `s_nation` , `s_region` , `s_phone` , `p_name` , `p_mfgr` , `p_category` , `p_brand` , `p_color` , `p_type` , `p_size` , `p_container` from lineorder l inner join customer c on (c.c_custkey = l.lo_custkey)  inner join supplier s on (s.s_suppkey = l.lo_suppkey)  inner join part p on  (p.p_partkey = l.lo_partkey) where year(lo_orderdate) in (1998);

2、执行标准SQL-单表查询

--Q1.1
SELECT sum(LO_EXTENDEDPRICE * LO_DISCOUNT) AS revenue
FROM lineorder_flat
WHERE LO_ORDERDATE >= 19930101 and LO_ORDERDATE <= 19931231 AND LO_DISCOUNT BETWEEN 1 AND 3 AND LO_QUANTITY < 25;



--Q1.2
SELECT sum(LO_EXTENDEDPRICE * LO_DISCOUNT) AS revenue FROM lineorder_flat 
WHERE LO_ORDERDATE >= 19940101 and LO_ORDERDATE <= 19940131 AND LO_DISCOUNT 
BETWEEN 4 AND 6 AND LO_QUANTITY BETWEEN 26 AND 35;


--Q1.3
SELECT sum(LO_EXTENDEDPRICE * LO_DISCOUNT) AS revenue
FROM lineorder_flat
WHERE weekofyear(LO_ORDERDATE) = 6 AND LO_ORDERDATE >= 19940101 and LO_ORDERDATE <= 19941231
  AND LO_DISCOUNT BETWEEN 5 AND 7 AND LO_QUANTITY BETWEEN 26 AND 35;



--Q2.1
SELECT
    sum(LO_REVENUE),
    (LO_ORDERDATE DIV 10000) AS year,
    P_BRAND
FROM lineorder_flat
WHERE P_CATEGORY = 'MFGR#12' AND S_REGION = 'AMERICA'
GROUP BY
    year,
    P_BRAND
ORDER BY
    year,
    P_BRAND;



--Q2.2
SELECT
    sum(LO_REVENUE),
    (LO_ORDERDATE DIV 10000) AS year,
    P_BRAND
FROM lineorder_flat
WHERE P_BRAND >= 'MFGR#2221' AND P_BRAND <= 'MFGR#2228' AND S_REGION = 'ASIA'
GROUP BY
    year,
    P_BRAND
ORDER BY
    year,
    P_BRAND;



--Q2.3
SELECT
    sum(LO_REVENUE),
    (LO_ORDERDATE DIV 10000) AS year,
    P_BRAND
FROM lineorder_flat
WHERE P_BRAND = 'MFGR#2239' AND S_REGION = 'EUROPE'
GROUP BY
    year,
    P_BRAND
ORDER BY
    year,
    P_BRAND;



--Q3.1
SELECT
    C_NATION,
    S_NATION,
    (LO_ORDERDATE DIV 10000) AS year,
    sum(LO_REVENUE) AS revenue
FROM lineorder_flat
WHERE C_REGION = 'ASIA' AND S_REGION = 'ASIA' AND LO_ORDERDATE  >= 19920101 AND LO_ORDERDATE   <= 19971231
GROUP BY
    C_NATION,
    S_NATION,
    year
ORDER BY
    year ASC,
    revenue DESC;



--Q3.2
SELECT
    C_CITY,
    S_CITY,
    (LO_ORDERDATE DIV 10000) AS year,
    sum(LO_REVENUE) AS revenue
FROM lineorder_flat
WHERE C_NATION = 'UNITED STATES' AND S_NATION = 'UNITED STATES' AND LO_ORDERDATE  >= 19920101 AND LO_ORDERDATE <= 19971231
GROUP BY
    C_CITY,
    S_CITY,
    year
ORDER BY
    year ASC,
    revenue DESC;



--Q3.3
SELECT
    C_CITY,
    S_CITY,
    (LO_ORDERDATE DIV 10000) AS year,
    sum(LO_REVENUE) AS revenue
FROM lineorder_flat
WHERE C_CITY in ( 'UNITED KI1' ,'UNITED KI5') AND S_CITY in ( 'UNITED KI1' ,'UNITED KI5') AND LO_ORDERDATE  >= 19920101 AND LO_ORDERDATE <= 19971231
GROUP BY
    C_CITY,
    S_CITY,
    year
ORDER BY
    year ASC,
    revenue DESC;



--Q3.4
SELECT
    C_CITY,
    S_CITY,
    (LO_ORDERDATE DIV 10000) AS year,
    sum(LO_REVENUE) AS revenue
FROM lineorder_flat
WHERE C_CITY in ('UNITED KI1', 'UNITED KI5') AND S_CITY in ( 'UNITED KI1',  'UNITED KI5') AND  LO_ORDERDATE  >= 19971201 AND LO_ORDERDATE <= 19971231
GROUP BY
    C_CITY,
    S_CITY,
    year
ORDER BY
    year ASC,
    revenue DESC;



--Q4.1
SELECT
   (LO_ORDERDATE DIV 10000) AS year,
    C_NATION,
    sum(LO_REVENUE - LO_SUPPLYCOST) AS profit
FROM lineorder_flat
WHERE C_REGION = 'AMERICA' AND S_REGION = 'AMERICA' AND P_MFGR in ( 'MFGR#1' , 'MFGR#2')
GROUP BY
    year,
    C_NATION
ORDER BY
    year ASC,
    C_NATION ASC;



--Q4.2
SELECT
   (LO_ORDERDATE DIV 10000) AS year,
    S_NATION,
    P_CATEGORY,
    sum(LO_REVENUE - LO_SUPPLYCOST) AS profit
FROM lineorder_flat
WHERE C_REGION = 'AMERICA' AND S_REGION = 'AMERICA' AND LO_ORDERDATE >= 19970101 and LO_ORDERDATE <= 19981231 AND  P_MFGR in ( 'MFGR#1' , 'MFGR#2')
GROUP BY
    year,
    S_NATION,
    P_CATEGORY
ORDER BY
    year ASC,
    S_NATION ASC,
    P_CATEGORY ASC;



--Q4.3
SELECT
    (LO_ORDERDATE DIV 10000) AS year,
    S_CITY,
    P_BRAND,
    sum(LO_REVENUE - LO_SUPPLYCOST) AS profit
FROM lineorder_flat
WHERE S_NATION = 'UNITED STATES' AND LO_ORDERDATE >= 19970101 and LO_ORDERDATE <= 19981231 AND P_CATEGORY = 'MFGR#14'
GROUP BY
    year,
    S_CITY,
    P_BRAND
ORDER BY
    year ASC,
    S_CITY ASC,
    P_BRAND ASC;

2.1、单表查询结果

在这里插入图片描述

3、执行标准SQL-多表查询

--Q1.1
select sum(lo_revenue) as revenue
from lineorder join dates on lo_orderdate = d_datekey
where d_year = 1993 and lo_discount between 1 and 3 and lo_quantity < 25;


--Q1.2
select sum(lo_revenue) as revenue
from lineorder
join dates on lo_orderdate = d_datekey
where d_yearmonthnum = 199401
and lo_discount between 4 and 6
and lo_quantity between 26 and 35;



--Q1.3
select sum(lo_revenue) as revenue
from lineorder
join dates on lo_orderdate = d_datekey
where d_weeknuminyear = 6 and d_year = 1994
and lo_discount between 5 and 7
and lo_quantity between 26 and 35;



--Q2.1
select sum(lo_revenue) as lo_revenue, d_year, p_brand
from lineorder
join dates on lo_orderdate = d_datekey
join part on lo_partkey = p_partkey
join supplier on lo_suppkey = s_suppkey
where p_category = 'MFGR#12' and s_region = 'AMERICA'
group by d_year, p_brand
order by d_year, p_brand;



--Q2.2
select sum(lo_revenue) as lo_revenue, d_year, p_brand
from lineorder
join dates on lo_orderdate = d_datekey
join part on lo_partkey = p_partkey
join supplier on lo_suppkey = s_suppkey
where p_brand between 'MFGR#2221' and 'MFGR#2228' and s_region = 'ASIA'
group by d_year, p_brand
order by d_year, p_brand;



--Q2.3
select sum(lo_revenue) as lo_revenue, d_year, p_brand
from lineorder
join dates on lo_orderdate = d_datekey
join part on lo_partkey = p_partkey
join supplier on lo_suppkey = s_suppkey
where p_brand = 'MFGR#2239' and s_region = 'EUROPE'
group by d_year, p_brand
order by d_year, p_brand;



--Q3.1
select c_nation, s_nation, d_year, sum(lo_revenue) as lo_revenue
from lineorder
join dates on lo_orderdate = d_datekey
join customer on lo_custkey = c_custkey
join supplier on lo_suppkey = s_suppkey
where c_region = 'ASIA' and s_region = 'ASIA'and d_year >= 1992 and d_year <= 1997
group by c_nation, s_nation, d_year
order by d_year asc, lo_revenue desc;



--Q3.2
select c_city, s_city, d_year, sum(lo_revenue) as lo_revenue
from lineorder
join dates on lo_orderdate = d_datekey
join customer on lo_custkey = c_custkey
join supplier on lo_suppkey = s_suppkey
where c_nation = 'UNITED STATES' and s_nation = 'UNITED STATES'
and d_year >= 1992 and d_year <= 1997
group by c_city, s_city, d_year
order by d_year asc, lo_revenue desc;



--Q3.3
select c_city, s_city, d_year, sum(lo_revenue) as lo_revenue
from lineorder
join dates on lo_orderdate = d_datekey
join customer on lo_custkey = c_custkey
join supplier on lo_suppkey = s_suppkey
where (c_city='UNITED KI1' or c_city='UNITED KI5')
and (s_city='UNITED KI1' or s_city='UNITED KI5')
and d_year >= 1992 and d_year <= 1997
group by c_city, s_city, d_year
order by d_year asc, lo_revenue desc;



--Q3.4
select c_city, s_city, d_year, sum(lo_revenue) as lo_revenue
from lineorder
join dates on lo_orderdate = d_datekey
join customer on lo_custkey = c_custkey
join supplier on lo_suppkey = s_suppkey
where (c_city='UNITED KI1' or c_city='UNITED KI5') and (s_city='UNITED KI1' or s_city='UNITED KI5') and d_yearmonth = 'Dec1997'
group by c_city, s_city, d_year
order by d_year asc, lo_revenue desc;



--Q4.1
select d_year, c_nation, sum(lo_revenue) - sum(lo_supplycost) as profit
from lineorder
join dates on lo_orderdate = d_datekey
join customer on lo_custkey = c_custkey
join supplier on lo_suppkey = s_suppkey
join part on lo_partkey = p_partkey
where c_region = 'AMERICA' and s_region = 'AMERICA' and (p_mfgr = 'MFGR#1' or p_mfgr = 'MFGR#2')
group by d_year, c_nation
order by d_year, c_nation;



--Q4.2
select d_year, s_nation, p_category, sum(lo_revenue) - sum(lo_supplycost) as profit
from lineorder
join dates on lo_orderdate = d_datekey
join customer on lo_custkey = c_custkey
join supplier on lo_suppkey = s_suppkey
join part on lo_partkey = p_partkey
where c_region = 'AMERICA'and s_region = 'AMERICA'
and (d_year = 1997 or d_year = 1998)
and (p_mfgr = 'MFGR#1' or p_mfgr = 'MFGR#2')
group by d_year, s_nation, p_category
order by d_year, s_nation, p_category;



--Q4.3
select d_year, s_city, p_brand, sum(lo_revenue) - sum(lo_supplycost) as profit
from lineorder
join dates on lo_orderdate = d_datekey
join customer on lo_custkey = c_custkey
join supplier on lo_suppkey = s_suppkey
join part on lo_partkey = p_partkey
where c_region = 'AMERICA'and s_nation = 'UNITED STATES'
and (d_year = 1997 or d_year = 1998)
and p_category = 'MFGR#14'
group by d_year, s_city, p_brand
order by d_year, s_city, p_brand;

3.1、多表查询结果

在这里插入图片描述

docsz
关注
  • 1
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
SSB系统的性能分析
05-12
调制的目的是把要传输的模拟信号或数字信号变换成适合信道传输的高频信号。按照调制器输入信号的形式，调制可分为模拟调制和数字调制。单边带调制是模拟调制中幅度调制的一种。本文介绍了单边带调制与解调的原理及其实现、已调信号的频谱特性、单边带解调器的调制度增益，并对单边带调制与双边带调制的性能进行了比较。现在移动通信系统都在使用数字调制技术，通信系统正在由模拟方式向数字方式过渡，可见模拟调制最终将逐步被数字调制所取代。
doris-ssb-tools.zip
01-07
【描述】"doris-ssb-tools.zip" 提供了在Apache Doris环境下进行SSB基准测试所需的全部工具。SSB是一个广泛使用的数据仓库性能基准，它模拟了业务智能应用中的常见查询模式。通过这个工具包，用户可以便捷地创建SSB...
SSB基准测试-模型介绍
com728871的博客
07-04 1205
SSB（Star Schema Benchmark）是麻省州立大学波士顿校区的研究人员定义的基于现实商业应用的数据模型，业界公认用来模拟决策支持类应用，比较公正和中立。学术界和工业界普遍采用它来评价决策支持技术方面应用的性能。全...
Doris【部署 02】Linux环境Doris数据库进行SSB基准测试
最新发布
Java与大数据相关实践内容分享！
05-16 1080
Linux环境Doris数据库进行SSB基准测试
大数据应用之 --- apache doris 基于ssb测试
qq_41187116的博客
07-15 997
大数据应用之 --- apache doris 基于ssb测试
SSB基准测试-ClickHouse
docsz的博客
11-03 445
SSB基准测试-ClickHouse
Clickhouse（20.4.2.9） SSB性能测试
聂雄超的博客
02-24 1583
SSB（Star Schema Benchmark）是麻省州立大学波士顿校区的研究人员定义的基于现实商业应用的数据模型，业界公认用来模拟决策支持类应用，比较公正和中立。
ssb-bot-feed：Scuttlebutt机器人，可读取RSS提要并自动发布更新
02-01
ssb-bot-feed Scuttlebutt机器人可以自动读取RSS提要并发布更新 用法 下载并运行 npm install -g ssb-bot-feed 句法： ssb-bot-feed [feed1] [feed2] [feedN] 例： ssb-bot-feed ...
SSB-Keys-Mnemonic-dotnet:NodeJS ssb-keys-mnemonic https的C＃（.NET Standard）实现
04-12
SSB按键助记符在SSB密钥和助记码之间进行转换的模块。 C＃（.NET Standard）实现用法using SSB . Keys . Mnemonic ;字符串KeysToWords（按键） var mnemonic = new MnemonicConverter ();var keys = new Keys{Curve ...
ssb-invites-db:使用ssb-invites-schema进行盾牌邀请的flumeview-reduce
05-08
ssb-invites-db 一种针对scuttle- ssb插件使用scuttle- flumeview-reduce。 允许在root记录（例如的顶部使用多态邀请/回复系统。 // Plug into a Scuttlebot server Server.use(require('ssb-invites-db')) // ...
ssb-secure-partial-replication
03-14
SSB安全部分复制 现状：设计阶段 本文档将概述转换现有SSB身份以使其准备部分复制所需的步骤。 首先，如所述，将从现有的SSB提要中生成根元。 主供稿与元供稿链接在一起，这意味着应用程序可以开始使用从元供稿链接...
详解dhcp服务器的搭建
01-27
详细讲解了如何搭建DHCP服务器，很适合初学者阅读
Apace Doris基本操作测试
程裕强的专栏
08-06 970
注：本文仅是记录操作过程 参考官方文档：https://doris.apache.org/master/zh-CN/getting-started/basic-usage.html 1、修改密码 MySQL [(none)]> SET PASSWORD FOR 'root' = PASSWORD('123456'); Query OK, 0 rows affected (0.01 sec) MySQL [(none)]> MySQL [(none)]> exit Bye [root@
tpc-ds doris性能测试
qq_44768464的博客
06-16 680
基于tpc-ds 和 doris的测试。
大数据应用之 --- aphache doris VS clickhouse 基于ssb性能比对
qq_41187116的博客
07-15 1662
大数据应用之 --- aphache doris VS clickhouse 基于ssb性能比对
根据表结构进行造数，作为测试使用
weixin_37353303的博客
01-25 245
代码和详细解释见连接：https://github.com/zwj-7/python
TPC-C 、TPC-H、TPC-DS和SSB测试基准（Benchmark）介绍
Laurence的技术博客
12-06 2767
TPC是一个非盈利组织，致力于定义事务处理和数据库benchmark，其提供了面向不同应用场景的多种Benchmark: https://www.tpc.org/information/benchmarks5.asp 下图是对几个主要的benchmark的汇总： 接下来，我们着重介绍一上最广泛讨论的四种Benchmark.面向OLTP测试，也就是测试关系型数据库的数据集。面向OLTP测试，也就是测试分析型数据库/数据仓库的数据集，业务场景是“商品零售业”。TPC-H是一款面向商品零售业的决策支持系统测试
OLAP(三)：Doris
.
08-27 1915
1.编写测试程序1,无限循环通过Spark restful API 提交任务到spark集群运行,每个任务申请worker数1个,cpu:1核,内存:1g,driver端 cpu:核,内存1g,程序只提交spark任务不进行任务读取文件和处理分析操作,申请到资源就立马释放。4.编写测试程序4,提交2个任务,第一个任务先提交并申请spark集群50%资源,然后提交第二个任务,第二个任务也要获取spark集群50%资源。4.若提交一个任务,spark集群只能满足其一部分申请,这个任务该如何进行。......
如何用iq调制实现dsb-ask和ssb-ask
11-22
DSB-ASK（Double Sideband Amplitude Shift Keying 双边带幅度调制）是一种调制方式，它将数字信号转化为两边带的调制信号传输。而SSB-ASK（Single Sideband Amplitude Shift Keying 单边带幅度调制）则是DSB-ASK的一种变种，只传输其中一边带的信号。 要实现DSB-ASK调制，可以按照以下步骤进行： 1. 将数字信号进行二进制编码，将每个数字转化为对应的基带信号。 2. 使用一个载波信号，可以选择正弦波或者余弦波作为载波。 3. 将基带信号与载波信号相乘，得到DSB-ASK调制的信号波形。 4. 可以通过增加滤波器来去除多余的频谱。 而要实现SSB-ASK调制，可以按照以下步骤进行： 1. 同样将数字信号进行二进制编码，将每个数字转化为对应的基带信号。 2. 使用一个载波信号，可以选择正弦波或者余弦波作为载波。 3. 将基带信号与载波信号相乘，得到DSB-ASK调制的信号波形。 4. 对DSB-ASK调制的信号进行带通滤波，将另外一个带通滤波器封锁。 5. 进行滤波后，得到SSB-ASK调制的信号波形。 在实际应用中，也可以利用数学软件进行模拟和实现，例如使用Matlab等工具进行DSB-ASK和SSB-ASK调制的仿真实验。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值