Database that drives Business Intelligence - Teradata Database
  • Teradata Database

    The Best Analytical Database Possible for the Best Decisions Possible

    Designed to deliver high performance, diverse queries, in-database analytics & sophisticated workload management

    View technical overview
  • Provides Faster Answers

    Get the power you need to make the right decisions - when you need it most. We put over 30 years of real-world experience into developing not only raw power but the most intelligent optimizer and smartest features to process queries and filter data to efficiently respond to any request. JSON data integration in Teradata Database lets you also apply that query power to dynamic data without adding columns to your table to accept new data.

    If your application architecture includes in-database processing, embed your favorite language (e.g., Ruby, Perl, Python) right in the database for parallel execution by the database. Supporting Teradata QueryGrid™ expands your data warehouse horizon, extending query reach to execute portions of your query on your Hadoop data platform or Oracle database, giving you access to all of your enterprise data or specialized processing engines.

    Technical Overview

    Reduces IT Effort & Time

    This uncomplicated, hands-off solution saves your staff untold hours by continuously running a multi-application data warehouse at peak performance. Your IT team will apprecitate Teradata Database's simple set-up, self-managing automation and intelligent design. 

    Teradata Technical Overview

    Flexibility to Meet Analytical Needs

    Ask any question at any time - from determining complex trends and anomalies in the business to customizing web offers with thousands of short queries. You'll have the flexibility to do it all - all at the same time - with intelligent query processing that supports any physical data model.

    Station Casinos: High Stakes

    Keep Pace with Growing Business & User Demands

    Managing your production environment brings change & challenge as the data in your Teradata system becomes more critical to your business.

    Teradata Workload Management

    Use Your Favorite Language

    Use the language which best handles the type of question and processing you require, or combine processing methodologies within a single analytical process. Submit SQL queries to the database, or invoke Java, Perl, Ruby, Python, R or other language scripts you have installed in the database to run custom analytics. Scripts automatically run in parallel within the database and produce a set of output rows just like a native SQL query.

    Structured and Multi-Structured Data

    Store and analyze structured and multi-structured data in the same database engine. Deep integration provides performance, workload management, in-database analytics, and ease of administration across all data and seamless use of all data types within queries. Full breadth of structured types, XML, JSON, and weblog data are all supported for native in-database processing.

    Exceed Your XML Expectations

    All Data In The Right Location

    Ensure the best performance when you use your critical data and ensure you pay for the right storage for all of your data without overpaying for premium storage where not needed. Teradata Database’s multi-temperature data management automatically utilizes hybrid storage for data temperature sensitive storage and Teradata Intelligent Memory for in-memory processing of the most critical data.

    Teradata Intelligent Memory

    Hybrid Row/Column Data Storage

    There are no silver bullets for performance. While columnar technology has been attractive, companies have shied away from columnar databases because they have lacked the capabilities businesses require.

    With its elegant hybrid design, Teradata Columnar breaks through that barrier by fully integrating columnar and row-based tables within Teradata Database. This allows support of mission-critical applications which depend on advanced workload management, high availability, rich SQL, and in-database analytics.

    Row vs. Columns: Why Not Both?

    Utilize Multiple Sources

    The Teradata Unified Data Architecture (UDA) includes the specialized platforms and compute engines to support the broad array of data and analytical techniques needed by leading enterprises. Teradata QueryGrid™ enables Teradata Database to orchestrate the resources of all of the platforms in the UDA and beyond so that a single query can utilize the unique analytical capabilities of and data on any of the platforms. For example, QueryGrid: Teradata Database-to-Hadoop lets Teradata Database push analytics down to Hadoop for processing and retrieval of some data for use within a query. With its bi-directional data exchange and query push down your complete Data Fabric enabled by QueryGrid is available from within your Teradata Database integrated data warehouse.

    Learn More About Teradata QueryGrid

    All Users Welcome

    Teradata Database is the best analytic data target for everyone from business users to application developers. Integrated with the leading BI and Analytical tools and supporting the most powerful and flexible custom written business SQL, business users can ask any question on any data. Application developers have the flexibility to use their language of choice and implement flexible application architecture with logic embedded in the database itself by using Teradata Database as the data platform for their applications.

    Broadest Range of Concurrent Queries

    The Teradata Database integrated data warehouse supports the breadth of queries from simple reporting and ad hoc queries to the most complex in-database algorithms - all at the same time. Database features combined with the best workload management in the industry enables the support of the mix of workload you require.

    Teradata Workload Management

    Full Bi-Temporal Tables & Queries

    Things just got simpler! You no longer need complex SQL condition clauses and date fields to model transaction (system) time and valid (real-world) time.

    Temporal Processing Delivers
  • “Teradata provides best in class analytic and BI solutions that are used to create significant value for our business.”

    Thomas Henry

    Senior Director of Corporate Systems, Express Scripts Inc.


    Express Scripts
    Express Scripts (ESI) delivers affordable prescriptions to clients such as public and private employers, managed-care plans and labor unions. Every day ESI deals with a mind-numbing multitude of insurance companies, employer plan sponsors, doctors and patients. Consolidating information on an upgraded data warehouse solution from Teradata and powerful new analytics capabilities from its Beacon application helped ESI detect fraud, reduce costs and continue to provide its trademark high level of service to its richly varied customer base.
    Read More
  • Our industry customers

    View More