|
总体来说,TeraData是数据仓库领域的先行者, 专攻大型OLAP市场, 而Oracle, IBM都是从OLTP发家的,数据仓库只是后期逐步介入的。 这样TeraData处于业内领先地位也很好理解。不过从下面的列表上看得出来,技术上3这没有什么明显差距,基本上Oracle > IBM >= TeraData,对标准的支持上也差不多这样,而且很多feature/solution, TeraData很依赖第三方的partner,显得前景不是很妙。当然OLAP这样的市场,先行一步是个巨大的优势,很多企业几十年也不会更换这些基础IT设施的。
[size=11.6667px]Summary of Key Differences
In order to better summarize how we see Oracle Enterprise Edition vs. IBM DB2 UDB ESE (on UNIX and Windows) and NCR Teradata, we’ve prepared a couple of tables comparing key features and indicators using information publicly available from all three vendors. The first table includes comparisons related to scalability and performance:
| Oracle | IBM UDB | NCR TeraData | Static Bitmap Indeces | Yes
| No | Limited | Materialized views | Yes, fact & dimension with SQL rewrite, bitmap join indexes | Yes, fact with SQL rewrite | Join indexes only, no automatic SQL rewrite | ANSI SQL analytic functions | Yes | Yes | Some analytics, standard? | OLAP in database | Yes,in RDBMS with SQL or Java API | Partial with DB2 OLAP | No, typically partner | Data mining | Yes, in RDBMS with Java API | Yes, with extender | Yes | NUMA, 64-bit platform support | Yes, 64-bit since early 1990s, NUMA since mid-1990s | Yes, since 2000 | No, future 64-bit | MPP, cluster support | Yes, clusters since 1980s, MPP since 1991 | Yes, since 1995 | Yes MPP; limited Windows cluster support since 2001 | Multi-TB customers | Yes, on HP Alpha, HP, IBM, Linux, Sun | Yes, on IBM | Yes, on NCR | Range, List partitioning | Yes | No, UNION ALL workaround | Range since V2R5 | Resource manager | Yes, CPU utilization, query cost, queues & reprioritization in RDBMS | External tool | Priority scheduler | Summary advisor | Yes | No | No | Sub-minute fail over | Yes, with RAC | No | Doubles disk | Extended security (ACL, row label…) | Yes | No | No | Traditional ETL Support | Yes, in RDBMS & Warehouse Builder | Yes, in Data Warehouse Center | High speed load optional, Informatica | Queuing | Yes, AQ / Streams in database | Yes, MQSeries middleware | Partner solution from TIBCO | Extended data types | Yes, included in RDBMS | Yes, with extenders | Limited partner solutions | XML in database | Yes | Yes | Partner solution | OMG CWM meta model standard | Yes | Yes | No | | | | |
|
|