海军舰艇的英文简称

美国海军舰船种类代号一览

Aircraft Carriers 航空母舰CV Aircraft Carrier 航空母舰

CVN Aircraft Carrier, Nuclear 核动力航母

CVB Aircraft Carrier, Large 大型航母

CVA Aircraft Carrier, Attack 攻击型航母

CVGH Aircraft Carrier, Guided Missile Helicopter 导弹直升机航母

CVL Aircraft Carrier, Light 轻型航母

CVE Aircraft Carrier, Escort 护航航母

CVS Seaplane Carrier (prior to and during WWII) 水上飞机母舰（二战前、二战期间）

Anti-Submarine/Support Carrier (after WWII) 反潜/支援航母（二战后）

CVH Aircraft Carrier, Helicopter 直升机航母

CVV Aircraft Carrier, Vertical Take Off And Landing 垂直起降飞机母舰

AVT Aircraft Carrier, Training Ship 训练航母

Battleships 战列舰B/BB Battleship - Usually larger than 20,000 tons and armed with guns of 10" or

more. 战列舰－通常20000吨以上、装甲防护、主炮口径10吋或更大

BM Monitors 浅水重炮舰

Cruisers 巡洋舰C Cruiser 巡洋舰

ACR Armored Cruiser 装甲巡洋舰

CB Large Cruiser 大巡洋舰

CC Prior to 1961: Battlecruiser 战列巡洋舰（1961前）

After 1961: Command Ship 指挥舰（1961后）

CA Prior to 1931: Armored Cruiser 装甲巡洋舰（1931前）

After 1931: Heavy Cruiser - a cruiser armed with guns 8" (20.3 cm) or larger

重巡洋舰（1931后）－装甲防护、8吋或更大口径主炮

CAG Heavy Cruiser, Guided Missile - a heavy cruiser converted to carry missiles

重型导弹巡洋舰－携带导弹的重巡洋舰

CG Guided Missile Cruiser 导弹巡洋舰

CGN Guided Missile Cruiser, Nuclear 核动力导弹巡洋舰

CH Cruiser with an assigned Helicopter直升机巡洋舰

CL Light Cruiser - cruiser armed with guns smaller than 8" (20.3cm)

轻巡洋舰－装甲防护、8吋以下主炮

CLAA Anti-Aircraft Light Cruiser 防空轻巡洋舰

CLC Command Light Cruiser 轻型指挥巡洋舰

CLH Helicoptor Light Cruiser - cruiser with an assigned Helicopter

轻型直升机巡洋舰－携带直升机的轻巡洋舰

CLK Light Cruiser, Killer (ASW) 反潜巡洋舰

CGH Guided Missile Cruiser with an assigned Helicopter导弹直升机巡洋舰

CLG Light Guided Missile Cruiser - a light cruiser converted to carry missiles

轻型导弹巡洋舰－携带导弹的轻巡洋舰

CLGN Light Guided Missile Cruiser, Nuclear 核动力轻型导弹巡洋舰

CS Scout Cruiser 侦察巡洋舰

CSG Strike Missile Cruiser 攻击型导弹巡洋舰

Destroyers 驱逐舰D/DD Destroyer 驱逐舰

DE Destroyer Escort 护航驱逐舰

DDE Destroyer converted to Fleet Escort 护航驱逐舰

DDH Destroyer with an assigned Helicopter 直升机驱逐舰

DDG Guided Missile Destroyer 导弹驱逐舰

DL Destroyer Leader or Frigate 驱逐领舰

DLG Destroyer Leader or Frigate, Guided Missle 导弹驱逐领舰

DLGN Destroyer Leader or Frigate, Guided Missile, Nuclear 核动力导弹驱逐领舰

DDR Radar Picket Destroyers 雷达哨驱逐舰

TB Torpedo Boat 鱼雷艇Frigates/Corvettes 护卫舰/轻型护卫舰F/FF Frigate. Originally called ocean escort

Name is sometimes used interchangeably with "Destroyer Escort."

护卫舰，又称远洋护航舰，有时称护航驱逐舰

FFG Guided Missile Frigate 导弹护卫舰

FFH Frigate with an assigned Helicopter 直升机护卫舰

FFT Reserve/Training Frigate 预备/训练护卫舰

PE Patrol Escort 巡逻护航舰

PF Corvette 轻型护卫舰

PFG Guided Missile Corvette 轻型导弹护卫舰

PFR Radar Picket Corvette 雷达哨轻型护卫舰

Submarines 潜艇SS Attack Submarine 攻击型潜艇

SSN Attack Submarine, Nuclear 核动力攻击潜艇

SSA/AGSS Auxilary/Experimental Submarine 辅助/试验潜艇

SSG Attack Submarine, Guided Missile 攻击型导弹潜艇

SSGN Attack Submarine, Guided Missile, Nuclear 核动力攻击型导弹潜艇

SSB Submarine, Ballistic Missile 弹道导弹潜艇

SSBN Submarine, Ballistic Missile, Nuclear 核动力弹道导弹潜艇

SSK Hunter-Killer Submarine 反潜潜艇

SM Submarine, Minelayer 布雷潜艇

SSM Midget Submarine 微型潜艇

SSP Transport Submarine 运输潜艇

SSR Radar Picket Submarine 雷达哨潜艇

SSRN Radar Picket Submarine, Nuclear 核动力雷达哨潜艇

Amphibious Forces 两栖部队LCAC Air Cushion Landing Craft 气垫登陆艇

LCC Amphibious Command Ship 两栖指挥舰

LCI Infantry Landing Craft 人员登陆艇

LCM Mechanized Landing Craft 机械化登陆艇

LCM/ML Minelaying Mechanized Landing Craft 布雷/机械化登陆艇

LCR Riverine Landing Craft 内河登陆艇

LCS Support Landing Craft 支援登陆艇

LCT Tank Landing Craft 坦克登陆艇

LCU Utility Landing Craft 通用登陆艇

LCV Vehicle Landing Craft 车辆登陆艇

LCVP Vehicle and Personnel Landing Craft 车辆人员登陆艇

LCW Wing-in-Ground-Effect Landing Craft 地效飞行登陆艇

LHA Amphibious Assault Ship 两栖攻击舰

LHD Amphibious Assault Ship 两栖攻击舰

LKA Amphibious Cargo Ship 两栖货船

LPD Amphibious Transport Dock Ship 两栖船坞运输舰

LPH Amphibious Assault Helicopter Carrier 两栖直升机攻击舰

LSD Dock Landing Ship 船坞登陆舰

LSM Medium Landing Ship 中型登陆舰

LSS Landing Support Ship 登陆支援舰

LSSL Small Landing Support Ship 小型登陆支援舰

LST Tank Landing Ship 坦克登陆舰

LST/ML Minelaying Tank Landing Ship 布雷/坦克登陆舰

LSU Utility Landing Ship 通用登陆舰

LSV Vehicle Landing Ship 车辆登陆舰

Littoral Warfare Ships 沿岸作战舰艇

PAC Air Cushion Patrol Craft 气垫巡逻艇

PB Patrol Boat 巡逻艇

PBL Amphibious Assault Patrol Boat 两栖突击艇

PBM Riverine Monitor 内河炮舰

PC Coastal Patrol Craft/Submarine Chaser (173 ft) 沿海巡逻艇/猎潜艇（173英尺）

PCC Submarine Chaser (control) 猎潜艇（指挥）

PCE Submarine Chaser (Escort) 猎潜艇（护航）

PCEC Escort (control) 护卫艇（指挥）

PCE(R) Escort (Rescue) 护卫艇（后备）

PCI Fast Coastal Interceptor 沿海快速截击艇

PCS Submarine Chaser (136 ft) 猎潜艇（136英尺）

PCSC Submarine Chaser (control) 猎潜艇（指挥）

PG Patrol Gunboat 巡逻炮艇

PGM Missile Gunboat 导弹艇

PGH Helicopter Gunboat 直升机炮艇

PH Hydrofoil Gunboat 水翼炮艇

PHM Missile Hydrofoil 水翼导弹艇

PHT Hydrofoil Torpedo Boat 水翼鱼雷艇

PL High Endurance Cutters 大型巡逻舰

PM Medium Endurance Cutters 中型巡逻舰

PR Radar Picket Conversion 雷达哨艇

PSOC Special Operations Craft 特种作战艇

PT Torpedo Boat 鱼雷艇

PTC Motor Boat Submarine Chasers 摩托猎潜艇

PW Wing-in-Ground-Effect Patrol Craft 地效飞行艇

PY Yacht 帆船

SC Submarine Chaser (110 ft) 猎潜艇（110英尺）

SCC Submarine Chaser (control) 猎潜艇（指挥）

Mine Warfare Ships 水雷战舰艇ACM Auxiliary Minelayer 辅助布雷舰

AM Minesweeper 扫雷舰

AMc Coastal Minesweeper 沿岸扫雷舰

AMc(U) Coastal Minesweeper (underwater locator) 沿岸扫雷舰（水下定位）

CM Minelayer 布雷舰

CMc Coastal Minelayer 沿岸布雷舰

DM Light Minelayer (converted destroyer) 轻型布雷舰（改装驱逐舰）

DMS High Speed Minesweeper (converted destroyer) 高速布雷舰（改装驱逐舰）

MCAC Air Cushion Mine Countermeasures Craft 气垫反水雷艇

MCD Mine Countermeasures Drone 遥控反水雷器

MCM Mine Countermeasures Ship 反水雷舰

MCS Mine Countermeasures Support Ship 反水雷支援舰

MCT Mine Countermeasures Conversion Trainer 反水雷改装训练舰

MHC Coastal Minehunter 沿岸猎雷艇

MHI Inshore Minehunter 近岸猎雷艇

ML Minelayer 布雷艇

MSA Auxiliary Minesweeper 辅助扫雷艇

MSAC Air Cushion Minesweeper 气垫扫雷艇

MSC Coastal Minesweeper 沿岸扫雷艇

MSD Drone Minesweeper 遥控扫雷艇

MSH Harbor Minesweeper 港湾扫雷艇

MSI Inshore Minesweeper 近岸扫雷艇

MSO Ocean Minesweeper 远洋扫雷舰

MSR River Minesweeper 江河扫雷艇

Auxiliary Combat Supply Ships 战斗补给辅助船

AD Support Tender 支援舰

ADC Dry Cargo Replenishment Ship 干货补给舰

AE Ammunition Ship 军火船

AFS Combat Stores Ship 战斗补给舰

AGC Amphibious Fleet Flagship 两栖舰队旗舰

AGF Fleet Flagship 舰队旗舰

AGMR Communications Major Relay Ship 通讯中继船

AGSS Experimental Submarine 试验潜艇

AH Hospital Ship 医院船

AHR Riverine Hospital Ship 内河医院船

AKA Attack Cargo Ship 武装货船

APA Attack Personnel Transport Ship 武装人员运输船

AO Fleet Oiler 舰队油船

AOE Fast Combat Support Ship 快速战斗支援舰

AOL Small Oiler 小型油船

AOR Replenishment Oiler 补给油船

AORL Small Replenishment Oiler 小型补给油船

AOT Transport Oiler 运油船

AR Repair Ship 修理舰

ARS Salvage Ship 救助船

AS Submarine Tender 潜艇供应舰

ASE Submarine Ammunition Ship 水中武器运输舰

ASR Submarine Rescue Vessel 后备潜水船

AVB Aviation Logistics Support Ship 航空勤务保障舰

Non-Combat Auxiliary Ships 非战斗辅助船ACS Crane Ship 起重船

ADG Degaussing Vessel 消磁船

AFDB Large Floating Drydock 大型浮船坞

AFDL Small Floating Drydock 小型浮船坞

AFDM Medium Floating Drydock 中型浮船坞

AG Auxiliary, Generic/General use 辅助船/通用

AGB Icebreaker 破冰船

AGDS Deep Submergence Support Ship 深潜支援船

AGFF Experimental Frigate 试验船

AGH Helicopter Support Ship 直升机支援船

AGI Intelligence Gathering Ship 情报收集船

AGM Missile Range Instrumentation Ship 导弹靶场设备船

AGOR Oceanographic Research Ship 海洋调查船

AGOS Ocean Surveillance Ship 海洋监测船

AGS Surveying Ship 测量船

AK Cargo Ship 货船

AKL Light Cargo Ship 小型货船

AKR Roll-on/Roll-off Cargo Ship 滚装船

AKV Aircraft Cargo Ship or Ferry 飞机运输船/渡船

AP Personnel Transport Ship 人员运输船

APL Floating Barracks 浮动营房

AN Net laying Ship 布网船

AOG Gasoline Tanker 汽油运输船

ARC Cable Ship 布缆船

ARD Repair Dock 修船坞

ARDM Medium Repair Dock 中型修船坞

ARV Aircraft Repair Ship 飞机修理船

ARVA Aircraft Airframe Repair Ship 飞机机体修理船

ARVE Aircraft Engine Repair Ship 飞机引擎修理船

ATA Auxiliary Ocean Tug 辅助远洋拖船

ATGB Large Icebreaking Tug 大型破冰拖船

ATF Fleet Tug 舰队拖船

ATS Salvage Tug 救援拖船

AV Seaplane Tender 水上飞机供应船

AVP Small Seaplane Tender 小型水上飞机供应船

AVS Aviation Supply Ship 航空补给船

AW Distilling Ship 蒸馏水船

AY VIP Yacht VIP帆船

AX Training Vessel 训练船

AXS Sail Training Vessel 航海训练船

AZ Aerostat Tender 飞艇供应船

Support Craft 支援船

DSRV Deep Submergence Rescue Vehicle 深潜救助器

DSV Deep Submergence Vehicle 深潜器

IX Unclassified Miscellaneous 各式其他船舶

NR Nuclear Powered Research Submersible 核动力研究潜艇

SDV Swimmer Delivery Vehicle 上浮救生器

SLWT Side Loading Warping Tug 侧绞式拖船

TWR Torpedo Retriever 鱼雷回收船

WLB Seagoing Buoy Tender 远海航标船

WLM Coastal Buoy Tender 沿岸航标船

WLI Inland Buoy Tender 近岸航标船

WLIC Inland Construction Tender 近岸交通艇

WLR River Buoy Tender 江河航标船

YTL Small Harbor Tug 小型港口拖船

YAG Miscellaneous Service Craft 各类勤务船

YC Lighter 小船

YCF Car Float 两栖车辆

YCV Aircraft Transportation Lighter 小型飞机运输船

YD Floating Crane 浮吊

YDT Diving Tender 潜水供应船

YF Covered Lighter 驳船

YFB Ferry 渡船

YFN Covered Lighter 驳船

YFNB Large Covered Lighter 大型驳船

YFND Dry Dock Companion Craft 干船坞引导艇

YFNX Special Purpose Lighter 特种作业驳船

YFP Power Barge 机动驳船

YFRT Range Tender 靶场供应船

YFU Harbor Utility Craft 港口作业艇

YGN Garbage Barge 垃圾驳船

YLC Salvage Lift Craft 救助提升工作艇

YM Dredge 挖泥船

YMN Dredge 挖泥船

YNG Gate Craft 围栏门艇

YO Oil Barge 油驳

YOG Gasoline Barge 汽油驳

YOGN Gasoline Barge 汽油驳

YON Oil Barge 油驳

YOS Oil Storage Barge 储油驳

YP Seamanship Training Craft 船舶驾驶训练艇

YPD Pile Driver 打桩船

YPR Parasail Training Craft 高级航海训练船

YR Repair Barge 修理驳

YRB Repair and Berthing Barge 修理、住宿驳

YRBM Repair, Berthing, and Messing Barge 修理、住宿、食堂驳

YRDH Hull Repair Barge 船壳修理驳

YRDM Machinery Repair Barge 机械修理驳

YRM Missile Retriever 导弹回收船

YRR Radiological Repair Barge 无线电设备修理驳

YRST Salvage Craft Tender 救助艇供应船

YRT Torpedo Retriever 鱼雷回收船

YSR Sludge Removal Barge 运泥驳

YTB Large Tug 大型拖船

YTL Small Tug 小型拖船

YTT Torpedo Trials Craft 鱼雷试验艇

YW Water Barge 运水驳

数据库与数据仓库的本质差别如下：

1、逻辑层面/概念层面：数据库和数据仓库其实是一样的或者及其相似的，都是通过某个数据库软件，基于某种数据模型来组织、管理数据。但是，数据库通常更关注业务交易处理（OLTP），而数据仓库更关注数据分析层面（OLAP），由此产生的数据库模型上也会有很大的差异。

2、数据库通常追求交易的速度，交易完整性，数据的一致性等，在数据库模型上主要遵从范式模型（1NF，2NF，3NF等），从而尽可能减少数据冗余，保证引用完整性；而数据仓库强调数据分析的效率，复杂查询的速度，数据之间的相关性分析，所以在数据库模型上，数据仓库喜欢使用多维模型，从而提高数据分析的效率。

3、产品实现层面：数据库和数据仓库软件是有些不同的，数据库通常使用行式存储，如SAP ASE，Oracle, Microsoft SQL Server，而数据仓库倾向使用列式存储，如SAP IQ，SAP HANA。

鹏仔微信 15129739599 鹏仔QQ344225443 鹏仔前端 pjxi.com 共享博客 sharedbk.com