Engineering Papers⌕ Search

Engineering topics

Yan, Cong

Publications and source records attributed to Yan, Cong.

Towards Auto-Generated Data Systems

After decades of progress, database management systems (DBMSs) are now the backbones of many data applications that we interact with on a daily basis. Yet, with the emergence of new data types and hardware, building and optimizing new data systems remain as difficult as the heyday of relational databases. In this paper, we summarize our work towards automating the building and optimization of data systems. Drawing from our own experience, we further argue that any automation technique must address three aspects: user specification, code generation, and result validation. We conclude by discussing a case study using videos data processing, along with opportunities for future research towards designing data systems that are automatically generated.

Computer Science↗

Leveraging Application Data Constraints to Optimize Database-Backed Web Applications

Exploiting the relationships among data is a classical query optimization technique. As persistent data is increasingly being created and maintained programmatically, prior work that infers data relationships from data statistics misses an important opportunity. We present Coco, the first tool that identifies data relationships by analyzing database-backed applications. Once identified, Coco leverages the constraints to optimize the application's physical design and query execution. Instead of developing a fixed set of predefined rewriting rules, Coco employs an enumerate-test-verify technique to automatically exploit the discovered data constraints to improve query execution. Each resulting rewrite is provably equivalent to the original query. Using 14 real-world web applications, our experiments show that Coco can discover numerous data constraints from code analysis and improve real-world application performance significantly.

Computer Science↗

Employing a Narrow-Band-Gap Mediator in Ternary Solar Cells for Enhanced Photovoltaic Performance

Ternary organic solar cells (OSCs) provide a convenient and effective means to further improve the power conversion efficiency (PCE) of binary ones via composition control. However, the role of the third component remains to be explored in specific binary systems. Herein, we report ternary blend solar cells by adding the narrow-band-gap donor PCE10 as the mediator into the PBDB-T:IDTT-T binary blend system. The extended absorption, efficient fluorescence resonance energy transfer, enhanced charge dissociation, and induced tighter molecular packing of the ternary blend films enhance the photovoltaic properties of devices and deliver a champion PCE of 10.73% with an impressively high open-circuit voltage (VOC) of 1.03 V. Good miscibility and similar molecular packing behavior of the components guarantee the desired morphology in the ternary blend films, leading to solar cell devices with over 10% PCEs at a range of compositions. Our results suggest that ternary systems with properly aligned energy levels and overlapping absorption among the components hold great promises to further enhance the performance of corresponding binary ones.

14 SOLAR ENERGY↗

Ubiquitin C-Terminal Hydrolase L1 regulates autophagy by inhibiting autophagosome formation through its deubiquitinating enzyme activity

Highlights: • UCHL1 interacts with LC3 and inhibits autophagosome formation. • UCHL1 Parkinson mutant I93 M abolishes to suppress autophagosome formation. • UCHL1 inhibitors LDN-57444 and NSC632839 promote autophagosome formation in cells. Ubiquitination modification has been shown to play a key role in autophagy. Increasing studies reported the involvement of de-ubiquitinating enzymes (DUBs) in autophagy pathway. To systematically search how DUBs manipulate autophagy, we utilized a double fluorescence tagged LC3 stable HeLa cell line, and did a genome wide screen of 55 human DUBs which is about 60% coverage of the DUB family. We found a bunch of DUBs have impact on autophagy by either changing the LC3 puncta formation or the autophagy flux. One of them, Ubiquitin C-Terminal Hydrolase L1 (UCHL1) correlated to Parkinson's disease, strongly affects autophagy by inhibiting autophagosome formation. We found UCHL1 overexpression inhibits LC3 puncta formation and is dependent on its DUB activity. Knockdown of UCHL1 significantly promotes LC3 puncta formation. Further study revealed that UCHL1 may affect autophagy by interacting with LC3 but not other autophagy related proteins. Interestingly, a Parkinson's disease related mutant UCHL1 I93 M defects its DUB activity and can no longer inhibit autophagosome formation. We further screened 22 commercially available DUB inhibitors and found two potent UCHL1 inhibitors LDN-57444 (LDN) and NSC632839 (NSC), when treating cells, both strongly induce LC3 puncta formation. Taken together, our results indicated a new insight into the manner in which DUB regulates autophagy and provided potential drugs for the Parkinson's disease.

60 APPLIED LIFE SCIENCES↗