Efficient migration of binary XML across databases

摘要

Techniques are provided for transporting subset of databases containing binary XML data. In one embodiment, a method is provided that allows transporting binary XML data that conforms to schema by also transporting the schema entries that are necessary to derive the binary XML. In another embodiment, a method is provided that allows transporting binary XML data that does not conform to schema by also transporting the token tables that contain the mapping for the binary XML.

主权项

1. A computer implemented method for moving XML data from a source database to a target database, comprising:
generating a copy of a particular tablespace that is part of the source database,
wherein the particular tablespace contains first binary XML data;wherein the first binary XML data is XML data that has been encoded in a binary format,wherein the copy of the particular tablespace contains second binary XML data;wherein the second binary XML data is a copy of the first binary XML data; incorporating the copy of the particular tablespace into the target database,
wherein incorporating the copy of the particular tablespace into the target database causes the second binary XML data to be incorporated in the target database; determining translation information, that is used for decoding the first binary XML data in the source database, and that is needed to decode the second binary XML data in the target database; and generating a copy of the translation information from said source database; incorporating the copy of the translation information into the target database; after incorporating the copy of the particular tablespace and the copy of the translation information into the target database, using the copy of the translation information to decode the second binary XML data when the second binary XML data is accessed in the target database; wherein generating the copy of the translation information includes generating a copy of a set of token tables that contain the translation information necessary to decode the second binary XML data; wherein incorporating the copy of the translation information into the target database includes updating metadata within the target database to indicate that the copy of the set of token tables are associated with said copy of the particular tablespace; and wherein the steps of generating a copy of the particular tablespace, incorporating the copy of the particular tablespace, generating a copy of the translation information, incorporating the copy of the translation information, and using the copy of the translation information are performed by one or more computing devices.