Re: Thus spoke SQL3 (on OO)

Поиск
Список
Период
Сортировка
От Chris Bitmead
Тема Re: Thus spoke SQL3 (on OO)
Дата
Msg-id 39291781.D9947450@bitmead.com
обсуждение исходный текст
Ответ на Thus spoke SQL3 (on OO)  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Thus spoke SQL3 (on OO)  (Marten Feldtmann <marten@feki.toppoint.de>)
Список pgsql-hackers
Hannu Krosing wrote:

> Is the ODMG interface available on the net, or is the plan to do a Poet > clone

Looking at database vendor specs will get us a fair way. Or you can
shell the $35 for a spec.

> > Unless we want to break new ground anyway.
> 
> We would need some syntax to distinguish between REFERENCES (primary 
> key) and REFERENCES (oid).

The trouble is the client cache code is generally all set up to cache by
oid. If you want to start referencing objects by various criteria, the
client cache becomes a lot more complex. More inefficient too because
you would have to set up hash tables on multiple criteria and jump
between them.

It's not such a big deal really. When you do an OO model you don't need
to think about your own primary key.

> Of course we would also need fast lookups by oid and oid->object lookup
> tables(s)/function(s) but that's another part of the story.

An index on oid will be a start.

-- 
Chris Bitmead
mailto:chris@bitmead.com
http://www.techphoto.org - Photography News, Stuff that Matters


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Ragnar Hakonarson"
Дата:
Сообщение: plperl
Следующее
От: Chris Bitmead
Дата:
Сообщение: Re: [GENERAL] Re: Postgresql OO Patch