Yearly Archives: 2013

Dynamic Data Bucketing: A Use Case for Complex Aggregation

Fast & Dynamic Data BucketingComplex aggregation has become a common requirement for business users looking to analyze sophisticated metrics across multiple dimensions. There are numerous use cases for complex aggregation such as cross-currency aggregation, which was explored in our last post. Dynamic bucketing is another use case example.Read more

Posted in Big Data Analytics, Technology | Leave a comment

Real-Time Cross-Currency Analytics: A Use Case for Complex Aggregation

SQL vs Post Processors: Currency Aggregation ExampleIn previous posts, we’ve delved into theprinciples of multidimensional databases. Among all the benefits that a multidimensional database delivers is complex aggregation, a process by which KPIs are written once and are immediately available across any dimensions, through any filtering, letting the user follow his train of thought.Read more

Posted in Big Data Analytics, Technology | Tagged , , , | Leave a comment

Why Complex Event Processing (CEP) is not enough for real-time decision making

Event Driven processingReal-time decision making is commonly linked with Complex Event Processing (CEP). Indeed, CEP systems can extract and alert about meaningful events from streams of data. However, for decision makers to have context and turn a notification into a meaningful, actionable event, CEP must be supplemented with mixed workload and multidimensional capabilities.Read more

Posted in Technology | Tagged , , , , , | Leave a comment

Mixed Workload databases: A Primer

In a previous post comparing multidimensional and relational databases we mentioned that the decision making imperatives in the Big Data era were disrupting the clear-cut border between OLTP and OLAP, enabling a new type of mixed workload database that addresses both needs.Read more

Posted in Technology | Leave a comment

Multidimensional or relational? What’s the right system for you?

Relational and multidimensional databases differ on almost any possible dimension:  tables, columns and rows vs. cubes, measures and dimensions; queries across joint tables vs. pre-calculated aggregations across dimensions; Structured Query Language (SQL) vs. Multidimensional Expressions MDXRead more

Posted in Technology | Leave a comment

Forbes highlights the scope of ActivePivot in the move to real-time risk management

Tom Groenfeldt, financial technology blogger for the internationally renowned business and finance publication, Forbes, outlines the benefits of using real-time risk management in the face of the Big Data conundrum.Read more

Posted in Finance | Leave a comment