Improved Presentation and Facade Layer Operations for Software Engineering Projects

  • Dr. Yunus Doğan
  • Hasan Gezer
  • Serdar Yılmaz
Keywords: Distributed Systems, Impedance Mismatch, N-Tier Architecture, Object Relational Mapping, Reverse Engineering

Abstract

Nowadays, one of the most challenging situations for software developers is the presence of a mismatch between relational database systems and programming codes. In the literature, this problem is defined as "impedance mismatch". This study is to develop a framework built on innovations based on the existing Object Relational Mapping technique to solve these problems. In the study, users can perform operations for three different database systems such as MsSQL, MySql and Oracle.  In addition, these operations can be done within the framework of C# and Java programming languages. In this framework, while the developers can define database tables in the interface automatically, they can create relations between tables by defining a foreign key. When the system performs these operations, it creates tables, views, and stored procedures automatically. In addition, entity classes in C# and Java for tables and views, and operation classes for stored procedures are created automatically. The summary of the transactions can be taken as pdf file by the framework. In addition, the project can automatically create Windows Communication Foundation classes to facilitate the handling of database elements created and the interfacing operations, as well. This framework, which supports distributed systems, can be downloaded at this link.

Downloads

Download data is not yet available.

References

Paulic M., Irgolic T., Balic J., Cus F., Cupar A., Brajlih T., & Drstvensek I. (2014). Reverse engineering of parts with optical scanning and additive manufacturing. Procedia Engineering, 69, 795-803.

T.A. Nguyen. (2015). Tools for program understanding and reverse-engineering of mobile applications. Available at: https://rc.library.uta.edu/uta-ir/bitstream/handle/10106/26733/Nguyen_uta_2502D_13260.pdf?sequence=1.

Jing L.U. (2006). Comment on N tier architecture based on. net. Computer Engineering and Design, 27, 3467-3469.

Płuciennik-Psota E. & Płuciennik T. (2013). Using object database as a cache for relational database-performance and usage considerations. Studia Informatica, 34,145-60.

H. Garcia-Molina, J.D. Ullman, & J. Widom. (2000). Database system implementation. Upper Saddle River, New Jersey, USA: Prentice Hall.

J.D. Ullman & J. Widom. (2007). A first course in database systems. (3rd ed.). Upper Saddle River, New Jersey, USA: Prentice Hall.

Ambler S.W. (2000). Mapping objects to relational databases. Available at: http://tiopf.sourceforge.net/Doc/Concepts/mappingObjects.pdf.

M. Keith & M. Schincariol. (2013). Introduction. In: Pro JPA 2. California, USA: Apress, 1-14.

Alghamdi A., Owda M. & Crockett K. (2017). Natural language interface to relational database through object relational mapping. Advances in Computational Intelligence Systems, Lancaster, 449-464.

Lorenz M., Rudolph J.P., Hesse G., Uflacker M., & Plattner H. (2017). Object-relational mapping revisited-a quantitative study on the impact of database technology on O/R mapping strategies. The 50th Hawaii International Conference on System Sciences, Hawaii, 4877-4886.

Lieponienė J. & Šlenderis L. (2016). Computer sciences. The 58th International Scientific Conference of Daugavpils University, Daugavpils, 189-198.

Hamilton D. & Pape P. (2017). 20 Years after the Mandate. CrossTalk, 14-16.

Torres A., Galante R., Pimenta M.S., & Martins, A.J.B. (2017). Twenty years of object-relational mapping: A survey on patterns, solutions, and their implications on application design. Information and Software Technology, 82, 1-18.

Lukyanchikov O., Payain S., Pluzhnik E., & Nikulchev E. (2014). Using object-relational mapping to create the distributed databases in a hybrid cloud infrastructure. IJACSA: International Journal of Advanced Computer Science and Applications, 5, 61-64.

Cho J., Kang H., & Kim S. (2015). A mobile application development tool based on object relational mapping solution. Indian Journal of Science and Technology, 8, 1-5.

Hule K. & Shaikh Z. (2014). Object relational mapping tool for c#.net framework. IJIRSET: International Journal of Innovative Research in Science, Engineering and Technology, 3, 15185-15191.

Cvetković S.S., Bogdanović M.D. & Stoimenov L.V. (2011). NHibernate Mapper – A tool for rapid development of data access layer for interoperable GIS solutions. Faculty of Electrical Engineering University of Banja Luka, 15, 62-66.

Blakeley A.J., Campbell D., Muralidhar S., & Nori A. (2006). The ADO.NET entity framework: Making conceptual level real. ACM SIGMOD Record, 35, 31-38.

Papa J. (2007). Data points- ADO.NET entity framework overview. MSDN Magazine-Louisville, 25-34.

Borys M. & Panczyk B. (2015). Improving data processing performance for web applications using object-relational mapping. Actual Problems in Economics, 1, 387-395.

Published
2019-10-31
How to Cite
Dr. Yunus Doğan, Hasan Gezer, & Serdar Yılmaz. (2019). Improved Presentation and Facade Layer Operations for Software Engineering Projects. International Journal of Engineering and Management Research, 9(5), 65-72. https://doi.org/10.31033/ijemr.9.5.11