Year: 2023
Type: conference-paper
Abstract: In the context of digital transformation, effective decision-making is paramount for corporate adaptability and growth. Spreadsheet software provides a familiar platform for accessing, analyzing, and visualizing data. In many instances, decision-making hinges on the analysis of information derived from organizational databases. Nevertheless, the essential data for analysis within spreadsheet software is obtained through computer programs. This scenario often requires program modification and additional development to accommodate evolving data query demands. To address this challenge, this paper introduces SpreadQuery, a spreadsheet-based query system designed to empower users to query databases without requiring expertise in the SQL database language. SpreadQuery aims to alleviate the challenges of effort, time, and code development by employing spreadsheet software as a user-friendly interface, while effectively managing data through backend relational database management systems. By bridging the gap between user requirements and data accessibility, SpreadQuery presents a cost-effective and time-efficient solution for crafting intricate queries and displaying query results using customizable spreadsheet templates.
Author: Somchai Chatvichienchai
Institutions: University of Nagasaki, Nagasaki University
Language: English
Subfield: Software
Field: Computer Science
Domain: Physical Sciences
Open Access status: gold
OpenAlex ID: W4389111247
