SQL Query Design Patterns and Best Practices : A practical guide to writing readable and maintainable SQL queries using its design patterns / by Hughes, Steve, author 656330, Neer, Dennis, author 656331, Singh, Ram Babu, 1955-, author 172446, Mala, Shabbir H., author 656332, Andrews, Leslie, author 656333, Zhang, Chi, author 656334, Packt Publishing (Online service) 656336

“…Enhance your SQL query writing skills to provide greater business value using advanced techniques such as common table expressions, window functions, and JSON Purchase of the print or Kindle book includes a free PDF eBook Key Features Examine query design and performance using query plans and indexes Solve business problems using advanced techniques such as common table expressions and window functions Use SQL in modern data platform solutions with JSON and Jupyter notebooks Book Description SQL has been the de facto standard when interacting with databases for decades and shows no signs of going away. Through the years, report developers or data wranglers have had to learn SQL on the fly to meet the business needs, so if you are someone who needs to write queries, SQL Query Design and Pattern Best Practices is for you. …”
Get full text
Get full text

Expediting treatments in the 21st century: orphan drugs and accelerated approvals by Domike, Reuben, Raju, G. K., Sullivan, Jamie, Kennedy, Annie

“…Although orphan drug approvals based on NMEs are the minority of orphan drug designations, the count of approved orphan drug NMEs has increased in recent years. The characteristics of orphan drug approvals show notable differences by disease area with rare diseases and medical genetics (49%) having a relatively large fraction of orphan drug approvals with NMEs compared to the oncological diseases (32%). …”
Get full text

Beyond Color: Lattice Gauge Theory for Strongly-Coupled Physics by Oare, Patrick R.

“…The primary focus of LGT in the 40 years since its inception has been the study of QCD, as the theory has direct physical relevance to so much of our universe, and the desire to understand QCD has driven many conceptual breakthroughs and advancements in LGT. …”
Get full text

Opportunities and Limitations of Earth Observation Technology for Environmental Justice Advocacy: A Case Study of Toxic Prisons in the U.S. by Ovienmhada, Ufuoma

“…In Design/Prescription, first, supported by 3 years of community engagement with prison EJ activists, I present the Design of a GIS decision support system that features EO data responding to expressed needs of prison EJ activists. …”
Get full text
Get full text

Memory Checking Requires Logarithmic Overhead by Boyle, Elette, Komargodski, Ilan, Vafa, Neekon

“…Memory checkers, first introduced over 30 years ago by Blum, Evans, Gemmel, Kannan, and Naor (FOCS '91, Algorithmica '94), allow a user to store and maintain a large memory on a remote and unreliable server by using small trusted local storage. …”
Get full text

Creative ageing in Singapore : a population study on participatory arts engagement and wellbeing among adults aged 50 and above by Ma, Stephanie Hilary Xinyi

“…Adopting a cross-sectional stratified random household survey, 1,067 community-dwelling Singaporean older adults between the ages of 50-95 years were recruited from all residential areas across Singapore. …”
Get full text

Feature extraction from EEG signals and regularization for brain-computer interface by Mishuhina, Vasilisa

“…Consequently, it has received tremendous research interest in recent years. Various methods of signal processing and machine learning supported by neuroscience, have made it possible to extract useful information from the brain. …”
Get full text

Detection of latent fingerprint using optical technique by Seah, Leong Keey., Ong, Lin Seng., Murukeshan, Vadakke Matham.

“…Often, when fingerprints deposited on strongly fluorescing backgrounds, their separation offer a challenging problem to fingerprint experts.Experiments were carried out for imaging the latent fingerprints, which are deposited on strongly fluorescing backgrounds, even when background fluorescence lifetime is longer than that of fingerprint fluorescence. Imaging of two years old fingerprints were also carried out with improved contrast. …”
Get full text

The combined role of MRI prostate and prostate health index in improving detection of significant prostate cancer in a screening population of Chinese men by Chiu, Peter K. F., Lam, Thomas Y. T., Ng, Chi-Fai, Teoh, Jeremy Y. C., Cho, Carmen C. M., Hung, Hiu-Yee, Hong, Cindy, Roobol, Monique J., Chu, Winnie C. W., Wong, Samuel Y. S., Sung, Joseph Jao Yiu

“…We aimed to investigate the value of prostate health index (PHI) and magnetic resonance imaging (MRI) prostate in an Asian PCa screening program. Men aged 50-75 years were prospectively recruited from a community-based PSA screening program. …”
Get full text

Study of online reviewers in a UGC community by Phyu Mon Theint

“…Imdb.com was selected as a source for the dataset in this research due to its abundance of existing data since the website has been in existence for over 20 years. The volume itself will stand as a good source for sampling. …”
Get full text

Enviro-toons : what do parents think about it? by Goh, Jeannette

“…In recent years there has been an increased societal focus on the detrimental effects that modernization has brought upon the environment, leading to more attention being put into solving these environmental issues. …”
Get full text

Modeling, optimization and thermal characterization of micropillar evaporator based high performance silicon vapor chamber by Wei, Mengyao

“…To overcome the high heat generation challenge and ensure sustainable development in the semiconductor industries, thermal management for high density electronic devices has drawn much attention in recent years. Being a passive thermal management device with high heat removal capability, vapor chamber that spreads concentrated heat via liquid-to-vapor phase change phenomena was proven to be a promising cooling technique. …”
Get full text

Efficient algorithms for embedded optimisation-based control by Dang, Van Thuy

“…Solving optimisation problem is computationally demanding, and hence Model Predictive Control (MPC), an optimisation-based control technology, is traditionally employed in applications with slow dynamics. In recent years, due to its ability to systematically handling constraints and multiple-input and multiple-output systems, MPC has been extended to many non-traditional areas, in particular networked or embedded applications. …”
Get full text
Get full text

Alkaline earth complexes supported by chelating diamido ligands by Haynes, M

“…<p>The alkaline earth metals magnesium, calcium, strontium and barium have received increasing attention in recent years due to their high abundance, low cost and biocompatibility. …”

Contraceptive experience and factors associated with desire for postpartum family planning among pregnant women of the nkongsamba health district, Littoral Region, Cameroon by Ajong, AB, Yakum, MN, Mangala, FN, Bekolo, CE, Agbor, VN, Waffo, LM, Kenfack, B

“…Compared to their respective counterparts, participants ≤ 30 years old (AOR = 0.71[0.52–0.99]), with monthly revenue below 100 thousand FCFA (AOR = 0.45[0.32–0.62]), who were single (AOR = 0.38[0.27–0.54]), had lower odds for desire of postpartum family planning. …”

Long Covid: a global health issue – a prospective, cohort study set in four continents by Pazukhina, E, Garcia-Gallo, E, Reyes, LF, Kildal, AB, Jassat, W, Dryden, M, Holter, JC, Chatterjee, A, Gomez, K, Søraas, A, Puntoni, M, Latronico, N, Bozza, FA, Edelstein, M, Gonçalves, BP, Kartsonaki, C, Kruglova, O, Gaião, S, Chow, YP, Doshi, Y, Duque Vallejo, SI, Ibáñez-Prada, ED, Fuentes, YV, Hastie, C, O'Hara, ME, Balan, V, Menkir, T, Merson, L, Kelly, S, Citarella, BW, Semple, MG, Scott, JT, Munblit, D, Sigfrid, L

“…<p><strong> Results </p></strong>Of 11 860 participants (median age: 52 (IQR: 41–62) years; 52.1% females), 56.5% were from HICs and 43.5% were from LMICs. …”

Imagined futures and relational agency in nurses' writing transitions: a qualitative study across two writing group interventions in a higher education setting by Waite, M

“…</p> <p>I collected data through participant observation, samples of writing-in-development, and individual narratives spanning up to three years. I analysed the data through a conceptual framework that draws theoretically from a sociocultural understanding of developmental transitions and a cultural-historical perspective on relational agency.…”

Cost-effectiveness of a group psychological intervention for postnatal depression in British South Asian mothers: an economic evaluation from the ROSHNI-2 trial by Ullah, A, Lunat, F, Brugha, T, Pierce, M, Morriss, R, Sharma, D, Rahman, A, Bhui, K, Bower, P, Husain, N

“…</p> <br> <p><strong>Outcomes:</strong> The base-case intention-to-treat analysis showed PHP significantly increased costs (£912, 95% CI £420–£1405) and quality-adjusted life years (QALYs) (0.037, CI 0.006–0.068), with an incremental cost-effectiveness ratio (ICER) of £24,739 (CI £15,539–£39,692). …”

Transforming kernel-based learners to incorporate domain knowledge from climate science by Bouabid, S

“…<p>In the face of persistent modelling and observational challenges in climate science, which hinder our understanding of the climate system, statistical machine learning has emerged as a potential ally in recent years. Modern machine learning methods promise to leverage the vast volumes of data from climate model simulations, satellite imagery, or in-situ measurements to advance our understanding of the climate system and, thereby, our ability to anticipate the adverse consequences of climate change. …”

Expressions of grief on the early modern stage by Welch, K

“…Tracking fake funerals over this time period revealed a sharp increase in this device after 1603, which the final chapter suggests is related to anxieties over public performances of mourning after Elizabeth I's death and one of the worst plague years on record.</p> <p>Performances of theatrical mourning thus occur displaced in time, preemptive requests for a death not to happen rather than the belated wish to bring the dead back to life. …”