Grant: Engage Plus Grants Program
Simon Fraser University
$12,500.00
Big data storage and retrieval technology for high-impact location derivative data
FY 2015-16
Summary
Evolution of computing and networking technology ushered in an era of ""Big Data"". 90% of the world's data
has been produced in the last two years, and businesses are looking to leverage data to gain competitive edge.
Massive volumes of data call for processing at massive scale. Old relational database (RDBMS) technology is
often unable to support high query rates. RDBMS provides strong consistency guarantees and flexible querying
at the expense of scalability; this motivates big data users to opt for NoSQL data stores. While NoSQL data
stores generally scale, getting reasonable query response times can be challenging. The key is to design the data
model in consideration of the query access pattern, applying so-called data denormalization techniques. This
project will focus on automating the process of data denormalization: turning it from a time-consuming manual
process to partly automated. We plan to develop tools that will analyze existing SQL queries and recommend
denormalization heuristics for designers of NoSQL data models. We will address this problem in the context of
Global Fleet Management: a Vancouver based company that performs GPS tracking of commercial vehicles.
We expect that our experience will lead to development of generalized techniques for partly automated data
denormalization.
Program
Engage Plus Grants Program
Recipient
Location
British Columbia, Canada
Recipient Type
Academia
Type
Grant
Source
NSERC's Awards Data
As published
Application id
484409-2015
Name nom
Fedorova, Alexandra
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
2015
Competition year année de concours
2015
Award amount
12500
Program id
EGP2
Program name en
Engage Plus Grants Program
Program name fr
Programme de subvention d'engagement partenarial Plus
Group en
Research partnerships programs
Group fr
Programmes de partenariat
Committee code
1554
Committee name en
Pacific Internal Decision Committee
Committee name fr
Comité de décision interne pour le Pacifique
Area of application code
804
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
Communication systems and services (planning, organization, services)
Area of application fr
Systèmes et services de communications (planification, organisation et services)
Research subject code
2705
Research subject group en
Information technology
Research subject group fr
Technologie de l'information
Research subject en
Software and development
Research subject fr
Logiciels et développement
Partie
1
Nb partie
1
Application title
Big data storage and retrieval technology for high-impact location derivative data
Keyword
NSERC
Application summary
Evolution of computing and networking technology ushered in an era of ""Big Data"". 90% of the world's data
has been produced in the last two years, and businesses are looking to leverage data to gain competitive edge.
Massive volumes of data call for processing at massive scale. Old relational database (RDBMS) technology is
often unable to support high query rates. RDBMS provides strong consistency guarantees and flexible querying
at the expense of scalability; this motivates big data users to opt for NoSQL data stores. While NoSQL data
stores generally scale, getting reasonable query response times can be challenging. The key is to design the data
model in consideration of the query access pattern, applying so-called data denormalization techniques. This
project will focus on automating the process of data denormalization: turning it from a time-consuming manual
process to partly automated. We plan to develop tools that will analyze existing SQL queries and recommend
denormalization heuristics for designers of NoSQL data models. We will address this problem in the context of
Global Fleet Management: a Vancouver based company that performs GPS tracking of commercial vehicles.
We expect that our experience will lead to development of generalized techniques for partly automated data
denormalization.