The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Data warehousing

IBM's data warehousing solutions are the most comprehensive data warehouse solutions in the industry; providing you with all of the capabilities necessary to glean maximum return from your most important investment - your information.

Integrate PureData system for Analytics and InfoSphere BigInsights for email analysis

Use BigInsights to store and analyze text files, and PureData System for Analytics as a warehouse and base platform for running Cognos BI reports. The authors use an email analysis example, storing and analyzing email data in BigInsights and the structured employee data in PureData System for Analytics. More >

Featured content

02 May 2013 — Show descriptions | Hide descriptions

Use the InfoSphere Optim 9.1 Test Data Management and Data Masking solution for Netezza Data Warehouse
Move a subset of data from a Netezza production database to a test database. Using this article, learn how to extract a subset of data, mask sensitive data, audit the masked data, and create a Netezza test database.
System Administration Certification exam 919 for Informix 11.70 prep, Part 7
Learn about data warehousing concepts, strategies, utilities, and commands. This series is designed to help you prepare for the System Administration Certification exam 919 for Informix 11.70.
An efficient change data capture using IBM InfoSphere CDC Transaction Stage
Guarantee data delivery and improve cost-efficiency by capturing changed operational data and transmitting it in real time to a data warehouse to ensure that the data is constantly up-to-date.
Secure and harden Netezza data warehouse appliance with InfoSphere Guardium
Learn the basics of protecting a Netezza appliance with Guardium. Vulnerability assessments and entitlement reports allow companies to monitor and identify potentially dangerous changes to the Netezza security setup that might put sensitive customer information at risk.
Best practices and performance guidelines for InfoSphere Information Server running on Intel Xeon servers, connecting to IBM Netezza Data Warehouse servers
Get the details about the comprehensive integration available between InfoSphere Information Server hosted on Intel Xeon E7 series processors and the Netezza Data Warehouse appliance. Learn how to optimize this environment for a highly scalable and reliable computing platform.
Best practices: Expanding an IBM Smart Analytics System
Use these best practices to learn how to identify, plan, and prepare for an expansion of your system, including how to understand the options involved in your expansion project.
Using InfoSphere Optim High Performance Unload as part of a recovery strategy in an IBM Smart Analytics System
Learn the best practices for unloading, extracting, and repartitioning data in DB2 for Linux, UNIX, and windows databases. Using High Performance Unload, you can move large volumes of data quickly by reading directly from backup images or table space containers rather than relying on the DB2 software layer.
Back up, restore, and roll forward in an InfoSphere Warehouse data partitioning environment
Learn how to back up and restore your database in a partitioned database environment. This article introduces the basics and demonstrates step-by-step the process of backup, recovery, and rollforward.
Effectively use DB2 data movement utilities in a data warehouse environment
Learn how to choose the proper data movement technique to efficiently move data between different systems in a large data warehouse. Explore a comparative study of the various methods for data movement.