Query Languages White Papers

(View All Report Types)
SQL Compatibility in DB2 9.7-- From triggers to object enhancements: A demonstration of the new PL/SQL compatibility features
sponsored by IBM
WHITE PAPER: This article overviews the new PL/SQL compatibility features in IBM DB2 software version 9.7, making it easier to adopt and allowing you to take advantage of its autonomic and high-performance characteristics. 
Posted: 01 Sep 2010 | Published: 01 Sep 2010

IBM

Reduce CPU Usage with 'SMART' SQL
sponsored by BMC Software, Inc.
WHITE PAPER: This paper discusses how and why to design SQL that will reduce the number of times calls are made to DB2. We'll look at how to write SMART applications rather than writing applications that act like generic I/O modules to DB2, properly tune SMART SQL, and how to exploit SQL and application features in DB2 on z/OS version 8 and 9.
Posted: 30 Nov 2009 | Published: 30 Nov 2009

BMC Software, Inc.

Migrate your Legacy IBM Database Environment to the latest Oracle Technologies
sponsored by Oracle Corporation
WHITE PAPER: Even the most effective servers will eventually have to be replaced once they reach the end of their lifecycles. This white paper explores key factors to consider when evaluating new servers for your business and offers exclusive advice for executing a seamless Linux migration.
Posted: 27 Jun 2012 | Published: 25 Jun 2012

Oracle Corporation

Improving Data Center Performance through Virtualization of SQL Server Databases
sponsored by Dell, Inc. and Intel®
WHITE PAPER: Small and medium businesses need to support growth while wringing every ounce of value out of the investments they’ve already made. This paper looks at the benefits of virtualizing SQL Server databases, as well as how to get the most out of your virtual infrastructure.
Posted: 16 Nov 2010 | Published: 16 Nov 2010

Dell, Inc. and Intel®

Total Economic Impact of Oracle Enterprise Manager Database Management Packs
sponsored by Oracle Corporation
WHITE PAPER: This study highlights the benefits and costs of deploying the Oracle Enterprise Manager Diagnostic Pack and Tuning Pack across the enterprise of a sample organization. The study examines the estimated ROI for the sample organization and presents aggregate findings derived from the interview and analysis process and Forrester's independent research.
Posted: 18 Mar 2009 | Published: 18 Feb 2008

Oracle Corporation

Exclusive Comparison of Server Performance and Power Consumption
sponsored by Dell, Inc. and Intel®
WHITE PAPER: Choosing the right hardware for your virtual environment can be a painstaking process, especially since it is difficult to predict how a platform will perform once it is deployed. This white paper examines one hardware configuration and measures the number of orders per minute and virtual machines it can support.
Posted: 07 Jun 2012 | Published: 01 May 2012

Dell, Inc. and Intel®

Apache Hadoop* Framework Spotlight: Apache Hive*
sponsored by Intel
WHITE PAPER: This brief resource examines the true value of Apache Hive, a SQL engine for the Apache Hadoop framework. Inside, learn how Hive's facilities for data and metadata management are impacting the existing warehouse infrastructure and driving business success.
Posted: 29 May 2013 | Published: 31 Mar 2013

Intel

Sybase IQ "Quick Start Guide"
sponsored by Sybase, an SAP company
WHITE PAPER: Read this white paper to learn the advantages of column-based databases, and see if it's right for your organization. Some of the key findings include how column-based databases perform faster and require less maintenance, while also performing better with analytic applications.
Posted: 09 Aug 2012 | Published: 09 Aug 2012

Sybase, an SAP company

How the Right Infrastructure Delivers Real SQL Database Virtualization Benefits
sponsored by Dell, Microsoft and AMD
WHITE PAPER: Consolidating and/or virtualizing SQL Server databases can improve data center efficiency and enable you to tackle database sprawl, achieve high availability, and boost agility. Beginning with the value 4 processor (4P) capabilities of the AMD Opteron™ 6000 Series platform, the AMD/Dell/Microsoft combination can help produce substantial savings.
Posted: 06 Jul 2010 | Published: 06 Jul 2010

Dell, Microsoft and AMD

eGuide: SQL Server Consolidation - An IT Manager's Guide
sponsored by Hewlett Packard Enterprise
WHITE PAPER: This E-Guide offers a step-by-step guide for consolidating SQL Servers, also provides insight on why SQL Server consolidation is an optimization technique.
Posted: 20 Nov 2008 | Published: 20 Nov 2008

Hewlett Packard Enterprise