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

Authors

  • 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

Keywords:

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

Abstract

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.

References

  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

Downloads

Published

2017-12-31

Issue

Section

Research Articles

How to Cite

[1]
Yarramreddy Prathyusha, Suhail Afroz, " Enhanced UI Design Features for End User to Interact With Database Servers, IInternational 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.