dbTalk Databases Forums  

Secondary Db in many-to-one relationship with Primary db.

comp.databases.berkeley-db comp.databases.berkeley-db


Discuss Secondary Db in many-to-one relationship with Primary db. in the comp.databases.berkeley-db forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Radzi
 
Posts: n/a

Default Secondary Db in many-to-one relationship with Primary db. - 11-01-2006 , 05:49 PM






Hi,
Is it possible for me to create secondary database which may require
multiple key from primary db record? For example, I have item record
that may contain more than one components. I would like to create index
on item record on the components. Since the number of components is
variables, I would not like to create secondary indexes for each
component. How could I lump them into one secondary index that allow me
to use join-cursor to for instance, finding items with component A, B
and C...


TIA.
Radzi.


Reply With Quote
  #2  
Old   
Michael Cahill
 
Posts: n/a

Default Re: Secondary Db in many-to-one relationship with Primary db. - 11-01-2006 , 06:28 PM






Hi Radzi,

Quote:
Is it possible for me to create secondary database which may require
multiple key from primary db record?
The only way to do this at present is to maintain the index manually:
that is, you need to add and remove the (secondary key, primary key)
pairs in your application. This is a common feature request for
Berkeley DB and is high on our todo list.

Regards,
Michael Cahill, Oracle.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.