Re: generic modelling of data models; enforcing constraints dynamically... - Mailing list pgsql-general

From Erik Jones
Subject Re: generic modelling of data models; enforcing constraints dynamically...
Date
Msg-id 4C5D7143-7487-44BB-A3D2-EE0180A1573E@engineyard.com
Whole thread Raw
In response to Re: generic modelling of data models; enforcing constraints dynamically...  (InterRob <rob.marjot@gmail.com>)
Responses Re: generic modelling of data models; enforcing constraints dynamically...  (InterRob <rob.marjot@gmail.com>)
List pgsql-general
On Sep 24, 2009, at 2:07 PM, InterRob wrote:

> I guess it IS quite overengineered indeed...
>
> What I'm trying to do is to facilitate different fieldwork
> methodologies for archaeological research (on project basis); there
> is no final agreement on data structure and semantics; however, on a
> meta-level all choices are rational and can be modelled... Infact,
> all models can be related to each other: that's where the "hybrid"
> part comes in: I wish to implement the common denominator (90%) and
> then further extend this, enabing specific data model
> implementations -- including checks for data integrity.

Have you considered a non-relational, "schema-less" database such as
MongoDB or Cassandra?  You're pretty much throwing out the relational
features of this database anyways so it seems that it would make sense
to use something more geared to that kind of work.

Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k






pgsql-general by date:

Previous
From: David Chell
Date:
Subject: The password specified does not meet the local or domain policy during install.
Next
From: ayen.krida@gmail.com
Date:
Subject: PQgetvalue() question