Grant: Engage Grants Program
McMaster University
$23,924.00
Multi-dimensional reporting and analysis
FY 2012-13
Summary
Vena Solutions is an innovative software provider delivering financial and regulatory solutions for the office of
finance, i.e., finance and accounting departments of publicly traded companies. In particular, Vena delivers a
comprehensive, innovative and simple-to-use Spreadsheet Process Management (SPM) solution.
Online Analytical Processing (OLAP) is an approach that allows for multi-dimensional analysis to occur on a
set of data in real-time. The Vena solution currently produces a multi-dimensional data model using standard
relational tables, which are connected together to form what is known as a star schema. That is, SPM imitates
multi-dimensional database through this schema. It creates a customized database view and connects to that
view directly from an analysis tool such as Excel. The main problem of this solution is that it does not scale
with problem size.
To achieve faster response time to queries, Vena's challenge is to replace the star schema in SPM by an
in-memory cube. The purpose of this project is to investigate how to achieve this: we need to evaluate various
possibilities, chose the best solution, and produce a prototype implementation.
We shall research possibilities for building an in-memory OLAP cube and how it can connect to Vena SPM
Excel framework. This includes literature review, narrowing down the options to a few tools, and performing
empirical studies. Here we should assess the suitability of tools such as the open-source Pentaho Mondrian
OLAP Server, MSAS, voltDB, etc. Criteria include how fast the cube can be updated, ease-of-use, ability to
connect to Excel, memory requirements, etc. A crucial goal is to ensure that the time taken to build, process
and update the cube will scale to large datasets in real-time.
We shell produce a comprehensive report that assesses open-source and inexpensive commercial tools. Based
on it, we shall make a recommendation to the Vena Solutions team what approach to pursue in terms of
building an OLAP cube.
Program
Engage Grants Program
Recipient
Location
Ontario, Canada
Recipient Type
Academia
Type
Grant
Source
NSERC's Awards Data
As published
Application id
433817-2012
Name nom
Nedialkov, Nedialko
Department département
Computing and Software
Organization id
27
Institution établissement
McMaster University
Province en
Ontario
Province fr
Ontario
Country en
CANADA
Country fr
CANADA
Fiscal year exercice financier
2012
Competition year année de concours
2012
Award amount
23924
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
1553
Committee name en
Ontario Internal Decision Committee
Committee name fr
Comité de décision interne pour l'Ontario
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
2713
Research subject group en
Information technology
Research subject group fr
Technologie de l'information
Research subject en
Algorithms
Research subject fr
Algorithmes
Partie
1
Nb partie
1
Application title
Multi-dimensional reporting and analysis
Keyword
NSERC
Application summary
Vena Solutions is an innovative software provider delivering financial and regulatory solutions for the office of
finance, i.e., finance and accounting departments of publicly traded companies. In particular, Vena delivers a
comprehensive, innovative and simple-to-use Spreadsheet Process Management (SPM) solution.
Online Analytical Processing (OLAP) is an approach that allows for multi-dimensional analysis to occur on a
set of data in real-time. The Vena solution currently produces a multi-dimensional data model using standard
relational tables, which are connected together to form what is known as a star schema. That is, SPM imitates
multi-dimensional database through this schema. It creates a customized database view and connects to that
view directly from an analysis tool such as Excel. The main problem of this solution is that it does not scale
with problem size.
To achieve faster response time to queries, Vena's challenge is to replace the star schema in SPM by an
in-memory cube. The purpose of this project is to investigate how to achieve this: we need to evaluate various
possibilities, chose the best solution, and produce a prototype implementation.
We shall research possibilities for building an in-memory OLAP cube and how it can connect to Vena SPM
Excel framework. This includes literature review, narrowing down the options to a few tools, and performing
empirical studies. Here we should assess the suitability of tools such as the open-source Pentaho Mondrian
OLAP Server, MSAS, voltDB, etc. Criteria include how fast the cube can be updated, ease-of-use, ability to
connect to Excel, memory requirements, etc. A crucial goal is to ensure that the time taken to build, process
and update the cube will scale to large datasets in real-time.
We shell produce a comprehensive report that assesses open-source and inexpensive commercial tools. Based
on it, we shall make a recommendation to the Vena Solutions team what approach to pursue in terms of
building an OLAP cube.