{"id":27286,"date":"2022-02-22T10:35:21","date_gmt":"2022-02-22T10:35:21","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=27286"},"modified":"2022-12-23T06:48:53","modified_gmt":"2022-12-23T06:48:53","slug":"what-is-teradata-database","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/what-is-teradata-database\/","title":{"rendered":"What is Teradata Database?"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"contents\">                                     Contents<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"what-is-teradata-database\"> What is Teradata Database?<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"teradata-a-brief-history-1\">Teradata \u2013 A Brief History<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"why-teradata-1\">Why Teradata?<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"what-is-a-data-warehouse-1\">What is a Data Warehouse?<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"what-is-a-relational-database-1\">What is a Relational Database?<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"teradata-database-advantages-1\">Teradata Database Advantages<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"the-features-that-makes-teradata-database-unique-from-others-databases-1\">The Features\u00a0That Makes Teradata Database Unique from Others Databases<\/h4>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-is-teradata-database-1\">What is Teradata Database?<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Teradata is a Relational Database Management System (RDBMS) for the world\u2019s largest commercial databases.<\/li><li>It is possible to have databases with petabytes of data in size.<\/li><li>This characteristic makes Teradata an obvious choice for large data warehousing applications.<\/li><li>With its parallelism and scalability, Teradata allows you to start small with a single node and grow large with many nodes through linear expandability.<\/li><li>Teradata is comparable to a large database server, with multiple client application making inquiries against it concurrently.<\/li><li>Teradata is a massively open processing system that supports Unix\/Linux\/Windows server platforms.<\/li><li>The latest Teradata release is 17.10 and executes as a SUSE Linux (SLES 11) application.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"764\" height=\"201\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-52.png\" alt=\"\" class=\"wp-image-27298\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-52.png 764w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-52-300x79.png 300w\" sizes=\"auto, (max-width: 764px) 100vw, 764px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"teradata-a-brief-history\">Teradata \u2013 A Brief History<\/h2>\n\n\n\n<p>Teradata was a division of NCR Corporation. It incorporated in 1979 but parted away from NCR in October 2007. Michael Koehler became the first CEO of Teradata.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"milestones-of-teradata-corporation\">Milestones of Teradata Corporation:<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>1979 \u2013 Teradata was incorporated<\/li><li>1984 \u2013 Release of first database computer DBC\/1012<\/li><li>1986 \u2013 Fortune magazine declared Teradata as \u2018Product of the Year\u2019<\/li><li>1999 \u2013 Largest database built using Teradata with 130 Terabytes<\/li><li>2002 \u2013 Teradata V2R5 version release with compression and Partition Primary<\/li><li>2006 \u2013 Launch of Teradata Master Data Management solution<\/li><li>2008 \u2013 Teradata 13.0 released with Active Data Warehousing<\/li><li>2011 \u2013 Acquires Teradata Aster and plunges into the Advanced Analytics Space<\/li><li>2012 \u2013 Teradata 14.0 introduced<\/li><li>2014 \u2013 Teradata 15.0 introduced<\/li><li>2015- Teradata Buys Apps Marketing Platform Appoxee<\/li><li>2016- Terada join hands with Big data<\/li><li>2017- Teradata Acquires San Diego\u2019s StackIQ<\/li><li>2018- Introduced of Teradata Vantage<\/li><li>2019- Teradata introduces Vantage Customer Experience and Vantage Analyst<\/li><li>2020- High Customer Satisfaction Led to Teradata\u2019s Leadership Distinction in Q4 Big Data Warehouse Landscape Report by The Information Difference.<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"why-teradata\">Why Teradata?<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Teradata offers a full suite of service which focuses on&nbsp;Data warehousing<\/li><li>The system is built on open architecture. So whenever any faster devices are made available, it can be incorporated into the already build architecture.<\/li><li>Teradata supports 50+ petabytes of data.<\/li><li>Single operation view for a large Teradata multi-node system using Service Workstation<\/li><li>Compatible with wide range of BI tool to fetch data.<\/li><li>It can act as a single point of control for the DBA to manage the&nbsp;Database<\/li><li>High performance, diverse queries, in-database analytics and sophisticated workload management<\/li><li>Teradata allows you to get the same data on multiple deployment options<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-is-a-data-warehouse\">What is a Data Warehouse?<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"a-data-warehouse-is-a-central-enterprise-wide-database-that-contains-information-extracted-from-operational-data-stores-ods\">A Data Warehouse is a central, enterprise-wide database that contains information extracted from Operational Data Stores (ODS).<\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Based on enterprise-wide model<\/li><li>Can begin small but may grow large rapidly<\/li><li>Populated by extraction\/loading data from operational systems<\/li><li>Responds to end-user &#8220;what if&#8221; queries<\/li><li>Can store detailed as well as summary data<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"773\" height=\"324\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-54.png\" alt=\"\" class=\"wp-image-27303\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-54.png 773w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-54-300x126.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-54-768x322.png 768w\" sizes=\"auto, (max-width: 773px) 100vw, 773px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-is-a-relational-database\">What is a Relational Database?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"a-relational-databaseconsists-of-a-set-of-logically-related-tables\">A Relational Databaseconsists of a set of logically related tables.<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>A tableis a two dimensional representation of data consisting of rows and columns.<\/li><li>Each row is in the table uniquely identified by a Primary Key (PK)\u20131 or more columns.<br>\u2013A PK cannot have duplicate values and cannot be NULL; only one per table.<br>\u2013A PK are considered \u201cnon-changing\u201d values.<\/li><li>A table may optionally have 1 or more Foreign Keys (FK).<br>\u2013A FK can be 1 or more columns, can have duplicate values, and allows NULLs<br>\u2013Each FK value must exist somewhere as a PK value<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"685\" height=\"189\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-55.png\" alt=\"\" class=\"wp-image-27307\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-55.png 685w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-55-300x83.png 300w\" sizes=\"auto, (max-width: 685px) 100vw, 685px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"teradata-database-advantages\">Teradata Database Advantages<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Unlimited, Proven Scalability\u2013amount of data and number of users; allows for an enterprise wide model of the data.<\/li><li>Unlimited Parallelism\u2013parallel access, sorts, and aggregations.<\/li><li>Mature Optimizer\u2013handles complex queries, up to 128 joins per query, ad-hoc processing.<\/li><li>Models the Business\u2013normalized data (usually in 3NF), robust view processing, &amp; provides star schema capabilities.<\/li><li>Provides a \u201csingle version of the business\u201d.<\/li><li>Low TCO (Total Cost of Ownership)\u2013ease of setup, maintenance, &amp; administration; no re-orgs, lowest disk to data ratio, and robust expansion utility (RECONFIG).<\/li><li>High Availability\u2013no single point of failure.<\/li><li>Parallel Load and Unload utility\u2013robust, parallel, and scalable import and export capabilities via Teradata Parallel Transporter (TPT).<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"the-features-that-makes-teradata-database-unique-from-others-databases\">The <strong>Features&nbsp;That Makes Teradata Database Unique<\/strong> from Others Databases<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"1-parallel-processing\">&#8216;1. Parallel Processing <\/h4>\n\n\n\n<p>Each AMP holds a portion of data and each AMP processes their portion of the data in parallel.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2-linear-scalability\">2. Linear Scalability<\/h4>\n\n\n\n<p>Double the AMPs and double the speed forever!<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3-mature-optimizer-pe\">3. Mature Optimizer (PE)<\/h4>\n\n\n\n<p>The Parsing Engine (PE) is called the optimizer. It has been improved on for the past 20 years . It is quite Mature!<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"4-automatic-data-distribution\">4. Automatic Data Distribution<\/h4>\n\n\n\n<p>Each table&#8217;s has Primary Index. Each row&#8217;s primary index hashed to automatically distribute data to an AMP.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"5-sharing-nothing-architecture\">5. Sharing Nothing  Architecture<\/h4>\n\n\n\n<p>Each AMP has their own CPU, memory and disk. This is shared nothing Architecture.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"6-single-data-store\">6. Single Data Store<\/h4>\n\n\n\n<p>Teradata Scalability allows for all data to be on one system. This sis said to be Single Data Store.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"841\" height=\"622\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-63.png\" alt=\"\" class=\"wp-image-27364\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-63.png 841w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-63-300x222.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-63-768x568.png 768w\" sizes=\"auto, (max-width: 841px) 100vw, 841px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contents What is Teradata Database? Teradata \u2013 A Brief History Why Teradata? What is a Data Warehouse? What is a Relational Database? Teradata Database Advantages The Features\u00a0That Makes Teradata Database Unique from Others Databases What is Teradata Database? Teradata is a Relational Database Management System (RDBMS) for the world\u2019s largest commercial databases. It is possible&#8230;<\/p>\n","protected":false},"author":48,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[7338],"tags":[],"class_list":["post-27286","post","type-post","status-publish","format-standard","hentry","category-teradata"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/27286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=27286"}],"version-history":[{"count":5,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/27286\/revisions"}],"predecessor-version":[{"id":27432,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/27286\/revisions\/27432"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=27286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=27286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=27286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}