Abstract
RDBMS enables the software systems to manipulate data from a database. Among all the database systems that exist, relational database systems take the major share of the market. Mostly, ER diagrams are used for modeling of RDBMS in design phase. In software applications, application layer is the object-oriented programming language, and RDBMS acts as the backend store. Mostly, UML is being used to model the application layer and ER diagram to model the RDBMS. Modeling of these layers separately creates inconsistency for the developers. Modeling these layers using a single notation, i.e., UML will bridge the gap. Modeling RDBMS using UML to incorporate the database schema as well as the operations to be performed on it. The entire RDBMS information could be scattered across the UML model. Enhancement in the modeling practice will be there using UML as standard for modeling of both layers and proposing new constructs at modeling level for RDBMS. The proposed method identifies different aspects in RDBMS which needs to be captured using UML. The representation of entire relational database system, its components and relationship between them is done using different diagrams in UML. The relationship between entities (tables in RDBMS) is identified based upon some constraints. The proposed method identifies the weaknesses in RDBMS modeling that has been done till now and extracts ways to overcome those weaknesses and propose new constructs at modeling level for RDBMS.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Balsters H (2003) Modelling database views with derived classes in the UML/OCL-Framework. In: UML, LNCS, vol 2863, pp 295–309
Ray I, Shuxin Yin (2005) Relational database operations modeling with UML. In 2013 IEEE 27th international conference on advanced information networking and applications (AINA). Taipei, Taiwan, pp 927–932
Attaran H, Far AH (2011) A novel technique for object oriented relational database design. In: IEEE 10th international conference on Cybernetic Intelligent Systems (CIS), IEEE
Sinha BR et al (2013) Database modeling with object relationship schema. In: International conference on Information Technology Based Higher Education and Training (ITHET), IEEE
Al-Fedaghi S (2014) Unified representation for object oriented and relational models. In: 11th International conference on electrical engineering/electronics, computer, telecommunications and information technology (ECTI-CON), IEEE
Lo C-M, Hung H-Y (2014) Towards a UML profile to relational database modeling. Appl Math 8(2):733–743
Lee S (2012) Unified Modeling Language (UML) for database systems and computer applications. Int J Database Theory Appl 5(1)
Nikose Ms MC, Dhande SS, Bamnote GR (2012) Query optimization in object oriented databases through detecting independent subqueries. Int J Adv Res Comput Sci Software Eng 2(2)
Albert M, Cabot J, Gómez C, Pelechano V (2011) Generating operation specifications from UML class diagrams: a model transformation approach. Data Knowl Eng 70:365–389
De Lucia A et al (2008) Data model comprehension: an empirical comparison of ER and UML class diagrams. In: The 16th IEEE International Conference on Program Comprehension (ICPC), IEEE
Song E, Yin S, Ray I (2007) Using UML to model relational database operations. Comput Stand Interfaces 29:343–354
Fakhar L, Muhammad AG (2007) Design of a simple and effective object-to-relational mapping technique. In: Proceedings of the 2007 ACM symposium on applied computing, pp 1445–1449
Akhtar N, Iftekhar N, Varshneya S (2015) Online profile maker. In: IEEE International Conference on Electrical, Computer and Communication Technologies (ICECCT), IEEE
Iftekhar N et al (2019) Reverse engineering of relational database schema to UML Model. In: International conference on electrical, electronics and computer engineering (UPCON), IEEE
Demuth B, Hussmann H (1999) Using UML/OCL constraints for relational database design. In: «UML»’99—The unified modeling language. Springer, Berlin, pp 598–613
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2021 The Author(s), under exclusive license to Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Iftekhar, N., Warsi, M.R., Zafar, S., Khan, S., Biswas, S.S. (2021). A Neoteric Approach for Modeling and Conversion of RDBMS Using UML. In: Abraham, A., Castillo, O., Virmani, D. (eds) Proceedings of 3rd International Conference on Computing Informatics and Networks. Lecture Notes in Networks and Systems, vol 167. Springer, Singapore. https://doi.org/10.1007/978-981-15-9712-1_25
Download citation
DOI: https://doi.org/10.1007/978-981-15-9712-1_25
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-15-9711-4
Online ISBN: 978-981-15-9712-1
eBook Packages: EngineeringEngineering (R0)