Archives of the TeradataForum
Message Posted: Thu, 18 Oct 2001 @ 19:22:21 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|