Optimization benchmark on Company Domain Schema
using UNISQL 3.1.2
Examples Query used
Database Instances
| - |
Storage |
SStorage |
Manager |
TManager |
Material |
SMaterial |
| DB1 |
160 |
80 |
1204 |
632 |
1526 |
1024 |
| DB2 |
1600 |
800 |
1719 |
833 |
2555 |
1555 |
| DB3 |
3200 |
1600 |
3281 |
1415 |
4435 |
2675 |
| DB4 |
5000 |
2500 |
5077 |
1937 |
7684 |
4526 |
| DB5 |
- |
- |
- |
- |
17500 |
8230 |
Database Instances randomly generated
Each created instance satisfies the integrity constraints
Ratio of Optimized and Original Cost
| - |
Manager |
Storage |
Material |
| - |
Query1 |
Query2 |
Query3 |
Query4 |
| DB1 |
16.4% |
107% |
70.5% |
98.2% |
| DB2 |
10.4% |
54.1% |
18.3% |
93.9% |
| DB3 |
9.3% |
46.3% |
19.2% |
17.6% |
| DB4 |
5.7% |
38.7% |
17.6% |
75.6% |
| DB5 |
- |
- |
- |
71.5% |
Graphic representation
ODB Tools 