ORM

How it is used

Popular examples are Hibernate, Entity Framework, Django ORM, SQLAlchemy, Prisma and ActiveRecord. ORMs save time but can hide inefficient queries; the most famous problem is the 'N+1 query problem'. Developers often mix ORM code with raw SQL for complex reports.

Example sentences

1. The ORM is sending one query per order item; that's a classic N+1 problem.

2. For this report, skip the ORM and write the SQL by hand.

Common collocations

• use an ORM
• ORM framework
• N+1 query problem
• ORM-generated SQL

Related terms

• SQLStructured Query Language: the standard language used to create tables and to read, add, change and delete data in relational databases.
• CRUDCreate, Read, Update, Delete: the four basic operations on stored data, matching the SQL statements INSERT, SELECT, UPDATE and DELETE.
• queryA request sent to a database to read or change data, usually written in SQL. As a verb, to query means to ask a database for data.
• SQL injectionAn attack in which someone types SQL code into a form or URL so that the database runs it, which can expose or delete data.

This word in other fields

The same English word can have a different meaning in another field:

• ORM · Databases & SQL

More terms: Databases and Persistence

• table
• column
• relational database
• DBMS
• primary key
• foreign key
• SELECT statement
• WHERE clause
• join
• schema
• transaction
• data type