Blog: Colin White

« Microsoft Moves into MDM with Acquisition of Stratature | Main | Microsoft Reports Significant Increase in Sales of its SharePoint Portal »

Types of Data Warehouse Appliance

Richard Hackathorn and I have just published our report on data warehouse appliances. You can find it at www.beyeresearch.com. In the report we define four main types of data warehouse appliance.

1. Native data warehouse appliance where the hardware and software is tightly integrated into a single data warehouse solution. The software and hardware are not individually licensed and cannot be separated. Examples of vendors providing native data warehouse appliances include DATAllegro, Netezza, and Teradata.

2. Software data warehouse appliance where commercial or open source relational DBMS software is designed and/or optimized for data warehouse processing. The software supports hardware solutions purchased from one or more third-party vendors. Examples of vendors or vendors providing software data warehouse appliances include Greenplum and Sybase (Sybase IQ).

3. Packaged data warehouse appliance where commercial software and hardware is tuned for data warehousing, is packaged and supplied by a single vendor, and is installed and maintained as a single system. Examples of vendors providing packaged data warehouse appliances include HP (NeoView), IBM (Balanced Warehouse), and Sun/Greenplum (Data Warehouse Appliance).

4. Data management appliance that offloads data intensive operations from a host computer. The offloaded workload may involve operational, specialized analytics, or archival processing. Examples of vendors providing data management appliances include ParAccel and Dataupia.

Share: