The SSB Schema is a generated database schema, that can be used to evaluate the Performance of a Datawarehouse system. This is used to evaluate the performance between ADWC in the cloud and a local Oracle Database which is running within a Virtual Box image on a Laptop. This test is not conducted under test lab conditions and should only provide a rough order of magnitude.
System (Hardware) Baseline
The following instances have been used for the Performance test.
ADWC Trial
based on Hardware specification shown:
This instances is only used as reference, since the sizing (with 2 CPUs) and query performance for some queries based on the same SSB schema are publically available.
ADWC
instance which only uses 1 CPU
VM Image
with 4GB Ram
and 1 CPU
Based on Laptop Host system (Lenovo Yoga 370 Laptop) with:
The image runs Oracle Database 12c R2 Enterprise Edition, with no specific/tuned configuration (parameters) for Datawarehousing.
System Schema Baseline
Benchmark Performance
For Prologue Queries based on these examples. As mentioned before, for the ADW instance “ADWC Trail”, some queries run times are publically available. These queries have also been executed within the other instances. The runtimes of the ADWC Trail have only been used as reference:
SSB Queries, as outlined here and here (Oracle Documentation). The below shows the query run-times for the ADWC and local Oracle Database (running as a Virtual Box image). The connection to the ADWC instance is made with the high connection type. When using the medium or low connection type, all queries were showing longer response times (as expected). Thus, the high connection type has been used for conducting the Benchmark.
The Excel file containing the system baseline in terms of number of records, queries and run-time results can be downloaded here.
Below is a galary of the executed SSB Queries on ADW and Virtual Box Oracle Database 12c: