Teradata Database 14 - Database Management

Products and Services Database Software
Teradata Database

Teradata Database 14 is the high performing analytical engine that powers all of Teradata’s “purpose-built” platform family members. Whether you need a data warehouse appliance or a flexible enterprise data warehouse, Teradata Database is the choice. Teradata brings analytical processing to all corners of your organization. Its proven analytical power and flexibility, scalability, and ease of use allows your entire organization to benefit from your valuable corporate information assets.

Teradata provides the analytical performance you need through its “parallel everything” design and industry leading optimizer to intelligently process all types of analytical and business intelligence queries. The renowned multi-dimensional scalability allows not only large amounts of data to be stored and processed, but the most concurrent queries, the most complex requests, and the widest variety of work to be accomplished. And, with its easy “set and go” optimization options, Teradata provides powerful embedded analytics and advanced workload management.

Features & Benefits

Automatic Built-In Functionality	Fast Query Performance	“Parallel Everything” design and smart Teradata Optimizer enables fast query execution across platforms
	Quick Time to Value	Simple set up steps with automatic “hands off” distribution of data, along with integrated load utilities result in rapid installations
	Simple to Manage	DBAs never have to set parameters, manage table space, or reorganize data
	Responsive to Business Change	Fully parallel MPP “shared nothing” architecture scales linearly across data, users, and applications providing consistent and predictable performance and growth
Easy “Set & G0” Optimization Options	Powerful, Embedded Analytics	In-database data mining, virtual OLAP/cubes, geospatial and temporal analytics, custom and embedded services in an extensible open parallel framework drive efficient and differentiated business insight
	Advanced Workload Management	Workload management options by user, application, time of day and CPU exceptions
	Intelligent Scan Elimination	“Set and Go” options reduce full file scanning (Primary, Secondary, Multi-level Partitioned Primary, Aggregate Join Index, Sync Scan)

Teradata Database 14 helps you create a consolidated data environment that gives you a single source for enterprise-wide decision making with these features and more:

Teradata Columnar
Compress on cold and intelligent multi-temperature data management
Enhanced security
Customer driven innovation in application migration and temporal

Primary Components

Advanced Data Warehousing Built-in

Teradata optimizer: Teradata optimizer develops the most efficient execution plan for each query. The most intelligent analytic query processing. Automatic use of set-and-go optimization features such as aggregate join indexes and partitioning without explicit references in queries.
Virtual independent processing engines for parallel processing and linear scalability delivering the best concurrent user, mixed workload, and complex query processing.
Geospatial analysis: Built-in geospatial functions and analysis allow geospatial relationships (e.g., distance, within an area or territory) to be used with other business factors and all of the data in the data warehouse.

OLAP, statistical, window, data mining features: Sophisticated and optimized advanced analytics techniques built into the database for use within the data warehouse. ETL to move data to a specialized engine is avoided. All corporate data is available for rich analyses.
Teradata Temporal: Time aware for automated temporal data management and intelligent temporal query processing. Reduces data errors, simplifies application development, and opens temporal data analysis up to business users.
Teradata Columnar: Hybrid row and column oriented data for extreme performance and dramatic compression without sacrificing the other benefits and industry leading attributes of Teradata.

Review All Primary Components