Slashdot Mirror

← Back to Domains

Domain: teradata.com

Stories and comments across the archive that link to teradata.com.

Comments · 9

  1. Eclipse RCP + DataTools by H0p313ss · · Score: 2 · on Ask Slashdot: Linux Database GUI Application Development?

    I'm sure this won't be a very popular option because Slashdot is allergic to Java in general and Eclipse specifically, but if were trying to write multi-platform GUI code with database integration I would probably start by investigating Eclipse RCP + Datatools.

    An example of this is Teradata Studio

  2. Re:pffff by Hillview · · Score: 2, Informative · on Microsoft Files For 3 Parallel Processing Patents

    I may be wrong, but I believe the article was referring to the fact that parallel processing has been around since before Microsoft existed. Of course, Following the Links and perhaps a little research of your own will provide further insight.

  3. Teradata by kbahey · · Score: 1 · on Database Bigwigs Lead Stealthy Open Source Startup

    You just described Teradata, which has been around since 1979, and do just what you said.

    Initially, they used parallelized hardware with each "node" having its own disks, with tables partitioned, and a specialized interconnect. They then migrated all that in software.

    See the diagrams on page 4, 5 and 6 here (PDF).

  4. Teradata by kbahey · · Score: 1 · on Database Bigwigs Lead Stealthy Open Source Startup

    You just described Teradata, which has been around since 1979, and do just what you said.

    Initially, they used parallelized hardware with each "node" having its own disks, with tables partitioned, and a specialized interconnect. They then migrated all that in software.

    See the diagrams on page 4, 5 and 6 here (PDF).

  5. Re:Dammit by Jerf · · Score: 1 · on Is the One-Size-Fits-All Database Dead?
    Truly heirarchical in nature, the data is also of varying sizes, full of binary blobs, and generally unsuitable for your average SQL system.
    Actually, I was bitching about this very problem (and some others) recently, when I came upon this article about recursive queries on the programming reddit.

    Recursive queries would totally, completely solve the "hierarchy" part of the problem, and halfway decent database design would handle the rest.

    My theory is that nobody realizes that recursive queries would solve their problems, so nobody asks for them, so nobody ever discovers them, so nobody ever realizes that recursive queries would solve their problem. I don't know of an open source DB that has this, and I'd certainly never seen this in my many years of working with SQL. I wish we did have it, it would solve so many of my problems.

    Now, if we could just deal with the problem of having a key that could relate to any one of several tables in some reasonable way... that's the other problem I keep hitting over and over again.
  6. Re:No change by StarOwl · · Score: 1 · on Carnivore No More

    Hey, you forgot Wal-Mart!

    After all, they have proven skill in maintaining large databases, and everyone knows that they're trustworthy when it comes to consumer's privacy, not to mention their being an all-around good corporate citizen.

  7. Re:The problem with clustering in Linux... by ID10T5 · · Score: 1 · on Flattening Out The Linux Cluster Learning Curve
    Some types of applications, it's easy to visualize how to get a dozen or a hundred computers to help with the problem (serving static web pages). Others, it's not (databases)

    Databases may not be easy, but they have been done (http://www.teradata.com/). Not sure if I'd call it a "typical cluster", but I can't say that any cluster is typical. Current Teradata stuff doesn't do Linux, but they're going there as I type.

  8. Re:The problem with clustering in Linux... by ID10T5 · · Score: 1 · on Flattening Out The Linux Cluster Learning Curve
    Some types of applications, it's easy to visualize how to get a dozen or a hundred computers to help with the problem (serving static web pages). Others, it's not (databases)

    Databases may not be easy, but they have been done (http://www.teradata.com/). Not sure if I'd call it a "typical cluster", but I can't say that any cluster is typical. Current Teradata stuff doesn't do Linux, but they're going there as I type.

  9. Wal-Mart's Datawarehouse is NCR Teradata by kbahey · · Score: 1 · on Advertising Via GPS
    [Marketing people look for that magic connection called the Beer-Pampers theory. Wal-mart keeps one of the largest marketing databases ever, over 300 terrabytes. They found that customers that buy pampers usually buy beer also, and vice versa. So they put the beer and the pampers in the same aisle and increased their sales on those two products by over 80%. This will be a goldmine for companies like Informix who make one of the best databases for Data Warehousing.]

    First, why do Beer and Pampers get sold together? The theory is that the wife picks up the groceries in the sedan, and leaves the bulky stuff for the husband (often driving the SUV). She asks the husband to pick up the Pampers, and while he is at it, he also gets the beer.

    Wal-Mart uses their datawarehouse as a HUGE competitive weapon. K-Mart uses the same technology (see below) and have not gotten much competitive advantage off it. The reason is that Wal-Mart analyze detail data, but K-Mart analyzes sample branch.

    Wal-Mart uses extensive research to open new branches. This includes demographic, driving distance, average household income, ...etc. They know that the average customer drives 17 minutes to shop at a Wal-Mart, and passes two K-Marts and a Target on the way!

    By the way, the visionary behind their datawarehouse (Randy Mott) left them after two decades, and joined another company.

    By the way, their datawarehouse is probably the largest commercial database, and it runs on NCR Massively Parallel hardware (Worldmark), and the really unique Datawarehousing Optimized database called Teradata

    I know, because I used Teradata, and work for NCR :-)

    Recently, Travelocity and E-Trade joined the who's-who list of Teradata users (British Airways, Bank of America, Wal-Mart, Delta Airlines, Royal Bank of Canada, and tons more).

    Basically, if you have a large amount of data to analyze, (specially 500 GB or more, the more the better :-), don't use Informix, nor Oracle nor IBM DB2: Teradata just shines!