Comparative
analysis
of
the
efficiency
of
Data
P
e
r
s
i
s
t
e
n
c
e
F
r
a
m
e
w
o
r
k
s
.
C
a
s
e
s
t
u
d
y
H
i
b
e
r
n
a
t
e
5.4
and
MyBatis
3.4
A
b
s
t
r
a
c
t
.
-
T
h
e
o
b
j
e
c
t
i
v
e
o
f
t
h
e
s
t
u
d
y
w
a
s
t
o
d
e
t
e
r
m
i
n
e
w
h
e
t
h
e
r
H
i
b
e
r
n
a
t
e
5
.
4
o
r
M
y
B
a
t
i
s
3
.
4
i
s
t
h
e
m
o
s
t
efficient
in
terms
of
time,
RAM,
and
CPU
usage.
Two
REST
microservices
were
implemented
to
perform
CRUD
o
p
e
r
a
t
i
o
n
s
;
w
h
i
c
h
w
e
r
e
a
c
c
e
s
s
e
d
b
y
R
E
S
T
s
e
r
v
i
c
e
s
d
e
v
e
l
o
p
e
d
w
i
t
h
H
i
b
e
r
n
a
t
e
a
n
d
M
y
B
a
t
i
s
i
n
v
o
k
e
d
f
r
o
m
a
client.
Our
results
were
that
Hibernate
was
the
most
efficient
with
respect
to
processing
time
at
509.1%
and
4
7
.
7
%
f
o
r
s
e
l
e
c
t
a
n
d
d
e
l
e
t
e
q
u
e
r
i
e
s
,
w
h
i
l
e
M
y
b
a
t
i
s
w
a
s
a
t
1
2
.
7
%
a
n
d
1
4
.
2
%
f
o
r
u
p
d
a
t
e
a
n
d
i
n
s
e
r
t
q
u
e
r
i
e
s
,
correspondingly.
Regarding
the
use
of
RAM
and
CPU,
MyBatis
was
determined
to
be
the
most
efficient
at
55.2%
and
20%
respectively.
Keywords:
Data
persistence
framework,
comparative
analysis,
Hibernate,
MyBatis.
I
S
S
N
-
E
:
2
5
4
2
-
3
4
0
1
,
I
S
S
N
-
P
:
1
3
1
6
-
4
8
2
1
U
n
i
v
e
r
s
i
d
a
d
,
C
i
e
n
c
i
a
y
T
e
c
n
o
l
o
g
í
a
,
V
o
l
.
2
6
,
N
ú
m
.
1
1
7
,
(
p
p
.
2
4
-
3
2
)
Medoza-Palomino
et al.
Comparative analysis of the efficiency of Data Persistence Frameworks. Case study Hibernate 5.4 and MyBatis 3.4
Yolvis
Luis
Mendoza-Palomino
https://orcid.org/0000-0002-6948-5558
y
o
l
v
i
s
.
m
e
n
d
o
z
a
.
2
7
@
u
n
s
c
h
.
e
d
u
.
p
e
Qualifacts
Lima,
Perú
Resumen.
-
El
objetivo
del
estudio
fue
determinar
si
Hibernate
5.4
o
MyBatis
3.4
es
el
más
eficiente
en
referencia
al
uso
del
tiempo,
la
RAM
y
la
CPU.
Se
implementó
dos
microservicios
REST
para
realizar
operaciones
CRUD;
los
cuales
fueron
accedidos
por
servicios
REST
desarrollados
con
Hibernate
y
MyBatis
invocados
desde
un
cliente.
Nuestros
resultados
fueron
que
Hibernate
fue
el
más
eficiente
respecto
al
tiempo
de
procesamiento
en
un
509.1%
y
47.7%
para
consultas
de
selección
y
eliminación,
mientras
que
Mybatis
en
un
12.7%
y
14.2%
para
consultas
de
actualización
e
inserción,
correspondientemente.
Con
respecto
al
uso
de
la
RAM
y
la
CPU
se
determinó
que
MyBatis
fue
el
más
eficiente
en
un
55.2%
y
20%
respectivamente.
Palabras
clave:
Framework
de
persistencia
de
datos,
análisis
comparativo,
Hibernate,
MyBatis.
Análisis
comparativo
de
la
eficiencia
de
Frameworks
de
persistencia
de
datos,
caso
de
estudio
Hibernate
5.4
y
MyBatis
3.4
24
R
e
c
i
b
i
d
o
(
2
9
/
0
7
/
2
0
2
2
)
,
A
c
e
p
t
a
d
o
(
0
1
/
1
0
/
2
0
2
2
)
Manuel
Avelino
Lagos-Barzola
https://orcid.org/0000-0001-8078-755X
m
a
n
u
e
l
.
l
a
g
o
s
@
u
n
s
c
h
.
e
d
u
.
p
e
Universidad
Nacional
de
San
Cristóbal
de
Huamanga
Ayacucho,
Perú
E
f
r
a
í
n
E
l
í
a
s
P
o
r
r
a
s
F
l
o
r
e
s
h
t
t
p
s
:
/
/
o
r
c
i
d
.
o
r
g
/
0
0
0
0
-
0
0
0
2
-
5
5
6
0
-
0
3
0
8
efrain.porras@unsch.edu.pe
U
n
i
v
e
r
s
i
d
a
d
N
a
c
i
o
n
a
l
d
e
S
a
n
C
r
i
s
t
ó
b
a
l
d
e
H
u
a
m
a
n
g
a
A
y
a
c
u
c
h
o
,
P
e
r
ú
https://doi.org/10.47460/uct.v26i117.657
I. INTRODUCTION
G
i
v
e
n
t
h
e
w
i
d
e
v
a
r
i
e
t
y
o
f
d
a
t
a
p
e
r
s
i
s
t
e
n
c
e
f
r
a
m
e
w
o
r
k
s
,
u
s
u
a
l
l
y
s
o
f
t
w
a
r
e
d
e
v
e
l
o
p
e
r
s
f
a
c
e
d
t
h
e
d
i
l
e
m
m
a
o
f
w
h
i
c
h
f
r
a
m
e
w
o
r
k
t
o
u
s
e
i
n
o
r
d
e
r
t
o
a
c
h
i
e
v
e
t
h
e
i
r
o
b
j
e
c
t
i
v
e
s
i
n
t
e
r
m
s
o
f
s
o
f
t
w
a
r
e
i
m
p
l
e
m
e
n
t
a
t
i
o
n
,
t
h
e
s
h
o
r
t
e
s
t
t
i
m
e
,
a
n
d
t
h
e
h
i
g
h
e
s
t
q
u
a
l
i
t
y
.
T
h
e
s
t
u
d
y
i
n
[
1
]
h
i
g
h
l
i
g
h
t
s
a
n
d
d
e
s
c
r
i
b
e
s
t
h
a
t
t
h
e
o
b
j
e
c
t
-
r
e
l
a
t
i
o
n
a
l
m
a
p
p
i
n
g
(ORM)
solution
is
available
in
many
popular
platforms,
that
offer
useful
tools
allowing
developers
to
be
concerned
about
other
pending
issues.
The
work
in
[2]
indicates
that
among
of
the
most
relevant
aspects
when
choosing
a
framework
are
speed
and
efficiency,
which
may
have
many
issues
due
to
the
diversity
of
metrics
to
measure
the
performance
of
a
f
r
a
m
e
w
o
r
k
.
H
o
w
e
v
e
r
,
t
h
e
r
e
a
r
e
o
t
h
e
r
a
s
p
e
c
t
s
t
h
a
t
c
o
u
l
d
h
e
l
p
t
o
d
e
c
i
d
e
,
s
u
c
h
a
s
t
h
e
r
e
s
p
o
n
s
e
s
p
e
e
d
,
t
h
e
i
n
t
e
g
r
a
t
i
o
n
w
i
t
h
t
h
e
d
a
t
a
b
a
s
e
,
t
h
e
u
s
e
o
f
t
h
e
C
P
U
,
a
n
d
t
h
e
u
s
e
o
f
R
A
M
.
The
study
[3],
concerned
about
data
processing
time,
reported
that
the
Hibernate
framework
slightly
i
n
c
r
e
a
s
e
s
t
h
e
p
r
o
c
e
s
s
i
n
g
t
i
m
e
s
w
h
e
n
c
o
m
p
a
r
e
d
t
o
t
h
e
M
y
B
a
t
i
s
f
r
a
m
e
w
o
r
k
,
i
n
a
n
e
x
p
e
r
i
m
e
n
t
a
t
i
o
n
q
u
e
r
y
automatically
generated
and
variation
of
caching
algorithms.
Similarly,
the
work
in
[4]
compared
Hibernate
against
MyBatis,
concluding
that
Hibernate
outperforms
MyBatis
in
terms
of
available
documentation,
quality,
robustness,
and
easy
learning
curve,
which
makes
it
ideal
for
developing
software
projects.
B
e
c
a
u
s
e
t
h
e
H
i
b
e
r
n
a
t
e
a
n
d
M
y
B
a
t
i
s
f
r
a
m
e
w
o
r
k
s
a
r
e
w
i
d
e
l
y
u
s
e
d
b
y
s
o
f
t
w
a
r
e
d
e
v
e
l
o
p
e
r
s
i
n
J
a
v
a
l
a
n
g
u
a
g
e
programming;
it
is
desirable
to
carry
out
an
evaluation
of
the
efficiency
of
both
frameworks
aiming
to
establish
w
h
i
c
h
c
o
u
l
d
b
e
s
e
l
e
c
t
e
d
a
s
a
f
r
a
m
e
w
o
r
k
f
o
r
a
s
o
f
t
w
a
r
e
d
e
v
e
l
o
p
m
e
n
t
p
r
o
j
e
c
t
.
A
l
t
h
o
u
g
h
p
r
e
v
i
o
u
s
s
t
u
d
i
e
s
t
r
i
e
d
to
establish
which
is
the
best
one,
there
is
a
lack
of
a
deep
study
in
terms
of
time,
RAM,
and
CPU
usage.
In
this
w
o
r
k
,
w
e
p
r
o
v
i
d
e
a
s
t
u
d
y
t
o
d
e
t
e
r
m
i
n
e
w
h
e
t
h
e
r
t
h
e
H
i
b
e
r
n
a
t
e
5
.
4
a
n
d
t
h
e
M
y
B
a
t
i
s
3
.
4
f
r
a
m
e
w
o
r
k
s
i
s
t
h
e
b
e
s
t
one
for
software
development.
II. DEVELOPMENT
A.
Object-relational
mapping
The
study
[5]
established
that
object-relational
mapping
(ORM)
is
a
technique
that
allows
converting
system
data
used
in
an
object-oriented
programming
language,
into
data
used
by
a
relational
database.
Thereby,
ORM
creates
a
virtual
object-oriented
database
over
a
relational
one.
Thus,
allowing
the
use
of
object-oriented
features
such
as
inheritance
and
polymorphism.
The
work
[6]
indicated
that
ORM
refers
to
the
automatic
persistence
of
objects
from
a
Java
application
to
tables
in
a
relational
database
and
that
the
mapping
between
the
objects
and
the
database
is
described
in
metadata,
which
is
used
to
reverse
effects.
Despite
this
advantage,
a
considerable
aspect
to
take
into
account
about
the
use
of
this
technique
is
the
compromise
of
the
performance
of
applications.
Another
study
from
a
developer
perspective
[7],
concluded
that
ORM
encompasses
solutions
for
mapping
business
objects
to
relational
data,
delegating
to
the
persistence
layer
the
details
of
its
persistence.
However,
ORM
is
not
fully
automatic,
and
that
automation
is
indescribable.
B.
Data
persistence
Data
persistence
can
be
understood
as
the
maintenance
of
the
state
of
the
object
as
well
as
its
class,
not
reducing
it
to
any
particular
program
[8].
In
a
more
specific
sense,
data
persistence
is
the
ability
of
a
computer
to
retain
information
even
after
shutting
down
or
closing
the
program
that
uses
that
information
[8],[9].
25
Medoza-Palomino
et al.
Comparative analysis of the efficiency of Data Persistence Frameworks. Case study Hibernate 5.4 and MyBatis 3.4
I
S
S
N
-
E
:
2
5
4
2
-
3
4
0
1
,
I
S
S
N
-
P
:
1
3
1
6
-
4
8
2
1
Universidad,
Ciencia
y
Tecnología,
Vol.
26,
Núm.
117,
(pp.
24-32)
C
.
F
r
a
m
e
w
o
r
k
The
term
framework
is
used
in
many
contexts
[11],
such
as
applications
in
medicine,
computer
vision,
games,
a
n
d
a
m
o
n
g
o
t
h
e
r
s
,
i
n
w
h
i
c
h
i
t
i
s
u
s
e
d
t
o
d
e
s
c
r
i
b
e
a
s
o
f
t
w
a
r
e
s
t
r
u
c
t
u
r
e
c
o
n
s
i
s
t
i
n
g
o
f
a
d
a
p
t
a
b
l
e
a
n
d
interchangeable
components
for
developing
applications.
In
other
words,
a
framework
can
be
thought
of
as
s
o
m
e
t
h
i
n
g
i
n
c
o
m
p
l
e
t
e
,
b
u
t
c
o
n
f
i
g
u
r
a
b
l
e
g
e
n
e
r
i
c
a
p
p
l
i
c
a
t
i
o
n
b
y
m
e
a
n
s
o
f
a
d
d
i
n
g
c
o
m
p
l
e
m
e
n
t
s
.
D.Hibernate
Hibernate
is
a
framework
that
provides
a
complete
solution
to
the
problem
of
data
persistence
in
Java.
By
i
n
t
e
r
a
c
t
i
n
g
b
e
t
w
e
e
n
t
h
e
a
p
p
l
i
c
a
t
i
o
n
a
n
d
t
h
e
r
e
l
a
t
i
o
n
a
l
d
a
t
a
b
a
s
e
,
H
i
b
e
r
n
a
t
e
a
l
l
o
w
s
d
e
v
e
l
o
p
e
r
s
t
o
f
o
c
u
s
o
n
t
h
e
business
problem.
Hibernate
also
enables
us
to
follow
a
lot
of
design
rules
and
specific
patterns
when
creating
persistence
classes
and
business
logic.
Moreover,
Hibernate
furnishes
high
integration
with
most
new
and
e
x
i
s
t
i
n
g
a
p
p
l
i
c
a
t
i
o
n
s
w
i
t
h
o
u
t
t
h
e
n
e
e
d
t
o
m
a
k
e
m
a
j
o
r
c
h
a
n
g
e
s
t
o
o
t
h
e
r
p
a
r
t
s
o
f
t
h
e
a
p
p
l
i
c
a
t
i
o
n
[
6
]
.
F
i
n
a
l
l
y
,
t
h
e
f
r
a
m
e
w
o
r
k
i
s
a
n
o
p
e
n
-
s
o
u
r
c
e
D
a
t
a
P
e
r
s
i
s
t
e
n
c
e
F
r
a
m
e
w
o
r
k
,
e
a
s
i
l
y
c
o
m
b
i
n
e
d
w
i
t
h
H
Q
L
a
n
d
S
Q
L
s
o
f
t
w
a
r
e
[
1
2
]
.
E
.
M
y
B
a
t
i
s
M
y
b
a
t
i
s
i
s
a
n
o
t
h
e
r
p
e
r
s
i
s
t
e
n
c
e
f
r
a
m
e
w
o
r
k
t
h
a
t
s
u
p
p
o
r
t
s
S
Q
L
,
s
t
o
r
e
d
p
r
o
c
e
d
u
r
e
s
,
a
n
d
,
a
d
v
a
n
c
e
d
m
a
p
p
i
n
g
s
.
MyBatis
does
not
require
JDBC
code,
manual
parameter
setting,
and
retrieval
of
results.
MyBatis
can
be
c
o
n
f
i
g
u
r
e
d
w
i
t
h
X
M
L
,
a
n
d
a
n
n
o
t
a
t
i
o
n
s
,
a
n
d
a
l
l
o
w
s
m
a
p
s
a
n
d
P
O
J
O
s
(
P
l
a
i
n
O
l
d
J
a
v
a
O
b
j
e
c
t
s
)
t
o
b
e
m
a
p
p
e
d
t
o
database
records
[13],[14].
F.
Efficiency
Efficiency
is
defined
as
the
characteristic
that
would
allow
evaluation
of
the
relationship
between
the
level
of
performance
of
software
and
the
number
of
resources
used.
The
aspects
to
be
evaluated
would
be
the
time
behavior
related
to
adequate
response
and
processing
times,
that
is
to
say,
the
performance
when
executing
its
function
under
specific
conditions
and,
on
the
other
hand,
the
resource
behavior,
related
to
the
capacity
of
the
software
to
use
suitable
amounts
and
types
of
resources,
also
operating
under
specific
conditions
[15].
G.
Aspect-Oriented
Programming
The
Aspect
Oriented
Programming
(AOP)
is
a
methodology
that
provides
separation
of
crosscutting
concerns
by
introducing
an
Aspect,
a
new
unit
of
modularization.
Each
aspect
focuses
on
a
particular
crosscutting
function.
Main
classes
are
no
longer
plagued
with
crosscutting
concerns.
The
aspect
weaver
assembles
the
final
system
by
combining
main
classes
and
crosscutting
aspects
through
a
process
called
weaving.
Therefore,
with
the
use
of
the
methodology,
applications
that
are
easy
to
design,
implement
and
maintain
would
be
created.
III. METHODOLOGY
A.
About
the
data
used
In
this
work,
we
use
the
Employee
data
table
of
the
Oracle
HR
scheme.
It
consists
of
10,000
records
for
tests.
Four
basic
queries:
selection,
insertion,
update,
and
elimination,
are
performed.
26
Medoza-Palomino
et al.
Comparative analysis of the efficiency of Data Persistence Frameworks. Case study Hibernate 5.4 and MyBatis 3.4
I
S
S
N
-
E
:
2
5
4
2
-
3
4
0
1
,
I
S
S
N
-
P
:
1
3
1
6
-
4
8
2
1
Universidad,
Ciencia
y
Tecnología,
Vol.
26,
Núm.
117,
(pp.
24-32)
T
h
e
r
e
s
t
-
c
l
i
e
n
t
:
I
m
p
l
e
m
e
n
t
s
a
R
E
S
T
c
l
i
e
n
t
a
n
d
t
h
r
o
u
g
h
t
h
r
e
a
d
s
,
w
e
s
e
n
d
a
h
u
n
d
r
e
d
r
e
q
u
e
s
t
s
simultaneously;
fifty
of
which
are
directed
towards
a
REST
service
of
hr-rest-MyBatis
and
the
other
fifty
towards
a
REST
of
hr-rest-hibernate,
in
this
way
we
subject
our
applications
to
a
stressful
situation
since
each
REST
service
will
have
to
process
fifty
requests
simultaneously.
The
hr-rest-mybatis:
microservice
implemented
with
MyBatis.
This
microservice
exposes
four
REST
services.
B
.
E
m
p
l
o
y
e
e
s
t
a
b
l
e
D
D
L
CREATE
TABLE
"HR"."EMPLOYEES"
(
"
E
M
P
L
O
Y
E
E
_
I
D
"
N
U
M
B
E
R
(
6
,
0
)
,
"FIRST_NAME"
VARCHAR2(20
BYTE),
"
L
A
S
T
_
N
A
M
E
"
V
A
R
C
H
A
R
2
(
2
5
B
Y
T
E
)
N
O
T
N
U
L
L
E
N
A
B
L
E
,
"
E
M
A
I
L
"
V
A
R
C
H
A
R
2
(
2
5
B
Y
T
E
)
N
O
T
N
U
L
L
E
N
A
B
L
E
,
"
P
H
O
N
E
_
N
U
M
B
E
R
"
V
A
R
C
H
A
R
2
(
2
0
B
Y
T
E
)
,
"HIRE_DATE"
DATE
NOT
NULL
ENABLE,
"
J
O
B
_
I
D
"
V
A
R
C
H
A
R
2
(
1
0
B
Y
T
E
)
N
O
T
N
U
L
L
E
N
A
B
L
E
,
"
S
A
L
A
R
Y
"
N
U
M
B
E
R
(
8
,
2
)
,
"COMMISSION_PCT"
NUMBER(2,2),
"
M
A
N
A
G
E
R
_
I
D
"
N
U
M
B
E
R
(
6
,
0
)
,
"
D
E
P
A
R
T
M
E
N
T
_
I
D
"
N
U
M
B
E
R
(
4
,
0
)
,
CONSTRAINT
"EMP_EMAIL_UK"
UNIQUE
("EMAIL")
)
C
.
A
b
o
u
t
t
h
e
a
r
c
h
i
t
e
c
t
u
r
e
o
f
t
h
e
d
e
v
e
l
o
p
e
d
s
y
s
t
e
m
First,
we
developed
three
applications
to
perform
basic
CRUD
queries.
Fig
1.
Illustrates
the
proposed
system
a
r
c
h
i
t
e
c
t
u
r
e
o
f
t
h
e
a
p
p
l
i
c
a
t
i
o
n
.
T
h
e
m
o
d
u
l
e
s
a
r
e
o
u
t
l
i
n
e
d
a
s
f
o
l
l
o
w
s
:
The
hr-rest-hibernate:
microservice
implemented
with
Hibernate.
This
microservice
also
exposes
four
REST
services.
27
Fig. 1.
System architecture for our experiments
Medoza-Palomino
et al.
Comparative analysis of the efficiency of Data Persistence Frameworks. Case study Hibernate 5.4 and MyBatis 3.4
I
S
S
N
-
E
:
2
5
4
2
-
3
4
0
1
,
I
S
S
N
-
P
:
1
3
1
6
-
4
8
2
1
Universidad,
Ciencia
y
Tecnología,
Vol.
26,
Núm.
117,
(pp.
24-32)
N
e
x
t
,
T
a
b
l
e
1
,
T
a
b
l
e
2
,
T
a
b
l
e
3
,
a
n
d
T
a
b
l
e
4
,
s
u
m
m
a
r
i
z
e
t
h
e
d
e
t
a
i
l
s
o
f
t
h
e
R
E
S
T
s
e
r
v
i
c
e
s
i
m
p
l
e
m
e
n
t
e
d
i
n
h
r
-
rest-mybatis
and
hr-rest-hibernate.
28
Table 1
. Detail of the rest service for the selection of a record from the Employee table.
Table 2
. Detail of the REST service for the update of a record in the Employee table.
Table 3
. Detail of the REST service for inserting a record in the Employee table.
Medoza-Palomino
et al.
Comparative analysis of the efficiency of Data Persistence Frameworks. Case study Hibernate 5.4 and MyBatis 3.4
I
S
S
N
-
E
:
2
5
4
2
-
3
4
0
1
,
I
S
S
N
-
P
:
1
3
1
6
-
4
8
2
1
U
n
i
v
e
r
s
i
d
a
d
,
C
i
e
n
c
i
a
y
T
e
c
n
o
l
o
g
í
a
,
V
o
l
.
2
6
,
N
ú
m
.
1
1
7
,
(
p
p
.
2
4
-
3
2
)
D
.
D
e
t
e
r
m
i
n
i
n
g
t
h
e
p
r
o
c
e
s
s
i
n
g
t
i
m
e
o
f
d
i
f
f
e
r
e
n
t
t
y
p
e
s
o
f
q
u
e
r
i
e
s
T
o
o
b
t
a
i
n
t
h
i
s
i
n
f
o
r
m
a
t
i
o
n
,
o
n
c
e
t
h
e
m
i
c
r
o
s
e
r
v
i
c
e
s
d
e
v
e
l
o
p
e
d
w
i
t
h
H
i
b
e
r
n
a
t
e
a
n
d
M
y
B
a
t
i
s
w
e
r
e
d
e
p
l
o
y
e
d
,
w
e
s
e
n
t
f
i
f
t
y
R
e
q
u
e
s
t
s
t
o
e
a
c
h
o
f
t
h
e
m
s
i
m
u
l
t
a
n
e
o
u
s
l
y
,
a
n
d
o
n
c
e
t
h
e
R
e
q
u
e
s
t
s
w
e
r
e
r
e
c
e
i
v
e
d
t
h
r
o
u
g
h
t
h
e
R
E
S
T
s
e
r
v
i
c
e
s
,
u
s
i
n
g
A
O
P
,
w
e
o
b
t
a
i
n
e
d
t
h
e
t
i
m
e
d
i
f
f
e
r
e
n
c
e
c
a
p
t
u
r
e
d
b
e
f
o
r
e
a
n
d
a
f
t
e
r
t
h
e
e
x
e
c
u
t
i
o
n
o
f
t
h
e
m
e
t
h
o
d
d
e
f
i
n
e
d
i
n
E
m
p
l
o
y
e
e
D
A
O
.
E.
Determining
the
RAM
usage
T
h
e
b
u
i
l
t
-
i
n
T
a
s
k
M
a
n
a
g
e
r
t
o
o
l
i
n
t
h
e
W
i
n
d
o
w
s
o
p
e
r
a
t
i
n
g
s
y
s
t
e
m
w
a
s
u
s
e
d
;
W
e
p
r
o
c
e
e
d
e
d
t
o
o
p
e
n
t
h
e
“Resource
Monitor”
window
and
went
to
the
“General
Information”
tab
to
obtain
the
information
from
the
“
W
o
r
k
s
p
a
c
e
(
K
B
)
”
c
o
l
u
m
n
o
f
t
h
e
“
M
e
m
o
r
y
”
s
e
c
t
i
o
n
,
w
h
i
c
h
s
h
o
w
s
t
h
e
a
m
o
u
n
t
o
f
p
h
y
s
i
c
a
l
m
e
m
o
r
y
u
s
e
d
i
n
r
e
a
l
-
t
i
m
e
b
y
a
p
r
o
c
e
s
s
.
F.
Determining
the
CPU
Usage
In
the
same
way,
the
Task
Manager
of
the
Windows
operating
system
was
used;
The
“Resource
Monitor”
section
was
accessed,
the
“General
Information”
section
and
the
information
were
obtained
from
the
“CPU”
column
of
the
“CPU”
section,
which
shows
the
percentage
of
CPU
usage
by
a
process.
IV.
RESULTS
A.
Average
processing
time
using
Hibernate
Table
5
shows
the
achieved
processing
time
with
Hibernate.
29
B.
Average
processing
time
using
MyBatis
Table
6
outlines
the
achieved
processing
time
with
MyBatis.
Table 4
. Detail of the REST service for deleting a record in the Employee table.
Table 5
.
Average processing time of the Hibernate framework.
Table 6
. Table 1 .Average processing times of the MyBatis framework.
Medoza-Palomino
et al.
Comparative analysis of the efficiency of Data Persistence Frameworks. Case study Hibernate 5.4 and MyBatis 3.4
I
S
S
N
-
E
:
2
5
4
2
-
3
4
0
1
,
I
S
S
N
-
P
:
1
3
1
6
-
4
8
2
1
U
n
i
v
e
r
s
i
d
a
d
,
C
i
e
n
c
i
a
y
T
e
c
n
o
l
o
g
í
a
,
V
o
l
.
2
6
,
N
ú
m
.
1
1
7
,
(
p
p
.
2
4
-
3
2
)
30
C
.
A
v
e
r
a
g
e
p
r
o
c
e
s
s
i
n
g
t
i
m
e
o
b
t
a
i
n
e
d
w
i
t
h
H
i
b
e
r
n
a
t
e
a
n
d
M
y
B
a
t
i
s
T
a
b
l
e
7
p
r
e
s
e
n
t
s
t
h
e
a
v
e
r
a
g
e
t
i
m
e
o
f
b
o
t
h
f
r
a
m
e
w
o
r
k
s
f
o
r
c
o
m
p
a
r
i
s
o
n
.
Table 7
. Hibernate and MyBatis Average Processing Time Summary
D
.
R
A
M
u
s
a
g
e
u
s
i
n
g
H
i
b
e
r
n
a
t
e
a
n
d
M
y
B
a
t
i
s
T
a
b
l
e
8
s
u
m
m
a
r
i
z
e
s
t
h
e
R
A
M
u
s
a
g
e
o
f
b
o
t
h
f
r
a
m
e
w
o
r
k
s
.
Table 8
. Table 1 .RAM usage using Hibernate and MyBatis for each type of queries.
Note:
*
Results
were
obtained
from
the
difference
between
maximum
and
minimum
RAM
used
by
a
process
E.
CPU
usage
using
Hibernate
and
MyBatis
Table
9
sums
up
the
CPU
usageof
frameworks.
Table 9
. CPU usage when running Hibernate and Mybatis rest services for each type of query.
CONCLUSIONS
Based
on
the
performed
experiments,
we
can
conclude
that
Hibernate
is
more
efficient
against
MyBatis
by
509.1%
and
47.7%
for
select
and
delete
queries,
respectively.
However,
we
found
that
MyBatis
is
more
efficient
by
12.7%
and
14.2%
for
update
and
insert
queries.
Taking
the
RAM
on
the
other
hand,
it
was
determined
that
MyBatis
was
more
efficient
regarding
the
use
of
RAM
in
general
by
55.2%
compared
to
Hibernate,
specifically
by
62.7%,
65.9%,
31.2%,
and
61.0%
for
selection
queries
update,
insertion,
and
deletion
of
data
respectively.
We
found
that
MyBatis
is
more
efficient
with
respect
to
the
use
of
the
CPU
by
20%
compared
to
Hibernate,
specifically
by
23%,
25%,
9%,
and
23%,
for
select,
update,
insert,
and
delete
queries,
respectively.
Medoza-Palomino
et al.
Comparative analysis of the efficiency of Data Persistence Frameworks. Case study Hibernate 5.4 and MyBatis 3.4
ISSN-E:
2542-3401,
ISSN-P:
1316-4821
Universidad,
Ciencia
y
Tecnología,
Vol.
26,
Núm.
117,
(pp.
24-32)
31
REFERENCES
[
1
]
A
.
T
o
r
r
e
s
,
R
.
G
a
l
a
n
t
e
,
M
.
S
.
P
i
m
e
n
t
a
,
a
n
d
A
.
J
.
B
.
M
a
r
t
i
n
s
,
“
T
w
e
n
t
y
y
e
a
r
s
o
f
o
b
j
e
c
t
-
r
e
l
a
t
i
o
n
a
l
m
a
p
p
i
n
g
:
A
s
u
r
v
e
y
o
n
p
a
t
t
e
r
n
s
,
s
o
l
u
t
i
o
n
s
,
a
n
d
t
h
e
i
r
i
m
p
l
i
c
a
t
i
o
n
s
o
n
a
p
p
l
i
c
a
t
i
o
n
d
e
s
i
g
n
,
”
I
n
f
.
S
o
f
t
w
.
T
e
c
h
n
o
l
.
,
v
o
l
.
8
2
,
p
p
.
1
–
1
8
,
2
0
1
7
,
d
o
i
:
1
0
.
1
0
1
6
/
j
.
i
n
f
s
o
f
.
2
0
1
6
.
0
9
.
0
0
9
.
[
2
]
U
.
H
e
r
n
á
n
d
e
z
,
“
C
ó
m
o
e
l
e
g
i
r
u
n
f
r
a
m
e
w
o
r
k
p
a
r
a
e
l
b
a
c
k
e
n
d
,
”
c
ó
d
i
g
o
f
a
c
i
l
i
t
o
,
2
0
1
8
.
h
t
t
p
s
:
/
/
c
o
d
i
g
o
f
a
c
i
l
i
t
o
.
c
o
m
/
a
r
t
i
c
u
l
o
s
/
e
l
e
g
i
r
-
f
r
a
m
e
w
o
r
k
-
b
a
c
k
e
n
d
#
!
(
a
c
c
e
s
s
e
d
A
p
r
.
1
5
,
2
0
2
2
)
.
[3]
S.
M.
Thampi,
“Performance
Comparison
of
Persistence
Frameworks,”
CoRR,
2007,
[Online].
Available:
http://arxiv.org/abs/0710.1404
[
4
]
J
.
G
a
v
i
l
a
n
e
s
,
“
E
s
t
u
d
i
o
c
o
m
p
a
r
a
t
i
v
o
d
e
l
a
p
r
o
d
u
c
t
i
v
i
d
a
d
e
n
t
r
e
l
o
s
F
r
a
m
e
w
o
r
k
s
d
e
p
e
r
s
i
s
t
e
n
c
i
a
e
n
J
a
v
a
Hibernate
y
Mybatis,
aplicado
al
Sistema
de
Evaluación
Docente
del
IPEC,”
2016.
[
5
]
O
.
Y
.
E
n
r
i
q
u
e
z
a
n
d
H
.
G
r
a
c
i
a
,
“
M
a
p
e
o
O
b
j
e
t
o
/
R
e
l
a
c
i
o
n
a
l
(
O
R
M
)
.
,
”
R
e
v
.
T
e
l
e
m
@
t
i
c
a
,
v
o
l
.
1
0
,
n
o
.
3
,
p
p
.
1
–
7,
2011.
[6]
C.
Bauer
and
G.
King,
Hibernate
in
Action,
vol.
4,
no.
Part
I.
2005.
[Online].
Available:
http://books.google.com/books?id=WCmSQgAACAAJ&pgis=1.
[7]
J.
W.
Yoder
and
R.
E.
Johnson,
“Connecting
business
objects
to
relational
databases,”
Urbana,
2005,
[Online].
Available:
http://test.joeyoder.com/Research/objectmappings/Persista.pdf%5Cnpapers2://publication/uuid/F7960186-
CF74-482F-ADF4-86EE560C47D9.
[8]
E.
Reinosa,
C.
Maldonado,
R.
Muñoz,
L.
Damiano,
and
M.
Abrutsky,
Base
de
datos,
1st
ed.
Buenos
Aires:
Alfaomega,
2012.
[
9
]
J
.
M
a
l
d
o
n
a
d
o
,
“
P
e
r
s
i
s
t
e
n
c
i
a
d
e
D
a
t
o
s
,
”
U
n
i
v
e
r
s
i
d
a
d
d
e
C
u
e
n
c
a
.
h
t
t
p
:
/
/
d
o
c
p
l
a
y
e
r
.
e
s
/
1
1
1
5
2
4
3
5
1
-
C
a
p
i
t
u
l
o
-
8
-
p
e
r
s
i
s
t
e
n
c
i
a
-
d
e
-
d
a
t
o
s
.
h
t
m
l
(
a
c
c
e
s
s
e
d
A
p
r
.
2
0
,
2
0
2
2
)
.
[
1
0
]
L
.
Y
o
u
e
t
a
l
.
,
“
J
D
a
p
:
S
u
p
p
o
r
t
i
n
g
i
n
-
m
e
m
o
r
y
d
a
t
a
p
e
r
s
i
s
t
e
n
c
e
i
n
j
a
v
a
s
c
r
i
p
t
u
s
i
n
g
I
n
t
e
l
’
s
P
M
D
K
,
”
J
.
S
y
s
t
.
Archit.,
vol.
101,
no.
June,
p.
101662,
2019,
doi:
10.1016/j.sysarc.2019.101662.
[11]
J.J.
Gutiérrez,
“¿Qué
es
un
framework
?,”
Available
http//www.
lsi.
us.
es/~
javierj/investigacion_ficheros/Framework.
pdf
Accessed
May,
vol.
12,
pp.
1–4,
2014,
[Online].
Available:
http://www.lsi.us.es/~javierj/investigacion_ficheros/Framework.pdf.
[12]
E.
N.
Navarrete
and
R.
Navarro,
“Desarrollo
de
un
marco
de
trabajo
(framework)
para
el
desarrollo
de
aplicaciones
web
en
la
Universidad
Nacional
de
Costa
Rica,”
p.
12,
2017,
[Online].
Available:
http://documentas.redclara.net/bitstream/10786/1287/1/131-17-4Desarrollo
de
un
marco
de
trabajo
%28framework%29
para
el
desarrollo
de
aplicaciones
web.pdf.
[13]
MyBatis,
“MyBatis
–
MyBatis
3
|
Introducción,”
2021.
https://mybatis.org/mybatis-3/es/
(accessed
Apr.
15,
2022).
[14]
Y.
Z.
Li,
S.
Gao,
J.
Pan,
B.
F.
Guo,
and
P.
F.
Xie,
“Research
and
application
of
template
engine
for
web
back-
end
based
on
Mybatis-PLUS,”
Procedia
Comput.
Sci.,
vol.
166,
pp.
206–212,
2020,
doi:
10.1016/j.procs.2020.02.052.
[15]
M.
A.
Abud
Figueroa,
“Calidad
en
la
Industria
del
Software
.
La
Norma
ISO-25000,”
Calid.
en
la
Ind.
del
Software.
La
Norma
ISO-9126,
p.
255,
2012,
[Online].
Available:
javier8a.com/itc/bd1/Normas
iso
9126.pdf.
Medoza-Palomino
et al.
Comparative analysis of the efficiency of Data Persistence Frameworks. Case study Hibernate 5.4 and MyBatis 3.4
ISSN-E:
2542-3401,
ISSN-P:
1316-4821
U
n
i
v
e
r
s
i
d
a
d
,
C
i
e
n
c
i
a
y
T
e
c
n
o
l
o
g
í
a
,
V
o
l
.
2
6
,
N
ú
m
.
1
1
7
,
(
p
p
.
2
4
-
3
2
)
32
LOS AUTORES
Y
o
l
v
i
s
L
.
M
e
n
d
o
z
a
P
a
l
o
m
i
n
o
i
s
a
B
a
c
h
e
l
o
r
o
f
S
y
s
t
e
m
s
E
n
g
i
n
e
e
r
i
n
g
f
r
o
m
t
h
e
National
University
of
San
Cristóbal
de
Huamanga.
He
is
also
a
Systems
Engineer
g
r
a
d
u
a
t
e
f
r
o
m
t
h
e
s
a
m
e
U
n
i
v
e
r
s
i
t
y
.
H
e
c
u
r
r
e
n
t
l
y
w
o
r
k
s
o
n
l
a
r
g
e
-
s
c
a
l
e
s
o
f
t
w
a
r
e
d
e
v
e
l
o
p
m
e
n
t
p
r
o
j
e
c
t
s
.
H
i
s
r
e
s
e
a
r
c
h
i
n
t
e
r
e
s
t
s
b
a
s
i
c
a
l
l
y
i
n
c
l
u
d
e
s
o
f
t
w
a
r
e
e
n
g
i
n
e
e
r
i
n
g
.
E
f
r
a
í
n
E
.
P
o
r
r
a
s
F
l
o
r
e
s
h
a
s
a
B
a
c
h
e
l
o
r
o
f
S
c
i
e
n
c
e
i
n
M
e
c
h
a
n
i
c
a
l
E
n
g
i
n
e
e
r
i
n
g
f
r
o
m
the
National
University
of
Engineering,
Peru,
in
1981.
He
also
graduated
as
a
M
e
c
h
a
n
i
c
a
l
E
n
g
i
n
e
e
r
f
r
o
m
t
h
e
s
a
m
e
u
n
i
v
e
r
s
i
t
y
i
n
1
9
9
1
.
M
a
s
t
e
r
o
f
S
c
i
e
n
c
e
i
n
S
y
s
t
e
m
s
E
n
g
i
n
e
e
r
i
n
g
f
r
o
m
t
h
e
s
a
m
e
u
n
i
v
e
r
s
i
t
y
i
n
2
0
1
0
.
D
o
c
t
o
r
i
n
S
y
s
t
e
m
s
E
n
g
i
n
e
e
r
i
n
g
f
r
o
m
the
Universidad
Nacional
Federico
Villarreal,
Peru,
2019.
M
a
n
u
e
l
A
.
L
a
g
o
s
B
a
r
z
o
l
a
h
a
s
a
B
a
c
h
e
l
o
r
'
s
d
e
g
r
e
e
i
n
C
o
m
p
u
t
e
r
E
n
g
i
n
e
e
r
i
n
g
f
r
o
m
the
National
University
of
San
Cristóbal
de
Huamanga,
Peru,
2006.
He
also
graduated
as
a
Computer
Engineer
from
the
same
university
in
2010.
Master
in
Computer
E
n
g
i
n
e
e
r
i
n
g
i
n
2
0
1
7
f
r
o
m
t
h
e
R
i
c
a
r
d
o
P
a
l
m
a
U
n
i
v
e
r
s
i
t
y
,
P
e
r
u
.
D
o
c
t
o
r
i
n
E
d
u
c
a
t
i
o
n
a
l
Sciences
from
the
National
University
Enrique
Guzmán
y
Valle,
Peru,
2020.
Medoza-Palomino
et al.
Comparative analysis of the efficiency of Data Persistence Frameworks. Case study Hibernate 5.4 and MyBatis 3.4
I
S
S
N
-
E
:
2
5
4
2
-
3
4
0
1
,
I
S
S
N
-
P
:
1
3
1
6
-
4
8
2
1
Universidad,
Ciencia
y
Tecnología,
Vol.
26,
Núm.
117,
(pp.
24-32)