AS/400e Advanced Technology 61
AS/400e Advanced Technology
technology and industry specific Business Intelligence applications have made
implementations meaningful and cost effective.
AS/400e Enabling Technology
The AS/400e system offers state-of-the-art 64-bit relational database processing. The
AS/400e system has been optimized for a Business Intelligence environment with customized
hardware (AS/400e servers) and optimized software (DB2/400, SMP for DB2/400, DB2
Multi-System, and Data Propagator Relational). These hardware and software functions
combine to make a powerful Business Intelligence server that is easy to install, manage, and
use.
With the AS/400e system open interfaces, hundreds of tools can be used to provide Business
Intelligence solutions accessing DB2/400 data transparently. Such tools include desktop
analysis tools (Business Objects, for example) and sophisticated multi-dimensional analysis
(commonly referred to as OLAP) tools (Essbase/400, for example), with no special
programming required.
SMP for DB2/400
provides parallel query processing. This allows multiple processors in a
single AS/400e system to collectively work on a single query and can improve query
performance by as much as 400%.
DB2 Multi-System
support provides clustering for the
AS/400e and allows up to 32 AS/400e servers to be “clustered” together into a single system.
This clustering provides almost unlimited scalability and unparalleled performance for
AS/400e customers. The combination of all of these advanced features has dramatically
improved AS/400e performance so much that customers using UNIX systems, PC servers,
and even large specialized parallel servers have converted from these machines to the
AS/400e system.
Data replication is an important technology to facilitate the automated loading of data
warehouses while cleaning up or summarizing data for integrity and performance purposes.
DataPropagator/400 provides asynchronous data movement between OLTP systems and
Business Intelligence systems. Data Propagator allows fields to be summarized, derived, or
aggregated into the data elements necessary in your data warehouse.
Data mining is a Business Intelligence application that uses mathematical algorithms to scan
potentially large amounts of data to find the golden nuggets of information. Intelligent Miner
for AS/400e provides the most advanced data mining application for AS/400e customers. It
offers optimized computer models to “discover” data relationships previously unknown. The
models include algorithms for clustering, information classification, predictions, associations,
sequential pattern recognition, and time sequence patterns. This analysis provides
executives with insight that can truly be a competitive advantage.