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 |