Enhanced UI Design Features for End User to Interact With Database Servers
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
- Jie.w., et al "Augmented modeling of SQL" in Information management and engineering(ICIME), 2010 the 2nd IEEE International Conference on 2010.
- Anley,C., "Advanced SQL injection in SQL server applications" in White Paper, Next Generation Software ltd 2002.
- Halfond, W.G.J.Aorso, P.Manolios "SQL Applications using positive tainting and syntax-free evaluation" in Software Engineering, IEEE transaction on 2008.
- 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.
- J.Han, E.Haihong, G.Le and J.Du "Survey on NoSQL database" in Pervasive Computing and Applications(ICPCA), International Conference on oct.2011.
- 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.
- Halfond, W.G.J.Aorso, P.Manolios "SQL Applications using positive tainting and syntax-free evaluation" in Software Engineering, IEEE transaction on 2008.
- PhilipA.Bernstien, Istvan Cseri, Nishant Dahi "Adapting microsoft SQL server for web computing" in IEEE Computer Engineering and Applications(ICCEA), 2010.
- Vasyl Romanchuk, Taras Andrukhiv "The main causes of failures of SQL Server" in IEEE Radio Engineering Telecommunications and Computer Science (IRCSET), 2012.
- 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
Issue
Section
License
Copyright (c) IJSRCSEIT

This work is licensed under a Creative Commons Attribution 4.0 International License.