Enhanced UI Design Features for End User to Interact With Database Servers

Authors(2) :-Yarramreddy Prathyusha, Suhail Afroz

Database is tremendous interrelated data in light of specific requirements forced on the database objects. DBMS is programming that deals with a database. Usually utilized DBMS are MS-ACESS, MS-SQL SERVER, ORACLE and MYSQL. Database server is utilized to play out all the database exchanges including DQL orders. Any database use of sort window/web/portable uses database server to interface backend. It can be either towards or far from database. GUI is associated with Database Server through Database Access Mechanisms like ADO, DAO, RDO, Native API, JDBC, ADO.NET and so forth. The individual with zero learning can likewise perform numerous perplexing operations in SQL server. Make, alter, or run SQL explanations utilizing the SQL Query Builder graphical interface, access to your database outline and protests so you can rapidly make or alter SQL articulations without really writing any SQL code, you likewise have the adaptability to include or adjust the SQL code in the manager window. The Main target of the web application is to play out a few SQL operations without knowing about any database server. The operations that should be possible by this application are making and erasing databases, tables, sees, files, put away methods and so forth and furthermore different operations like rough operations and information show and so on. Such a few operations should be possible without composing any single inquiry. The question will be consequently produced and the outcomes can be sent out by utilizing MS Excel sheet.

Authors and Affiliations

Yarramreddy Prathyusha
Department of CSE, CVR College of Engineering & Technology, Ibrahimpatnam (M), Rangareddy (D), Telangana India
Suhail Afroz
Professor, Department of CSE, CVR College of Engineering & Technology, Ibrahimpatnam (M), Rangareddy (D), Telangana India

SQL, RDBMS, Databases, Tables, Views, DDL, DML, DQL, TCL, DCL, File Database, Server Database, ADO, ADO.NET.

  1. Jie.w., et al "Augmented modeling of SQL" in Information management and engineering(ICIME), 2010 the 2nd IEEE International Conference on 2010.
  2. Anley,C., "Advanced SQL injection in SQL server applications" in White Paper,  Next Generation Software ltd 2002.
  3. Halfond, W.G.J.Aorso, P.Manolios "SQL Applications using positive tainting and syntax-free evaluation" in Software Engineering,  IEEE transaction on 2008.
  4. YishanLi, SathiamoorthyManoharam "A performance comparision of SQL and NO SQL databases" in Communictions, Computers and Signal processing(PACRIM), IEEE Pacific Rim Conference on Aug.2013.
  5. J.Han, E.Haihong, G.Le and J.Du "Survey on NoSQL database" in Pervasive Computing and Applications(ICPCA),  International Conference on oct.2011.
  6. D.G.Cambell, G.Kakivaya, N.Ellis "Extreme scale with Full SQL language support in Microsoft SQL Server" in  IEEE Data Eng.Bull vol.29, no.4 2006.
  7. Halfond, W.G.J.Aorso, P.Manolios "SQL Applications using positive tainting and syntax-free evaluation" in Software Engineering,  IEEE transaction on 2008.
  8. PhilipA.Bernstien, Istvan Cseri, Nishant Dahi "Adapting microsoft SQL server for web computing" in IEEE Computer Engineering and Applications(ICCEA), 2010.
  9. Vasyl Romanchuk, Taras Andrukhiv "The main causes of failures of SQL Server" in IEEE Radio Engineering Telecommunications and Computer Science (IRCSET), 2012.
  10. DandanLi, LuHan, Yi Ding "SQL Query optimization methods of Relational database system" in IEEE Computer Engineering and Applications(ICCEA), Second International Conference on mar.2010

Publication Details

Published in : Volume 2 | Issue 6 | November-December 2017
Date of Publication : 2017-12-31
License:  This work is licensed under a Creative Commons Attribution 4.0 International License.
Page(s) : 384-388
Manuscript Number : CSEIT1726118
Publisher : Technoscience Academy

ISSN : 2456-3307

Cite This Article :

Yarramreddy Prathyusha, Suhail Afroz, "Enhanced UI Design Features for End User to Interact With Database Servers", International Journal of Scientific Research in Computer Science, Engineering and Information Technology (IJSRCSEIT), ISSN : 2456-3307, Volume 2, Issue 6, pp.384-388, November-December-2017. |          | BibTeX | RIS | CSV

Article Preview