1.WMAIN上的特征保持架
不错的选择,但如果温哥华市的所有供水网络都能实现,这将是一个巨大的性能冲击。
“!position=“4179.29 728.525”!top_left=“4179.29 728.525”!bottom_right=“5414.68 542.273”!bounding\u rect=“4179.29 728.525 1235.39 186.252”!订单=“5E + 14”!跟随anchor=“true”!info_node=“false”!colour=“1,1,0.784314,0.192157”!size_policy=“10”!comment_type=“Regular”!锚定的_node=“11”!>2。每个事务使用连接器顺序和功能=1
有点慢,因为每个事务都有一个提交
“!position=“4179.29 196.032”!top_left=“4179.29 196.032”!bottom_right=“4178.29 197.032”!bounding rect=“4179.29 196.032-1-1”!订单=“5E + 14”!跟随anchor=“true”!info_node=“false”!colour=“1,1,0.784314,0.192157”!size_policy=“8”!comment_type=“Regular”!锚定的_node=“17”!>制造商ID
“!position=“1550.79 251.658”!top_left=“1550.79 251.658”!bottom_right=“1550.79 251.658”!bounding诳rect=“1550.79 251.658 0 0”诳!订单=“5E + 14”!跟随anchor=“true”!info_node=“false”!colour=“1,1,0.784314,0.192157”!size_policy=“8”!comment_type=“Regular”!锚定的_node=“20”!>独特的制造商
“!position=“2317.96-34.1104”!top_left=“2317.96-34.1104”!bottom_right=“2316.96-33.1104”!bounding瓒rect=“2317.96-34.1104-1-1”!订单=“5E + 14”!跟随anchor=“true”!info_node=“false”!colour=“1,1,0.784314,0.192157”!size_policy=“8”!comment_type=“Regular”!锚定的_node=“21”!>如何避免这个错误?
|错误执行语句'insert into“wmain”(“mainid”,“已启用”,“安装日期”“生命周期状态”,“类型”,“制造商ID”,“geom”)值(:“mainid”,:“启用”,:“安装日期”,:“生命周期状态”,:“类型”,:“制造商ID”,:“geom”)“没有成功;错误为“ora-02291:违反了完整性约束(wmain-wasset)-找不到父键”。(serverType='oracle8i',ServNe=
子连接
“!position=“2109.17 324.783”!top_left=“2109.17 324.783”!bottom_right=“2108.17 325.783”!bounding rect=“2109.17 324.783-1-1”!订单=“5E + 14”!跟随anchor=“true”!info_node=“false”!colour=“1,1,0.784314,0.192157”!size_policy=“8”!comment_type=“Regular”!锚定的_node=“56”!>父连接
“!position=“2109.17 64.834”!top_left=“2109.17 64.834”!bottom_right=“2108.17 65.834”!bounding rect=“2109.17 64.834-1-1”!订单=“5E + 14”!跟随anchor=“true”!info_node=“false”!colour=“1,1,0.784314,0.192157”!size_policy=“8”!comment_type=“Regular”!锚定的_node=“60”!>删除并创建wmain和wasset表
在wmain和wasset之间创建约束
“!位置=“-113.982 349.691”!左上角=“-113.982 349.691”!bottom_right=“658.778 119.689”!bounding rect=“-113.982 349.691 772.76 230.002”!订单=“5E + 14”!跟随anchor=“true”!info_node=“false”!colour=“0.329412,0.329412,1,0.192157”!size_policy=“10”!comment_type=“Regular”!锚定的_node=“54”!>禁用约束wmain-wasset
“!position=“4202.9-473.255”!top_left=“4202.9-473.255”!bottom_right=“4201.9-472.255”!bounding诳rect=“4202.9-473.255-1-1”诳!订单=“5E + 14”!跟随anchor=“true”!info_node=“false”!colour=“1,1,0.784314,0.192157”!size_policy=“8”!comment_type=“Regular”!锚定的_node=“44”!>三。SQL和FeatureWriter可以更好地控制预处理和后处理
“!position=“4188.67-298.86”!top_left=“4188.67-298.86”!bottom_right=“5319.93-441.361”!bounding rect=“4188.67-298.86 1131.26 142.501”!订单=“5E + 14”!跟随anchor=“true”!info_node=“false”!colour=“1,1,0.784314,0.192157”!size_policy=“10”!comment_type=“Regular”!锚定的_node=“0”!>…Wassets[1:m]W主
需要先加载父表(查找),然后是孩子(数据)
“!top_left=“2958.68-14.6521”!bottom_right=“3709.96-655.284”!bounding瓒rect=“2958.68-14.6521 751.282 640.632”!sticky=“假”!colour=“0.537255,0.0156863,0.764706”!内容=“”>外键是manufacturerID
“!top_left=“2958.68 453.481”!bottom_right=“3709.96 54.098”!bounding rect=“2958.68 453.481 751.282 399.383”!粘性=“真”colour=“0.592157,0.486275,0.937255”!内容=“5”字号!>可选练习:
主、干燥剂和控制阀是压力区[1:m]的成员。
我们将如何:
1.在工作区中建立此关系
2。按照正确的顺序编写压力区和wmain、whydrant和wcontrolvalve,以满足Oracle关系。
“!top_left=“751.104-1835.02”!bottom_right=“3630.98-2318.78”!bounding rect=“751.104-1835.02 2879.88 483.759”!粘性=“真”colour=“0.756863,0.184314,0.921569”!contents=“8 33 2 15 26”!>