Data storage schema independent programming for data retrieval using semantic bridge

• US 6,711,579 B2
• Filed: 04/20/2001
• Issued: 03/23/2004
• Est. Priority Date: 04/20/2001
• Status: Expired due to Fees

• Current Assignee: SREE Ayyanar Spinning and Weaving Mills Limited
• Original Assignee: SREE Ayyanar Spinning and Weaving Mills Limited
• Inventors: Balakrishnan, Prabaharan
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US09/839,814
• Publication Number:
  US 20030110467A1
• Time in Patent Office: 1,068 Days
• Field of Search: 707/102, 717/174
• US Class Current: 1/1
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 8/35 model driven
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A computer implemented process accesses data stored on one or more computers, the data on each computer having a data storage schema. A program is generated to access the data using terms and constructs of a semantic programming interface. The semantic programming interface provides an abstract, object-oriented representation of the data that is independent of the data storage schemas of the data. Mappings of the representation of the data in the semantic programming interface to each of the data storage schemas of the data stored on the one or more computers are created. The data mappings are used to translate the interface-based program into one or more executable programs. The executable programs are run to access the data stored on the one or more computers. System security and data security are maintained on the one or more computers.

Claims

1. A method of processing data stored on one or more computers, the data on each of the one or more computers having a data storage schema, the method comprising:

(a) receiving an interface-based program on each the one or more computers to process the data, said interface-based program using terms and constructs of a semantic programming interface, the semantic programming interface providing an abstract, object-oriented representation of the data that is independent of the data storage schemas of the data;

(b) generating a mapping of the representation of the data in the semantic programming interface to each of the data storage schemas, each mapping utilizing rules for generating user-specific views of the data stored on the one or more computers;

(c) translating the interface-based program into one or more executable programs; and

(d) running the one or more executable programs on the one or more computers in combination with each data mapping to process the data stored on the one or more computers in accordance with the user-specific views.

2. The method of claim 1 wherein the data stored on the one or more computers is contained in one or more databases.

3. The method of claim 2 wherein each data mapping is a field level mapping that associates the terms and constructs of the semantic programming interface with database fields of each of the one or more databases.

4. The method of claim 1 wherein a user seeks to process the data stored in the one or more computers, the data having access permissions, the method further comprising:

(e) identifying and authenticating the user to determine the user'"'"'s access permissions for the data.

5. The method of claim 4 wherein the data stored on the one or more computers is contained in one or more databases and the access permissions of the databases define which fields, rows and tables within the databases the user is entitled to access.

6. The method of claim 4 wherein the data stored on the one or more computers is contained in one or more documents stored on the one or more computers and the access permissions of the documents define which portions of the documents the user is entitled to access.

7. The method of claim 1 wherein the representation of the data in the semantic programming interface includes a specification of properties of the data and relationships among the data.

8. The method of claim 7 wherein data is denoted using the semantic programming interface directly, or indirectly using its relationship with other data, or indirectly using properties of the data.

9. The method of claim 1 wherein the data stored on the one or more computers is contained in one or more documents stored on the one or more computers.

10. The method of claim 1, wherein the user-specific views are generated at runtime by expressions constructed from the mapping to each of the data storage schemas.

11. The method of claim 10 wherein the expressions use SQL syntax.

13. The method of claim 11 wherein the data stored on the one or more server computers is contained in one or more databases.

14. The method of claim 13 wherein each data mapping is a field level mapping that associates the terms and constructs of the semantic programming interface with database fields of each of the one or more databases.

12. A method of implementing processing on one or more server computers, the data on each of the one or more server computers having a data storage schema, the method comprising:

(a) generating an interface-based object program at the client computer to process the data, said interface-based object program using terms and constructs of a semantic programming interface, the semantic programming interface providing an abstract, object-oriented representation of the data that is independent of the data storage schemas of the data;

(b) generating a mapping on each of the server computers of the representation of the data in the semantic programming interface to each of the data storage schemas of the data stored on the one or more server computers, each mapping providing information for generating user-specific views of the data stored on the one or more computers;

(c) transmitting the interface-based object program from the client computer to the one or more server computers;

(d) translating the interface-based object program into one or more executable programs at the one or more server computers;

(e) running the one or more executable programs on the one or more server computers in combination with one or more of the data mappings to process the data at the one or more server computers; and

(f) returning the processed data to the client computer.

15. The method of claim 12 wherein a user seeks to process the data stored in the one or more server computers, the data having access permissions, the method further comprising:

(g) identifying and authenticating the user to determine the user'"'"'s access permissions for the data.

16. The method of claim 15 wherein the data stored on the one or more server computers is contained in one or more databases and the access permissions of the databases define which fields, rows and tables within the databases the user is entitled to access.

17. The method of claim 15 wherein the data stored on the one or more server computers is contained in one or more documents stored on the one or more server computers and the access permissions of the documents define which portions of the documents the user is entitled to access.

18. The method of claim 12 the representation of the data in the semantic programming interface includes a specification of properties of the data and relationships among the data.

19. The method of claim 18 wherein data is denoted using the semantic programming interface directly, or indirectly using its relationship with other data, or indirectly using properties of the data.

20. The method of claim 12 wherein the data stored on the one or more server computers is contained in one or more documents stored on the one or more server computers.

21. The method of claim 12, wherein the user-specific views are generated at runtime by expressions constructed from the mapping to each of the data storage schemas.

22. The method of claim 21 wherein the expressions use SQL syntax.

23. A method using denotations for specifying a semantic programming interface, said method for use by a user processing data stored in one or more databases on one or more computers, the method comprising:

(a) identifying computationally meaningful relationships between the data and computationally meaningful groupings of the data;

(b) representing the data as objects, each object having associated methods; and

(c) declaring the computationally meaningful relationships and computationally meaningful groupings as the methods associated with the objects;

(d) denoting objects of interest using the relationships and roles the objects of interest play in relation to other ones of the objects; and

(e) constructing data selection logic using said denotations without direct access by the user to the one or more databases.

24. The method of claim 23 wherein the methods declared in step (c) return one or more object identifiers.

25. A method for executing on a server computer a source program written on a client computer, the method comprising:

(a) transmitting the source program from the client computer to the server computer along with an identification of a program domain for which the source program is written;

(b) storing the source program on the server computer;

(c) instantiating on the server computer a secure first loader capable of loading classes in the program domain and a secure second loader capable of loading the source program when it has been compiled;

(d) compiling the source program on the server computer;

(e) loading the compiled program using the second loader; and

(f) running the compiled program on the server computer.

26. The method of claim 25 wherein the source program is designed to process data stored on the server computer, the data having a data storage schema.

27. The method of claim 26 wherein the source program is written using terms and constructs of a semantic programming interface, the semantic programming interface providing an abstract, object-oriented representation of the data that is independent of the data storage schema of the data.

28. The method of claim 26 wherein running the compiled program on the server computer generates output from the processed data, the method further comprising:

(g) transmitting the output from the server computer to the client computer.

29. The method of claim 25 wherein a user generates the source program written on the client computer, the method further comprising:

(h) identifying and authenticating the user on the server computer to determine the user'"'"'s access permissions on the server computer.

30. A method of creating and executing one or more programs on a client computer for processing data from one or more domains, the data being stored on one or more server computers, the method comprising:

(a) identifying the one or more domains and the one or more server computers;

(b) generating request code and response handler code, said request code to process the data stored on the one or more server computers and said response handler code to handle an output received from the one or more server computers in response to receiving a request generated by the request code, wherein said request code and said response handler code use terms and constructs of a semantic programming interface, the semantic programming interface providing an abstract, object-oriented representation of the data that is independent of the data storage schema of the data, and wherein the response handler code includes the capability of identifying a new set of servers and the capability of handling information that may be used as parameters in a succeeding request, depending on the nature of the further processing required in the original request;

(c) combining the request code and the response handler code to form one or more chores including nested chores of different kinds; and

(d) queuing the chores for execution.

31. The method of claim 30 wherein in step (d) the chores are serviced using multiple threads.

32. The method of claim 30 wherein the one or more identified servers in step (a) are divided among one or more client machines to carry out steps (b) through (d) in parallel.

33. The method of claim 30 wherein each request encapsulates information specific to one of the server computers including the IP address of the server computer, authentication information, protocols needed, the code to be executed and values for code parameters.