Enhancements in IBMDB210 provide high performance, low cost, and unexpected

By significantly accelerating queries and enhancing data compression, You can significantly reduce storage costs and create time-aware tables within one hour. This is all possible in the latest version of IBMDB2. Together with many other improvements, the above improvements make IBMDB210 and InfoSphereWarehouse10 a more powerful, more economical, and more reliable transaction processing and

With significantly accelerated queries and enhanced data compression, You can significantly reduce storage costs by creating time-aware tables within one hour, which is all possible in the latest IBM DB2 version. These improvements, together with many others, make IBM DB2 10 and InfoSphere Warehouse 10 a more powerful, cost-effective, and reliable transaction processing and

With significantly accelerated queries and enhanced data compression, You can significantly reduce storage costs by creating time-aware tables within one hour, which is all possible in the latest IBM DB2 version. These improvements, together with many others, make IBM DB2 10 and InfoSphere Warehouse 10 a more powerful, cost-effective, and reliable transaction and data Warehouse environment, early users of the new version can confirm this.

Optimized to accelerate query response

The new internal optimization provides high-speed query performance, which directly translates into cost savings and enhances the ability to fulfill business commitments. IBM has made numerous internal Optimizations to common query, connection, and aggregation types. IBM engineers also optimized index access and accelerated data retrieval. The buffer usage optimization improves by 75% to 85%, significantly improving the overall performance and reducing the required CPU cycle.

In addition to the above optimization, the new row and column access control features also provide enhanced security, while greatly reducing the need to separate data using custom methods, further improving performance. With the enhancements built in the latest version, DB2 provides outstanding performance improvements that go beyond the old version in an out-of-the-box manner.

"Using Intel-based®Xeon®When DB2 10 in the E7 processor's IBM System x3850, query processing performance is improved by ten times over the previous version, which makes us feel excited, "said Paul ine Nist, general manager of software strategy for Intel data centers and interconnected systems. "Customers can now run IBM DB2 10 on Intel Xeon processors, significantly improving performance at a lower query cost ."

Adaptive compression helps you control data

Compressed Storage is another feature of DB2 10. The new adaptive compression feature helps the IT Department manage the rapidly growing data storage needs, thus saving money. Data often contains duplicate information, such as the same city, date, or department ID. The IT department no longer needs to store the same value repeatedly. The compression function allows the IT department to store these values in a separate location (I .e. a dictionary) and reference these values with shorter symbols.

IBM DB2 has always used a table-level compressed dictionary, which usually achieves a higher compression rate. However, maintaining a large data dictionary requires the Administrator to spend a lot of time and costs. In DB2 10, IBM not only applies table-level compression, but also performs page-level compression, which significantly surpasses the compression improvements of earlier versions. In addition, the page-level dictionary has an adaptive nature, so the page-level method eliminates time-consuming updates and maintenance issues.

Better compression means that data occupies less space than before, and thus helps reduce storage requirements. Coca-Cola Bottling Company tested DB2 10 beta using the Company's SAP application. The Administrator was very satisfied with the results. The company migrated from its initial Oracle Database to DB2, achieving 40% storage savings. The subsequent upgrade to DB2 9.7 brought about 17% savings. "Now, with the adaptive compression feature of DB2 10, we have achieved another 20% savings and reduced the average database compression to 77%, which is a considerable storage savings, "said Andrew Juarez, the SAP Director/DBA of Coca-Cola.

New features allow queries at any time point

The new Time Travel Query feature is like a DB2 customer's Time machine. Its unique features make IBM stand out from competitors. DB2 users can now define the time period for data validity, or traverse the time to process historical data versions. "We are very satisfied with the new Time Travel Query feature, which enables us to save a lot of Time in future projects," said Jingjie Li of China LanceInfo Business Intelligence Department.

Many organizations need to manage the business time dimension. For example, the reservation system must ensure that two customers have booked the same hotel room or plane seats during the overlapping period. Similarly, banks must ensure that only one interest rate is valid for a loan at any time point.

DB2 10 enables enterprises to meet these requirements and provides comprehensive functionality that supports inserting, modifying, and querying past, present, and future effective dates, these dates are managed as business time periods. The Platform also provides optional time constraints, which helps prevent overlapping hotel reservations.

In the past, organizations have always met time data management needs through self-developed and manual coding solutions. However, time-aware processing logic is often extremely complex. Manual coding is costly for application development and performance is often lower than expected. With the emergence of DB2 10, organizations can leave independent development methods behind.

Compared with self-developed implementations, complex time data conversion using simple SQL statements can greatly reduce coding requirements. Ajith Nayak of India's Tata Consultancy Services believes: "The Time Travel Query feature of DB2 10 significantly simplifies application code, it helped us save at least 25% to 30% of the workload in the field of aviation-related applications."

NoSQL in DB2 can combine the strengths of both.

NoSQL Technology in DB2 allows organizations to quickly and easily deploy new applications. In the process of exploring NoSQL, enterprises often fall into a dilemma. Open-source NoSQL data management systems provide the agility to implement application changes quickly. However, relational data storage such as IBM DB2 provides important advantages that many organizations want to retain.

With IBM DB2 10, organizations can take advantage of both relational data and NoSQL technologies. Organizations can benefit from NoSQL's convenient database design and rapid development, and retain DB2's performance, security, reliability, and recovery functions, it also fully complies with atomicity, consistency, isolation, and durability (ACID ).

IBM DB2 10 enables users to adopt a new programming model that combines the graphic storage example with the data triple. IBM has added this additional feature to DB2 to address all the necessary optimizations and ensure a smooth experience for DB2 users. IBM is developing other types of NoSQL data storage and plans to work with DB2 in the future. However, the graphic storage technology has been released first. It is also the most flexible and useful NoSQL method.

IBM's own Rational Software Group is one of the first organizations to adopt the new graphic storage feature. In fact, when the IBM Rational team evaluated DB2's graphical storage and compared it to the leading open-source NoSQL solution, they found that DB2's performance was 3.5 times higher than these solutions.

The new version helps solve today's Data Challenges

DB2 10 also provides many other advantages. This includes multi-temperature band data management, allowing organizations to store different parts of their data in different storage layers. For example, an organization can store frequently accessed data in the hot storage of a storage device that is faster in use, store less frequently accessed data in a cold storage with a low storage device speed. In the end, the performance will be improved, and the ability to meet the service level agreement will also be enhanced, and the cost will be reduced because the Organization can extend its storage service life.

In addition, the new Continuous Ingest feature allows organizations to continuously and quickly import data into a data warehouse (even if they are running a query on the Data Warehouse) to implement real-time data warehouse and operation analysis.

With these advantages, DB2 continues to lead in the field of data management in the future. As Ivo Grodtke, manager of IBM Business Partner LIS. TEC GmbH, said: "IBM DB2 10 solves many of today's most important data warehouse challenges ."