Generic and Personalized Web/Mobile Services by Abstracting and Specializing SQL Queries

Abstract

This paper proposes a query abstraction mechanism which allows web/mobile-service administrator to formulate a skeleton of a sequence of SQL queries by parameterizing holes, later being filled by end-users. The mechanism is generic as the administrator can use it to register multiple services, and expandable as the existing service can be specialized, to automatically generate new kinds of personalized services. An end-user's input, when given in its entirety, initiates the automatic generation of appropriate SQL queries suitable for the user's requested service. A personalized service can be devised by designating the enduser's input parameters into static or dynamic. When static input arguments are given, a specialized skeleton service with respect to the given input is created. The mechanism is implemented to be used in systems for web/mobile-based information and transaction services.