To allow more users to benefit from WX2’s incredible in-memory performance, a number of new performance and management features have been added to assist with the process of moving data between disk and memory. These features make WX2 a much more dynamic environment where users can manage their memory (RAM) usage themselves.
Improved disk scanning
WX2 version 7.2 includes a new “disk train” mechanism which combines IO requests for multiple table scans, thereby reducing unnecessary disk head movements, and an automatically built and maintained “Compressed Disk Mapping” (CDM) functionality. As a result, access speeds for disk-based data have been dramatically improved. In turn, this improves query speeds for disk-based data but also allows data to be moved into and out of RAM more quickly.
Inmproved data loading
While WX2 has always excelled at data loading, version 7.2 contains contains a completely new, very high speed bulk loader. Besides dramatically increasing load speeds, the new loader allows complex file conversions to take place within the database platform.
Version 7.2 now supports data compression on disk, allowing users to load and analyze more data, more quickly.
Support for Multi-Dimensional Expressions (MDX)
As well as SQL, the new version includes support for MDX. MDX is the language used by applications that expect to access data in a pre-aggregated OLAP cube. This feature allows OLAP applications to access relational data held in WX2 directly. In effect the data appears as a “virtual cube”.
With Version 7.2 WX2 is now easier to administer than before. The new version supports a number of new features to assist with memory management, including a completely new management user interface (UI). Additional platform performance statistics have been provided to assist with overall system management.
More support for the Cloud
WX2 version 7.2 is suited for deployment in the Kognitio Cloud, where users pay only for the analytics that they want to conduct via a monthly subscription model.
Version 7.2 is available immediately and pricing is available on demand.
Kognitio is a long-standing innovator in the data warehousing, business intelligence and analytics markets. The company has pioneered many of the technologies now employed by state-of-the-art data warehouse/BI systems including the industry’s first in-memory analytic database, data warehouse appliance, MPP shared-nothing database, and Data Warehousing as a Service (DaaS) cloud-based solution. Kognitio’s award-winning WX2 product is the industry’s fastest and most scalable analytic database, enabling firms to turn massive amounts of raw, complex data into valuable insight to solve their most urgent business problems. Its clients span many industries including market research, consumer packaged goods, retail, telecommunications, financial services, insurance, gaming, media and utilities. Kognitio is headquartered in Chicago and Bracknell, UK with offices in New York, Raleigh, Minneapolis and other U.S. cities. More information is available at http://www.kognitio.com, on Twitter at @kognitio and on Facebook at http://www.facebook.com/kognitio
For more information:
For the original version on PRWeb visit: http://www.prweb.com/releases/prweb2011/10/prweb8877419.htm