GUI IMPLEMENTATION OF MYSQL WORKBENCH FOR SCRIPT GENERATION IN MULTIPLE DATABASES
| Main Authors: | Akash Jadhav, Prof.Kumkum Bala |
|---|---|
| Other Authors: | IRJCS: International Research Journal of Computer Science |
| Format: | Article eJournal |
| Bahasa: | eng |
| Terbitan: |
, 2020
|
| Subjects: | |
| Online Access: |
https://zenodo.org/record/3879053 |
Daftar Isi:
- A guided user interface application developed in swing framework to build database, table, triggers and audit table for same model on different databases. Databases have been used in a query based format. Database languages like Mysql and Postgres have different workbenches for table operations. The main challenges for today's frontend developers is struggling through learning of different back-end software. We have implemented a simple interface that allows sql script generation in a text file format for table creation on multiple databases for same mode.
- Data in organizations can be compared to life in living organisms. Data runs the industry irrespective of size of company. Data is available in multiple forms depending on various factors such as time period, importance and the application of data. Data, often received in unordered format can be converted into tables if categorized in regular instances. Data loss for an organization is crucial and might incur huge loss in terms of money and time. Thus structuring of data is an important task, regardless of the amount of data. Databases provide an excellent solution to the problem of classification and grouping of data. Databases like MySQL, PostGreSQl etc. work in query based programming, where query is replied by result from the database. Common difficulties occurring in such mannerism arises while creation of tables with multiple tuples. Such difficulties can be eliminated by providing a guided user interface for table creation such as MySql WorkBench. Even though creation of tables has been made easy, conversion of one database to another database provides difficulties for most of the front-end developers who keep on experimenting with different types of databases. For each database, tables need to be created from scratch which provides a major drawback with increasing tuples in a table. As a solution to this problem, we have created an application which allows generation of query scripts in various databases, similar to workbench without disturbing the characteristics of table. The generation of these scripts is a text file, which can be run on command prompt of different databases for quick table generation. The text files are automatically stored in a directory previously. Selected by the user and holds different versions of same table, indexed in terms of time and date. Different versions of tables can be seen in the directory and referenced for future table generation. Along with text files, format of tables remain saved with functionalities like opening a previous table model and editing to create a different versions.