Tag Archives: Enterprise Data Warehousing

What is Change Data Capture? Something Business and IT Both Agree on for Mainframe Data Integration

A few days ago, I got a text message from a friend telling me that my favorite company’s stock price was suddenly tanking and that I should dump my holding.  So I went to the news portal to get a stock quote and see where the stock price happens to be. I found that the [...]

What Role Does Data Integration Play In Data Warehousing?

In my previous entry, I mentioned how our customers are democratizing innovation in data warehousing and data integration. One thing is clear: there is renewed energy around using data to become competitive in the global market. We also have many options in data warehousing –a centralized enterprise data warehouse (EDW), departmental data warehouses and data [...]

Dr. Kimball, Pervasive BI and Real-time Demo

This year, I have the pleasure of hosting a yearlong Web Seminar series featuring Dr. Ralph Kimball. On April 23, we will discuss how we build an enterprise data warehouse to garner the benefits of Pervasive BI. This is exciting because it will be the first time that Dr. Kimball will describe Pervasive BI from [...]

After 2009, Enterprise Data Warehousing Will Never be the Same

For years, the data warehousing space had been fairly steady and predictable. Data warehouses grew by terabytes over terabytes, addressing a critical need to collect and analyze data to discover patterns in customer behavior and other business trends. However, data warehouses have also been notoriously expensive and complex to implement in their early stages, requiring [...]

Turbocharging Data Warehousing Performance with ELT

Flipping around traditional ETL (Extract-Transform-Load) on its head is not a new practice.  ELT (Extract-Load-Transform), where processing is handled in the database, instead of the ETL server, has been proven to enhance performance in many types of data warehousing deployments. For example, Oi, a leading telecom provider in Brazil, implemented an enterprise data warehouse (EDW) [...]