Abstract
The purpose of this paper is to realize a comparative analysis of relational and non-relational database management systems. Both conceptual and technical characteristics are introduced, presenting the benefits and disadvantages of each model, using a hybrid application. The application, named SuperstoreSalesReporting, generates comparative reports which describe the technical characteristics of both SQL and NoSQL databases based on the executed operations. The application constitutes the contribution of this study, together with the creation of the SQL Server internal processes for migrating data from a flat file into a star schema.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
https://academy.datastax.com/planet-cassandra/what-is-nosql, accessed on 30 Aug 2017.
- 2.
https://en.wikipedia.org/wiki/Eventual_consistency, accessed on 30 Aug 2017.
References
Coșofreț, G.: Analiză comparativă a bazelor de date relationale și non-relaționale. Studiu de caz pe interacțiunea Customer-Retailer, Universitatea Babeș-Bolyai (2017)
Codd, E.: A relational model of data for large shared data banks. Commun. ACM 13(6), 377–387 (1970). IBM Research Laboratory
Chamberlin, D.: SQL. In: Liu, L., Özsu, M.T. (eds.) Encyclopedia of Database Systems, p. 4355. Springer, Boston (2009). https://doi.org/10.1007/978-0-387-39940-9_1091
Gilbert, S., Lynch, N.: Brewer’s conjecture and the feasibility of consistent, available, partition-tolerant web services. ACM SIGACT News 33(2), 51–59 (2002)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer International Publishing AG
About this paper
Cite this paper
Coșofreț, G., Ciuciu, I. (2018). Superstore Sales Reporting: A Comparative Analysis of Relational and Non-relational Databases. In: Debruyne, C., et al. On the Move to Meaningful Internet Systems. OTM 2017 Workshops. OTM 2017. Lecture Notes in Computer Science, vol 10697. Springer, Cham. https://doi.org/10.1007/978-3-319-73805-5_10
Download citation
DOI: https://doi.org/10.1007/978-3-319-73805-5_10
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-73804-8
Online ISBN: 978-3-319-73805-5
eBook Packages: Computer ScienceComputer Science (R0)