Testing Setups

We used three different testing scenarios to evaluate our platform: SafeSpark-SGX, SafeSpark-OPE, and SafeSpark-DET.
Below, you can see how we protected the TPC-DS data columns for each secure setup.
  • All
  • Catalog Returns
  • Catalog Sales
  • Customer Address
  • Customer
  • Customer Demographics
  • Date_Dim
  • Household Demographics
  • Inventory
  • Item
  • Store Returns
  • Store Sales
  • Store
  • Warehouse
  • Web Sales
Data Column SafeSpark-SGX SafeSpark-OPE SafeSpark-DET
cr_returned_date_sk SGX DET DET
cr_returned_time_sk SGX DET DET
cr_item_sk SGX DET DET
cr_refunded_customer_sk SGX DET DET
cr_refunded_cdemo_sk SGX DET DET
cr_refunded_hdemo_sk SGX DET DET
cr_refunded_addr_sk SGX DET DET
cr_returning_cdemo_sk SGX DET DET
cr_returning_hdemo_sk SGX DET DET
cr_returning_addr_sk SGX DET DET
cr_call_center_sk SGX DET DET
cr_catalog_page_sk SGX DET DET
cr_ship_mode_sk SGX DET DET
cr_warehouse_sk SGX DET DET
cr_reason_sk SGX DET DET
cr_order_number SGX DET DET
cr_refunded_cash SGX SGX SGX
default STD STD STD
Data Column SafeSpark-SGX SafeSpark-OPE SafeSpark-DET
cs_sold_date_sk SGX DET DET
cs_sold_time_sk SGX DET DET
cs_ship_date_sk SGX DET DET
cs_bill_customer_sk SGX DET DET
cs_bill_cdemo_sk SGX DET DET
cs_bill_hdemo_sk SGX DET DET
cs_bill_addr_sk SGX DET DET
cs_ship_customer_sk SGX DET DET
cs_ship_cdemo_sk SGX DET DET
cs_ship_hdemo_sk SGX DET DET
cs_ship_addr_sk SGX DET DET
cs_call_center_sk SGX DET DET
cs_catalog_page_sk SGX DET DET
cs_ship_mode_sk SGX DET DET
cs_warehouse_sk SGX DET DET
cs_item_sk SGX DET DET
cs_promo_sk SGX DET DET
cs_order_number SGX DET DET
cs_sales_price SGX SGX SGX
Default STD STD STD
Data Column SafeSpark-SGX SafeSpark-OPE SafeSpark-DET
ca_address_sk DET & SGX DET DET
ca_address_id SGX DET DET
ca_city OPE & SGX OPE & STD DET
ca_county OPE & SGX OPE & STD DET
ca_state SGX DET DET
ca_zip SGX DET DET
ca_country SGX SGX SGX
Default STD STD STD
Data Column SafeSpark-SGX SafeSpark-OPE SafeSpark-DET
c_current_cdemo_sk SGX SGX SGX
c_current_hdemo_sk SGX SGX SGX
c_current_addr_sk SGX SGX SGX
c_first_shipto_date_sk SGX SGX SGX
c_first_sales_date_sk SGX SGX SGX
c_first_name OPE & SGX OPE & SGX OPE & DET
c_last_name OPE & SGX OPE & SGX OPE & DET
c_birth_day SGX SGX SGX
c_birth_country SGX SGX SGX
Default STD STD STD
Data Column SafeSpark-SGX SafeSpark-OPE SafeSpark-DET
cd_demo_sk SGX DET DET
cd_gender SGX DET DET
cd_marital_status SGX DET DET
cd_education_status SGX DET DET
Default STD STD STD
Data Column SafeSpark-SGX SafeSpark-OPE SafeSpark-DET
d_date_sk DET & SGX DET DET
d_date_id SGX DET DET
d_date SGX SGX SGX
d_month_seq SGX SGX SGX
d_year OPE & SGX OPE & SGX OPE & SGX
d_dow SGX DET DET
d_dom OPE OPE OPE
d_qoy DET DET DET
Default STD STD STD
Data Column SafeSpark-SGX SafeSpark-OPE SafeSpark-DET
hd_demo_sk SGX DET DET
hd_income_band_sk SGX DET DET
hd_buy_potential SGX DET DET
hd_dep_count SGX SGX SGX
hd_vehicle_count SGX SGX SGX
Default STD STD STD
Data Column SafeSpark-SGX SafeSpark-OPE SafeSpark-DET
inv_date_sk SGX DET DET
inv_item_sk DET & SGX SGX DET
inv_warehouse_sk SGX DET DET
inv_quantity_on_hand OPE & SGX OPE OPE
Default SGX SGX SGX
Data Column SafeSpark-SGX SafeSpark-OPE SafeSpark-DET
i_item_sk SGX DET DET
i_item_id OPE & SGX OPE & STD OPE & DET
i_item_desc DET & SGX DET DET
i_current_price OPE & SGX OPE & SGX OPE & SGX
i_brand_id SGX DET DET
i_class_id SGX DET DET
i_category_id SGX DET DET
i_manufact_id SGX DET DET
i_manufact SGX DET DET
i_size SGX DET DET
i_color DET & SGX DET DET
i_units DET & SGX DET DET
i_manager_id DET & SGX DET DET
Default STD STD STD
Data Column SafeSpark-SGX SafeSpark-OPE SafeSpark-DET
sr_returned_date_sk SGX DET DET
sr_return_time_sk SGX DET DET
sr_item_sk SGX DET DET
sr_customer_sk SGX DET DET
sr_cdemo_sk SGX DET DET
sr_hdemo_sk SGX DET DET
sr_addr_sk SGX DET DET
sr_store_sk SGX DET DET
sr_reason_sk SGX DET DET
sr_ticket_number SGX OPE OPE & DET
Default STD STD STD
Data Column SafeSpark-SGX SafeSpark-OPE SafeSpark-DET
ss_sold_date_sk SGX DET DET
ss_sold_time_sk DET DET DET
ss_item_sk DET DET DET
ss_customer_sk DET DET DET
ss_cdemo_sk SGX DET DET
ss_hdemo_sk SGX DET DET
ss_addr_sk DET DET DET
ss_store_sk SGX DET DET
ss_promo_sk DET DET DET
ss_ticket_number OPE OPE OPE & DET
ss_quantity SGX SGX SGX
ss_list_price SGX SGX SGX
ss_sales_price SGX SGX SGX
ss_ext_sales_price SGX SGX SGX
ss_coupon_amt SGX SGX SGX
ss_net_paid SGX SGX SGX
ss_net_profit SGX SGX SGX
Default STD STD STD
Data Column SafeSpark-SGX SafeSpark-OPE SafeSpark-DET
s_store_sk SGX DET DET
s_store_id SGX DET DET
s_rec_start_date SGX DET DET
s_rec_end_date SGX DET DET
s_closed_date_sk SGX DET DET
s_store_name OPE & SGX OPE & STD OPE & DET
s_market_id SGX DET DET
s_division_id SGX DET DET
s_company_id SGX DET DET
s_city SGX DET DET
s_county SGX DET DET
s_state OPE & SGX OPE & STD OPE & DET
s_zip SGX DET DET
Default STD STD STD
Data Column SafeSpark-SGX SafeSpark-OPE SafeSpark-DET
w_warehouse_sk SGX DET DET
w_warehouse_id SGX DET DET
w_state OPE & SGX OPE & SGX OPE & DET
Default STD STD STD
Data Column SafeSpark-SGX SafeSpark-OPE SafeSpark-DET
ws_sold_date_sk SGX DET DET
ws_sold_time_sk SGX DET DET
ws_ship_date_sk SGX DET DET
ws_item_sk SGX DET DET
ws_bill_customer_sk SGX DET DET
ws_bill_cdemo_sk SGX DET DET
ws_bill_hdemo_sk SGX DET DET
ws_bill_addr_sk SGX DET DET
ws_ship_customer_sk SGX DET DET
ws_ship_cdemo_sk SGX DET DET
ws_ship_hdemo_sk SGX DET DET
ws_ship_addr_sk SGX DET DET
ws_web_page_sk SGX DET DET
ws_web_site_sk SGX DET DET
ws_ship_mode_sk SGX DET DET
ws_warehouse_sk SGX DET DET
ws_promo_sk SGX DET DET
ws_ext_sales_price SGX SGX SGX
Default STD STD STD