Method and apparatus for using Java as a stored procedure language and as an embedded language on a client

• US 6,477,540 B1
• Filed: 12/22/1999
• Issued: 11/05/2002
• Est. Priority Date: 12/22/1999
• Status: Expired due to Term

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation
• Inventors: Singh, Ashutosh, Patel, Jignesh M., Kabra, Navin
• Primary Examiner(s): Mizrahi, Diane D.
• Application Number:
  US09/470,228
• Time in Patent Office: 1,049 Days
• Field of Search: 707/103.R, 707/10, 707/2, 707/206, 707/3, 709/102, 709/226, 709/231, 717/107, 710/33, 714/35
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2291 User-Defined Types; Storage management thereof
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

One or more embodiments of the invention provide the ability to utilize the Java programming language as a stored procedure language. One or more embodiments of the invention provide for Java abstract data types (ADT) that map to ADT attributes from a database. The Java ADT can then be manipulated in an application written in the Java programming language such as a stored procedure. Each ADT attribute from a database is mapped to a Java class by wrapping the ADT definition (which is commonly written in C ++) in a Java wrapper. The wrapping process enables a user to write any client side Java application. Once the ADTs are wrapped and a stored procedure is created, the stored procedure must be able to execute. Enhancements permit a stored procedure written in the Java programming language to execute. Such enhancements include a server side cursor that the stored procedure can use to run SQL queries. Additionally, the server has been enhanced to link to a Java virtual machine that can be used to execute the bytecodes of the stored procedure written in the Java programming language.

Claims

1. A method of using Java as a stored procedure programming language comprising:

obtaining an abstract data type attribute from a database;

wrapping the abstract data type attribute in a Java class; and

executing a stored procedure in a Java virtual machine, wherein the stored procedure is written in the Java programming language and uses the Java class.

2. The method of claim 1 wherein the abstract data type attribute is defined in C++.

3. The method of claim 1 wherein the Java class comprises a put method.

4. The method of claim 1 wherein the Java class comprises a get method.

5. The method of claim 1 further comprising the stored procedure utilizing a server side cursor to execute an SQL query.

6. A system for using Java as a stored procedure programming language comprising:

a database comprised of an abstract data type attribute;

a Java class wrapping the abstract data type attribute;

a stored procedure on a data server, the stored procedure written in the Java programming language using the Java class;

a Java virtual machine configured to execute the stored procedure.

7. The system of claim 6 wherein the abstract data type attribute is defined in C ++.

8. The system of claim 6 wherein the Java class comprises a put method.

9. The system of claim 6 wherein the Java class comprises a get method.

10. The system of claim 6 further comprising a server side cursor used by the stored procedure to an execute SQL query.

11. An article of manufacture for using Java as a stored procedure programming language comprising:

means for obtaining an abstract data type attribute from a database;

means for wrapping the abstract data type attribute in a Java class; and

means for executing a stored procedure in a Java virtual machine, wherein the stored procedure is written in the Java programming language and uses the Java class.

12. The article of manufacture of claim 11 wherein the abstract data type attribute is defined in C ++.

13. The article of manufacture of claim 11 wherein the Java class comprises a put method.

14. The article of manufacture of claim 11 wherein the Java class comprises a get method.

15. The article of manufacture of claim 11 further comprising means for the stored procedure to utilize a server side cursor to execute an SQL query.