VoltDB Client Details

 
Client 1
Client 2
Author
Nasser Alrayes Deepak Karkala & Ravi Hiremani
Schema Description
  • Data is stored in the following tables: "users", "friendship", "resources" and "manipulation".
  • Friendship is stored in one table, "friendship", as two records for every confirmed friendship.
  • Aggregates are stored as attributes in the "users" table.
  • Data is stored in the following tables: "users", "confirmedfriendship", "pendingfriendship", "resources" and "manipulation".
  • Two records are maintained in the "confirmedfriendship" table for every friendship.
  • Aggregates are calculated by issuing aggregate queries.
  • Profile and thumbnail images for a user are stored in the file system.
Index Structures
  • The "users" table is index on userid.
  • The "freindship" table is index on friend1 and friend2.
  • The "resources" table is indexed on resourceid and walluserid (the userid for the wall, where the resource is posted on).
  • The "manipulation" table is indexed on manipulationid and resourceid.
  • The "pendingfriendship" and "confirmedfriendship" tables are indexed on inviter and inviteeid.
  • The "resources" table is indexed on resourceid and walluserid (the userid for the wall, where the resource is posted on).
  • The "manipulation" table is indexed on manipulationid and resourceid.
Source
Download Download

  • 124816
    Client 1100230300450750
    Client 260160210300440
  • 124816
    Client 197683141499129705117649116376
    Client 23058238852389603911238724
  • 124816
    Client 119181984198919941994
    Client 220121984198921961994

# 10,000 members, 100 friends per user, 100 resources per user, no user images.

† The reported performance numbers were obtained using instances with the following specifications: Intel(R) Core(TM) i5-750 Processor (2.67 GHz), 16 Gigabytes RAM. One instance hosted the data store while multiple BGClients were used to generate workload. Processor and network resources of the BGClients were not a bottleneck while obtaining these numbers. The experiments were conducted using VoltDB-Server 3.1 and VoltDB-Client 3.1.