Teradata

Teradata Corporation makes taking your first step toward an enterprise data warehouse an easy one with the Teradata® Data Warehouse Appliance 2580. With this appliance from Teradata, you can start building your data warehouse and grow it as your needs expand.

Delivered ready to run, the Teradata Data Warehouse Appliance is a fully-integrated system that’s purpose-built for data warehousing. The Teradata Data Warehouse Appliance features the industry-leading Teradata Database, a Teradata platform with dual quad core Nahelem Intel® processors, SUSE® Linux operating system, and enterprise-class storage – all preinstalled into a power-efficient unit. That means you can have the system up and running live in just a few hours for rapid time to value. Best of all, the solution is supported by the most trusted name in data warehousing – Teradata. Plus, this new data warehouse appliance was designed to be easy to set up. Your users will be submitting queries after only a few simple steps:

1. Network connect and power up.
2. Log on and create users and databases.
3. Define tables and load data using a Teradata load utility.
4. Go – start submitting business queries.
   

The Teradata Data Warehouse Appliance uses the proven high-performance Teradata Database. Established in hundreds of customer sites around the world, it’s the most robust database for data warehousing. This appliance’s innovative design is optimized for deep-dive analytical analysis. Its software-based, shared nothing architecture delivers always on parallelism so even the toughest, most complex queries complete quickly.

• Automatically designs the fastest query plan.
• Can rewrite problem queries on the fly and optimize SQL from BI tools to take advantage of unique Teradata Database performance advantages.

Primary indexes, multi-level partitioned primary indexes, and aggregate join indexes provide super-fast results and eliminate the need to scan entire tables.

• Straightforward execution with one-time definition.
• No time consuming data or SQL pre-preparation.

Performance groups assigned to one of four settings: Rush, High, Medium, or Low.

• If the system is not fully utilized, CPU is automatically made available to lower priority performance groups.
• Ensures your queries complete in business time.
• Threshold Exception Actions enable long-running queries to be passed to a lower priority level dynamically based on CPU seconds. This will allow more effective query management.
• System Filters and Throttles help manage queries, sessions, and utilities.

The Teradata Data Warehouse Appliance is so easy to manage, you can free up your DBA resources to do other valuable tasks. With virtualized CPU, memory, and storage all designed to work together as a unit, you get automated management of physical disk space so your database administrators never have to worry about data placement or data reorganization.

And the long-term advantages are clear:

• A single database standard for analytics across your organization – you can eliminate disparate data marts and simplify your organization by standardizing on a Teradata system.
• Leverage your existing resources and tools – with Teradata as your standard for all business intelligence platforms, your DBAs, systems administrators, and application developers can support multiple systems without additional training.
• Easily migrate applications into an Enterprise Data Warehouse from Teradata by leveraging the same data, data models, table structures, views, queries, and load programs. Grow into a Teradata Active Enterprise Data Warehouse as your needs evolve.

In addition to hardware and software technology, Teradata offers you a full array of support advantages, including:

• A single vendor for all your support needs; there’s no need for third-party coordination.
• Industry certified regional and global Customer Care Centers.
• Experienced service representatives dedicated to data warehouse support.
• Tested and proven support processes.
• Secure remote connectivity options. 

As the industry leader in data warehousing, Teradata has partnered with other world-class companies to provide you with an array of applications and tools to help you get the most value from your data warehouse. Applications and tools from industry innovators, including Attensity,™ Business Objects,® Cognos,® GoldenGate Software,® Harte-Hanks, ® IBM, ® Informatica, ® Information Builders, KXEN,™ MicroStrategy, ® Microsoft, ® Oracle, ® Protegrity, SAP, ® SAS, ® TIBCO, ® and others, are ready to run on Teradata Database. Since the Teradata Data Warehouse Appliance includes the Teradata Database, you can easily leverage these vendors’ tools and applications without any complex integration work.