Tag Archives: database

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 »

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 »

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 »

Normalization for Normal People … Organizing Data for Business Value

February 4, 2015

Are you a business person or executive involved in a data warehouse project where the term “normalization” keeps coming up but you have no idea what they (the technical IT folks) mean? You have heard them talk about “third” normal form and wonder if it is some new health fad or yoga position. In my… Read More »

Don’t confuse experimentation with IT projects. There is a place for both.

June 10, 2014

It happens every few years and it’s happening again. A new technology comes along and a significant segment of the IT and business community want to toss out everything we’ve learned over the past 60 years and start fresh. We “discover” that we’ve been wasting time applying unnecessary rigor and bureaucracy to our projects. No… Read More »

Take a Giant Step with Teradata QueryGrid

April 29, 2014

Teradata 15.0 has gotten tremendous interest from customers and the press because it enables SQL access to native JSON data. This heralds the end of the belief that data warehouses can’t handle unstructured data. But there’s an equally momentous innovation in this release called Teradata QueryGrid. What is Teradata QueryGrid? In Teradata’s Unified Data Architecture… Read More »

We are the Borg! You will be assimilated. Resistance is futile.

February 3, 2014

In the Star Trek movies, “the Borg” refers to an alien race that conquers all planets, absorbing the people, technology, and resources into the Borg collective. Even Captain Picard becomes a Borg and chants “We are the Borg. You will be assimilated. Resistance is futile.” It strikes me that the relational database has behaved similarly… Read More »

Anna Littick and the Unified Data Architecture — Part 2

October 16, 2013

Ring ring ringtone. Dan: “Hello. This is Dan at Teradata. How can I help you today?” Anna: “Hi Dan. It’s Anna Littick from Sunshine-Stores calling again. Can we finish our conversation?” Dan: “Oh yeah, hi Anna. Sure. Where did we leave off?” Anna: “Well, you remember our new CFO – Xavier Money — wants us… Read More »

Big Elephant Eats Data Warehouse

September 19, 2013

— Teradata PR pit boss: “Dan, have you seen this Big Elephant Eats Data Warehouse article at BigMedia.com? This cub reporter guy’s like Rip Van Winkle waking up and trying to explain how the iPhone works. He’s just making things up. Get this Willy Everlern reporter on the phone.” Ring ring ringtone. “Hello, Willy? Willy… Read More »