A Generic Open Source Framework for Auto Generation of DataManipulation Commands

Journal Title: IOSR Journals (IOSR Journal of Computer Engineering) - Year 2015, Vol 17, Issue 3

Abstract

Abstract: Free and open source technology has gained a tremendous importance in software development dueto its low cost and holds numerous other compelling advantages both from the perspective of software user andsoftware developer. J2EE and PHP technologies have availed a highest market share. All types of web sitesranging from medium to large sized applications employing these technologies include ample master tables forstoring data which are subject to seldom changes. In application development, there is a lot of code repetitionin manipulation of data stored in these tables. Further, globalization demands thorough testing of webapplications for variety of web browsers depending on the client base. There is a monotonous sequence of tasksinvolved, from the task of code generation, deployment, setting runtime environment to testing. Hence theautomation of these tasks enables a tremendous decrease in development time and cost. Further, customerdemands vary in choice of technology, web server and back end database management systems. Also, validationis an integral part of any application which not only ensures that the data is present but also the valid data isstored in the database. Any well written application should enable easy switching on and off of the validationtests as per the requirements. To cater all these needs, in this paper, the authors have designed and implementeda generic framework for automatic generation of data manipulation commands for variety of web servers, webbrowsers and database management systems (DBMS). All the configuration information pertaining to backendDBMS information, technology information, validation information is stored in an XML file which is parsedusing Microsoft XML Parser. Seven test cases are generated for testing the tool in various runtime environmentsinvolving various cutting edge technologies. The model is generic and susceptible to future modifications forincorporating new technologies.

Authors and Affiliations

Dr. Poornima. G. Naik , Dr. Kavita. S. Oza

Keywords

Related Articles

 Analysis and Implementation of Selective Image Encryption Technique Using Matlab

 Abstract: Encryption plays a very significant role in secure transmission of digital images from one place to another. There are a number of encryption algorithms available which perform the task of encryption. How...

 Modern Computer Implementation on Smart Phone withAndroid Platform for Smes (UMKM) in Optimization ServicesDistrict Malang

Abstract: The use of Android in the smartphone operating system currently used by many companies. Because of its superiority as a software that uses computer code base that can be distributed openly (open source) so many...

Robot Car for Exploring Dangerous environments controlled by Bluetooth

Car controlling one of the projects that get a lot of attention in this days. There are many challenges generated during implementation of system especially when the car connected with number of sensors and that mean the...

 Privacy Preserving by Hiding Association Rule Mining from Transaction Database

Abstract: For making the decision of data mining process some expertise are required, some organization have their own expertise, but many organization doesn’t have their own expertise, so the organization helps with som...

 Hybrid Algorithm combining Genetic algorithms and CSP approach to plane an Optimized path for a Mobile Robot moving under Time Window

 Abstract: The problems of optimization are considered as a type of a constraint satisfaction problem: COP (Constraint Optimization problem). In this frame goes our first works which are interested in the optimi...

Download PDF file
  • EP ID EP100596
  • DOI -
  • Views 115
  • Downloads 0

How To Cite

Dr. Poornima. G. Naik, Dr. Kavita. S. Oza (2015).  A Generic Open Source Framework for Auto Generation of DataManipulation Commands. IOSR Journals (IOSR Journal of Computer Engineering), 17(3), 25-38. https://europub.co.uk/articles/-A-100596