|
Thai QBE for Ad Hoc Query |
|---|---|
| รหัสดีโอไอ | |
| Creator | Areerat Trongratsameethong |
| Title | Thai QBE for Ad Hoc Query |
| Contributor | Phada Woodtikarn |
| Publisher | Siam Technology College,Bangkok,Thailand |
| Publication Year | 2562 |
| Journal Title | Journal of Technology and Innovation in Tertiary Education |
| Journal Vol. | 2 |
| Journal No. | 2 |
| Page no. | 1 |
| Keyword | Thai QBE, Fixed Asset Database, Ad Hoc Query, Levenshtein Distance, Edit Distance Algorithm. |
| URL Website | http://jti.siamtechno.ac.th |
| Website title | Journal of Technology and Innovation in Tertiary Education |
| ISSN | 2630-0540 |
| Abstract | Data for answering business questions usually query from databases. Software applications are provided for users to query these data. However, queries provided by software programs must be predefined through searching criteria specified in program user interfaces. The searching criteria are transformed to SQL statement and stored in a program. If users want data in different views or want more data, the searching criteria stored in a program must be modified or new programs must be created. This will consume more time and costs. Moreover, the ad hoc questions for real-time decision making require ad hoc query tools to generate ad hoc data and ad hoc reports. But users who want to use these tools must be trained or learned how to use them. These issues inspire the researchers/authors of this paper to develop an ad hoc query tool named Thai QBE (Query-by-Example) to query ad hoc data. User interfaces of Thai QBE were designed to support Thai language for ease in use. The concept used to design Thai QBE was derived from Query-by-Example (QBE) of Microsoft Access. A Thai QBE prototype was developed as a web application for users without technical skills to query ad hoc data anytime and anywhere. Two types of queries supported by Thai QBE were used: general query and statistical query. The researchers implemented and tested the Thai QBE prototype with fixed asset system database. The results prove that Thai QBE can serve as a powerful tool for querying ad hoc data. Thai QBE can be applied to query ad hoc data from other databases easily for its straightforward modification. The Thai QBE can be extended to support recursive relationship in future applications. |
