Technology Articles Blog
Characteristics of successful data warehouse projects generally include the following aspects – Clear business justification for the project ie. measurable benefits must be defined for a data warehouse project Efficient project personnel Ensuring data quality & consistency Data warehouses deal with historical data from a variety of sources. So care must taken to ensure data…
Ongoing maintenance is the final phase of creation of a data warehousing system. The ongoing maintenance of data warehouse generally involves constant loading of new data and addressing the changing analysis requirements of end users Now as the end users gains confidence, satisfaction and control over the data warehousing system, they wish to switch over…
Once the application is well defined, data warehouse developers are able to begin making technical decisions about building the logical & physical design of the data warehouse system. They may specify the system integration details, the database/software platforms to be used, baseline system models and architectures to be designed at the beginning of data warehouse…
Pre-engineering is the time to define the goals of the application, to make the initial analysis of the system and make other decisions. This includes deciding whether the data warehouse should be build at all. Each phase of pre-engineering process should be put to better understand the system from a data warehousing point of view….
Data warehousing has a great relevance in IT since it provides an Integrated Information management solution that aids in providing the right information, in the right form, to the right person, at the right place, at the right time and at the right cost. The enterprise instrument panel that’s causing excitement among IS/IT professionals today…
We shall compare the ordinary OLTP systems & the Data warehouse systems w.rt the type of data that they handle and shall point out how both are related in a data warehouse application. Operational Vs Informational data Operational data is the data we use to run the business. This data is what is typically stored,…
In the present day competitive & technology centric information age, business enterprises are realising that the enterprise data is valuable resource just like other resources of the enterprise such as man, machine, raw materials & money. The great value of data lies in the fact that enterprises could manipulate this data and create valuable information,…