Object-relational mapping
Connecting program objects to data in a relational database.
What is object-relational mapping?
Object-relational mapping, or ORM, connects program objects or models to relational database structures. A corresponding tool translates many accesses into database operations. Field, relationship and change handling depend on the ORM and its configuration. The approach does not make schema, constraint, query and migration decisions for the team.
In a fictional portal, the ServiceRequest model represents a saved request. Changing an object in memory does not automatically mean a durable database change with every tool; the intended saving workflow must run. The team checks generated queries, required data and access rights. A conveniently expressed model query guarantees neither suitable query performance nor permission to see all returned requests.
Sources
Related terms
- Relational data modelModelling data in tables with rows, columns and explicitly described relationships.
- SQLA language for defining, querying and changing data.
- PostgreSQLAn open-source object-relational database system for structured storage and querying of data.
- Unique keyA unique key constrains values or combinations so they cannot occur more than once within the defined data scope.
- Database queryA database query requests data under defined conditions. Selection, result scope and ordering should fit the work being done.
- Database indexA database index supports suitable lookups. It does not accelerate every query and adds storage and data-change overhead.
Your project with ASES
Describe your project to us. We will get back to you with an initial assessment.