White Paper: Intelligent Solutions, Inc. recommends IBM Dynamic Warehousing

Dynamic warehousing means the business intelligence implementers need to rethink the technology they use to design, develop, and deliver their BI environments. Traditional data warehouse technology may not be able to support the constantly changing, fast-paced world of operational BI. This world must address the expanding needs for fresh, current, and ever-changing information. It must serve the increasing number and types of applications needed during a business day as well as support the varying service level demands from instant responses for short, relatively simple queries to slower responses to longer running, more complex ones.

• The mixed workload and constantly changing business needs mean the DBMS must have a split personality – one that is OLTP-like for the operational BI queries and one that is OLAP-like in nature for the strategic and tactical ones.
• Operational BI implementers need technological solutions that can speed up information delivery and data presentation to end users at the appropriate points in their decision-making cycle. For this, they should look to simplified frameworks, like a service-oriented architecture (SOA), to present operational BI analyses at appropriate points in workflows and business processes.