IDEAS home Printed from https://ideas.repec.org/a/spr/infsem/v20y2022i3d10.1007_s10257-022-00555-6.html
   My bibliography  Save this article

A proposal for future data organization in enterprise systems—an analysis of established database approaches

Author

Listed:
  • Benedict Bender

    (University of Potsdam)

  • Clementine Bertheau

    (University of Potsdam)

  • Tim Körppen

    (University of Potsdam)

  • Hannah Lauppe

    (University of Potsdam)

  • Norbert Gronau

    (University of Potsdam)

Abstract

The digital transformation sets new requirements to all classes of enterprise systems in companies. ERP systems in particular, which represent the dominant class of enterprise systems, are struggling to meet the new requirements at all levels of the architecture. Therefore, there is an urgent need to reconsider the overall architecture of the systems and address the root of the related issues. Given that many restrictions ERP pose on their adaptability are related to the standardization of data, the database layer of ERP systems is addressed. Since database serve as the foundation for data storage and retrieval, they limit the flexibility of enterprise systems and the chance to adapt to new requirements accordingly. So far, relational databases are widely used. Using a systematic literature approach, recent requirements for ERP systems were identified. Prominent database approaches were assessed against the 23 requirements identified. The results reveal the strengths and weaknesses of recent database approaches. To this end, the results highlight the demand to combine multiple database approaches to fulfill recent business requirements. From a conceptual point of view, this paper supports the idea of federated databases which are interoperable to fulfill future requirements and support business operation. This research forms the basis for renewal of the current generation of ERP systems and proposes to ERP vendors to use different database concepts in the future.

Suggested Citation

  • Benedict Bender & Clementine Bertheau & Tim Körppen & Hannah Lauppe & Norbert Gronau, 2022. "A proposal for future data organization in enterprise systems—an analysis of established database approaches," Information Systems and e-Business Management, Springer, vol. 20(3), pages 441-494, September.
  • Handle: RePEc:spr:infsem:v:20:y:2022:i:3:d:10.1007_s10257-022-00555-6
    DOI: 10.1007/s10257-022-00555-6
    as

    Download full text from publisher

    File URL: http://link.springer.com/10.1007/s10257-022-00555-6
    File Function: Abstract
    Download Restriction: Access to the full text of the articles in this series is restricted.

    File URL: https://libkey.io/10.1007/s10257-022-00555-6?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Marina V. Sokolova & Francisco J. Gómez & Larisa N. Borisoglebskaya, 2020. "Migration from an SQL to a hybrid SQL/NoSQL data model," Journal of Management Analytics, Taylor & Francis Journals, vol. 7(1), pages 1-11, January.
    2. Jan Brocke & Wolfgang Maaß & Peter Buxmann & Alexander Maedche & Jan Marco Leimeister & Günter Pecht, 2018. "Future Work and Enterprise Systems," Business & Information Systems Engineering: The International Journal of WIRTSCHAFTSINFORMATIK, Springer;Gesellschaft für Informatik e.V. (GI), vol. 60(4), pages 357-366, August.
    3. Avner Engel & Tyson R. Browning, 2008. "Designing systems for adaptability by means of architecture options," Systems Engineering, John Wiley & Sons, vol. 11(2), pages 125-146, June.
    4. Panos Vassiliadis, 2009. "A Survey of Extract–Transform–Load Technology," International Journal of Data Warehousing and Mining (IJDWM), IGI Global, vol. 5(3), pages 1-27, July.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Benedikt Berger & Martin Adam & Alexander Rühr & Alexander Benlian, 2021. "Watch Me Improve—Algorithm Aversion and Demonstrating the Ability to Learn," Business & Information Systems Engineering: The International Journal of WIRTSCHAFTSINFORMATIK, Springer;Gesellschaft für Informatik e.V. (GI), vol. 63(1), pages 55-68, February.
    2. Sungchul Kim & Ronald Giachetti & Sangsung Park, 2018. "Real Options Analysis for Acquisition of New Technology: A Case Study of Korea K2 Tank’s Powerpack," Sustainability, MDPI, vol. 10(11), pages 1-18, October.
    3. Michel‐Alexandre Cardin & Mehdi Ranjbar‐Bourani & Richard de Neufville, 2015. "Improving the Lifecycle Performance of Engineering Projects with Flexible Strategies: Example of On‐Shore LNG Production Design," Systems Engineering, John Wiley & Sons, vol. 18(3), pages 253-268, May.
    4. Miranda Reed-Grice & Brandon E. Ross, 2024. "Application of the Black–Scholes Financial Model to Support Adaptability as a Sustainability Strategy for Buildings: A Case Study of an Adaptable Campus Parking Garage," Sustainability, MDPI, vol. 16(7), pages 1-19, March.
    5. Zhan, Yuanzhu & Tan, Kim Hua, 2020. "An analytic infrastructure for harvesting big data to enhance supply chain performance," European Journal of Operational Research, Elsevier, vol. 281(3), pages 559-574.
    6. Tyson R. Browning & Eric C. Honour, 2008. "Measuring the life‐cycle value of enduring systems," Systems Engineering, John Wiley & Sons, vol. 11(3), pages 187-202, September.
    7. Ulrich Gnewuch & Stefan Morana & Marc T. P. Adam & Alexander Maedche, 2022. "Opposing Effects of Response Time in Human–Chatbot Interaction," Business & Information Systems Engineering: The International Journal of WIRTSCHAFTSINFORMATIK, Springer;Gesellschaft für Informatik e.V. (GI), vol. 64(6), pages 773-791, December.
    8. Lawson, James G. & Street, Daniel A., 2021. "Detecting dirty data using SQL: Rigorous house insurance case," Journal of Accounting Education, Elsevier, vol. 55(C).
    9. Plattfaut, Ralf & Koch, Julian, 2021. "Preserving the legacy – Why do professional soccer clubs (not) adopt innovative process technologies? A grounded theory study," Journal of Business Research, Elsevier, vol. 136(C), pages 237-250.
    10. Emanuel Stoeckli & Christian Dremel & Falk Uebernickel & Walter Brenner, 2020. "How affordances of chatbots cross the chasm between social and traditional enterprise systems," Electronic Markets, Springer;IIM University of St. Gallen, vol. 30(2), pages 369-403, June.
    11. Jessica Ryan & Shahram Sarkani & Thomas Mazzuchi, 2014. "Leveraging Variability Modeling Techniques for Architecture Trade Studies and Analysis," Systems Engineering, John Wiley & Sons, vol. 17(1), pages 10-25, March.
    12. Eun Suk Suh & Michael R. Furst & Kenneth J. Mihalyov & Olivier de Weck, 2010. "Technology infusion for complex systems: A framework and case study," Systems Engineering, John Wiley & Sons, vol. 13(2), pages 186-203, June.
    13. Ulrich Gnewuch & Marcel Ruoff & Christian Peukert & Alexander Maedche, 2022. "Multiexperience," Business & Information Systems Engineering: The International Journal of WIRTSCHAFTSINFORMATIK, Springer;Gesellschaft für Informatik e.V. (GI), vol. 64(6), pages 813-823, December.
    14. Eun Suk Suh & Noemi Chiriac & Katja Hölttä‐Otto, 2015. "Seeing Complex System through Different Lenses: Impact of Decomposition Perspective on System Architecture Analysis," Systems Engineering, John Wiley & Sons, vol. 18(3), pages 229-240, May.
    15. David Gil & Magnus Johnsson & Higinio Mora & Julian Szymanski, 2019. "Advances in Architectures, Big Data, and Machine Learning Techniques for Complex Internet of Things Systems," Complexity, Hindawi, vol. 2019, pages 1-3, March.
    16. Benedikt Simmert & Philipp Alexander Ebel & Christoph Peters & Eva Alice Christiane Bittner & Jan Marco Leimeister, 2019. "Conquering the Challenge of Continuous Business Model Improvement," Business & Information Systems Engineering: The International Journal of WIRTSCHAFTSINFORMATIK, Springer;Gesellschaft für Informatik e.V. (GI), vol. 61(4), pages 451-468, August.
    17. Jan-jaap Moerman & Seppe van Heusden & Brigitte Matheussen & Alberto Martinetti, 2022. "Encouraging a Modal Shift to Passenger Railway Transportation: A Case Study in Adaptable Rolling Stock Interior Design," Sustainability, MDPI, vol. 14(15), pages 1-17, August.
    18. Alberto Sols & Javier Romero & Robert Cloutier, 2012. "Performance‐based logistics and technology refreshment programs: Bridging the operational‐life performance capability gap in the Spanish F‐100 frigates," Systems Engineering, John Wiley & Sons, vol. 15(4), pages 422-432, December.
    19. Avner Engel & Yoram Reich, 2015. "Advancing Architecture Options Theory: Six Industrial Case Studies," Systems Engineering, John Wiley & Sons, vol. 18(4), pages 396-414, July.
    20. Alessandro Golkar & Edward F. Crawley, 2014. "A Framework for Space Systems Architecture under Stakeholder Objectives Ambiguity," Systems Engineering, John Wiley & Sons, vol. 17(4), pages 479-502, December.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:spr:infsem:v:20:y:2022:i:3:d:10.1007_s10257-022-00555-6. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Sonal Shukla or Springer Nature Abstracting and Indexing (email available below). General contact details of provider: http://www.springer.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.