As the latest version of relational database standard,SQL3 not only has been extended with many new relational features but also added with the object-oriented technologies.This paper introduces the object-oriented fe...As the latest version of relational database standard,SQL3 not only has been extended with many new relational features but also added with the object-oriented technologies.This paper introduces the object-oriented features of SQL3 and then extends it with object deputy model to support object view mechanisms.展开更多
在"PostgreSQL+PostGIS"平台基础上,以上海市公共图书馆、博物馆、文化馆和电影院等公共文化设施数据为基础,建立上海市公共文化信息空间数据库,并通过构建S Q L 3空间查询分析的语句及均值中心点、紧密度指数、最近邻指数等...在"PostgreSQL+PostGIS"平台基础上,以上海市公共图书馆、博物馆、文化馆和电影院等公共文化设施数据为基础,建立上海市公共文化信息空间数据库,并通过构建S Q L 3空间查询分析的语句及均值中心点、紧密度指数、最近邻指数等数量特征模型,实现对各种设施的空间分布格局、空间分布均衡性、人均拥有量等的GIS空间查询与分析。从总体上看,上海市公共文化服务发展水平较高,公共文化设施分布相对密集,但在空间分布格局上呈现出相对不均衡性。应加强对上海市公共文化设施空间格局的研究,合理构建公共文化设施的空间布局模式,确立文化设施建设的重点区域,推动上海市公共文化设施的建设。展开更多
Solvent dependent assembly obtained two novel Ni coordination polymers with H_2 tbtpa and flexible 1,2-bix ligand(H_2tbtpa = tetrabromoterephthalic acid and 1,2-bix = 1,2-bis(imidazol-1-ylmethyl)benzene),formulate...Solvent dependent assembly obtained two novel Ni coordination polymers with H_2 tbtpa and flexible 1,2-bix ligand(H_2tbtpa = tetrabromoterephthalic acid and 1,2-bix = 1,2-bis(imidazol-1-ylmethyl)benzene),formulated as [Ni_(0.5)(tbtpa)_(0.5)(1,2-bix)·(H_2O)]_n(1) and [Ni(tbtpa)(1,2-bix)(H_2O)_2]_n(2).They have been structurally characterized by single-crystal and powder X-ray diffraction,elemental analysis,FT-IR spectra and TGA.Compound 1 crystalizes in triclinic,space group P1 with a = 9.0276(4),b = 10.0012(6),c = 11.4955(5) A,α = 69.121(5),β = 76.398(4),γ = 89.668(4)o,C_(36)H_(32)Br_4 Ni N_8O_6,Mr = 1051.04,V = 939.05(8) A^3,Z = 1,Dc = 1.859 g·cm^-3,μ = 6.222 mm^-1,F(000) = 520,8.502≤2θ≤134.16°,λ(Cu Kα) = 1.54184 A,T = 294(6) K,the final R = 0.0750,w R = 0.1988 and S = 1.033.Compound 2 crystalizes in triclinic,space group P1 with a = 11.1257(7),b = 11.5062(6),c = 12.3529(4) A,α = 88.861(3),β = 84.572(4),γ = 64.235(6)o,C_(22)H_(18)Br_4 Ni N_4O_6,Mr = 812.75,V = 1417.36(1) A^3,Z = 2,Dc = 1.904 g·cm^-3,μ = 7.968 mm^-1,F(000) = 788,7.2≤2θ≤134.1°,λ(Cu Kα) = 1.54184 A,T = 294(6) K,the final R = 0.0414,w R = 0.0865 and S = 1.025.1 shows a two-dimensional(4,4)-sql topology and 2 manifests a three-dimensional 6~58 Cd SO_4 topology coordination polymer network.展开更多
基金Supported by the National Natural Science Foun-dation of China(60273072)S63 Foundation of China(2002AA4Z3150)+1 种基金Research Fund for the Doctoral Prugram of High-er Education(20010486029)Hubei Natural Science Fund for Dy tinguished Youth(2002AC003)
文摘As the latest version of relational database standard,SQL3 not only has been extended with many new relational features but also added with the object-oriented technologies.This paper introduces the object-oriented features of SQL3 and then extends it with object deputy model to support object view mechanisms.
文摘在"PostgreSQL+PostGIS"平台基础上,以上海市公共图书馆、博物馆、文化馆和电影院等公共文化设施数据为基础,建立上海市公共文化信息空间数据库,并通过构建S Q L 3空间查询分析的语句及均值中心点、紧密度指数、最近邻指数等数量特征模型,实现对各种设施的空间分布格局、空间分布均衡性、人均拥有量等的GIS空间查询与分析。从总体上看,上海市公共文化服务发展水平较高,公共文化设施分布相对密集,但在空间分布格局上呈现出相对不均衡性。应加强对上海市公共文化设施空间格局的研究,合理构建公共文化设施的空间布局模式,确立文化设施建设的重点区域,推动上海市公共文化设施的建设。
基金Supported by the National Natural Science Foundation of China(NSFC)(No.21271117)National Students'Innovation and Entrepreneurship Training Program(201410425060)
文摘Solvent dependent assembly obtained two novel Ni coordination polymers with H_2 tbtpa and flexible 1,2-bix ligand(H_2tbtpa = tetrabromoterephthalic acid and 1,2-bix = 1,2-bis(imidazol-1-ylmethyl)benzene),formulated as [Ni_(0.5)(tbtpa)_(0.5)(1,2-bix)·(H_2O)]_n(1) and [Ni(tbtpa)(1,2-bix)(H_2O)_2]_n(2).They have been structurally characterized by single-crystal and powder X-ray diffraction,elemental analysis,FT-IR spectra and TGA.Compound 1 crystalizes in triclinic,space group P1 with a = 9.0276(4),b = 10.0012(6),c = 11.4955(5) A,α = 69.121(5),β = 76.398(4),γ = 89.668(4)o,C_(36)H_(32)Br_4 Ni N_8O_6,Mr = 1051.04,V = 939.05(8) A^3,Z = 1,Dc = 1.859 g·cm^-3,μ = 6.222 mm^-1,F(000) = 520,8.502≤2θ≤134.16°,λ(Cu Kα) = 1.54184 A,T = 294(6) K,the final R = 0.0750,w R = 0.1988 and S = 1.033.Compound 2 crystalizes in triclinic,space group P1 with a = 11.1257(7),b = 11.5062(6),c = 12.3529(4) A,α = 88.861(3),β = 84.572(4),γ = 64.235(6)o,C_(22)H_(18)Br_4 Ni N_4O_6,Mr = 812.75,V = 1417.36(1) A^3,Z = 2,Dc = 1.904 g·cm^-3,μ = 7.968 mm^-1,F(000) = 788,7.2≤2θ≤134.1°,λ(Cu Kα) = 1.54184 A,T = 294(6) K,the final R = 0.0414,w R = 0.0865 and S = 1.025.1 shows a two-dimensional(4,4)-sql topology and 2 manifests a three-dimensional 6~58 Cd SO_4 topology coordination polymer network.