Zhenglin Xu
Current Organizations / Institutes
The organizations/institutes from the scholar's latest article
Previous Organizations / Institutes
The organizations / institutes from the scholar's other articles in the past ten years
Research Subjects
Zhenglin Xu has a total of 10 co-authors. Here are the top co-authors by number of shared publications:
- Bin Tang
Institute for Frontier Materials Deakin University Geelong VIC Australia
1 shared publication - Daiqi Li
State Key Laboratory of New Textile Materials and Advanced Processing Technologies Wuhan Textile University Wuhan 430200 P. R. China
1 shared publication - Dexin Zhang
Shanghai Jiao Tong University, Shanghai, China
1 shared publication - Guangming Cai
State Key Laboratory of New Textile Materials and Advanced Processing Technologies & School of Textile Science and Engineering Wuhan Textile University Wuhan 430200 China
1 shared publication - Haibo Chen
Shanghai Jiao Tong University, Shanghai, China
1 shared publication - Haoran Ding
Shanghai Jiao Tong University, Shanghai, China
1 shared publication
Latest Publications
- Open Access
- 8 December 2023
- Published by Association for Computing Machinery (ACM) in Proceedings of the ACM on Management of Data
- Vol. 1 (4) , 1-26
Proving Query Equivalence Using Linear Integer Arithmetic
Proving the equivalence between SQL queries is a fundamental problem in database research. Existing solvers model queries using algebraic representations and convert such representations into first-order logic formulas so that query equivalence can be verified by solving a satisfiability problem. The main challenge lies in "unbounded summations", which appear commonly in a query's algebraic representation in order to model common SQL features, such as projection and aggregate functions. Unfortunately, existing solvers handle unbounded summations in an ad-hoc manner based on heuristics or syntax comparison, which severely limits the set of queries that can be supported. This paper develops a new SQL equivalence prover called SQLSolver, which can handle unbounded summations in a principled way. Our key insight is to use the theory of LIA^*, which extends linear integer arithmetic formulas with unbounded sums and provides algorithms to translate a LIA^* formula to a LIA formula that can be decided using existing SMT solvers. We augment the basic LIA^* theory to handle several complex scenarios (such as nested unbounded summations) that arise from modeling real-world queries. We evaluate SQLSolver with 359 equivalent query pairs derived from the SQL rewrite rules in Calcite and Spark SQL. SQLSolver successfully proves 346 pairs of them, which significantly outperforms existing provers.
- 8 December 2023
- Published by Association for Computing Machinery (ACM) in Proceedings of the ACM on Management of Data
- Vol. 1 (4) , 1-26
Open AccessProving Query Equivalence Using Linear Integer Arithmetic
Proving the equivalence between SQL queries is a fundamental problem in database research. Existing solvers model queries using algebraic representations and convert such representations into first-order logic formulas so that query equivalence can be verified by solving a satisfiability problem. The main challenge lies in "unbounded summations", which appear commonly in a query's algebraic representation in order to model common SQL features, such as projection and aggregate functions. Unfortunately, existing solvers handle unbounded summations in an ad-hoc manner based on heuristics or syntax comparison, which severely limits the set of queries that can be supported. This paper develops a new SQL equivalence prover called SQLSolver, which can handle unbounded summations in a principled way. Our key insight is to use the theory of LIA^*, which extends linear integer arithmetic formulas with unbounded sums and provides algorithms to translate a LIA^* formula to a LIA formula that can be decided using existing SMT solvers. We augment the basic LIA^* theory to handle several complex scenarios (such as nested unbounded summations) that arise from modeling real-world queries. We evaluate SQLSolver with 359 equivalent query pairs derived from the SQL rewrite rules in Calcite and Spark SQL. SQLSolver successfully proves 346 pairs of them, which significantly outperforms existing provers.
- 26 April 2019
- Published by SAGE Publications in Textile Research Journal
- Vol. 89 (23-24) , 4929-4937
Study on the effect of an inert atmosphere for the heat treatment coloration of wool fabric
This article is focused on a novel method to color wool fabric via heat treatment under an inert atmosphere. It can not only give new color to the fabric but also minimize pollution, because it is water and dye-free. The effects of temperature, time and different inert atmospheres (nitrogen, argon) used in the heat treatment on wool fabric color were studied. The bending stiffness, the crease recovery angle and tensile testing were used to analyze the mechanical properties of wool fabric before and after heat treatment. The color fastness to soaping and light of wool fabric after inert atmosphere heat treatment were compared with that of traditional basic yellow dyed wool fabric. The results showed that the K/S value of wool fabric treated with a nitrogen and argon atmosphere increased with the increasing temperature and time. Under the same heat treatment conditions, the maximum K/S value of fabric heat treated under nitrogen was higher than that under argon. The bending stiffness and crease recovery angle performance were improved and positively correlated with the heat treatment temperature and time. The samples treated under the same conditions under nitrogen showed higher bending stiffness and a lower crease recovery angle than under argon. The contact angle of the wool fabric after the treatment would decrease first and then increase with the increasing temperature. The tensile strength of the wool fabric would decrease with increasing temperature and time of the heat treatment in both nitrogen and argon, and the tensile strength of the wool fabric after treatment was higher than 80% of the original tensile strength, although the breaking elongation decreased. The color fastness to soaping and light of wool fabric after inert atmosphere heat treatment were better than for the traditional basic yellow dyed wool fabric. Therefore, the use of inert atmosphere heat treatment to endow wool fabric color is a potential research direction.
- 26 April 2019
- Published by SAGE Publications in Textile Research Journal
- Vol. 89 (23-24) , 4929-4937
Study on the effect of an inert atmosphere for the heat treatment coloration of wool fabric
This article is focused on a novel method to color wool fabric via heat treatment under an inert atmosphere. It can not only give new color to the fabric but also minimize pollution, because it is water and dye-free. The effects of temperature, time and different inert atmospheres (nitrogen, argon) used in the heat treatment on wool fabric color were studied. The bending stiffness, the crease recovery angle and tensile testing were used to analyze the mechanical properties of wool fabric before and after heat treatment. The color fastness to soaping and light of wool fabric after inert atmosphere heat treatment were compared with that of traditional basic yellow dyed wool fabric. The results showed that the K/S value of wool fabric treated with a nitrogen and argon atmosphere increased with the increasing temperature and time. Under the same heat treatment conditions, the maximum K/S value of fabric heat treated under nitrogen was higher than that under argon. The bending stiffness and crease recovery angle performance were improved and positively correlated with the heat treatment temperature and time. The samples treated under the same conditions under nitrogen showed higher bending stiffness and a lower crease recovery angle than under argon. The contact angle of the wool fabric after the treatment would decrease first and then increase with the increasing temperature. The tensile strength of the wool fabric would decrease with increasing temperature and time of the heat treatment in both nitrogen and argon, and the tensile strength of the wool fabric after treatment was higher than 80% of the original tensile strength, although the breaking elongation decreased. The color fastness to soaping and light of wool fabric after inert atmosphere heat treatment were better than for the traditional basic yellow dyed wool fabric. Therefore, the use of inert atmosphere heat treatment to endow wool fabric color is a potential research direction.