The Connection Between the Relational Model and ERP Systems: a Financial Approach
Suoranta, Riikka (2023)
2023
All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2023051510837
https://urn.fi/URN:NBN:fi:amk-2023051510837
Tiivistelmä
This qualitative literature review aims to discover and present the connection between the relational data model and enterprise resource planning systems through a financial viewpoint, discussing to which extent finance professionals are also data professionals. In the ever-evolving world of information technology and data, roles and business operations are constantly changing and expanding. The expanding growth of data and need for data-analytics also affects the roles of finance professionals, and their contributions to companies.
The theoretical framework aims to explain theories and concepts like information technology (IT), data, the relational data model, relational data base management systems (RDBMS), enterprise resource planning (ERP) systems and SQL as simply as possible and in connection to the functional business process of accounting and finance. The majority of the theoretical frame- work is built based on peer-reviewed journal articles. In addition, some books and web sources are used. The sources were gathered from several different journals and databases. Information technology, system architecture, relational theory and programming languages can be difficult and highly technical subjects for beginners. This review aims to simplify these subjects so that even people perhaps learning about the relational model for the first time, could understand them easily.
ERP systems are integrated information technology systems that are crucial for the data integration and performance of a thriving business. But what is their role in financial transactions, and how much does the database in the system actually matter and affect the work or finance professionals? Business operations include a lot of financial transactions, that revolve around transactional data. Relational databases, based on the relational model dating back to 1970, are still a prevalent database choice for ERP systems today. A computer language SQL can be used to query and modify those databases. All of these subjects have a closer connection than what might seem obvious at first glance. By exploring and explaining this connection, the author aims to provide deeper insight for people already working with a relational database, as well as starting finance professionals simply interested in the growing world of data and computer sciences.
The theoretical framework aims to explain theories and concepts like information technology (IT), data, the relational data model, relational data base management systems (RDBMS), enterprise resource planning (ERP) systems and SQL as simply as possible and in connection to the functional business process of accounting and finance. The majority of the theoretical frame- work is built based on peer-reviewed journal articles. In addition, some books and web sources are used. The sources were gathered from several different journals and databases. Information technology, system architecture, relational theory and programming languages can be difficult and highly technical subjects for beginners. This review aims to simplify these subjects so that even people perhaps learning about the relational model for the first time, could understand them easily.
ERP systems are integrated information technology systems that are crucial for the data integration and performance of a thriving business. But what is their role in financial transactions, and how much does the database in the system actually matter and affect the work or finance professionals? Business operations include a lot of financial transactions, that revolve around transactional data. Relational databases, based on the relational model dating back to 1970, are still a prevalent database choice for ERP systems today. A computer language SQL can be used to query and modify those databases. All of these subjects have a closer connection than what might seem obvious at first glance. By exploring and explaining this connection, the author aims to provide deeper insight for people already working with a relational database, as well as starting finance professionals simply interested in the growing world of data and computer sciences.