Archives of the TeradataForum

Message Posted: Thu, 18 Oct 2001 @ 19:22:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Paul:

Thanks for the tips and the comments. We are using mid-range servers for Oracle but a potential customer uses Teradata so your comments on the scalability and maintenance will become handy.

As I read the Teradata documentation it becomes clear that its features are very good compared to Oracle's.

Could you tell me if this outline is correct regarding equivalent components between Oracle and Teradata?

What I think,

TeraData                Oracle
----------              ----------
BTEQ                    SQL/PLUS
C Preprocessor  *Pro C
Cobol Preprocessor      *Pro Cobol
PL/I Preprocessor       Nothing
CLI                     OCI     (I am really not sure on this one)
TDP                     NET8 (aka. SQLNET) (Not sure on this one either)
MTDP/MOSI               No idea of what it might be. Any ideas?
Archive/Restore RMAN
FastExport              exp utility
Fastload                imp utility
MultiLoad               SQL Loader
TeraData Manager        Oracle Enterprise Manager

Also, on what platforms does the TeraData Server run? So far from the documentation I found that TeraData runs on NCR systems, Windows (NT and/or 2000) and Mainframes running MVS, VM. How about UNIX servers such as Solaris, AIX, and HP-UX?

Where I am really lost is in the equivalence for CLI, TDP, and MTDP/MOSI. How do they map into the Oracle World?

My take on how the Oracle side works is (please correct me if I am wrong):

1) A C program with Embedded SQL is run through a C Preprocessor which results in a C program with OCI Calls. (Likewise, a Java program making JDBC calls ends up using the OCI layer via the JDBC drivers)

2) The OCI calls interface with NET8 (aka SQLNET). NET8 is really the protocol used by Oracle to connect among clients and servers.

3) NET8 (aka SQLNET) interfaces with the next layer (TCP/IP, SNA, etc.).

4) The data flow goes on through Ethernet, Token Ring, Frame Relay, etc to the other side.

5) Return data follows the same path in reverse.

How could these steps be paraphrased using the Teradata environment?

Robert.

	<Prev	Next>		<<First	<Prev	Next>	Last>>