Product and service reviews are conducted independently by our editorial team, but we sometimes make money when you click on links. Learn more.
 

Data Warehouse: Exadata (Oracle) vs. TwinFin (Netezza/IBM)

Data Warehouse: Exadata (Oracle) vs. TwinFin (Netezza/IBM)
By

Last time I wrote about Data Warehousing and the dilemma of what companies need to think about to transform the organization once a Business Intelligence/Data Warehousing system has been implemented (see Business Intelligence Transforms Your Organization). Now  I want to start a discussion about Data Warehousing’s extreme performance capabilities, specifically in the area of minimizing movement while processing at high speeds.

First, the amount of data IT pros must deal with has grown considerably over the last few years. According to IDG, humans created 150 exabytes of data in 2005, and the number grew eight times to 1,200 exabytes by 2010. The amount of data generated grew by a phenomenal 60% per year (90% if the data is unstructured).

Second, when advanced analytics first started, the focus was on short transactions writing to a data set.  As Data Warehousing evolved, however, the focus turned to heavy database read operations with sizable sets of data. 

So, as companies start to use the Data Warehouse as a central repository where all of their data is stored—as well as a point in time for historical data—the amount of information contained in the system increases exponentially. This means the volume of enterprise data is exploding.  As a result, enterprises must address new methods for ensuring that system performance and throughput is optimized.

Big challenges include the ability to process complex queries in a short amount of time, as well as query and analyze terabytes and petabytes of data. For this reason, I want to spend time comparing Oracle’s Exadata and IBM’s Netezza TwinFin Data Warehousing products. Both are outstanding solutions to these difficulties.

Laura PaolettiLaura PaolettiLaura Paoletti holds a Bachelor of Science Degree in Computer Information Systems and has been the Vice President of Information Technology at NBC-Universal and Disney ABC Television.  She has also held positions at Ernst & Young LLP in the Technology practice.  In her role she has been responsible for Applications, Infrastructure and Digital Media.  Some of her notable accomplishments include the implementation of applications for Digital Media, Marketing, Finance, Manufacturing (supply chain), Sales and Consumer Products; Implementation of Enterprise Data Warehousing/Business Intelligence systems; Data Center management, including hardware, storage strategies, digital libraries and data center expansion; Implementation of a Project Management office; and Business transformation from a tape to a tapeless environment (digital media).