태블로 vs 라플라스
trino jdbc 다운로드
jar 파일을 ~/Library/Tableau/Drivers
로 이동
포트 포워딩 후 연결
> 자세히...
에서 Presto 선택 후 연결 정보 입력ㅌ
1 | 차트 시각화 응답 속도 개선율 | (a) Tableau에서 차트 시각화 응답시간 측정 후 동일한 환경을 구성하여 (b)라플라스 애널리틱스로 응답시간 측정 → (a - b) / a 로 계산 | 30% 이상 |
---|---|---|---|
2 | 문제점 진단 엔진 처리 성능 | Tableau에서 데이터 연결 및 차트 시각화까지 걸리는 시간 대비 (b)라플라스로 데이터 연결 및 차트 시각화, 문제점 진단까지 걸리는 시간 측정 (a - b) / a 로 계산 | 30% 이상 |
시험환경 구성도, 스펙
trino spec
worker
Spec
Pre-Requisite
캡처 화면
coordinator
pod
Spec
Pre-Requisite
캡처 화면
태블로 버전
2024.3.0
웹브라우저 정보
Chrome 129.0.6668.103
테스트 컴퓨터 스펙
MacBook Pro 16
Spec
Pre-re
[측정 1]
[측정 2]
총 row 수
컬럼 스키마
show create table laplace_dashboard.laplacian_8486.commerce_order
CREATE TABLE laplace_dashboard.laplacian_8486.commerce_order (
order_id varchar,
product_order_id varchar,
used_reward double,
used_deposit double,
market_used_reward double,
market_used_deposit double,
product_price double,
option_price double,
product_id varchar,
product_name varchar,
product_name_id varchar,
option_id varchar,
option_name varchar,
category_id varchar,
category_name varchar,
qty bigint,
order_status varchar,
order_datetime_id timestamp(3) with time zone,
pay_datetime_id timestamp(3) with time zone,
confirm_datetime_id timestamp(3) with time zone,
cancel_datetime_id timestamp(3) with time zone,
exchange_datetime_id timestamp(3) with time zone,
return_datetime_id timestamp(3) with time zone,
delivery_datetime_id timestamp(3) with time zone,
delivery_start_datetime_id timestamp(3) with time zone,
device_type varchar,
pay_service_type varchar,
agent_type varchar,
inflow varchar,
pay_methods varchar,
pay_method varchar,
pay_service varchar,
member_id varchar,
buyer_phone varchar,
product_price_discount double,
coupon_discount double,
delivery_group_id varchar,
receiver_phone varchar,
user_id varchar,
delivery_fee double,
shop_discount double,
refund_datetime_id timestamp(3) with time zone,
channel_name varchar,
provider varchar,
sales double,
brand_name varchar,
currency varchar,
delivery_discount double,
postal_code varchar,
base_address varchar,
commission double,
settle_amount double,
solution_order_id varchar,
category_names varchar,
full_category_id varchar,
full_category_name varchar,
flatten_category_id varchar,
data_id bigint,
user_id_covered varchar,
row_id bigint,
customer_type varchar,
shop_type varchar,
shop_id varchar,
shop_name varchar,
product_order_price double,
customer_order_type varchar,
delivery_order_type varchar,
age_range varchar,
gender varchar,
latest_product_name varchar,
latest_option_name varchar,
claim_sales double,
claim_product_order_price double,
claim_delivery_fee double,
claim_used_reward double,
claim_used_deposit double,
claim_shop_discount double,
claim_coupon_discount double,
claim_product_price_discount double,
seller_delivery_fee double,
claim_status varchar,
refund_qty bigint,
cancel_qty bigint,
exchange_qty bigint,
return_qty bigint,
claim_qty bigint,
delivery_company_code varchar,
delivery_company_name varchar,
is_gift varchar,
custom_product_id varchar,
is_coupon_discount_order varchar,
vendor_id varchar,
vendor_name varchar,
detail_address varchar,
full_address varchar,
buyer_name varchar,
receiver_name varchar,
exg_org_order_id varchar,
exg_org_product_order_id varchar,
is_initial varchar,
is_claimed varchar,
raw_buyer_phone varchar,
raw_receiver_phone varchar,
country varchar,
state_province varchar,
city_district varchar,
town varchar,
deleted_status varchar
)
시연 1 - 라플라스
시연 1 - 태블로
시연 2 - 라플라스 (ai 요약 3회 반복)
시연 2 - 태블로 (3회 반복)