Cisco与华为网络设备图标详解

需积分: 49 9 下载量 132 浏览量 更新于2024-08-14 收藏 9.39MB PPT 举报
该资源是一份关于计算机通信类的PPT图标集合,涵盖了各种设备图标、拓扑图标以及计算机相关的图标。图标涉及的品牌包括Cisco、H3C和Huawei等知名厂商,展示了不同类型的网络设备和终端设备。 主要内容中提到了多种网络设备和服务器类型,如: 1. **SIP硬终端** 和 **H.323硬终端**:这两种都是IP语音(VoIP)通信的硬件设备,SIP(Session Initiation Protocol)是用于建立和管理多媒体通信会话的协议,而H.323是ITU制定的一个多媒体通信标准,用于IP网络上的音视频通信。 2. **普通电话**:传统的模拟电话,通过公共交换电话网(PSTN)进行通信。 3. **PC、Uniphone、U-PATH、IP超市话务台、OpenEye**:这些可能是特定品牌的软电话、IP电话或者综合通信解决方案,用于实现IP网络上的语音和数据通信。 4. **网络云图** 和 **IP私网**:网络云图通常表示互联网或广域网的抽象概念,IP私网是指使用私有IP地址段的内部网络,与外部网络通过路由器或NAT设备隔离。 5. **HUB、LANSwitch**:HUB是早期的局域网连接设备,负责数据帧的广播;LAN Switch(局域网交换机)则提供更高的带宽和更智能的数据转发功能,能减少网络冲突。 6. **PSTN/ISDN云图**:PSTN(Public Switched Telephone Network)是传统的公共电话交换网络,ISDN(Integrated Services Digital Network)是一种数字电话网络,提供比PSTN更高的数据传输速率。 7. **Cisco图标** 包括了各种路由器、交换机、服务器、网络管理设备等,如: - **Router**:路由器用于连接不同的网络,实现数据包的转发。 - **Switch**:交换机用于同一网络内的设备间高速通信。 - **Workstation**:工作站,通常指高性能的个人电脑。 - **Terminal Server**:终端服务器,允许多个远程用户接入并共享服务器的计算资源。 - **Access Server**:访问服务器,提供网络接入服务。 - **CiscoWorks**:Cisco的网络管理工具,用于监控和管理网络设备。 - **其他还包括PC Router、Server with PC Router Software、Bridge、Workgroup Switch等**。 8. **H3C和Huawei图标** 也代表了各自的网络设备产品,虽然没有具体列出,但它们可能包括类似路由器、交换机等网络基础设施设备。 这些图标和设备在实际的网络设计、部署和管理中都有重要作用,它们构成了复杂的网络架构,支持着现代通信和数据传输的需求。对于理解和学习网络技术,了解这些设备及其功能至关重要。

SELECT PIS.SHOW_FLT_DETAIL AS SHOW_FLT_DETAIL -- new , PIS.SHOW_AWB_DETAIL AS SHOW_AWB_DETAIL -- new , PIS.DISPLAY_AIRLINE_CODE AS CARRIER_CODE , DECODE(PIS.REVERT_FLOW,'N',PIS.FLOW_TYPE,DECODE(PIS.FLOW_TYPE,'I','E','I')) AS FLOW_TYPE , PIS.SHIP_TO_LOCATION AS SHIP_TO_LOCATION , PIS.INVOICE_SEQUENCE AS INVOICE_SEQUENCE , PFT.FLIGHT_DATE AS FLIGHT_DATE , PFT.FLIGHT_CARRIER_CODE AS FLIGHT_CARRIER_CODE , PFT.FLIGHT_SERIAL_NUMBER AS FLIGHT_SERIAL_NUMBER , PFT.FLOW_TYPE AS AIRCRAFT_FLOW , FAST.AIRCRAFT_SERVICE_TYPE AS AIRCRAFT_SERVICE_TYPE , PPT.AWB_NUMBER AS AWB_NUMBER , PPT.WEIGHT AS WEIGHT , PPT.CARGO_HANDLING_OPERATOR AS CARGO_HANDLING_OPERATOR , PPT.SHIPMENT_PACKING_TYPE AS SHIPMENT_PACKING_TYPE , PPT.SHIPMENT_FLOW_TYPE AS SHIPMENT_FLOW_TYPE , PPT.SHIPMENT_BUILD_TYPE AS SHIPMENT_BUILD_TYPE , PPT.SHIPMENT_CARGO_TYPE AS SHIPMENT_CARGO_TYPE , PPT.REVENUE_TYPE AS REVENUE_TYPE , PFT.JV_FLIGHT_CARRIER_CODE AS JV_FLIGHT_CARRIER_CODE , PPT.PORT_TONNAGE_UID AS PORT_TONNAGE_UID , PPT.AWB_UID AS AWB_UID , PIS.INVOICE_SEPARATION_UID AS INVOICE_SEPARATION_UID , PFT.FLIGHT_TONNAGE_UID AS FLIGHT_TONNAGE_UID FROM PN_FLT_TONNAGES PFT , FZ_AIRLINES FA , PN_TONNAGE_FLT_PORTS PTFP , PN_PORT_TONNAGES PPT , FF_AIRCRAFT_SERVICE_TYPES FAST , SR_PN_INVOICE_SEPARATIONS PIS --new , SR_PN_INVOICE_SEP_DETAILS PISD--new , SR_PN_INV_SEP_PORT_TONNAGES PISPT --new WHERE PFT.FLIGHT_OPERATION_DATE >= trunc( CASE :rundate WHEN TO_DATE('01/01/1900', 'DD/MM/YYYY') THEN ADD_MONTHS(SYSDATE,-1) ELSE ADD_MONTHS(:rundate,-1) END, 'MON') AND PFT.FLIGHT_OPERATION_DATE < trunc( CASE :rundate WHEN TO_DATE('01/01/1900', 'DD/MM/YYYY') THEN TRUNC(SYSDATE) ELSE TRUNC(:rundate) END, 'MON') AND PFT.TYPE IN ('C', 'F') AND PFT.RECORD_TYPE = 'M' AND (PFT.TERMINAL_OPERATOR NOT IN ('X', 'A') OR (PFT.TERMINAL_OPERATOR <> 'X' AND FA.CARRIER_CODE IN (SELECT * FROM SPECIAL_HANDLING_AIRLINE) AND PPT.REVENUE_TYPE IN (SELECT * FROM SPECIAL_REVENUE_TYPE) AND PPT.SHIPMENT_FLOW_TYPE IN (SELECT * FROM SPECIAL_SHIPMENT_FLOW_TYPE) AND PFT.FLIGHT_OPERATION_DATE >= (select EFF_DATE from SPECIAL_HANDLING_EFF_DATE) )) AND PFT.DELETING_DATETIME IS NULL AND FA.AIRLINE_UID = PFT.AIRLINE_UID AND FA.DELETING_DATETIME IS NULL AND PTFP.FLIGHT_TONNAGE_UID = PFT.FLIGHT_TONNAGE_UID AND PTFP.RECORD_TYPE = 'M' AND PTFP.DELETING_DATETIME IS NULL AND PPT.TONNAGE_FLIGHT_PORT_UID (+)= PTFP.TONNAGE_FLIGHT_PORT_UID AND PPT.RECORD_TYPE (+)= 'M' AND PPT.DISCREPANCY_TYPE (+)= 'NONE' AND PPT.ADJUSTMENT_INC_FLAG (+)= 'Y' AND PPT.DELETING_DATETIME (+) IS NULL AND FAST.AIRCRAFT_SERVICE_TYPE_UID = PFT.AIRCRAFT_SERVICE_TYPE_UID AND FAST.DELETING_DATETIME IS NULL AND PIS.TEMPORAL_NAME = TO_CHAR((CASE :rundate --new WHEN TO_DATE('01/01/1900', 'DD/MM/YYYY') THEN TRUNC(SYSDATE) ELSE TRUNC(:rundate) END ), 'YYYYMM') || '00' AND PIS.INVOICE_SEPARATION_UID = PISD.INVOICE_SEPARATION_UID --new AND PISD.INVOICE_SEP_DETAIL_UID = PISPT.INVOICE_SEP_DETAIL_UID --new AND PISPT.PORT_TONNAGE_UID = PPT.PORT_TONNAGE_UID --new AND PIS.PRINT_SUPPORTING_DOC = 'Y';上面是oracle的写法,请转成spark SQL的写法。

2023-06-02 上传