Teradata Solution Technical Overview

The Teradata solution is a powerful tool that can be used to help analysts and decision makers get the answers they need quickly and accurately.
Email Print Download

 Average 5 out of 5

Teradata Pioneered Data Warehousing

Since our first shipment of the Teradata® Database, we’ve gained more than 30 years of experience building and supporting data warehouses worldwide. Today, Teradata solutions outperform other vendors’ data warehouse solutions, from small to very large production warehouses with petabytes of data. With a family of purpose-built platforms, all running the Teradata Database, that lead spans needs from specialized analytical applications to the most general enterprise data management.

Teradata Corporation offers a powerful, complete solution that combines parallel database technology and scalable hardware with the world’s most experienced data warehousing consultants, along with the best tools and applications available in the industry today.

Making Smarter, Faster Decisions

Most companies have large volumes of detailed operational data, but key business analysts and decision makers still can’t get the answers they need to react quickly enough to changing conditions. Why? Because the data are spread across many departments in the organization or are locked in a sluggish technology environment. Today, Teradata solutions are helping companies like yours consolidate those data to present a single view of your business. You can make smarter decisions faster and less expensively, and get answers to questions that previously went unanswered.

Real, Measurable Data Warehouse ROI

In today’s economy, companies are striving to maximize the return on their information technology investment. Companies hesitate to implement centralized data warehouses because they’re concerned that a single system can’t meet the requirements of their multiple constituents, and they worry about the cost of acquiring and maintaining a decision support system outside the scope of their current departmental environments. Now, however, a single database can be used for high-volume strategic and operational queries. The design of Teradata Database is geared toward multiple groups of users and multiple reporting and analytical requirements enabling businesses to meet the needs of their current users and deploy new applications faster than ever, further accelerating their ROI. And, with the Teradata Purpose-Built Platform Family, you can start with a departmental data warehouse and grow into a fully scalable system with complete configuration flexibility or build an enterprise data warehouse (EDW) yet still meet the need of a specialized application for its own system.

Data Warehousing Leader

Teradata Database powers the data warehouses of the world’s leading companies in all industries. When our customers entrust terabytes or petabytes of their precious corporate data to a database engine, they expect availability 24 hours per day, 7 days per week, and 52 weeks per year. Teradata Database meets those expectations.

Our services consultants are the most experienced in the industry, and our Teradata platforms have been hailed as the most reliable and scalable computing systems for data warehousing on the market today. Teradata also has the most comprehensive data warehousing programs to assist with your current and future initiatives. And, Teradata recognizes that strategic partnerships provide robust, proven, and reliable offerings that extend and strengthen our data warehouse solutions with best-of-breed capabilities. These partnerships enable you to choose from a full suite of tools, applications, and software products – a win-win situation for everyone.

The Database – A Critical Component of Your Data Warehouse

Will the database you’re using today support your data warehouse needs in the future? Probably not if you’re using the database you also selected for on-line transaction processing (OLTP). Most common relational database management systems (RDBMS) were designed for OLTP environments, which need quick access and updates to single-record requests. These databases, designed for precise and directed access, often perform poorly when faced with entirely different workloads, such as full-table scans, many-table joins, sorting, or aggregating – common data warehousing functions. Their response to unfamiliar needs is to add more tables to the database or add more tuning parameters to the database management system. This adds additional overhead and complexity, to the point where one popular OLTP-based RDBMS has more than 100 different parameters just to control data caches in memory.

What happens when users and applications need to scan large amounts of data to answer complex business questions? Can users afford delays in getting the answers they need because custom aggregate tables must be created to meet their analytical needs? Can you afford to support a department of DBAs to maintain and tune your data warehousing databases? Will the OLTP database support the scalability requirements so necessary in most data warehouse environments?

What happens when you’ve developed an application on a departmental warehouse, such as the Teradata Data Mart Appliance, or separate specialized system, but it becomes more cost effective later to move it into your EDW?

Do you have to redesign the data model and rewrite the application to match the EDW? Not if you’ve used the same database for all your analytical needs regardless of hardware configuration or query mix characteristics.

These are important questions to consider when choosing your data warehouse partners and vendors. Data warehousing is a dynamic and iterative process, the requirements of which are constantly changing as the demands on your business change. Because a data warehouse is something you build – not something you buy – it’s critical to choose data warehouse partners and vendors who will allow you to adapt quickly and flexibly to these ever-changing business requirements.

Teradata Database – The Premier Performer

The primary requirement of your database is performance. So why not begin with the database that outperforms all others – Teradata Database? This scalable, high-performance decision-support engine is unmatched in the industry.

Designed from the ground up for decision support, the Teradata Database is free from the limitations that traditionally plague transaction processing databases. Instead, the Teradata Database easily and efficiently handles complex data requirements and simplifies management of the data warehouse environment. How? With a truly parallel implementation that automatically distributes data and balances workloads. The Teradata Database’s ease of use, combined with true query and workload parallelism, allows it to achieve performance and throughput levels not found in any other RDBMS.

Download the PDF to learn more.