Using XML for flexible replication of complex types

• US 20080040369A1
• Filed: 08/09/2006
• Published: 02/14/2008
• Est. Priority Date: 08/09/2006
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Arora, Nimar, Warner, James W., Murthy, Ravi, Krishnaprasad, Muralidhar, Liu, Zhen Hua, Lu, Edwina, Arora, Geeta, Abraham, Sundeep
• Granted Patent: US 7,801,856 B2
• Time in Patent Office: Days
• US Class Current: 707/101
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

Instances of complex types are logically replicated. In general, the logical replication of complex types involves converting a complex type instance from its storage format into a logical representation written in a markup language, like XML. The logical representation is then propagated to a destination (or destinations), which converts the logical representation to a storage format used at the destination for that complex type.

Claims

1. A method of replicating objects at multiple sites, the method comprising the steps of:

converting an instance of a complex type from a first storage format used at a source site to a logical representation that conforms to a markup language;

propagating said logical representation to at least one destination site; and

at the destination site, converting said logical representation to a second storage format that may be different from said storage format.

2. The method of claim 1, wherein the step of converting an instance includes incorporating within said logical representation information that identifies the type of the complex type.

3. The method of claim 1, wherein:

the steps further include determining that there is a subtype defined for said complex type; and

the step of incorporating is performed in response to determining that there is a subtype defined for said complex type.

4. The method of claim 1, wherein:

said instance includes a site specific component; and

the steps of converting an instance includes;

generating a logical representation for said site specific component that is recognized by other sites of said plurality of sites, and

incorporating said logical representation of said site specific component within said logical representation of said complex type.

5. The method of claim 1, wherein:

said instance includes an object reference that includes a table identifier that identifies a table at said source site that stored said instance;

generating a logical representation of said table identifier that is recognized by other sites of said plurality of sites as said table; and

incorporating said logical representation of said table identifier within said logical representation of said complex type.

6. The method of claim 5, wherein said logical representation includes a table name of said table.

7. The method of claim 5, wherein:

said instance is stored in an object table of an object type;

wherein one or more columns are primary keys for instances of said object stored in said object table; and

wherein said object reference includes a representation of a value for each of said one or more columns.

8. The method of claim 1, wherein said complex type is an opaque type.

9. The method of claim 8, wherein:

converting an instance of a complex type includes invoking a user registered function registered to covert instances of said complex type to logical representations of said instances; and

converting said logical representation to a second storage format includes invoking a user registered function registered to covert logical representations of said instances to said second storage format.

10. The method of claim 1, wherein:

said source site defines a first version of said complex type;

said destination site defines a second version of said complex type; and

the steps further include transforming said logical representation to represent said second version of said complex type.

11. The method of claim 10, wherein transforming includes changing the order of attributes within said logical representation.

12. The method of claim 11, wherein transforming includes adding or removing attributes not defined by said second version.

13. The method of claim 10, wherein execution of instructions that conform to one or more XML languages causes said transforming said logical representation.

14. The method of claim 13, wherein said one or more XML languages include at least one language from a set languages that include XSLT and XQuery.

15. The method of claim 1, wherein said markup language is either XML or SGML.

16. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 1.

17. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 2.

18. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 3.

19. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 4.

20. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 5.

21. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 6.

22. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 7.

23. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 8.

24. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 9.

25. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 10.

26. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 11.

27. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 12.

28. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 13.

29. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 14.

30. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 15.