Object-Relational Mapping in Python: Benefits and Drawbacks Analysis

This report provides an in-depth analysis of object-relational mapping (ORM) in Python, with a specific focus on Django's implementation. It explores the core concepts of ORM, which involves converting data between incompatible type systems using object-oriented programming languages. The report ...Read More

Running head: ADVANCE COMPUTER SCIENCE RESEARCH
ADVANCE COMPUTER SCIENCE RESEARCH
Name of the Student:
Name of the University:
Author Note:

1ADVANCE COMPUTER SCIENCE RESEARCH
Object relational mapping in python
Object relational mapping is the programming technique to convert data among
incompatible kind systems by using languages of object orientated programming such as python.
It creates virtual object database which could be used in programming language. Both
commercial and free packages are there which are available for performing object relational
mapping (Song, et al., 2016). Within object oriented programming, tasks of data management act
on the objects which are always almost non scalar values. One of the applications of object
relational mapping is Django.
Django’s one of most useful features is object relational mapper (ORM) that enables in
making interaction with database. ORM of Django is pythonical way for creating SQL for query
along with manipulate the database as well as get the results in pythonic fashion. It is actually
smart engineering which takes advantages of few of Python’s more complicated parts for making
lives of developers easier. ORM of Django is amazing implementation for increasing the
development speed. Main goal of ORM of Django is transmitting data among application model
and relational database (Bucher, et al., 2019). ORM automates the transmission, so that it is not
required to write SQL by the developer. ORM of Django maps the objects attributes for
respective fields of tables. It could retrieve data also in such manner. It makes whole process of
development fast as well as error free. The attributes of the objects are stored automatically
within corresponding fields. ORM automatically would create as well as store object data within
the database.
There are certain benefits of ORM of Django over traditional approach. ORMs’ major
advantage is providing rapid development. Django’s ORM make the projects much more

2ADVANCE COMPUTER SCIENCE RESEARCH
portable. This is easier in changing database if ORMs are used. Web developers are required in
having knowledge of the databases too. Database is essential component from start. Objects and
classes are used by programming languages used for the web development for interpretation of
data. There is use of class in data structure within web applications. Knowledge of SQL is not
enough also since implementations of SQL differ slightly from each other within different
databases (Mele, 2018). It became time consuming and difficult task. Hence, for resolving this,
ORM’s concept is introduced within web frameworks. Django’s ORMs create schema
automatically from the defined models or classes. SQL is generated by them from the python
code for specific database. Django’s ORMs let developers create project by using one language
which means python.
Django is dispatched with own ORM. This is quite efficient OPM as well as is coupled
tightly with Django framework. ORM of Django is suitable to handle complexity queries of low
medium. Django’s migrations features is part of ORM of Django also. There are several benefits
of ORM engulfing the migrations as well as Querysets. Django is only framework that is
complete (Marani, 2018). This is choice of developer totally. Though there are ORM’s certain
benefits, there are few downsides too. This is beneficial to developers as this allows quicker
development. Sometimes much complicated queries are generated by ORMs of Django than they
should. It could result in decrease of performance. Hence, this is totally choice of developer as
well as work level they are performing. ORMs of Django make this theoretically possible in
switching application among several relational databases.
ORMs of Django has the capability to write codes of python in place of SQL could speed
up development of web application, especially at starting of project. While few software
developers might not mind in switching forth and back among languages, it is easier in knocking

3ADVANCE COMPUTER SCIENCE RESEARCH
out prototype or begin web application by using one programming language. ORM libraries of
python are not needed to access the relational databases. Access of low level is provided
typically by other library known as database connector like MySQL-python and psycopg. ORMS
of Django are quite easy often to try, however quite tough to master (Dauzon, Bendoraitis &
Ravindran, 2016). In Django, model is object which is mapped with database. While creating
model, SQL is executed by Django for creating corresponding table within database, without
writing single code of SQL. Table name is prefixed with Django with name of Django
application.
ORMs of Django provide abstraction level that makes this easy in working with the
objects. ORM would relate attributes of objects to the corresponding fields of table
automatically. ORM of Django could create models through pasting code in the application’s
models.py (Mendonça, et al., 2018). There is addition of Django migrations in Django projects
version 1.7, which is deprecated now and merged in Django. The migrations could be tricky for
the developer. Django is used for linking code with the data.

4ADVANCE COMPUTER SCIENCE RESEARCH
References
Bucher, E., Claunch, C. J., Hee, D., Smith, R. L., Devlin, K., Thompson, W., ... & Heiser, L. M.
(2019). Annot: a Django-based sample, reagent, and experiment metadata tracking
system. BMC bioinformatics, 20(1), 1-6.
Dauzon, S., Bendoraitis, A., & Ravindran, A. (2016). Django: Web Development with Python.
Packt Publishing Ltd.
Marani, F. (2018). Practical Django 2 and Channels 2: Building Projects and Applications with
Real-Time Capabilities. Apress.
Mele, A. (2018). Django 2 by Example: Build powerful and reliable Python web applications
from scratch. Packt Publishing Ltd.
Mendonça, D. S., da Silva, T. G., de Oliveira, D. F., Brandão, J. S., Lopes, H., Barbosa, S. D., ...
& von Staa, A. (2018, October). Applying pattern-driven maintenance: a method to
prevent latent unhandled exceptions in web applications. In Proceedings of the 12th
ACM/IEEE International Symposium on Empirical Software Engineering and
Measurement (pp. 1-10).
Song, C., Huo, R., Wang, S., & Lv, C. (2019, November). Transformer Equipment Temperature
Monitoring Based on the Network Framework of Django. In 2019 Chinese Automation
Congress (CAC) (pp. 4594-4597). IEEE.