L OS PRONOMBRES SUJETO DESDE LA PERSPECTIVA DEL CAMBIO LINGÜÍSTICO

Additional IBM products are included or available in special InfoSphere

Warehouse 10.1 editions, such as data management, data integration, and DB2 advanced recovery solutions, Cognos Business Intelligence, and InfoSphere Warehouse Packs, as shown in Figure 1-15.

Figure 1-15 InfoSphere Warehouse components and features

You need to download, install, and configure some of these components. For additional details, refer to the licensing information for the InfoSphere Warehouse editions, as described in 1.4.5, “InfoSphere Warehouse editions and differences” on page 39.

IBM Data Management solutions

The IBM data management solutions described in this section provide the foundation and tools for enhancing the administration and maintenance of data.

These tools can help you meet SLAs and solve performance problems before they impact the business.

򐂰 IBM Data Studio

IBM Data Studio is not just another integrated development environment (IDE) for application development, it is a full data lifecycle management tool. Data Studio provides a basic set of tools to administer and develop your database; Data Studio Health Monitor allows you to view health information, alerts, application connections, and utilities related to the system.

򐂰 InfoSphere Data Architect

Data modeling is the first step in creating a data warehouse. You might realize that the current physical definitions of your data model need to be modified. You might need additional columns or referential integrity that is not currently implemented.

A subset of the data modeling component was added to InfoSphere Warehouse using an Eclipse plug-in (physical data modeling). With this plug-in, existing data structures can be reverse-engineered and new physical data structures can be defined. One tool that can help is InfoSphere Data Architect, which can be used to extend the data modeling capabilities into logical modeling, logical dimensional modeling, and business glossary features.

򐂰 InfoSphere Optim Performance Manager

Optim Performance Manager can be used to isolate performance problems by monitoring bufferpools, I/O, locking, logging, memory, active SQL, system utilities, and workload. It offers highly accessible monitoring with a new browser-based user interface. InfoSphere Optim Performance Manager Extended Edition provides extensive dashboards and alerts to identify a problem at any time from any location. This alert includes identifying locking conflicts, deadlocks, problematic applications or queries, constrained buffer pool cache and heap sizes, CPU, memory, file system shortages, and data skew conditions. DBAs can also set thresholds so alerts can be automatically triggered by a particular set of circumstances.

򐂰 InfoSphere Optim Query Workload Tuner

IBM InfoSphere Optim Query Workload Tuner empowers administrators to more efficiently manage performance by proactively optimizing the

performance of SQL queries and query workloads. Built on an open-source, Eclipse-based environment, InfoSphere Optim Query Workload Tuner makes it easy to access candidate queries and define workloads from a number of common sources. DBAs can efficiently capture, format, and analyze SQL statements and workloads, creating graphic visualizations of query plans and costs. For administrators, the solution removes much of the tedium and time

from query analysis by formatting queries for readability, annotating them with statistics, visualizing the access plan, and more.

򐂰 InfoSphere Optim Configuration Manager

IBM InfoSphere Optim Configuration Manager for DB2 for Linux, UNIX, and Windows offers centralized management of database and client configuration based on IBM DB2 technology and is designed to manage data more effectively and efficiently. Centralized client connection definitions can improve manageability by tracking client access to data servers and providing information, such as host name, IP address, user ID, client version

information, and more. Properties of deployed database clients can be modified to improve database transaction performance, enforce security and privacy controls, allocate data clients among data servers for desired workload balance, and redirect data clients to connect to a different data server.

Data integration solutions

As organizations try to view their customers and business in a unified way, they are quickly discovering that the individual silos of information that have been created or acquired over the years are now a major obstacle in optimizing their business processes and relationships with customers. The following IBM Data Integration solutions can help you to synchronize information across

heterogeneous environments and provide a consistent view of information without impacting the source system performance:

򐂰 InfoSphere Replication Server

IBM InfoSphere Replication Server provides a high-volume, low-latency data replication solution that uses WebSphere MQ message queues for high availability and disaster recovery, data synchronization, and data distribution. 򐂰 InfoSphere Federation Server

IBM InfoSphere Federation Server allows organizations to virtualize their data and provide information in a form that applications and users need while hiding the complexity of the underlying sources. Data virtualization allows information to be accessed through a common interface that centralizes the control of data access.

IBM DB2 Advanced Recovery solutions

The following IBM DB2 Advanced Recovery solutions offer an effective backup and recovery strategy to help meet SLAs, reduce errors, and reduce recovery time:

򐂰 Optim High Performance Unload

The primary function of the DB2 High Performance Unload tool is unloading very large tables from DB2 rapidly; often, four to six times faster than when

using the DB2 export command. It achieves this speed by reading the table space files directly and processing them itself rather then using standard DB2 services. As a result, it cannot do complex SQL query-type processing. It trades away that capability for high speed unloading of the data.

High Performance Unload can filter columns and rows with simple predicates and even do some basic transformations of the data while it is being

unloaded. High Performance Unload is designed to be an unload utility rather than a query tool. It is highly threaded to exploit the hardware to perform the unloads in the shortest possible time through parallel processing.

򐂰 DB2 Recovery Expert

DB2 Recovery Expert is separate from the database, which allows it to run without taking operations offline. It only needs the artifacts of the database, such as the database logs and the backup files, to figure out the best path to recovery, and reduces the amount of disruption during the recovery process. 򐂰 DB2 Merge Backup

DB2 Merge Backup can help reduce application downtime, manage backups more efficiently and easily, and recover more quickly to meet SLAs. For example, if backups are large and are now taking longer, it is often perceived that you can solve the problem by buying a newer, faster tape drive or higher performance storage. So, when grappling with these kinds of issues, consider a well thought out backup and recovery strategy.

IBM Cognos Business Intelligence

IBM Cognos Business Intelligence is the preferred reporting tool to integrate with InfoSphere Warehouse as the front-end of a virtualized business intelligence environment.

IBM Cognos Business Intelligence delivers reporting capabilities in a single product, with one platform that can address a large range of users, from executives to line managers to sales and support staff. Business users can access any data or combination of data and visualize it through a number of access modes, including zero-footprint web browser, enterprise search, and even on a mobile device. The platform is founded on a web-services-based service-oriented architecture to maximize integration and delivery across all products.

InfoSphere Warehouse Packs

Few organizations have the time, budget, and specialized IT staff to build all capabilities from scratch. Many departments or branch offices within larger enterprises also lack the resources to implement business analytics from scratch. These organizations can use the following IBM solutions that are ready

for immediate use to simplify and speed deployment of critical business analytics while minimizing risk and cost.

IBM InfoSphere Warehouse Packs are designed to speed time-to-value by allowing organizations to focus on business issues and innovation rather than database plumbing. The packs are accelerator add-ons for InfoSphere Warehouse installations. They include complete physical data models and sample reports based on specific business issues that organizations face every day.

The following packs are designed to reduce data warehousing project time, business risk, and deployment cost:

򐂰 Customer Insight Warehouse Pack

This pack addresses a range of business issues common to organizations that are trying to better understand the profitability and profiles of their typical customers. It includes sample Cognos reports in the areas of communications analysis, transaction analysis, periodic analysis, and profitability analysis. 򐂰 Marketing and Campaign Insight Pack

This pack is designed to help organizations understand the overall details of their market and determine how to acquire new customers in a competitive environment. It includes sample Cognos reports in the areas of market analysis and campaign analysis.

򐂰 Supply Chain Insight Pack

This pack is designed to help organizations ensure that they have the correct products or components in the correct place at the correct time, without hurting cash flow by overinvesting in inventory. For many organizations, efficient supply chain management is fundamental to success.