A walk back through the joins, hashing, Teradata, key selection, and arguments for and against sequence numbers. While this post is specifically related to Teradata, there are some generic statements here that apply to all MPP solutions.
Recently I taught a class on-site for a customer all about Data Vault 2.0. When I got to the point where I shared the template / process for end-dating (updating end dates in place, using a characteristic function) I was point-blank told: “Teradata does not use or have indexes other than the Primary Index” And […]
A look at NoSQL, BigData, and Data Vault with regards to Transactions Per Second – the hype around ingestion rates, and questions around why / when you would or wouldn’t need to switch to NoSQL platforms to handle bigdata.
Hadoop, NoSQL, Big Data, the introduction continues on a deeper technical level this time. I expose some of the issues, and discuss some of the benefits of applying your data warehouse TO a Hadoop platform. Would love to hear from you, please comment at the end of the entry.
An introductory discussion on Data Warehousing, Hadoop, and Big Data. How it works, the differences between it and a relational system, and what some of the benefits/drawbacks are to plugging a Hadoop system IN to your architecture.
A short introduction to Data Vault 2.0, and a discussion of the old standards of Data Vault 1.0 – along with some information about where DV2.0 is going, and the future of Data Vault
In this entry I will explore the use of implementation of Data Vault on Teradata. However, this entry is applicable to everyone in the Data Vault community, as it covers definitions and descriptions of primary keys, indexing, surrogate keys, natural keys, and performance and tuning.
I’ve begun researching Data Vault models on Hadoop solutions, including HadoopDB and Hive. Recently I came across a number of articles which describe the solutions of Hive and HadoopDB in detail on top of Hadoop solutions. I had to take a minute to write this article, to explain my view points of using the Data […]
A very short entry on migrating a Data Vault from SQLServer to Teradata, there’s really not much to do to make this work properly.