On the necessity of model checking NoSQL database schemas when building SaaS applications

  • Authors:
  • Stefanie Scherzinger;Eduardo Cunha De Almeida;Felipe Ickert;Marcos Didonet Del Fabro

  • Affiliations:
  • Regensburg University of Applied Sciences, Germany;UFPR, Brazil;UFPR, Brazil;UFPR, Brazil

  • Venue:
  • Proceedings of the 2013 International Workshop on Testing the Cloud
  • Year:
  • 2013

Quantified Score

Hi-index 0.00

Visualization

Abstract

The design of the NoSQL schema has a direct impact on the scalability of web applications. Especially for developers with little experience in NoSQL stores, the risks inherent in poor schema design can be incalculable. Worse yet, the issues will only manifest once the application has been deployed, and the growing user base causes highly concurrent writes. In this paper, we present a model checking approach to reveal scalability bottlenecks in NoSQL schemas. Our approach draws on formal methods from tree automata theory to perform a conservative static analysis on both the schema and the expected write-behavior of users. We demonstrate the impact of schema-inherent bottlenecks for a popular NoSQL store, and show how concurrent writes can ultimately lead to a considerable share of failed transactions.