SmartAntenna
【网学网提醒】：网学会员鉴于大家对十分关注，论文会员在此为大家搜集整理了“SmartAntenna”一文，供大家参考学习
平均功率增益（dB） 平均CI增益（dB）
开启赋形后/前/后-前 DPCH平均功率（dBm）DPCH_RSCP
开启赋形后/前/后-前 DPCH平均CI（dBm）DPCH_C_I
开启赋形后/前/后-前 与发射天线距离（米）dist
开启赋形后/前/后-前 相对法线方位（°）direct
开启赋形后/前/后-前RLCRTXRate
开启赋形后/前/后-前 HS16QAMRate
开启赋形后/前/后-前 hsdschackRate
开启赋形后/前/后-前 HSPDSCHTotalBLER
开启赋形后/前/后-前 MACPDUDiscardRate
开启赋形后/前/后-前 下载速率（kbps）ftp_download
开/关赋形
开启赋形后/前/后-前
(to.dpch_rscp-t0.pccpch_rscp)-(tc.dpch_rscp-tc.pccpch_rscp)asp_gain平均功率增益（dB）,
(to.dpch_c_i-t0.pccpch_c_i)-(tc.dpch_c_i-tc.pccpch_c_i)asc_gain平均CI增益（dB）,
to.d_rscpasod_rscpDPCH平均RSCP（dB）后
to.d_ciasod_ciDPCH平均CI（dB）后
t0.distasodist与发射天线距离（米）后
tc.distascdist与发射天线距离（米）前
t0.dist-tc.distasdist_d与发射天线距离（米）后-前
t0.directasodirect相对法线方位（°）后
tc.directascdirect相对法线方位（°）前
t0.direct-tc.directasdirect_d相对法线方位（°）
同一个点测两组数据，对应两张数据表，一张赋形后o，一张前c
useSmartAntenna
insertintoanalysis_tmp
select38097asci,
t0.distasodist,
tc.distascdist,
t0.dist-tc.distasdist_d,
t0.directasodirect,
tc.directascdirect,
t0.direct-tc.directasdirect_d,
tc.sangleassangle,
(t0.d_rscp-t0.p_rscp)-(tc.d_rscp-tc.p_rscp)asp_gain,
t0.d_rscpasod_rscp,
t0.p_rscpasop_rscp,
tc.d_rscpascd_rscp,
tc.p_rscpascp_rscp,
t0.d_rscp-tc.d_rscpasd_rscp_d,
t0.p_rscp-tc.p_rscpasp_rscp_d,
(t0.d_ci-t0.p_ci)-(tc.d_ci-tc.p_ci)asc_gain,
t0.d_ciasod_ci,
tc.d_ciascd_ci,
t0.p_ciasop_ci,
tc.p_ciascp_ci,
t0.d_ci-tc.d_ciasd_ci_d,
t0.p_ci-tc.p_ciasp_ci_d,
t0.rr_rate-tc.rr_rateasrr_rate_d,
t0.rr_rateasorr_rate,
tc.rr_rateascrr_rate,
t0.q16_rate-tc.q16_rateasq16_rate,
t0.q16_rateasoq16_rate,
tc.q16_rateascq16_rate,
t0.ack_rate-tc.ack_rateasack_rate_d,
t0.ack_rateasoack_rate,
tc.ack_rateascack_rate,
t0.bler-tc.blerasbler_d,
t0.blerasobler,
tc.blerascbler,
t0.disc_rate-tc.disc_rateasdisc_rate_d,
t0.disc_rateasodisc_rate,
tc.disc_rateascdisc_rate,
t0.ftp-tc.ftpasftp_d,
t0.ftpasoftp,
tc.ftpascftp
from
(selectidasid,
distasdist,
cast(pccpch_rscpasfloat)asp_rscp,
cast(dpch_rscpasfloat)asd_rscp,
cast(pccpch_c_iasfloat)asp_ci,
cast(dpch_c_iasfloat)asd_ci,
cast(RLC_RTX_Rateasfloat)asrr_rate,
cast(HS_16_QAM_Rateasfloat)asq16_rate,
cast(hs_dsch_ack_rateasfloat)asack_rate,
cast(HS_PDSCH_TotalBLERasfloat)asbler,
cast(MAC_PDU_DiscardRateasfloa
t)asdisc_rate,
cast(ftp_downloadasfloat)asftp,
casewhen90-atn2(cast(Latitudeasfloat)-sy,cast(longitudeasfloat)-sx)/pi()*180<0then90-atn2(cast(Latitudeasfloat)-sy,cast(longitudeasfloat)-sx)/pi()*180+360else90-atn2(cast(Latitudeasfloat)-sy,cast(longitudeasfloat)-sx)/pi()*180endasdirect,
sxassx,
syassy,
sangleassangle
from_38097_csso_1
whereDPCH_RSCPISNOTNULL)ast0,
(selectidasid,
distasdist,
cast(pccpch_rscpasfloat)asp_rscp,
cast(dpch_rscpasfloat)asd_rscp,
cast(pccpch_c_iasfloat)asp_ci,
cast(dpch_c_iasfloat)asd_ci,
cast(RLC_RTX_Rateasfloat)asrr_rate,
cast(HS_16_QAM_Rateasfloat)asq16_rate,
cast(hs_dsch_ack_rateasfloat)asack_rate,
cast(HS_PDSCH_TotalBLERasfloat)asbler,
cast(MAC_PDU_DiscardRateasfloat)asdisc_rate,
cast(ftp_downloadasfloat)asftp,
casewhen90-atn2(cast(Latitudeasfloat)-sy,cast(longitudeasfloat)-sx)/pi()*180<0then90-atn2(cast(Latitudeasfloat)-sy,cast(longitudeasfloat)-sx)/pi()*180+360else90-atn2(cast(Latitudeasfloat)-sy,cast(longitudeasfloat)-sx)/pi()*180endasdirect,
sxassx,
syassy,
sangleassangle
from_38097_cssc_1
whereDPCH_RSCPISNOTNULL)astc
wheret0.id=tc.id
CREATETABLEanalysis_tmp(
idvarchar(13),
ciINT,
odistFLOAT,
cdistFLOAT,
dist_dFLOAT,
odirectFLOAT,
cdirectFLOAT,
direct_dFLOAT,
sangleFLOAT,
p_gainFLOAT,
d_rscpFLOAT,
op_rscpFLOAT,
cd_rscpFLOAT,
cp_rscpFLOAT,
d_rscp_dFLOAT,
p_rscp_dFLOAT,
c_gainFLOAT,
od_ciFLOAT,
cd_ciFLOAT,
op_ciFLOAT,
cp_ciFLOAT,
d_ci_dFLOAT,
p_ci_dFLOAT,
rr_rate_dFLOAT,
orr_rateFLOAT,
crr_rateFLOAT,
q16_rateFLOAT,
oq16_rateFLOAT,
cq16_rateFLOAT,
ack_rate_dFLOAT,
oack_rateFLOAT,
cack_rateFLOAT,
bler_dFLOAT,
oblerFLOAT,
cblerFLOAT,
disc_rate_dFLOAT,
odisc_rateFLOAT,
cdisc_rateFLOAT,
ftp_dFLOAT,
oftpFLOAT,
cftpFLOAT)