Detecting and Reporting Object-Relational MappingProblems: An Industrial Report

Transcript

1. 1.

   Detecting and Reporting Object-Relational Mapping Problems: An Industrial Report Marcos

   Nazário @gustavopinto Gustavo Pinto Rodrigo Bonifácio Eduardo Guerra
2. 2.

   @gustavopinto ORM Application Code Database

3. 3.

   @gustavopinto @Entity public class Color { private String code; private

   String name; private Boolean enable; }
4. 4.

   @gustavopinto @Entity @Table(schema = "public", name = "COLOR") public class

   Color { private String code; private String name; private Boolean enable; }
5. 5.

   @gustavopinto @Entity @Table(schema = "public", name = "COLOR") public class

   Color { @Column private String code; @Column private String name; @Column private Boolean enable; }
6. 6.

   @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; }
7. 7.

   @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; }
8. 8.

   @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; }
9. 9.

   @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; }
10. 10.

    @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; }
11. 11.

    @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; }
12. 12.

    @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; }
13. 13.

    @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; }
14. 14.

    @gustavopinto We catalogued 12 ORM-related problems

15. 15.

    @gustavopinto We implemented this catalog in a static analysis tool

16. 16.

    @gustavopinto We implemented this catalog in a static analysis tool

    Finds the problems Suggests the fix
17. 17.

    @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
18. 18.

    @gustavopinto Could others take advantage of our tool?

19. 19.

    @gustavopinto

20. 20.

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

    developers
21. 21.

    @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
22. 22.

    @gustavopinto

23. 23.

    @gustavopinto 6 ORM tasks

24. 24.

    @gustavopinto 6 ORM tasks

25. 25.

    @gustavopinto 6 ORM tasks

26. 26.

    @gustavopinto All participants completed the experiment

27. 27.

    @gustavopinto eases ORM modeling Every day I do object-relational mapping,

    and this tool could help me to remember what is missing “ ”
28. 28.

    @gustavopinto eases ORM modeling the tool is precise forces best

    practices
29. 29.

    @gustavopinto Little docs I found it quite difficult to find

    help in the documentation. There is nothing on the web “ ”
30. 30.

    @gustavopinto Little docs Custom annotations were not intuitive The tool

    poses many constraints
31. 31.

    None
32. 32.

    None
33. 33.

    None
34. 34.

    None
35. 35.

    None
36. 36.

    None