Grant: Discovery Grants Program - Individual
The University of British Columbia
$41,000.00
Improving querying and data access for non-expert users
FY 2024-25
Summary
Historically, databases have been managed and queried by experts who have been trained both in database management and in the specific domain and schema for the application that the expert was working on. This was because computers were expensive, disk space was relatively limited, and those who had large amounts of both typically had enough resources in order to hire experts to make sure that their individual data needs were met.
In today's world, that is no longer the case. In the simplest case, there are now users who have access to a very large amount of their own data that would have been unthinkable 40 years ago. But these users may not have the ability to query that data because they do not understand how to query it or they do not have a good mental model of how to organize it, yet alone what to do with it once it is organized. The goal of my research program is to help such untrained users access their data.
The simplest version of this problem is if a user has enough resources to have an application that is suited for their needs or to order to hire someone to create a database and application for them. This application may work quite well for the user's needs, as long as the user is asking a question for which the application is developed. The moment that is no longer the case, however, then the user runs into trouble and may not know how to find the answers that they are looking for.
A second variation of this problem comes when a user is trying to work with open data. Because of the amazing number of things that citizen scientists can do with data, many governments and other entities have been eager to get their data released to the public. Unfortunately, the motivation for those within the government who manage the data is often to make sure that the data is released, not to make sure that it's usable.
A final variation on this problem comes in when a domain expert understands their own data, but is given someone else's data to work with. For example, an astronomer may get access to the Sloan Digital Sky Survey (SDSS), the premier source of astronomy data. This dataset is amazingly complicated and hard to work with, so it's no surprise that it often is hard to get the "right" answer, even if they have an oracle that tells them what the correct answer is. These untrained users would benefit from having a mechanism to help them refine their queries in order to create the "right" query.
All of these problems are ones that I have discovered by working with domain experts, and has shaped my overall research program to explore, query, and understand their data. In the next five years, my goal is to focus on how to solve these problems around query recommendation, metadata assistance, and query refinement.
Program
Discovery Grants Program - Individual
Recipient
Location
British Columbia, Canada
Recipient Type
Academia
Type
Grant
Source
NSERC's Awards Data
As published
Application id
RGPIN-2023-04530
Name nom
Pottinger, Rachel
Department département
Computer Science
Organization id
2
Institution établissement
The University of British Columbia
Province en
British Columbia
Province fr
Colombie-Britannique
Country en
CANADA
Country fr
CANADA
Fiscal year exercice financier
2024
Competition year année de concours
2023
Award amount
41000
Program id
RGPIN
Program name en
Discovery Grants Program - Individual
Program name fr
Programme de subventions à la découverte - individuelles
Group en
DISCOVERY RESEARCH
Group fr
RECHERCHE AXÉE SUR LA DÉCOUVERTE
Committee code
1507
Committee name en
Computer Science
Committee name fr
Sciences informatiques
Area of application code
801
Area of application group en
Information and communication services
Area of application group fr
Services d'information et de télécommunications
Area of application en
Computer software
Area of application fr
Logiciel
Research subject code
2711
Research subject group en
Information technology
Research subject group fr
Technologie de l'information
Research subject en
Database management
Research subject fr
Gestion de bases de données
Field of research list names en
Not available
Field of research list names fr
Non disponible
Socioeconomic objective list names en
Not available
Socioeconomic objective list names fr
Non disponible
Application title
Improving querying and data access for non-expert users
Keywords
databases; data management; query refinement; open data; query recommendation; data representation; data science; data curation
Application summary
Historically, databases have been managed and queried by experts who have been trained both in database management and in the specific domain and schema for the application that the expert was working on. This was because computers were expensive, disk space was relatively limited, and those who had large amounts of both typically had enough resources in order to hire experts to make sure that their individual data needs were met.
In today's world, that is no longer the case. In the simplest case, there are now users who have access to a very large amount of their own data that would have been unthinkable 40 years ago. But these users may not have the ability to query that data because they do not understand how to query it or they do not have a good mental model of how to organize it, yet alone what to do with it once it is organized. The goal of my research program is to help such untrained users access their data.
The simplest version of this problem is if a user has enough resources to have an application that is suited for their needs or to order to hire someone to create a database and application for them. This application may work quite well for the user's needs, as long as the user is asking a question for which the application is developed. The moment that is no longer the case, however, then the user runs into trouble and may not know how to find the answers that they are looking for.
A second variation of this problem comes when a user is trying to work with open data. Because of the amazing number of things that citizen scientists can do with data, many governments and other entities have been eager to get their data released to the public. Unfortunately, the motivation for those within the government who manage the data is often to make sure that the data is released, not to make sure that it's usable.
A final variation on this problem comes in when a domain expert understands their own data, but is given someone else's data to work with. For example, an astronomer may get access to the Sloan Digital Sky Survey (SDSS), the premier source of astronomy data. This dataset is amazingly complicated and hard to work with, so it's no surprise that it often is hard to get the "right" answer, even if they have an oracle that tells them what the correct answer is. These untrained users would benefit from having a mechanism to help them refine their queries in order to create the "right" query.
All of these problems are ones that I have discovered by working with domain experts, and has shaped my overall research program to explore, query, and understand their data. In the next five years, my goal is to focus on how to solve these problems around query recommendation, metadata assistance, and query refinement.