From: Phillip Gawlowski Date: 2010-11-18T20:37:35+09:00 Subject: Re: ORM's - Don't Do It! On Wed, Nov 17, 2010 at 7:24 PM, Mike Stephens wrote: > I'm thinking of eg a large general insurance application. There would be > hundreds of other databases across the organisation but I recall 800 > Oracle tables in the main app. So, how do you access them, then? ORM is not an option, so how do you et the data into a report, a quoting app, or shove it over to accounts payable? >> the only people who have access to all tables >> in any given database are only a select few, simply for privacy and >> security reasons. >> > You refer to people who have access to all tables as though there are > only two types of users - 800 tablers or 20 tablers. In fact there will > be all sorts of different profiles. I never said that, and I never implied that. But an insurance agent will *not* have access to the financial records of the corporation, nor to detailed payment behavior of clients, nor will HR have access to client information, nor will billing have access to client profiles or financial records. The only people with access to all the data in all the tables with be a handful of DBAs. Don't put words in my worth. > You seem very evangelical when it comes to ORMs Not at all. I'm merely trying to get answer out of you as what alternatives *you see* to ORM. So far, you haven't offered one, despite claiming that ORM is a sub-par technology when it comes to accessing databases. Burden of proof is yours, so provide some proof. > but I'm sure you're > aware the impedance mismatch is a well known issue. I didn't invent it. I'm also aware that databases aren't the best place to put program logic (stored procedures are pushing it already, but enforcing constraints, normalization, and access *is* a key feature of database engines). So, let me reiterate: What alternatives do you offer to accessing a database from within programs? You've not yet answered this question. -- Phillip Gawlowski Though the folk I have met, (Ah, how soon!) they forget When I've moved on to some other place, There may be one or two, When I've played and passed through, Who'll remember my song or my face.