Aswani Karteek

Aswani Karteek

Life Cycle Management Strategy for Very Large Data Warehouses

Jim Barksdale, former Netscape CEO once said, “If we have data, let’s look at data. If all we have are opinions, let’s go with mine.”In this modern era of data, Data Warehouses are key to decision making in most of the businesses. Maintaining these systems in good health is very critical to the success of an enterprise. Every business makes decisions based on historical data that is specific to a period of time. Determining the rate at which data is refreshed in these systems, expiry date of data in the data warehouse & strategies on handling expired data in the data warehouse are collectively known as Information Life Cycle Management strategy (ILM) for Data Warehouse. A standard definition of ILM refers to – a process for managing information through its lifecycle, from conception until disposal, in a manner that optimizes storage and access at the lowest cost.

Aswani KarteekAswani Karteek | 16th September 2015
Data,Data warehouse, Ilm, Strategies

Dimensional Data Modeling

Dimensional Data Modeling is one of the methods of data modeling that helps us design a data model which is retrieval friendly. Let us try and build a crude model to understand dimensional modeling. A friend once asked me this question: “Every month, we earn and spend money. I always keep wondering at the end of the month why there’s only so little left. How can I see where’s my money going”?

Aswani KarteekAswani Karteek | 2nd July 2015
Data modeling,Facts and measures,Model, Crude model, Fact table, Dimensions