Teradata RainStor’s Compression and Performance Technology

April 1, 2015

It is well-known that there are two extreme alternatives for storing database tables on any storage media: storing it row-by-row (as done by traditional “row-store” technology) or storing it column-by-column (as done by recently popular “column-store” implementations). Row-stores store the entire first row of the table, followed by the entire second row of the table,… Read More »

Funnel Analysis: an Approach from the Power Marketer Playbook

March 31, 2015

Power marketers are always interested in the most effective ways to track, measure, and analyze customer experiences for more relevant engagement. I’d like to share an approach that is less known yet potentially quite powerful. Businesses across global markets are re-thinking data, analytics, platforms, and research methods to better understand their customers. Event analytics offers… Read More »

Modeling for Intelligence: Conceptual, Logical, Physical

March 24, 2015

It’s a fact: intelligence in big business, big data and big analytics begins with data modelers. And understand this: we data modelers are a special breed: we LIKE translating business requirements into conceptual, logical, and physical data models. We enjoy analytical work with tools like Entity Relationship Diagrams (ERD), which are valuable formats that we… Read More »

So, When was Your Data Breach?

March 24, 2015

by Jay Irwin, JD, Director, Teradata InfoSec COE 2015 barely got underway and it happened again, more breaches of customer data kept by large companies. Journalists said 2014 was the year of the data breach, but hold on, here we go again. Security experts are not the least bit surprised. Neither should you be. There… Read More »

SAP R/3 for Real-time Analytics: Replication & Mythical Cluster Tables

March 17, 2015

PART FIVE: This is the last blog in my series about Near Real Time data acquisition from SAP. This final blog is co-written with Arno Luijten, who is one of Teradata’s lead engineers. He is instrumental in demystifying the secrets of the elusive SAP clustered and pooled tables. There is a common misconception that the… Read More »

The Value of Big Data Unlocked

March 17, 2015

It’s on every enterprise list of Things To Tackle in 2015. It’s every organization’s technological priority because it’s commonly considered important to future growth and competitive positioning. The value of Big data is big news —without a doubt. Even though most business executives think realizing benefits from the value of big data is long overdue,… Read More »

‘What’s next in analytics on SAP R/3’ – Introduction

March 17, 2015

SAP’s ERP application R/3 is classified as a real time transaction processing system. However for most larger companies SAP R/3 is not suited for analytical purposes. These companies started with the building data warehouses. This is also where my “SAP analytics journey” started, in the early 1990ies as an employee of Shell. To load the… Read More »

Hybrid Row-Column Stores: A General and Flexible Approach

March 10, 2015

During a recent meeting with a post-doc in my lab at Yale, he reminded me that this summer will mark the 10-year anniversary of the publication of C-Store in VLDB 2005. C-Store was by no means the first ever column-store database system (the column-store idea has been around since the 70s — nearly as long… Read More »