29-04-2014, 02:50 PM
Java Applet Based Database Management Interface
[attachment=62642]
ABSTRACT
The Java Applet Based Database Management Interface is essentially a java application
that is operable from within a web browser and can be used to create and maintain SQL
compliant databases remotely over a network. This system follows the standard client-
server paradigm. The client side is implemented as a Java applet that runs under web
browsers. In this project the server side creates and maintains a MySQL relational
database, but the key point of this project is that the applet developed here can serve as an
interface to any database that adheres to the current SQL standard.
Several computer science graduate students at Florida State University have worked on
this system and implemented different modules. Ms. Tamanna Kazi implemented the
Tables module and provided functions for creation and management of the tables in the
database. Ms. Ming Li implemented a version of query and forms module. Yan Mao
implemented another version of the queries module by modifying Ming Li's version to
allow for defining relations between multiple tables, and also added a first draft reports
module. However, all these projects used Java sockets for the client-server
communication. This approach is known to have security problems. Java sockets on the
server side can be easily exploited by hackers.
INTRODUCTION
Background
This project is part of an ongoing effort to create a Java Applet that acts as an interface
for creation and management of an SQL compliant database over a network. The intuition
behind this is that since Java Applets can run inside a web browser, it will be possible to
use this interface for creating and managing databases remotely over a network.
Several Computer Science graduate students at Florida State University have contributed
in the development of this system. Ms. Tamanna Kazi designed the Tables Module which
allowed the users to perform the entire tables’ management part. Ming Li added a queries
module and a preliminary forms module. Yan Mao redid the queries module in Ming Li's
version to allow for defining relations between multiple tables, and added a first draft
reports module. However, the work done by these students used Java sockets for client
server communication.
Java and Applets
Java was chosen as the baseline programming language for this project. The entire
GUI (Graphical User Interface) for this system has been designed using the Java
SWING packages. Java is the language of the internet. In addition to the
programming language itself, Java has a rich library that makes it possible to write
portable programs that are operating system independent. Java also has a rich set of
security features that help in learning the language faster. The java virtual machine
can catch many kinds of mistakes and report them accurately. Instead of producing
executable code, a Java compiler produces byte code. The Java run-time system is an
interpreter for byte code. Once the Java run-time package exists for a given system,
the byte code version of any Java program can run on it. Therefore, Java produces
truly portable programs.
[attachment=62642]
ABSTRACT
The Java Applet Based Database Management Interface is essentially a java application
that is operable from within a web browser and can be used to create and maintain SQL
compliant databases remotely over a network. This system follows the standard client-
server paradigm. The client side is implemented as a Java applet that runs under web
browsers. In this project the server side creates and maintains a MySQL relational
database, but the key point of this project is that the applet developed here can serve as an
interface to any database that adheres to the current SQL standard.
Several computer science graduate students at Florida State University have worked on
this system and implemented different modules. Ms. Tamanna Kazi implemented the
Tables module and provided functions for creation and management of the tables in the
database. Ms. Ming Li implemented a version of query and forms module. Yan Mao
implemented another version of the queries module by modifying Ming Li's version to
allow for defining relations between multiple tables, and also added a first draft reports
module. However, all these projects used Java sockets for the client-server
communication. This approach is known to have security problems. Java sockets on the
server side can be easily exploited by hackers.
INTRODUCTION
Background
This project is part of an ongoing effort to create a Java Applet that acts as an interface
for creation and management of an SQL compliant database over a network. The intuition
behind this is that since Java Applets can run inside a web browser, it will be possible to
use this interface for creating and managing databases remotely over a network.
Several Computer Science graduate students at Florida State University have contributed
in the development of this system. Ms. Tamanna Kazi designed the Tables Module which
allowed the users to perform the entire tables’ management part. Ming Li added a queries
module and a preliminary forms module. Yan Mao redid the queries module in Ming Li's
version to allow for defining relations between multiple tables, and added a first draft
reports module. However, the work done by these students used Java sockets for client
server communication.
Java and Applets
Java was chosen as the baseline programming language for this project. The entire
GUI (Graphical User Interface) for this system has been designed using the Java
SWING packages. Java is the language of the internet. In addition to the
programming language itself, Java has a rich library that makes it possible to write
portable programs that are operating system independent. Java also has a rich set of
security features that help in learning the language faster. The java virtual machine
can catch many kinds of mistakes and report them accurately. Instead of producing
executable code, a Java compiler produces byte code. The Java run-time system is an
interpreter for byte code. Once the Java run-time package exists for a given system,
the byte code version of any Java program can run on it. Therefore, Java produces
truly portable programs.