Benchmark Dataset Reference

On this page you will learn how the data is stored in Benchmark Dataset.

Tables

Descriptions of each table and their correspondent fields are found below:

performance_(daily|weekly|monthly)_(seller|buyer)

This table contains the total of ok and nok searches, quotes, bookings and cancellation requests and responses times for the buyer|seller and for TravelgateX. The buyers|sellers that aren’t connected are aggregated in “others” for the seller case and “OTHERS” for the buyers case.

fields

  • search_date (TIMESTAMP). Search date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • client_id (STRING). Client unique ID.
  • provider_id (STRING). Provider unique ID.
  • client_owner (STRING). Organization’s name of the client.
  • provider_owner (STRING). Organization’s name of the provider.
  • search_ok (NUMBER). Quantity of searches with searchable results.
  • search_ok_tgx (NUMBER). Quantity of searches with searchable results for TravelgateX.
  • search_nok(NUMBER). Quantity of searches with errors.
  • search_nok_tgx (NUMBER). Quantity of searches with errors for TravelgateX.
  • search_time (NUMBER). Total response time (in milliseconds) for all searches.
  • search_time_tgx (NUMBER). Total response time (in milliseconds) for all searches for TravelgateX.
  • quote_ok (NUMBER). Quantity of quotes with searchable results.
  • quote_ok_tgx (NUMBER). Quantity of quotes with searchable results for TravelgateX.
  • quote_nok (NUMBER). Quantity of quotes with errors.
  • quote_nok_tgx (NUMBER). Quantity of quotes with errors for TravelgateX.
  • quote_time (NUMBER). Total response time (in milliseconds) for all quotes.
  • quote_time_tgx (NUMBER). Total response time (in milliseconds) for all quotes for TravelgateX.
  • booking_ok (NUMBER). Quantity of correct bookings.
  • booking_ok_tgx (NUMBER). Quantity of correct bookings for TravelgateX.
  • booking_nok (NUMBER). Quantity of bookings with an error.
  • booking_nok_tgx (NUMBER). Quantity of bookings with an error for TravelgateX.
  • booking_time (NUMBER. Total response time (in milliseconds) for bookings.
  • booking_time_tgx (NUMBER. Total response time (in milliseconds) for bookings for TravelgateX.
  • cancel_ok (NUMBER). Quantity of correct cancellations.
  • cancel_ok_tgx (NUMBER). Quantity of correct cancellations for TravelgateX.
  • cancel_nok (NUMBER). Quantity of cancellations with an error.
  • cancel_nok_tgx (NUMBER). Quantity of cancellations with an error for TravelgateX.
  • cancel_time (NUMBER). Total response time (in milliseconds) for cancellations.
  • cancel_time_tgx (NUMBER). Total response time (in milliseconds) for cancellations for TravelgateX.

Preview

search_date provider_id client_id provider_owner client_owner search_ok search_ok_tgx search_nok search_nok_tgx search_time search_time_tgx quote_ok quote_ok_tgx quote_nok quote_nok_tgx quote_time quote_time_tgx booking_ok booking_ok_tgx booking_nok booking_nok_tgx booking_time booking_time_tgx cancel_ok cancel_ok_tgx cancel_nok cancel_nok_tgx cancel_time cancel_time_tgx
2019-05-31 00:00:00 UTC Provider 1 Client 1 Org Name 1 Org Name 1 2739 2739 5435 5435 15143760 15143760 19 19 0 0 54151 54151 2 2 1 1 31747 31747 0 0 0 0 0 0
2019-05-31 00:00:00 UTC Provider 2 Client 2 Org Name 2 Org Name 2 22631 1079375 4964 669086 2308465 256855044 1694 7708 0 80 157269 3539127 8 18 1 1 5441 15815 1 7 0 0 625 5925
2019-05-31 00:00:00 UTC Provider 3 Client 3 Org Name 3 Org Name 3 131116 192822 68270 106039 581904466 1168506957 6386 8220 1232 1511 32997644 41012522 93 193 1 1 3468668 7259187 32 40 0 0 334721 399424

Comments