Analytic data solutions specialist Teradata announced the launch of Intelligent Memory, a database technology that extends memory space beyond cache to help increase query performance and enable organizations to leverage in-memory technologies with big data.
Intelligent Memory is available for any of the current Teradata workload-specific platforms running the Teradata Database. For organizations looking for departmental solutions, Integrated Data Warehouse or Active Data Warehouse, Teradata Intelligent Memory is designed to deliver the performance required to offer the required set of data analytics.
Teradata Intelligent Memory is designed to integrate into the overall Unified Data Architecture strategy, which leverages Teradata, Teradata Aster, and open source Apache Hadoop. Data in Apache Hadoop that is frequently used can be accessed through Teradata SQL-H, and based on temperature of the data, moved to Intelligent Memory to take advantage of its computing capability.
“The introduction of Teradata Intelligent Memory allows our customers to exploit the performance of memory within Teradata Platforms in a new way, and extends our leadership position as the best performing data warehouse technology at the most competitive price,” Scott Gnau, president of Teradata Labs, said in a statement. “Teradata Intelligent Memory technology is built into the data warehouse and customers don’t have to buy a separate appliance.
“Additionally, Teradata enables its customers to configure the exact amount of in-memory capability needed for critical workloads. It can be difficult, expensive, and impractical to keep all data in memory, and Teradata’s unique approach means the right amount of memory can be applied to the right set of data for blinding performance–automatically.”
Intelligent Memory will be available as part of Teradata Database 14.10 for release in the second quarter of 2013. Intelligent Memory uses algorithms that automatically age, track and rank data to ensure effective data management and support for user queries. Access to data in-memory eliminates disk input/output (I/O) bottlenecks and query delays, and increases system throughput access to data in-memory is three orders of magnitude faster than access to hard disk drives, the company said.
Inside Intelligent Memory, data can be stored and compressed in columns and rows, which maximizes the amount of data in the memory space. The platform places only the very hottest data to the new extended memory space, which allows organizations to access the most current data quickly from system memory to satisfy the majority of their queries.The platform extends multi-temperature data management into the memory layer and supplements other multi-temperature features including Virtual Storage, which continuously migrates data to the appropriate level of storage, solid state drive (SSD) and hard disk drive (HDD) technology, based on its to achieve optimum data warehouse performance.
Virtual Storage provides an automated lifecycle management process where “cold,” or the least used data, is migrated to less expensive drives. In addition, when data is identified as cold, the Teradata compress-on-cold feature automatically compresses the data to deliver dramatic space savings. This process is designed to eliminate the frequent compression and decompression of hot data. When user data is highly compressed and it is transferred to the new memory space, Intelligent Memory is able to further maximize the amount of data in the memory space.