Formulation is putting together of components in appropriate relationships according to a formula. In databases, Query formulation is an essential part of successful information retrieval. Formulation of valid queries on a relational database, the user must be familiar with SQL known as Structured Query Language. The Information Technology professionals can easily query the data and get information. However, normal users are not familiar with query languages and syntax of a particular query, but would like to access data in a more user friendly way. The goal of this paper is to present a query formulation using a window based application tool that allows users to easily build a query and retrieve the data using an almost natural language, on a step by step basis guided by the tool.
KeywordsQuery Formulation, Structured Query Language, Visual query systems, Visual query language, and Graphical user interface.
1.INTRODUCTIONIt create a window based Application where is SQL is user friendly. In SQL, customer has to remember the syntax of Query to maintain Database Management which is very difficult. So, to maintain Database in SQL in user friendly format is main motive of paper. The user can use SQL in user friendly format, where customer will be asked every specification of Query in click format. The data will be queried in the form of web. In this paper the software used MS SQL SERVER 2000 for Database and ASP.NET with VB.NET in frontend for Application Development. Being a language is not merely an interface and, at the same time, assuming data to be schema-free is one of the key challenges addressed in the context of design and development of this research paper. Without loss of generality, this article focuses on the Data Web scenario. The Web as a database, where each data source is seen as table.[1] This system under development explore and query one or multiple data sources without prior knowledge about the syntax, IT schema, structure, vocabulary, or any technical details of these sources. This is mainly based on Visual Query Languages represent an evolution, in terms of understandability and adaptability, with respect to traditional textual languages. The iconic query system that enables the interaction of a novice user with a relational database. The paper is to help a user to use and retrieve the relational data from a query language such as SQL. This Visual Query Language is Window based user friendly software applications interacting with the Relational Databases. The system is to provide a language that is easy to use also for non expert users, as it does not require special knowledge of the content of the underlying database or understanding the details of the database schema. The Window based graphical interface, is a visual query processing facility that allows users to query a database through the use of icons.[2]
Advantages Reduction of the time needed to formulate a query by humancomputer interaction. The graphical click and select representations, where tables are used to represent ...