Standardized Query Languages White Papers

(View All Report Types)
RedBook: Oracle to DB2 Conversion Guide - Compatibility Made Easy
sponsored by IBM
WHITE PAPER: New IBM DB2 features make compatibility easy. In this guide, you’ll learn about native support for PL/SQL, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQL*Plus, data movement tools, best practices and more—all designed to improve your ability to run applications on both DB2 and Oracle platforms
Posted: 01 Sep 2010 | Published: 01 Sep 2010

IBM

BI is in the Details: How Columnar Technology Leverages the Latent Value in SQL Databases
sponsored by Vertica Systems
WHITE PAPER: This paper will discuss how Vertica enhances the capabilities of analytical work through the implementation of different architecture for relational database-based analytical work. By simply rotating the orientation of the database from rows to columns, dramatic improvements in load and query speed, scalability and cost effectiveness are achieved.
Posted: 29 Aug 2011 | Published: 01 Sep 2009

Vertica Systems

Benefits and Best Practices For Deploying SSDS In An OLTP Environment Using Dell Equallogic PS Series
sponsored by DellEMC and Intel®
WHITE PAPER: Using Solid State Disks (SSDs) in enterprise storage arrays is one of today's hottest storage trends. This whitepaper discusses the best practices for deploying SSDs in an OLTP environment using Dell EqualLogic PS Series arrays.
Posted: 05 May 2009 | Published: 05 May 2009

DellEMC 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

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.

Oracle Database 11g: Real Application Testing & Manageability Overview
sponsored by Oracle Corporation
WHITE PAPER: Read this white paper to learn how the new Real Application Testing capabilities in the Oracle Database 11g allows database administrators to adapt to changes easily, lower their testing costs and reduce hardware and software investments.
Posted: 14 Oct 2008 | Published: 14 Oct 2008

Oracle Corporation

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

Comprehensive Data Warehousing & BI Solution with Oracle Database 11g
sponsored by Oracle Corporation
WHITE PAPER: This white-paper provides an overview of Oracle Database 11g's capabilities for data warehousing, and discuses its key features and technologies. Discover how to integrate information, perform fast queries, scale to very large data volumes, and more.
Posted: 15 Oct 2007 | Published: 01 Oct 2007

Oracle Corporation

OMEGAMON Extended Insight- Analysis: Where is your application spending time?
sponsored by IBM
WHITE PAPER: The limited amount of infomation provided by traditional DB2 for z/OS monitoring makes it difficult and time-consuming to isolate problems within the multiple layers of today's Java, CLI (SAP), and .NET applications. Read this paper to discover a monitoring alternative that provides the detailed information needed for modern applications.
Posted: 14 Feb 2012 | Published: 31 Dec 2011

IBM

Best Practices for Decision Support Systems with Microsoft SQL Server 2012 using Dell EqualLogic PS Series Storage Arrays
sponsored by Dell and VMware
WHITE PAPER: This white paper describes sizing and best practices for deploying a data warehouse in order to prevent bottlenecks and deliver a cost-effective solution.
Posted: 29 Aug 2013 | Published: 31 Jul 2013

Dell and VMware