A New System for Database Query Generator

Abstract
In this paper a new type of system is described which can be used for generating the SQL queries
without having to manually write them or learn them. It can be used by the learning students as
well as by the people of the business which need to perform some actions on their databases. By
using this, the students can simply learn and understand how SQL queries can be written and
executed. Also for the people of business it is very helpful as if they use this system they can
generate queries for their databases and also can place the queries in their own application by
just simply pressing button. Also the person who don’t know about the SQL can easily use this
for generating their own queries which will be stored in the text document which they can make
use of it later. It helps the people to do their work very efficiently and quickly without having to
wait for the specialized person.

Keywords
Database, SQL queries, tables, columns, tuples, application.

1. INTRODUCTION
Query languages [1] are used to make queries in a database, and Microsoft Structured Query
Language (SQL) is the standard. Under the SQL query umbrella, there are several extensions of
the language, including MySQL, Oracle SQL and Nuo DB. Query languages for other types of
databases, such as No SQL databases and graph databases, include Cassandra Query Language
(CQL), Neo4j's Cypher, Data Mining Extensions (DMX) and XQuery.

SQL [2] (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to
communicate with a database. According to ANSI (American National Standards Institute), it is
the standard language for relational database management systems. SQL statements are used to
perform tasks such as update data on a database, or retrieve data from a database.

The spread of dynamic websites on the World Wide Web today is largely due to the possibility
for their content to be handled through databases.[3] The origins of the SQL take us back to the
1970s, when in the IBM laboratories, new database software was created - System R. And to
manage the data stored in System R, the SQL language was created. At first it was called
SEQUEL, a name which is still used as an alternative pronunciation for SQL, but was later
renamed to just SQL.
In 1979, a company called Relational Software, which later became Oracle, saw the commercial
potential of SQL and released its own modified version, named Oracle V2.
Now into its third decade of existence, SQL offers great flexibility to users by supporting
distributed databases, i.e. databases that can be run on several computer networks at a time.
Certified by ANSI and ISO, SQL has become a database query language standard, lying in the
basis of a variety of established database applications on the Internet today. It serves both
industry-level and academic needs and is used on both individual computers and corporate
servers. With the progress in database technology SQL-based applications have become
increasingly affordable for the regular user. This is due to the introduction of various open-
source SQL database solutions such as MySQL, PostgreSQL, SQLite, Firebird, and many more.
2. BASIC CONCEPTS OF SQL QUERIES :
SQL commands can be divided into DDL, DML, DCL and TCL[5]:

DDL stands for Data Definition Language, and contain commands for creating, modifying and
deleting databases, schemas, tables, columns etc. such as CREATE, ALTER, RENAME, DROP
etc.

DML stands for Data Manipulation Language, and these queries are used to create or manipulate
the actual data. SQL implements CRUD operations through INSERT, SELECT, UPDATE and
DELETE commands that belong to DML. CRUD (create, read, update and delete) operations are
the four basic functions of any persistent storage mechanisms.

DCL stands for Data Control Language and contain commands such as GRANT, REVOKE etc.

TCL stands for Transaction Control and contain commands such as COMMIT, SAVEPOINT,
ROLLBACK etc.

Also the other commands such as order by, having, group by, aggregate functions, relational
algebra operators , etc can be used in order to get the finite content of data from the databases
that they are working on.

3. EXISTING SYSTEM and NEW SYSTEM:

RazorSQL[4] is an SQL query tool, database browser, SQL editor, and database
administration tool for Windows, macOS, Mac OS X, Linux, and Solaris. RazorSQL has been
tested on over 40 databases, can connect to databases via either JDBC or ODBC, and includes
support for the various databases like mongoDB, oracle, mySQL, openbase, PostgreSQL, etc.
It provides a platform to make use of the SQL queries, in any of the application or for any of
the databases.

RazorSQL[6] ships with a built in relational database engine that is up and running out of the
box and requires no end user administration. Some of the main features contained in
RazorSQL are visual tools for creating, editing, describing, altering, dropping, and viewing
database objects; tools for importing and exporting data; a database browser for the viewing of
database objects and structures; and a robust programming editor with support for SQL,
PL/SQL, TransactSQL, SQL PL, PHP, Java, XML, HTML, and twelve other programming
languages.

3.2 NEW SYSTEM DATABASE QUERY GENERATOR:

In this project of Database Query generator is simple java enabled language used so that it
becomes platform independent and also it provides support to various other SQL tool. In this it
gives the user two options either to generate the query or to connect to their own application to
place the generated queries.

If the user selects the first option then he or she needs to enter the database name, table name,
column name in order to create the database table and columns and on which they perform
other operation such as insert select update or any other operations and also they need to select
appropriate data type and size for the columns they need to store. And all the operations will
be stored in the text files which they can make use of it at any time afterwards.

Else if user selects the second option then user is required to select the application in which
user wants to place the query then the query will be placed in user query. And then the user
can run the application to check whether the outpy generated of query is according to users
requirement.

This application is time saving and also helps the people who don’t know about the databases
to generate queries. Also it is helpful for the students who wants to learn about the syntax of
SQL queries and the operations they perform after executing on the databases.

4. RESULTS:
4.1 FOR EXISTING SYSTEM:

4.2 FOR NEW DATABASE QUEY GENERATOR:

5. CONCLUSION:

In this project the SQL queries are generated without writing the whole query on its own or
manually. In this the person needs to simply select whether they want to generate the query or
want to execute the query in their application. If the person selects on the generating the query
the query will be generated by simply just providing the data which is asked and then queries
generated can be stored in the text file which the person can make use of it later. Also the
person can write the queries generated to their own application by simply pressing the button.
It also helps the
People who don’t know the database and are willing to perform the operations on the database.

6. ACKNOWLEGEMENT:
1. Ms. Sanober Shaikh (Guide)
2. Simran Lund
3. Yogita Motwani
4. Sakshi Pandita
5. Sanjana Rohra

7. REFERENCES:
[1] https://searchsqlserver.techtarget.com/definition/query

[2] http://www.sqlcourse.com/intro.html

[3] https://www.ntchosting.com/encyclopedia/databases/structured-query-language/

[4] https://razorsql.com/

[5] https://javajee.com/basic-sql-concepts

[6] http://wiki.appvisor.org/RazorSQL