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.
based on Hardware specification shown:
instance which only uses 1 CPU
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
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:
The following is a step-by-step guide to determine the Connection string for Oracle Analytics Cloud and Oracle Database Cloud.
When logging into your Oracle Cloud Service using your identity Domain, a similar page is being displayed:
Click on the Action Menu of the Database Cloud Service and select “Open Service Console”.
This Page shows details about your Cloud Services such as OCPUs, Storage or Memory:
click on the Database Service Name to get to the Details Page:
This reveals the Public IP of the Oracle Cloud Database and the required Service Name.
Within the Oracle BI Administration Tool, the connection string needs to be created in the Data Source Name Field:
Using the following format:
After modelling the data and saving the .rpd file, the Model can be uploaded to the OAC Cloud: