System and interface for manipulating a database

• US 20050138064A1
• Filed: 01/18/2005
• Published: 06/23/2005
• Est. Priority Date: 07/20/2002
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Anonsen, Steven P., Trappen, Anthony R.
• Granted Patent: US 7,461,053 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99936 Pattern matching access

Abstract

An interface exposes methods for use in manipulating a database. The interface receives requests in terms of entities (or objects).

Claims

1. An application programming interface (API), exposed by objects in an object model, the API having methods which, when invoked, cause a data accessing system implemented by objects in the object model to receive a request and manipulate data in a relational database based on the request.

2. The API of claim 1 wherein the request is expressed in terms of the object model.

3. The API of claim 2 wherein the request identifies an entity having associated data.

4. The API of claim 3 wherein the object model includes an object that exposes a portion of the API, having a method which, when invoked, reads the data associated with the identified entity.

5. The API of claim 3 wherein the object model includes an object that exposes a portion of the API, having a method which, when invoked, deletes the data associated with the identified entity.

6. The API of claim 3 wherein the object model includes an object that exposes a portion of the API, having a method which, when invoked, writes the data associated with the identified entity.

7. The API of claim 3 wherein the object model includes an object that exposes a portion of the API, having a method which, when invoked, updates the data associated with the identified entity.

8. The API of claim 3 wherein the object model includes an object that exposes a portion of the API, having a method which, when invoked, returns only a specified part of the data associated with the identified entity.

10. The API of claim 3 wherein the request identifies a set of entities each having associated data and wherein the object model includes an object that exposes a portion of the API, having a method which, when invoked, performs an operation on the identified set of entities.

13. The API of claim 3 wherein the object model includes an object that exposes a portion of the API, having a method which, when invoked, implements parameters that specify a manipulation of a database.

9. (canceled)

11. (canceled)

12. (canceled)

14. A data accessing system in an object-relational (O-R) database system, the data accessing system exposing an interface which, when invoked, causes the data accessing system to perform steps of:

receiving a request expressed in terms of an object model; and

manipulating data in the O-R database system based on the request.

15. The data accessing system of claim 14 wherein the request identifies an entity and wherein manipulating data comprises:

accessing the identified entity in the O-R database.

20. The data accessing system of claim 14 wherein the request identifies an entity having associated data and wherein manipulating data comprises:

inserting the data associated with the identified entity to a relational database portion of the database.

16. (canceled)

17. (canceled)

18. (canceled)

19. (canceled)

21. A computer readable medium storing computer readable instructions which, when read, cause the computer to implement an application programming interface (API), exposed by objects in an object model, the API having methods which, when invoked, cause a data accessing system implemented by objects in the object model to receive a request and manipulate data in a relational database based on the request.

22. The computer readable medium of claim 21 wherein the API receive the request wherein the request is expressed in terms of the object model.

23. The computer readable medium of claim 22 wherein the request identifies an entity having associated data.

24. The computer readable medium of claim 23 wherein the object model includes an object that exposes a portion of the API, having a method which, when invoked, reads the data associated with the identified entity.

25. The computer readable medium of claim 23 wherein the object model includes an object that exposes a portion of the API, having a method which, when invoked, deletes the data associated with the identified entity.

26. The computer readable medium of claim 23 wherein the object model includes an object that exposes a portion of the API, having a method which, when invoked, writes the data associated with the identified entity.

27. The computer readable medium of claim 23 wherein the object model includes an object that exposes a portion of the API, having a method which, when invoked, updates the data associated with the identified entity.

28. The computer readable medium of claim 22 wherein the object model includes an object that exposes a portion of the API, having a method which, when invoked, performs an operation on a set of entities.