Previous
Advanced Query Management for Optimizing Data Warehouse Performance
White Papers This paper describes first in Japan - of the implementation of IBM DB2 Query Patroller Version 8.2 in a development project for a data warehouse system. It describes the issues the client, a major Japanese manufacturer, had in their environment...
[April 21, 2007, 1:00]
Data Analysis Solution Provider Increases Query Performance by Nearly 50 Percent
White Papers Nexius worked with Netezza, a developer of data warehouse appliances, and Microsoft to integrate Xplore with the Netezza platform. The combined solution integrates Nexius technology with Microsoft SQL Server 2008 Analysis Services and the Netezza...
[May 30, 2009, 1:19]
Data Warehouse Technologies: an Architectural Comparison
White Papers It addresses the inherent limitations of traditional architectures that result in bottlenecks when processing complex queries on enormous quantities of data, examines the methods used by some well-known vendors and it shows how Netezza’s approach...
[April 12, 2005, 0:00]
Implementation of IBM DB2 Cube Views With Siebel Business Analytics
White Papers IBM DB2 Cube Views is a feature of the IBM DB2 Universal DataBase (UDB) Data Warehouse Editions that improves the ability of DB2 UDB to perform OLAP processing. SQL queries in Data Warehouse applications usually involve large volumes of data stored...
[August 30, 2006, 1:00]
An Introduction to New Data Warehouse Scalability Features in SQL Server 2008
White Papers SQL Server 2008 provides a range of integrated products that enables one to build data warehouse, and query and analyze its data. It meets the data warehouse needs of the largest enterprises more easily than ever.
[September 16, 2009, 1:22]
Data Profiling and Automated Cleansing Using Oracle Warehouse Builder 10g Release 2
White Papers Data is usually sourced from a number of systems and has to be extracted, cleansed, and integrated before being made available for users to query. Most organizations build a data warehouse to provide an integrated, reliable, and consistent "Single...
[March 20, 2008, 0:02]
Oracle Database 10g: Top Features for DBAs - Part 4: Data Warehousing and Integration Features
White Papers This paper presents new features for more efficiently managing materialized views, Query Rewrite, Transportable Tablespace, and table partitions make the data warehouse an even more powerful, and less resource-intensive, asset.
[October 11, 2006, 0:00]
Manage Large Data Warehouses With SQL Server 2005
White Papers The focus is on the efficient operation of management functions so that the data warehouse will be highly available to service query requests. This paper discusses things to consider when managing a large, high-performance relational data warehouse...
[March 2, 2007, 0:00]
Key Data Warehousing Features in Oracle10g: A Comparative Performance Analysis
White Papers This paper focuses on two key features of Oracle10g, range partitioning and bitmap indexes, and demonstrates how these two features alone provide order-of-magnitude performance benefits for typical load and query operations in a data warehouse.
[October 4, 2005, 3:00]
TechNet Webcast: Setting Up and Deploying SQL Server 2005 Reporting Services for SAP BW (Level 200)
White Papers An updated data provider and a new query designer enable to take advantage of the data in SAP BW (now called NetWeaver Business Intelligence). Microsoft SQL Server 2005 Service Pack 1 (SP1) includes an integrated Reporting Services solution to...
[August 18, 2006, 0:00]
Project REAL: Enterprise Class Hardware Tuning for Microsoft Analysis Services
White Papers This paper describes best practices for hardware optimization for a multi-terabyte SQL Server 2005 data warehouse and cube. It describes hardware testing and tuning exercises conducted with large-scale Analysis Services (MS OLAP) cubes based on a...
[March 1, 2007, 0:00]
TechNet Webcast: SQL Server 2008 (Part 1 of 3): High-Performance Data Warehousing (Level 300)
White Papers The attendee will learn how to incorporate the new features in Microsoft SQL Server 2008 to provide a high-performance data warehouse that can scale to larger number of users and growing volumes of data.
[March 24, 2008, 0:02]
Business Analytics - Six Questions to Ask About Information and Competition
White Papers It should generally be transferred into a data warehouse for easy access. If databases are particularly large, it may be necessary to store them in a "Data Warehouse Appliance" - specialized hardware and software for data access and retrieval.
[September 2, 2009, 1:22]
Advances in Data Warehouse Performance: I/O Elimination in DB2
White Papers Read this paper to learn how to reduce query response time from hours to seconds, support real time data warehousing, optimize your storage, and lower operating costs. WinterCorp analyzes IBM's DB2 Warehouse and how it addresses twin challenges...
[January 22, 2009, 8:03]
Stuart Maue Mitchell & James, Ltd. Improves Customer Service and Reduces Costs With Self-Service Reporting and Query Capabilities
White Papers The company wanted to improve customer service and reduce costs by enabling automated customized-reporting and ad hoc-query capabilities. Stuart Maue deployed Oracle Business Intelligence modules, including Oracle Discoverer and Oracle Warehouse...
[December 7, 2006, 0:00]
Workload Management for DB2 Data Warehouse
White Papers This IBM white paper addresses the workload management issues encountered in a data warehouse environment. It delivers a period aging mechanism where a query travels from one period to another during its execution.
[October 4, 2005, 3:00]
PREMIER Bankcard Gains Control Over a Fast-Growing Database and Deeper Insight Into Customer Trends Using Microsoft Windows-Based HP Technology
White Papers PREMIER Bankcard wanted to handle huge growth in its data warehouse and improve performance of the data mining and reporting so critical to everyday decision making. PREMIER Bankcard optimized and tested the solution to ensure predictable results...
[January 1, 2009, 0:00]
Oracle database event triggering
News The database interface the user is utilising contains embedded event triggers that initiate several downline processes: a warehouse database query is made; the "zero" response reroutes the query to a remote warehouse, and a delivery order is...
[February 26, 2003, 13:55]
EII: A database of databases
News In a business environment, this could mean your call centre agents could submit a single query to the EII platform and get a result that incorporates relational data from a DB2 database, email from Lotus Notes, images from Documentum and...
[February 11, 2004, 14:30]
Business Objects makes business intelligence 'easy'
News Jill Smith, applications manager at NHS Services Scotland, said in a statement that by using XI Release 2, NHS users "will be able to link queries from multiple data sources across the intranet, allowing us to roll out access to our corporate data...
[September 27, 2005, 14:40]
