Home // International Journal On Advances in Software, volume 10, numbers 1 and 2, 2017 // View article

Cloud Data Denormalization for Platform-As-A-Service

Authors:
Aspen Olmsted

Keywords: web services; distributed database; modeling; cloud computing

Abstract:
In this paper, we investigate the problem of representing transaction data in PAAS cloud-based systems. We compare traditional database normalization techniques with our denormalized approach. In this research, we focus on transactional data related to an organization’s customers. Some optimization comes from the absence of a known customer object, which allows for the vertical merging of tuples. Instead of storing detail transactional data, data is stored in aggregate form. The journaling features of the data store allow for full audits of transactions while not requiring anonymous data to be materialized in fine-grained levels. The horizontal merging of objects is also deployed to remove detail lookup data instance records and one-to-many leaf node records.

Pages: 21 to 30

Copyright: Copyright (c) to authors, 2017. Used with permission.

Publication date: June 30, 2017

Published in: journal

ISSN: 1942-2628