Skip to main content
Disciplines
Automotive Business IT + Informatics Construction + Real Estate Electrical Engineering + Electronics Energy + Sustainability Insurance + Risk Finance + Banking Management + Leadership Marketing + Sales Mechanical Engineering + Materials
Events
DE
EN
Books
Journals
Topic Page
Marketing
Start single access now
Access for companies
EXTENDED SEARCH
Log in
Top
Published in:
Visualizing Student Engagement and Performance in Online Course: A Step to Smart Learning Environment Read chapter Read first chapter

2023 | OriginalPaper | Chapter

Building a NoSQL ERP

Authors : Ela Pustulka, Stefan von Arx, Lucia de Espona

Published in: Proceedings of Seventh International Congress on Information and Communication Technology

Publisher: Springer Nature Singapore

Log in

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

Enterprise resource planning (ERP) systems are needed in many business activities. Small and medium enterprises (SMEs) are not well-served by current ERPs, as such systems are hard to tailor. This prompts us to experiment with building an ERP on top of a NoSQL database, which intends to be more flexible, as it is based on JSON and not on a relational data model. We present a novel ERP solution specifically designed to grow and evolve as the world changes. The ERP is for a service company which bills for time spent on customer projects. The work involves various challenges: data modelling, query specification, write and read performance analysis, versioning, user interface generation and query optimisation. Here, we report on the performance of a NoSQL ERP using MongoDB and show that writes are fast and queries and reports are fast enough.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

inform now
previous chapter Application of Sound of Kobyz in Online Therapy and Health Improvement
next chapter Models for Estimation of Concrete Compressive Strength Based on Experimental Research with Destructive and Non-destructive Methods
Literature
1.
Aboutorabi SH, Rezapour M, Moradi M, Ghadiri N (2015) Performance evaluation of SQL and MongoDB databases for big e-commerce data. In: 2015 international symposium on computer science and software engineering (CSSE), pp 1–7
2.
Andreoli R, Cucinotta T, Pedreschi D (2021) RT-MongoDB: a NoSQL database with differentiated performance. In: Proceedings of 11th international conference on cloud computing and services science, CLOSER’21, SCITEPRESS, pp 77–86
3.
Barth C, Koch S (2019) Critical success factors in ERP upgrade projects. Ind Manag Data Syst 119(3):656–675CrossRef
4.
Cayres LU, de Lima BS, Garcia RE, Correia RCM (2020) Analysis of Node.js application performance using MongoDB drivers. In: Information technology and systems: proceedings of ICITS, vol 1137 of advances in intelligent systems and computing. Springer, Berlin, pp 213–222
5.
Daly D (2021) Creating a virtuous cycle in performance testing at MongoDB. In: ICPE’21: ACM/SPEC international conference on performance engineering (ICPE). ACM, pp 33–41
6.
Daly D (2021) Performance engineering and database development at MongoDB. In: ICPE’21: ACM/SPEC international conference on performance engineering (ICPE). ACM, p 129
7.
Davoudian A, Chen L, Liu M (2018) A survey on NoSQL stores. ACM Comput Surv 51:2 Apr
8.
De Michelis G, Dubois E, Jarke M, Matthes F, Mylopoulos J, Schmidt JW, Woo C, Yu E (1998) A three-faceted view of information systems. Commun ACM 41(12):64–70 DecCrossRef
9.
10.
Gibson N, Holland CP, Light B (1999) Enterprise resource planning: a business approach to systems development. In: 32nd annual Hawaii international conference on system sciences HICSS-32. IEEE Computer Society
11.
Guerrero S (2021) Consuming data in Fiori Applications. In: Custom Fiori Applications in SAP HANA. Springer, Berlin, pp 37–80
12.
Huang C, Cahill MJ, Fekete AD, Röhm U (2020) Deciding when to trade data freshness for performance in MongoDB-as-a-service. In: 36th international conference on data engineering, ICDE’20. IEEE, pp 1934–1937
13.
Huang Q, Rahim MM, Foster S, Anwar M (2021) Critical success factors affecting implementation of cloud ERP systems: a systematic literature review with future research possibilities. In: 54th Hawaii international conference on system sciences, HICSS 2021. ScholarSpace, pp 1–10
14.
Idreos S, Callaghan M (2020) Key-value storage engines. In: Proceedings of 2020 ACM SIGMOD international conference on management of data, SIGMOD ’20, ACM, pp 2667–2672
15.
Ingo H, Daly D (2020) Automated system performance testing at MongoDB. In: Proceedings of 8th international workshop on testing database Systems, DBTest@SIGMOD 2020. ACM, pp 3:1–3:6
16.
Kamsky A (2019) Adapting TPC-C benchmark to measure performance of multi-document transactions in MongoDB. Proc VLDB 12(12):2254–2262CrossRef
17.
Kim RY (2020) The impact of COVID-19 on consumers: Preparing for digital sales. IEEE Eng Manag Rev 48(3):212–218CrossRef
18.
Liu ZH, Hammerschmidt B, McMahon D, Chang H, Lu Y, Spiegel J, Sosa AC, Suresh S, Arora G, Arora V (2020) Native JSON datatype support: maturing SQL and NoSQL convergence in Oracle database. Proc VLDB 13(12):3059–3071CrossRef
19.
Llano-Ríos TF, Khalefa M, Badia A (2020) Experimental comparison of relational and NoSQL document systems: the case of decision support. In: Performance Evaluation and Benchmarking—12th TPC technology conference, TPCTC’20, vol 12752 of LNCS. Springer, Berlin, pp 58–74
20.
Lu F, Fang T, Zhang Z, Li S, Chen J, An H, Han W (2019) Improving the performance of MongoDB with RDMA. In: 17th IEEE international conference on smart City; 5th IEEE international conference on data science and systems, HPCC/SmartCity/DSS19. IEEE, pp 1004–1010
21.
Makris A, Tserpes K, Spiliopoulos G, Anagnostopoulos D (2019) Performance evaluation of MongoDB and PostgreSQL for spatio-temporal data. In: Proceedings of workshops of EDBT/ICDT’19, vol 322 of CEUR Workshop Proceeings
22.
Marimuthu T, van der Merwe A, Gerber A (2021) Systematic literature review of essential enterprise architecture management dimensions. In Proceedings of 6th international congress on information and communication technology—ICICT’21, vol 1, vol 235 of LNCS. Springer, Berlin, pp 381–391
23.
Meier A, Kaufmann M (2019) SQL and NoSQL databases. Springer, Berlin
24.
25.
26.
27.
Parker Z, Poe S, Vrbsky SV (2013) Comparing NoSQL MongoDB to an SQL DB. In: ACM Southeast regional conference 2013, SE’13. ACM, pp 5:1–5:6
28.
Ravat, F, Song J, Teste O, Trojahn C (2020) Efficient querying of multidimensional RDF data with aggregates: comparing NoSQL, RDF and relational data stores. Int J Inf Manag 54:102089
29.
Senaya SK, van der Poll JA, Schoeman M (2022) Towards a framework to address enterprise resource planning (ERP) challenges. In: Proceedings of 6th international congress on information and communication technology. Springer, Berlin, pp 57–71
30.
Soransso RASN, Cavalcanti MC (2018) Data modeling for analytical queries on document-oriented DBMS. In: Proceedings of 33rd annual ACM symposium on applied Computing, SAC’18, pp 541–548
31.
van Beijsterveld JA, Van Groenendaal WJ (2016) Solving misfits in ERP implementations by SMEs. Inf Syst J 26(4):369–393CrossRef
32.
Wang J, Trummer I, Basu D (2021) UDO: universal database optimization using reinforcement learning. Proc VLDB 14(13):3402–3414CrossRef
Metadata
Title
Building a NoSQL ERP
Authors
Ela Pustulka
Stefan von Arx
Lucia de Espona
Copyright Year
2023
Publisher
Springer Nature Singapore
Book
Proceedings of Seventh International Congress on Information and Communication Technology

Print ISBN: 978-981-19-1609-0

Electronic ISBN: 978-981-19-1610-6

Copyright Year: 2023

DOI
https://doi.org/10.1007/978-981-19-1610-6_59