Canada Spends Logo

Explorez notre analyse du budget 2026

Grant: Collaborative Research and Development Grants

Simon Fraser University

$40,000.00

Aggregate Keyword Search in Relational Data

EF 2011-12

Résumé
Keyword search has been recently extended to relational databases to retrieve information from text-rich attributes. However, all the existing methods focus on finding individual tuples matching a set of query keywords from one table or the join of multiple tables. In this project, we will systematically investigate a novel theme of aggregate keyword search: finding minimal group-bys covering a set of query keywords well, which is useful in many applications. This project will be built on our preliminary work of two interesting approaches. Moreover, we will work closely with SAP BusinessObjects, the industry collaborator. In this project, we will focus on three tasks. In the first task, we will transplant and test our preliminary approaches on a business intelligence analytic prototype system for relational data in SAP BusinessObjects, and generalize and extend our methods so that they can be applied in an industry setting. In the second task, we will develop effective and efficient methods for ranking answers to aggregate keyword search queries. In the last task, we will tackle the query suggestion problem for aggregate keyword search. At least one Ph.D. student, one master's student, and one undergraduate intern student will participate in this project and obtain training in research and industry development. Moreover, the research results will be published in premier academic forums. We will actively explore the possibility of transferring the techniques developed in this projects to industry and products. Some results in this project will be used to enrich the undergraduate and graduate courses in database systems, data warehousing, and data mining.
Programme
Collaborative Research and Development Grants
Emplacement
British Columbia, Canada
Type de bénéficiaire
Academia
Type
Grant
Source
NSERC's Awards Data

Tel que publié

Application id
411256-2010
Name nom
Pei, Jian
Department département
Computing Science, School of
Organization id
5
Institution établissement
Simon Fraser University
Province en
British Columbia
Province fr
Colombie-Britannique
Country en
CANADA
Country fr
CANADA
Fiscal year exercice financier
2011
Competition year année de concours
2010
Award amount
40000
Program id
CRDPJ
Program nane en
Collaborative Research and Development Grants
Program name fr
Subventions de recherche et développement coopérative
Group en
Research partnerships programs
Group fr
Programmes de partenariat
Committee code
96
Committee name en
RPP Internal Decision Cttee
Committee name fr
Cté de décision interne - PPR
Area of application code
802
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
Information systems and technology
Area of application fr
Systèmes d'information et technologie de l'information
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
Partie
1
Nb partie
1
Application title
Aggregate Keyword Search in Relational Data
Keyword
NSERC
Application summary
Keyword search has been recently extended to relational databases to retrieve information from text-rich attributes. However, all the existing methods focus on finding individual tuples matching a set of query keywords from one table or the join of multiple tables. In this project, we will systematically investigate a novel theme of aggregate keyword search: finding minimal group-bys covering a set of query keywords well, which is useful in many applications. This project will be built on our preliminary work of two interesting approaches. Moreover, we will work closely with SAP BusinessObjects, the industry collaborator. In this project, we will focus on three tasks. In the first task, we will transplant and test our preliminary approaches on a business intelligence analytic prototype system for relational data in SAP BusinessObjects, and generalize and extend our methods so that they can be applied in an industry setting. In the second task, we will develop effective and efficient methods for ranking answers to aggregate keyword search queries. In the last task, we will tackle the query suggestion problem for aggregate keyword search. At least one Ph.D. student, one master's student, and one undergraduate intern student will participate in this project and obtain training in research and industry development. Moreover, the research results will be published in premier academic forums. We will actively explore the possibility of transferring the techniques developed in this projects to industry and products. Some results in this project will be used to enrich the undergraduate and graduate courses in database systems, data warehousing, and data mining.