SkeletonQL: Skeleton SQL Query Language towards Generic Information/Transaction, and Personalized Services by Abstracting and

Abstract

This thesis proposes a query abstraction mechanism which allows an administrator to formulate a skeleton of a sequence of SQL queries by parameterizing holes, later being filled by the end-users. The mechanism is generic because the administrator can use it to register multiple services, and expandable because the existing service can be enhanced further, 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 end-user’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. The novelty of SkeletonQL is that beside information, it also allows administrator to register generic transaction services.