All Articles

Data warehousing – Defining data

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

All Articles

Data warehousing – Data warehouse Project Management

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…

All Articles

DATA WAREHOUSE PROJECT LIFE CYCLE – Ongoing maintenance and changing user requirements

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…

All Articles

DATA WAREHOUSE PROJECT LIFE CYCLE – Design and implementation-Engineering

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…

All Articles

Data warehousing – Concept

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

All Articles

Data warehousing – Data warehousing technology

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…

All Articles

Data warehousing – Project Scope

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…

All Articles

Data warehousing – Need for Data warehousing

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…