RDBMS Demo Test
This is how we tested Vesper with in-house Relational Database Management System.
01
Prepare Data File
First, we prepared 'fake' personal health records for 100,000 and 1,000,000 people, which are 20MB and 200MB text files. Each entry has 10 fields: name, sex, age, height, weight, systolic & diastolic blood pressure, sleep hours, phone number, and address: all mixed types (character, integer, floating point number).
02
Encrypt Data File
Data files are encrypted using Vesper. 20MB file took 0.12 seconds, and 200MB file took 1.16 seconds - both have similar average rate of 170MB/s.
03
Prepare Configuration
Writing configuration file is easy. Simply define columns and name them, then write the titles and which column(s) to select and evaluate. The configuration file shown on the left shows seven queries for the RDBMS demo program.
04
Run RDBMS Demo
Vesper RDBMS demo reads in the configuration file and encrypted data file, analyzes the encrypted data, and displays the results. The data of one million people took 3.29 seconds, which is a rate of 3,040,000 fields per second. That is calculating averages, recording minimum/maximum values, and calculating standard deviations.
05
RDBMS Simple Search
We prepared another fake credit card user data file of 100,000 people (21MB), encrypted with Vesper, and ran a search query for a specific card number. It took 0.298 seconds, which is a rate of about 2,010,000 fields per second.