“Driving Business Efficiency and Expansion”

Archiving with Oracle Database Data Warehousing 11g for Small Business Practices with IBM System p and System Storage Configuration for Unix® and Linux® operating system-based Oracle Database.

All businesses in need of information technology management are looking at the Oracle Enterprise Management Portfolio and the newest Oracle Database Data Warehousing 11g with IBM Solutions.

Small business practices requiring large-scale data warehousing, combined with “powerful, reliable, and secure” information processing and computing solutions for a very large customer base, ranging from 1,000 to 100,0000 accounts or more, for operational transactions, management, market analysis, statistics, date warehousing, archives, can find the IBM System p for Oracle Data Warehousing 11g as a practical business solution to information management.

The IBM System p models run on advanced IBM Power™ Dual Core chip technology, at affordable price/performance, innovative virtualization capacity, and mainframe-inspired reliability features. System p allows simultaneous applications and multi-threading technology to run at the same time, delivering outstanding performance for a single server, using the Oracle Database Data Warehousing 11g.

Case-in-point, a typical multimedia business can consolidate separate servers for graphics design, animation, audio, film, text, video games, and operational services on the IBM System p models. Multiple applications run on AIX and Linux operating systems simultaneously, separately, and securely, using one-tenth of the power with Advanced Power virtualization for the IBM System p. Flexible “capacity-on-demand” is custom-designed to scale up or down on processing power and memory load, based upon business demands and fluctuation.

IBM System p storage is compatible with Oracle Data Warehousing 11g and offers customer-oriented solutions and options for small business practices. For instance, IBM System Storage DS8000™ family delivers powerful “robust, flexible, highly available, and cost-effective disk storage operations for project management and mission-critical workloads”. While the IBM System Storage DS4000™ family-scalable, modular Fibre Channel Disk Storage, is designed for expansion growth, reliability, and availability in mind, from entry-level small business practices to corporate enterprise environments and performance-oriented service operations to capacity-oriented applications.

IBM and Oracle have teamed up to establish information technology standards used as Information Appliance Foundations, along with the Oracle Information Appliance Initiative. These are balanced configurations for data archiving warehouses that integrate system resources including hardware storage, Input/Output, and networking into data warehouse building blocks, partitioned for different economies of scale, in a linear mode—architecturally designed to support fluctuating workloads, based on varying raw data size, concurrent user load and diverse query complexity.

The architecture for Oracle and IBM System p is custom-designed and developed for Business Intelligence, reference, performance, and query analysis.

The Oracle Business Intelligence Enterprise Edition consists of high-level architectural software and system design solutions, that is to say: interactive dashboards, reporting and publishing queries, ad-hoc analysis, proactive detection and alerts, disconnected analysis, Microsoft Office; Oracle Intelligence Server, Partition Management, Oracle Database EE, Enterprise Tools, Oracle Automated Storage Management, supported by IBM AIX 5./3/Linux on x86, for IBM System p/ System x, and IBM System Storage.

The BI Server repository in the Oracle BI Enterprise Edition, with the individual client applications used to access the data warehouse, are part of the third software architecture group.

The architectural systems for Oracle on IBM System p, from data Input to Output, is defined as “a series of processes encompassing data integration, data warehousing, and data analytics; extracting, transforming, and loading (ETL) data constructed on repeatable building blocks, known as Oracle “nodes” for extracting, transforming, and loading data into the data warehouse and analytics application using corresponding sizing techniques for storage capacity.

Functional nodes are sized upon workload characteristics for Input/Output bandwidth, memory requirement, and the use of the central processing unit (CPU).

The Oracle BI Enterprise Edition processes data integration through ETL/Application, Synchronization, Transportation/Messaging, Information Integrity, etc.

The IBM business intelligence solution is the Oracle BI “Quick Sizer” Reference Tool developed over the years of business service to determine total storage capacity for integrated systems in the partnership between Oracle infrastructure, architectural systems design, and IBM information technology for Oracle Database Data Warehousing 11g and the IBM System p.

Accurate sizing provides an exact number of Oracle data integration nodes, Oracle data warehouse nodes and Oracle analytics nodes required.

Quick sizing for the Oracle DB Data Warehousing 11g is based upon performance data and other information collected from the customer’s operational environment—used to estimate the resources required for the following:
• New Oracle Business Intelligence or Data Warehousing 11g installations
• Additional applications for an existing Oracle BI or Data Warehousing 11g production environment
• Migrations to upgrade to new IBM hardware platforms, that is to say System p or System x™ servers, for expansion and growth performance

For questions and inquiries, contact Sales, Eric W. Brown at Email: ewbrown@us.ibm.com
or call, Tel. 1-800-426-0222, Nicole Parker, Oracle.

Oracle Business Intelligence combines information technology and applications for the small business entrepreneur to the corporate level in the Enterprise Edition Model. Enterprise information is architecturally designed for smart management with business insights for the entrepreneur, who is advised by its best features, in the Oracle EE Portfolio, as follow:

• Interactive Dashboards which access data via live reports and charts, dynamically custom-designed and personalized, based on functional roles in the business setting
• Microsoft Office and Outlook Integration which users embed and interact with BI content from familiar Microsoft Office desktop tools, using Oracle Business Intelligence Server Authentication
• Disconnected and Mobile Analytics for mobile users to have full analytical functionality with the same intuitive interface, while connected or off-line
• Proactive Detection and Alerts provide notifications and alerts to managers through multiple channels in response to predefined business events to improve and fasten, refined decision-making
• Reporting and Publishing for users who can integrate data from multiple sources to provide a wide array of reports using Microsoft Office and Adobe Acrobat, in order to deliver them through multiple channels
• Ad hoc Analysis for users who can gather and interact with a logical view of the information acquired from multiple data sources
• Essbase designed as the Oracle’s Hyperion Essbase, an online analytical processing (OLAP) server which provides users with an environment for rapidly developing custom analytics and enterprise performance management applications
• Desktop Gadgets for users who can choose multiple channels for which they want their intelligence reports delivered—including desktop gadgets.

The Oracle’s Business Intelligence Portfolio includes integrated security, user management, custom-designed personalization, a multidimensional calculation and integration engine, intelligent request generation, and optimized data access services.

With Oracle, “the innovation continues” by the current and updated Oracle Database Data Warehousing 11g, featuring:
• Online upgrades and patching
• Advanced partitioning and compression for customized archiving
• Record and replay real workloads
• Delegated jobs to a standby database
• Total Recall Query to a database “as it was a week ago”.

Oracle BI on IBM Systems can be accessed through a Web browser, portals, devices, and web services.

A model example for an Oracle data warehouse with the following specifications include:

• Architecture/OS – Powers5 2.2 GHz/Aix 5.3
• Server – IBM System p5 570
• Processors per block – 8
• Memory per block – 32 GB
• Internal Storage – 4x73GB 15K rpm HDD
• Fiber Channel HBA’s per Block 8xDual Port 4Gbps
• Interconnects per Block 4x 10/100/1000 Ethernet
• SAN Switch 16 port SAN Fibre Channel Switch
• External Storage Configuration: 1xDS4800 with 10x EXP810 Expansion Units – 160 x 145 GB 15 K rpm HDD
• Raw/Usable Storage Space 5TB/18TB

The IBM System p for Oracle Data Warehousing 11g allows data deployment throughout Enterprise and other applications from data sources, unstructured, informational, external.

IBM and Oracle are simplifying data processing for archiving, extraction, transformation, and loading (ETL), analytic applications through innovation and integrated technology for data warehousing with Oracle Database 11g and the IBM System p Optimized Storage configuration and deployment examples for Oracle Data Warehousing. Change without risk.

For additional information technology about the IBM System p and Oracle DB Data Warehousing 11g, visit the website at http://www.ibm.com/solutions/oracle

Small business service practices with projected expansion growth performance can benefit from the information technology and business intelligence provided by Oracle and IBM solutions.

Source: http://www.oracle.com and http://www.ibm.com

Gardenia C. Hung, M.A., B.A.'s VisualCV