Skip to main content

Advertisement

SpringerLink
Log in
Menu
Find a journal Publish with us
Search
Cart
Book cover

International Conference on Availability, Reliability, and Security

CD-ARES 2012: Multidisciplinary Research and Practice for Information Systems pp 73–84Cite as

  1. Home
  2. Multidisciplinary Research and Practice for Information Systems
  3. Conference paper
Combining Relational and Semi-structured Databases for an Inquiry Application

Combining Relational and Semi-structured Databases for an Inquiry Application

  • Marius Ebel21 &
  • Martin Hulin21 
  • Conference paper
  • 2102 Accesses

  • 1 Citations

Part of the Lecture Notes in Computer Science book series (LNISA,volume 7465)

Abstract

The popularity of NoSQL databases keeps growing and more companies have been moving away from relational databases to non-relational NoSQL databases. In this paper, the partitioning of a relational data model of an inquiry system into semi-structured and relational data for storage in both SQL and NoSQL databases is shown. Furthermore, the CAP theorem will be applied to categorize the storing of the correct parts of the model into their corresponding databases. As a result of these reorganizations and the introduction of additional histogram data, overall performance improvements of about 93% to 98% are achieved.

Keywords

  • NoSQL
  • Document Stores
  • MongoDB
  • semi-structured data
  • inquiry system

Download conference paper PDF

References

  1. Abiteboul, S., Buneman, P., Suciu, D.: Data on the Web: From relations to semistructured data and XML. Morgan Kaufmann Publishers Inc., San Francisco (2000)

    Google Scholar 

  2. Brewer, E.A.: Towards robust distributed systems (abstract). In: Proceedings of the Nineteenth Annual ACM Symposium on Principles of Distributed Computing, PODC 2000, p. 7. ACM, New York (2000)

    CrossRef  Google Scholar 

  3. Cattell, R.: Scalable SQL and NoSQL data stores. SIGMOD Record 39(4), 12–27 (2010)

    CrossRef  Google Scholar 

  4. Chang, F., Dean, J., Ghemawat, S., Hsieh, W.C., Wallach, D.A., Burrows, M., Chandra, T., Fikes, A., Gruber, R.E.: Bigtable: A distributed storage system for structured data. In: Proceedings of the 7th Conference on USENIX Symposium on Operating Systems Design and Implementation, vol. 7, pp. 205–218 (2006)

    Google Scholar 

  5. Comer, D.: The Ubiquitous B-Tree. ACM Computing Surveys 11, 121–137 (1979)

    CrossRef  MATH  Google Scholar 

  6. Dean, J., Ghemawat, S.: MapReduce: Simplified data processing on large clusters. In: Proceedings of the 6th Symposium on Opearting Systems Design & Implementation. USENIX Association (2004)

    Google Scholar 

  7. Evans, E.: Eric Evans’ Weblog (May 2009), http://blog.sym-link.com/2009/05/12/nosql_2009.html (retrieved March 03, 2012)

  8. Fielding, R.T.: Architectural styles and the design of network-based software architectures. Ph.D. thesis, University of California (2000)

    Google Scholar 

  9. Gilbert, S., Lynch, N.: Brewer’s conjecture and the feasibility of consistent, available, partition-tolerant web services. SIGACT News 33, 51–59 (2002)

    CrossRef  Google Scholar 

  10. Leavitt, N.: Will NoSQL Databases Live Up to Their promise? Computer 43, 12–14 (2010)

    CrossRef  Google Scholar 

  11. Lerner, R.M.: At the Forge - Redis. Linux Journal 2010 (197) (September 2010), http://www.linuxjournal.com/article/10836 (retrieved February 27, 2012)

  12. MongoDB: BSON, http://www.mongodb.org/display/DOCS/BSON (retrieved February 26, 2012)

  13. Ramalho, L.: Implementing a Modern API for CDS/ISIS, a classic semistructured NoSQL Database. In: Todt, E. (ed.) Forum Internacional Do Software Livre, XI Workshop Sobre Software Livre, Porto Alegre, vol. 11, pp. 42–47 (2010)

    Google Scholar 

  14. Riva, C., Laitkorpi, M.: Designing Web-Based Mobile Services with REST. In: Di Nitto, E., Ripeanu, M. (eds.) ICSOC 2007. LNCS, vol. 4907, pp. 439–450. Springer, Heidelberg (2009)

    CrossRef  Google Scholar 

  15. Robinson, D.: Amazon Web Services Made Simple: Learn how Amazon EC2, S3, SimpleDB and SQS Web Services enables you to reach business goals faster. Emereo Pvt. Ltd., London (2008)

    Google Scholar 

  16. Xiang, P., Hou, R., Zhou, Z.: Cache and consistency in NOSQL, vol. 6, pp. 117–120. IEEE (2010)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. University of Applied Sciences Ravensburg-Weingarten, 88250, Weingarten, Germany

    Marius Ebel & Martin Hulin

Authors
  1. Marius Ebel
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Martin Hulin
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of IT, Engineering and Environment, University of South Australia, Mawson Lakes Campus, 5001, Adelaide, SA, Australia

    Gerald Quirchmayr

  2. Department of Information Technologies, University of Economics, W. Churchill Sq. 4, 130 67, Prague 3, Czech Republic

    Josef Basl

  3. School of Information Science, Korean Bible University, 16 Danghyun 2-gil, Nowon-gu, 139-791, Seoul, Korea

    Ilsun You

  4. Information Technology and Decision Sciences, Old Dominion University, 2076 Constant Hall, 23529, Norfolk, VA, USA

    Lida Xu

  5. Institute of Software Technology and Interactive Systems, Vienna University of Technology and SBA Research, Favoritenstrsse 9-11, 1040, Vienna, Austria

    Edgar Weippl

Rights and permissions

Reprints and Permissions

Copyright information

© 2012 IFIP International Federation for Information Processing

About this paper

Cite this paper

Ebel, M., Hulin, M. (2012). Combining Relational and Semi-structured Databases for an Inquiry Application. In: Quirchmayr, G., Basl, J., You, I., Xu, L., Weippl, E. (eds) Multidisciplinary Research and Practice for Information Systems. CD-ARES 2012. Lecture Notes in Computer Science, vol 7465. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-32498-7_6

Download citation

  • .RIS
  • .ENW
  • .BIB
  • DOI: https://doi.org/10.1007/978-3-642-32498-7_6

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-32497-0

  • Online ISBN: 978-3-642-32498-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Share this paper

Anyone you share the following link with will be able to read this content:

Sorry, a shareable link is not currently available for this article.

Provided by the Springer Nature SharedIt content-sharing initiative

Search

Navigation

  • Find a journal
  • Publish with us

Discover content

  • Journals A-Z
  • Books A-Z

Publish with us

  • Publish your research
  • Open access publishing

Products and services

  • Our products
  • Librarians
  • Societies
  • Partners and advertisers

Our imprints

  • Springer
  • Nature Portfolio
  • BMC
  • Palgrave Macmillan
  • Apress
  • Your US state privacy rights
  • Accessibility statement
  • Terms and conditions
  • Privacy policy
  • Help and support

167.114.118.210

Not affiliated

Springer Nature

© 2023 Springer Nature