计算机硬件基本知识,计算机硬件_基本知识.ppt

计算机硬件_基本知识

二、认识计算机硬件 硬盘 几个主要指标 容量:指硬盘能存储的数据量大小,以字节为基本单位 单碟容量:硬盘都是由一个或几个小的盘片组成的,单碟容量就是指包括正两面在内的单个碟片的总容量 转速:即主轴马达转动速度,单位为RPM(Round Per Minute),即每分钟盘片转动圈数 缓存:是硬盘控制器上的一块内存芯片,具有极快的存取速度,它是硬盘内部盘片和外部接口间的缓冲器。 常用指标 常用指标 杨策药扇抢薪呛珠砍萧蓖郡活氯澎皂取谱横及轰赡怠贷尔侈胺泼粒喀纱译计算机硬件_基本知识计算机硬件_基本知识 二、认识计算机硬件 硬盘 平均访问时间:硬盘磁头找到目标数据所需的平均时间 平均寻道时间:磁头寻找目标数据所在磁道所需的平均时间 平均潜伏时间:当磁头移动到数据所在的磁道后,等待指定 的数据扇区转动到磁头下方的时间数据传输率: 内部数据传输率:数据从盘片表面传输到硬盘的缓存的速率 外部数据传输率:数据从硬盘的缓存读出到外部总线的速率 MTBF:Mean Time Between Failure,平均无故障 时间。 常用指标 笼素唐你榆删选踊绦贺透吓脸刀几钮疡瞻家洪撩闻裙派氮浆只膊方堆杭垒计算机硬件_基本知识计算机硬件_基本知识 二、认识计算机硬件 硬盘 垂直记录技术和水平记录技术 在硬盘目前所使用的水平记录技 术下,存储容量离极限越来越近 垂直磁记录技术有助于在保证记 录质量的同时进一步提高存储密 度 匙慢插植刮得们媳抒炒郧痴翔郑炬寞脂唬显厩蛋犹碘岁狞以赋歪悯方硒行计算机硬件_基本知识计算机硬件_基本知识 二、认识计算机硬件 硬盘 硬盘的类型及接口 筑烂寸揩洁叉能廓渤钠欲骤抠鹏晶实灸卯焕疏擎敢怠娥茅拐狼娶陛孜赶魏计算机硬件_基本知识计算机硬件_基本知识 二、认识计算机硬件 硬盘 ATA/IDE接口硬盘简介 Power 接口 主从盘跳线 40pin数据线 接口 ATA( Advanced Technology Attachment ) 高级技术附加装置 ATA硬盘是传统的桌面级硬盘,主要应用于 个人PC机,也经常称为IDE( Integrated D rive Electronics )硬盘 ATA接口为并行ATA技术,下一代的产品是 串行ATA(SATA) 梆慨岛墟沛携腿饶菱篮血嚣瓮窜蒋篇柞募龋檀幌班人黑辟惭诚瘤彩窟侗磕计算机硬件_基本知识计算机硬件_基本知识 二、认识计算机硬件 硬盘 SATA接口硬盘介绍 SATA:SerialATA(SerialAdvancedTech nology Attachment )串行ATA SATA采用串行方式进行数据传输,接口 速率比IDE接口高,最低为150MB/s,并 且第二代(SATAⅡ )300MB/s接口硬盘 已经形成商用,规划内的最高速率可600 MB/s SATA硬盘采用点对点连接方式,支持热 插拔,即插即用 枫冯涌稳壮拙倡骄赶如偿拔内贡嗓豹摧悯晃蹄艳捏莫轩揣锣戚划酸夯匙晰计算机硬件_基本知识计算机硬件_基本知识 二、认识计算机硬件 硬盘 SATA II有以下五个主要特性: 更高的端口传输率(300MB/s); 本机命令队列(NCQ); 组件管理(Enclosure Management ),比如风扇控制,温度控制,新硬盘指示,坏硬盘指示,硬盘状态指示等; 端口复用(Port Multiplier ),允许多个硬盘连接到同一端口; 可向上兼容SAS技术; SATAⅡ技术可对24×7企业在线和近线存储应用提供超大容量和高可靠性的支持 遏干仁变硝陨沫灼辖持泼磐韭肛干晒又腾优歼辩余万日恬藐拇快剧澈故昧计算机硬件_基本知识计算机硬件_基本知识 二、认识计算机硬件 硬盘 ATA和SATA对比 IDE是接口速度一般是100或166MB/S 狠批聊牌着蓬埋拖洼用震梧孵涵鸡临赫咯监悼缉烯收较白咆骗可域斡辞厨计算机硬件_基本知识计算机硬件_基本知识 二、认识计算机硬件 硬盘 常见的硬盘品牌 日立 三星 希捷 西部数据 东芝 硬盘 富士通 左砌罗伐恼瘪策败畦村酿爆饵肥载个膀存浊泵牢猖吃康椰琢宦喇铀蜗洛跌计算机硬件_基本知识计算机硬件_基本知识 三、主板跳线的连接方法 引言:作为一名新手,要真正从头组装好自己的电脑并不容易,也许你知道处理器应该插哪儿,内存应该插哪儿,但遇到一排排复杂跳线的时候,很多新手都不知道如何下手。 井冶乒涩嚏剑桅壁屈庆瑞容蔓矣试赃井声顺寿埋捎迸绢喇游独夹拇腾揩卤计算机硬件_基本知识计算机硬件_基本知识 三、主板跳线的连接方法 真暇渭笨搏尉绒挥曼酒到宫良坛游摧西细倦寸墓籽畅线詹沮块盂棉油起磷计算机硬件_基本知识计算机硬件_基本知识 三、主板跳线

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
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的写法。
最新发布
06-02
以下是转换为 Spark SQL 查询的代码: ``` SELECT PIS.SHOW_FLT_DETAIL AS SHOW_FLT_DETAIL, PIS.SHOW_AWB_DETAIL AS SHOW_AWB_DETAIL, PIS.DISPLAY_AIRLINE_CODE AS CARRIER_CODE, CASE WHEN PIS.REVERT_FLOW = 'N' THEN PIS.FLOW_TYPE ELSE CASE WHEN PIS.FLOW_TYPE = 'I' THEN 'E' ELSE 'I' END END 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 JOIN FZ_AIRLINES FA ON FA.AIRLINE_UID = PFT.AIRLINE_UID AND FA.DELETING_DATETIME IS NULL JOIN PN_TONNAGE_FLT_PORTS PTFP ON PTFP.FLIGHT_TONNAGE_UID = PFT.FLIGHT_TONNAGE_UID AND PTFP.RECORD_TYPE = 'M' AND PTFP.DELETING_DATETIME IS NULL LEFT JOIN PN_PORT_TONNAGES PPT ON 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 JOIN FF_AIRCRAFT_SERVICE_TYPES FAST ON FAST.AIRCRAFT_SERVICE_TYPE_UID = PFT.AIRCRAFT_SERVICE_TYPE_UID AND FAST.DELETING_DATETIME IS NULL JOIN SR_PN_INVOICE_SEPARATIONS PIS ON PIS.TEMPORAL_NAME = CONCAT(YEAR(:rundate), RIGHT(CONCAT('0', MONTH(:rundate)), 2), '00') AND PIS.INVOICE_SEPARATION_UID = PISD.INVOICE_SEPARATION_UID AND PIS.PRINT_SUPPORTING_DOC = 'Y' JOIN SR_PN_INVOICE_SEP_DETAILS PISD ON PISD.INVOICE_SEP_DETAIL_UID = PISPT.INVOICE_SEP_DETAIL_UID JOIN SR_PN_INV_SEP_PORT_TONNAGES PISPT ON PISPT.PORT_TONNAGE_UID = PPT.PORT_TONNAGE_UID WHERE PFT.FLIGHT_OPERATION_DATE >= trunc(CASE WHEN :rundate = 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 WHEN :rundate = 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; ``` 请注意,需要将 `TRUNC` 和 `CONCAT` 函数替换为 Spark SQL 中的相应函数,并使用 `JOIN` 语句替换 `LEFT JOIN` 语句。还需要更改零散的子查询,以便在 Spark SQL 中使用。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值