A new generation of middleware solutions for a near-real-time data warehousing architecture

The term "middleware" is used to identify software services and products that enable an integration communication model between application, data, business process, and web services especially in heterogeneous environments to be created and supported. In this paper, I propose that the enterprise service bus (ESB) middleware under the service-oriented architecture (SOA) can enable communication between the front and back-end layers of SOA integration that connects users with a data management layer. Including in this data management layer is a near-real-time data warehouse in addition to routing, security, message processing, and modeling capabilities. An ESB is one platform that helps achieve and support enterprise-wide SOA. The main issue to be addressed is the provision of access to a company-wide view of data wherever it resides. This is accomplished by building the SOA integration on top of the data warehouse. This will also use ESB middleware for integration solutions for existing applications and new business processes, along with the ability to pass data to any integration level. Most companies in the 21st century face increasing challenges to stay competitive, and accessibility and accuracy of information have become critical success factors. The traditional role of a data warehouse has been to support strategic decision making. This role has expanded to include more critical business tasks that support both strategic decisions and operational business processes. ESB has become an important part of the architectural framework for a business intelligence solution and is considered a critical component in the architecture of advanced near-real-time data warehouses.