Help! Diff between Teradata SQL and Oracle SQL. - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Help! Diff between Teradata SQL and Oracle SQL.

Help! Diff between Teradata SQL and Oracle SQL.# Database - 数据库

s*r2010-10-05 07:10

1 楼

Never use Teradata before and will touch it now. I know there are some
structure differences between teradata and oracle. Now I am more interested
in for database user, sql, what's the difference between them.
I have a very old sql bible which covers oracle, DB2, sql server but no
teradata.
Any suggestion? Thanks,

c*e2010-10-05 07:10

2 楼

mostly performance related

interested

【在 s******r 的大作中提到】

: Never use Teradata before and will touch it now. I know there are some
: structure differences between teradata and oracle. Now I am more interested
: in for database user, sql, what's the difference between them.
: I have a very old sql bible which covers oracle, DB2, sql server but no
: teradata.
: Any suggestion? Thanks,

s*r2010-10-05 07:10

3 楼

I know performance is the key. However that's the problem of DBA. As a user,
I hope to have some reference that tell detail of the difference.
For instance, different function, primary index define, commit, volatile,
like(?) table.
I do not want to go through teradata from the very beginning. If find such
book/web, I can focus on the different part. It could save some time.

【在 c*******e 的大作中提到】

: mostly performance related
:
: interested

B*g2010-10-05 07:10

4 楼

http://download.oracle.com/docs/cd/B28359_01/gateways.111/b31050/toc.htm

user,

【在 s******r 的大作中提到】

: I know performance is the key. However that's the problem of DBA. As a user,
: I hope to have some reference that tell detail of the difference.
: For instance, different function, primary index define, commit, volatile,
: like(?) table.
: I do not want to go through teradata from the very beginning. If find such
: book/web, I can focus on the different part. It could save some time.

s*s2010-10-05 07:10

5 楼

commit is not used often in teradata, assuming warehouse environment.
PI is a key concept. it is used to hash your data in a table.
SQL functions in td are relatively limited. SQL itself is very different
between the two. you need to play with both. stats are imprtant in td and
developers need to know stats.
which version of td, 12 or 13?

【在 s******r 的大作中提到】

s*r2010-10-05 07:10

6 楼

Thanks for all your help.
From the document I read, without commit, no result would be saved, commit
is necessary for my system. Sounds it is only setting of our teradata? You
are right, stats is also important.
I realized the difference and hope to get a comparison book/web.
Our system is 13.

【在 s******s 的大作中提到】

: commit is not used often in teradata, assuming warehouse environment.
: PI is a key concept. it is used to hash your data in a table.
: SQL functions in td are relatively limited. SQL itself is very different
: between the two. you need to play with both. stats are imprtant in td and
: developers need to know stats.
: which version of td, 12 or 13?

w*r2010-10-05 07:10

7 楼

Teradat 13??? yoru company is brave!!!!!

commit
You

【在 s******r 的大作中提到】

: Thanks for all your help.
: From the document I read, without commit, no result would be saved, commit
: is necessary for my system. Sounds it is only setting of our teradata? You
: are right, stats is also important.
: I realized the difference and hope to get a comparison book/web.
: Our system is 13.