Method and apparatus for formally specifying application-specific read/write consistency

• US 7,624,108 B1
• Filed: 06/25/2003
• Issued: 11/24/2009
• Est. Priority Date: 06/25/2003
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Sun Microsystems Incorporated (Oracle Corporation)
• Inventors: Ali, Syed M., Kamen, Yury, Daniels, Bruce K., Goldberg, Robert N.
• Primary Examiner(s): Jalil; Neveen Abel
• Assistant Examiner(s): Hicks; Michael J
• Application Number:
  US10/603,884
• Time in Patent Office: 2,344 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database

Abstract

A system for specifying read/write consistency for an application including an application including at least one transaction, wherein the at least one transaction includes at least one of a plurality of states, at least one of a plurality of transitions, and at least one artifact; and a database operatively connected to the application, wherein the application accesses data associated with the at least one artifact using a read/write consistency specification; wherein the read/write consistency specification specifies at least one selected from the group consisting of a read consistency and a write consistency for the at least one artifact within the transaction.

Claims

1. A system for specifying consistency for an application, comprising:

an application comprising a transaction, wherein the transaction comprises at least one of a plurality of states, at least one of a plurality of transitions, and at least one artifact; and

a database operatively connected to the application;

wherein the application accesses data from the database associated with the at least one artifact using a consistency specification when the application enters the at least one of the plurality of the states; and

wherein the consistency specification specifies at least one of a read consistency and a write consistency to apply to the at least one artifact.

2. The system of claim 1, wherein the application is defined using an application usage specification.

3. The system of claim 1, wherein the application is designed using an application usage specification and a business object specification.

4. The system of claim 3, wherein the business object specification defines a variable of a business object.

5. The system of claim 4, wherein the business object specification defines how the business object is to be used in within the plurality of states and the plurality of transitions using the application usage specification.

6. The system of claim 1, wherein the application is designed using an application usage specification and a database schema.

7. The system of claim 6, wherein the database schema defines an attribute in a database schema.

8. The system of claim 7, wherein the database schema defines how the attribute is applied within the plurality of states and the plurality of transitions using the application usage specification.

9. The system of claim 1, wherein the database is a relational database.

10. The system of claim 1, wherein the read consistency includes at least one selected from the group consisting of none, read once, re-read, and read consistent.

11. The system of claim 1, wherein the write consistency includes at least one selected from the group consisting of none, creating an object, write over, write append, and write consistent.

12. The system of claim 1, wherein the artifact is one selected from the group consisting of a variable, an attribute, and a relationship.

13. A method for generating an application, comprising:

obtaining a business object specification that defines at least one artifact;

obtaining an application usage specification that defines the application as a plurality of states and a plurality of transitions, wherein the at least one artifact is associated with one of the plurality of states;

obtaining a consistency specification that corresponds to at least one transaction, wherein the at least one transaction comprises at least one of the plurality of states and one of the plurality of transitions and the consistency specification includes at least one of a read consistency and a write consistency to apply to the at least one artifact; and

generating the application using a database schema, the application usage specification, and the consistency specification;

wherein the artifact is one selected from the group consisting of a variable, a relationship, and an attribute

wherein the application accesses data from a database associated with the at least one artifact using the consistency specification when the application enters the at least one of the plurality of the states.

14. The method of claim 13, wherein the read consistency includes at least one selected from the group consisting of none, read once, re-read, and read consistent.

15. The method of claim 13, wherein the write consistency includes at least one selected from the group consisting of none, creating an object, write over, write append, and write consistent.

16. A computer-readable medium having recorded thereon instructions executable by a processor, the instructions for:

obtaining a database schema that defines at least one artifact;

obtaining an application usage specification that defines the application as a plurality of states and a plurality of transitions, wherein the at least one artifact is associated with one of the plurality of states;

obtaining a consistency specification that corresponds to at least one transaction, wherein the at least one transaction comprises at least one of the plurality of states and one of the plurality of transitions and the consistency specification includes at least one of a read consistency and a write consistency to apply to at least one artifact; and

generating the application using the database schema, the application usage specification, and the consistency specification,

wherein the application accesses data from a database associated with the at least one artifact using a consistency specification when the application enters the at least one of the plurality of the states.

17. An apparatus for generating an application, comprising:

means for obtaining a database schema that defines at least one artifact;

means for obtaining an application usage specification that defines the application as a plurality of states and a plurality of transitions, wherein the at least one artifact is associated with one of the plurality of states;

means for obtaining a consistency specification that corresponds to at least one transaction, wherein the at least one transaction comprises at least one of the plurality of states and one of the plurality of transitions and the consistency specification includes at least one of a read consistency and a write consistency to apply to the at least one artifact; and

means for generating the application using the database schema, the application usage specification, and the consistency specification;

wherein the artifact is one selected from the group consisting of a variable, a relationship, and an attribute,

wherein the application accesses data from a database associated with the at least one artifact using a consistency specification when the application enters the at least one of the plurality of the states.