Lower costs and improve performance with DB2 10 and InfoSphere Warehouse 10
DB2 for Linux, UNIX and Windows is the database of choice for robust, enterprise-wide solutions handling high-volume workloads. Optimized to deliver industry-leading performance, DB2 adheres to tenets of low operational costs, ease of use and reliability to power today’s data applications--and beyond.
InfoSphere Warehouse is powered by DB2. InfoSphere Warehouse provides additional capabilities like cubing services, text analytics, data mining, and so on that work with DB2 to implement departmental and enterprise data warehouses.
New features that ease development and administration
IBM ® DB2® 10 for Linux, UNIX and Windows and IBM InfoSphere™ Warehouse 10 introduce new features to help improve performance, ease database administration, ease development, and lower your data management costs. These features include:
DB2 10 and InfoSphere Warehouse 10 offer several query performance enhancements and workload management enhancements that make certain workloads run as much as 3.3 times faster than with the previous release.
DB2 10 and InfoSphere Warehouse 10 offer native support for the most popular data types, SQL syntax, PL/SQL syntax, scripting syntax, built-in packages, and concurrency models in Oracle® Database. This makes it easier to move from Oracle Database to DB2. It also makes it easier for people with Oracle skills to work with DB2 and InfoSphere Warehouse. The new releases include several enhancements to these features, increasing the typical out-of-the-box compatibility with PL/SQL code above 98%.
IBM has also enhanced product support for the DB2 pureScale feature, allowing an increased number of advanced features to work with pureScale and making it easier to administer a pureScale environment.
IBM adds adaptive compression techniques to DB2 10 and InfoSphere Warehouse 10, further compressing data and lowering data storage costs. In addition to table-wide compression dictionaries, IBM adds page-level compression dictionaries, and by applying different compression techniques optimizes your storage savings.
Time Travel Query is the name for the native bi-temporal features in DB2 10 and InfoSphere Warehouse 10. Time Travel Query supports both valid time and transaction time. It provides standards-based support for temporal insert, update, and delete operations. Time Travel Query allows you to create historical queries with less effort and reduced costs.
DB2 10 and InfoSphere Warehouse 10 add a parallel ingest utility that supports the continuous ingest of data. The Continuous Ingest feature makes it easier to implement real-time data warehousing and operational analytics in your environment, helping you to support the business by enabling faster and more accurate business decisions.
DB2 10 and InfoSphere Warehouse 10 add NoSQL Graph Store capabilities and the SPARQL query language. The NoSQL Graph Store provides an optimized way to store and work with graph triples inside DB2, or to put it another way, DB2 allows you to store graph triples while also enjoying the benefits of ACID compliance, data compression, parallel execution, load balancing, backup and recovery, advanced security, and so on.
IBM introduces support for multi-temperature data management in DB2 10 and InfoSphere Warehouse 10. Multi-temperature data management allows you to store different portions of your data on different classes of storage.
Frequently accessed data will be classified as “hot”, less frequently accessed data will be classified as “warm”, infrequently access data will be classified as “cold”, archived data will be classified as “dormant”.
You can then allocate these different classes of data to different types of storage devices. Adopting such an approach helps you optimize your data storage environment and improve performance.
DB2 10 and InfoSphere Warehouse 10 also include enhancements to security, workload management, index management, monitoring, high availability, and resiliency features in the product.
"IBM and Intel® have collaborated over a decade to optimize DB2 performance with Intel® Parallel Studio 2011, software development suite on Intel® Xeon® processors. We are excited to see a ~10x improvement in query processing performance using DB2 10 over the previous DB2 version, running on IBM System x3850 using Intel® Xeon® Processor E7. Customers can now realize dramatically greater performance boost at lower cost per query running IBM DB2 10 on servers powered by Intel® Xeon® processors." -- Pauline Nist , GM Software Strategies Intel's Datacenter & Connected Systems Group.
"With IBM and Triton Consulting, we've grown our direct business despite the fact that consumer travel has significantly decreased. With IBM's new software we have also been able to speed our business transactions by 100 percent."
-- Nilan Peiris, Chief Marketing Technology Officer for HolidayExtras.com
Featured Success Story
Coca-Cola Bottling Company Reinvests Cost Savings by Switching to DB2
The largest independent bottler of Coca Cola products in the U.S. has been using DB2 10 to drive increased performance and lower software and hardware costs.