"计算机组装与维护54683ppt课件.ppt 一窥计算机基础知识和发展历程"

0 下载量 178 浏览量 更新于2024-01-22 收藏 1.84MB PPT 举报
本节课程《计算机组装与维护54683ppt课件.ppt》从计算机的基本知识出发,着重介绍了初步认识计算机、计算机的发展历程、计算机的分类、用途和发展方向以及计算机的系统结构等内容。通过本课程的教学,学生们得以全面了解计算机的硬件体系结构、基本工作过程和硬件系统等知识,使得对计算机有了更加深入的理解和认识。 首先,课程介绍了计算机的基本知识。计算机,俗称电脑,是一种用于高速计算的电子计算器,具有进行数值计算和逻辑计算,以及存储记忆等功能。计算机是一种能够按照程序运行,自动、高速处理海量数据的现代化智能电子设备。通过对计算机的基本知识的介绍,学生们对计算机的本质和作用有了更加清晰的理解。 其次,课程详细讲解了计算机的发展历程。从1946年美国宾夕法尼亚大学诞生世界上第一台电子数字计算机ENIAC开始,一直到目前的计算机技术发展的现状,学生们了解到了计算机从最初的巨大体积到如今的微型化、便携化的发展历程,对计算机技术的进步和演变有了更加直观和具体的认识。 再者,课程介绍了计算机的分类、用途和发展方向。从原理上计算机可以分为数字式计算机、模拟式电子计算机和数模混合式电子计算机,而从用途上分为通用计算机和专业计算机。同时,根据规模和性能特点可分为巨型计算机、大型计算机、小型计算机、微机、工作站、服务器等。此外,课程还介绍了计算机在各行各业中的广泛用途,包括科学计算、数据处理、自动控制、辅助设计、辅助教学、人工智能和娱乐活动等。同时,课程还指出了计算机未来的发展方向,使得学生对计算机技术的前景有了更为清晰的认识。 最后,课程通过计算机的软件系统进行了介绍。通过了解计算机软件系统的相关内容,学生们对计算机的体系结构和工作过程有了更加深入的了解,同时也为今后学习计算机软件相关知识打下了坚实的基础。 总的来说,本课程内容详实丰富,对计算机组装与维护有了更加全面的了解。通过学习本课程,同学们不仅加深了对计算机硬件和软件系统的认识,也了解了计算机的发展历程和发展方向。这些知识为今后的学习和工作打下了坚实的基础,同时也为同学们未来的职业规划提供了更多的选择和发展空间。

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 上传