GUI IMPLEMENTATION OF MYSQL WORKBENCH FOR SCRIPT GENERATION IN MULTIPLE DATABASES

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.