Tag Archives: database

The Future of Health and Human Services data modeling (Part 1)

August 19, 2016

The question was put to me “When will the IT industry provide reusable clinical and administrative data warehouses for the Medicaid enterprise?” It was a thought-provoking question that was well worth considering. Currently the healthcare insurance and provider industries are guided to target reporting that is defined by government regulation and motivated by financial incentives.… Read More »

Implementing Teradata Temporal in a Physical Data Model using ERwin

June 15, 2016

There is no question that a database-supported temporal implementation gives Teradata users a powerful tool, because the time dimension has been added to data management and query processing. For the business user, the ability to ask more sophisticated time-based questions from their data warehouse, and receive more insightful answers, can yield a distinct competitive advantage.… Read More »

Simplifying SAP R/3 is irrelevant for users

October 14, 2015

Part two of a series about an old ‘SAP’ dog who learns a new trick Today more than ever, SAP is more focused on technology (HANA) than data. When they do focus on data, they talk about simplifying it because simplification is necessary to make said technology work better. In SAP terms, simplification means fewer… Read More »

News: Teradata Database on AWS

October 7, 2015

I’m very excited about Teradata’s latest cloud announcement – that Teradata Database, the market’s leading data warehousing and analytic solution, is being made available for cloud deployment on Amazon Web Services (AWS) to support production workloads. Teradata Database on AWS will be offered on a variety of multi-terabyte EC2 (Elastic Cloud Compute) instances in supported… Read More »

The Smarter, Cheaper Approach to In-Memory: Teradata Intelligent Memory

August 5, 2015

By Imad Birouty, Teradata Product Marketing Manager In-memory database processing is a hot topic in the market today. It promises to bring high performance to OLTP and Data Warehouse environments.  As such, many vendors are working hard to develop in-memory database technology. Memory is fast, but still expensive when compared to disk storage. As such, it… Read More »

Why We Love Presto

June 24, 2015

Concurrent with acquiring Hadoop companies Hadapt and Revelytix last year, Teradata opened the Teradata Center for Hadoop in Boston. Teradata recently announced that a major new initiative of this Hadoop development center will include open-source contributions to a distributed SQL query engine called Presto. Presto was originally developed at Facebook, and is designed to run… Read More »

Agile Data Warehousing Meets Agile Technology

April 20, 2015

By Youko Watari, Technical Marketing Manager Agile development and its 12 principles[1] have been adopted everywhere, and data warehousing is not an exception. The Agile data warehousing publications out there mostly focus on how to adopt Agile tools and techniques such as the backlog, user stories, and iterations into the data warehouse development process, or how… Read More »

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 »