Aggregate function

Nội dung trình bày trong bài giảng này gồm có: Hibernate Query Language (HQL), HQL - from HQL - select, HQL - aggregate function, HQL - where, HQL - Expression, HQL - order by, HQL - group by & having, HQL - sub query.

31p shiwo_ding10 04-08-2019 19 4   Download

Chapter 8 describes more advanced features of the SQL language standard for relational databases. In this chapter present more complex features of SQL retrieval queries, such as nested queries, joined tables, outer joins, aggregate functions, and grouping.

71p kiepnaybinhyen_04 15-12-2015 61 3   Download

Bài giảng "Hibernate query language" trình bày các nội dung: Hibernate Query Language, HQL – from, HQL – selec, HQL – aggregate function, HQL – where, HQL - Expression, HQL – order by, HQL – group by và having, HQL – sub query. Mời các bạn cùng tham khảo nội dung chi tiết.

32p nhansinhaoanh_03 21-10-2015 77 6   Download

Heterologous expression of the extracellular domains (ECDs) of the nicotinic acetylcholine receptor (AChR) subunits may give large amounts of proteins for studying the functional and spatial characteristics of their ligand-binding sites. The ECD of the a7 subunit of the homo-oligomeric a7 neuronal AChR appears to be a more suitable object than the ECDs of other heteromeric neuronal or muscle-type AChRs. The rat a7 ECDs (amino-acid residues  1–210) were recently expressed in Escherichia coli as fusion proteins with maltose-binding protein...

9p system191 01-06-2013 37 3   Download

Hemolin, a plasma protein from lepidopteran insects, is composed of four immunoglobulin domains. Its synthesis is induced by microbial challenge. We investigated the biological functions of hemolin inManduca sexta.It was found to bind to the surface of bacteria and yeast, and caused these micro-organisms to aggregate. Hemolin was demonstrated to bind to lipopolysaccharide (LPS) from Gram-negativebacteriaand to lipoteichoic acid fromGram-positive bacteria.

8p research12 23-04-2013 36 2   Download

a-Crystallin, a molecular chaperone and lens structural protein protects soluble enzymes against heat-induced aggregation and inactivation by a variety of molecules. In this study we investigated the chaperone function ofa-crys-tallininamorephysiological systeminwhicha-crystallinwas incorporated into red cell
ghosts. Its ability to protect the intrinsic membrane protein Na/K-ATPase from external stresses was studied. Red cell ghosts were created by lysing the red cells and removing cytoplasmic contents by size-exclusion chromatography. ...

7p fptmusic 16-04-2013 48 2   Download

Small heat shock proteins (sHSPs) function as molecular chaperones, pre-venting stress induced aggregation of partially denatured proteins and pro-moting their return to native conformations when favorable conditions pertain. Sequence similarity between sHSPs resides predominately in an internal stretch of residues termed the a-crystallin domain, a region usually flanked by two extensions.

15p awards 06-04-2013 37 3   Download

Recently, a novel plaque-associated protein, collagenous Alzheimer amy-loid plaque component (CLAC), was identified in brains from patients with Alzheimer’s disease. CLAC is derived from a type II transmembrane colla-gen precursor protein, termed CLAC-P (collagen XXV). The biological function and the contribution of CLAC to the pathogenesis of Alzheimer’s disease and plaque formation are unknown.

0p awards 06-04-2013 27 2   Download

The hemocyanin of the tiger shrimp,Penaeus monodon, was investigated with respect to stability and oxygen binding. While hexamers occur as a major component, dodecamers and traces of higher aggregates are also found. Both the hexamers and dodecamers were found to be extremely sta-ble against dissociation at high pH, independently of the presence of cal-cium ions, in contrast to the known crustacean hemocyanins.

16p awards 06-04-2013 35 3   Download

It is well established that in addition to its functional role in cell motility, cell division and intracellular transport, cyto-skeletal protein tubulin also possesses significant chaperone-like activity. In vitro studies from our laboratory showed that dimeric tubulin can prevent stress induced aggregation of substrate proteins, can resist thermal deactivation of enzymes and can also refold enzymes from their fully dena-tured state [Manna, T., Sarkar, T., Poddar, A., Roy-chowdhury, M., Das, K.P. & Bhattacharyya, B....

9p dell39 03-04-2013 34 3   Download

We have investigated the molecular mechanisms that produce different structural and functional behavior in the monomeric and trimeric forms of seminal vesicle protein no. 4, a protein with immunomodulatory, anti-inflamma-tory, and procoagulant activity secreted from the rat seminal vesicle epithelium. The monomeric and trimeric forms were characterized in solution by CD.

9p dell39 03-04-2013 34 5   Download

a-synuclein is one of a family of proteins whose function remains unknown. This protein has become linked to a number of neurodegenera-tive disease although its potential causative role in these diseases remains mysterious. In diseases such as Parkinson’s disease and Lewy body demen-tias, a-synuclein becomes deposited in aggregates termed Lewy bodies.

9p galaxyss3 21-03-2013 51 3   Download

The functions of long smooth muscle myosin light chain kinase (L-MLCK), a molecule with multiple domains, are poorly understood. To examine the existence of further potentially functional domains in this molecule, we ana-lyzed its amino acid sequence with a tangoprogram and found a putative aggregation domain located at the 4Ig domain of the N-terminal extension.

12p media19 06-03-2013 29 3   Download

Many human proteins have homopolymeric amino acid (HPAA) tracts, but their physiological functions or cellular effects are not well understood. Previously, we expressed 20 HPAAs in mammalian cells and showed char-acteristic intracellular localization, in that hydrophobic HPAAs aggregated strongly and caused high cytotoxicity in proportion to their hydrophobic-ity.

9p media19 04-03-2013 45 2   Download

Small heat shock proteins (sHsps) are intracellular molecular chaperones that prevent the aggregation and precipitation of partially folded and destabilized proteins. sHsps comprise an evolutionarily conserved region of 80–100 amino acids, denoted thea-crystallin domain, which is flanked by regions of variable sequence and length: the N-terminal domain and the C-terminal extension.

14p vinaphone15 28-02-2013 34 2   Download

Mutations in the E3 ubiquitin ligase parkin cause early-onset, autosomal-recessive juvenile parkinsonism (AJRP), presumably as a result of a lack of function that alters the level, activity, aggregation or localization of its sub-strates. Recently, we have reported that phospholipase Cc1 is a substrate for parkin.

12p vinaphone15 25-02-2013 40 3   Download

One of the most important pathological features of type 2 diabetes is the formation of islet amyloid, of which the major component is amylin pep-tide. However, the presence of a natural inhibitor such as insulin may keep amylin stable and physiologically functional in healthy individuals. Some previous studies demonstrated that insulin was a potent inhibitor of amylin fibril formationin vitro, but others obtained contradictory results.

7p viettel02 22-02-2013 41 3   Download

After completing this lesson, you should be able to do the following: Identify the available group functions Describe the use of group functions Group data using the GROUP BY clause Include or exclude grouped rows by using the HAVING clause

30p trinh02 28-01-2013 48 3   Download

Fragile X mental retardation protein (FMRP) is an RNA binding protein necessary for correct spatiotemporal control of neuronal gene expression in humans. Lack of functional FMRP causes fragile X mental retardation, which is the most common inherited neurodevelopmental disorder in humans.

10p cosis54 05-01-2013 45 4   Download

TDP-43 (transactive response binding protein of 43 kDa) and FUS (fused in sarcoma) comprise the neuropathological protein aggregates of distinct subtypes of the neurodegenerative diseases frontotemporal lobar degen-eration and amyotrophic lateral sclerosis.

19p cosis54 09-12-2012 58 4   Download