blocks|key|5277261|text|在谷歌搜索"Teradata+Best+Practices“的首位，我得到了TERADATA+ADVISORY+GROUP+SETS+BEST+PRACTICES+FOR+BUSINESS+OBJECTS+AND+TERADATA+CUSTOMERS|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|5277262|编辑:正如你所指出的，这只是广告，看看你是如何使用这些的。请记住，我对Teradata是什么一无所知，也看不到我自己在公元22世纪的任何时候都会使用它。|5277263|5277264|Teradata+Discussion+Forums|unordered-list-item|5277265|Best+Practices+for+Teradata+Deployments|5277266|Best+Study+Guides+For++NCR+Teradata+Certifications|5277267|5277268|中间的看起来很有希望，因为它的顶部有很长的链接树|5277269|Oracle®业务智能应用程序安装和配置指南>+|5277270|+BI应用程序的预安装和预部署注意事项>+Oracle业务分析仓库的Teradata特定数据库指南>|blockquote|5277271|5277272|5277273|第一个链接，到论坛，应该能让你接触到合适的人。|5277274|entityMap|0|LINK|mutability|MUTABLE|url|http://www.businessobjects.com/pdf/partners/teradata_advisory_group.pdf|1|http://www.teradata.com/teradataForum/|2|http://download.oracle.com/docs/cd/E12104_01/books/AnyInstAdm/AnyInstAdmPreInstall12.html|3|http://www.eplanetlabs.com/vendors/Teradata.htm^0|12|2F|0|0|0|0|0|Q|1|0|0|13|2|0|0|1E|3|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1D|8|@]|9|@$A|1E|B|1F|1|1G]]|C|$]]|$1|D|3|E|5|6|7|1H|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|1I|8|@]|9|@]|C|$]]|$1|G|3|H|5|I|7|1J|8|@]|9|@$A|1K|B|1L|1|1M]]|C|$]]|$1|J|3|K|5|I|7|1N|8|@]|9|@$A|1O|B|1P|1|1Q]]|C|$]]|$1|L|3|M|5|I|7|1R|8|@]|9|@$A|1S|B|1T|1|1U]]|C|$]]|$1|N|3|-4|5|6|7|1V|8|@]|9|@]|C|$]]|$1|O|3|P|5|6|7|1W|8|@]|9|@]|C|$]]|$1|Q|3|R|5|6|7|1X|8|@]|9|@]|C|$]]|$1|S|3|T|5|U|7|1Y|8|@]|9|@]|C|$]]|$1|V|3|-4|5|6|7|1Z|8|@]|9|@]|C|$]]|$1|W|3|-4|5|6|7|20|8|@]|9|@]|C|$]]|$1|X|3|Y|5|6|7|21|8|@]|9|@]|C|$]]|$1|Z|3|-4|5|6|7|22|8|@]|9|@]|C|$]]]|10|$11|$5|12|13|14|C|$15|16]]|17|$5|12|13|14|C|$15|18]]|19|$5|12|13|14|C|$15|1A]]|1B|$5|12|13|14|C|$15|1C]]]]

Top of the list on a Google search for "Teradata Best Practices" gave me <a href="http://www.businessobjects.com/pdf/partners/teradata_advisory_group.pdf" rel="nofollow noreferrer">TERADATA ADVISORY GROUP SETS BEST PRACTICES FOR BUSINESS OBJECTS AND TERADATA CUSTOMERS</a>

EDIT: Seeing as that's just advertising, as you've pointed out, see how you go with these. Please bear in mind that I don't have a clue what Teradata is and can't see myself using it any time this side of the 22nd century AD.

<ul>
<li><a href="http://www.teradata.com/teradataForum/" rel="nofollow noreferrer">Teradata Discussion Forums</a></li>
<li><a href="http://download.oracle.com/docs/cd/E12104_01/books/AnyInstAdm/AnyInstAdmPreInstall12.html" rel="nofollow noreferrer">Best Practices for Teradata Deployments</a></li>
<li><a href="http://www.eplanetlabs.com/vendors/Teradata.htm" rel="nofollow noreferrer">Best Study Guides For NCR Teradata Certifications</a></li>
</ul>

The middle one looks promising with it's nice long link tree at the top

<blockquote>
 Oracle® Business Intelligence Applications Installation and Configuration Guide > Preinstallation and Predeployment Considerations for Oracle BI Applications > Teradata-Specific Database Guidelines for Oracle Business Analytics Warehouse >
</blockquote>

and the first link, to the forums, should put you in touch with the right people.

blocks|key|5277314|text|我不知道网上有什么好的参考资料。Teradata有一些可供下载的设计手册，但它们更多的是说明手册，而不是“最佳实践”。点击这里查看：http://www.info.teradata.com/DataWarehouse/eTeradata-BrowseBy.cfm?page=Teradata%2520Database|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|5277315|或者，您需要找到一位友好的Teradata专家来反省您的想法。尝试Teradata本身，或者找到具有Teradata经验的当地顾问。|5277316|Teradata上的最佳实践不是一个引起很多讨论的话题，大多数最佳技巧往往是发现它们的人/人的专有知识。|5277317|抱歉，David+Stewardson+Satyam计算机服务|5277318|entityMap|0|LINK|mutability|MUTABLE|url|http://www.info.teradata.com/DataWarehouse/eTeradata-BrowseBy.cfm?page=Teradata%2520Database^0|1U|2I|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]]]

I don't know of any good references available online. Teradata has some design manuals that are available for download, but they're more instruction manuals and not "best practices" as such. check them out here: <a href="http://www.info.teradata.com/DataWarehouse/eTeradata-BrowseBy.cfm?page=Teradata%20Database" rel="nofollow noreferrer">http://www.info.teradata.com/DataWarehouse/eTeradata-BrowseBy.cfm?page=Teradata%20Database</a>

Alternatively, you need to find a friendly Teradata expert to bounce ideas off. Try Teradata themselves, or find a local consultant with Teradata experience.

Best Practices on Teradata isn't a topic that gets lots of discussions and most of the best tricks tend to be proprietary knowledge of the person/people who discovered them.

Sorry,
David Stewardson
Satyam Computer Services

blocks|key|2197369|text|可以从这里开始：http://www.teradataforum.com/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2197370|这可能有点晚了，但我可以警告你一些关于Teradata的事情，我已经学到了。|2197371|尽可能多地使用最新版本。对于V12，优化器已重新编写，数据库现在的性能要好得多。试着认识到SQL+Server和Teradata是非常不同的东西，大多数概念都不会很好地过渡。不要低估主索引的重要性。与其他数据库相比，teradata使用的锁非常原始。请勿使用TERA模式。你没有任何遗留的代码，ANSI模式是非常优秀的，并且得到了广泛的鼓励。连接索引是非常有用的工具，但它们并不能提供所有的答案。并行，花时间了解FASTLOAD、MULTILOAD和TPUMP是如何工作的，并了解如何将其与ETL策略结合使用。如果您试图运行需要高性能的查询，请不要使用任何强制转换，优化器将不会使用统计信息来生成最佳执行计划。处理日期将是一件痛苦的事情，只是一个警告。Teradata是非常面向DDL的，在创建表时请尝试理解所有相关的语法。压缩是一个很棒的工具，如果你在表格中有任何重复的值，请使用它。Teradata提供的工具并不多，请准备好构建很多工具。现有的工具非常昂贵。|2197372|不幸的是，我对SQL+Server了解不多，所以我不能说出SQL+Server中的哪些工具出现在Teradata中。|2197373|希望这能有所帮助|2197374|entityMap|0|LINK|mutability|MUTABLE|url|http://www.teradataforum.com/^0|8|T|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|Y|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|Z|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|10|8|@]|9|@]|C|$]]|$1|L|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]]]

One place to start is here: <a href="http://www.teradataforum.com/" rel="noreferrer">http://www.teradataforum.com/</a>

This might be a little late, but there are a few things which I can warn you about Teradata which I have learned.

Use the most recent version as often as possible.
 For V12 the optimizer was re-written and the database performs much better now. 
 Try to realize that SQL Server and Teradata are very different beasts, most of the concepts will not transition well.
 Do not underestimate the importance of a primary index.
 The locks that teradata uses are very primitive when compared to other databases.
 Do NOT use TERA mode. You do not have any code which is legacy, ANSI mode is far superior and is widely encouraged.
 Join indexes are very helpful tools, but they do not provide all the answers.
 Parallelism, take the time to understand how FASTLOAD, MULTILOAD, and TPUMP works and find out how one can leverage it with their ETL strategy.
 If you are attempting to run a query which needs to be performant, do not use any casts, the optimizer will not use statistics to generate the best execution plan.
 Working with dates are going to be a pain, just a warning.
 Teradata is very DDL oriented, try to understand all the syntax related when creating a table.
 Compression is a wonderful tool, if you have any values which are repeated in a table, make use of it.
 There are not many tools available with Teradata, be prepared to build a lot. The tools that exist are very expensive. 

Unfortunately, I do not know much about SQL Server, so I cannot say what tools in SQL Server appear in Teradata.

Hope this helps

blocks|key|2197394|text|我还会看看最近发布的Teradata+Developer+Exchange以及Teradata主网站上的TeradataForum和论坛。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2197395|entityMap|0|LINK|mutability|MUTABLE|url|http://developer.teradata.com/^0|A|R|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I would also look into the recently launched <a href="http://developer.teradata.com" rel="nofollow noreferrer">Teradata Developer Exchange</a> as well as the TeradataForum and forums on Teradata's main website.

Looks like my data warehouse project is moving to Teradata next year (from SQL Server 2005).

I'm looking for resources about best practices on Teradata - from limitations of its SQL dialect to idioms and conventions for getting queries to perform well - particularly if they highlight things which are significantly different from SQL Server 2005. Specifically tips similar to those found in <a href="https://rads.stackoverflow.com/amzn/click/com/0596008945" rel="noreferrer" rel="nofollow noreferrer">The Art of SQL</a> (which is more Oracle-focused).

My business processes are currently in T-SQL stored procedures and rely fairly heavily on SQL Server 2005 features like PIVOT, UNPIVOT, and Common Table Expressions to produce about 27m rows of output a month from a 4TB data warehouse.

Can you recommend a good source for Teradata Best Practices?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

看起来我的数据仓库项目将在明年(从SQL Server2005)迁移到Teradata。我正在寻找有关Teradata的最佳实践的资源-从其SQL方言的限制到使查询执行良好的习惯用法和约定-特别是如果它们突出显示了与SQL Server 2005显著不同的内容。具体地说，技巧类似于中的技巧(它更专注于甲骨文)。我的业务...

问你能推荐一个好的Teradata最佳实践来源吗？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问你能推荐一个好的Teradata最佳实践来源吗？EN