Teradata Case Study

999 Words 4 Pages
Teradata is basically a database that is designed to handle queries. It is a relational database management system for the world's largest commercial databases. Other RDBMS takes enormous time to process and execute the data. But Teradata RDBMS handles massive amount of data with ease.
The main attraction of Teradata is its scalability, parallel processing and high performance. It generates an optimal plan for the query within few seconds.
Teradata can save upto Teradata bytes in size. The concept of parallelism makes Teradata the industry giant in data warehousing applications.
Teradata is based on the shared nothing architecture.
Features of Teradata
1. Faster response
Teradata has the most intelligent optimizer and smartest features to
…show more content…
Saves IT effort and time
Teradata is easy to set up and simple to use. It will save a lot of time for your IT department letting them to concentrate on the main goals of business. It's simple set up, automation processes and intelligent design are more attracted features of the IT people
3. Analytical Needs
Teradata is ready to solve any type of query and at any time. It deals with complex business trends to customizing web offers. Teradata works with multiple queries at the same time making it easy for the user to derive at a decision
4. Manage Data Warehouse at a single click
Teradata contains features that enables faster data warehouse deployment that combines with software controls of memory space, CPU and security. Teradata has a defined data warehouse that quickly responds to the changing business requirements. Teradata's Defined Warehouse includes three major sections
 Teradata Workload Management
 Teradata Database Secure Zones
 Teradata Data Lab
5. Language choice
You have an option to choose your favourite language which you think will handle the type of questions at its best. You can select Java, Perl, Ruby, Python, R or any other language script installed in your system to run custom
…show more content…
Row/Column data storage
Teradata has an element called Teradata Columnar which helps in integrating column and row based tables within the Teradata Database. It supports advanced workload management, rich SQL and in database analytics.
9. All types of users
Teradata can be used by all types of users from business users to application developers. It is best suited for business users because of its features of leading BI and flexible custom written business SQL. It is best for application developers because of its language choice and flexible application architecture.
10. Bi temporal
You will not need any complex SQL condition clauses. Teradata makes it more simple for you. It offers full bi temporal tables and queries.
Benefits of Teradata
 Automatic data distribution - Teradata automatically distributes even or uniform or random data
 High scalability
 Optimizer - Teradata has powerful optimizer to perform a lot of operations
 Highly flexible
 Easy to install, use and maintain
 Acts like a single data store
 Low cost of ownership
 Bulk load facilities
 Full support to

Related Documents