Object Oriented Data Modeling for Data Warehousing (An Extension of UML approach to study Hajj pilgrim's private tour as a Case Study)

We are all familiar with the growth rate of the public Web. Regardless of the metric used to measure its growth attached networks, servers, users or pages the growth rate continues to exhibit an exponential pattern. In the same vein, the adoption rate of intranet and extranet data warehouses (i.e., Web warehouses) has exhibited a similar pattern, although the pattern has lagged public adoption. While data warehouse and business intelligence vendors have offered Web-enabled versions. All over world there are hundreds of private tour operators (PTOs) managing tour for hajj pilgrims. According to the visiting Indian Ministry 138,000 Indian pilgrims performed hajj during 2007.Out of above mentioned figure 110,000 through the Hajj committee and 38,000 through PTOs. In India there are about 397 registered PTOs up to 2007. We introduce the UML Profile for Modeling DWH Usage for modeling the different kinds of DWH usage on a conceptual level. It uses features of UML intended for the purpose of creating abstract, general models. The profile distinguishes four perspectives of usage, and allows to model details of the users. The UML Profile is applied to example illustrating Hajj pilgrims private tour. KeywordsBusiness intelligence, data modeling, private tour operator, unified modeling language, web enabled warehouse Received December2, 2008; Accepted March 17 2009