Re: EAV - again

On 2015-02-07, James K. Lowden <jklowden_at_speakeasy.net> wrote:
> On Fri, 6 Feb 2015 20:59:53 +0000
> Eric <eric_at_deptj.eu> wrote:
>
>> 1 is software designed around EAV as a way of providing end-user
>> tailoring.
>
> Never mind "tailoring", sometimes that's the whole design.
>
> If you trundle around the world of "master data management" for a
> little while, you'll soon find million-dollar systems with a single EAV
> at the center and a giant application on top that lets the "user" --
> what used to be called "application developer" -- define a database
> cum application. It supports domains, constraints, and transformation
> rules, and the selling point is that it's all ad hoc: you can do
> anything you want, because the system neither enforces consistency of
> any kind nor provides any means of checking it (other than user-written
> reports).
>
> Hurrah! No foreign key violations! Free at last!
>
> And when management asks if it runs on Oracle, the answer of course is
> Yes.

Yes, that's one end of the spectrum, and yes, it exists. Thankyou.

Eric

-- 
ms fnd in a lbry