Grant: Engage Grants Program
Simon Fraser University
$25,000.00
Building a bridge between SQL-based applications and Big Data infrastructure
EF 2014-15
Résumé
Many existing successful business information system applications are based on traditional SQL. Typically,they use ODBC/JDBC drivers as the middle ware. At the same time, the emergence of ""big data"", such associal media, has played critical roles in business analytics. Such big data is often stored in the new generationof NoSQL databases, and processed in MapReduce/Hadoop based infrastructure. NoSQL databases andMapReduce/Hadoop systems do not support SQL queries natively. The industry is facing an essentialchallenge: can millions of existing successful applications based on SQL take the advantage of big datainfrastructure?In this project, we will start our collaboration with Simba, an industry leader of big data technology. Our thrustis to investigate the new critical techniques in building ODBC/JDBC drivers on NoSQL databases, as well asthe parallel SQL query execution techniques in Hadoop platforms. The success of this project will enablemigration of SQL-based applications to big data infrastructure in a seamless manner. Simba is a technologypioneer and market leader in SQL and relational databases, and has provided a significant number of ODBCand JDBC drivers for a number of Hadoop-based and NoSQL databases. The PI's group has a remarkable trackrecord in multidimensional analytics and data analytics query processing. The close interaction of the twoparties in this project suggests a promising synergy of long term productive collaboration.
Programme
Engage Grants Program
Bénéficiaire
Emplacement
British Columbia, Canada
Type de bénéficiaire
Academia
Type
Grant
Source
NSERC's Awards Data
Tel que publié
Application id
463493-2014
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
2014
Competition year année de concours
2014
Award amount
25000
Program id
EGP
Program name en
Engage Grants Program
Program name fr
Programme de subventions d'engagement partenariat
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
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
Building a bridge between SQL-based applications and Big Data infrastructure
Keyword
NSERC
Application summary
Many existing successful business information system applications are based on traditional SQL. Typically,they use ODBC/JDBC drivers as the middle ware. At the same time, the emergence of ""big data"", such associal media, has played critical roles in business analytics. Such big data is often stored in the new generationof NoSQL databases, and processed in MapReduce/Hadoop based infrastructure. NoSQL databases andMapReduce/Hadoop systems do not support SQL queries natively. The industry is facing an essentialchallenge: can millions of existing successful applications based on SQL take the advantage of big datainfrastructure?In this project, we will start our collaboration with Simba, an industry leader of big data technology. Our thrustis to investigate the new critical techniques in building ODBC/JDBC drivers on NoSQL databases, as well asthe parallel SQL query execution techniques in Hadoop platforms. The success of this project will enablemigration of SQL-based applications to big data infrastructure in a seamless manner. Simba is a technologypioneer and market leader in SQL and relational databases, and has provided a significant number of ODBCand JDBC drivers for a number of Hadoop-based and NoSQL databases. The PI's group has a remarkable trackrecord in multidimensional analytics and data analytics query processing. The close interaction of the twoparties in this project suggests a promising synergy of long term productive collaboration.