Warning: Invalid argument supplied for foreach() in /home/seen2adm/public_html/s2/lib/mpr.php on line 374
Teradata Tutorial at it1me.com

Teradata Corporation
Traded as
Industry Data warehousing
Founded 1979; 38 years ago (1979)
Headquarters Miamisburg, Ohio
Key people
Victor L. Lund, President and CEO
Products Integrated Data Warehouse Hardware and Software, Unified Data Architecture, Big Data Analytics, Professional Services, Customer Services
Revenue DecreaseUS$2.3 billion (2016)[1]
Increase $125 million (2016)[1]
Increase $112 million (2016)[1]/>
Number of employees
10,093 (2016)[1]
Website www.teradata.com

Teradata Corporation is a provider of database-related products and services. The company was formed in 1979 in Brentwood, California, as a collaboration between researchers at Caltech and Citibank's advanced technology group.[2] The company was acquired by NCR Corporation in 1991, and subsequently spun-off again as an independent public company on October 1, 2007.

The company produces a relational database management system of the same name, which it markets as a data warehouse. It also acquired new technologies by making many acquisitions. In 2015, after continued losses, the company announced a business transformation review, which led to divestitures and replacement of executives.[3] Teradata employed 10,093 at the end of 2016, and had corporate headquarters Dayton, Ohio.[1]

Corporate overview

Teradata is an enterprise software company that develops and sells a relational database management system (RDBMS) with the same name. Teradata is publicly traded on the New York Stock Exchange (NYSE) under the stock symbol TDC.[4]

The flagship Teradata product is referred to as a "data warehouse system" which stores and manages data. The data warehouses use a "shared nothing architecture", which means that each server node has its own memory and processing power.[5] Adding more servers and nodes increases the amount of data that can be stored. The database software runs on the servers and spreads the workload among them.[6] In 2010, Teradata added text analytics to track unstructured data, such as word processor documents, and semi-structured data, such as spreadsheets.[7]

Teradata has a supplier diversity program that designates a minimum of 3 to 5% of spending on minority, women, veteran, or small business vendors.[8] In 2013, the Ethisphere Institute named Teradata as one of the "World's Most Ethical Companies."[9]

Teradata holds an annual user group conference and expo known as Teradata Partners with keynote industry speakers, educational sessions led by customers and other vendors.[10] The Teradata Partners Conference has been an annual event since 1985.[11] The conference involves lectures and speeches on technical and business topics and announcements about new products.[12]


NCR Teradata Worldmark 5100 in 2002

The concept of Teradata grew from research at California Institute of Technology (Caltech) and from the discussions of Citibank's advanced technology group in the 1970s.[13] The company was incorporated in 1979 in Brentwood, California by Jack E. Shemer, Philip M. Neches, Walter E. Muir, Jerold R. Modes, William P. Worth, Carroll Reed and David Hartke. In 1984, Teradata released its DBC/1012 specialized database computer.[14][15] In 1990, it acquired Sharebase, originally named Britton Lee.[16]

In September 1991, AT&T Corporation acquired NCR Corporation,[17] which in December announced the acquisition of Teradata for about $250 million. Kenneth W. Simonds had been chief executive since 1986.[18] In 1992, Teradata built the first system over 1 terabyte, at Wal-Mart.[19] A Teradata database became the world's largest at 11 terabytes in 1992. By 1997, NCR became independent from AT&T.[17]

In 1999, NCR acquired Strategic Technologies & Systems, and appointed Stephen Brobst as chief technology officer of the Teradata Solutions Group. In April 2000, NCR acquired Ceres Integrated Solutions and its customer relationship management software for $90 million,[20] and in July Stirling Douglas Group and its demand chain management software.[21] In 2005, it acquired financial management software from DecisionPoint.[22]

In January 2007, NCR announced Teradata would become an independent public company, led by Michael F. Koehler.[23][24] The new company's shares started trading in October.[4] In March 2008 Teradata acquired professional services company Claraview, which previously had spun out software provider Clarabridge.[25]

In August 2010, Teradata acquired column-oriented DBMS vendor Kickfire.[26][27] In December, it acquired marketing software company Aprimo for about $550 million.[28][29] In March 2011, it acquired Aster Data Systems for about $263 million.[30][31] In May 2012, Teradata acquired email direct marketing company eCircle, which was merged into the Aprimo business.[32]

In July 2014, Teradata acquired the assets of Revelytix, a provider of information management products and for a reported $50 million, Hadapt, a company that developed the database management system Presto for Apache Hadoop,[33][34][35] and in September, Hadoop service firm Think Big Analytics.[36] In December, Teradata acquired RainStor, a company specializing in online data archiving on Hadoop.[37]

In January 2015, Teradata acquired Appoxxee, a mobile marketing software as a service provider, for about $20 million.[38] In September, Teradata acquired digital marketing company FLXone, based in the Netherlands.[39] In November 2015, after continued losses and declining revenue, a business transformation review was announced.[3] The company terminated "co-president" Herman Wimmer in December 2015, although it later had to pay more than 4.2 million Euros and a company car as severance.[40]

In April 2016, a product line called IntelliFlex was announced.[41] On May 5, 2016 Victor L. Lund, who had been an executive of American Stores from 1977 to 1999, became the chief executive.[42] In July 2016, the marketing applications division, using the Aprimo brand, was sold to private equity firm Marlin Equity Partners for about $90 million. This was hundreds of millions less than Teradata paid making the acquisitions of several companies merged into the unit.[43][44] Marlin combined businesses of the former eCircle, Appoxee, and Ozone businesses with an email marketing company BlueHornet (that it had acquired in 2015), using the brand Mapp Digital in September 2016.[45]

On July 21, 2016, Teradata acquired Big Data Partnership, a service company based in the UK.[46]

In July 2017, Teradata acquired StackIQ, maker of the Stacki software.[47]

Technology and products

Active enterprise data warehouse

Teradata Active Enterprise Data Warehouse, often called Teradata Database, includes data management tools and data mining software. Teradata's product can be used for business analysis. Data warehouses can track company data, such as sales, customer preferences, product placement, etc.[6] The data warehouse differentiates between "hot and cold" data - meaning that the warehouse puts data that is not often used in a slower storage section.[48] The original system used a proprietary network technology called BYNet.[49]

Teradata Database 13.10 was announced in October 2010.[50][51] At the time, Teradata used Xeon 5600 processors for the server nodes.[52]

Teradata Database 14 was sold as the upgrade to 13.10 in 2011 and runs multiple data warehouse workloads at the same time.[53] It includes column-store analyses.[54]

Teradata Integrated Analytics[55] is a set of tools for data analysis that resides inside the data warehouse.[56]

Teradata Warehouse Miner provides and interface for data mining on Microsoft Windows. It was released before 2003.[57]

Aster Platform

The Aster Platform is Teradata's analytic technology, acquired from Aster Data Systems.[58]

Backup, archive, and restore

BAR is Teradata's backup and recovery system.[59]

The Teradata Disaster Recovery Solution is automation and tools for data recovery and archiving. Customer data can be stored in an offsite recovery center.[60]


The Teradata database includes a feature called QueryGrid,[61] that allows user of the Teradata database to fetch data from external databases from standard SQL queries, as if they were hosted in the local EDW. The data movement happens in parallel whenever possible, so it is as efficient as performance the external data source; this is usually still much slower than native Teradata database performance, but still acceptable for exploratory tasks. External data sources are Aster, Presto, Teradata, Hive and Oracle.

Platform family

Teradata Platform Family is a set of products that include the Teradata Data Warehouse, Database, and a set of analytic tools. The platform family is marketed as smaller and less expensive than the other Teradata products.[62]

Big data

Teradata began to market with the term "big data" in 2010. CTO Stephen Brobst attributed the rise of big data to "new media sources, such as social media."[63] The increase in semi-structured and unstructured data gathered from online interactions prompted Teradata to form the "Petabyte club" in 2011 for its heaviest big data users.[64]

The rise of big data resulted in many traditional data warehousing companies updating their products and technology.[65] For Teradata, big data prompted the acquisition of Aster Data Systems in 2011 for the company's MapReduce capabilities and ability to store and analyze semi-structured data.[66]


Teradata's main competitors are similar products from vendors such as Oracle, IBM, Microsoft and Sybase IQ. Also, competitors include data warehouse appliance vendors such as Netezza[67] (acquired in November 2010 by IBM), Snowflake Computing (a cloud-based data-warehousing startup publicly launched by Bob Muglia in 2014), DATAllegro (acquired in August 2008 by Microsoft), ParAccel (acquired in April 2013 by Actian in April 2013), Pivotal Greenplum Database (acquired in July 2010 by EMC Corporation in July 2010), and Vertica Systems (acquired in February 2011 by HP), and from packaged data warehouse applications such as SAP BW.

Teradata has also seen competition from Hadoop-based distributions and other open source technologies.


  1. ^ a b c d e "For 10-K: Annual Report for the Fiscal Year Ending December 31, 2016". February 27, 2017. Retrieved 2017. 
  2. ^ "The History of Teradata". Teradata.com. Teradata. Retrieved . 
  3. ^ a b "Teradata Reports 2015 Third Quarter Results and Updates Key Initiatives". Press release. Teradata. November 5, 2015. Retrieved 2017. 
  4. ^ a b "NCR Completes Teradata Spin Off" (Press release). NCR. October 1, 2007. 
  5. ^ "Teradata Architecture". Teradata Tech. February 24, 2013. Archived from the original on December 24, 2013. 
  6. ^ a b Lawson, Loraine. "How Business Logic Modeling Helps Data Warehouse Integration". IT Business Edge. Retrieved 2011. 
  7. ^ Sambandaraksa, Don (August 12, 2010). "Teradata launches new text analytics". Bangkok Post. Retrieved 2011. 
  8. ^ Cogliano, Joe (November 2, 2009). "Teradata Targets Diverse Suppliers". Dayton Business Journal. Retrieved 2011. 
  9. ^ http://ethisphere.com/worlds-most-ethical/wme-honorees/
  10. ^ "Teradata PARTNERS User Group". 
  11. ^ "Learning how small fish can eat big fish". Chin noa Daily. November 15, 2010. Retrieved 2011. 
  12. ^ Wise, Lyndsay (October 22, 2009). "Wrapping Up at Teradata Partners User Group Conference". Dashboard Insight. Retrieved 2011. 
  13. ^ Teradata Milestones
  14. ^ Paul Gillin (February 20, 1984). "Will Teradata revive a market?". Computer World. pp. 43, 48. Retrieved 2017. 
  15. ^ Pereira, Brian (January 1, 2010). "Marrying Strategic Intelligence with Operational Intelligence". Information Week. Archived from the original on June 13, 2012. Retrieved 2017. 
  16. ^ Jean S. Bozman (May 7, 1990). "Teradata rides shifting winds". Computer World. Retrieved 2017. 
  17. ^ a b Andrews, Edmund (January 11, 1996). "AT&T Acquisition, Soon to be Spun Off, Regains NCR Name". The New York Times. Retrieved 2011. 
  18. ^ Richard W. Stevenson (June 2, 1991). "Making a Difference - Whirlwind Courtship". The New York Times. Retrieved 2017. 
  19. ^ Hubler, David. "Teradata sees revenue growth in data consolidation". Washington Technology. Retrieved 2011. 
  20. ^ "Company News; NCR Acquires Ceres Integrated in a $90 Million Deal.". The New York Times. April 12, 2000. Retrieved 2011. 
  21. ^ "NCR Completes Acquisition of Sterling Douglas Group". Press release. NCR. July 14, 2000. Retrieved 2013. 
  22. ^ "Teradata Acquires DecisionPoint(R) Software; Acquisition Extends Teradata's Financial Management Portfolio". Press release. November 30, 2005. Retrieved 2011. 
  23. ^ "NCR, Teradata to split up". CNN Money. January 8, 2007. Retrieved 2017. 
  24. ^ Hagerty, John (January 9, 2007). "NCR to Spinoff Teradata". Forbes. Retrieved 2017. 
  25. ^ Grimes, Seth (March 20, 2008). "Teradata has Acquired BI/DW Firm Claraview". Information Week. Archived from the original on October 8, 2014. Retrieved 2017. 
  26. ^ Kanaracus, Chris (August 10, 2010). "Teradata buys analytics vendor Kickfire". Info World. Retrieved 2011. 
  27. ^ Kanaracus, Chris (August 10, 2010). "Teradata quietly scoops up Kickfire". Computer World. Retrieved 2017. 
  28. ^ Prickett Morgan, Timothy (December 22, 2010). "Teradata eats Aprimo for $550m.". The Register. Retrieved 2017. 
  29. ^ Henschen, Doug (April 9, 2011). "IT and Marketing: How Digital Media's Changing the Relationship". Information Week. Archived from the original on April 11, 2011. Retrieved 2017. 
  30. ^ Morgan, Timothy Prickett (March 3, 2011). "Teradata snaps up Aster Data for $263m". The Register. Retrieved 2011. 
  31. ^ Vizard, Mike (September 22, 2011). "Diversity Comes to Data Management". IT Business Edge. Retrieved 2011. 
  32. ^ Henschen, Doug (May 2, 2012). "Teradata Acquires eCircle For Social, Mobile Marketing Push". Information Week. Retrieved 2017. 
  33. ^ Kanaracus, Chris (July 22, 2014). "Teradata acquires assets of Hadapt, Revelytix for big data". PC World. Retrieved 2017. 
  34. ^ Keohane, Dennis (July 16, 2014). "Hadapt acquired by Teradata, will lead to more employees in Boston". The Boston Globe. Retrieved 2017. 
  35. ^ Natalie Gagliordi (September 28, 2015). "Facebook and Teradata on Apache Presto and the disruption of open source". ZDNet. Retrieved 2017. 
  36. ^ Henschen, Doug (September 3, 2014). "Teradata Buys Think Big for Big Data Consulting". Information Week. Retrieved 2017. 
  37. ^ Deutscher, Maria (December 17, 2014). "Teradata acquires RainStor to super-charge Hadoop archiving". Silicon Angle. Retrieved 2017. 
  38. ^ Lunden, Ingrid (January 3, 2015). "Teradata Buys App Marketing Platform Appoxee For $20-25M, Sets Up Israeli R&D Center". Tech Crunch. Retrieved 2017. 
  39. ^ Nelson, Jess (October 19, 2015). "Teradata Updates Marketing Cloud; Acquires DMP FLXone". Email Marketing Daily. Retrieved 2017. 
  40. ^ Martin, Anthony J (April 7, 2017). "Teradata pays ex-prez EUR4.2m to close 'invalid termination' settlement". The Register. Retrieved 2017. 
  41. ^ Brian McKenna (April 18, 2016). "Teradata Universe 2016: MPP architecture recast as 'Intelliflex'". Computer Weekly. Retrieved 2017. 
  42. ^ "Teradata Announces CEO Change" (Press release). Atlanta: Teradata. May 5, 2016. Retrieved 2017. 
  43. ^ Council, Jared (July 20, 2016). "Aprimo getting new life under new ownership, old name". Indianapolis Business Journal. Retrieved 2017. 
  44. ^ Council, Jared (April 26, 2016). "Teradata selling Aprimo unit at $435M discount". Indianapolis Business Journal. Retrieved 2017. 
  45. ^ "PE launches digital giant Mapp with Teradata deal". Decision Marketing. September 14, 2016. Retrieved 2017. 
  46. ^ O'Hear, Steve (July 25, 2016). "Big data company Teradata acquires UK's Big Data Partnership". Tech Crunch. Retrieved 2017. 
  47. ^ Bruce V. Bigelow (July 13, 2017). "Teradata Acquires San Diego's StackIQ to Strengthen Cloud Business". Xconomy. Retrieved 2017. 
  48. ^ Whitehorn, Mark (September 14, 2009). "What your database needs is a good thermometer.". The Register. Retrieved 2011. 
  49. ^ Allan Holbrook (February 14, 2000). "Teradata scales a data mountain". Info World. Retrieved 2017. 
  50. ^ Dignan, Larry. "Teradata rolls out latest database, pushes time aware analysis." ZDnet. October 25, 2010. http://www.zdnet.com/blog/btl/teradata-rolls-out-latest-database-pushes-time-aware-analysis/40865
  51. ^ Vizard, Mike. "Teradata Extends Analytics Engine." CTOEdge. October 25, 2010.
  52. ^ Morgan, Timothy Prickett (October 25, 2010). "Teradata pumps data warehouses with six-core Xeons". The Register. Retrieved 2011. 
  53. ^ Russom, Philip. "Big Data Analytics: The News from Teradata." TDWI blog. September 22, 2011.
  54. ^ Henschen, Doug. "Teradata Upgrades Break Down Database Barriers." InformationWeek. September 22, 2011.
  55. ^ https://www.teradata.com/product-and-services/Integrated-Analytics/#tabbable=0&tab1=0&tab2=0
  56. ^ Winter, Richard. InformationWeek. September 18, 2010. "Research: State of Enterprise Databases."
  57. ^ Jesus Mena. Investigative Data Mining for Security and Criminal Detection. Butterworth-Heinemann. p. 247-248. ISBN 9780750676137. 
  58. ^ Teradata Aster
  59. ^ Teradata brochure. "Teradata Backup Archive Restore."
  60. ^ Fratto, Mike. "Teradata Disaster Recovery Solution Helps Reduce the Panic of Catastrophic Events." Network Computing. June 29, 2009.
  61. ^ Teradata QueryGrid
  62. ^ IT Reseller Magazine. "Teradata announces new family of powerful analytic platforms.."[dead link]
  63. ^ Salah-Ahmed, Amira (May 4, 2011). "One-on-One with Teradata's CTO Stephen Brobst". The Daily Egypt News. Retrieved 2011. 
  64. ^ Grant, Ian (April 11, 2011). "Big data boosts Teradata growth". Computer Weekly. Retrieved 2011. 
  65. ^ Miniman, Stuart (March 28, 2011). "The Emerging Big Data Vendor Ecosystem". Wikibon. Retrieved 2011. 
  66. ^ Kanaracus, Chris (March 3, 2011). "Teradata Buys Aster Data, Boosts "Big Data" Wares". CIO. Retrieved 2011. 
  67. ^ Teradata decides to compete head-on as a data warehouse appliance vendor

External links

Media related to Teradata at Wikimedia Commons

  This article uses material from the Wikipedia page available here. It is released under the Creative Commons Attribution-Share-Alike License 3.0.


Manage research, learning and skills at IT1me. Create an account using LinkedIn to manage and organize your IT knowledge. IT1me works like a shopping cart for information -- helping you to save, discuss and share.

  Contact Us  |  About IT1me.com |  IT Training & References |  IT Careers |  IT Hardware |  IT Software |  IT Books