Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What are alternatives to standard ORM in a data access layer? [closed]

We're all familiar with basic ORM with relational databases: an object corresponds to a row and an attribute in that object to a column, though many ORMs add a lot of bells and whistles.

I'm wondering what other alternatives there are (besides raw access to the data). Alternatives that just work with relational databases would be great, but ones that could work with multiple types of backends besides just SQL (such as flat files, RSS, NoSQL, etc.) in a uniform manner would be even better. I'm more interested in ideas rather than specific implantations and what languages/platforms they work with, but please link to anything you think is interesting.

like image 889
swampsjohn Avatar asked May 23 '10 22:05

swampsjohn


People also ask

What is the alternative to an ORM?

To avoid the mapping problem you have two alternatives. Either you use the relational model in memory, or you don't use it in the database.

Is ORM data access layer?

DAL (Data Access Layer):It is a layer that handles all your data needs. But this is different from ORM. Actually, this may use ORM internally for any RDBMS communication. Although DAL can be designed without using any ORM also.

How many types of ORM are there?

There are many types of ORM languages like Django ORM, Dapper ORM, JOOQ ORM, SQL Alchemy, etc.


1 Answers

Your basic choices are:

  • Just use raw SQL.
  • Pick an ORM that meets your needs. Most platforms have a variety of choices. - for example the .NET platform supports LINQ, nHibernate, Entity Framework, etc.
  • Write your own ORM and/or data access framework.
like image 133
Justin Ethier Avatar answered Sep 18 '22 05:09

Justin Ethier