On Sun, Nov 16, 2008 at 3:36 PM, Ivan Shcheklein <[EMAIL PROTECTED]>wrote:
> Hi Sean,
>
> It seems to me that I don't exactly understand what do you want to do.
> Can you provide an example of documents and updates/inserts and explain the
> way you want to manage them?
Sorry, Ivan, for being unclear. I have documents that look like:
<MedlineCitationSet>
<MedlineCitation>
<PMID>12345</PMID>
.....
</MedlineCitation>
<MedlineCitation>
<PMID>23456</PMID>
...
</MedlineCitation>
</MedlineCitationSet>
I load about 600 of these, each with 30k entries at the beginning of the
year. Then, as the year progresses, I receive a new file, one per week,
that has the same structure as the above. In these additional files, some
records are added (that have PMID that are not already in the collection)
while others are "updates" (that have a PMID already in the collection).
For those records for which there is no PMID already in the collection, I
simply want to add them as usual. However, for those that have an existing
record (as evidenced by a matching PMID in the collection), I want to either
update the existing record or simply remove it and add the new record. The
total data are about 50GB or so, so this is a rather large database.
Thanks,
Sean
>
> On Sat, Nov 15, 2008 at 7:03 PM, Sean Davis <[EMAIL PROTECTED]> wrote:
>
>> Sorry for all the questions recently, but I am learning a ton from the
>> answers (so, I keep asking).
>>
>> I have a set of XML documents that are loaded into a collection once per
>> year. Then, throughout the year, updates are sent out and need to be either
>> inserted (if a record does not exist) or updated (if a record exists). The
>> update can be a simple replace of the entire node. Is it possible to
>> convert an insert to an update using triggers so that I can still do bulk
>> loads rather than having to load nodes one-at-a-time? It is a little
>> complicated, because the updates would be from a different document than the
>> original record. Any suggestions on how to do this? I can, of course, do
>> all of this from an external application, but it would be nice to do it from
>> within the database.
>>
>> Thanks (AGAIN),
>> Sean
>>
>>
>> -------------------------------------------------------------------------
>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>> challenge
>> Build the coolest Linux based applications with Moblin SDK & win great
>> prizes
>> Grand prize is a trip for two to an Open Source event anywhere in the
>> world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> Sedna-discussion mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/sedna-discussion
>>
>>
>
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
