project idea(universal database viewer)

Project Idea | (Universal Database Viewer)



Introduction

The main object of this project is to provide the database in GUI oriented format through which we can retrieve information about the remote database and their tables for proper manipulation. GUI programming can be done in JAVA IDE.


Features


This Universal Persistent Viewer is a utility for database browsing. It provides an interface for viewing a database. We can browse a remote database also and change its contents even if the client side software is not available for the database.


One main important aspect of this project is SQL interpreter, which is used to execute queries by which the table can be modified. Queries can also be executed in this utility. The records can be added deleted and modified in a table. Records can be viewed with the specified condition. The final results are provided in a table format. The project also includes the properties of database, which provide the functions, keywords, supporting functions, maximum functions whichever needed.


Software Required

  • Any Java basedIDE.
  • Any Database Management Software (Preferably MySQL).


Advanced Features

  • We will import and export the table across the Database.
  • Within the Database version dependency will be prevented. As it can convert Oracle’s version 10 to 11 version.
  • Across the Database transparency.
  • Data type difference can be managed easily.


This Project Idea is contributed by Anurag Gupta.If you like GeeksforGeeks and would like to contribute, you can also write an article and mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s