Backward compatibility in database schemas

• US 7,844,639 B2
• Filed: 03/08/2005
• Issued: 11/30/2010
• Est. Priority Date: 11/24/2003
• Status: Expired due to Fees

• Current Assignee: PayPal, Inc. (PayPal Holdings, Inc.)
• Original Assignee: eBay Inc.
• Inventors: Avalani, Bhaven, Cohen, Alon, Ahmed, Zahid
• Primary Examiner(s): LeRoux; Etienne P
• Assistant Examiner(s): GIRMA, ANTENEH B
• Application Number:
  US11/074,541
• Publication Number:
  US 20050149543A1
• Time in Patent Office: 2,093 Days
• Field of Search: 707/100, 707/102
• US Class Current: 707/803
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/213 with details for schema evolution support
• CPC Class Codes: G06Q 30/08 Auctions
• CPC Class Codes: H04L 67/10 in which an application is distributed across nodes in the network software deployment G06F8/60; multiprogramming arrangements G06F9/46

Abstract

A method of accommodating at least one difference between a first database schema and a second database schema is provided. The method includes receiving a request from a first application program that is operationally dependent upon the first database schema, the request being received at a second application program that is operationally dependent upon the second database schema. Thereafter, the method identifies if there is a difference between the first database schema and the second database schema. When there is a difference, the method identifies the difference between the first database schema and the second database schema to identify at least one different schema definition element and associates the different schema definition element with a reserved element. The reserved element may have a corresponding reserved element provided in the first database schema. A response is then communicated to the first application program including the reserved element.

Claims

1. A method of accommodating at least one difference between a first database schema and a second database schema, the method including:

receiving a request from a first application program that is operationally dependent upon the first database schema, the first database schema comprising a custom slot that is included in the first database schema upon creating the first database schema, the custom slot being a placeholder, and the request being received at a second application program that is operationally dependent upon the second database schema;

identifying at least one different schema definition element between the first database schema and the second database schema;

generating a response, the response including a reserved element that corresponds to the custom slot provided in the first database schema, the reserved element being a substitute for the different schema definition element and being an indication that the different schema definition element is not included in the first database schema; and

communicating the response to the first application program.

2. The method of claim 1, wherein the first database schema is a client-side database schema and the first application program is a client application, and the second database schema is a server-side database schema and the second application program is a server application.

3. The method of claim 2, wherein the server application program is an Application Program Interface (API) of a network-based commerce facility, the API communicating with a plurality of remote client applications.

4. The method of claim 1, wherein the identifying if there is a difference between the first and the second database schemas includes identifying a version number of the first database schema.

5. The method of claim 1, wherein the database schema includes a schema definition that includes at least one custom slot.

6. The method of claim 5, wherein the schema definition is an XML schema definition and the custom slot is provided in a schema dictionary.

7. The method of claim 1, wherein the requests and responses are communicated using Web Services Description Language (WSDL) messages.

8. A machine-readable medium comprising instructions which, when executed by a machine, cause the machine to:

receive a request from a first application program that is operationally dependent upon the first database schema, the first database schema comprising a custom slot that is included in the first database schema upon creating the first database schema, the custom slot being a placeholder, and the request being received at a second application program that is operationally dependent upon the second database schema;

identify at least one different schema definition element between the first database schema and the second database schema;

generate a response, the response including a reserved element that corresponds to the custom slot provided in the first database schema, the reserved element being a substitute for the different schema definition element and being an indication that the different schema definition element is not included in the first database schema; and

communicating the response to the first application program.

9. A system to accommodate at least one difference between a first database schema and a second database schema, the system including:

a programmatic interface to receive a request from a first application program that is operationally dependent upon the first database schema, the first database schema comprising a custom slot that is included in the first database schema upon creating the first database schema, the custom slot being a placeholder, and the request being received at a second application program that is operationally dependent upon the second database schema; and

a processing module comprising at least one processor to;

identify at least one different schema definition element between the first database schema and the second database schema, and

generate a response, the response including a reserved element that corresponds to the custom slot provided in the first database schema, the reserved element being a substitute for the different schema definition element and being an indication that the different schema definition element is not included in the first database schema; and

wherein the programmatic interface is to communicate the response to the first application program.

10. The system of claim 9, wherein the first database schema is a client-side database schema and the first application program is a client application, and the second database schema is a server-side database schema and the second application program is a server application.

11. The system of claim 10, wherein the server application program is an Application Program Interface (API) of a network-based commerce facility, the API communicating with a plurality of remote client applications.

12. The system of claim 9, wherein the identifying if there is a difference between the first and the second database schemas includes identifying a version number of the first database schema.

13. The system of claim 9, wherein the database schema includes a schema definition that includes at least one custom slot.

14. The system of claim 13, wherein the schema definition is an XML schema definition and the custom slot is provided in a schema dictionary.

15. The system of claim 9, wherein the requests and responses are communicated using Web Services Description Language (WSDL) messages.

16. A system to accommodate at least one difference between a first database schema and a second database schema, the system including:

means for receiving a request from a first application program that is operationally dependent upon the first database schema, the first database schema comprising a custom slot that is included in the first database schema upon creating the first database schema, the custom slot being a placeholder, and the request being received at a second application program that is operationally dependent upon the second database schema;

means, using a processor, for identifying at least one different schema definition element between the first database schema and the second database schema;

means for generating a response, the response including a reserved element that corresponds to the custom slot provided in the first database schema, the reserved element being a substitute for the different schema definition element and being an indication that the different schema definition element is not included in the first database schema; and

means for communicating the response to the first application program.