Businesses are exploring cloud computing as a way to improve their operational efficiency, enhance IT flexibility and lower overall costs. In doing so, they can optimize their existing resources and workloads through a virtualized application infrastructure and position the organization to effectively respond to the rapidly changing business environment.
IBM provides workload patterns that are full stacks of IBM software integrated and configured for a specific purpose. This helps reduce the total cost of ownership for many types of applications.
The IBM Transactional Database Pattern and IBM Data Mart Pattern (collectively known as IBM Database Patterns) provide self-service management capabilities essential to the provisioning and management of the transactional database and data mart infrastructure in a secure, private cloud. In conjunction with the IBM Workload Deployer appliance, these patterns help reduce IT operational complexity by:
- Delivering best practices for repeated, consistent, and secure transactional database deployment
- Automating database deployments with centralized security, deployment, and logging features
- Empowering the application group within IT to provision databases and data marts with minimal effort
At the heart of IBM Database Patterns is the IBM DB2 database software, which offers SQL compatibility with Oracle PL/SQL syntax. This greatly facilitates server consolidation projects and enables your IT staff to get up and running with minimal or no change. By providing self-service capabilities, IBM Database Patterns help reduce the time and cost required for administering transactional databases and data marts thereby freeing up valuable resource time to devote to developing new solutions and innovation.
IBM Database Patterns now support deployment on both AIX and Linux environments. Affordable licensing for non-production use is also available.
IBM Database Patterns
The IBM Transactional Database Pattern, formerly known as IBM Workload Deployer Pattern is designed to accommodate departmental OLTP (online transaction processing) applications that do not require high levels of database customization. The most important service level metrics for these applications are availability, performance, and cost. This pattern offers a cost effective approach to deliver transactional database infrastructure for information-centric applications.
Highlights of the IBM Transactional Database Pattern key function:
- Automate configuration for departmental OLTP deployment, virtual machine deployment sizing templates, and database backup processing
- Enable database deployment cloning
- Deliver integrated data modeling, monitoring, and diagnostics
IBM Transactional Database Pattern is ideal for IT organizations trying to minimize:
- Risks incurred by unmanaged departmental database solutions without data backup or security plans.
- Opportunity costs and other inefficiencies in waiting for the operations group to provision hardware, software, and database infrastructure for the various application teams.
The built-in expertise of IBM Transactional Database Pattern makes it possible to create and deploy workload-optimized test and production-ready databases in minutes providing greater business flexibility while lowering costs and risks.
The IBM Data Mart Pattern provides a set of capabilities that are essential to the provisioning and management of data mart infrastructure for data-centric applications in a secure, private cloud. Tuned for the unique I/O throughput required of data mart workloads, the IBM Data Mart Pattern includes data compression capabilities and data movement tools--all designed to help move the business forward with the needed information without delay.
Highlights of the IBM Data Mart Pattern key function:
- Automate configuration for Data Mart deployment, virtual machine deployment sizing templates and database backup processing
- Enable database deployment cloning
- Offer compression features for improved performance
- Provide SQL Warehousing tools for creating and modifying physical models, control flows, and data flows of your target data marts.
- Deliver integrated diagnostics and monitoring
Instead of having analysts perform analysis using unmanaged spreadsheet solutions without data backup and security plans, the IBM Data Mart Pattern enables IT to address operational demands stemming from ad-hoc business analysis by quickly provisioning a data mart environment geared for intensive query requirements with appropriate support.
