sqltablecopies

数据库测试工具Benchmark,主要对数据库的性能进行了详细的测试。

copy warehouse
  (w_id, w_ytd, w_tax, w_name, w_street_1, w_street_2, w_city, w_state, w_zip)  
  from 'c:/java/benchmarksql-2.3/run/csv/warehouse.csv' WITH CSV;

copy item
  (i_id, i_name, i_price, i_data, i_im_id) 
  from 'c:/java/benchmarksql-2.3/run/csv/item.csv' WITH CSV;

copy stock
  (s_i_id, s_w_id, s_quantity, s_ytd, s_order_cnt, s_remote_cnt, s_data,
   s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05,
   s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10)
  from 'c:/java/benchmarksql-2.3/run/csv/stock.csv' WITH CSV;

copy district
  (d_id, d_w_id, d_ytd, d_tax, d_next_o_id, d_name, d_street_1,
   d_street_2, d_city, d_state, d_zip) 
  from 'c:/java/benchmarksql-2.3/run/csv/district.csv' WITH CSV;

copy customer
  (c_id, c_d_id, c_w_id, c_discount, c_credit, c_last, c_first, c_credit_lim, 
   c_balance, c_ytd_payment, c_payment_cnt, c_delivery_cnt, c_street_1, 
   c_street_2, c_city, c_state, c_zip, c_phone) 
  from 'c:/java/benchmarksql-2.3/run/csv/customer.csv' WITH CSV;

copy history
  (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) 
  from 'c:/java/benchmarksql-2.3/run/csv/cust-hist.csv' WITH CSV;

copy oorder
  (o_id, o_w_id, o_d_id, o_c_id, o_carrier_id, o_ol_cnt, o_all_local, o_entry_d) 
  from 'c:/java/benchmarksql-2.3/run/csv/order.csv' WITH CSV;

copy order_line
  (ol_w_id, ol_d_id, ol_o_id, ol_number, ol_i_id, ol_delivery_d, 
   ol_amount, ol_supply_w_id, ol_quantity, ol_dist_info) 
  from 'c:/java/benchmarksql-2.3/run/csv/order-line.csv' WITH CSV;

copy new_order
  (no_w_id, no_d_id, no_o_id)  
  from 'c:/java/benchmarksql-2.3/run/csv/new-order.csv' WITH CSV;