Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Detecting and Reporting Object-Relational Mappi...

Gustavo Pinto
September 19, 2019

Detecting and Reporting Object-Relational MappingProblems: An Industrial Report

Gustavo Pinto

September 19, 2019
Tweet

More Decks by Gustavo Pinto

Other Decks in Research

Transcript

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

    Nazário @gustavopinto Gustavo Pinto Rodrigo Bonifácio Eduardo Guerra
  2. @gustavopinto @Entity @Table(schema = "public", name = "COLOR") public class

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

    Color { @Column private String code; @Column private String name; @Column private Boolean enable; }
  4. @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; }
  5. @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; }
  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. @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. @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; }
  9. @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; }
  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. @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; }
  12. @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
  13. @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
  14. @gustavopinto eases ORM modeling Every day I do object-relational mapping,

    and this tool could help me to remember what is missing “ ”
  15. @gustavopinto Little docs I found it quite difficult to find

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