Informed Schema Design for Column Store-Based Database Services

Proceedings - 2015 IEEE 8th International Conference on Service-Oriented Computing and Applications, SOCA 2015

Volumn , Issue , 2016, Pages 163-172

  Bermbach, David ^a   Müller, Steffen ^b   Eberhardt, Jacob ^a   Tai, Stefan ^a  

^a TECHNISCHE UNIVERSITÄT BERLIN   (Germany)

^b KARLSRUHE INSTITUTE OF TECHNOLOGY   (Germany)

Author keywords

Column Stores; NoSQL Systems; Schema Design

Indexed keywords

DESIGN; DISTRIBUTED COMPUTER SYSTEMS;

APPLICATION DEVELOPERS; APPLICATION SPECIFIC; COLUMN-STORE; DATABASE SCHEMAS; DATABASE SERVICE; POOR PERFORMANCE; RELATIONAL DATABASE MANAGEMENT SYSTEMS; SCHEMA DESIGN;

RELATIONAL DATABASE SYSTEMS;

EID: 84964871381     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/SOCA.2015.29     Document Type: Conference Paper

References (23)

1. G. L. Sanders and S. Shin, "Denormalization effects on performance of rdbms," in HICSS 2001. IEEE, 2001.
2. S. K. Shin and G. L. Sanders, "Denormalization strategies for data retrieval from data warehouses," Decision Support Systems, 2006.
3. Z. Wei, J. Dejun, G. Pierre, C.-H. Chi, and M. van Steen, "Service-oriented data denormalization for scalable web applications," in WWW 2008. ACM, 2008, pp. 267-276.
4. S. Sakr, A. Liu, D. M. Batista, and M. Alomari, "A Survey of Large Scale Data Management Approaches in Cloud Environments," IEEE Communications Surveys and Tutorials, vol. 13, 2011.
5. L. Todorov, "Python driver overview using twissandra," http://planetcassandra.org/blog/python-driver-overview-using-twissandra (accessed Sept 1, 2014), 2014.
6. F. Chang, J. Dean, S. Ghemawat, W. Hsieh, D. Wallach, M. Burrows, T. Chandra, A. Fikes, and R. Gruber, "Bigtable: A distributed storage system for structured data," ACM TOCS, vol. 26, no. 2, pp. 1-26, 2008.
7. D. Bermbach and J. Kuhlenkamp, "Consistency in distributed storage systems: An overview of models, metrics and measurement approaches," in NETYS 2013. Springer, 2013.
8. W. Vogels, "Eventually consistent," Queue, vol. 6, October 2008.
9. D. Bermbach, S. Sakr, and L. Zhao, "Towards comprehensive measurement of consistency guarantees for cloud-hosted data storage services," in TPCTC 2013. Springer, 2013.
10. D. Bermbach. and S. Tai, "Benchmarking eventual consistency: Lessons learned from long-term experimental studies," in IC2E 2014, 2014.
11. H. Wada, A. Fekete, L. Zhao, K. Lee, and A. Liu, "Data consistency properties and the trade offs in commercial cloud storages: the consumers' perspective," in CIDR 2011, vol. 11, 2011.
12. D. Abadi, "Consistency tradeoffs in modern distributed database system design: Cap is only part of the story," Computer, 2012.
13. T. Vajk, P. Feher, K. Fekete, and H. Charaf, "Denormalizing data into schema-free databases," in CogInfoCom 2013. IEEE, 2013, pp. 747-752.
14. T. Vajk, L. Deák, K. Fekete, and G. Mezei, "Automatic nosql schema development: A case study," in PDCN 2013, vol. 2013.
15. M. J. Mior, "Automated schema design for nosql databases," in ACM SIGMOD 2014 PhD Symposium, 2014.
16. S. Scherzinger, E. C. De Almeida, F. Ickert, and M. D. Del Fabro, "On the necessity of model checking nosql database schemas when building saas applications," in TTC 2013. ACM, 2013, pp. 1-6.
17. A. S. Tanenbaum and M. V. Steen, Distributed Systems - Principles and Paradigms, 2nd ed. Upper Saddle River, NJ: Pearson Education, 2007.
18. M. Shapiro, N. Preguiça, C. Baquero, and M. Zawirski, "Conflict-free replicated data types," in SSS 2011. Springer, 2011, pp. 386-400.
19. A. Lakshman and P. Malik, "Cassandra: a decentralized structured storage system," ACM SIGOPS OSR, vol. 44, no. 2, pp. 35-40, 2010.
20. J. Kuhlenkamp, M. Klems, and O. Röss, "Benchmarking scalability and elasticity of distributed database systems," PVLDB, vol. 7, no. 12, 2014.
21. D. Bermbach, J. Kuhlenkamp, A. Dey, S. Sakr, and R. Nambiar, "Towards an extensible middleware for database benchmarking," in TPCTC 2014. Springer, 2014.
22. D. B. Terry, V. Prabhakaran, R. Kotla, M. Balakrishnan, M. K. Aguilera, and H. Abu-Libdeh, "Consistency-based service level agreements for cloud storage," in ACM SOSP 2013.
23. D. Bermbach, J. Kuhlenkamp, B. Derre, M. Klems, and S. Tai, "A middleware guaranteeing client-centric consistency on top of eventually consistent datastores," in IC2E 2013. IEEE, 2013.