Our highly experienced consulting associates are the industry leaders in Datallegro DW Appliance. Additionally, we have a vast retail knowledge to implement Datallegro DW Appliance projects in a cost-effective and timely manner to meet the business needs.

Exiom Offers Consulting services in Datallegro DW Appliance

Overview of DATAllegro

DATAllegro’s data warehouse appliances are based on commodity hardware components (Intel motherboards & CPU, Western Digital disk drives, Infiniband) and open source software (Linux, Ingres r3).  DATAllegro has also developed several technologies that, together with DATAllegro’s combination of hardware and software, enable the company to offer industry leading high performance and low cost.  These technologies, some of which are patent pending, include RAIDW™, Ultra Shared Nothing™ (USN) and Direct Data Streaming™ (DDS).

RAIDW™

The use of traditional (typically SAN-based) storage solutions in data warehouse environments slows the speeds at which data can be queried, and reduces the amount of disk space available for user data.  DATAllegro’s patent-pending RAIDW™ technology maximizes data I/O speeds, while also providing built-in fault tolerance for all components, not just the disks.

Direct Data Streaming™ (DDS)
Most traditional data warehouse technologies end up with random I/O at the disk level. This is due to the extensive use of indexes, complex SAN disk infrastructures and the need to support multiple hardware platforms and operating systems. DATAllegro’s Direct Data Streaming™ technology enables most of your queries to access data using sequential disk I/O without tuning.

Ultra-Shared Nothing™ (USN) Parallel Database
DATAllegro’s USN™ parallel database design maximizes the use of co-located joins across all nodes.  The result is reduced network traffic which means even faster query speeds for all query types. Multi-level partitioning minimizes the amount of data read for each query to improve performance even further. Finally, indexes can be used to give outstanding performance on queries that only require a few rows of data.

DATAllegro's World Class Products Include:

DATAllegro P2™

A high performance data warehouse appliance with a two terabyte data capacity and ultra fast query speeds. Priced at $250,000, DATAllegro P2 is ideal for data marts or data warehouses with high performance requirements

DATAllegro P5™

A high performance data warehouse appliance that sets a new standard in price and performance. DATAllegro’s built-in failover, optional indexing, non-proprietary hardware and 5 terabytes of data capacity make it the premier data warehouse appliance for a broad range of purposes. DATAllegro P5 is priced at $450,000 and offers table scanning at one terabyte per minute.

DATAllegro P5e™

DATAllegro P5e combines DATAllegro's high performance P5 appliance with encryption technology to provide a secure, high performance data warehouse.

DATAllegro C25™

A high capacity data warehouse appliance that allows you to store and access large volumes of data at an affordable price. Whether you are tasked with meeting compliance requirements or have other business needs that include accessing historical data, DATAllegro C25 is an affordable option to archiving data on tape or nearline. Priced at less than $20,000 per terabyte, DATAllegro C25 can hold up to 25 terabytes of user data and includes built-in failover. For larger systems multiple appliances can be linked together.

DATAllegro C25e™

DATAllegro C25e combines DATAllegro's high capacity C25 appliance with encryption technology to provide a secure, high capacity data warehouse.

DATAllegro IQR™

Hides the complexity of a sophisticated data warehouse by intelligently routing queries to the appropriate DATAllegro appliance for optimal performance and throughput. DATAllegro IQR supports multi-tier data warehousing as well as disaster recovery, and can be purchased as an add-on product to both DATAllegro 'P' series and DATAllegro 'C' series appliances.

DATAllegro Encryption Technology™

DATAllegro P2e™, DATAllegro P5e™ and DATAllegro C25e™ allow the encryption of “at rest” data to protect companies from data theft and help meet compliance and legislative requirements.

DATAllegro DW Appliance Differentiator

• Easy Administration that requires less resources for maintenance and reduces TCO
• Reliability due to single, preconfigurated, architecturally integrated product with disk arrays, operating system and database software from one single vendor
• 0-50 times performance improvement for $150,000 per terabyte
• Cost of Appliance is less than 500K
• Table scanning at 1 TB per minute
• Seamlessly integrates with an existing Oracle DW
• Alliance with Industry best experts from Exiom that have  successfully migrated  DW and implemented Appliance solution
• Parallel Architecture has enhanced speed for selective query
• Benchmark your own data on DW appliance at our secure site
• Fully SQL-92 Compatible

Integration with BI tools

• Business Objects
• Cognos
• MicroStrategy
• Hyperion

Advantages of  DW Appliance over Traditional DW

The Value Proposition

• Complete packaged solution (SW + HW + Disk)
• Patent-pending SW on commodity HW
• Affordable upgrade alternative for existing 1- 5TB Oracle DW
• Seamless integration (bolt-on)
• Very low TCO
• 10-50x price/performance
• Built-in failover for high availability
• Fast loading with optional indexing

 

Datawarehousing

CRM