Query Tools White Papers

WHITE PAPER: This white paper highlights how organizations can leverage big data to solve business challenges. It focuses on query-able data warehouses as a way to reduce costs and gain business insights. Discover how you can free up your data warehouse from processes slowing it down and disrupting revenue goals.

Posted: 06 May 2014 | Published: 31 Dec 2013

WHITE PAPER: Discover the new features and benefits of IBM DB2 Analytics Accelerator for z/OS version 4.1.

Posted: 24 Mar 2014 | Published: 31 Oct 2013

WHITE PAPER: This white paper offers up a comprehensive comparison of the Oracle Exadata and IBM Netezza data warehouse appliance, helping you decide which is the better fit for your business. Read this now and learn how they stack up in terms of online transaction processing (OLTP), query performance, simplicity of operation, value and more.

Posted: 30 May 2012 | Published: 18 Jan 2012

WHITE PAPER: Data warehouse appliances have transformed the DW with a platform designed to deliver optimal price and performance with extreme simplicity. This paper outlines the IBM Netezza data warehouse appliance and how it offers extreme time to value, agility and ability to grow with new workloads, cost reduction of ongoing maintenance and more.

Posted: 05 Apr 2012 | Published: 14 Dec 2011

WHITE PAPER: Read this white paper and learn about the intelligent software in the Oracle Exadata Storage Server that accelerates database query processing (DQP) by offloading database query processing to the storage layer.

Posted: 12 Dec 2011 | Published: 12 Dec 2011

WHITE PAPER: Technical white paper covering the impact of XML on data warehousing and how to deliver new levels of business analysis and bring users closer to their data.

Posted: 17 Mar 2011 | Published: 17 Mar 2011

WHITE PAPER: Access this white paper to learn the benefits of advanced data mining, including a greater return on investment. It offers practical guidance for incorporating additional data types and sources, expanding the scope of data mining projects and deploying results more effectively throughout your organization.

Posted: 22 Feb 2011 | Published: 22 Feb 2011

WHITE PAPER: This paper, intended for both IT and operational management, explores a series of high-level best practices for analytics and data warehousing based on Sybase’s experience with successful implementations. Suggestions are provided in three categories: performance, cost control, and ease-of-deployment with each dimension broken down into sub-topics.

Posted: 28 Oct 2010 | Published: 28 Oct 2010

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: 22 Oct 2010 | Published: 23 Sep 2009

WHITE PAPER: NoetixViews transforms the complexity of the Oracle E-Business Suite database into recognizable business views of data that are used to create operational reports and ad hoc queries. NoetixViews enables faster, easier and more cost-effective access to information stored in the Oracle E-Business Suite data structure. Read this paper to learn more.

Posted: 04 Aug 2010 | Published: 04 Aug 2010

WHITE PAPER: Column-based databases can be slow deleting and updating data. Vertica’s Analytic Database is designed specifically for storing and querying large datasets. Vertica’s differentiator is that it combines a columnar database engine with MPP and shared-nothing architecture, aggressive data-compression rates, and high availability.

Posted: 16 Jul 2010 | Published: 16 Jul 2010

WHITE PAPER: Learn how Pink OTC Market Inc., the third largest U.S. equity trading marketing place,  built a highly available and reliable (no downtime in a year of production use) data warehouse using Vertica's Analytic DBMS that cost-effectively stores billions of records and scales easily by simply adding CPUs without incurring additional licensing fees.

Posted: 16 Jul 2010 | Published: 16 Jul 2010

WHITE PAPER: In the following paper, we briefly describe, and illustrate from examples, what we believe are the “Top 10” mistakes of data mining, in terms of frequency and seriousness. Most are basic, though a few are subtle. All have, when undetected, left analysts worse off than if they’d never looked at their data.

Posted: 07 Apr 2010 | Published: 07 Apr 2010

WHITE PAPER: This white paper focuses on the use of a log-based, real-time change data capture (CDC) solution to enable real-time reporting using a low overhead solution that minimizes the impact on IT infrastructure.

Posted: 02 Feb 2010 | Published: 04 Jan 2010

WHITE PAPER: With over 60% of CEOs saying they need to do a better job of capturing and understanding information to make more effective and timely business decisions, it's clear that there's a gap between capability and need. It's similarly fair to say that this shortfall is a leading reason why businesses aren’t as competitive as they’d like to be.

Posted: 08 Oct 2009 | Published: 08 Jul 2009

WHITE PAPER: The reasons driving standardization in BI and reporting are core to every company—cutting costs, boosting revenue, and increasing profits. IBM Cognos 8 BI lets business users move among capabilities in a guided way, get the answers they seek, and collaborate while giving IT complete control over the BI environment.

Posted: 05 Oct 2009 | Published: 05 Jan 2009

WHITE PAPER: Reporting is recognized as a way for companies to improve service, ensure quality, control costs, and prevent losses by empowering decision-makers throughout the organization. This paper will explain why reporting is one form of business intelligence that has become business-critical.

Posted: 31 Aug 2009 | Published: 01 Aug 2009

WHITE PAPER: In large networks, the sheer number of permission settings makes it almost impossible to gain a clear overview of overall security, and checking that all those permission are in compliance with corporate and regulatory standards is a Herculean task.

Posted: 27 Aug 2009 | Published: 27 Aug 2009

WHITE PAPER: With more and more sensitive data moving from file servers to SharePoint sites, it's important to keep a close eye on what users can access documents, what users have permissions to change the SharePoint sites, and what documents are getting modified.

Posted: 27 Aug 2009 | Published: 01 Dec 2008

WHITE PAPER: Visual analytics is the process of analytical reasoning facilitated by interactive visual interfaces. Its becoming the fastest way for people to explore and understand Business Intelligence data of any size. This paper will introduce you to the seven essential elements of true visual analytics applications.

Posted: 20 Apr 2009 | Published: 20 Apr 2009

WHITE PAPER: Find out how Embarcadero's DB Optimizer™ can help you to quickly discover and fix problematic SQL statements that can cause performance bottlenecks in your database. DB Optimizer™ gives you the flexibility of using a single easy-to-use IDE to test, profile and tune SQL.

Posted: 16 Apr 2009 | Published: 16 Apr 2009

WHITE PAPER: The Oracle Developer Tools for Visual Studio is a free product that is available for download today from the Oracle Technology Network.

Posted: 19 Jan 2009 | Published: 19 Jan 2009

WHITE PAPER: Learn how DB2 can help you meet the demands of business intelligence by reducing query response time from hours to seconds, supporting real time data warehousing, and optimizing your storage while lowering operating costs.

Posted: 28 Nov 2007 | Published: 01 May 2007

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