Object-relational mapping is a programming technique that allows applications to work with the data as objects, but store the data in a database as groups of simpler values.

learn more… | top users | synonyms

0
votes
2answers
107 views

Lower() vs ilike on postgresql

What I want to do is to check if value of column equals some string, but case insensitive. Is there a performance difference when using ilike without wildcards (percents) and lower() ? I was planning ...
1
vote
0answers
10 views

Type of relational/object-oriented database with improved joins for object graphs?

I would like to know if there is a specific name or term for the kind of database described below: I notice one of the biggest problems when working with relational databases and object trees/graphs ...
1
vote
0answers
406 views

Can someone please give me hints on normalizing this database and any other helpful hints

I am using Entity Framework 5 to work with this database but I am getting issues with how tblTalkers and tblChatSessions are being mapped in the entity model when imported into Visual Studio. Please ...
0
votes
0answers
62 views

Deadlocks due to foreign keys (MySQL)

We are in the process of creating a web application using mysql as a data source. We are using spring with hibernate as an ORM framework. We have hundreds of entities with relations (manyToMany \ ...
0
votes
0answers
42 views

MySql Doctrine ORM DB Design for simple app

I am pretty new to Doctrine and am building a simple app and need some help with some thinking. I have: TableA - call it soccer games TableB - days of the week these games are held on TableC - times ...