FUDforum: comp.lang.php » ORMs comparisons/complaints.

Home » Imported messages » comp.lang.php » ORMs comparisons/complaints.

Show: Today's Messages :: Polls :: Message Navigator

Re: ORMs comparisons/complaints. [message #184483 is a reply to message #184463]

Fri, 03 January 2014 02:10

Arne Vajhøj
Messages: 27
Registered: December 2013

Karma:

Junior Member

On 1/2/2014 6:36 AM, Silvio wrote:
> On 01/02/2014 04:19 AM, Arne Vajhøj wrote:
>> On 12/30/2013 8:38 AM, Silvio wrote:
>>> This is also the area where ORMs failed in the projects
>>> I talked about. It's not that the ORM can not do it, it just can not do
>>> it sufficiently well even with help from the most experienced experts we
>>> could find.
>>
>> ????
>>
>> Joins is a core feature of ORM.
>>
>> And common Java ORM's like JPA implemntations and Hibernate does
>> aggregate functions exactly like SQL in JPQL and HQL respectively.
>>
>> I wonder what kind of "experts" you got.
>
> Yes, they got all the stuff working the first time with joins and
> aggregates like you say. But after some time they got into trouble
> because aliased data caused the systems to show faulty counts and totals
> etc. and from there on it went down-hill. On more than one system they
> had to forcefully flush the cache at specific moments to get the right
> results for subsequent reporting. Which then did not work very promptly,
> to put it mildly.

It has either been a horrible ORM or some horrible "experts".

> Most systems I work(ed) on are primarily analytical systems working on
> data that comes from surveys, measure devices, order tracking systems
> etc. and fetching a record and storing it after manually changing some
> attributes is not the common use case. The primary goal is to properly
> manage such data at the record level behind the scenes while at the same
> time allow thorough analysis of the overall process. Much of this
> requires aggregates on joins that have to be built dynamically because
> the user can specify exactly what he needs via a UI, akin to an OLAP
> system.
>
> I admit that this is not a good match for ORM but in these cases that
> was hindsight wisdom. When they started they thought ORM was the right
> tool. Which does not surprise me since I encounter many people who never
> doubt ORM is the way to go with any system.

Ah.

ORM's are often good for transactional data (OLTP).

Not as obvious a choice for analytical data (DWH).

Arne

Report message to a moderator

[Message index]

		ORMs comparisons/complaints. By: Daniel Pitts on Sun, 22 December 2013 19:05
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Sun, 22 December 2013 19:46
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Sun, 22 December 2013 20:17
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Sun, 22 December 2013 20:38
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Sun, 22 December 2013 20:47
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Sun, 22 December 2013 21:04
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Sun, 22 December 2013 21:09
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Sun, 22 December 2013 21:20
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Sun, 22 December 2013 21:34
		Re: ORMs comparisons/complaints. By: Qu0ll on Mon, 23 December 2013 01:54
		Re: ORMs comparisons/complaints. By: Michael Vilain on Mon, 23 December 2013 04:48
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Mon, 23 December 2013 12:58
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 03:46
		Re: ORMs comparisons/complaints. By: Qu0ll on Mon, 30 December 2013 03:54
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 04:06
		Re: ORMs comparisons/complaints. By: Qu0ll on Mon, 30 December 2013 04:21
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Mon, 30 December 2013 13:04
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 17:32
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Mon, 30 December 2013 17:47
		Re: ORMs comparisons/complaints. By: Qu0ll on Mon, 30 December 2013 21:23
		Re: ORMs comparisons/complaints. By: Doug Miller on Mon, 30 December 2013 19:45
		Re: ORMs comparisons/complaints. By: Ricardo Palomaes on Mon, 30 December 2013 18:20
		Re: ORMs comparisons/complaints. By: The Natural Philosoph on Mon, 30 December 2013 18:34
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Mon, 30 December 2013 19:27
		Re: ORMs comparisons/complaints. By: Marcel Müller on Sun, 22 December 2013 21:26
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 04:17
		Re: ORMs comparisons/complaints. By: Kevin McMurtrie on Mon, 23 December 2013 00:11
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 04:08
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Mon, 30 December 2013 21:36
		Re: ORMs comparisons/complaints. By: The Natural Philosoph on Mon, 30 December 2013 22:13
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Tue, 31 December 2013 02:09
		Re: ORMs comparisons/complaints. By: The Natural Philosoph on Tue, 31 December 2013 11:30
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Tue, 31 December 2013 13:11
		Re: ORMs comparisons/complaints. By: Chris Uppal on Wed, 01 January 2014 14:20
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Thu, 02 January 2014 03:05
		Re: ORMs comparisons/complaints. By: Qu0ll on Thu, 02 January 2014 03:48
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Thu, 02 January 2014 02:57
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Thu, 02 January 2014 08:04
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Thu, 02 January 2014 02:54
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Thu, 02 January 2014 08:09
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Fri, 03 January 2014 01:54
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Fri, 03 January 2014 13:18
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Fri, 03 January 2014 21:45
		Re: ORMs comparisons/complaints. By: Qu0ll on Mon, 23 December 2013 06:38
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Mon, 23 December 2013 12:57
		Re: ORMs comparisons/complaints. By: Qu0ll on Mon, 23 December 2013 23:11
		Re: ORMs comparisons/complaints. By: Jerry Stuckle on Tue, 24 December 2013 00:59
		Re: ORMs comparisons/complaints. By: Qu0ll on Tue, 24 December 2013 01:14
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 04:02
		Re: ORMs comparisons/complaints. By: Qu0ll on Mon, 30 December 2013 04:40
		Re: ORMs comparisons/complaints. By: Silvio on Mon, 23 December 2013 12:25
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 04:27
		Re: ORMs comparisons/complaints. By: Silvio on Mon, 30 December 2013 13:38
		Re: ORMs comparisons/complaints. By: Daniel Pitts on Mon, 30 December 2013 17:36
		Re: ORMs comparisons/complaints. By: Silvio on Tue, 31 December 2013 00:26
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Thu, 02 January 2014 03:23
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Thu, 02 January 2014 03:19
		Re: ORMs comparisons/complaints. By: Silvio on Thu, 02 January 2014 11:36
		Re: ORMs comparisons/complaints. By: Daniel Pitts on Thu, 02 January 2014 17:36
		Re: ORMs comparisons/complaints. By: Silvio on Thu, 02 January 2014 20:06
		Re: ORMs comparisons/complaints. By: Chris Uppal on Fri, 03 January 2014 14:48
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Fri, 03 January 2014 01:59
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Fri, 03 January 2014 02:07
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Fri, 03 January 2014 02:10
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Tue, 31 December 2013 13:44
		Re: ORMs comparisons/complaints. By: leif.roar on Mon, 23 December 2013 13:22
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Mon, 30 December 2013 04:20
		Re: ORMs comparisons/complaints. By: Wanja Gayk on Tue, 24 December 2013 11:28
		c By: Jerry Stuckle on Tue, 24 December 2013 13:49
		Re: c By: Qu0ll on Tue, 24 December 2013 22:35
		Re: c By: Graham Hobbs on Wed, 25 December 2013 00:35
		Re: c By: Jerry Stuckle on Wed, 25 December 2013 05:08
		Re: c By: Qu0ll on Wed, 25 December 2013 06:46
		Re: c By: Graham Hobbs on Wed, 25 December 2013 14:24
		Re: c By: Qu0ll on Wed, 25 December 2013 09:41
		[EOD] Re: c By: Wanja Gayk on Wed, 25 December 2013 10:15
		Re: [EOD] Re: c By: Qu0ll on Wed, 25 December 2013 12:29
		Re: [EOD] Re: c By: The Natural Philosoph on Wed, 25 December 2013 12:48
		Re: c By: Arne Vajhøj on Mon, 30 December 2013 03:51
		Re: c By: Jerry Stuckle on Mon, 30 December 2013 13:03
		Re: c By: Arne Vajhøj on Mon, 30 December 2013 17:40
		Re: c By: Jerry Stuckle on Mon, 30 December 2013 17:46
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Wed, 25 December 2013 17:56
		Re: ORMs comparisons/complaints. By: jebblue on Tue, 31 December 2013 16:52
		Re: ORMs comparisons/complaints. By: Evan Platt on Tue, 31 December 2013 19:50
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Tue, 31 December 2013 21:54
		Re: ORMs comparisons/complaints. By: jebblue on Wed, 01 January 2014 01:33
		Re: ORMs comparisons/complaints. By: Arved Sandstrom on Thu, 02 January 2014 21:37
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Thu, 02 January 2014 02:46
		Re: ORMs comparisons/complaints. By: Gordon Levi on Thu, 02 January 2014 08:34
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Fri, 03 January 2014 01:43
		Re: ORMs comparisons/complaints. By: Gordon Levi on Fri, 03 January 2014 09:19
		Re: ORMs comparisons/complaints. By: Arne Vajhøj on Fri, 03 January 2014 20:43

Previous Topic:	tracking file usage
Next Topic:	Processing accented characters submitted from forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 03:34:06 GMT 2024

Total time taken to generate the page: 0.04932 seconds