Overview
ONE SIZE DOES NOT FIT ALL
DATAllegro v3 MRA products provide high performance and the ability to scale out your data warehouse from 15 terabytes to one petabyte without forklift upgrades. Multiple data racks combine with a single control rack to scale out data capacity as needed. Data racks come in either a 15-30 terabyte capacity (MRA1530) or a 25-50 terabyte capacity (MRA2550). Each rack is priced based on the smallest capacity with the option of adding capacity as it is needed up to the maximum. In addition, data racks can be upgraded to include DATAllegro's new grid-enabled technology to allow companies to leverage a hub-and-spoke or multi-temperature architecture, as well as disaster recovery.
EMC®, DELL™ AND CISCO®—POWERFUL PARTNERS PROVIDE ENTERPRISE-CLASS RELIABILITY
A data warehouse appliance is an integrated set of data storage, database, compute servers and O/S, each of which is pre-configured and pre-tuned for the rigors of data warehousing. DATAllegro v3 is a second-generation appliance that uses leading, standards-based technologies along with DATAllegro's patent-pending software to provide enterprise-class reliability. EMC storage devices, standard Dell servers and Cisco InfiniBand interconnect combine together in DATAllegro's RAIDW™ (Redundant Array of Inexpensive Data Warehouses) architecture. With enterprise-class reliability and no single point of failure, DATAllegro v3 provides an architecture for high availability from SQL to storage.
FASTER QUERY TIMES THAN EVER BEFORE WITHIN YOUR ENVIRONMENT
DATAllegro v3 delivers significantly faster query times than traditional data warehouse technologies. With minimal tuning and optimization, your business will benefit from a 10x-100x improvement in query speeds. DATAllegro v3 provides the right blend of administration simplicity and the ability to support and optimize performance for complex mixed workloads. DATAllegro v3 adjusts to data growth, user concurrency and workload changes. With support for all types of ad-hoc queries, operational reports and high-speed concurrent loads, DATAllegro v3 provides a solution that solves critical business problems.
MAXIMIZE THE POWER OF YOUR HARDWARE
With DATAllegro RAIDW servers or nodes execute queries in parallel independently of each other. A patented parallel database design called Ultra Shared Nothing (USN)™ distributes data across all nodes in the appliance. USN limits data movement and ensures queries are resolved locally on each node for high performance. Multi-level partitioning further reduces the amount of data scanned during query processing. As a result, DATAllegro v3 can scan data at up to 10.5TB/minute.
PROCESS DATA AT QUAD CORE SPEED
DATAllegro's Direct Data Streaming™ technology streams data from EMC storage devices and processes the data using Intel® Xeon® Quad-Core processors. Each core in the processor reads data in parallel. The architecture allows DATAllegro to ride the multi-core processor wave for continual performance improvements.
LOAD DATA WHILE PERFORMING COMPLEX QUERIES
Automated workload management and system resource balancing enable you to load data at the same time that multiple users perform a range of query types—all without sacrificing performance. As your business grows, DATAllegro v3 provides options to support more users performing different types of queries.
REDUCE ADMINISTRATION COSTS
DATAllegro appliances are easy to install, deploy and maintain. Automated storage management replaces complex space allocation. Diagnostics detect and broadcast hardware issues. A management console provides a simple GUI interface and dashboard for tracking and resolving issues. Ultra-fast loading and high-speed backups reduce administration for even the largest data warehouses. DATAllegro supplies and supports all parts of the appliance, providing a single source for upgrades. Reduce your total cost of ownership by reducing administration complexity.
INCREASE OPPORTUNITIES TO RESPOND TO BUSINESS CHANGES AND CHALLENGES
DATAllegro is architected for change. Open and best-of-breed devices allow the appliance to improve as technology advances. Automated workload management allows changes in user concurrency and workloads. The MRA product line provides simple and cost-effective capacity expansion. Cost and complexity no longer cause business opportunities to be missed.
PROVEN SUCCESS
Telecommunication: Large telecommunication companies are using DATAllegro v3 for call data record (CDR) mediation as well as performing complex queries over large data volumes.
Retail: Companies with retail customer information are using DATAllegro v3 for fine-grained analytical reporting.
Analytics: Analytics companies use DATAllegro to make informed, fact-based decisions across all sectors with near real-time data.
Financial: Banking and financial companies and scoring engines use DATAllegro v3 for high-speed transformation and aggregation.
Key Features & Benefits
| Improve performance and add capacity without forklift upgrades by adding additional data racks |
| Add capacity as needed within a data rack for $15k /TB |
| Provides enterprise-class reliability, high availability and keeps pace with advances in technology |
| Lowers the total cost of ownership, while providing sophisticated and mature DBMS features |
| Provides 10x-100x performance gains over existing solutions for data warehouse queries |
| DATAllegro appliances make overall data warehouse administration easy while having the flexibility to respond to capacity and performance-tuning requirements |
| Enables enterprise reporting, OLAP and ad-hoc queries with concurrent data loading |
| Deliver data when needed with support for near real-time loads (up to 1TB per hour) |
| Supports high user concurrency and complex workloads |
| Fast installation and simple maintenance lowers TCO and shortens time to value |
| SNMP alerts notify operators of any failure and can be configured to match business requirements |
| A simple GUI interface and dashboard enables administrators to manage appliance usage, diagnose and resolve system issues and monitor queries |
| Storage devices provide mirroring and hot-swappable drives; remove and replace components with no downtime; spare compute servers ensure queries continue to execute in the event of a hardware failure |
| Open standard access for BI, ETL and other tools |
| Supports normalized and de-normalized data models, star and snowflake schemas |
| Optional indexing provides even faster data access for single-row lookups against very large tables |
| DATAllegro MRA-B allows you to back up or restore terabytes of data at several terabytes per hour |
HOW CUSTOMERS ARE USING DATALLEGRO APPLIANCES
- As a low cost solution for high-performance enterprise data warehousing or data marts
- As a high-performance component of a grid-enabled data warehouse
- To offload applications from the enterprise data warehouse for high-speed aggregation and queries
- To provide long-term data storage in multi-tier data warehouses or extend data warehouse capacity affordably
- As a subject-oriented data mart or sandbox for new analytic applications
- For data mart consolidation
- As an enabling platform to improve the query performance of Business Objects™, MicroStrategy® and other BI tools
Product Spec
CONTROL RACK:
- Control Servers: Dell 2950 Servers, 2 Intel® Quad-Core CPUs
- DBMS: Ingres
- OS: 64bit Linux
- Control Storage: Dell MD1000
- Rack: Standard 42 Unit including switches and networking for InfiniBand, Fibre Channel and GigE
|
DATA RACKS:
- Data Servers: Dell 2950 Servers, 2 Intel® Quad-Core CPUs
- DBMS: Ingres
- OS: 64bit Linux
- Compute Node Work Storage: 6 SAS drives—696GB capacity per node
- Data Storage: EMC 3x Clariion Series
- Spares Included for both data servers and data storage
- Rack: Standard 42 Unit including switches and networking for InfiniBand, Fibre Channel and GigE
|
