Re: generic modelling of data models; enforcing constraints dynamically...

Поиск
Список
Период
Сортировка
От InterRob
Тема Re: generic modelling of data models; enforcing constraints dynamically...
Дата
Msg-id 671e36b0909271145q1f8ea2ebqb141176fecfec4cd@mail.gmail.com
обсуждение исходный текст
Ответ на Re: generic modelling of data models; enforcing constraints dynamically...  (Erik Jones <ejones@engineyard.com>)
Список pgsql-general
In fact, I considered doing so, yes... But no luck: to complicate things, I will need the support for spatial datatypes, as implemented by the contrib "PostGIS"... Moreover: various applications that will make-up the front-end, will only be able to talk with mainstraim or ODBC-compatible databases  :((


Rob

2009/9/26 Erik Jones <ejones@engineyard.com>

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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: CREATE LANGUAGE workaround
Следующее
От: Gerhard Wiesinger
Дата:
Сообщение: Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans