Teradata: Difference between revisions

Source: Wikipedia, the free encyclopedia.
Browse history interactively
← Previous editNext edit →
Content deleted Content added
VisualWikitext
HtownCat (talk | contribs)
1,180 edits
Removing outdated tag.
Extended confirmed users, Pending changes reviewers, Rollbackers
28,957 edits
fix red link, tighten up some trivial sections
Line 21: Line 21:
==Introduction==
==Introduction==


Teradata is an [[enterprise software]] company that develops and sells a [[relational database management system]] (RDBMS) with the same name. In February 2011, [[Gartner]] ranked Teradata as one of the leading companies in data warehousing and [[enterprise analytics]].<ref>{{cite web|last=Henschen|first=Doug|title=Garnter Ranks Data Warehousing Leaders|url=http://www.informationweek.com/news/software/info_management/229215658?pgno=1|work=InformationWeek |accessdate=December 13, 2011}}</ref> Teradata was a division of the NCR Corporation, which acquired Teradata on February 28, 1991. Teradata's revenues in 2005 were almost $1.5 billion with an operating margin of 21%.<ref name=ForbesNCR /> On January 8, 2007, NCR announced that it would spin-off Teradata as an independently traded company,<ref>{{cite press release |url=http://www.ncr.com/about_ncr/media_information/news_releases/2007/january/010807.jsp?lang=EN |title=NCR Announces Intention to Separate into Two Independent Companies |date=January 8, 2007 |publisher=NCR }}</ref> and this spin-off was completed October 1 of the same year, with Teradata trading under the [[New York Stock Exchange|NYSE]] stock symbol TDC.<ref name=NCRspinoff>{{cite press release |url=http://www.ncr.com/about_ncr/media_information/news_releases/2007/october/100107a.jsp |publisher=NCR |date=October 1, 2007 |title=NCR Completes Teradata Spin Off}}</ref>
Teradata is an [[enterprise software]] company that develops and sells a [[relational database management system]] (RDBMS) with the same name. In February 2011, [[Gartner]] ranked Teradata as one of the leading companies in data warehousing and enterprise [[analytics]].<ref>{{cite web|last=Henschen|first=Doug|title=Garnter Ranks Data Warehousing Leaders|url=http://www.informationweek.com/news/software/info_management/229215658?pgno=1|work=InformationWeek |accessdate=December 13, 2011}}</ref> Teradata was a division of the NCR Corporation, which acquired Teradata on February 28, 1991. Teradata's revenues in 2005 were almost $1.5 billion with an operating margin of 21%.<ref name=ForbesNCR /> On January 8, 2007, NCR announced that it would spin-off Teradata as an independently traded company,<ref>{{cite press release |url=http://www.ncr.com/about_ncr/media_information/news_releases/2007/january/010807.jsp?lang=EN |title=NCR Announces Intention to Separate into Two Independent Companies |date=January 8, 2007 |publisher=NCR }}</ref> and this spin-off was completed October 1 of the same year, with Teradata trading under the [[New York Stock Exchange|NYSE]] stock symbol TDC.<ref name=NCRspinoff>{{cite press release |url=http://www.ncr.com/about_ncr/media_information/news_releases/2007/october/100107a.jsp |publisher=NCR |date=October 1, 2007 |title=NCR Completes Teradata Spin Off}}</ref>


The Teradata product is referred to as a "[[data warehouse]] system" and 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. Adding more [[server (computing)|server]]s and nodes increases the amount of data that can be stored. The [[database software]] sits on top of the servers and spreads the workload among them.<ref name="Lawson">{{cite web|last=Lawson|first=Loraine|title=How Business Logic Modeling Helps Data Warehouse Integration|url=http://www.itbusinessedge.com/cm/community/features/interviews/blog/how-business-logic-modeling-helps-data-warehouse-integration/?cs=43396|work=IT Business Edge|accessdate=December 13, 2011}}</ref> Teradata sells applications and software to process different types of data. In 2010, Teradata added [[text analytics]] to track [[unstructured data]], such as word processor documents, and semi-structured data, such as spreadsheets.<ref>{{cite web|last=Sambandaraksa|first=Don|title=Teradata launches new text analytics|url=http://www.bangkokpost.com/tech/computer/210208/teradata-launches-new-text-analytics|date=August 12, 2010|work=Bangkok Post|accessdate=December 13, 2011}}</ref>
The Teradata product is referred to as a "[[data warehouse]] system" and 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. Adding more [[server (computing)|server]]s and nodes increases the amount of data that can be stored. The [[database software]] sits on top of the servers and spreads the workload among them.<ref name="Lawson">{{cite web|last=Lawson|first=Loraine|title=How Business Logic Modeling Helps Data Warehouse Integration|url=http://www.itbusinessedge.com/cm/community/features/interviews/blog/how-business-logic-modeling-helps-data-warehouse-integration/?cs=43396|work=IT Business Edge|accessdate=December 13, 2011}}</ref> Teradata sells applications and software to process different types of data. In 2010, Teradata added [[text analytics]] to track [[unstructured data]], such as word processor documents, and semi-structured data, such as spreadsheets.<ref>{{cite web|last=Sambandaraksa|first=Don|title=Teradata launches new text analytics|url=http://www.bangkokpost.com/tech/computer/210208/teradata-launches-new-text-analytics|date=August 12, 2010|work=Bangkok Post|accessdate=December 13, 2011}}</ref>
Line 32: Line 32:
Timeline information taken from Teradata company history unless otherwise cited.<ref>{{cite web|title=History|url=http://www.teradata.com/history/|publisher=Teradata company website|accessdate=December 13, 2011}}</ref>
Timeline information taken from Teradata company history unless otherwise cited.<ref>{{cite web|title=History|url=http://www.teradata.com/history/|publisher=Teradata company website|accessdate=December 13, 2011}}</ref>


*1976–1979: concept of Teradata grows from research at [[California Institute of Technology]] (Caltech) and from the discussions of [[Citibank|Citibank’s]] advanced technology group.<ref name="tdhist">[http://www.teradata.com/t/go.aspx/page.html?id=42649 Teradata Milestones]</ref>
*1976–1979: concept of Teradata grows from research at [[California Institute of Technology]] (Caltech) and from the discussions of [[Citibank]]'s advanced technology group.<ref name="tdhist">[http://www.teradata.com/t/go.aspx/page.html?id=42649 Teradata Milestones]</ref>
*Incorporated in 1979 in [[Brentwood, CA]] by Dr. Jack E. Shemer, Dr. Philip M. Neches, Walter E. Muir, Jerold R. Modes, William P. Worth, and Carroll Reed.
*Incorporated in 1979 in [[Brentwood, CA]] by Dr. Jack E. Shemer, Dr. Philip M. Neches, Walter E. Muir, Jerold R. Modes, William P. Worth, and Carroll Reed.
*1980: Enough funding for a Research and Development team.
*1980: Enough funding for a research and development team.
*1983: First beta system shipped to [[Wells Fargo Bank]].
*1983: First beta system shipped to [[Wells Fargo Bank]].
*1984: Teradata releases the world's first parallel data warehouses and data marts.<ref>{{cite web|last=Pereira|first=Brian|title=Marrying Strategic Intelligence with Operational Intelligence|url=http://www.informationweek.in/Archive/10-01-01/Marrying_Strategic_Intelligence_with_Operational_Intelligence.aspx|date= January 1, 2010|work=InformationWeek|accessdate=December 13, 2011}}</ref>
*1984: Teradata releases the world's first parallel data warehouses and data marts.<ref>{{cite web|last=Pereira|first=Brian|title=Marrying Strategic Intelligence with Operational Intelligence|url=http://www.informationweek.in/Archive/10-01-01/Marrying_Strategic_Intelligence_with_Operational_Intelligence.aspx|date= January 1, 2010|work=InformationWeek|accessdate=December 13, 2011}}</ref>
*1986: [[Fortune Magazine]] names Teradata "Product of the Year."
*1986: [[Fortune Magazine]] names Teradata "Product of the Year."
*1987: Teradata IPO in August
*1987: Teradata [[initial public offering]] in August
*1989: Teradata partners with NCR to build new database computers.
*1989: Teradata partners with NCR to build new database computers.
*Sept. 1991: [[AT&T Corporation]] acquires [[NCR Corporation|NCR]].<ref name="Andrews">{{cite news|last=Andrews|first=Edmund|title=AT&T Acquisition, Soon to be Spun Off, Regains NCR Name|url=http://www.nytimes.com/1996/01/11/business/at-t-acquisition-soon-to-be-spun-off-regains-ncr-name.html |work=The New York Times|accessdate=December 13, 2011|date=January 11, 1996}}</ref>
*September 1991: [[AT&T Corporation]] acquires [[NCR Corporation|NCR]].<ref name="Andrews">{{cite news|last=Andrews|first=Edmund|title=AT&T Acquisition, Soon to be Spun Off, Regains NCR Name|url=http://www.nytimes.com/1996/01/11/business/at-t-acquisition-soon-to-be-spun-off-regains-ncr-name.html |work=The New York Times|accessdate=December 13, 2011|date=January 11, 1996}}</ref>
*Dec. 1991: NCR announces acquisition of Teradata.<ref>{{cite news|title=NCR, Teradata to split up|url=http://money.cnn.com/2007/01/08/news/companies/ncr/index.htm|publisher=CNN Money|accessdate=December 13, 2011|date=January 8, 2007}}</ref>
*December 1991: NCR announces acquisition of Teradata.<ref>{{cite news|title=NCR, Teradata to split up|url=http://money.cnn.com/2007/01/08/news/companies/ncr/index.htm|publisher=CNN Money|accessdate=December 13, 2011|date=January 8, 2007}}</ref>
*1992: Teradata creates the first system over 1 [[terabyte]], which goes live at [[Wal-Mart]].<ref>{{cite web|last=Hubler|first=David|title=Teradata sees revenue growth in data consolidation|url=http://washingtontechnology.com/articles/2010/12/13/teradata-data-consolidation.aspx |publisher=Washington Technology|accessdate=December 13, 2011}}</ref>
*1992: Teradata creates the first system over 1 [[terabyte]], which goes live at [[Wal-Mart]].<ref>{{cite web|last=Hubler|first=David|title=Teradata sees revenue growth in data consolidation|url=http://washingtontechnology.com/articles/2010/12/13/teradata-data-consolidation.aspx |publisher=Washington Technology|accessdate=December 13, 2011}}</ref>
*1994: Gartner names Teradata the "Leader in Commercial Parallel Processing."
*1994: Gartner names Teradata the "Leader in Commercial Parallel Processing."
Line 74: Line 74:
*2008: Teradata Labs becomes the first to unveil a working prototype demonstrating the innovative use of solid state disk (SSD) drives in a data warehouse environment at the 2008 Teradata PARTNERS User Group Conference & Expo.<ref>{{cite web|last=Jai|first=C.S.|title=Teradata Labs Unveils SSD Data Warehouse Solution." InfoTech Spotlight|url=http://it.tmcnet.com/topics/it/articles/42729-teradata-labs-unveils-ssd-data-warehouse-solution.htm|date=October 14, 2008|accessdate=December 13, 2011}}</ref>
*2008: Teradata Labs becomes the first to unveil a working prototype demonstrating the innovative use of solid state disk (SSD) drives in a data warehouse environment at the 2008 Teradata PARTNERS User Group Conference & Expo.<ref>{{cite web|last=Jai|first=C.S.|title=Teradata Labs Unveils SSD Data Warehouse Solution." InfoTech Spotlight|url=http://it.tmcnet.com/topics/it/articles/42729-teradata-labs-unveils-ssd-data-warehouse-solution.htm|date=October 14, 2008|accessdate=December 13, 2011}}</ref>
*2008: Teradata Accelerate launches
*2008: Teradata Accelerate launches
*2009: [[Forrester Research]] ranks Teradata as number 1 amongst enterprise data warehousing for their current offering.
*2009: [[Forrester Research]] ranks Teradata as number 1 amongst enterprise data warehousing.
*2009: Teradata announces that database administrators can now rewind Teradata Viewpoint monitoring applications and portlets to check database activity or performance at a specific point in time.
*2009: Teradata announces that database administrators can now rewind Teradata Viewpoint monitoring applications and portlets to check database activity or performance at a specific point in time.
*2009: Teradata ranked among BusinessWeek’s “InfoTech 100,"<ref>{{cite web|title=The Infotech 100|url=http://www.businessweek.com/interactive_reports/it100_2009.html|year= 2009|publisher=Bloomberg Business Week|accessdate=December 13, 2011}}</ref> the world’s best-performing tech companies” and Fortune’s 1000.<ref>{{cite news|title=Fortune 1000|url=http://money.cnn.com/magazines/fortune/fortune500/2009/companies/T.html|date= May 4, 2009|publisher=CNNMoney.com|accessdate=December 13, 2011}}</ref>
*2009: Teradata ranked among BusinessWeek’s “InfoTech 100,"<ref>{{cite web|title=The Infotech 100|url=http://www.businessweek.com/interactive_reports/it100_2009.html|year= 2009|publisher=Bloomberg Business Week|accessdate=December 13, 2011}}</ref> the world’s best-performing tech companies” and Fortune’s 1000.<ref>{{cite news|title=Fortune 1000|url=http://money.cnn.com/magazines/fortune/fortune500/2009/companies/T.html|date= May 4, 2009|publisher=CNNMoney.com|accessdate=December 13, 2011}}</ref>
Line 88: Line 88:
[[Fortune (magazine)|''Fortune'' magazine]] named Teradata “Product of the Year” in 1986. Over the next four years channel connections to [[IBM]] MVS and [[Univac]] [[OS 2200|OS 1100]] mainframes were introduced, and a Teradata system over one [[terabyte]] (a trillion bytes) went live.<ref name="tdhist" />
[[Fortune (magazine)|''Fortune'' magazine]] named Teradata “Product of the Year” in 1986. Over the next four years channel connections to [[IBM]] MVS and [[Univac]] [[OS 2200|OS 1100]] mainframes were introduced, and a Teradata system over one [[terabyte]] (a trillion bytes) went live.<ref name="tdhist" />


==Technology and Products==
==Technology and products==
Teradata is a [[massive parallelism (computing)|massively parallel processing]] system running a [[shared nothing architecture]]. Teradata's Active Enterprise Intelligence technology consists of [[computer hardware|hardware]], [[software]], database, and consulting. The system moves data to a [[data warehouse]] where it can be recalled and analyzed.<ref>{{cite web|last=Pereira|first=Brian|title=Marrying Strategic Intelligence with Operational Intelligence|url=http://www.informationweek.in/Archive/10-01-01/Marrying_Strategic_Intelligence_with_Operational_Intelligence.aspx|date= January 1, 2010|work=InformationWeek|accessdate=December 13, 2011}}</ref>
Teradata is a [[massive parallelism (computing)|massively parallel processing]] system running a [[shared nothing architecture]]. Teradata's Active Enterprise Intelligence technology consists of [[computer hardware|hardware]], [[software]], database, and consulting. The system moves data to a [[data warehouse]] where it can be recalled and analyzed.<ref>{{cite web|last=Pereira|first=Brian|title=Marrying Strategic Intelligence with Operational Intelligence|url=http://www.informationweek.in/Archive/10-01-01/Marrying_Strategic_Intelligence_with_Operational_Intelligence.aspx|date= January 1, 2010|work=InformationWeek|accessdate=December 13, 2011}}</ref>


Teradata systems can be used as back-up for one another during downtime. The systems balance the work load across themselves.<ref>{{cite web|last=Howard|first=Philip|title=Dual Loading for Teradata|url=http://www.businesscomputingworld.co.uk/dual-loading-for-teradata/|date=September 8, 2010|publisher=BCW IT Leadership|accessdate=December 13, 2011}}</ref>
Teradata systems can be used as back-up for one another during downtime. The systems balance the work load across themselves.<ref>{{cite web|last=Howard|first=Philip|title=Dual Loading for Teradata|url=http://www.businesscomputingworld.co.uk/dual-loading-for-teradata/|date=September 8, 2010|publisher=BCW IT Leadership|accessdate=December 13, 2011}}</ref>


===Teradata Active Enterprise Data Warehouse===
===Active enterprise data warehouse===
Teradata Active Enterprise Data Warehouse is the platform that runs the Teradata Database 12.10, with added data management tools and [[data mining]] software.
Teradata Active Enterprise Data Warehouse is the platform that runs the Teradata Database, with added data management tools and [[data mining]] software.


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.<ref>{{cite web|last=Whitehorn|first=Mark|title=What your database needs is a good thermometer.|url=http://www.theregister.co.uk/2009/09/14/hot_and_cold_data/|date=September 14, 2009|work=The Register|accessdate=December 13, 2011}}</ref> As of October 2010, Teradata uses Xeon 5600 processors for the server nodes.<ref>{{cite web|last=Morgan|first=Timothy Prickett|title=Teradata pumps data warehouses with six-core Xeons|url=http://www.theregister.co.uk/2010/10/25/teradata_appliance_refresh/|date=October 25, 2010|work=The Register|accessdate=December 13, 2011}}</ref>
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.<ref>{{cite web|last=Whitehorn|first=Mark|title=What your database needs is a good thermometer.|url=http://www.theregister.co.uk/2009/09/14/hot_and_cold_data/|date=September 14, 2009|work=The Register|accessdate=December 13, 2011}}</ref> As of October 2010, Teradata uses Xeon 5600 processors for the server nodes.<ref>{{cite web|last=Morgan|first=Timothy Prickett|title=Teradata pumps data warehouses with six-core Xeons|url=http://www.theregister.co.uk/2010/10/25/teradata_appliance_refresh/|date=October 25, 2010|work=The Register|accessdate=December 13, 2011}}</ref>


⚫
Teradata Database 13.10 was announced in 2010 as the company’s database software for storing and processing data.<ref>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</ref><ref>Vizard, Mike. [http://www.ctoedge.com/content/teradata-extends-analytics-engine “Teradata Extends Analytics Engine.”] CTOEdge. October 25, 2010. </ref>
===Teradata Database 13.10===
⚫
Teradata Database 13.10 is the company’s database software for storing and processing data in an open parallel framework.<ref>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</ref><ref>Vizard, Mike. [http://www.ctoedge.com/content/teradata-extends-analytics-engine “Teradata Extends Analytics Engine.”] CTOEdge. October 25, 2010. </ref>


⚫
Teradata Database 14 was sold as the upgrade to 13.10 in 2011 and runs multiple data warehouse workloads at the same time.<ref>Russom, Philip. [http://tdwi.org/blogs/philip-russom/2011/09/big-data-analytics-news-from-teradata.aspx “Big Data Analytics: The News from Teradata.”] TDWI blog. September 22, 2011. </ref> It includes column-store analyses.<ref>Henschen, Doug. [http://www.informationweek.com/news/software/bi/231601992?pgno=1 “Teradata Upgrades Break Down Database Barriers.”] ''InformationWeek''. September 22, 2011. </ref>
===Teradata Database 14===
⚫
Teradata Database 14 is sold as the upgrade to 13.10 and runs multiple data warehouse workloads at the same time.<ref>Russom, Philip. [http://tdwi.org/blogs/philip-russom/2011/09/big-data-analytics-news-from-teradata.aspx “Big Data Analytics: The News from Teradata.”] TDWI blog. September 22, 2011. </ref> It includes column-store analyses.<ref>Henschen, Doug. [http://www.informationweek.com/news/software/bi/231601992?pgno=1 “Teradata Upgrades Break Down Database Barriers.”] ''InformationWeek''. September 22, 2011. </ref>


⚫
Teradata Integrated Analytics is a set of tools for data analysis that resides inside the data warehouse.<ref>Winter, Richard. InformationWeek. September 18, 2010. [http://www.informationweek.com/news/software/info_management/227500132 “Research: State of Enterprise Databases.”]</ref>
===Teradata Integrated Analytics===
⚫
Teradata Integrated Analytics is a set of tools for data analysis that resides inside the data warehouse. Analytics take place within the open parallel framework of the data warehouse.<ref>Winter, Richard. InformationWeek. September 18, 2010. [http://www.informationweek.com/news/software/info_management/227500132 “Research: State of Enterprise Databases.”]</ref>


===Backup, archive, and restore===
===Backup, archive, and restore===
Line 170: Line 167:


==="Migrate from Oracle"===
==="Migrate from Oracle"===
Teradata began the Oracle-to-Teradata Migration Program in 2000. As of October 2011, over 250 [[Oracle Corporation|Oracle]] customers completed migration to Teradata.<ref>{{cite web|title=Teradata Expands Successful Offer to Migrate Oracle Users|url=http://www.information-management.com/news/7470-1.html|date=October 1, 2003|publisher=Information Management|accessdate=December 13, 2011}}.Teradata 14 adds over 70 new functions and two new data types to reduce the effort required when moving data and porting applications to Teradata Database from Oracle, DB2 and Netezza.
Teradata began the Oracle-to-Teradata Migration Program in 2000. As of October 2011, over 250 [[Oracle Corporation|Oracle]] customers completed migration to Teradata.<ref>{{cite web|title=Teradata Expands Successful Offer to Migrate Oracle Users|url=http://www.information-management.com/news/7470-1.html|date=October 1, 2003|publisher=Information Management|accessdate=December 13, 2011}}.</ref>
</ref>


==Customers==
==Customers==
Line 178: Line 174:
*[[3M]]
*[[3M]]
*[[Aircel]]
*[[Aircel]]
*[[AT&T Inc.]] (formerly [[SBC Communications|SBC]])
*[[AT&T Inc.]] (formerly [[SBC Communications]])
*[[Aviva]]
*[[Aviva]]
*[[Bank of America]]
*[[Bank of America]]

Revision as of 19:11, 5 June 2013

Teradata Corporation
Founded1979
HeadquartersMiami Township, Ohio, United States (Miamisburg mailing address)
Key people
Michael F. Koehler, President and CEO
Bruce A. Langos, Chief Operations Officer
Stephen Brobst, Chief Technology Officer
Darryl D. McDonald, Executive Vice President and Chief Marketing Officer
ProductsIntegrated Data Warehouse Hardware and Software, Professional Services, Customer Services
Revenue$2.665 billion USD (2012)
$303 million USD (2012)
Number of employees
10,000 (2012)[1]
Websitewww.teradata.com

Teradata Corporation is an American computer company that sells database software for

NCR Corporation, Teradata was incorporated in 1979 and separated from NCR in October 2007.[2] Teradata is led by Mike Koehler, the former senior vice president of NCR.[3] Teradata's headquarters is located in Miamisburg, Ohio
.

Introduction

Teradata is an

relational database management system (RDBMS) with the same name. In February 2011, Gartner ranked Teradata as one of the leading companies in data warehousing and enterprise analytics.[4] Teradata was a division of the NCR Corporation, which acquired Teradata on February 28, 1991. Teradata's revenues in 2005 were almost $1.5 billion with an operating margin of 21%.[3] On January 8, 2007, NCR announced that it would spin-off Teradata as an independently traded company,[5] and this spin-off was completed October 1 of the same year, with Teradata trading under the NYSE stock symbol TDC.[6]

The Teradata product is referred to as a "

text analytics to track unstructured data, such as word processor documents, and semi-structured data, such as spreadsheets.[8]

Teradata's product can be used for business analysis. Data warehouses can track company data, such as sales, customer preferences, product placement, etc.[7]

In 2010, the Ethisphere Institute named Teradata as one of the "World's Most Ethical Companies."[9]

History

Timeline information taken from Teradata company history unless otherwise cited.[10]

  • 1976–1979: concept of Teradata grows from research at California Institute of Technology (Caltech) and from the discussions of Citibank's advanced technology group.[11]
  • Incorporated in 1979 in
    Brentwood, CA
    by Dr. Jack E. Shemer, Dr. Philip M. Neches, Walter E. Muir, Jerold R. Modes, William P. Worth, and Carroll Reed.
  • 1980: Enough funding for a research and development team.
  • 1983: First beta system shipped to
    Wells Fargo Bank
    .
  • 1984: Teradata releases the world's first parallel data warehouses and data marts.[12]
  • 1986:
    Fortune Magazine
    names Teradata "Product of the Year."
  • 1987: Teradata initial public offering in August
  • 1989: Teradata partners with NCR to build new database computers.
  • September 1991:
    NCR.[13]
  • December 1991: NCR announces acquisition of Teradata.[14]
  • 1992: Teradata creates the first system over 1
    Wal-Mart.[15]
  • 1994: Gartner names Teradata the "Leader in Commercial Parallel Processing."
  • 1995: IDC consulting group names Teradata number one in massively parallel processing in Computerworld Magazine.
  • 1996: A Teradata database becomes the world's largest database at 11 terabytes.
  • 1997: NCR becomes independent from AT&T.[13]
  • 1997: Teradata customer creates world's largest production database at 24 terabytes.
  • 1998: Teradata ported to Microsoft Windows NT.
  • 1999: Teradata customer has world's largest database with 130 terabytes.
  • 2000: NCR acquires Ceres Integrated Solutions and reconfigures their customer relationship management software into Teradata CRM.[16]
  • 2000: NCR acquires Stirling Douglas Group and adds its Demand Chain Management software to list of Teradata applications.[17]
  • 2002: Teradata Warehouse 7.0 launches.
  • 2003: More than 120 companies migrate from Oracle Corporation to Teradata after Oracle-to-Teradata migration program.[18]
  • 2003: Teradata University is created. Nearly 170 universities in 27 countries included in network.
  • 2004: Teradata creates partnerships with SAP[19] and Siebel Systems, Inc.[20]
  • 2005: Teradata launches Teradata Warehouse 8.1.
  • 2005: Teradata acquires DecisionPoint software[21] and rebrands it as Teradata Decision Experts.
  • 2005: Teradata adds Linux as an operating system choice for enterprise-class data warehouses.
  • 2006: Teradata launches Enterprise Master Data Management Solution.
  • 2006: Microsoft and Teradata collaborate on business intelligence application.[22]
  • 2007: NCR announces that NCR and Teradata will separate into two independent businesses.[23]
  • 2007: Intelligent Enterprise magazine names Teradata the best global data warehouse-business intelligence appliance vendor.
  • 2007: Teradata partners with DFA Capital Management, Inc.[24]
  • 2007: Agilent Technologies and Teradata established the first partnership between a data warehouse company and an instrument measurement company in order to integrate network and customer data for telecommunications industry.[25]
  • 2007: Teradata University network consists of 850 universities in 70 countries.
  • 2007: On Oct 1, Teradata completes spin-off from NCR and is traded as its own stock. Mike Koehler becomes the CEO of Teradata.[26]
  • 2007: Teradata launches Teradata 12
  • 2007: Teradata announces partnership with SAS involving further technical integration of their respective products and coordinated marketing, sales, and services activities.[27]
  • 2008: Teradata acquires Claraview.[28]
  • 2008: Teradata Purpose Built Platform Family launches.
  • 2008: Teradata Petabyte Power Players announced: a group of five Teradata customers with data warehouse environments exceeding one
    petabyte.[29]
  • 2008: Teradata Labs becomes the first to unveil a working prototype demonstrating the innovative use of solid state disk (SSD) drives in a data warehouse environment at the 2008 Teradata PARTNERS User Group Conference & Expo.[30]
  • 2008: Teradata Accelerate launches
  • 2009: Forrester Research ranks Teradata as number 1 amongst enterprise data warehousing.
  • 2009: Teradata announces that database administrators can now rewind Teradata Viewpoint monitoring applications and portlets to check database activity or performance at a specific point in time.
  • 2009: Teradata ranked among BusinessWeek’s “InfoTech 100,"[31] the world’s best-performing tech companies” and Fortune’s 1000.[32]
  • 2009: Teradata Database 13 releases
  • 2010: Teradata introduces Teradata Extreme Data Appliance 1600.
  • 2010: Teradata is named “one of the world’s most ethical companies” by The Ethisphere Institute.[33]
  • 2011: Teradata acquires Aprimo[34] and Aster Data Systems.[35]
  • 2011: Gartner names Teradata as the global leader in data warehousing databases.[36]
  • 2011: Teradata adds Aprimo Real-Time Interaction Manager to its Marketing Solution suite.
  • 2012: Teradata acquires eCircle, a direct marketing company with focus on email
  • 2013: Teradata is named a leader in Gartner's Data Warehouse DBMS Magic Quadrant in February 2013 [37]

terabyte (a trillion bytes) went live.[11]

Technology and products

Teradata is a

shared nothing architecture. Teradata's Active Enterprise Intelligence technology consists of hardware, software, database, and consulting. The system moves data to a data warehouse where it can be recalled and analyzed.[38]

Teradata systems can be used as back-up for one another during downtime. The systems balance the work load across themselves.[39]

Active enterprise data warehouse

Teradata Active Enterprise Data Warehouse is the platform that runs the Teradata Database, with added data management tools and data mining software.

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.[40] As of October 2010, Teradata uses Xeon 5600 processors for the server nodes.[41]

Teradata Database 13.10 was announced in 2010 as the company’s database software for storing and processing data.[42][43]

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

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

Backup, archive, and restore

BAR is Teradata’s backup and recovery system.[47]

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

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 solutions.[49]

Events

Acquisitions

Acquisition date Company Valuation in millions USD Purpose References
May 2, 2012 eCircle Marketing Tools
March 3, 2011 Aster Data Systems 263 MapReduce, Big Data [50][51]
December 22, 2010 Aprimo 550 Marketing tools [52][53]
August 10, 2010 Kickfire [54]
March 20, 2008 Claraview [55]
November 30, 2005 under NCR DecisionPoint Sourcing and integration of data [56]
July 14, 2000 under NCR Stirling Douglas Group Demand chain management [57]

"Migrate from Oracle"

Teradata began the Oracle-to-Teradata Migration Program in 2000. As of October 2011, over 250 Oracle customers completed migration to Teradata.[58]

Customers

Teradata customers include companies such as

Teradata also shares over 200 joint customers with MicroStrategy, including Hudson's Bay Company, Metro Group, and the USPS.[60][61]

Partners

Below is a partial list of Teradata partners.

Teradata Partners Conference

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.[69] The Teradata Partners Conference has been an annual event since 1985.[70] The conference involves lectures and speeches on technical and business topics and announcements about new products.[71]

Teradata and Big Data

Teradata began to associate itself with the term, “Big Data” in 2010. CTO, Stephen Brobst, attributes the rise of big data to “new media sources, such as social media.”[72] 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.[73]

The rise of big data resulted in many traditional data warehousing companies updating their products and technology.[74] 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.[75]

Public interest in big data resulted in a 13% increase in Teradata’s global sales.[73]

Competition

Teradata's main competitors are similar products from vendors such as

SAP and Kalido
.

Recognition

In 2009, Forrester Research issued a report, "The Forrester Wave: Enterprise Data Warehouse Platform," by James Kobielus,[77] rating Teradata the industry's number one enterprise data warehouse platform in the "Current Offering" category.

Marketing research company

Gartner Group placed Teradata in the "leaders quadrant" in its 2009, 2010, and 2012 reports, "Magic Quadrant for Data Warehouse Database Management Systems".[78][79]

Teradata is the most popular data warehouse DBMS in the DB-Engines database ranking.[80]

In 2010, Teradata was listed in

Fortune’s annual list of Most Admired Companies.[81]

Philanthropy

The Teradata Cares program is Teradata’s main philanthropic effort and community relations program. Teradata establishes volunteer efforts in communities with Teradata offices and encourages employees to participate at these programs by giving them four days a year to volunteer during working hours.[82] As of 2010, Teradata Cares was active in 45 cities in 14 countries.[83]

Teradata Cares programs include youth education programs to promote science and technology, bike and blanket donations,

United Way.[84]

Teradata has a supplier diversity program that designates a minimum of 3 to 5% of spending on minority, women, veteran, or small business vendors.[85]

References

  1. ^ "Company Profile for Teradata Corp (TDC)". Retrieved January 7, 2013.
  2. ^ "NCR Completes Teradata Spin Off". October 1, 2007.
  3. ^ a b "NCR To Spinoff Teradata". Forbes. January 9, 2007.
  4. ^ Henschen, Doug. "Garnter Ranks Data Warehousing Leaders". InformationWeek. Retrieved December 13, 2011.
  5. ^ "NCR Announces Intention to Separate into Two Independent Companies" (Press release). NCR. January 8, 2007.
  6. ^ "NCR Completes Teradata Spin Off" (Press release). NCR. October 1, 2007.
  7. ^ a b Lawson, Loraine. "How Business Logic Modeling Helps Data Warehouse Integration". IT Business Edge. Retrieved December 13, 2011.
  8. ^ Sambandaraksa, Don (August 12, 2010). "Teradata launches new text analytics". Bangkok Post. Retrieved December 13, 2011.
  9. ^ Coster, Helen (March 22, 2010). "The World's Most Ethical Companies". Forbes. Retrieved December 13, 2011.
  10. ^ "History". Teradata company website. Retrieved December 13, 2011.
  11. ^ a b Teradata Milestones
  12. ^ Pereira, Brian (January 1, 2010). "Marrying Strategic Intelligence with Operational Intelligence". InformationWeek. Retrieved December 13, 2011.
  13. ^ a b Andrews, Edmund (January 11, 1996). "AT&T Acquisition, Soon to be Spun Off, Regains NCR Name". The New York Times. Retrieved December 13, 2011.
  14. ^ "NCR, Teradata to split up". CNN Money. January 8, 2007. Retrieved December 13, 2011.
  15. ^ Hubler, David. "Teradata sees revenue growth in data consolidation". Washington Technology. Retrieved December 13, 2011.
  16. ^ "Company News; NCR Acquires Ceres Integrated in a $90 Million Deal". The New York Times. April 12, 2000. Retrieved December 13, 2011.
  17. ^ "NCR Completes Acquision of Sterling Douglas Group" (Press release). July 14, 2000. Retrieved December 13, 2011.
  18. ^ "Teradata Expands Successful Offer to Migrate Oracle Users". Information Management Online. April 27, 2009. Retrieved December 13, 2011.
  19. ^ Grant, Ian (April 27, 2009). "Users welcome integration of Netweaver and Teradata". Computer Weekly.
  20. ^ Campanelli, Melissa (April 21, 2004). "Siebel Systems, Teradata Partner". Direct Marketing News. Retrieved December 13, 2011.
  21. ^ "Teradata Acquires DecisionPoint Software". Information Management Online. December 5, 2005.
  22. ^ "Microsoft and Teradata Collaborate to Offer Business Intelligence Solutions for Mutual Customers" (Press release). Microsoft. January 15, 2007. Retrieved December 13, 2011.
  23. ^ "NCR, Teradata to split up". CNN Money. January 8, 2007. Retrieved December 13, 2011.
  24. ^ "Teradata and DFA Capital Management Announce Partnership" (Press release). DFA Capital Management. May 8, 2007. Retrieved December 13, 2011.
  25. ^ "Agilent Technologies and Teradata Establish First-of-Its-Kind Partnership to Integrate Network, Customer Data for Telecommunications Industry" (Press release). Agilent Technologies. May 21, 2007. Retrieved December 13, 2011.
  26. ^ Hagerty, John (January 9, 2007). "NCR to Spinoff Teradata". Forbes. Retrieved December 13, 2011.
  27. ^ "SAS, Teradata Expand In-database Analytics Options". EFYTimes.com. October 24, 2009. Retrieved December 13, 2011.
  28. ^ Grimes, Seth (March 20, 2008). "Teradata has Acquired BI/DW Firm Claraview". InformationWeek. Retrieved December 13, 2011.
  29. ^ Lai, Eric (October 14, 2008). "Teradata creates elite club for petabyte-plus data warehouse customers". Computerworld.
  30. ^ Jai, C.S. (October 14, 2008). "Teradata Labs Unveils SSD Data Warehouse Solution." InfoTech Spotlight". Retrieved December 13, 2011.
  31. ^ "The Infotech 100". Bloomberg Business Week. 2009. Retrieved December 13, 2011.
  32. ^ "Fortune 1000". CNNMoney.com. May 4, 2009. Retrieved December 13, 2011.
  33. ^ Coster, Helen (March 22, 2010). "The World's Most Ethical Companies". Forbes. Retrieved December 13, 2011.
  34. ^ Morgan, Timothy Prickett (December 22, 2010). "Teradata eats Aprimo for $550m". The Register. Retrieved December 13, 2011.
  35. ^ Morgan, Timothy Prickett (March 3, 2011). "Teradata snaps up Aster Data for $263m". The Register. Retrieved December 13, 2011.
  36. ^ Henschen, 2011. http://www.informationweek.com/news/software/info_management/229215658?pgno=1
  37. ^ "Dataware house DBMS magic quadrant". Dashboard Insight. February 2, 2013. Retrieved February 2, 2013.
  38. ^ Pereira, Brian (January 1, 2010). "Marrying Strategic Intelligence with Operational Intelligence". InformationWeek. Retrieved December 13, 2011.
  39. ^ Howard, Philip (September 8, 2010). "Dual Loading for Teradata". BCW IT Leadership. Retrieved December 13, 2011.
  40. ^ Whitehorn, Mark (September 14, 2009). "What your database needs is a good thermometer". The Register. Retrieved December 13, 2011.
  41. ^ Morgan, Timothy Prickett (October 25, 2010). "Teradata pumps data warehouses with six-core Xeons". The Register. Retrieved December 13, 2011.
  42. ^ 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
  43. ^ Vizard, Mike. “Teradata Extends Analytics Engine.” CTOEdge. October 25, 2010.
  44. ^ Russom, Philip. “Big Data Analytics: The News from Teradata.” TDWI blog. September 22, 2011.
  45. ^ Henschen, Doug. “Teradata Upgrades Break Down Database Barriers.” InformationWeek. September 22, 2011.
  46. ^ Winter, Richard. InformationWeek. September 18, 2010. “Research: State of Enterprise Databases.”
  47. ^ Teradata brochure. “Teradata Backup Archive Restore.”
  48. ^ Fratto, Mike. “Teradata Disaster Recovery Solution Helps Reduce the Panic of Catastrophic Events.” Network Computing. June 29, 2009.
  49. ^ IT Reseller Magazine. “Teradata announces new family of powerful analytic platforms.”
  50. ^ Morgan, Timothy Prickett (March 3, 2011). "Teradata Snaps Up Aster Data for $263m". Channel Register. Retrieved December 13, 2011.
  51. ^ Vizard, Mike (September 22, 2011). "Diversity Comes to Data Management". IT Business Edge. Retrieved December 13, 2011.
  52. ^ Morgan, Timothy Prickett (December 22, 2010). "Teradata Eats Aprimo for $550m". Channel Register. Retrieved December 13, 2011.
  53. ^ Henschen, Doug (April 9, 2011). "IT and Marketing: How Digital Media's Changing the Relationship". InformationWeek. {{cite web}}: |access-date= requires |url= (help); Missing or empty |url= (help); Unknown parameter |http://www.informationweek.com/news/software/bi/229400641?pgno= ignored (help)
  54. ^ Kanaracus, Chris (August 10, 2010). "Teradata buys analytics vendor Kickfire". Info World. Retrieved December 13, 2011.
  55. ^ Grimes, Seth (March 20, 2008). "Teradata Has Acquired BI/DW Firm Claraview". InformationWeek. Retrieved December 13, 2011.
  56. ^ "Teradata Acquires DecisionPoint(R) Software; Acquisition Extends Teradata's Financial Management Portfolio". NCR press release November 30, 2005. {{cite web}}: |access-date= requires |url= (help); Missing or empty |url= (help); Unknown parameter |http://investor.ncr.com/phoenix.zhtml?c= ignored (help)
  57. ^ "NCR Completes Acquisition of Stirling Douglas Group" (Press release). PR Newswire. July 14, 2000. Retrieved December 13, 2011.
  58. ^ "Teradata Expands Successful Offer to Migrate Oracle Users". Information Management. October 1, 2003. Retrieved December 13, 2011..
  59. ^ Customers A-Z
  60. ^ Solutions: MicroStrategy and Teradata
  61. ^ MicroStrategy Collaborates with Teradata
  62. ^ "Browse Our Partners". Teradata. Retrieved April 26, 2013.
  63. ^ Howard, Philip (September 8, 2010). "Dual Loading for Teradata". BCW. Retrieved December 13, 2011.
  64. ^ "Kalido and Teradata Team to Deliver an Agile Data Warehouse for the Mid-Market" (Press release). Kalido. October 25, 2010. Retrieved December 13, 2011.
  65. ^ "Solutions: MicroStrategy and Teradata". MicroStrategy website. Retrieved December 13, 2011.
  66. ^ "MicroStrategy Announces Teradata Support for Business Intelligence Cloud" (Press release). MicroStrategy. January 24, 2012.
  67. ^ Grant, Ian (April 27, 2009). "Users welcome integration of Netweaver and Teradata". Computer Weekly. Retrieved December 13, 2011.
  68. ^ "Browse Our Partners". Teradata. Retrieved December 13, 2011.
  69. ^ "Teradata PARTNERS User Group".
  70. ^ "Learning how small fish can eat big fish". China Daily. November 15, 2010. Retrieved December 13, 2011.
  71. ^ Wise, Lyndsay (October 22, 2009). "Wrapping Up at Teradata Partners User Group Conference". Dashboard Insight. Retrieved December 13, 2011.
  72. ^ Salah-Ahmed, Amira (May 4, 2011). "One-on-One with Teradata's CTO Stephen Brobst". The Daily Egypt News. Retrieved December 13, 2011.
  73. ^ a b Grant, Ian (April 11, 2011). "Big data boosts Teradata growth". Computer Weekly. Retrieved December 13, 2011.
  74. ^ Miniman, Stuart (March 28, 2011). "The Emerging Big Data Vendor Ecosystem". Wikibon. Retrieved December 13, 2011.
  75. ^ Kanaracus, Chris (March 3, 2011). "Teradata Buys Aster Data, Boosts "Big Data" Wares". CIO. Retrieved December 13, 2011.
  76. ^ Teradata decides to compete head-on as a data warehouse appliance vendor
  77. ^ "The Forrester Wave: Enterprise Data Warehouse Platform," by James Kobielus, February 6, 2009.
  78. ^ Donald Feinberg, Mark A. Beyer (January 28, 2011). "Magic Quadrant for Data Warehouse Database Management Systems". Gartner Group. Retrieved October 25, 2011.
  79. ^ "Magic Quadrant for Data Warehouse Database Management Systems". Gartner Group. February 6, 2012. Retrieved February 29, 2012.
  80. ^ "DB-Engines Ranking of database management systems". Retrieved April 11, 2013.
  81. ^ "WORLD'S MOST ADMIRED COMPANIES". Fortune. Retrieved October 27, 2010.
  82. ^ a b Martin, Brett (October 27, 2010). "Teradata Cares Donates Bikes and Blankets". Smart Data Collective. Retrieved December 13, 2011.
  83. ^ "Teradata Community Relations". Teradata website. Retrieved December 13, 2011.
  84. ^ "Teradata Cares". Teradata. Retrieved December 13, 2011.
  85. ^ Cogliano, Joe (November 2, 2009). "Teradata Targets Diverse Suppliers". Dayton Business Journal. Retrieved December 13, 2011.

External links

Retrieved from "https://en.wikipedia.org/w/index.php?title=Teradata&oldid=558488566"