Using Java to Add "Stored Procedures" to Databases

Authors:
Raimund K. Ege;Naphtali Rishe;Jingyu Liu;Vladimir Lebedev
Affiliations:
-;-;-;-
Venue:
TOOLS '99 Proceedings of the Technology of Object-Oriented Languages and Systems
Year:
1999

Citing 8
Cited 0

Object-oriented concepts, databases, and applications

Object-oriented concepts, databases, and applications
Database design: the semantic modeling approach

Database design: the semantic modeling approach
A file structure for semantic databases

Information Systems
Oracle: PL/SQL programming

Oracle: PL/SQL programming
SYBASE SQL Server 11 Unleashed

SYBASE SQL Server 11 Unleashed
Java Developers Guide; With Cdrom

Java Developers Guide; With Cdrom
Java Virtual Machine Specification

Java Virtual Machine Specification
The Java Language Specification

The Java Language Specification

Quantified Score

Hi-index	0.00

Visualization

Abstract

The paper describes our approach to adding "stored procedure" capability to a semantic database system using Java byte-codes and Java's ability to dynamically load and execute Java code. Several steps were necessary: first we added a Java application programmer interface to the database system; then we created a database schema to hold Java executable code; then we constructed a Java class loader to allow code to be loaded from the database; then we enabled the creation of Java objects and executed the Java code for them. Our approach is not specific to our semantic database system, rather it can serve as a recipe for adding "stored procedures" to any database system.