Category Archives: Business intelligence

How Good Is Teradata’s Intelligent Memory?

Jason asked a great question in the comment section here… he asked… does Teradata’s Intelligent Memory erode HANA’s value proposition?  Let me answer here in a more general way that is applicable to the general database space… Every time a vendor puts more silicon between the CPU and the disk they will improve their performance […] Continue reading

Posted in Business intelligence, data warehouse, data warehousing, Database Architecture, EDW, HANA, IMDB, in-memory database, Netezza, Teradata | Tagged , , , , | Leave a comment

Memory Trends and HANA

If the Gartner estimates here are correct… then DRAM prices will fall 50% per year per year over the next several years… and then in 2015 non-volatile RAM (see the related articles below) will become generally available. It has been suggested that memory prices will fall slower than data warehouses will grow (see here). That does not seem to […] Continue reading

Posted in Business intelligence, Computer memory, data warehouse, data warehousing, Dynamic random-access memory, EDW, Flash memory, HANA, hardware, IBM, IMDB, in-memory database, Netezza, Non-volatile memory, Non-volatile random-access memory, TechTarget | Tagged , , | Leave a comment

A Teradata Prediction Comes True… and Wondering About Netezza…

If you missed the tweet… 2+ years ago I predicted here that Teradata would go away from ByNet… and lo and behold they did (see here). In the same post I predicted that Netezza would go away from FPGAs. This has not come to pass. But I wonder if it might… or if there is a [...] Continue reading

Posted in Business intelligence, data warehouse, data warehousing, Database Architecture, Database Hardware, EDW, Greenplum, Netezza | Tagged , , , , | Leave a comment

A Teradata Prediction Comes True… and Wondering About Netezza…

If you missed the tweet… 2+ years ago I predicted here that Teradata would go away from ByNet… and lo and behold they did (see here). In the same post I predicted that Netezza would go away from FPGAs. This has not come to pass. But I wonder if it might… or if there is a [...] Continue reading

Posted in Business intelligence, data warehouse, data warehousing, Database Architecture, Database Hardware, EDW, Greenplum, Netezza | Tagged , , , , | Leave a comment

A Teradata Prediction Comes True… and Wondering About Netezza…

If you missed the tweet… 2+ years ago I predicted here that Teradata would go away from ByNet… and lo and behold they did (see here). In the same post I predicted that Netezza would go away from FPGAs. This has not come to pass. But I wonder if it might… or if there is a […] Continue reading

Posted in Business intelligence, data warehouse, data warehousing, Database Architecture, Database Hardware, EDW, Greenplum, Netezza | Tagged , , , , | Leave a comment

The Five Minute Rule and Teradata Memory Utilization

I have mentioned now and again that Teradata‘s architecture which writes intermediate results to spool violates the Five Minute Rule may be a poor design choice. Let me make this case more clearly. The Five Minute Rule was developed by Gray and Putzolu to determine where the trade-off is between keeping data in-memory and writing [...] Continue reading

Posted in Business intelligence, data warehouse, data warehousing, Database Hardware, EDW, HANA, IMDB, in-memory database, Netezza, Teradata | Tagged , , , , | Leave a comment

MPP, IMDB and Moore’s Law

In the post here I listed the units of parallelism (UoP) applied by various products on a single node. Those findings are summarized in the table below. Product Version/HW Cores per Node UoP per Node Notes Teradata EDW 6700H 16 32 Uses hyper-threads. Greenplum DCA UAP Edition 16 8 Recommends 1 Segment for each 2 […] Continue reading

Posted in Business intelligence, Central processing unit, data warehouse, data warehousing, Database Architecture, Database Hardware, EDW, Greenplum, Greenplum Database, HANA, IBM, IMDB, in-memory database, ivy bridge, Moore, Moore's law, Multi-core processor, Netezza, Oracle Exadata, Shared nothing architecture, Teradata | Tagged , , , , | Leave a comment

MPP on HANA, Exadata, Teradata, and Netezza

6 May… There is a summary of this post and on the comments here.  - Rob 17 April… A single unit of parallelism is a core plus a thread/process to feed it instructions plus a feed of data. The only exception is when the core uses hyper-threading… in which case 2 instructions can execute more-or-less […] Continue reading

Posted in Business intelligence, data warehouse, data warehousing, Database Hardware, Database Servers, EDW, Field-programmable gate array, FPGA, Greenplum, HANA, Netezza, Oracle Exadata, SPARC, Teradata | Tagged , , , , , , | Leave a comment

Some Unaudited HANA Performance Numbers

The following performance numbers are being reported publicly for HANA: HANA scans data at 3MB/msec/core On a high-end 80-core server this translates to 240GB/sec per node HANA inserts rows at 1.5M records/sec/core Or 120M records/sec per node… Aggregates 12M records/sec/core Or 960M records per node… These numbers seem reasonable: A 100X improvement over disk-based scan […] Continue reading

Posted in Business intelligence, data warehouse, data warehousing, EDW, Greenplum, Greenplum Database, HANA, Netezza, SAP, SAP HANA | Tagged , | Leave a comment

Rackspace acquires Database-as-a-Service provider ObjectRocket

Announcement: Says acquisition will help customers scale MongoDB in the Cloud

Featured

Add to Awards Page: 
0

Alternate Author: 
DatacenterDynamics FOCUS
Rackspace Hosting ha… Continue reading

Posted in Business intelligence, business news, Colocation & Hosting, Company News, data analysis, data center acquisition, data center news, data centre news, data cneter hosting, Enterprise IT, Global, ICT, Industry News, IT Optimization, Netezza, North America, ObjectRocket, operator, Rackspace, technology news, United States, USA | Tagged , , | Leave a comment