Hello Umashankar,
*warning* this doesn't answer the question you asked *warning*
you write that you are new to object databases. The problem that you
describe sounds like it might much more completely be solved by not using
the object features and avoiding an array alltogether.
If you simply wish to solve the problem, then I can recommend some reading
on normal forms, which goes into all the problems that can occur in
databases without consideration for storage anomalities. You can find a
good article here:
http://home.earthlink.net/~billkent/Doc/simple5.htm
Your database would then be in "first normal form" and not contain lists
inside a field any more. You simply create two columns, the first listing
the patient ID and the second listing the illness. Patient IDs are
allowed to occur repeatedly. You could retrieve all illnesses for a
particular patient by the use of:
select illness from patient_illness where patient_id=1434;
or you may retrieve all patients' illnesses by querying:
select * from patient_illness order by patient_id,illness;
I hope that helps,
Oliver
