Two kinds of definitions relevant to data warehouse design are the definition of business terms and definition of data elements. Data element definitions help the business person make sense of the data and to understand the meaning of data stored in their operational OLTP system. Business term definitions help the business person manage his business….

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…

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,…

Throughout the history of systems development, the primary emphasis had been given to the operational systems (simple OLTP -Online transact ion processing systems) and the data they process. Little effort was put on building up an integrated information management system that is capable of capturing, storing & handling the distributed operational data (current & historic…

A typical project scope for Data warehousing is as below – Title: APPLYING DATA WAREHOUSING The major goal & effort on working on the project is to study and analyse a typical system (eg: automobile servicing stations) for applying Data warehousing, study the scope of Data warehousing in the system and present a proposed system Perform Data warehouse…

The need for an effective information management solution is of top priority in today’s changing & competitive business environment. Various Information systems like OLTP systems, DSS& EIS has been serving this information management need for many years. Data warehousing is an Enhancement of such information management solutions in providing complete, integrated enterprise a information management…