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 puts SQL code into an input field so that the application runs it, letting the attacker read, change or delete data.

This word in other fields

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

• ORM · Software Engineering

More terms: Database Basics

• database
• relational database
• DBMS
• data warehouse
• OLTP