A.2.1 Inheritance 3
Assoc 1
100 200 300 400 500 600 700 800 900 1000
8 9 10 11 12 13 14 15 16
Population
Time(ms)
Inh3Assoc1 GBQ Real Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1000
8 10 12 14 16
Population
Time(ms)
Inh3Assoc1 GBQ CPU Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 0
500 1,000 1,500 2,000 2,500
Population
Time(ms)
Inh3Assoc1 Query Real Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000
10 15 20 25
Population
Time(ms)
Inh3Assoc1 Query Real Time Medians Comparison
Sql Server PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000 5
6 7 8 9 10 11 12
Population
Time(ms)
Inh3Assoc1 Query CPU Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
Assoc 2
100 200 300 400 500 600 700 800 900 1000
12 14 16 18 20 22 24
Population
Time(ms)
Inh3Assoc2 GBQ Real Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 0
500 1,000 1,500 2,000 2,500 3,000 3,500
Population
Time(ms)
Inh3Assoc2 Query Real Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1000
8 10 12 14 16 18 20 22 24
Population
Time(ms)
Inh3Assoc2 GBQ CPU Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 10
15 20 25 30
Population
Time(ms)
Inh3Assoc2 Query Real Time Medians Comparison
Sql Server PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000
8 10 12 14 16
Population
Time(ms)
Inh3Assoc2 Query CPU Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
Assoc 3
100 200 300 400 500 600 700 800 900 1000
20 25 30 35
Population
Time(ms)
Inh3Assoc3 GBQ Real Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1000
14 16 18 20 22 24 26
Population
Time(ms)
Inh3Assoc3 GBQ CPU Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 0
1,000 2,000 3,000 4,000
Population
Time(ms)
Inh3Assoc3 Query Real Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000
15 20 25 30 35
Population
Time(ms)
Inh3Assoc3 Query Real Time Medians Comparison
Sql Server PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000 10
12 14 16 18 20 22
Population
Time(ms)
Inh3Assoc3 Query CPU Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
A.2.2 Inheritance 4
Assoc 1
100 200 300 400 500 600 700 800 900 1000
8 9 10 11 12 13 14 15
Population
Time(ms)
Inh4Assoc1 GBQ Real Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1000
7 8 9 10 11 12
Population
Time(ms)
Inh4Assoc1 GBQ CPU Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 0
500 1,000 1,500 2,000 2,500
Population
Time(ms)
Inh4Assoc1 Query Real Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000
10 15 20 25 30
Population
Time(ms)
Inh4Assoc1 Query Real Time Medians Comparison
Sql Server PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000 6
7 8 9 10 11
Population
Time(ms)
Inh4Assoc1 Query CPU Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
Assoc 2
100 200 300 400 500 600 700 800 900 1000
12 14 16 18 20 22 24
Population
Time(ms)
Inh4Assoc2 GBQ Real Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 0
500 1,000 1,500 2,000 2,500 3,000 3,500
Population
Time(ms)
Inh4Assoc2 Query Real Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1000
10 12 14 16 18
Population
Time(ms)
Inh4Assoc2 GBQ CPU Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 15
20 25 30 35
Population
Time(ms)
Inh4Assoc2 Query Real Time Medians Comparison
Sql Server PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000
8 10 12 14 16
Population
Time(ms)
Inh4Assoc2 Query CPU Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
Assoc 3
100 200 300 400 500 600 700 800 900 1000
20 25 30 35
Population
Time(ms)
Inh4Assoc3 GBQ Real Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1000
12 14 16 18 20 22 24 26
Population
Time(ms)
Inh4Assoc3 GBQ CPU Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 0
1,000 2,000 3,000 4,000
Population
Time(ms)
Inh4Assoc3 Query Real Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000
15 20 25 30 35 40 45
Population
Time(ms)
Inh4Assoc3 Query Real Time Medians Comparison
Sql Server PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000 10
12 14 16 18 20 22
Population
Time(ms)
Inh4Assoc3 Query CPU Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
A.2.3 Inheritance 5
Assoc 1
100 200 300 400 500 600 700 800 900 1000
8 10 12 14 16 18
Population
Time(ms)
Inh5Assoc1 GBQ Real Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1000
7 8 9 10 11 12 13 14
Population
Time(ms)
Inh5Assoc1 GBQ CPU Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 0
500 1,000 1,500 2,000 2,500 3,000
Population
Time(ms)
Inh5Assoc1 Query Real Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000
10 20 30 40 50
Population
Time(ms)
Inh5Assoc1 Query Real Time Medians Comparison
Sql Server PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000 6
7 8 9 10 11 12
Population
Time(ms)
Inh5Assoc1 Query CPU Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
Assoc 2
100 200 300 400 500 600 700 800 900 1000
14 16 18 20 22 24 26
Population
Time(ms)
Inh5Assoc2 GBQ Real Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 0
1,000 2,000 3,000 4,000
Population
Time(ms)
Inh5Assoc2 Query Real Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1000
12 14 16 18 20
Population
Time(ms)
Inh5Assoc2 GBQ CPU Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 10
20 30 40 50 60
Population
Time(ms)
Inh5Assoc2 Query Real Time Medians Comparison
Sql Server PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000
8 10 12 14 16 18
Population
Time(ms)
Inh5Assoc2 Query CPU Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
Assoc 3
100 200 300 400 500 600 700 800 900 1000
20 25 30 35
Population
Time(ms)
Inh5Assoc3 GBQ Real Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1000
10 15 20 25 30
Population
Time(ms)
Inh5Assoc3 GBQ CPU Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 0
1,000 2,000 3,000 4,000 5,000
Population
Time(ms)
Inh5Assoc3 Query Real Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000
20 30 40 50 60 70
Population
Time(ms)
Inh5Assoc3 Query Real Time Medians Comparison
Sql Server PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000 12
14 16 18 20 22 24
Population
Time(ms)
Inh5Assoc3 Query CPU Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
A.2.4 Inheritance 6
Assoc 1
100 200 300 400 500 600 700 800 900 1000
10 15 20 25 30
Population
Time(ms)
Inh6Assoc1 GBQ Real Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1000
8 9 10 11 12 13 14
Population
Time(ms)
Inh6Assoc1 GBQ CPU Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 0
1,000 2,000 3,000 4,000
Population
Time(ms)
Inh6Assoc1 Query Real Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000
0 20 40 60 80 100
Population
Time(ms)
Inh6Assoc1 Query Real Time Medians Comparison
Sql Server PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000 6
8 10 12 14 16
Population
Time(ms)
Inh6Assoc1 Query CPU Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
Assoc 2
100 200 300 400 500 600 700 800 900 1000
15 20 25 30 35
Population
Time(ms)
Inh6Assoc2 GBQ Real Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 0
1,000 2,000 3,000 4,000 5,000
Population
Time(ms)
Inh6Assoc2 Query Real Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1000
12 14 16 18 20
Population
Time(ms)
Inh6Assoc2 GBQ CPU Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 20
40 60 80 100 120 140
Population
Time(ms)
Inh6Assoc2 Query Real Time Medians Comparison
Sql Server PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000
10 12 14 16 18 20 22
Population
Time(ms)
Inh6Assoc2 Query CPU Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
Assoc 3
100 200 300 400 500 600 700 800 900 1000
20 25 30 35 40
Population
Time(ms)
Inh6Assoc3 GBQ Real Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1000
16 18 20 22 24 26
Population
Time(ms)
Inh6Assoc3 GBQ CPU Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 0
1,000 2,000 3,000 4,000 5,000 6,000
Population
Time(ms)
Inh6Assoc3 Query Real Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000
20 40 60 80 100 120 140 160
Population
Time(ms)
Inh6Assoc3 Query Real Time Medians Comparison
Sql Server PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000 12
14 16 18 20 22 24 26
Population
Time(ms)
Inh6Assoc3 Query CPU Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
A.3 Northwind
100 200 300 400 500 600 700 800 900 1000
11.8 11.9 12 12.1 12.2
Population
Time(ms)
Northwind GBQ Real Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1000
10 10.5 11 11.5 12 12.5
Population
Time(ms)
Northwind GBQ CPU Time per Database
Sql Server MySql PostgreSql
100 200 300 400 500 600 700 800 900 1,000 5
6 7 8 9 10 11 12
Population
Time(ms)
Northwind Query Real Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000
5 6 7 8 9 10 11 12
Population
Time(ms)
Northwind Query Real Time Medians Comparison
Sql Server PostgreSql GBQ EF
100 200 300 400 500 600 700 800 900 1,000 4
5 6 7 8 9 10 11 12
Population
Time(ms)
Northwind Query CPU Time Medians Comparison
Sql Server MySql PostgreSql GBQ EF