Redistribute native XML index key shipping

A computer program product for redistributing data in a database system, the computer program product comprising:

• a computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising:
• computer readable program code to store a first set of receiver location identifiers mapped to a document identifier, wherein the first set of receiver location identifiers are assigned to a first set of receiver locations, wherein the first set of receiver locations contain relational data referencing the document identifier, and wherein the relational data was received from a sender partition;
• computer readable program code to store a second set of receiver location identifiers mapped to the document identifier, wherein the second set of receiver location identifiers are assigned to a second set of receiver locations, wherein the second set of receiver locations contain document data corresponding to the document identifier referenced by the relational data, and wherein the document data was received from the sender partition separately from the relational data;
• computer readable program code to receive, from the sender partition separately from the relational data and the document data, sender index keys referencing the document identifier, wherein the sender index keys contain sender location identifiers;
• computer readable program code to determine, from the stored first set of receiver location identifiers and the stored second set of receiver location identifiers, which receiver location identifiers mapped to the document identifier referenced by the received sender index keys;
• and
• computer readable program code to modify the received sender index keys by replacing the sender location identifiers with the determined receiver location identifiers.

A system, comprising:

• a sender partition storing relational data referencing an document identifier and document data corresponding to the document identifier;
• and
• a receiver partition operatively coupled to the sender partition, the receiver partition comprising:
• a computer processor;
• and
• a memory containing a program that, when executed by the computer processor, performs an operation for redistributing data in a database system, the operation comprising:
• storing a first set of receiver location identifiers mapped to the document identifier, wherein the first set of receiver location identifiers are assigned to a first set of receiver locations, wherein the first set of receiver locations contain the relational data referencing the document identifier, and wherein the relational data was received from the sender partition;
• storing a second set of receiver location identifiers mapped to the document identifier, wherein the second set of receiver location identifiers are assigned to a second set of receiver locations, wherein the second set of receiver locations contain document data corresponding to the document identifier referenced by the relational data, and wherein the document data was received from the sender partition separately from the relational data;
• receiving, from the sender partition separately from the relational data and the document data, sender index keys referencing the document identifier, wherein the sender index keys contain sender location identifiers;
• determining, from the stored first set of receiver location identifiers and the stored second set of receiver location identifiers, which receiver location identifiers are mapped to the document identifier referenced by the received sender index keys;
• and
• modifying the received sender index keys by replacing the sender location identifiers with the determined receiver location identifiers.

A method for redistributing data in a database system, comprising:

• storing receiver record identifiers (“RID's”) mapped to an extensible markup language (“XML”) identifier, wherein the RID's are assigned to receiver records containing relational data referencing the XML identifier, and wherein the relational data was received from a sender partition;
• storing receiver XML page identifiers (“XID's”) mapped to the XML identifier, wherein the XID's are assigned to one or more receiver XML pages containing XML data corresponding to the XML identifier referenced by the relational data, and wherein the XML data was received from the sender partition separately from the relational data;
• receiving from the sender partition separately from the relational data and the XML data, sender index keys referencing the XML identifier, wherein the sender index keys contain sender RID's and XID's;
• determining, from the stored RID's and stored XID's, which receiver RID's and XID's are mapped to the XML identifier referenced by the sender index keys;
• and
• modifying the received sender index keys by replacing the sender RID's with the determined receiver RID's and by replacing the sender XID's with the determined receiver XID's.