Page 107 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Unit 5: Data Warehouse Research – Issues and Research

notes
figure 5.3: the Data Warehouse operational process Metamodel



Case Study Data Warehousing system for a Logistics regulatory
Body
Business challenge

The customer, the sole regulatory body for ports and maritime affairs of a leading
republic in the Asia Pacific, protects the maritime and ports interests of the republic in
the international arena by regulating and licensing port and marine services and facilities.
It also manages vessel traffic in the port, ensures navigational safety and port/maritime
security, and a clean marine environment.

In the wake of increasing vessel traffic through the port and booming number of users,
the customer required a system that would provide an integrated framework in which
end-users could perform online queries, prepare ad hoc reports and analyze data with
user-friendly tools.
Mahindra satyam role

Mahindra Satyam identified Data Warehouse (DW) as a potential and essential tool for
high-level analysis and planning, and for faster and easier information management.
The role involved developing a data warehouse (DW) application that has the capability
of comparative or variance analysis, trend analysis, slice and dice, ranking, drill down,
visualization on table, alerts and job scheduling etc.

Business Benefits
1. Helped the customer promote the nation as an important hub port and an International
maritime centre
2. Facilitated easier monitoring of the increased vessel movement through the port
Contd...

LoveLy professionaL university 101