Optimization of Analytic Window Functions

Analytic functions represent the state-of-the-art way of performing complex data analysis within a single SQL statement. In particular, an important class of analytic functions that has been frequently used in commercial systems to support OLAP and decision support applications is the class of window functions. A window function returns for each input tuple a value derived from applying a function over a window of neighboring tuples. However, existing window function evaluation approaches are based on a naive sorting scheme. In this paper, we study the problem of optimizing the evaluation of window functions. We propose several efficient techniques, and identify optimization opportunities that allow us to optimize the evaluation of a set of window functions. We have integrated our scheme into PostgreSQL. Our comprehensive experimental study on the TPC-DS datasets as well as synthetic datasets and queries demonstrate significant speedup over existing approaches.Comment: VLDB201

A Study on Water Utilization in Chinese Rural Areas

In China, because rural population is great and agriculture is very important in national economy, rural areas have becomes a main sphere of water consume. There exist the problems of water shortage and water waste in the countryside. The conflicts of water resource supply and demand between industry and agriculture are very conspicuous. Various factors that include ideology, finance, technology, management and policy restrict the rational and effective use of water resource. The survey on the villages of Jia Ge Zhuang and Yao Bai Zhuang in Ji County, Tianjin reflects these problems. The government tries to solve the problems by making laws and policies, as well as affording financial and technology support to towns and villages. At the same time, it is necessary for the government to make officials and farmers realize the importance of rational water usage and saving by doing propaganda, coordinating the inter-governments relations, and defining the departments’ duties. For realizing the objective of rational water usage, it is necessary to take measures to construct and perfect irrigation installations by both superior and local governments’ investment and farmers’ labor force. Key Words: Chinese Rural Areas, Water Resource, Rational Use, Farmland, Irrigation System Résumé: En Chine,la population est grande et l’agriculture est très importante dans l’économie nationale. Les régions rurales sont devenues un sphère principal de la consommation d’eau. Il existe les problèmes d’insuffisance d’eau et le gaspillage d’eau dans la campagne. Les conflits sur les resources d’eau fournie et demandée entre industrie and agriculture sont très fréquents. Les facteurs variés tels qu’idéologie, finance, technologie, management et politique limitent l’usage rationel et effectif de ressources d’eau. L’enquête sur les villages de Jia Ge Zhuang et Yao Bai Zhuang dans le pays Ji, Tianjin reflète ces problèmes. Le government tente de résoudres les problèmes par l’élabortion des lois et les poliques, ainsi que le support financierl et technologique aux bourgs et villages. Au meme temps, il est nécessaire pour le government à render conscients les officiels et les paysans l’ importance de l’usage rationel en économisant par la publicité, en coordonnant les relations inter-governmentaux, et en déterminant les tâches des départments. Pour la realiser l’objectif de l’usage d’eau rational, il est nécessaire de prendre des mesures pour construire et perfectionner l’ installations d’irrigation par l’investissement des governements supérieurs et locaux ainsi que les forces des labeurs. Mots clés: Les régions rurales chionoises, Ressource d’eau, usage rationel, fermier, Système d’ Irrigatio

Credit Rationing and Firm Exports: Micro Evidence from SMEs in China

In this study we examine the effect of credit rationing on export performance for small and medium sized firms in China. We use a detailed firm-level data provided by the Small and Medium-sized Enterprises Dynamic Survey (SMEDS) to conduct this analysis. SMEDS provides firm-specific measures of credit rationing based directly on firm-level responses to the survey rather than indirectly from firm-level financial statements. We find that, at the extensive margin, weak and strong credit rationing reduce SMEs' export probability by 22% and 36%, respectively. At the intensive margin, they decrease SMEs' export values by more than 32% and over 66%, respectively. Different from existing literature, we construct valid firm-level instruments, firm-level housing investments and receivables, for credit rationing rather than using province-level instruments. In addition, credit rationing exhibits heterogeneous impacts on firms with different liquidity ratios, product portfolios, external collateral and capital utilization rates

Ferrocen­yl(meth­yl)diphenyl­silane

In the title mol­ecule, [Fe(C5H5)(C18H17Si)], the distances of the Fe atom from the centroids of the unsubstituted and substituted cyclo­penta­dienyl (Cp) rings are 1.651 (1) and 1.646 (1) Å, respectively. The dihedral angle between the two Cp rings is 3.20 (17)°. The crystal packing is mainly stabilized by van der Waals forces