W H I T E P A P E R
www.persistent.com
© 2017 Persistent Systems Ltd. All rights reserved.
Consistency
model
No writes –read-only reporting and analytics
Security
Authentication based on school Id (tenant); Role
based authorizations (row and column level);
encryption of data at rest and on DB backups;
Auditing; allow several BI tool clients
Compliance
DPA (Data Protection Act)
GDPR (General Data Protection Regulation)
Performance
Sustained performance in the order of 384,000
completed queries in an hour based on customer
analytic workload, which corresponds to Medium
level performance as defined in Appendix 1
Customer workload has
more operational query
mix compared to TPC-H;
However, performance
characterization as
Medium-level seems still
adequate
Scalability
No real scalability, as number of users and data
volumes largely known beforehand and (IaaS)
infrastructure is statically provisioned
Resource
Management
Monitor and replace failed nodes, server backups
and restore, OS updates/patches
SQL Server managed
by the customer on IaaS
initially (but see below)
Pricing Models
Pay as you go
Cost
Low (associated with public cloud + IaaS)
to medium (associated with public managed
PaaS)
User skills
Mostly end users; target skill level is 80% of
users should create a simple list report with no
training
Internal
technical skills
No development skills, large staffing needs
Reason why project
subcontracted to PSL
Requirement
on cloud
computing
ecosystem
SQL Server, Jasper Reports, Excel, Tableau
OLTP technology
stack which based
around Microsoft SQL
Server
17