perfkitbenchmarker/data/edw/tpc_profile_details.py (3,107 lines of code) (raw):

"""The order of query templates in each query stream. The order is determined by dsqgen. Details can be found at http://www.tpc.org/tpc_documents_current_versions/current_specifications.asp The order is the same for all scale factors. """ profile_dictionary = { 'tpc_ds_power': [ 96, 7, 75, 44, 39, 80, 32, 19, 25, 78, 86, 1, 91, 21, 43, 27, 94, 45, 58, 64, 36, 33, 46, 62, 16, 10, 63, 69, 60, 59, 37, 98, 85, 70, 67, 28, 81, 97, 66, 90, 17, 47, 95, 92, 3, 51, 35, 49, 9, 31, 11, 93, 29, 38, 22, 89, 15, 6, 52, 50, 42, 41, 8, 12, 20, 88, 82, 23, 14, 57, 65, 71, 34, 48, 30, 74, 87, 77, 73, 84, 54, 55, 56, 2, 26, 40, 72, 53, 79, 18, 13, 24, 4, 99, 68, 83, 61, 5, 76, ], 'tpc_ds_throughput_1': [ 83, 32, 30, 92, 66, 84, 98, 58, 16, 77, 40, 96, 13, 36, 95, 63, 99, 3, 6, 12, 28, 85, 51, 41, 27, 78, 8, 14, 50, 52, 81, 5, 26, 57, 82, 69, 54, 61, 88, 18, 94, 35, 68, 24, 75, 11, 67, 9, 25, 37, 86, 4, 60, 97, 33, 79, 43, 80, 93, 31, 47, 17, 19, 1, 64, 53, 55, 46, 21, 15, 20, 65, 70, 49, 59, 48, 72, 87, 34, 2, 38, 22, 89, 7, 10, 90, 71, 29, 73, 45, 91, 62, 44, 76, 23, 56, 42, 39, 74, ], 'tpc_ds_throughput_2': [ 56, 98, 59, 24, 88, 2, 5, 6, 27, 87, 90, 83, 91, 28, 68, 8, 76, 75, 80, 1, 69, 26, 11, 17, 63, 77, 19, 21, 31, 93, 54, 39, 10, 15, 55, 14, 38, 42, 53, 45, 99, 67, 23, 62, 30, 86, 82, 25, 16, 81, 40, 44, 50, 61, 85, 73, 95, 84, 4, 37, 35, 94, 58, 96, 12, 29, 22, 51, 36, 43, 64, 20, 57, 9, 52, 49, 71, 72, 70, 7, 97, 33, 79, 32, 78, 18, 65, 60, 34, 3, 13, 41, 92, 74, 46, 89, 47, 66, 48, ], 'tpc_ds_throughput_3': [ 89, 5, 52, 62, 53, 7, 39, 80, 63, 72, 18, 56, 13, 69, 23, 19, 74, 30, 84, 96, 14, 10, 86, 94, 8, 87, 58, 36, 37, 4, 38, 66, 78, 43, 22, 21, 97, 47, 29, 3, 76, 82, 46, 41, 59, 40, 55, 16, 27, 54, 90, 92, 31, 42, 26, 34, 68, 2, 44, 81, 67, 99, 6, 83, 1, 60, 33, 11, 28, 95, 12, 64, 15, 25, 93, 9, 65, 71, 57, 32, 61, 85, 73, 98, 77, 45, 20, 50, 70, 75, 91, 17, 24, 48, 51, 79, 35, 88, 49, ], 'tpc_ds_throughput_4': [ 79, 39, 93, 41, 29, 32, 66, 84, 8, 71, 45, 89, 91, 14, 46, 58, 48, 59, 2, 83, 21, 78, 40, 99, 19, 72, 6, 28, 81, 44, 97, 88, 77, 95, 33, 36, 61, 35, 60, 75, 74, 55, 51, 17, 52, 90, 22, 27, 63, 38, 18, 24, 37, 47, 10, 70, 23, 7, 92, 54, 82, 76, 80, 56, 96, 50, 85, 86, 69, 68, 1, 12, 43, 16, 4, 25, 20, 65, 15, 98, 42, 26, 34, 5, 87, 3, 64, 31, 57, 30, 13, 94, 62, 49, 11, 73, 67, 53, 9, ], 'tpc_ds_throughput_5': [ 73, 66, 4, 17, 60, 98, 88, 2, 19, 65, 3, 79, 13, 21, 51, 6, 49, 52, 7, 56, 36, 77, 90, 76, 58, 71, 80, 69, 54, 92, 61, 53, 87, 68, 85, 28, 42, 67, 50, 30, 48, 22, 11, 94, 93, 18, 33, 63, 8, 97, 45, 62, 81, 35, 78, 57, 46, 32, 24, 38, 55, 74, 84, 89, 83, 31, 26, 40, 14, 23, 96, 1, 95, 27, 44, 16, 64, 20, 43, 5, 47, 10, 70, 39, 72, 75, 12, 37, 15, 59, 91, 99, 41, 9, 86, 34, 82, 29, 25, ], 'tpc_ds_throughput_6': [ 34, 88, 44, 94, 50, 5, 53, 7, 58, 20, 75, 73, 91, 36, 11, 80, 9, 93, 32, 89, 28, 87, 18, 74, 6, 65, 84, 14, 38, 24, 42, 29, 72, 23, 26, 69, 47, 82, 31, 59, 49, 33, 86, 99, 4, 45, 85, 8, 19, 61, 3, 41, 54, 67, 77, 15, 51, 98, 62, 97, 22, 48, 2, 79, 56, 37, 10, 90, 21, 46, 83, 96, 68, 63, 92, 27, 12, 64, 95, 39, 35, 78, 57, 66, 71, 30, 1, 81, 43, 52, 13, 76, 17, 25, 40, 70, 55, 60, 16, ], 'tpc_ds_throughput_7': [ 70, 53, 92, 99, 31, 39, 29, 32, 6, 64, 30, 34, 13, 28, 86, 84, 25, 4, 98, 79, 69, 72, 45, 48, 80, 20, 2, 21, 97, 62, 47, 60, 71, 46, 10, 14, 35, 55, 37, 52, 9, 85, 40, 76, 44, 3, 26, 19, 58, 42, 75, 17, 38, 82, 87, 43, 11, 5, 41, 61, 33, 49, 7, 73, 89, 81, 78, 18, 36, 51, 56, 83, 23, 8, 24, 63, 1, 12, 68, 66, 67, 77, 15, 88, 65, 59, 96, 54, 95, 93, 91, 74, 94, 16, 90, 57, 22, 50, 27, ], 'tpc_ds_throughput_8': [ 57, 29, 24, 76, 37, 66, 60, 98, 80, 12, 59, 70, 91, 69, 40, 2, 16, 44, 5, 73, 14, 71, 3, 49, 84, 64, 7, 36, 61, 41, 35, 50, 65, 51, 78, 21, 67, 22, 81, 93, 25, 26, 90, 74, 92, 75, 10, 58, 6, 47, 30, 94, 97, 55, 72, 95, 86, 39, 17, 42, 85, 9, 32, 34, 79, 54, 77, 45, 28, 11, 89, 56, 46, 19, 62, 8, 96, 1, 23, 88, 82, 87, 43, 53, 20, 52, 83, 38, 68, 4, 13, 48, 99, 27, 18, 15, 33, 31, 63, ], 'tpc_ds_throughput_9': [ 15, 60, 62, 74, 81, 88, 50, 5, 84, 1, 52, 57, 13, 14, 90, 7, 27, 92, 39, 34, 21, 65, 75, 9, 2, 12, 32, 28, 42, 17, 67, 31, 20, 11, 77, 36, 82, 33, 54, 4, 16, 10, 18, 48, 24, 30, 78, 6, 80, 35, 59, 99, 61, 22, 71, 68, 40, 66, 94, 47, 26, 25, 98, 70, 73, 38, 87, 3, 69, 86, 79, 89, 51, 58, 41, 19, 83, 96, 46, 53, 55, 72, 95, 29, 64, 93, 56, 97, 23, 44, 91, 49, 76, 63, 45, 43, 85, 37, 8, ], 'tpc_ds_throughput_10': [ 43, 50, 41, 48, 54, 53, 31, 39, 2, 96, 93, 15, 91, 21, 18, 32, 63, 24, 66, 70, 36, 20, 30, 25, 7, 1, 98, 69, 47, 94, 82, 37, 64, 86, 87, 28, 55, 85, 38, 44, 27, 78, 45, 49, 62, 59, 77, 80, 84, 67, 52, 76, 42, 33, 65, 23, 90, 88, 99, 35, 10, 16, 5, 57, 34, 97, 72, 75, 14, 40, 73, 79, 11, 6, 17, 58, 56, 83, 51, 29, 22, 71, 68, 60, 12, 4, 89, 61, 46, 92, 13, 9, 74, 8, 3, 95, 26, 81, 19, ], 'tpc_ds_throughput_11': [ 95, 31, 17, 49, 38, 29, 37, 66, 7, 83, 4, 43, 13, 36, 45, 98, 8, 62, 88, 57, 28, 64, 59, 16, 32, 96, 5, 14, 35, 99, 55, 81, 12, 40, 72, 69, 22, 26, 97, 92, 63, 77, 3, 9, 41, 52, 87, 84, 2, 82, 93, 74, 47, 85, 20, 46, 18, 53, 76, 67, 78, 27, 39, 15, 70, 61, 71, 30, 21, 90, 34, 73, 86, 80, 94, 6, 89, 56, 11, 60, 33, 65, 23, 50, 1, 44, 79, 42, 51, 24, 91, 25, 48, 19, 75, 68, 10, 54, 58, ], 'tpc_ds_throughput_12': [ 68, 37, 94, 9, 97, 60, 81, 88, 32, 56, 44, 95, 91, 28, 3, 5, 19, 41, 53, 15, 69, 12, 52, 27, 98, 83, 39, 21, 67, 76, 22, 54, 1, 90, 71, 14, 33, 10, 61, 24, 8, 87, 75, 25, 17, 93, 72, 2, 7, 55, 4, 48, 35, 26, 64, 51, 45, 29, 74, 82, 77, 63, 66, 43, 57, 42, 65, 59, 36, 18, 70, 34, 40, 84, 99, 80, 79, 89, 86, 50, 85, 20, 46, 31, 96, 92, 73, 47, 11, 62, 13, 16, 49, 58, 30, 23, 78, 38, 6, ], 'tpc_ds_throughput_13': [ 23, 81, 99, 25, 61, 50, 54, 53, 98, 89, 92, 68, 13, 69, 75, 39, 58, 17, 29, 43, 14, 1, 93, 63, 5, 56, 66, 36, 82, 74, 33, 38, 96, 18, 65, 21, 85, 78, 42, 62, 19, 72, 30, 16, 94, 4, 71, 7, 32, 22, 44, 49, 67, 10, 12, 11, 3, 60, 48, 55, 87, 8, 88, 95, 15, 47, 20, 52, 28, 45, 57, 70, 90, 2, 76, 84, 73, 79, 40, 31, 26, 64, 51, 37, 83, 24, 34, 35, 86, 41, 91, 27, 9, 6, 59, 46, 77, 97, 80, ], 'tpc_ds_throughput_14': [ 46, 54, 76, 16, 42, 31, 38, 29, 5, 79, 24, 23, 91, 14, 30, 66, 6, 94, 60, 95, 21, 96, 4, 8, 39, 89, 88, 28, 55, 48, 85, 97, 83, 45, 20, 36, 26, 77, 47, 41, 58, 71, 59, 27, 99, 44, 65, 32, 98, 33, 92, 9, 82, 78, 1, 86, 75, 50, 49, 22, 72, 19, 53, 68, 43, 35, 64, 93, 69, 3, 15, 57, 18, 7, 74, 2, 34, 73, 90, 37, 10, 12, 11, 81, 56, 62, 70, 67, 40, 17, 13, 63, 25, 80, 52, 51, 87, 61, 84, ], 'tpc_ds_throughput_15': [ 51, 38, 74, 27, 47, 37, 97, 60, 39, 73, 62, 46, 13, 21, 59, 88, 80, 99, 50, 68, 36, 83, 44, 19, 66, 79, 53, 69, 22, 49, 26, 61, 56, 3, 64, 28, 10, 87, 35, 17, 6, 65, 52, 63, 76, 92, 20, 98, 5, 85, 24, 25, 55, 77, 96, 40, 30, 31, 9, 33, 71, 58, 29, 23, 95, 67, 12, 4, 14, 75, 43, 15, 45, 32, 48, 7, 70, 34, 18, 81, 78, 1, 86, 54, 89, 41, 57, 82, 90, 94, 91, 8, 16, 84, 93, 11, 72, 42, 2, ], 'tpc_ds_throughput_16': [ 11, 97, 48, 63, 35, 81, 61, 50, 66, 34, 41, 51, 91, 36, 52, 53, 84, 76, 31, 23, 28, 56, 92, 58, 88, 73, 29, 14, 33, 9, 10, 42, 89, 75, 12, 69, 78, 72, 67, 94, 80, 20, 93, 8, 74, 24, 64, 5, 39, 26, 62, 16, 22, 87, 83, 90, 59, 37, 25, 85, 65, 6, 60, 46, 68, 82, 1, 44, 21, 30, 95, 43, 3, 98, 49, 32, 57, 70, 45, 54, 77, 96, 40, 38, 79, 17, 15, 55, 18, 99, 13, 19, 27, 2, 4, 86, 71, 47, 7, ], 'tpc_ds_throughput_17': [ 86, 61, 49, 8, 67, 54, 42, 31, 88, 70, 17, 11, 13, 28, 93, 29, 2, 74, 37, 46, 69, 89, 24, 6, 53, 34, 60, 21, 85, 25, 78, 47, 79, 30, 1, 14, 77, 71, 82, 99, 84, 64, 4, 19, 48, 62, 12, 39, 66, 10, 41, 27, 33, 72, 56, 18, 52, 81, 16, 26, 20, 80, 50, 51, 23, 55, 96, 92, 36, 59, 68, 95, 75, 5, 9, 98, 15, 57, 3, 38, 87, 83, 90, 97, 73, 94, 43, 22, 45, 76, 91, 58, 63, 7, 44, 40, 65, 35, 32, ], 'tpc_ds_throughput_18': [ 40, 42, 9, 19, 82, 38, 47, 37, 53, 57, 94, 86, 91, 69, 4, 60, 7, 48, 81, 51, 14, 79, 62, 80, 29, 70, 50, 36, 26, 16, 77, 35, 73, 59, 96, 21, 87, 65, 55, 76, 2, 12, 44, 58, 49, 41, 1, 66, 88, 78, 17, 63, 85, 71, 89, 45, 93, 54, 27, 10, 64, 84, 31, 11, 46, 22, 83, 24, 28, 52, 23, 68, 30, 39, 25, 5, 43, 15, 75, 97, 72, 56, 18, 61, 34, 99, 95, 33, 3, 74, 13, 6, 8, 32, 92, 90, 20, 67, 98, ], 'tpc_ds_throughput_19': [ 90, 47, 25, 58, 55, 97, 35, 81, 29, 15, 99, 40, 13, 14, 44, 50, 32, 49, 54, 11, 21, 73, 41, 84, 60, 57, 31, 28, 10, 27, 87, 67, 34, 52, 83, 36, 72, 20, 22, 74, 7, 1, 92, 6, 9, 17, 96, 88, 53, 77, 94, 8, 26, 65, 79, 3, 4, 38, 63, 78, 12, 2, 37, 86, 51, 33, 56, 62, 69, 93, 46, 23, 59, 66, 16, 39, 95, 43, 30, 61, 71, 89, 45, 42, 70, 76, 68, 85, 75, 48, 91, 80, 19, 98, 24, 18, 64, 82, 5, ], 'tpc_ds_throughput_20': [ 18, 35, 16, 6, 22, 61, 67, 54, 60, 43, 76, 90, 91, 21, 92, 31, 98, 9, 38, 86, 36, 34, 17, 2, 50, 15, 37, 69, 78, 63, 72, 82, 70, 93, 56, 28, 71, 64, 33, 48, 32, 96, 24, 80, 25, 94, 83, 53, 29, 87, 99, 19, 10, 20, 73, 75, 44, 97, 8, 77, 1, 7, 81, 40, 11, 85, 89, 41, 14, 4, 51, 46, 52, 88, 27, 66, 68, 95, 59, 42, 65, 79, 3, 47, 57, 74, 23, 26, 30, 49, 13, 84, 58, 5, 62, 45, 12, 55, 39, ], 'tpc_h_power': [ 14, 2, 9, 20, 6, 17, 18, 8, 21, 13, 3, 22, 16, 4, 11, 15, 1, 10, 19, 5, 7, 12, ], 'tpc_h_throughput_1': [ 21, 3, 18, 5, 11, 7, 6, 20, 17, 12, 16, 15, 13, 10, 2, 8, 14, 19, 9, 22, 1, 4, ], 'tpc_h_throughput_2': [ 6, 17, 14, 16, 19, 10, 9, 2, 15, 8, 5, 22, 12, 7, 13, 18, 1, 4, 20, 3, 11, 21, ], 'tpc_h_throughput_3': [ 8, 5, 4, 6, 17, 7, 1, 18, 22, 14, 9, 10, 15, 11, 20, 2, 21, 19, 13, 16, 12, 3, ], 'tpc_h_throughput_4': [ 5, 21, 14, 19, 15, 17, 12, 6, 4, 9, 8, 16, 11, 2, 10, 18, 1, 13, 7, 22, 3, 20, ], 'tpc_h_throughput_5': [ 21, 15, 4, 6, 7, 16, 19, 18, 14, 22, 11, 13, 3, 1, 2, 5, 8, 20, 12, 17, 10, 9, ], 'tpc_h_throughput_6': [ 10, 3, 15, 13, 6, 8, 9, 7, 4, 11, 22, 18, 12, 1, 5, 16, 2, 14, 19, 20, 17, 21, ], 'tpc_h_throughput_7': [ 18, 8, 20, 21, 2, 4, 22, 17, 1, 11, 9, 19, 3, 13, 5, 7, 10, 16, 6, 14, 15, 12, ], 'tpc_h_throughput_8': [ 19, 1, 15, 17, 5, 8, 9, 12, 14, 7, 4, 3, 20, 16, 6, 22, 10, 13, 2, 21, 18, 11, ], 'tpc_h_throughput_9': [ 8, 13, 2, 20, 17, 3, 6, 21, 18, 11, 19, 10, 15, 4, 22, 1, 7, 12, 9, 14, 5, 16, ], 'tpc_h_throughput_10': [ 6, 15, 18, 17, 12, 1, 7, 2, 22, 13, 21, 10, 14, 9, 3, 16, 20, 19, 11, 4, 8, 5, ], 'tpc_h_throughput_11': [ 15, 14, 18, 17, 10, 20, 16, 11, 1, 8, 4, 22, 5, 12, 3, 9, 21, 2, 13, 6, 19, 7, ], 'tpc_h_throughput_12': [ 1, 7, 16, 17, 18, 22, 12, 6, 8, 9, 11, 4, 2, 5, 20, 21, 13, 10, 19, 3, 14, 15, ], 'tpc_h_throughput_13': [ 21, 17, 7, 3, 1, 10, 12, 22, 9, 16, 6, 11, 2, 4, 5, 14, 8, 20, 13, 18, 15, 19, ], 'tpc_h_throughput_14': [ 2, 9, 5, 4, 18, 1, 20, 15, 16, 17, 7, 21, 13, 14, 19, 8, 22, 11, 10, 3, 12, 6, ], 'tpc_h_throughput_15': [ 16, 9, 17, 8, 14, 11, 10, 12, 6, 21, 7, 3, 15, 5, 22, 20, 1, 13, 19, 2, 4, 18, ], 'tpc_h_throughput_16': [ 1, 3, 6, 5, 2, 16, 14, 22, 17, 20, 4, 9, 10, 11, 15, 8, 12, 19, 18, 13, 7, 21, ], 'tpc_h_throughput_17': [ 3, 16, 5, 11, 21, 9, 2, 15, 10, 18, 17, 7, 8, 19, 14, 13, 1, 4, 22, 20, 6, 12, ], 'tpc_h_throughput_18': [ 14, 4, 13, 5, 21, 11, 8, 6, 3, 17, 2, 20, 1, 19, 10, 9, 12, 18, 15, 7, 22, 16, ], 'tpc_h_throughput_19': [ 4, 12, 22, 14, 5, 15, 16, 2, 8, 10, 17, 9, 21, 7, 3, 6, 13, 18, 11, 20, 19, 1, ], 'tpc_h_throughput_20': [ 16, 15, 14, 13, 4, 22, 18, 19, 7, 1, 12, 17, 5, 10, 20, 3, 9, 21, 11, 2, 6, 8, ], 'tpc_h_throughput_21': [ 20, 14, 21, 12, 15, 17, 4, 19, 13, 10, 11, 1, 16, 5, 18, 7, 8, 22, 9, 6, 3, 2, ], 'tpc_h_throughput_22': [ 16, 14, 13, 2, 21, 10, 11, 4, 1, 22, 18, 12, 19, 5, 7, 8, 6, 3, 15, 20, 9, 17, ], 'tpc_h_throughput_23': [ 18, 15, 9, 14, 12, 2, 8, 11, 22, 21, 16, 1, 6, 17, 5, 10, 19, 4, 20, 13, 3, 7, ], 'tpc_h_throughput_24': [ 7, 3, 10, 14, 13, 21, 18, 6, 20, 4, 9, 8, 22, 15, 2, 1, 5, 12, 19, 17, 11, 16, ], 'tpc_h_throughput_25': [ 18, 1, 13, 7, 16, 10, 14, 2, 19, 5, 21, 11, 22, 15, 8, 17, 20, 3, 4, 12, 6, 9, ], 'tpc_h_throughput_26': [ 13, 2, 22, 5, 11, 21, 20, 14, 7, 10, 4, 9, 19, 18, 6, 3, 1, 8, 15, 12, 17, 16, ], 'tpc_h_throughput_27': [ 14, 17, 21, 8, 2, 9, 6, 4, 5, 13, 22, 7, 15, 3, 1, 18, 16, 11, 10, 12, 20, 19, ], 'tpc_h_throughput_28': [ 10, 22, 1, 12, 13, 18, 21, 20, 2, 14, 16, 7, 15, 3, 4, 17, 5, 19, 6, 8, 9, 11, ], 'tpc_h_throughput_29': [ 10, 8, 9, 18, 12, 6, 1, 5, 20, 11, 17, 22, 16, 3, 13, 2, 15, 21, 14, 19, 7, 4, ], 'tpc_h_throughput_30': [ 7, 17, 22, 5, 3, 10, 13, 18, 9, 1, 14, 15, 21, 19, 16, 12, 8, 6, 11, 20, 4, 2, ], 'tpc_h_throughput_31': [ 2, 9, 21, 3, 4, 7, 1, 11, 16, 5, 20, 19, 18, 8, 17, 13, 10, 12, 15, 6, 14, 22, ], 'tpc_h_throughput_32': [ 15, 12, 8, 4, 22, 13, 16, 17, 18, 3, 7, 5, 6, 1, 9, 11, 21, 10, 14, 20, 19, 2, ], 'tpc_h_throughput_33': [ 15, 16, 2, 11, 17, 7, 5, 14, 20, 4, 21, 3, 10, 9, 12, 8, 13, 6, 18, 19, 22, 1, ], 'tpc_h_throughput_34': [ 1, 13, 11, 3, 4, 21, 6, 14, 15, 22, 18, 9, 7, 5, 10, 20, 12, 16, 17, 8, 19, 2, ], 'tpc_h_throughput_35': [ 14, 17, 22, 20, 8, 16, 5, 10, 1, 13, 2, 21, 12, 9, 4, 18, 3, 7, 6, 19, 15, 11, ], 'tpc_h_throughput_36': [ 9, 17, 7, 4, 5, 13, 21, 18, 11, 3, 22, 1, 6, 16, 20, 14, 15, 10, 8, 2, 12, 19, ], 'tpc_h_throughput_37': [ 13, 14, 5, 22, 19, 11, 9, 6, 18, 15, 8, 10, 7, 4, 17, 16, 3, 1, 12, 2, 21, 20, ], 'tpc_h_throughput_38': [ 20, 5, 4, 14, 11, 1, 6, 16, 8, 22, 7, 3, 2, 12, 21, 19, 17, 13, 10, 15, 18, 9, ], 'tpc_h_throughput_39': [ 3, 7, 14, 15, 6, 5, 21, 20, 18, 10, 4, 16, 19, 1, 13, 9, 8, 17, 11, 12, 22, 2, ], 'tpc_h_throughput_40': [ 13, 15, 17, 1, 22, 11, 3, 4, 7, 20, 14, 21, 9, 8, 2, 18, 16, 6, 10, 12, 5, 19, ], }