Seeking the truth about ad hoc join costs

In this paper, we re-examine the results of prior work on methods for computing ad hoc joins. We develop a detailed cost model for predicting join algorithm performance, and we use the model to develop cost formulas for the major ad hoc join methods found in the relational database literature. We show that various pieces of “common wisdom” about join algorithm performance fail to hold up when analyzed carefully, and we use our detailed cost model to derive op timal buffer allocation schemes for each of the join methods examined here. We show that optimizing their buffer allocations can lead to large performance improvements, e.g., as much as a 400% improvement in some cases. We also validate our cost model's predictions by measuring an actual implementation of each join algorithm considered. The results of this work should be directly useful to implementors of relational query optimizers and query processing systems. Edited by M. Adiba. Received May 1993 / Accepted April 1996     

A comparison of leaf-spring with aircushion trailer suspensions in the transport environment

Packaging engineers need to be able to accurately determine the forces present in the shipping environment in order to protect packaged goods. The purpose of this study was to determine the vertical vibration levels measured in three separate truck-trailer suspension systems; conventional leaf-spring, conventional air-ride and damaged air-ride. The main conclusion reached in this study is that the air-ride suspension when maintained gives lower power density (PD) levels on all road surfaces studied. A damaged air-ride suspension and leaf-spring suspension are very similar in response frequencies, although the damaged air-ride produces higher vibration levels at lower frequencies.     

反常声电光频谱分析器

介绍了一种新型的反常声电光频谱分析器，它可以采用外加电压的办法改变器件的中心频率，扩大器件的频带宽度，并改善器件在频带宽度范围内的频率响应特性。用ＬｉＮｂＯ３制作了一个６０ＭＨｚ的反常声电光频谱分析器件，测试结果表明，器件中心频率可以由５０ＭＨｚ变到７０ＭＨｚ，频带宽度由原来的２６ＭＨｚ扩大到３７ＭＨｚ。     

山东省水资源配置思路浅析

山东省总体上属于资源性缺水省份，合理配置水资源已成为解决水资源供需矛盾、保障经济社会可持续发展的关键问题之一。通过对山东省水资源的基本特点进行分析，建立了水资源合理配置系统模型及生成配置方案，在供需平衡分析的基础上，提出了水资源合理配置的基本思路。     

An accurate and practical buffer allocation model for the buffer cache based on marginal gains

A new dynamic buffer allocation strategy based on the notion of marginal gains is presented for the buffer cache that is used by the operating system to store frequently accessed disk blocks in main memory, and the performance of the proposed strategy is compared with those of previous allocation strategies. In the proposed strategy, marginal gain values are predicted by exploiting functions that approximate the expected number of buffer hits per unit time. Experimental results from both trace-driven simulation and an actual implementation in the FreeBSD operating system show that the proposed strategy accurately predicts the marginal gain values for various workloads resulting in significantly improved buffer hit ratios.     

单壁碳纳米管的制备及生长特性研究

采用Fe/MgO作为催化剂 ,催化裂解CH4制备了较纯的单壁碳纳米管 ,用TEM和Raman对碳纳米管进行了表征 ,对不同生长温度下制备的碳纳米管Raman径向呼吸振动峰 (RBM)进行了分析 ,研究了生长温度对单壁碳纳米管生长特性和结构特性的影响     

Allocation of Scarce Water Resources Using Deficit Irrigation in Rotational Systems

On irrigation schemes with rotational irrigation systems in semiarid tropics, the existing rules for water allocation are based on applying a fixed depth of water with every irrigation irrespective of the crops, their growth stages, and soils on which these crops are grown. However, when water resources are scarce, it is necessary to allocate water optimally to different crops grown in the irrigation scheme taking account of different soils in the command area. Allocating water optimally may lead to applying less water to crops than is needed to obtain the maximum yield. In this paper, a three stage approach is proposed for allocating water from a reservoir optimally based on a deficit irrigation approach, using a simulation-optimization model. The allocation results with a deficit irrigation approach are compared for a single crop (wheat) in an irrigation scheme in India, first with full irrigation (irrigation to fill the root zone to field capacity) and second with the existing rule. The full irrigation with a small irrigation interval was equivalent to adequate irrigation (no stress to the crop). It is found that practicing deficit irrigation enables the irrigated area and the total crop production in the irrigation scheme used for the case study to be increased by about 30–45% and 20–40%, respectively, over the existing rule and by 50 and 45%, respectively, over the adequate irrigation. Allocation of resources also varied with soil types.     

EPON媒体接入控制的关键技术研究

文章简要介绍了基于以及太网的无源光网络（EPON）这种新型的接入网技术，将其与基于ATM技术的无源光网络（APON）的优缺点进行了比较，并对其媒体接入控制（MAC）的关键技术测距及上行接入进行了讨论，初步提出了光网络单元（ONU）的软、硬件实现方案。     

STUDY ON PHASE PERCEPTION IN SPEECH

The perceptual effect of the phase information in speech has been studied by auditory subjective tests. On the condition that the phase spectrum in speech is changed while amplitude spectrum is unchanged, the tests show that: (1) If the envelop of the reconstructed speech signal is unchanged, there is indistinctive auditory perception between the original speech and the reconstructed speech; (2) The auditory perception effect of the reconstructed speech mainly lies on the amplitude of the derivative of the additive phase; (3) td is the maximum relative time shift between different frequency components of the reconstructed speech signal. The speech quality is excellent while td <10ms; good while 10ms< td <20ms; common while 20ms< td <35ms, and poor while td >35ms.     

自适应RBF神经网络在CDMA移动通信上行链路功率控制中的应用研究

提出了一种自适应RBF神经网络功率控制方案。详细研究了该网络在DS-CDMA通信中，进行上行链路闭环功率控制(基于信扰比(SIR))的应用理论，给出了该网络参数的计算方法。最后用计算机仿真法模拟出该控制器的运行性能。结果表明基于SIR的自适应RBF神经网络功率控制器能自适应地调整移动台的发射功率，使基站接收信号的信扰比始终非常接近于一个常数，且有比定步长功率控制更小的SIR跟踪误差，从而可以降低接收信号的中断概率、提高信道容量。