Modernizing IT P1

Hiya, My apologies for neglecting this blog… The SSA CIO job takes time. I have several database-specific blogs drafted that I hope to get to over the holidays… In the meantime here is a CIOish post on the problem of modernizing old IT infrastructure: https://cio.gov/modernizing-federal-it-part-1-catching-up-and-jumping-ahead/ While it is not specifically about database infrastructure… I think…

More thinking on Specialized Databases

Recently I posted (here) some thinking that suggested that the cost of replicating data into specialized databases might outweigh the benefits of specialization. This post will present a counter view and try to sort out when a specialized database might make sense. In the ZDNet post here: “Look at What Google and Amazon are doing with…

A Modern Data Warehouse Architecture: Part 2 – Make it a Logical Data Warehouse

In the first post of this series (here) I suggested that Hadoop could be effectively used as the platform for staging. Figure 2 describes the result. In this post I will extend the architecture by adding a data federation feature and turning the entire picture into a logical data warehouse… and then we’ll consider the…