1 / 21

SQL*NET

SQL*NET. Wizards. Course. OSI Overview : Matching the model to reality. Frédéric Hemmer CERN. Zürich 14-18 June 1989. Today's computers OSI layers overview Bridges, Routers and Gateways Decnet, TCP/IP SQL*Net Common questions SQL*Net example : CERN Performance

zonta
Download Presentation

SQL*NET

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL*NET Wizards Course OSI Overview : Matching the model to reality Frédéric Hemmer CERN Zürich 14-18 June 1989

  2. Today's computers OSI layers overview Bridges, Routers and Gateways Decnet, TCP/IP SQL*Net Common questions SQL*Net example : CERN Performance Conclusions OSI Overview:Matching the model to reality

  3. Single user operating system Monotasking operating system Limited (expensive) disk space availability Usually no native networking Availability of resource sharing systems Very good dedicated user interface PC's and MAC's

  4. Multitasking operating system Multiuser operating system Higher disk space availability Native networking Resource sharing by means of standards Good (distributed) windowing interface A lot of CPU dedicated to the user interface Workstations

  5. Multitasking operating system Multiuser time-shared operating system High (cheap) disk space availability No native multi-vendor networking Resource sharing by means of standard protocols Weak user interface Little CPU used for the user interface Mainframes

  6. ISO/OSI Reference Model Application Presentation Session Transport Network Data Link Physical

  7. ISO/OSI Reference Model Application FTP, Telnet, FTAM, Set host, RDA Presentation ISO/CCITT presentation (X409) Session ISO/CCITT session Transport TCP, UDP, NSP, TP0 -> TP4 Network X25, IP,CLNS,CONS Data Link HDLC, SDLC, LAPB LLC, 802.x Physical RS232, CSMA/CD IBM TR, FDDI

  8. MAC-Level Bridges

  9. Decnet Phase IVlayers User Network Management Network Application Session Control Network Services Transport Data Link Physical

  10. OSI Application Decnet Phase Vlayers Naming Service Application DNA Application Presentation Session Control DNA Session Control Transport Network Data Link Physical

  11. TCP/IP layers Telnet, FTP, SMTP, Name Server, r-series, NFS (+ Sun RPC), User programs TCP/UDP IP/ICMP/ARP Drivers/Controllers Physical

  12. SQL*Net layers User Oracle UPI OPI Two-Task Common Two-Task Common OSN Transport Network Data Link Physical

  13. I understood protocols upper layers are independent of the data link layer. So, why should I buy an Excelan Ethernet board to run TCP/IP on my Microsoft / Intel PC? Problem #1

  14. I understood protocols like TCP/IP are standards. So, why does the Oracle installation procedure for SQL*NET TCP/IP on VMS ask me which TCP/IP (Wollongong orExcelan) ? Similarly, why does SQL*NET TCP/IP not work for CMU TCP/IP which is almost free ? Problem #2

  15. Oracle provides a SQL*NET driver for TCP/IP on IBM's 6150 (RT/PC). What should I do to make it work over IBM's Token ring using TCP/IP ? Problem #3

  16. I'm a newcomer in the networking world. What networking protocol should I use ? What SQL*NET networking protocol should I use if I have the choice ? Problem #4

  17. SQL*NET Topologyat CERN Siemens 7890 S VM/HPO CTC VTAM IBM 3090/600 6 VF - VM/XA 3725 Cray X/MP 48 CLC SNA (LU 6.2) Sun 3732 8232 TCP Decnet ... IP Central VAX/VMS Cluster LAVC LEP LAVC PS Ultrix Apollo Ultrix Ultrix TCP Ultrix RT PC Ultrix Ultrix IPX TCP TCP Fastpath TCP Novell Sun Appletalk Mac Mac IBM PC IBM PC Mac IBM PC Mac IBM PC Mac Mac IBM PC Mac IBM PC IBM PC Apollo

  18. The LEP Control System

  19. LEP Control System Software Architecture

  20. Performance ms Decnet Tcp/Ip Local KB

  21. ISO protocols being specified ISO protocols not yet fullyimplemented. Interim solutions. SQL*Net hides the protocol for the user. Better use of computers Oracle will have to provide SQL*Net/ISO Conclusions

More Related