Components of Teradata

Teradata is made up of following components –

Processor Chip – The processor is the BRAIN of the Teradata system. It is responsible for all the processing done by the system. All task are done according to the direction of the processor.

Memory – The memory is known as the HAND of the Teradata system. Data is retrieved from the hard drives into memory, where processor manipulates, change or alter the data. Once changes are made in memory, the processor directs the information back to the hard drive for storage.

Hard Drives – This is known as the SPINE of the Teradata system. All the data of the Teradata system is stored in the hard drives. Size of hard drives reflects the size of the Teradata system.


Teradata has Linear Scalability

One of the most important asset of Teradata is that it has Linear Scalability. There is no limit on Teradata system. We can grow it to as many times as we want. Any time you want to double the speed of Teradata system, just double the numbers of AMPs and PE. This can be better explained with the help of an example –

Teradata takes every table in the system and spread evenly among different AMPs. Each Amp works on the portion of records which it holds.

Suppose a EMPLOYEE table has 8 different employee id’s. Now in a 2 AMP system each AMP will hold 4 rows in its DISK to accommodate total 8 rows.

2 AMP SYSTEM

At the time of data retrieval each AMP will work on its DISK and send 4 rows to PE for further processing. If we suppose, one AMP will take 1 microseconds (MS) to retrieve 1 rows, then the time taken to retrieve 4 rows is 4 MS. And as we know that AMPs work in parallel, so both the AMPs will retrieve all 8 records in 4 MS only (4 MS time for each AMP).

Now we double the AMP in our system, and we use total 4 AMP. As Teradata distribute the records evenly among all AMPs, so now each AMP will store 2 records of the table.

4 AMP SYSTEM

Now according to our time scale, the time taken by each AMP for retrieving 2 records is 2MS.

So all 4 AMPs, working parallel, will retrieve the 8 records in 2MS only. Which was previously 4MS for the 2 AMP system.

Hence we double our speed by doubling the number of AMPs in our system.

This is the power of parallelism in Teradata. It is also known as ‘DIVIDE and CONQUER’ theory, according to which we are dividing the work equally and getting the result faster. To achieve the desirable speed we can increase the number of AMPs accordingly.

Related PostTeradata Architecture


113 comments

Skip to comment form

  1. Attractive component to content. I simply stumbled upon your
    weblog and in accession capital to say that I get in fact loved account your blog posts.
    Any way I’ll be subscribing on your augment or even I achievement you access consistently
    quickly.

  2. bokep, bokep indo, porn, website penipu, bokep 3gp, sex, porno, xnxx, website scam,
    scam, penipu11:29

  3. Hi there! I just wish to give you a huge thumbs up for your great information you have
    got here on this post. I’ll be coming back to your web site for more soon.

  4. I do not even know how I ended up here, but I thought this post
    was great. I do not know who you are but certainly you’re going
    to a famous blogger if you aren’t already 😉 Cheers!

  5. Fantastic web site. A lot of helpful information here.
    I am sending it to a few buddies ans also sharing in delicious.
    And of course, thank you in your sweat!

  6. Do you have any video of that? I’d care to find out some additional information.

  7. Does your site have a contact page? I’m having a tough time locating
    it but, I’d like to send you an e-mail. I’ve got
    some recommendations for your blog you might be interested in hearing.

    Either way, great blog and I look forward to seeing it
    develop over time.

  8. مولتی ویتامین رول وان با بیش از ۵۰ ماده فعال، شامل ۲۴ ویتامین و ماده معدنی ضروری، آمینو اسیدها، آنزیم‌های گوارشی، و عصاره‌های گیاهی، یک سر و گردن از مولتی ویتامین‌های بازاری بالاتر است.

  9. Hey! I know this is sort of off-topic however I had to ask.

    Does building a well-established website like yours take a large amount
    of work? I’m completely new to running a blog
    however I do write in my journal everyday. I’d like
    to start a blog so I can easily share my experience and feelings online.
    Please let me know if you have any kind of recommendations or tips for
    new aspiring bloggers. Thankyou!

  10. free fire max diamond top up, free fire india top up, codashop free fire
    top up, free fire diamond top up, free fire top up,
    garena free fire top
    up, free fire max top up, top up free fire max, top up free fire, top-up
    garena free fire, free fire diamonds top up, garena ff diamond top up,
    garena free fire max top up, top up ff max, free fire diamond shop,
    garena free fire top up diamonds, free fire top up offer, free fire
    diamond buy, ff diamond top up, ff diamonds top up, free fire diamonds
    buy, free fire id top up, free fire account top up, free fire max top up
    center, ff max top-up, ff top up, garena topup free fire, free
    fire
    top-up, free fire top up website in india, free fire top
    up codashop,
    garena top up center ff, free fire top up diamonds, free fire top up
    diamond, garena diamond top up free fire, top up diamond free fire
    codashop, double diamond top up codashop, free fire top up centre, free
    fire top up center, codashop free fire max paytm, diamonds free fire top
    up, diamond free fire top up, free fire special airdrop
    top up online,
    top up free fire diamond, top up free fire diamonds, codashop com free
    fire, garena free fire max top up center, garena free fire topup, free
    fire diamond recharge, diamond top-up free fire, free
    fire diamond top
    up app, free fire diamond top up site, garena free fire diamond top up,
    free fire diamond top up website, monthly membership in free fire, free
    fire garena top up, codashop ff top up, free fire top-up website, top up
    in free fire, garena free fire max diamond top up, garena free fire max
    diamonds top up, free fire diamonds top up app,
    free fire double diamond
    top up codashop, free fire diamond purchase, free fire top up india,
    winzo free fire diamond top up, free fire diamonds purchase,
    diamond top
    up in free fire, codashop free fire diamond india,
    free fire top up app,
    free fire topup, shop garena sg diamond, shop garena sg diamonds,

    freefire topup discount, top up garena free fire max, shop garena
    free
    fire diamond, freefire top up, top up game free fire, top
    up game free
    fire max, free fire online top up, free fire paytm top up, free
    fire top
    up paytm, free fire diamond topup, top up for free fire, free fire
    top
    up shop, free fire top up website, garena top up
    centre free fire,
    garena ff id top up, garena top up diamond, free fire game top up, free
    fire top up offers, free fire diamond store, coda shop diamond ff, free
    fire top up link, free fire top up live, free fire top up websites, top
    up app for free fire, top up app for free fire max, free fire top
    up
    recharge, free fire top ups, online free fire top up, online free fire
    top up max, free fire top up apps, garena free fire top up website,
    free
    fire airdrop top up online, free fire monthly membership top up, free
    fire diamond top up karo, diamond top up ff, seagm free fire, free fire
    diamond top up paytm, free fire top up upi, free
    fire official top up,
    top up website free fire, ggtopup free fire, seagm free fire top up,
    diamond top up website, ff top up codashop,
    free fire diamond top up
    garena, codashop free fire double diamond, free fire uid top up, free
    fire uid top up india, free fire uid top up online, best ff top up site,
    best free fire top up site, best free fire top up website, cheap diamond
    top up website, instant free fire top up, instant ff top up, buy free
    fire diamonds, purchase free fire diamonds, cheap free fire diamonds,
    cheapest free fire top up, affordable ff diamonds, trusted
    free fire top
    up, secure free fire top up, official free fire top up, free fire
    recharge, ff recharge, free fire recharge online, free fire recharge
    india, free fire recharge upi, free fire recharge paytm, free
    fire
    recharge phonepe, free fire recharge google pay,
    free fire recharge
    website, free fire recharge app, instant diamond top
    up, instant diamond
    delivery, free fire digital top up, online diamond purchase, free fire
    booyah pass, buy booyah pass, free fire weekly membership, buy
    weekly
    membership, free fire evo access, evo access top up, free fire level up
    pass, premium diamond top up, gaming recharge website, free fire gift
    card, ff gift card, free fire voucher, ff voucher, free
    fire online
    store, free fire recharge portal, ff recharge portal, 100 diamond top
    up, 310 diamond top up, 520 diamond top up, 1060 diamond top up, 2180
    diamond top up, 5600 diamond top up, buy free fire max diamonds,
    instant
    free fire max top up, free fire max recharge, free fire max recharge
    online, ff max recharge, ff max diamonds, trusted diamond seller,
    verified gaming recharge, 24×7 free fire top up, fast ff recharge, quic k
    free fire recharge
    , DOUBLE DIAMOND TOP UP, double diamonds top up, games kharido, game kharido, top up
    free fire, fre fire top-up, top up free fire, free fire game top up

  11. Asking questions are genuinely fastidious thing if you
    are not understanding something completely, however this article
    offers good understanding even.

  12. Heya just wanted to give you a brief heads up and let you
    know a few of the pictures aren’t loading correctly.

    I’m not sure why but I think its a linking issue. I’ve tried it
    in two different browsers and both show the same outcome.

  13. Keep on working, great job!

  14. I every time emailed this webpage post page to all my friends, because if like to
    read it then my contacts will too.

  15. فیتنس مکمل منبع بهترینهای مکمل فیتنس اروجینال، برای افرادی است که به سلامت و زیبای اندام خود، و کیفیت و اصالت مکمل ورزشی اهمیت میدهند.

  16. bookmarked!!, I really like your blog!

  17. کراتین ماسل مدز
    در واقع فرم میکرونایزد و بسیار خالص کراتین مونوهیدرات است، وقتی شما کراتین ماسل مدز را مصرف می‌کنید، در واقع در حال پر کردن ذخایر فسفوکراتین عضلات
    خود هستید.

  18. I used to be recommended this blog by means of my cousin. I’m no longer certain whether this submit is written through him
    as no one else realize such unique approximately my problem.
    You’re wonderful! Thanks!

  19. I’m not sure why but this blog is loading very
    slow for me. Is anyone else having this problem or is it
    a problem on my end? I’ll check back later
    and see if the problem still exists.

  20. I was skeptical about the cost of professional landscaping but the results have been worth every single penny The
    crew worked quickly and cleanly leaving the property in absolutely
    perfect condition when they finished the job
    The service covers everything from basic lawn mowing all the way up to
    complete landscape redesign and renovation projects I highly recommend this
    landscaping service to any homeowner who wants to seriously improve their outdoor living space

  21. Hello there! This is kind of off topic but I need some advice from an established blog.
    Is it very difficult to set up your own blog? I’m not very techincal but I can figure things
    out pretty quick. I’m thinking about making my own but I’m
    not sure where to begin. Do you have any ideas or suggestions?
    Thanks

  22. It’s an awesome piece of writing designed for all the online people; they
    will get advantage from it I am sure.

  23. I like the helpful information you provide in your articles.
    I will bookmark your weblog and check again here frequently.
    I’m quite sure I will learn many new stuff right here! Good
    luck for the next!

  24. This is the right webpage for anyone who hopes to understand this topic.
    You understand a whole lot its almost tough to argue with you
    (not that I really will need to…HaHa). You
    definitely put a brand new spin on a subject that’s been discussed
    for decades. Great stuff, just great!

  25. Thanks for some other excellent article.

    The place else could anyone get that kind of information in such an ideal approach of writing?
    I’ve a presentation subsequent week, and I’m at the look for such information.

  26. Good day! Do you use Twitter? I’d like to follow you if that
    would be okay. I’m undoubtedly enjoying your blog and look forward to new updates.

  27. Fantastic items from you, man. I’ve take note your stuff prior to and you are simply too excellent.

    I actually like what you’ve obtained here, really like what you are stating and the way in which in which you are saying it.

    You make it entertaining and you still care for to keep it wise.
    I can not wait to learn much more from you. That is actually a terrific website.

  28. We’re a group of volunteers and starting a new scheme in our community.
    Your web site offered us with valuable info to work on. You
    have done a formidable job and our whole community will be thankful to you.

  29. Have you ever considered about including a little bit more than just your articles?
    I mean, what you say is fundamental and everything.

    Nevertheless imagine if you added some great pictures
    or videos to give your posts more, “pop”! Your content is excellent but with
    images and clips, this website could undeniably be one of
    the most beneficial in its field. Superb blog!

  30. It’s difficult to find educated people about this topic, but you seem like you know
    what you’re talking about! Thanks

  31. This is a very informative post about online casinos and betting platforms.
    I especially liked how it explains the importance of
    choosing a licensed site before signing up.

    Many players often ask where they can find reliable gaming platforms with fair odds
    and smooth payouts. From what I’ve seen, checking platforms
    like vn22vip helps users compare features, bonuses, and overall experience.

    Thanks for sharing these insights — they’re helpful for both beginners and experienced bettors.

  32. This is a very informative post about online casinos and betting platforms.
    I especially liked how it explains the importance
    of choosing a licensed site before signing up.

    Many players often ask where they can find reliable gaming platforms
    with fair odds and smooth payouts. From what I’ve seen, checking platforms like vn22vip helps users compare features, bonuses,
    and overall experience.

    Thanks for sharing these insights — they’re
    helpful for both beginners and experienced bettors.

  33. This excellent website definitely has all the info I wanted concerning this subject and didn’t know who to ask.

  34. We stumbled over here from a different website and thought I
    should check things out. I like what I see so now
    i’m following you. Look forward to exploring your web page again.

  35. Postingan yang sangat informatif! Informasi ini
    sangat relevan dengan tren industri game saat ini yang mulai
    mengadopsi kecerdasan buatan. **1131GG** berhasil membedakan diri sebagai **Platform Game Online dengan Analisis RTP
    & Pola Berbasis AI** yang memberikan nilai tambah nyata bagi penggunanya.
    Ini bukan sekadar platform biasa, tetapi solusi cerdas berbasis
    data. Terima kasih sudah berbagi wawasan ini! Kunjungi 1131GG – AI Game Platform

  36. Sopariwala offers premium tobacco leaves for
    cigarette and tobacco product manufacturers in Bangladesh.
    Explore Black Chopadia, Calcutti, Lal Chopadia, and Rustica whole and dried tobacco leaf varieties.
    Tobacco manufacturers in Dhaka, Chattogram, Khulna, Rajshahi, Sylhet, and Rangpur can request a quotation now.

  37. Post writing is also a excitement, if you be familiar with afterward you
    can write otherwise it is complex to write.

  38. Asking questions are actually good thing if you are not understanding something
    entirely, except this article provides pleasant understanding even.

  39. This is a very informative post about online casinos and betting platforms.
    I especially liked how it explains the importance of choosing
    a secure site before signing up.

    Many players often ask where they can find reliable gaming platforms with
    fair odds and smooth payouts. From what I’ve seen, checking platforms
    like vn22vip helps users compare features, bonuses, and overall experience.

    Thanks for sharing these insights — they’re helpful for both beginners
    and experienced bettors.

  40. Provide pickup, destination, date and service details to receive a moving proposal tailored
    by ADI MOVING. https://adimoving.co.il/en/quote

  41. hi!,I really like your writing so so much!
    proportion we be in contact extra approximately your article on AOL?
    I require an expert in this house to solve my problem.
    Maybe that’s you! Looking forward to look you.

  42. Postingan yang sangat informatif! Ulasan ini sangat membantu khususnya bagi pengguna
    yang ingin kemudahan transaksi tanpa hambatan. **Slot QRIS Indonesia**
    hadir sebagai solusi **Platform Game Online dengan Pembayaran QRIS
    Cepat** yang sangat praktis. QRIS memang jadi primadona pembayaran digital, dan platform ini sukses mengintegrasikannya dengan baik.
    Terima kasih sudah berbagi! Kunjungi Slot QRIS Indonesia

  43. To guarantee genuine online privacy, an anti-detect browser does not merely block data
    transfers—it thoroughly replicates the characteristics of an actual physical device.
    It enables the setup of isolated browsing sessions, each generating
    a distinct digital fingerprint that appears entirely natural to
    websites, while also linking to an individual proxy server.
    From the perspective of tracking systems, each separate session resembles an entirely fresh user,
    accessing the internet from a different machine and location. This approach prevents any
    crossover between profiles and can help bypass even the most advanced tracking
    mechanisms employed by major corporations.

  44. Υ᧐u actually make it seem so easy with your presentation but
    I in findіng this matter to be really something that I fеel
    I might by noo means understand. It srt of feels too
    complicated and extremely wԁe for me. I’m
    having a look forward for your subsequent submit, Ӏ’ll attsmpt to get the hold of it!

    Here іs my blog post – hargatoto

  45. We’re a bunch of volunteers and opening a brand new scheme in our community.
    Your site offered us with helpful info to work on. You have done a
    formidable task and our whole group will likely be grateful to
    you.

  46. Thanks for the marvelous posting! I seriously enjoyed reading
    it, you could be a great author. I will remember to bookmark your blog and may come back very
    soon. I want to encourage you to ultimately continue your great work, have a nice day!

  47. Nice post. I learn something totally new and challenging on blogs I stumbleupon everyday.

    It will always be interesting to read through content from other writers and use a little
    something from their websites.

  48. I just like the helpful info you provide to your articles.
    I’ll bookmark your weblog and take a look at again here frequently.
    I’m moderately sure I’ll be informed a lot of new stuff proper here!

    Best of luck for the next!

  49. Hi there! This post could not be written much better!

    Reading through this article reminds me of my previous roommate!
    He always kept talking about this. I am going to send this post to him.
    Pretty sure he will have a very good read.
    Many thanks for sharing!

  50. I am genuinely happy to read this web site posts which
    contains tons of useful facts, thanks for providing these data.

    Have a look at my homepage – trx wallet address generator

  51. I don’t even know how I finished up here, however I believed this submit used to be great.
    I do not know who you might be however certainly you are going to a famous blogger when you
    are not already. Cheers!

  52. What i don’t realize is actually how you are now not actually a lot more neatly-liked than you may be right now.
    You are so intelligent. You realize therefore considerably on the
    subject of this matter, produced me in my view consider it from so many various angles.
    Its like men and women are not fascinated except it’s
    something to do with Girl gaga! Your own stuffs excellent.
    At all times handle it up!

  53. Have you ever thought about publishing an e-book or guest authoring on other blogs?
    I have a blog based on the same ideas you discuss and would really like to have you share some stories/information. I know my
    visitors would appreciate your work. If you are even remotely interested, feel free to send me an e-mail.

  54. Aw, this was an exceptionally nice post.
    Finding the time and actual effort to make a top notch article… but what can I say… I hesitate
    a lot and don’t seem to get nearly anything done.

  55. You actually make it appear so easy with your presentation however I find this matter to be really something that I think I’d never understand.
    It sort of feels too complicated and extremely wide for me.

    I’m having a look forward in your subsequent post, I’ll attempt to get the dangle of it!

  56. Fantastic items from you, man. I have have in mind your stuff prior to and you are simply too magnificent.
    I really like what you’ve received right here, certainly like what you’re stating
    and the way in which by which you say it. You are making it enjoyable and you continue to take care of to stay it
    sensible. I can not wait to learn much more from you. That
    is really a terrific site.

  57. Hello everyone, it’s my first pay a quick visit at this
    site, and post is in fact fruitful in support of me, keep up posting these articles or reviews.

  58. As soon as I noticed this internet site I went on reddit to share some of the love with them.

  59. Its like you read my mind! You appear to know so much about this,
    like you wrote the book in it or something. I think that you could do with some
    pics to drive the message home a bit, but other than that, this is
    great blog. An excellent read. I’ll definitely be back.

  60. I’m very happy to find this page. I want to to thank
    you for ones time for this fantastic read!! I definitely liked every part of it and I have you saved as a favorite to check out new information on your web site.

  61. My brother suggested I may like this website. He was totally
    right. This submit actually made my day. You can not consider simply how a lot time I had spent for this information! Thank you!

  62. ConextSolution adalah konsultan ERP dan transformasi digital yang membantu
    organisasi meningkatkan efisiensi operasional
    melalui ERP system, Business Intelligence, dan integrasi sistem.
    Sebagai odoo consultant indonesia, kami menyediakan layanan implementasi odoo serta pengembangan sistem ERP untuk bisnis.
    Kami melayani berbagai sektor industri termasuk ERP manufacturing indonesia dan industri retail.
    Dengan pengalaman dalam implementasi ERP perusahaan,
    kami membantu bisnis membangun sistem yang lebih
    terintegrasi, efisien, dan siap berkembang di era digital.

    Kunjungi https://conextsolution.com

  63. Its such as you read my thoughts! You seem to understand so much
    approximately this, such as you wrote the book in it
    or something. I think that you simply could do with some % to pressure the message home a bit, but instead
    of that, that is excellent blog. An excellent read.
    I’ll definitely be back.

  64. Hi there, yes this piece of writing is genuinely good and I have learned lot
    of things from it concerning blogging. thanks.

  65. Thanks for the good writeup. It actually was once a enjoyment account it.
    Glance complex to more brought agreeable from you! However, how can we be in contact?

  66. If some one desires to be updated with most recent technologies afterward he must be pay a visit this web
    site and be up to date daily.

  67. Link exchange is nothing else except it is just
    placing the other person’s website link on your page at proper place and other person will also do similar in favor of you.

  68. I’m gone to convey my little brother, that he should also go to see this web site on regular basis to take updated from latest information.

  69. Hi there colleagues, its impressive article concerning teachingand
    entirely defined, keep it up all the time.

  70. Sweet blog! I found it while surfing around on Yahoo News.
    Do you have any suggestions on how to get listed in Yahoo News?

    I’ve been trying for a while but I never seem to get there!

    Many thanks

  71. I like the helpful information you provide in your articles.
    I will bookmark your blog and check again here frequently.
    I’m quite sure I’ll learn plenty of new stuff right here!
    Good luck for the next!

  72. I enjoy reading an article that can make people think.
    Also, thank you for allowing me to comment!

  73. Hmm is anyone else having problems with the images
    on this blog loading? I’m trying to determine if its a problem on my end
    or if it’s the blog. Any feed-back would be greatly appreciated.

  74. Hi, its pleasant piece of writing on the topic of media print, we all know
    media is a fantastic source of information.

  75. Thanks , I’ve just been looking for info approximately
    this subject for a while and yours is the best I’ve discovered so far.
    But, what concerning the conclusion? Are you certain about the source?

  76. I’m truly enjoying the design and layout of your website. It’s a
    very easy on the eyes which makes it much more enjoyable for
    me to come here and visit more often. Did you hire out a developer to create your theme?
    Exceptional work!

  77. My family members every time say that I aam wastong my tike hede at net,
    exceplt I knoww I amm gettijng know-how dailyy by reaing tthes good articles.

    Heere is my site :: redwap.pro

  78. I’m nnot sur why butt this weblg iis loading incrediblky skow for me.
    Is anyoje ese having this issue oor iss itt a isesue on myy end?
    I’ll chheck bacfk latr onn and ssee iff tthe probem strill exists.

  79. If you want to improve your experience simply keep visiting this
    web site and be updated with the newest news update posted here.

  80. Looking for a site with a massive game collection? Afunjogo has it all! Slots, live casino, sports… tons of options! Check out afunjogo

  81. What’s up, fam? Been playing a55game and it’s keeping me entertained. Good graphics and fun gameplay. Give it a whirl: a55game

  82. Yo, check out fi777! Heard some good things, might be a decent spot to try your luck. Anyone else had any good experiences? Let me know!

    • Navi on May 5, 2017 at 3:41 pm
    • Reply

    Hi,

    If I double the AMP, performance would double. But, if I double the data and also double the AMPs, what would be the performance then?

    1. In that case, performance will be constant.
      you will not see any performance degradation because of double data.

    • Sneha Naik on July 26, 2016 at 1:18 am
    • Reply

    Hi Admin,

    Could you explain the data distribution in the case of multiple tables.

    If I had 3 tables , tables A B and C.

    Table A has 2 records
    B has 7 records
    C has 10 records.

    How does the data distribution take place and how is it decided ?? Which component in the architecture decides on the distribution of rows of data.

    Thanks,
    Sneha

    1. Each AMP stores a certain portion of each table. Meaning, ideally each AMP will have some rows of each table which is defined in Teradata (exceptions possible).

      To know more about the data distribution please move to the topic – http://www.teradatatech.com/?p=470

      Online Teradata Training –
      http://www.mytechentity.com/courses/teradata-development/

    • aiman sarosh on September 3, 2015 at 8:12 am
    • Reply

    Hi Admin,
    Great article..really helpful. but i have a question here about AMP and PE.
    Does PE and AMP work like master-slave architecture?…like in hadoop (name-node and data-node) ?. if yes, then how can we increase the number of PE, since we can have only one master and multiple slaves ?

    I am a hadoop SME, so trying to correlate the two.

    Regards,
    Aiman

    1. in teradata AMP and PE both are actually virtual processors (VPROCS), number of VPROCS in Teradata can be modify with actual NODE processor and memory.

    • PRIYANKA CHOUDHARY on January 30, 2015 at 4:57 pm
    • Reply

    hii,
    I m new to tera data ,can u suggest me some good ebooks for teradata.

    1. you can go for the e-books by Tera-Tom or material available on Teradata website itself.

    • Gokul on January 7, 2015 at 12:03 pm
    • Reply

    Good !!!
    Increasing PE s or AMP s , does it reflect in any other parameter increase ?/

    • Gokul on January 7, 2015 at 12:02 pm
    • Reply

    Good !!!
    Increasing PE s or AMP s increases any cost?

    • Vladek on December 17, 2014 at 12:11 am
    • Reply

    I hate unexplained acronyms. ‘AMP’, ‘PE’ ????

    1. AMP = Access module processor
      PE = Parsing Engine

    • Shirish on September 6, 2014 at 12:57 pm
    • Reply

    Great job Admin.

    I have a question here.
    you are saying we can double the AMPs and PEs ( while u are explaining about linear scalability )
    Can we also double the PEs ? Bcoz, I can’t see multiple PEs anywhere in pictures.

    Please explain.

    —Shirish

    1. Hi Shirish,

      Yes we can double PEs as well because PE is also one of the VPROC(virtual processor) running inside the node memory.

  83. Hi Admin,

    Its really a good article. Wish to learn more .

    regards!

    • nilesh mali on December 8, 2013 at 6:08 pm
    • Reply

    Fantastic explanation…………..great job…………….

    • Shuhbodeep on September 17, 2013 at 4:59 am
    • Reply

    It was really a great presentation. However can you explain how hashing algorithm works in TD?? I have been listening this HA word from past one year but never got a single positive response from any of the ADMIN. Hope this will be my last post for this question

    1. the hashing algorithm is the usual hashing process available in any programming language. This is implemented as a C code inside Teradata optimizer. If you want to know about the code a quick google on ‘hashing algorithm example’ will help you.

    • Monisha on May 10, 2013 at 5:44 am
    • Reply

    Dear Admin,
    Even I would like to take the classes. Please let me know the procedure,

    1. http://teradatatech.com/OTT_Home.html

  84. I am an admn. person. But somehow I want to learn teradata as I was challenged by friends that I can’t learn Teradata without any relative background. But I feel that data does not relate or belong to any particular field and it is a general and at the same time special and very powerful tool of Data Management and its uses. Depending upon the grey matter of the person handling this tool, I strongly believe that “Sky is the only limit” for its usage. This is the basic reason why I want learn this “Wonderful and Evergreen” subject. I hope my ambition is appreciated in the right spirit.

    I am a novice to IT field in general and TeraData in particular. I am a B.Com. graduate and superannuated from Central Government service recently. I want to utilise some of my time now for learning this useful subject. Thanks.

    Laxmi, M.S.

    1. Hi Laxmi,

      Your amibition is great and yes you have said all correct words 🙂

      btw are you interested in taking Teradata classes ?
      let me know …

      Thanks

        • praveen kumar reddy on October 2, 2012 at 8:28 am
        • Reply

        Hi Admin,

        I am intrested to attend the classes. please let me know the procedure.
        Thanks for your articals which are well benifited for beginners like me. 🙂

        Regards,
        Praveen

    • rashid on July 22, 2012 at 5:22 pm
    • Reply

    do you have a printable versions of he tutorials so that i can print them out and study them when ever i want and highlight the main ideas of the article

    1. Now you can take the print out directly from the website.

    • Abhishek on February 23, 2012 at 10:56 am
    • Reply

    Hi,

    Am newbie on teradata and exploring it .

    With in the AMP does teradata has MPP and shared nothing functionality ?

    In other words for single AMP does teradata has different server process having their own memory and disks.

    From explanation it is cleared that PE doesn’t contain any user data i hope 🙂 but How HA is achieved in teradata,is it like data residing on one AMP the same data would be present on another AMP in case of node failure to achieve no single point of failure.

    The basics concept is mentioned very clearly and thanks for that but a bit explanation on my doubts would be appreciated.

    Thanks
    Abhishek

    • PriyaSudheer on January 5, 2012 at 5:08 am
    • Reply

    Fantastic explanation….!!! gr8 job….

    • Plastic Surgeon on March 6, 2011 at 10:18 pm
    • Reply

    Kudos for the great article. I am glad I have taken the time to learn this.

    1. thanks 🙂

Leave a Reply

Your email address will not be published.