GUI Database – A Review

Abstract

This paper will explain the concept of creating a Graphical User Interface for Relational Database Management Systems. This is a general-level GUI, which can be connected to the database system i.e SQL server. As a result, the database manipulation can be performed using single interface. Moreover, the queries can be executed very easily, since the user needs not  to  type  any  queries,  but  can  simply select the appropriate options according to their requirements. Thus, this software can be used by a person with no knowledge of SQL. This software is developed using .net as front end and SQL Server as backend. This paper provide only the operations most commonly required, thereby reducing complexity. Code optimization is the refining process in database administration and it helps to bring down speed of execution. Some object-oriented languages allows to express queries explicitly in the code, which are optimized using the query optimization techniques from the database domain