Relational-Object Mapping of Databases
Abstract
Mapping relational databases is a programming technique that enables developers to interact with the database using objects, which are instances of classes defined in a specific programming language. Objectives: This paper proposes a scientific method based on several rules in order to transform the logic layer of a relational database into an object model formalized in a class diagram. Prior Work: This research is based on C.J. Date logic and relational approach to modeling relational databases. Approach: We are using the high-level Microsoft C# object-oriented programming language in order to implement the object model of a classic transactional database employing a set of rules and a specific library for serializing collections of objects for a dedicated (MongoDB) persistence layer, Results: the JSON serialized form of the objects is further used to generate new instances according to the business application layer. Implications: The back & forward transformations without information loss by serializing and deserializing objects according to a predefined data scheme validate the methodology proposed by this paper. Value: The importance of our research resides in the plenitude of source code utilized for exemplifying our methodology and the diversity of real-life situations that might benefit our research in terms of efficiency and consistent data management.
References
Church, A. (1996). Introduction to Mathematical Logic. Princeton: Princeton University Press.
Russell, B. (2009). Our Knowledge of the External World. London: Taylor & Francis.
Wittgenstein, L. (2001). Tractatus Logico-Philosophicus. Boca Raton: Routledge.
Downloads
Published
Issue
Section
License
Copyright (c) 2024 EIRP Proceedings
This work is licensed under a Creative Commons Attribution 4.0 International License.
You are free to:
- Share — copy and redistribute the material in any medium or format
- Adapt — remix, transform, and build upon the material
- for any purpose, even commercially.
- The licensor cannot revoke these freedoms as long as you follow the license terms.
Under the following terms:
-
Attribution — You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.