垂直数据分区技术从逻辑上将满足一定语义条件的数据库表属性存放在同一个物理块中,进而降低数据访问成本,提高查询效率.数据库查询负载中的每条查询通常只与数据库表中的部分属性有关,因此只需使用数据库表的某个属性子集便可以得到准...垂直数据分区技术从逻辑上将满足一定语义条件的数据库表属性存放在同一个物理块中,进而降低数据访问成本,提高查询效率.数据库查询负载中的每条查询通常只与数据库表中的部分属性有关,因此只需使用数据库表的某个属性子集便可以得到准确的查询结果.合理的垂直数据分区方式可以使大多数查询负载不需要扫描完整数据库就可以完成查询任务,从而达到减少数据访问量,提高查询处理效率的目的.传统的数据库垂直分区方法主要基于专家设置的启发式规则,分区策略粒度较粗,且不能根据负载的特征进行有针对性的分区优化.同时,当负载规模较大或者属性个数较多时,现有垂直分区方法执行时间过长,尤其无法满足数据库在线实时调优的性能需求.为此,提出在线环境下基于谱聚类的垂直数据分区方法(spectral clustering based vertical partitioning,SCVP),采用分阶段求解的思想,减少算法时间复杂度,加快分区执行速度.首先通过增加约束条件缩小解空间(即根据谱聚类生成初始分区),然后对解空间设计算法进行精细的搜索(即采用频繁项集和贪心搜索相结合的策略对初始分区进行优化).为了进一步提升SCVP在高维属性下的性能,提出了SCVP的改进版本SCVP-R(spectral clustering based vertical partitioning redesign).SCVP-R通过引入同域竞争机制、双败淘汰机制和循环机制,对SCVP在分区优化过程中的合并方案进行了进一步优化.在不同数据集上的实验结果表明,相比于目前最好的垂直分区方法,SCVP和SCVP-R有着更快的执行时间和更好的性能表现.展开更多
The equilibrium distribution coefficients of 12 impurities （As,Fe,Ca,Co,Al,Cr,Cu,Mg,Mn,Ni,Pb,Zn） in phosphorus were obtained by measuring their effective distribution coefficients at zone travel rate of 3,5,10,15,an...The equilibrium distribution coefficients of 12 impurities （As,Fe,Ca,Co,Al,Cr,Cu,Mg,Mn,Ni,Pb,Zn） in phosphorus were obtained by measuring their effective distribution coefficients at zone travel rate of 3,5,10,15,and 20 mm·h-1 in the purification process with vertical zone-melting technique.The results indicate that the method is reliable.The equilibrium distribution coefficients are below 0.3 except arsenic.展开更多
How snow cover changes in response to climate change at different elevations within a mountainous basin is a less investigated question. In this study we focused on the vertical distribution of snow cover and its rela...How snow cover changes in response to climate change at different elevations within a mountainous basin is a less investigated question. In this study we focused on the vertical distribution of snow cover and its relation to elevation and temperature within different elevation zones of distinct climatology, taking the mountainous Manasi River Basin of Xinjiang, Northwest China as a case study. Data sources include MODIS 8-day snow product, MODIS land surface temperature(LST) data from 2001 to 2014, and in situ temperature data observed at three hydrological stations from 2001 to 2012. The results show that:(1) the vertical distribution of snow areal extent(SAE) is sensitive to elevation in low(<2100 m) and high altitude(>3200 m) regions and shows four different seasonal patterns, each pattern is well correspondent to the variation of temperature.(2) The correlation between vertical changes of the SAE and temperature is significant in all seasons except for winter.(3) The correlation between annual changes of the SAE and temperature decreases with increasing elevation, the negative correlation is significant in area below 4000 m.(4) The snow cover days(SCDs) and its long-term change show visible differences in different altitude range.(5) The long-term increasing trend of SCDs and decreasing trend of winter temperature have a strong vertical relation with elevation below 3600 m. The decreasing trend of SCDs is attributed to the increasing trend of summer temperature in the area above 3600 m.展开更多
Turbulence data(2008–2012) from a 325 m meteorological tower in Beijing, which consisted of three layers(47,140, and 280 m), was used to analyze the vertical distribution characteristics of turbulent transfer over Be...Turbulence data(2008–2012) from a 325 m meteorological tower in Beijing, which consisted of three layers(47,140, and 280 m), was used to analyze the vertical distribution characteristics of turbulent transfer over Beijing city according to similarity theory. The conclusions were as follows.(1) Normalized standard deviations of wind speeds/ui * were plotted as a function only of a local stability parameter. The values under near-neutral conditions were 2.15, 1.61, and 1.19 at 47 m, 2.39, 1.75,and 1.21 at 140 m, and 2.51, 1.77, and 1.30 at 280 m, showing a clear increase with height. The normalized standard deviation of wind components fitted the 1/3 law under unstable stratification conditions and decreased with height under both stable and unstable conditions.(2) The normalized standard deviation of temperature fitted the.1/3 law in the free convection limit, but was quite scattered with different characteristics under near-neutral conditions. The normalized standard deviations of humidity and the CO2 concentration fitted the.1/3 law under unstable conditions, and remained constant under near-neutral and stable stratification. The normalized standard deviation of scalars, i.e., temperature, humidity, and CO2 concentration, all increased with height.(3) Compared with momentum, and the water vapor and CO2 concentrations, the turbulence correlation coefficient for heat was smaller under near-neutral conditions, but larger under both stable and unstable conditions. A dissimilarity between heat, and the water vapor and CO2 concentrations was observed in urban areas. The relative correlation coefficients between heat and each of momentum, humidity, and CO2 concentration(|rwT/ruw|, |rwT/rwc| and |rwT/ruq|) in the lower layers were always larger than in higher layers, except for the relative correlation coefficient between heat and humidity in an unstable stratification. Therefore, the ratio between heat and each of momentum, humidity, and CO2 concentration decreased with height.展开更多
文摘垂直数据分区技术从逻辑上将满足一定语义条件的数据库表属性存放在同一个物理块中,进而降低数据访问成本,提高查询效率.数据库查询负载中的每条查询通常只与数据库表中的部分属性有关,因此只需使用数据库表的某个属性子集便可以得到准确的查询结果.合理的垂直数据分区方式可以使大多数查询负载不需要扫描完整数据库就可以完成查询任务,从而达到减少数据访问量,提高查询处理效率的目的.传统的数据库垂直分区方法主要基于专家设置的启发式规则,分区策略粒度较粗,且不能根据负载的特征进行有针对性的分区优化.同时,当负载规模较大或者属性个数较多时,现有垂直分区方法执行时间过长,尤其无法满足数据库在线实时调优的性能需求.为此,提出在线环境下基于谱聚类的垂直数据分区方法(spectral clustering based vertical partitioning,SCVP),采用分阶段求解的思想,减少算法时间复杂度,加快分区执行速度.首先通过增加约束条件缩小解空间(即根据谱聚类生成初始分区),然后对解空间设计算法进行精细的搜索(即采用频繁项集和贪心搜索相结合的策略对初始分区进行优化).为了进一步提升SCVP在高维属性下的性能,提出了SCVP的改进版本SCVP-R(spectral clustering based vertical partitioning redesign).SCVP-R通过引入同域竞争机制、双败淘汰机制和循环机制,对SCVP在分区优化过程中的合并方案进行了进一步优化.在不同数据集上的实验结果表明,相比于目前最好的垂直分区方法,SCVP和SCVP-R有着更快的执行时间和更好的性能表现.
基金Supported by the Eleventh Five-year National Key Technology Research and Development Program of China (2007BAE58B01)
文摘The equilibrium distribution coefficients of 12 impurities （As,Fe,Ca,Co,Al,Cr,Cu,Mg,Mn,Ni,Pb,Zn） in phosphorus were obtained by measuring their effective distribution coefficients at zone travel rate of 3,5,10,15,and 20 mm·h-1 in the purification process with vertical zone-melting technique.The results indicate that the method is reliable.The equilibrium distribution coefficients are below 0.3 except arsenic.
基金National Natural Science Foundation of China,No.41271353
文摘How snow cover changes in response to climate change at different elevations within a mountainous basin is a less investigated question. In this study we focused on the vertical distribution of snow cover and its relation to elevation and temperature within different elevation zones of distinct climatology, taking the mountainous Manasi River Basin of Xinjiang, Northwest China as a case study. Data sources include MODIS 8-day snow product, MODIS land surface temperature(LST) data from 2001 to 2014, and in situ temperature data observed at three hydrological stations from 2001 to 2012. The results show that:(1) the vertical distribution of snow areal extent(SAE) is sensitive to elevation in low(<2100 m) and high altitude(>3200 m) regions and shows four different seasonal patterns, each pattern is well correspondent to the variation of temperature.(2) The correlation between vertical changes of the SAE and temperature is significant in all seasons except for winter.(3) The correlation between annual changes of the SAE and temperature decreases with increasing elevation, the negative correlation is significant in area below 4000 m.(4) The snow cover days(SCDs) and its long-term change show visible differences in different altitude range.(5) The long-term increasing trend of SCDs and decreasing trend of winter temperature have a strong vertical relation with elevation below 3600 m. The decreasing trend of SCDs is attributed to the increasing trend of summer temperature in the area above 3600 m.
基金supported by the National Nature Science Foundation of China (Grant Nos. 41275023, 91537212 & 410210040)
文摘Turbulence data(2008–2012) from a 325 m meteorological tower in Beijing, which consisted of three layers(47,140, and 280 m), was used to analyze the vertical distribution characteristics of turbulent transfer over Beijing city according to similarity theory. The conclusions were as follows.(1) Normalized standard deviations of wind speeds/ui * were plotted as a function only of a local stability parameter. The values under near-neutral conditions were 2.15, 1.61, and 1.19 at 47 m, 2.39, 1.75,and 1.21 at 140 m, and 2.51, 1.77, and 1.30 at 280 m, showing a clear increase with height. The normalized standard deviation of wind components fitted the 1/3 law under unstable stratification conditions and decreased with height under both stable and unstable conditions.(2) The normalized standard deviation of temperature fitted the.1/3 law in the free convection limit, but was quite scattered with different characteristics under near-neutral conditions. The normalized standard deviations of humidity and the CO2 concentration fitted the.1/3 law under unstable conditions, and remained constant under near-neutral and stable stratification. The normalized standard deviation of scalars, i.e., temperature, humidity, and CO2 concentration, all increased with height.(3) Compared with momentum, and the water vapor and CO2 concentrations, the turbulence correlation coefficient for heat was smaller under near-neutral conditions, but larger under both stable and unstable conditions. A dissimilarity between heat, and the water vapor and CO2 concentrations was observed in urban areas. The relative correlation coefficients between heat and each of momentum, humidity, and CO2 concentration(|rwT/ruw|, |rwT/rwc| and |rwT/ruq|) in the lower layers were always larger than in higher layers, except for the relative correlation coefficient between heat and humidity in an unstable stratification. Therefore, the ratio between heat and each of momentum, humidity, and CO2 concentration decreased with height.
