Entwurf und Implementierung eines SQL-normkonformen Datenbankkatalogs für ein relationales Datenbankmanagementsystem

Bei relationalen Datenbanksystemen haben sich de-jure-Normen für SQL stetig weiterentwickelt; mit diesen Normen wird es einfacher, portable Datenbankanwendungen zu entwickeln. Die SQL-Norm ruht auf zwei S?ulen, zum einen auf der Datenbanksprache SQL, zum anderen auf einer Vorgabe eines Datenbankkatalogs, welcher die gespeicherten Daten beschreiben soll. Im vorliegenden Beitrag wird derjenige Teilbereich des Datenbankkatalogs der aktuellen SQL99-Norm dargestellt, der bereits in der SQL92-Norm (ISO/IEC 9075:1992 bzw. DIN 66315) definiert ist und die klassischen (nicht objektrelationalen) Elemente einer relationalen Datenbank beschreibt. In dieser Darstellung nimmt der zweischichtige Spezifikationsansatz (Informationsschema, Definitionsschema) einigen Raum ein; mit seiner Hilfe weist SQL einen eleganten Weg, auf dem existierende Datenbanksysteme normkonforme Datenbankkataloge bereitstellen k?nnen. Anhand des Datenbankmanagementsystems DB2 wird anschlie?end untersucht, wie ein normkonformer Datenbankkatalog (das sogenannte Informationsschema) „oberhalb” des verfügbaren DB2-Katalogs realisiert werden kann, d. h. wie die vom Informationsschema geforderten Sichten auf DB2-Katalogtabellen abgebildet werden k?nnen. Auf generelle Schwierigkeiten und M?glichkeiten einer solchen Abbildung (ein- oder zweistufig) wird ebenso eingegangen wie auf Probleme, die sich speziell bei DB2 ergeben. In einer prototypischen Realisierung konnte das Informationsschema bis auf wenige Einschr?nkungen komplett umgesetzt werden. Damit wurde die Machbarkeit normkonformer Kataloge nachgewiesen. In heute verfügbaren DBMS-Produkten sind Datenbankkataloge in dieser konsequent normkonformen Gestalt leider immer noch nicht anzutreffen.     

新兴的数字化革命:打造图书馆员的领导力

香港大学图书馆领导研修班是为现任和未来图书馆领导而设的密集式培训班,预计参加者主要为现任或未来的馆长或助理馆长.研修班将采用英语作为主要讲授语言另辅以部分中文翻译,采取让学员透过一系列主题讲学、个案研究、小组活动及互动讨论的方式向其它馆员和资讯业专家学习.     

Blood flow restriction in human skeletal muscle during rest periods after high-load resistance training down-regulates miR-206 and induces Pax7

BackgroudBlood flow restriction (BFR) with low-intensity resistance training has been shown to result in hypertrophy of skeletal muscle. In this study, we tested the hypothesis that BFR during the rest periods between acute, high-intensity resistance exercise sessions (70% of 1 repetition maximum, 7 sets with 10 repetitions) enhances the effects of the resistance training.MethodsA total of 7 healthy young men performed squats, and between sets BFR was carried out on one leg while the other leg served as a control. Because BFR was applied during rest periods, even severe occlusion pressure (approximately 230 mmHg), which almost completely blocked blood flow, was well-tolerated by the participants. Five muscle-specific microRNAs were measured from the biopsy samples, which were taken 2 h after the acute training.ResultsDoppler data showed that the pattern of blood flow recovery changed significantly between the first and last BFR. microRNA-206 levels significantly decreased in the BFR leg compared to the control. The mRNA levels of RAC-β serine/threonine-protein kinase v22, nuclear respiratory factor 1, vascular endothelial growth factor, lupus Ku autoantigen protein p70 genes (p < 0.05), and paired box 7 (p < 0.01) increased in the BFR leg. The protein levels of paired box 7, nuclear respiratory factor 1, and peroxisome proliferator-activated receptor γ coactivator 1α did not differ between the BFR leg and the control leg.ConclusionBFR, during the rest periods of high-load resistance training, could lead to mRNA elevation of those proteins that regulate angiogenesis, mitochondrial biogenesis, and muscle hypertrophy and repair. However, BFR also can cause DNA damage, judging from the increase in mRNA levels of lupus Ku autoantigen protein p70.     

Esports players,got muscle? Competitive video game players’ physical activity,body fat,bone mineral content,and muscle mass in comparison to matched controls

BackgroundEsports players, like traditional athletes, practice for long hours and, thus, are vulnerable to the negative health effects of prolonged sitting. There is a lack of research on the physical activity and the health ramifications of prolonged sitting by competitive players. The purpose of this study was to investigate activity levels, body mass index (BMI), and body composition in collegiate esports players as compared to age-matched controls.MethodsTwenty-four male collegiate esports players and non-esports players between 18 and 25 years of age signed a written consent to participate. Physical activity was examined using daily activity (step count) with a wrist-worn activity tracker. A questionnaire assessing physical activity was also administered. Secondary outcomes included body-fat percentage, lean-body mass, BMI, and bone mineral content measured using dual X-ray absorptiometry.ResultsThe step count in the esports players was significantly lower than the age-matched controls (6040.2 ± 3028.6 vs. 12843.8 ± 5661.1; p = 0.004). Esports players exhibited greater body-fat percentage (p = 0.05), less lean body mass (p = 0.003), and less bone mineral content (p = 0.03), despite no difference in BMI between the esports and non-esports players.ConclusionAs compared to non-esports players, collegiate esports players were significantly less active and had a higher body-fat percentage, with lower lean body mass and bone mineral content. The BMIs showed no difference between the 2 groups. Esports athletes displayed significantly less activity and poor body composition, which are all correlated with potential health issues and risk of injury. BMI did not capture this difference and should not be considered as an accurate measure of health in competitive esports players.     

A Methodological Toolkit for Science

Science & Education -     

Changing Children's Overt Behaviour Related to Self‐esteem by the Use of Behaviour Modification

Abstract The experiment was designed to monitor the effects of behavioural techniques upon the frequency of positive self‐referent verbal statements (PSRVS) and on overt behaviours considered to be related to global self‐esteem. Fourteen maladjusted boys aged 10‐12 years were randomly assigned to an experimental and control group to monitor the effect of procedures to enhance the frequency of PSRVS. Both groups experienced extraction procedures and rewards but only the experimental group received modelling, instruction and contingent rewards. An ABCDA design demonstrated a very substantial and significant increase in PSRVS within the experimental group over the treatment period and provided some evidence for a generalisation effect on return to baseline and in the follow‐up period. A post‐experiment analysis of teacher ratings of the pupils on the Behaviour Rating Form (BRF) showed a significant difference in favour of the experimental group.     

Come home to college

Because of new applications of telecommunications, especially television, adults today have increasing flexibility in taking advantage of college courses in the privacy and convenience of their homes. The quality of courses has improved greatly in the last few years, and they are available in a variety of subject areas. Today's television courses are carefully designed and produced by teams of leading scholars and producers. Most of the country's public televison stations broadcast one or more television courses, each semester. In addition, many are broadcast on local cable channels. Most of the students for television courses are older than traditional college students, female and employed. They view the television courses at home. In the future, the personal computer can be expected to add new dimensions and flexibility to homebased college education.