LDBC SNB Business Intelligence workload

The LDBC SNB Business Intelligence workload is focusing on aggregation- and join-heavy complex queries touching a large portion of the graph with microbatches of insert/delete operations. Its data sets are available in Cloudflare R2.

For an overview of the workload, see the VLDB 2023 paper and its presentation by Gabor Szarnyas.

The workload produces scoring metrics for performance (power and throughput scores) at the given scale and price/performance metrics. The full disclosure reports (FDR) further break down the composition of the metric into its constituent parts, e.g. single query execution times.

Note that the system cost is the sum of the license, hardware, and maintenance costs, where maintenance means 24/7 support with a response time of less than 4 hours.

Audited results

Benchmark setup SF Hardware Performance metrics and cost Documents
30,000 72 Alibaba Cloud ecs.r7.16xlarge instances:
64×Intel Xeon Platinum 8369B vCPUs, 
512 GiB RAM per instance
  • Power@SF: 111,775.39
  • Power@SF (price‑adjusted): 19.79
  • Throughput@SF: 56,920.48
  • Throughput@SF (price‑adjusted): 10.08
100 1 AWS r6a.4xlarge instance:
16×AMD EPYC 7R13 vCPUs,
128GiB RAM
  • Power@SF: 6,253.72
  • Power@SF (price‑adjusted): 43.79
  • Throughput@SF: 3,723.44
  • Throughput@SF (price‑adjusted): 26.07
1,000 4 AWS r6a.8xlarge instances:
32×AMD EPYC 7R13 vCPUs,
256GiB RAM per instance
  • Power@SF: 23,951.74
  • Power@SF (price‑adjusted): 18.39
  • Throughput@SF: 10,605.12
  • Throughput@SF (price‑adjusted): 8.14
10,000 48 AWS r6a.8xlarge instances:
32×AMD EPYC 7R13 vCPUs,
256GiB RAM per instance
  • Power@SF: 89,444.50
  • Power@SF (price‑adjusted): 11.36
  • Throughput@SF: 41,025.76
  • Throughput@SF (price‑adjusted): 5.21
1,000 Dell PowerEdge 6625 with
64×AMD EPYC 9354 CPU cores and
1.5TiB RAM
  • Power@SF: 30,990.08
  • Power@SF (price‑adjusted): 22.90
  • Throughput@SF: 12,993.85
  • Throughput@SF (price‑adjusted): 9.60

The audited LDBC SNB BI results displayed above are available as a CSV file.

LDBC-certified auditors

SNB BI audits can be commissioned from the following LDBC-certified auditors:

  • Fabian Murariu (Pometry Ltd.)
  • David Püroja