Tweet
Tweet

Slide 1

Slide 1 text

Detecting and Reporting Object-Relational Mapping Problems: An Industrial Report Marcos Nazário @gustavopinto Gustavo Pinto Rodrigo Bonifácio Eduardo Guerra

Slide 2

Slide 2 text

@gustavopinto ORM Application Code Database

Slide 3

Slide 3 text

@gustavopinto @Entity public class Color { private String code; private String name; private Boolean enable; }

Slide 4

Slide 4 text

@gustavopinto @Entity @Table(schema = "public", name = "COLOR") public class Color { private String code; private String name; private Boolean enable; }

Slide 5

Slide 5 text

@gustavopinto @Entity @Table(schema = "public", name = "COLOR") public class Color { @Column private String code; @Column private String name; @Column private Boolean enable; }

Slide 6

Slide 6 text

@gustavopinto @Entity @Table(schema = "public", name = "COLOR") public class Color { @Column(name = "CODE", nullable = false) private String code; @Column(name = "NAME", length = 80, nullable = false) private String name; @Column(name = "ENABLE", nullable = false) private Boolean enable; }

Slide 7

Slide 7 text

@gustavopinto @Entity @Table(schema = "public", name = "COLOR") public class Color { @Column(name = "CODE", nullable = false) private String code; @Column(name = "NAME", length = 80, nullable = false) private String name; @Column(name = "ENABLE", nullable = false) private Boolean enable; }

Slide 8

Slide 8 text

@gustavopinto @Entity @Table(schema = "public", name = "COLOR") public class Color { @Column(name = "CODE", nullable = false) private String code; @Column(name = "NAME", length = 80, nullable = false) private String name; @Column(name = "ENABLE", nullable = false) private Boolean enable; }

Slide 9

Slide 9 text

@gustavopinto @Entity @Table(schema = "public", name = "COLOR") public class Color { @Column(name = "CODE", nullable = false) private String code; @Column(name = "NAME", length = 80, nullable = false) private String name; @Column(name = "ENABLE", nullable = false) private Boolean enable; }

Slide 10

Slide 10 text

@gustavopinto @Entity @Table(schema = "public", name = "COLOR") public class Color { @Id @Column(name = "CODE", nullable = false) private String code; @Column(name = "NAME", length = 80, nullable = false) private String name; @Column(name = "ENABLE", nullable = false) private Boolean enable; }

Slide 11

Slide 11 text

@gustavopinto @Entity @Table(schema = "public", name = "COLOR") public class Color { @Id @Column(name = "CODE", nullable = false) private String code; @Column(name = "NAME", length = 80, nullable = false) private String name; @Column(name = "ENABLE", nullable = false) private Boolean enable; }

Slide 12

Slide 12 text

@gustavopinto @Entity @Table(schema = "public", name = "COLOR") public class Color { @Id @Column(name = "CODE", nullable = false) private String code; @Column(name = "NAME", length = 80, nullable = false) private String name; @Column(name = "ENABLE", nullable = false) private Boolean enable; }

Slide 13

Slide 13 text

@gustavopinto @Entity @Table(schema = "public", name = "COLOR") public class Color implements Serializable { @Id @Column(name = "CODE", nullable = false) private String code; @Column(name = "NAME", length = 80, nullable = false) private String name; @Column(name = "ENABLE", nullable = false) private Boolean enable; }

Slide 14

Slide 14 text

@gustavopinto We catalogued 12 ORM-related problems

Slide 15

Slide 15 text

@gustavopinto We implemented this catalog in a static analysis tool

Slide 16

Slide 16 text

@gustavopinto We implemented this catalog in a static analysis tool Finds the problems Suggests the fix

Slide 17

Slide 17 text

@gustavopinto We implemented this catalog in a static analysis tool We are using this tool for over 5 years now Finds the problems Suggests the fix

Slide 18

Slide 18 text

@gustavopinto Could others take advantage of our tool?

Slide 19

Slide 19 text

@gustavopinto

Slide 20

Slide 20 text

@gustavopinto We conducted a developer experience (DX) study with 13 developers

Slide 21

Slide 21 text

@gustavopinto We conducted a developer experience (DX) study with 13 developers 3 students, 10 from industry 6 with 7+ years with ORM experience 2 with no previous ORM experience

Slide 22

Slide 22 text

@gustavopinto

Slide 23

Slide 23 text

@gustavopinto 6 ORM tasks

Slide 24

Slide 24 text

@gustavopinto 6 ORM tasks

Slide 25

Slide 25 text

@gustavopinto 6 ORM tasks

Slide 26

Slide 26 text

@gustavopinto All participants completed the experiment

Slide 27

Slide 27 text

@gustavopinto eases ORM modeling Every day I do object-relational mapping, and this tool could help me to remember what is missing “ ”

Slide 28

Slide 28 text

@gustavopinto eases ORM modeling the tool is precise forces best practices

Slide 29

Slide 29 text

@gustavopinto Little docs I found it quite difficult to find help in the documentation. There is nothing on the web “ ”

Slide 30

Slide 30 text

@gustavopinto Little docs Custom annotations were not intuitive The tool poses many constraints

Slide 31

Slide 31 text

No content

Slide 32

Slide 32 text

No content

Slide 33

Slide 33 text

No content

Slide 34

Slide 34 text

No content

Slide 35

Slide 35 text

No content

Slide 36

Slide 36 text

No content