{"id":551,"date":"2011-03-08T10:17:37","date_gmt":"2011-03-08T15:17:37","guid":{"rendered":"http:\/\/hstore.cs.brown.edu\/"},"modified":"2012-04-17T01:01:51","modified_gmt":"2012-04-17T05:01:51","slug":"seats","status":"publish","type":"page","link":"https:\/\/hstore.cs.brown.edu\/projects\/seats\/","title":{"rendered":"The SEATS Airline Ticketing Systems Benchmark"},"content":{"rendered":"

\n

    \n
  1. \n

    Introduction<\/h2>\n

    To be written…<\/i><\/p>\n

  2. \n

    Tables<\/h2>\n

    The benchmark scales with an integer scaling parameter N. It can be set to any value of interest, though we have in mind a number between 1 and 100.<\/p>\n

      \n
    1. \n

      COUNTRY<\/h3>\n

      Read-only table of countries.<\/p>\n\n\n\n\n\n\n\n\n
      Column<\/th>\nType<\/th>\nCardinality<\/th>\nReferences<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
      CO_ID<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      CO_NAME<\/td>\nVARCHAR(64)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      CO_CODE_2<\/td>\nVARCHAR(2)<\/td>\nUNIQUE<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      CO_CODE_3<\/td>\nVARCHAR(3)<\/td>\nUNIQUE<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n

      PRIMARY KEY (CO_ID)
      \n<\/tbody>\n<\/table>\n

    2. \n

      AIRPORT<\/h3>\n

      Read-only table of airports. <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
      Column<\/th>\nType<\/th>\nCardinality<\/th>\nReferences<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
      AP_ID<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_CODE<\/td>\nVARCHAR(3)<\/td>\nUNIQUE<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_NAME<\/td>\nVARCHAR(128)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_CITY<\/td>\nVARCHAR(64)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_POSTAL_CODE<\/td>\nVARCHAR(12)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_CO_ID<\/td>\nBIGINT<\/td>\n–<\/td>\nCOUNTRY (CO_ID)<\/td>\n–<\/td>\n<\/tr>\n
      AP_LONGITUDE<\/td>\nFLOAT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_LATITUDE<\/td>\nFLOAT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_GMT_OFFSET<\/td>\nFLOAT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_WAC<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR00<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR01<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR02<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR03<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR04<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR05<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR06<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR07<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR08<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR09<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR10<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR11<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR12<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR13<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR14<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AP_IATTR15<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n

      PRIMARY KEY (AP_ID)
      \n<\/tbody>\n<\/table>\n

    3. \n

      AIRPORT_DISTANCE<\/h3>\n

      Read-only table of the distance (in miles) from each airport to all other airports.<\/p>\n\n\n\n\n\n\n\n
      Column<\/th>\nType<\/th>\nCardinality<\/th>\nReferences<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
      D_AP_ID0<\/td>\nBIGINT<\/td>\n–<\/td>\nAIRPORT (AP_ID)<\/td>\n–<\/td>\n<\/tr>\n
      D_AP_ID1<\/td>\nBIGINT<\/td>\n–<\/td>\nAIRPORT (AP_ID)<\/td>\n–<\/td>\n<\/tr>\n
      D_DISTANCE<\/td>\nFLOAT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n

      PRIMARY KEY (D_AP_ID0, D_AP_ID1)
      \n<\/tbody>\n<\/table>\n

    4. \n

      AIRLINE<\/h3>\n

      Read-only table of airlines.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
      Column<\/th>\nType<\/th>\nCardinality<\/th>\nReferences<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
      AL_ID<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATA_CODE<\/td>\nVARCHAR(3)<\/td>\nUNIQUE<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_ICAO_CODE<\/td>\nVARCHAR(3)<\/td>\nUNIQUE<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_CALL_SIGN<\/td>\nVARCHAR(32)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_NAME<\/td>\nVARCHAR(128)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_CO_ID<\/td>\nBIGINT<\/td>\n–<\/td>\nCOUNTRY (CO_ID)<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR00<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR01<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR02<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR03<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR04<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR05<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR06<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR07<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR08<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR09<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR10<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR11<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR12<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR13<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR14<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      AL_IATTR15<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n

      PRIMARY KEY (AL_ID)
      \n<\/tbody>\n<\/table>\n

    5. \n

      CUSTOMER<\/h3>\n

      A Customer table. There are N *10 **6 customers, each with an integer customer identifier (CID) and 40 fields of attribute data, e.g. name, address frequent flier number, etc.. Twenty are character strings with a length of 8 bytes and 20 are four byte integers. Hence, total record length is 244 bytes. For N = 1 this is 244 Mbytes. For larger N, do the math. CIDs can be assumed to be positive integers between 1 and N * 10 **6.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
      Column<\/th>\nType<\/th>\nCardinality<\/th>\nReferences<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
      C_ID<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_BASE_AP_ID<\/td>\nBIGINT<\/td>\n–<\/td>\nAIRPORT (AP_ID)<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR00<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR01<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR02<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR03<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR04<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR05<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR06<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR07<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR08<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR09<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR10<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR11<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR12<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR13<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR14<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR15<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR16<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR17<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR18<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_SATTR19<\/td>\nVARCHAR(8)<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR00<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR01<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR02<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR03<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR04<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR05<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR06<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR07<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR08<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR09<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR10<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR11<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR12<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR13<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR14<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR15<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR16<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR17<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR18<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      C_IATTR19<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n

      PRIMARY KEY (C_ID)
      \n<\/tbody>\n<\/table>\n

    6. \n

      FREQUENT_FLYER<\/h3>\n

      Customer frequent flyer information per airline.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
      Column<\/th>\nType<\/th>\nCardinality<\/th>\nReferences<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
      FF_C_ID<\/td>\nBIGINT<\/td>\n–<\/td>\nCUSTOMER (C_ID)<\/td>\n–<\/td>\n<\/tr>\n
      FF_AL_ID<\/td>\nBIGINT<\/td>\n–<\/td>\nAIRLINE (AL_ID)<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR00<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR01<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR02<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR03<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR04<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR05<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR06<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR07<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR08<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR09<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR10<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR11<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR12<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR13<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR14<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      FF_IATTR15<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n

      PRIMARY KEY (FF_C_ID, FF_AL_ID)
      \n<\/tbody>\n<\/table>\n

    7. \n

      FLIGHT<\/h3>\n

      A Flight table. There are N * 10 **5 flights. Each flight has a flight identifier (F_ID), an airline (AL_ID), departure airport (DEPART_AP_ID), departure time, arrival airport (ARRIVE_AP_ID), arrival time, and 30 misscellaneous data attributes. Each attribute is an integer. Total record length is XXX bytes. <\/p>\n

      Each F_ID is a 64-bit composite ID containing departure\/arrival airport ids, the flight date, and a unique identifier. This allows the benchmark driver to execute various transactions <\/p>\n\n<\/table>\n
      \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
      Column<\/th>\nType<\/th>\nCardinality<\/th>\nReferences<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
      F_ID<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_AL_ID<\/td>\nBIGINT<\/td>\n–<\/td>\nAIRLINE (AL_ID)<\/td>\n–<\/td>\n<\/tr>\n
      F_DEPART_AP_ID<\/td>\nBIGINT<\/td>\n–<\/td>\nAIRPORT (AP_ID)<\/td>\n–<\/td>\n<\/tr>\n
      F_DEPART_TIME<\/td>\nTIMESTAMP<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_ARRIVE_AP_ID<\/td>\nBIGINT<\/td>\n–<\/td>\nAIRPORT (AP_ID)<\/td>\n–<\/td>\n<\/tr>\n
      F_ARRIVE_TIME<\/td>\nTIMESTAMP<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_STATUS<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_SEATS_LEFT<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR00<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR01<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR02<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR03<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR04<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR05<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR06<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR07<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR08<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR09<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR10<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR11<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR12<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR13<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR14<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR15<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR16<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR17<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR18<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR19<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR20<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR21<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR22<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR23<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR24<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR25<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR26<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR27<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR28<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      F_IATTR29<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n

      PRIMARY KEY (F_ID)
      \n<\/tbody>\n<\/table>\n

    8. \n

      RESERVATION<\/h3>\n

      A Reservation table. Each reservation applies to a single customer and a single flight, each randomly chosen. A reservation has 10 data fields, each an integer (for example the cost of the flight and the seat chosen, if any). RIDs can also be sequence numbers.<\/p>\n

      There are sufficient reservations loaded at the start of the benchmark, so that every flight is between 60 and 100% full, with an average of 80%. Every plane is assumed to have 150 seats. Hence, there are 12M reservations. Total size of the reservation table is 624 Mbytes for N = 1. As the number of flights scales with N, so will Reservations.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
      Column<\/th>\nType<\/th>\nCardinality<\/th>\nReferences<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
      R_ID<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      R_C_ID<\/td>\nBIGINT<\/td>\n–<\/td>\nCUSTOMER (C_ID)<\/td>\n–<\/td>\n<\/tr>\n
      R_F_ID<\/td>\nBIGINT<\/td>\n–<\/td>\nFLIGHT (F_ID)<\/td>\n–<\/td>\n<\/tr>\n
      R_SEAT<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      R_IATTR00<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      R_IATTR01<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      R_IATTR02<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      R_IATTR03<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      R_IATTR04<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      R_IATTR05<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      R_IATTR06<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      R_IATTR07<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n
      R_IATTR08<\/td>\nBIGINT<\/td>\n–<\/td>\n<\/td>\n–<\/td>\n<\/tr>\n

      PRIMARY KEY (R_ID, R_C_ID)
      \n<\/tbody>\n<\/table>\n<\/ol>\n

    9. \n

      Stored Procedures<\/h2>\n
        \n
      1. \n

        ChangeSeat<\/h3>\n

        Source Code<\/a><\/p>\n

      2. \n

        FindFlightByAirport<\/h3>\n

        Source Code<\/a><\/p>\n

      3. \n

        FindFlightByNearbyAirport<\/h3>\n

        Source Code<\/a><\/p>\n

      4. \n

        FindOpenSeats<\/h3>\n

        Source Code<\/a><\/p>\n

      5. \n

        NewReservation<\/h3>\n

        Source Code<\/a><\/p>\n

      6. \n

        UpdateFrequentFlyer<\/h3>\n

        Source Code<\/a><\/p>\n

      7. \n

        UpdateReservation<\/h3>\n

        Source Code<\/a><\/p>\n<\/ol>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

        Introduction To be written… Tables The benchmark scales with an integer scaling parameter N. It can be set to any value of interest, though we have in mind a number between 1 and 100. COUNTRY Read-only table of countries. Column Type Cardinality References Description CO_ID BIGINT – – CO_NAME VARCHAR(64) – – CO_CODE_2 VARCHAR(2) UNIQUE […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":42,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/551"}],"collection":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/comments?post=551"}],"version-history":[{"count":15,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/551\/revisions"}],"predecessor-version":[{"id":1602,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/551\/revisions\/1602"}],"up":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/42"}],"wp:attachment":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/media?parent=551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}