Building a Data Warehousing Infrastructure based on Service Oriented Architecture

This paper analyses the possibility and advantages of providing on-demand data warehousing as an attempt to reach a new level of business intelligence. Providing data warehousing as a service is primarily aimed at medium and small business organizations, which have large volume of data but are incapable of having a suitable data warehousing infrastructure. A suitable architecture based on service orientation is proposed to provide different components of data warehousing as a service and describes how this architecture provide support for integration and discovery of services. Features of web services and data warehousing are combined to implement the proposed architecture. Data warehousing can be supported by service orientation which has the ability to join various services from different areas of the data warehouse to create composite applications. These composite applications can take the form of common services. Services are composed in such way that it would be generic to all data warehouses.