"物联网技术与应用体系架构:前景与应用案例"

0 下载量 190 浏览量 更新于2023-12-20 收藏 1.04MB PPT 举报
物联网技术与应用体系架构ppt课件.ppt是一份介绍物联网技术及应用体系架构的课件。物联网技术与应用体系架构是近年来备受关注的热点话题,人们对于物联网的前景和应用前景都充满了好奇和期待。但是对于普通用户来说,物联网究竟能够做些什么呢?该课件通过介绍几种与普通用户关系紧密的物联网应用场景,来让大家更加直观地了解物联网的潜力。 首先,课件提到了一个日常生活中非常常见的应用场景:当你早上拿着车钥匙出门上班的时候,家中的智能感应器就会通过互联网络自动发起一系列事件,比如通过短信或者喇叭自动播报当天的天气情况,在电脑上显示最快捷通畅的开车路径并估算路上所需时间,同时还会通过短信或者即时聊天工具告知你的同事你将马上到达。这样的应用场景展示了物联网技术在帮助我们解决日常生活中的实际问题,提高生活的便利性和效率。 其次,课件还介绍了一种更加未来感的应用场景:联网冰箱。联网冰箱可以监视冰箱里的食物,在我们去超市购物时,冰箱会告诉我们缺少哪些食材,同时还会提醒我们哪些食物快要过期了。冰箱还可以跟踪常用的美食网站,为我们收集食谱并在购物单里添加所需配料。它甚至可以根据我们给每顿饭做出的评分来了解我们的口味喜好,从而为我们推荐更加适合的食谱。这种应用场景展示了物联网技术在智能家居中的潜力,可以让家电设备更加智能化、个性化,提高我们的生活品质。 在课件中,还通过右图形象地展示了物联网在我们日常生活中的应用。图中展示了物联网应用的一个小部分,实际的物联网应用还有更加丰富多彩的场景,还有许多潜在的应用前景有待人们去发掘和实现。因此,学习物联网技术与应用体系架构不仅可以帮助我们更加全面地了解物联网的基础知识和相关技术,还可以帮助我们开拓更加丰富多彩的物联网应用前景,为我们的生活带来更多便利和可能性。 总的来说,物联网技术与应用体系架构ppt课件.ppt通过介绍物联网应用的场景和前景,让我们对于物联网技术更加直观地了解到它的潜力和可能性。物联网技术的发展将为普通用户的日常生活带来更多便利和可能性,也将为智能家居、智能城市等领域的发展带来新的机遇和挑战。因此,学习和了解物联网技术与应用体系架构对于我们来说是非常有意义和必要的。相信随着物联网技术的不断发展和创新,我们的生活将变得更加智能、便利,也将迎来更多更加丰富多彩的应用场景和可能性。

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