What is an ORM tool

ORM (object relational mapping)

Object Relational Mapping (ORM) is a programming technique for converting data between relational databases and object-oriented programming languages. With ORM technology, objects can be mapped onto the structures of a relational database.

Object relational mapping can be used to convert data between incompatible systems using object-oriented programming languages. Objects can be accessed and modified from different data sources, even if the data sinks that receive them and the applications in which they are used change. Based on the abstraction, ORM manages the mapping details between a set of objects and the underlying relational databases, XML repositories or other data sources and data sinks, while at the same time hiding the often changing details of the associated interfaces from developers and the code they create.

Since the relational formations cannot always be connected 1: 1 with the object-oriented structures, this is an approach for tools that support ORM mapping. In addition to commercial tools such as Oracle Toplink, Hibernate is one of the best-known and most developed persistence frameworks available as open source. Its use not only enables the connection to most relational databases, but also the cluster capability, caching and session management are taken into account.