Related links:
Title
|
Type
|
Date
|
|---|---|---|
| Data mining techniques
Examine different data mining and analytics
techniques and solutions. Learn how to build them using existing software
and installations.
Also available in:
Russian
Vietnamese
|
Articles | 11 Dec 2012 |
| Big data business intelligence analytics
Learn about integrating business intelligence and big data analytics.
Explore the similarities, differences, and what choices to consider.
|
Articles | 20 Nov 2012 |
| Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
In this IBM Redbooks publication we explain how you can build a business intelligence system with InfoSphere Warehouse Advanced Enterprise to manage and support daily business operations for an enterprise, to generate more income with lower cost. We describe the foundation of the business analytics, the Data Warehouse features and functions, and the solutions that can deliver immediate analytics solutions and help you drive better business outcomes.
We show you how to use the advanced analytics of InfoSphere Warehouse Advanced Enterprise Edition and integrated tools for data modeling, mining, text analytics, and identifying and meeting the data latency requirements. We describe how the performance and storage optimization features can make building and managing a large data warehouse more affordable, and how they can help significantly reduce the cost of ownership. We also cover data lifecycle management and the key features of IBM Cognos Business Intelligence.
|
Redbooks | 08 Oct 2012 |
| Virtualized Business Intelligence with InfoSphere Warehouse
This IBM Redbooks publication discusses the deployment of a BI cloud solution. It includes details such as understanding the architecture of a cloud, planning implementation, integrating various software components, and understanding the preferred practices of running a cloud deployment. Essentially, this book can be used as a guide by anyone who is interested in deploying a virtualized environment for a BI cloud solution.
|
Redbooks | 08 Oct 2012 |
| Evaluate: IBM InfoSphere Warehouse 10.1 Enterprise Edition
Download a free trial version of IBM InfoSphere Warehouse V10.1 Enterprise Edition,
which makes it easier to discover hidden business opportunities. It provides a comprehensive
platform to design, optimize, discover and grow departmental data marts and enterprise data
warehouses.
|
Trial Downloads | 28 Aug 2012 |
| Data.gov for government agencies
Because people are more aware of the value of open data,
entire new economies have sprung up around its use and management. In
2009, the U.S. Federal Government launched Data.gov, a site to aggregate
feeds of government data. Pressure on agencies to publish information at
Data.gov has been steady. The Open Government Directive of 2009 requires
all Federal agencies to post at least three high-value data sets online
and register them on Data.gov. Learn about Data.gov, the basic information
your agency needs to know to participate in this revolution in government,
and ideas for doing so efficiently.
Also available in:
Russian
Portuguese
|
Articles | 28 Feb 2012 |
| Back up, restore, and roll forward in an InfoSphere Warehouse data
partitioning environment
Knowing how to back up and restore your database is a fundamental skill
for every database administrator. In a partitioned database environment, where your
database is split across multiple partitions or nodes, there are special
considerations. This article introduces the basics and demonstrates
step-by-step the process
of backup, recovery, and rollforward in the IBM InfoSphere Warehouse partitioned environment.
Also available in:
Chinese
|
Articles | 08 Dec 2011 |
| Effectively use DB2 data movement utilities in a data warehouse environment
Choosing proper data movement utilities and methodologies is key to efficiently moving data between different systems in a large data
warehouse environment. To help you with your data movement tasks, this article provides insight on the pros and cons of each method with
IBM InfoSphere Warehouse, and includes a
comparative study of the various methods using actual DB2 code for the data movement.
|
Articles | 17 Nov 2011 |
| Online roll-out with table partitioning in InfoSphere Warehouse
Starting with DB2 9.7.1, the table partitioning feature is enhanced with
support for online roll-out using detach. With online roll-out, queries
continue to access the partitioned table while one or more partitions of the
table are being detached using the ALTER TABLE DETACH PARTITION command. This
article discusses how online detach improves the availability of the warehouse
and describes some best practices to leverage and monitor the new behavior. A
stored procedure is provided to help database administrators to script the
post-detach processing on the target table, that is, the new table created as
a result of the detach operation. The article also demonstrates how the same
procedure can be used to simulate synchronous detach behavior in certain
application scenarios. We conclude with frequently asked questions related to
detach.
Also available in:
Chinese
|
Articles | 27 Oct 2011 |
| Creating an active-active data warehouse topology using IBM InfoSphere Warehouse
This article explains how you can create an active-active environment for IBM InfoSphere Warehouse to meet the highest availability requirements using DB2 for Linux, UNIX, and Windows, WebSphere Edge Components, and Q Replication.
|
Articles | 21 Oct 2011 |
| Architect retail solutions with the IBM Retail Industry Framework
Learn how to architect successful Retail industry solutions
using the products and industry components of the IBM Retail Industry
Framework. By understanding how IT can enable solutions that address the key
business drivers and imperatives for the Retail industry, the IBM Retail
Industry Framework provides a model for solution development.
|
Knowledge paths | 07 Oct 2011 |
| Configure and monitor InfoSphere Warehouse with Optim Performance Manager
Extended Insight
Optim Performance Manager Extended Edition provides end-to-end database transaction response time
monitoring capability for InfoSphere Warehouse applications with its Extended Insight capability. This
capability gives you insight into the transaction and SQL statement response time metrics of a database
application throughout all layers of the software stack; from the time that the SQL is issued in the application, and through
the network and database server. Special support is available for InfoSphere
Warehouse SQL Warehousing Tool (SQW)
applications by recognizing transactions and SQL statements from InfoSphere Warehouse Application Server
automatically. This article provides detailed information for installing, configuring, and validating
the Optim Performance Manager Extended Insight feature for InfoSphere Warehouse applications.
|
Articles | 25 Aug 2011 |
| Use the IBM Industry Model Information Insurance Warehouse to define smart and mature
data models
In this tutorial, understand the method for developing data models for data warehouse projects
using the IBM Industry Model Insurance Information Warehouse (IIW), which is part of the IBM Industry Models product defined for the domain of
insurance. The tutorial shows the best approach to develop core data warehouse (CDW) models and data mart (DM) models. The tutorial also
introduces the recommended data warehousing development method (DWDM) to deal
with the IIW model pattern framework to architect DWH solutions for insurance companies.
|
Tutorial | 23 Dec 2010 |
| Tools and XML functionality for DB2 pureXML users
This article provides guidance to database users in choosing XML tools to help them
with the new responsibilities that arise now that IBM DB2 can efficiently store and manipulate XML data with
pureXML. The size of XML, which can vary from a few kilobytes (KB) to many megabytes (MB) per document
instance, and the hierarchical structure creates the need for new tool capabilities to ease the tasks of
creating, viewing, editing, and querying XML instances and schemas when using DB2 pureXML. This article reviews
the XML capabilities in tools available from IBM for working with XML database objects,
the different job roles that are impacted by having XML in the database, and the specific tasks involved. It then
describes the key XML-related tasks that arise and outlines which tools provide capabilities to help with those
tasks.
|
Articles | 02 Dec 2010 |
| Find databases with protected health information
Identity theft and medical fraud are growing problems. They are so big
the U.S. government is spending billions of dollars securing its own computer
systems and has written thousands of pages of new regulations that you must
follow to help protect your customer and employee data. To comply with new
regulations and properly secure data, you will need to find personally
identifiable information (PII) and protected health information (PHI) in your
databases and documents. Both PHI and PII are conceptually easy to understand
but very difficult to track in the thousands of relational data stores, files,
and spreadsheets that make up a typical organization's IT environment. This
article describes some methods to automatically identify and inventory PII,
PHI, and other sensitive data with databases and spreadsheets using Java
technology and the Apache Ant build tool.
Also available in:
Portuguese
Spanish
|
Articles | 19 Oct 2010 |
| Development Notebook: The evolution of the IBM Smart Analytics System
Two key IBM developers discuss the history and background of the IBM Smart Analytics System.
Also available in:
Chinese
|
Articles | 10 Oct 2010 |
| Smarter is: Breaking Data and Disease Down to Size
A hospital in China teams with IBM to create a tool that can help research treatments for chronic kidney disease.
Also available in:
Chinese
|
Articles | 10 Oct 2010 |
| Data Architect: You want to govern what?
Robert Catterall is a database guy, and he needs to be convinced of the need for data governance. With help from Steven Adler, director of Information Governance Solutions at IBM, he explores the tenets of data governance and discusses how it can help database teams.
Also available in:
Chinese
|
Articles | 30 Jul 2010 |
| Smarter is: Delivering social services where they're needed most
Alameda County Social Services Agency uses IBM DB2, InfoSphere Identity
Insight Solutions, and Cognos to implement a Social Services Integrated Reporting System that helps generate the information that the agency needs to continue to qualify for state and federal funding. The solution also helps reduce waste and direct resources where they are most needed.
Also available in:
Chinese
|
Articles | 30 Jul 2010 |
| Predictive analytics on SAP with SPSS and InfoSphere Warehouse
Predictive analytics software helps you to find non-obvious, hidden patterns in large
data sets.
Current tools for predictive analytics, such as SPSS (an IBM company) and IBM InfoSphere Warehouse, expect data to be represented in an
appropriate way before the actual analysis can take place.
However, you may have cases where the data you want to analyze is not readily available in
a format these tools can recognize.
For example, SAP systems are widely used by many companies across a variety of industries, but
data in SAP systems is not directly accessible to these tools.
This article shows you how to use IBM InfoSphere Information Server to extract data from SAP systems for analysis
within InfoSphere Warehouse and SPSS PASW Modeler.
|
Articles | 08 Jul 2010 |
| InfoSphere Warehouse: A Robust Infrastructure for Business Intelligence
The InfoSphere Warehouse platform provides a fully integrated environment built around IBM DB2® 9.7 server technology on Linux®, UNIX® and Microsoft® Windows® platforms, as well as System z®. Common user interfaces support application development, data modeling and mapping, SQL transformation, online application processing (OLAP) and data mining functionality from virtually all types of information. Composed of a component-based architecture, it extends the DB2 data warehouse with design-side tooling and runtime infrastructure for OLAP, data mining, inLine analytics and intra-warehouse data movement and transformation, on a common platform.
|
Redbooks | 21 Jun 2010 |
| Taking the first steps toward data quality
How do you create a data quality project or program? What specific
steps should you take, and why? What should you focus on and what can you
leave alone? This article outlines smart moves you can make to kick-start
your data quality efforts, and presents a plan for initiating a data quality program.
|
Articles | 30 Apr 2010 |
| Using IBM InfoSphere Warehouse Design Studio with pureXML data,
Part 2: Create a control flow for multiple ETL jobs involving XML
Learn how to integrate business-critical XML data into your data
warehouse using IBM InfoSphere(TM) Warehouse Design Studio and DB2(R) 9.7
pureXML(R). This two-part article series provides step-by-step instructions
for using pureXML as both a source and target data source for extract,
transform, and load (ETL) operations developed with InfoSphere Warehouse
Design Studio. This article describes how to build a single control flow that calls multiple data
flows that extract, transform, and load XML data in a specific sequence.
Also available in:
Portuguese
|
Articles | 01 Apr 2010 |
| Using IBM InfoSphere Warehouse Design Studio with pureXML data,
Part 1: Create an ETL data flow to populate a hybrid data warehouse
Learn how to integrate business-critical XML data into your data
warehouse using IBM InfoSphere(TM) Warehouse Design Studio and DB2(R) 9.7
pureXML(R). This two-part article series provides step-by-step instructions
for using pureXML as both a source and target data source for extract,
transform, and load (ETL) operations developed with InfoSphere Warehouse
Design Studio. This article explains how to build a single data flow that uses
an XML-based source table to populate two target data warehouse tables. One of
these tables contains only relational data, while the other contains both
relational and XML data.
Also available in:
Russian
Portuguese
|
Articles | 25 Mar 2010 |
| High-performance data mining
An examination of the capabilities of IBM InfoSphere Balanced Warehouse through a scoring performance study
|
Articles | 19 Oct 2009 |
| Using virtual cubes in IBM InfoSphere Warehouse 9.7 to combine business
scenarios and to improve performance
Virtual cubes are one of the new Cubing Services features in IBM
InfoSphere(TM) Warehouse 9.7. A virtual cube provides a way to merge different
cubes together to allow a single query destination that returns merged results
from the cubes that compose it. Virtual cubes can be used to drastically
improve the response time of the cube server queries by using efficient data
partitioning for optimum cache utilization (in some cases, over 100 times
better response times). Virtual cubes also offer a solution for combining
results by merging different regional cubes into a country cube. They also
enable merging sales numbers with currency exchange rates to provide a global
view of the business. This article explains how virtual cubes are created, how
they work, and how to use them for InfoSphere Warehouse Cubing Services
9.7.
Also available in:
Russian
Portuguese
|
Articles | 10 Sep 2009 |
| Designing and deploying a security model using IBM InfoSphere Warehouse
Cubing Services
In IBM InfoSphere(TM) Warehouse V9.7, Cubing Services modify the way you
secure your cubes and provide a way for you to secure your dimensions. You
might need to limit access to your OLAP data at the level of the cube or at
the more granular level of the dimension, depending on your security
requirements. In this article, you will learn how to define security on cubes
and dimensions by creating roles, policies, and authorizations in the Design
Studio. This article describes how to export the security model to a file and
how to use the Administration Console to import the security model to the
InfoSphere Warehouse control database. After importing the security model, you
will learn how to instruct the Cube Server to enforce the rules in the
security model.
Also available in:
Portuguese
|
Articles | 03 Sep 2009 |
| Text Analysis in InfoSphere Warehouse, Part 3: Develop and integrate custom UIMA text analysis engines
In the first two articles of this series, you learned about IBM InfoSphere Warehouse text analysis capabilities,
how to use regular expressions and dictionaries to extract information from text, and how to publish the results with
a Cognos report.
This article describes how to use the Unstructured Information Management Architecture (UIMA) framework to create a custom
text annotator and use it in InfoSphere Warehouse.
The ability of InfoSphere Warehouse to use UIMA based annotators in analytic flows is a powerful feature.
You can write
custom annotators that can extract almost any information from text.
Plus you can use UIMA based annotators that are provided by IBM, other companies, and
many universities.
For example, you can find UIMA annotators that tokenize words and extract
concepts such as persons or sentiments.
Also available in:
Spanish
|
Articles | 27 Aug 2009 |
| Text analysis in InfoSphere Warehouse, Part 2: Dictionary-based information extraction combined with IBM Cognos
reporting
Unstructured information represents the largest, most current, and
fastest growing source of information that is available today. This
information exists in many different sources such as call center records,
repair reports, product reviews, e-mails, and many others. The text analysis
features of IBM InfoSphere(TM) Warehouse can help you uncover the hidden value
in this unstructured data. This series of articles covers the general
architecture and business opportunities of analyzing unstructured data with
the text analysis capabilities of InfoSphere Warehouse. The integration of
this capability with IBM Cognos(R) reporting enables people across the company
to exploit the text analysis results. The first article of this series gave an
overview of the text analysis capabilities in InfoSphere Warehouse and showed
how to use regular expressions to extract concepts from free-form text. This
second article shows you how to use dictionaries for concept extraction and
how you can use taxonomies to structure them. It also explains how you can
present the results in an interactive Cognos report.
|
Articles | 09 Jul 2009 |
| Generate Cognos reports using InfoSphere Warehouse Cubes
Learn how to generate Cognos professional reports using InfoSphere Warehouse data models.
Cognos is SOA-based, light-weight, and user-friendly, and no programming skills are required to create reports.
This article serves as a start for users who may have used other tools in the past and now want to generate professional
Cognos reports using InfoSphere Warehouse cubes.
Also available in:
Portuguese
|
Articles | 18 Jun 2009 |
| Text analysis in InfoSphere Warehouse, Part 1: Architecture overview and example of information extraction with regular expressions
Unstructured information represents the largest, most current, and fastest
growing source of information that is available today.
This information exists in many different sources such as call center records,
repair reports, product reviews, e-mails, and many others.
The text analysis features of IBM InfoSphere Warehouse can help you uncover the hidden value
in this unstructured data.
This series of articles covers the general architecture and business opportunities of analyzing unstructured data with the text analysis capabilities
of InfoSphere Warehouse.
The integration of this capability with IBM Cognos reporting enables people across the company
to exploit the text analysis results.
This first article introduces the basic architecture of the text analysis feature in InfoSphere Warehouse
and includes a technical example showing how to extract concepts from text using regular expressions.
Also available in:
Spanish
|
Articles | 04 Jun 2009 |
| Using DB2 XQuery to extract data mining results stored as PMML
Data mining is the process of finding rules and patterns in structured
data. DB2(R) data mining uses Intelligent Miner, which is part of
InfoSphere(R)
Warehouse. Intelligent Miner(R) stores those results in Predictive Model
Markup Language (PMML) format, which is based on XML.
Since the launch of DB2
9, information stored in XML can be processed efficiently using XQuery. Find
out how easily you can use DB2 XQuery to create your own access methods based on your data
mining results.
Also available in:
Japanese
|
Articles | 21 May 2009 |
| Install and configure InfoSphere Warehouse on System z
This article takes you through the installation of InfoSphere Warehouse on a Linux partition on System z. Learn about pre-installation requirements, then walk through the steps for a successful installation.
|
Articles | 14 May 2009 |
| Multidimensional Analytics: Delivered with InfoSphere Warehouse Cubing Services
In this IBM Redbooks publication, we discuss and describe a multidimensional data warehousing infrastructure that can enable solutions for complex problems in an efficient and effective manner. The focus of this infrastructure is the InfoSphere Warehouse Cubing Services Feature. With this feature, DB2 becomes the data store for large volumes of data that you can use to perform multidimensional analysis, which enables viewing complex problems from multiple perspectives, which provides more information for management business decision making. This feature supports analytic tool interfaces from powerful data analysis tools, such as Cognos 8 BI, Microsoft Excel, and Alphablox.
This is a significant capability that supports and enhances the analytics that clients use as they work to resolve problems with an ever growing scope, dimension, and complexity.
Analyzing problems by performing more detailed queries on the data and viewing the results from multiple perspectives yields significantly more information and insight. Building multidimensional cubes based on underlying DB2 relational tables, without having to move or replicate the data, enables significantly more powerful data analysis with less work and leads to faster problem resolution with the capability for more informed management decision making.
This capability is known as No Copy Analytics and is made possible with InfoSphere Warehouse Cubing Services.
|
Redbooks | 05 May 2009 |
| Integrate InfoSphere Warehouse Data Mining with IBM Cognos
Reporting, Part 4: Customer segmentation with InfoSphere Warehouse and Cognos
In the previous articles of this series, you learned different
techniques for integrating InfoSphere Warehouse Data Mining and simple Cognos
reports. This latest article teaches you how to use some of the same
integration techniques to create a more complex report that focuses on the
task of customer segmentation. Customer segmentation allows companies to
cluster their customers into characteristic groups. One important issue in this task is to explain to
the user the meaning of the individual customer segments. Interactive Cognos
reports can help you do this. The article uses a step-by-step example, to
teach you how to create a report that visualizes cluster statistics and, thus,
allows you to find out which customers in a given segment are special. The
article also shows you how to enable drill-through for accessing details of
individual customers within a segment.
Also available in:
Vietnamese
|
Articles | 29 Jan 2009 |
| Integration of InfoSphere Warehouse Data Mining with IBM Cognos Reporting, Part 3: Invoke mining dynamically from Cognos using a market basket analysis example
Association rules express which items, events or other
entities often occur simultaneously in large datasets. This knowledge
can be applied, for instance, in market basket analysis to
leverage cross-selling potentials by recommending products
that are ofter bought together.
You can apply association rule mining in InfoSphere
Warehouse and export the resulting model to Cognos reports,
similar to the way previous articles in this series did with Cluster and Classification models.
Since association rule mining is a highly interactive task, a better
solution would be to allow the user to call mining directly
from a Cognos report, possibly specifying additional
parameters. Such an approach can be denoted as dynamic or ad hoc mining.
In this article you will learn to achieve this.
|
Articles | 30 Dec 2008 |
| Integrate IBM InfoSphere Warehouse data mining with IBM Cognos
reporting, Part 2: Deviation detection with InfoSphere Warehouse and Cognos
Learn advanced techniques, such as drill-down and the extraction of
structured information from data mining models with Cognos. Using the included
business scenario and running example, understand the data mining task of
deviation detection, that is, the task of identifying unnatural data records.
See how to find such records with IBM InfoSphere Warehouse data mining, and
create interactive reports that allow interactive exploration.
|
Articles | 26 Nov 2008 |
| Integrate InfoSphere Warehouse data mining with IBM Cognos
reporting, Part 1: Overview of InfoSphere Warehouse and Cognos integration
architecture
Get an introduction to the basic integration architecture involved in
integrating InfoSphere Warehouse data mining with IBM Cognos reporting, in Part 1 of
this series. Also, examine a technical case study to gain a basic understanding of how to achieve the integration.
|
Articles | 30 Oct 2008 |
| Use the Business Intelligence Reporting Tool with DB2 Data Warehouse
Edition, Part 4: Interactivity in reports and charts
The Business Intelligence and Reporting Tool (BIRT) is an open source,
relational reporting solution. It provides an Eclipse-based plug-in for report
development and testing, and it provides J2EE deployment and API that can be used in
custom Java applications. With IBM DB2 Data Warehouse Edition (DWE), use DWE Design
Studio to seamlessly integrate the BIRT development environment, and then deploy
those reports to an IBM WebSphere server. During the course of this tutorial, learn
how to add interactivity to your reports using BIRT in Design Studio.
Also available in:
Chinese
|
Tutorial | 06 Mar 2008 |
| Create Web services for real-time scoring using DB2 Warehouse V9.5
Build real-time scoring analytical Web services with DB2 Warehouse
V9.5 Design Studio. Compute cross-sell recommendations using
association models or compute risk scores using prediction
models in real-time to drive operational business decisions.
Also available in:
Russian
|
Articles | 06 Dec 2007 |
| Hints and tips for using the Business Intelligence and Reporting Tools
The open source, Eclipse-based Business Intelligence and Reporting Tools project brings advanced reporting capabilities to Information Management products such as DB2 Data Warehouse Edition and WebSphere RFID Information Center. This article shows you how to go beyond the basics to implement additional functions to meet the detailed reporting needs of your user community.
|
Articles | 09 Aug 2007 |
| Use the Business Intelligence Reporting Tool with DB2 Data Warehouse
Edition, Part 2: Create basic reports and charts
Learn the best practices of using BIRT in Design Studio. This tutorial is
Part 2 of a series aimed at demonstrating the best practices for installing BIRT,
using it to create reports on relational data, and then deploying them in a Web
server to view them.
Also available in:
Chinese
|
Tutorial | 12 Jul 2007 |
| Use the Business Intelligence Reporting Tool with DB2 Data Warehouse
Edition, Part 1: Install BIRT and sample data in DWE Design Studio
BIRT being an open source tool for report generation is very useful for our
DWE users. Reason being it's ability to generate reports based on relational data
and providing interactivity between them. The present series of tutorial is aimed to
demostrate the best practices for instaling BIRT, using it to create reports on
realtional data and then deploying them in a Web server to view them. During the
course of this tutorial, you will learn the best practices of using BIRT in Design
Studio.
Also available in:
Chinese
|
Tutorial | 19 Apr 2007 |
| Advanced topics for DB2 Data Warehouse Edition users, Part 3: Command Line Interface for DB2 Data Warehouse Edition SQL Warehousing
This article introduces an early version of the IBM DB2 Data Warehouse Edition Administration Command
Line Interface. The DWE CLI extends the existing infrastructure to support execution of administrative and monitoring tasks in non-GUI environments, the automation of recurring tasks, and handling of large task batches.
|
Articles | 05 Apr 2007 |
| Improve DB2 query performance in a business intelligence environment
Running large queries efficiently is a top performance challenge in a business intelligence environment. Learn techniques for improving DB2 data server query performance in this environment. Walk through various methods, step-by-step, then experiment on your own system. Each method is applied to a single SQL statement, using the db2batch tool to measure performance.
|
Articles | 22 Mar 2007 |
| Advanced topics for DWE users Part 2: Best practices for choosing DB2 Data Warehouse Edition SQL Warehousing variable phases
Optimize your DB2 Data Warehouse Edition flow design with a good understanding
of variable usage in order to promote user satisfaction, support flow reuse, and help
reduce administration overhead. In this article, find recommendations and best practices on how to best utilize different variable phases to maximize the benefits of variable usage in SQL Warehousing Tool data flows and control flows during design time, and how each variable
phase can impact the runtime behavior when these flows are
executed.
|
Articles | 01 Feb 2007 |
| Advanced topics for DB2 Data Warehouse Edition users, Part 1: Crash recovery utility for DB2 Data Warehouse Edition SQL Warehousing Tool
Protect your data warehouse environment using a new, downloadable crash
recovery utility. With this tool, perform health checks and recover
inconsistent IBM DB2 Data Warehouse Edition SQL Warehousing runtime metadata caused by unhandled
interrupts. After the tool corrects the inconsistent metadata, the interrupted process
instances are available for restart or termination.
|
Articles | 18 Jan 2007 |
| Text Mining for associations using UIMA and DB2 Intelligent Miner
Get more value from your unstructured information. Explore how you can mine text using UIMA and DB2 Intelligent Miner to bridge from unstructured to structured information.
|
Articles | 02 Feb 2006 |
| IBM Redbooks: Business Performance Management . . . Meets Business Intelligence
In this IBM Redbook, we discuss business performance management (BPM) and its integration with business intelligence. BPM is all about taking a holistic approach for managing business performance and achieving the business goals.
|
Articles | 16 Aug 2005 |
| Deliver an effective and flexible data warehouse solution, Part 1: Engage your customers in planning the data warehouse project
Take a flexible and effective approach to plan, design, and implement a basic data warehouse solution with this article series. Part 1 focuses on the customer engagement process and project planning.
|
Articles | 16 Jun 2005 |
| Business Intelligence solutions architecture
Build a data warehouse solution using IBM technology.
|
Articles | 26 May 2005 |
| Data mining with association rules using WebSphere Commerce Analyzer
This short tutorial shows how you can create association rule mining against the WebSphere Commerce operational database or against a WebSphere Commerce Analyzer data mart where the production system is not impacted. You can use the results from association rule mining to set up bundles of packages that customers tend to buy together.
|
Articles | 24 Nov 2004 |
| Using DB2 UDB OLAP functions
Online analytical processing (OLAP) functions are very flexible and powerful. Using them, you may come up with simple solutions to some problems that would otherwise require either iteration through one or several cursors or recursion. In some other cases it is much easier to write a query using OLAP functions or auxiliary tables than to write an equivalent query not using them.
|
Articles | 22 Jan 2004 |
| Building business intelligence skills
Data warehousing and business intelligence projects require very specific and sound technical skills. It is no mean feat to collect data from many different sources and ensure it is validated, combined, structured, stored, distributed and analyzed reliably and correctly. This requires a sound knowledge of information analysis techniques, of data warehousing and business intelligence technology. Additionally, one also needs a level of business acumen to understand how business intelligence technology can support the decision making process within the organization.
|
Articles | 22 Jan 2004 |
| Create an intelligent and flexible solution with BPM, Business Rules, and Business Intelligence: Sense and respond in the data warehouse
In our first article, we introduced the overall concepts of ondemand business, business process management (BPM), business rules engine and business intelligence. In the second article, we demonstrated how a business rules engine can serve to externalize policy from the business process manager. In the third article, we discussed the details of how to make business intelligence data visible to the business process. In this final article in the series, we touch on analytics in concert with BPM can create a dynamic and flexible sense and respond environment.
|
Articles | 04 Dec 2003 |
| Create an intelligent and flexible solution with BPM, Business Rules, and Business Intelligence: Data warehouse visibility
This article focuses on the role of business intelligence in an intelligent and flexible BPM solution. It discusses the application of on-line analytical processing (OLAP) technology for advanced analytics, considering both OLAP access and integration. This includes drilling down to the technical details of implementing a dynamic pricing model. Finally, it introduces DB2 Cube Views, an extension to the OLAP paradigm which, when used with OLAP products, can be used to produce optimized OLAP solutions for enterprises.
|
Articles | 20 Nov 2003 |
| Mining Your Warranty Data Using IBM DB2 Intelligent Miner for Data
This paper starts with the concept of warranty and shows how IBM?s DB2 Intelligent Miner for Data can be used to analyze repair records.
|
Articles | 20 Nov 2003 |
| Best Practices for EMC Symmetrix 8000 with IBM DB2 Universal Database
This white paper gives you a general overview of IBM DB2 Universal Database (UDB) with database partitioning and the EMC Symmetrix 8000 series (Symmetrix).
|
Articles | 19 Jun 2003 |
| Enhance Your Business Applications: Simple Integration of Advanced Data Mining Functions
Data mining can be used just like any other standard relational function. Part 1 of this redbook helps business analysts and implementers to understand and position these new DB2 data mining functions. Part 2 provides examples for implementers on how to easily and quickly integrate the data mining functions in business applications to enhance them. And part 3 helps database administrators and IT developers to configure these functions once to prepare them for use and integration in any application.
|
Redbooks | 08 Jan 2003 |
| DB2 UDB's High-Function Business Intelligence in e-business
This IBM Redbook deals with exploiting DB2 UDB's materialized views (also known as ASTs/MQTs), statistics, analytic, and OLAP functions in e-business applications to achieve superior performance and scalability. This redbook is aimed at a target audience of DB2 UDB application developers, database administrators (DBAs), and independent software vendors (ISVs).
|
Redbooks | 03 Oct 2002 |
| DB2 OLAP Server V8.1: Using Advanced Functions
This redbook explores DB2 OLAP Server V8.1 enhancements and strengths in the areas of scalability, performance, high concurrency, high availability and administration and how to deploy them in a whole enterprise environment.
|
Redbooks | 03 Oct 2002 |
| DB2 Intelligent Miner Multiprocessor Solution V1.1
The DB2 Intelligent Miner Multiprocessor Solution combines proven Intelligent Miner technology with the parallel database access capabilities of DB2 UDB to meet the demands of large-scale mining.
|
Related sites | 06 Jun 2002 |
| Connector for SAP R/3: A Ready-to-go Warehousing Solution
Realize the value of integrating critical SAP R/3 data with other important business data for enhanced business intelligence. Incorporate SAP business objects into your DB2 data warehouse quickly and easily using Connector for SAP R/3.
|
Articles | 01 Apr 2002 |
| New OLAP Miner Feature
OLAP Miner Fixpak 6 provides a no charge DB2 OLAP Miner feature, which can help you analyze your business data by automating the ability to scan through OLAP cubes to find atypical values.
|
Product documentation | 06 Dec 2001 |
| Mining Your Own Business in Telecoms using DB2 Intelligent Miner for Data
This IBM Redbook is a solution guide to address the business issues in telecommunications by real usage experience and to position the value of DB2 Intelligent Miner for Data in a Business Intelligence architecture as an integrated solution.
|
Redbooks | 12 Oct 2001 |
| Mining Your Own Business in Health Care Using DB2 Intelligent Miner for Data
This IBM Redbook is a solution guide to address the business issues in health care by real usage experience and to position the value of DB2 Intelligent Miner for Data in a Business Intelligence architecture as an integrated solution.
|
Redbooks | 12 Oct 2001 |
| Operation Data Mining
This article explains the considerations in operationalizing data mining, how DB2 Intelligent Miner Scoring brings the model deployment process out of the hands of analysts into the standard database administrative process, and what data mining developments to expect in the future.
|
Articles | 27 Jul 2001 |
| e-Business Intelligence Front-End Tool Access to OS/390 Data Warehouse
Based on the IBM e-BI architectural framework, this Redbook explains the building blocks required to connect front-end e-BI user tools to the OS/390 data warehouse or data mart. It also shows the Web integration in the architecture and the accessibility of the data warehouse from browser-based clients in an e-business environment.
|
Redbooks | 03 Jul 2001 |
| Reading between the lines
This article discusses methods of mining unstructured data including three fundamental text mining operations: clustering, categorization, and information retrieval.
|
Articles | 01 Mar 2001 |
