Optimization Project home page. ODB Tools
Optimization benchmark on Company Domain Schema using O2 4.2 - O2 Technology

  • Examples Query used

  • Database Instances
    - Storage SStorage Manager TManager Material SMaterial
    DB1 164 56 1151 534 1700 950
    DB2 1555 725 1718 691 2600 1481
    DB3 3220 1621 3436 1382 4900 2912
    DB4 4869 2515 5154 2073 8200 4668
    DB5 - - - - 17575 7500

  • 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 8.9% 63.2% 40.1% 58.1%
    DB2 3.7% 49.2% 42.3% 56.6%
    DB3 1.7% 55.5% 45.2% 56.5%
    DB4 1.2% 54.0% 45.7% 54.3%
    DB5 - - - 39.0%

    Graphic representation