An algebraic theory of functional and multivalued dependencies in relational databases

Computation of the dependency basis is the fundamental step in solving the membership problem for functional dependencies (FDs) and multivalued dependencies (MVDs) in relational database theory. We examine this problem from an algebraic perspective. We introduce the notion of the inference basis of a set M of MVDs and show that it contains the maximum information about the logical consequences of M. We propose the notion of a dependency-lattice and develop an algebraic characterization of inference basis using simple notions from lattice theory. We also establish several interesting properties of dependency-lattices related to the implication problem. Founded on our characterization, we synthesize efficient algorithms for (a): computing the inference basis of a given set M of MVDs; (b): computing the dependency basis of a given attribute set w.r.t. M; and (c): solving the membership problem for MVDs. We also show that our results naturally extend to incorporate FDs also in a way that enables the solution of the membership problem for both FDs and MVDs put together. We finally show that our algorithms are more efficient than existing ones, when used to solve what we term the ‘generalized membership problem’.

The Implication Problem for Functional and Multivalued Dependencies

Computation of the dependency basis is the fundamental step in solving the implication problem for MVDs in relational database theory. We examine this problem from an algebraic perspective. We introduce the notion of the inference basis of a set M of MVDs and show that it contains the maximum information about the logical consequences of M. We propose the notion of an MVD-lattice and develop an algebraic characterization of the inference basis using simple notions from lattice theory. We also establish several properties of MVD-lattices related to the implication problem. Founded on our characterization, we synthesize efficient algorithms for (a) computing the inference basis of a given set M of MVDs; (b) computing the dependency basis of a given attribute set w.r.t. M; and (c) solving the implication problem for MVDs. Finally, we show that our results naturally extend to incorporate FDs also in a way that enables the solution of the implication problem for both FDs and MVDs put together.

Exploring methods of preparing functional cartilage-bone xenografts for joint repair

This thesis explores the feasibility of donor-receiver concept for joint replacement where cartilage-bone tissues can be taken from either human or other mammals and prepared scientifically for repairing focal joint defects in knees, hips and shoulders. The manufactured construct is immunologically inert and is capable of acting as a scaffold for engineering new cartilage-bone laminates when placed in the joint. Innovative manufacturing procedures and assessment techniques were developed for appraising this tissue-based scaffold. This research has demonstrated that tissue replacement technology can be applied in situations where blood vessels are absent such as in articular cartilage.

Representation of functional dependencies in relational databases using linear graphs

Functional dependencies in relational databases are investigated. Eight binary relations, viz., (1) dependency relation, (2) equipotence relation, (3) dissidence relation, (4) completion relation, and dual relations of each of them are described. Any one of these eight relations can be used to represent the functional dependencies in a database. Results from linear graph theory are found helpful in obtaining these representations. The dependency relation directly gives the functional dependencies. The equipotence relation specifies the dependencies in terms of attribute sets which functionally determine each other. The dissidence relation specifies the dependencies in terms of saturated sets in a very indirect way. Completion relation represents the functional dependencies as a function, the range of which turns out to be a lattice. Depletion relation which is the dual of the completion relation can also represent functional dependencies and similarly can the duals of dependency, equipotence, and dissidence relations. The class of depleted sets, which is the dual of saturated sets, is defined and used in the study of depletion relations.

The process for implementation of a Quality Management System within a multi-functional cereal laboratory

The intent of this study was to design, document and implement a Quality Management System (QMS) into a laboratory that incorporated both research and development (R&D) and routine analytical activities. In addition, it was necessary for the QMS to be easily and efficiently maintained to: (a) provide documented evidence that would validate the system's compliance with a certifiable standard, (b) fit the purpose of the laboratory, (c) accommodate prevailing government policies and standards, and (d) promote positive outcomes for the laboratory through documentation and verification of the procedures and methodologies implemented. Initially, a matrix was developed that documented the standards' requirements and the necessary steps to be made to meet those requirements. The matrix provided a check mechanism on the progression of the system's development. In addition, it was later utilised in the Quality Manual as a reference tool for the location of full procedures documented elsewhere in the system. The necessary documentation to build and monitor the system consisted of a series of manuals along with forms that provided auditable evidence of the workings of the QMS. Quality Management (QM), in one form or another, has been in existence since the early 1900's. However, the question still remains: is it a good thing or just a bugbear? Many of the older style systems failed because they were designed by non-users, fiercely regulatory, restrictive and generally deemed to be an imposition. It is now considered important to foster a sense of ownership of the system by the people who use the system. The system's design must be tailored to best fit the purpose of the operations of the facility if maximum benefits to the organisation are to be gained.

Reversible Water Intercalation Accompanied by Coordination and Color Changes in a Layered Metal-Organic Framework

A new two-dimensional 3d-4f mixed-metal mixed dicarboxylate (homocyclic and heterocyclic) of the formula [Gd2(H2O)2Ni(H2O)2(1,2-bdc)2(2,5-pydc)2] 3 8H2O (1; 1,2-H2bdc = 1,2-benzenedicarboxylic acid and 2,5-H2pydc = 2,5- pyridinedicarboxylic acid) has been prepared by employing the hydrothermal method. The structure has infinite onedimensional-Gd-O-Gd- chains formed by the edge-shared GdO9 polyhedral units, resulting exclusively from the connectivity between the Gd3+ ions and the 1,2-bdc units. The chains are connected by the [Ni(H2O)2(2,5-pydc)2]2- metalloligand, forming the two-dimensional layer arrangements. The stacking of the layers creates hydrophilic and hydrophobic spaces in the interlamellar region. A one-dimensional water ladder structure, formed by the extraframework water molecules, occupies the hydrophilic region while the benzene ring of 1,2-bdc occupies the hydrophobic region. To the best of our knowledge, the present compound represents the first example of a 3d-4f mixed-metal carboxylate in which two different aromatic dicarboxylate anions act as the linkers. The stabilization energies of the water clusters have been evaluated using density functional theory calculations. The water molecules in 1 are fully reversible accompanied by a change in color (greenish blue to brown) and coordination around Ni2+ ions (octahedral to distorted tetrahedral).

Representation of functional dependencies in relational databases using linear graphs

Functional dependencies in relational databases are investigated. Eight binary relations, viz., (1) dependency relation, (2) equipotence relation, (3) dissidence relation, (4) completion relation, and dual relations of each of them are described. Any one of these eight relations can be used to represent the functional dependencies in a database. Results from linear graph theory are found helpful in obtaining these representations. The dependency relation directly gives the functional dependencies. The equipotence relation specifies the dependencies in terms of attribute sets which functionally determine each other. The dissidence relation specifies the dependencies in terms of saturated sets in a very indirect way. Completion relation represents the functional dependencies as a function, the range of which turns out to be a lattice. Depletion relation which is the dual of the completion relation can also represent functional dependencies and similarly can the duals of dependency, equipotence, and dissidence relations. The class of depleted sets, which is the dual of saturated sets, is defined and used in the study of depletion relations.

Functional dynamics of the nitrogen balance of sorghum. II. Grain filling period.

Maintenance of green leaf area during grain filling can increase grain yield of sorghum grown under terminal water limitation. This 'stay-green' trait has been related to the nitrogen (N) supply-demand balance during grain filling. This study quantifies the N demand of grain and N translocation rates from leaves and stem and explores effects of genotype and N stress on onset and rate of leaf senescence during the grain filling period. Three hybrids differing in potential height were grown at three levels of N supply under well-watered conditions. Vertical profiles of biomass, leaf area, and N% of leaves, stem and grain were measured at regular intervals. Weekly SPAD chlorophyll readings on main shoot leaves were correlated with observed specific leaf nitrogen (SLN) to derive seasonal patterns of leaf N content. For all hybrids, individual grain N demand was sink determined and was initially met through N translocation from the stem and rachis. Only if this was insufficient did leaf N translocation occur. Maximum N translocation rates from leaves and stem were dependent on their N status. However, the supply of N at canopy scale was also related to the amount of leaf area senescing at any one time. This supply-demand framework for N dynamics explained effects of N stress and genotype on the onset and rate of leaf senescence.

Functional dynamics of the nitrogen balance of sorghum: I. N demand of vegetative plant parts.

Stay-green, an important trait for grain yield of sorghum grown under water limitation, has been associated with a high leaf nitrogen content at the start of grain filling. This study quantifies the N demand of leaves and stems and explores effects of N stress on the N balance of vegetative plant parts of three sorghum hybrids differing in potential crop height. The hybrids were grown under well-watered conditions at three levels of N supply. Vertical profiles of biomass and N% of leaves and stems, together with leaf size and number, and specific leaf nitrogen (SLN), were measured at regular intervals. The hybrids had similar minimum but different critical and maximum SLN, associated with differences in leaf size and N partitioning, the latter associated with differences in plant height. N demand of expanding new leaves was represented by critical SLN, and structural stem N demand by minimum stem N%. The fraction of N partitioned to leaf blades increased under N stress. A framework for N dynamics of leaves and stems is developed that captures effects of N stress and genotype on N partitioning and on critical and maximum SLN.

Isolation and functional characterization of a lycopene beta-cyclase gene that controls fruit colour of papaya (Carica papaya L.).

The colour of papaya fruit flesh is determined largely by the presence of carotenoid pigments. Red-fleshed papaya fruit contain lycopene, whilst this pigment is absent from yellow-fleshed fruit. The conversion of lycopene (red) to beta-carotene (yellow) is catalysed by lycopene beta-cyclase. This present study describes the cloning and functional characterization of two different genes encoding lycopene beta-cyclases (lcy-beta1 and lcy-beta2) from red (Tainung) and yellow (Hybrid 1 B) papaya cultivars. A mutation in the lcy-beta2 gene, which inactivates enzyme activity, controls lycopene production in fruit and is responsible for the difference in carotenoid production between red and yellow-fleshed papaya fruit. The expression level of both lcy-beta1 and lcy-beta2 genes is similar and low in leaves, but lcy-beta2 expression increases markedly in ripe fruit. Isolation of the lcy-beta2 gene from papaya, that is preferentially expressed in fruit and is correlated with fruit colour, will facilitate marker-assisted breeding for fruit colour in papaya and should create possibilities for metabolic engineering of carotenoid production in papaya fruit to alter both colour and nutritional properties.

Direct measurement of inner prosthesis loading during activities of daily living: Proposal for classification of functional outcome

Background The purpose of this presentation is to outline the relevance of the categorization of the load regime data to assess the functional output and usage of the prosthesis of lower limb amputees. The objectives are • To highlight the need for categorisation of activities of daily living • To present a categorization of load regime applied on residuum, • To present some descriptors of the four types of activity that could be detected, • To provide an example the results for a case. Methods The load applied on the osseointegrated fixation of one transfemoral amputee was recorded using a portable kinetic system for 5 hours. The load applied on the residuum was divided in four types of activities corresponding to inactivity, stationary loading, localized locomotion and directional locomotion as detailed in previously publications. Results The periods of directional locomotion, localized locomotion, and stationary loading occurred 44%, 34%, and 22% of recording time and each accounted for 51%, 38%, and 12% of the duration of the periods of activity, respectively. The absolute maximum force during directional locomotion, localized locomotion, and stationary loading was 19%, 15%, and 8% of the body weight on the anteroposterior axis, 20%, 19%, and 12% on the mediolateral axis, and 121%, 106%, and 99% on the long axis. A total of 2,783 gait cycles were recorded. Discussion Approximately 10% more gait cycles and 50% more of the total impulse than conventional analyses were identified. The proposed categorization and apparatus have the potential to complement conventional instruments, particularly for difficult cases.

Expression of functional GABAc receptors in the brain

γ-aminobutyric acid (GABA) is the main inhibitory transmitter in the nervous system and acts via three distinct receptor classes: A, B, and C. GABAC receptors are ionotropic receptors comprising ρ subunits. In this work, we aimed to elucidate the expression of ρ subunits in the postnatal brain, the characteristics of ρ2 homo-oligomeric receptors, and the function of GABAC receptors in the hippocampus. In situ hybridization on rat brain slices showed ρ2 mRNA expression from the newborn in the superficial grey layer of the superior colliculus, from the first postnatal week in the hippocampal CA1 region and the pretectal nucleus of the optic tract, and in the adult dorsal lateral geniculate nucleus. Quantitative RT-PCR revealed expression of all three ρ subunits in the hippocampus and superior colliculus from the first postnatal day. In the hippocampus, ρ2 mRNA expression clearly dominated over ρ1 and ρ3. GABAC receptor protein expression was confirmed in the adult hippocampus, superior colliculus, and dorsal lateral geniculate nucleus by immunohistochemistry. From the selective distribution of ρ subunits, GABAC receptors may be hypothesized to be specifically involved in aspects of visual image motion processing in the rat brain. Although previous data had indicated a much higher expression level for ρ2 subunit transcripts than for ρ1 or ρ3 in the brain, previous work done on Xenopus oocytes had suggested that rat ρ2 subunits do not form functional homo-oligomeric GABAC receptors but need ρ1 or ρ3 subunits to form hetero-oligomers. Our results demonstrated, for the first time, that HEK 293 cells transfected with ρ2 cDNA displayed currents in whole-cell patch-clamp recordings. Homomeric rat ρ2 receptors had a decreased sensitivity to, but a high affinity for picrotoxin and a marked sensitivity to the GABAC receptor agonist CACA. Our results suggest that ρ2 subunits may contribute to brain function, also in areas not expressing other ρ subunits. Using extracellular electrophysiological recordings, we aimed to study the effects of the GABAC receptor agonists and antagonists on responses of the hippocampal neurons to electrical stimulation. Activation of GABAC receptors with CACA suppressed postsynaptic excitability and the GABAC receptor antagonist TPMPA inhibited the effects of CACA. Next, we aimed to display the activation of the GABAC receptors by synaptically released GABA using intracellular recordings. GABA-mediated long-lasting depolarizing responses evoked by high-frequency stimulation were prolonged by TPMPA. For weaker stimulation, the effect of TPMPA was enhanced after GABA uptake was inhibited. Our data demonstrate that GABAC receptors can be activated by endogenous synaptic transmitter release following strong stimulation or under conditions of reduced GABA uptake. The lack of GABAC receptor activation by less intensive stimulation under control conditions suggests that these receptors are extrasynaptic and activated via spillover of synaptically released GABA. Taken together with the restricted expression pattern of GABAC receptors in the brain and their distinctive pharmacological and biophysical properties, our findings supporting extrasynaptic localization of these receptors raise interesting possibilities for novel pharmacological therapies in the treatment of, for example, epilepsy and sleep disorders.

Developmental, functional brain imaging and electrophysiological evidence of visual and auditory working memory

Intact function of working memory (WM) is essential for children and adults to cope with every day life. Children with deficits in WM mechanisms have learning difficulties that are often accompanied by behavioral problems. The neural processes subserving WM, and brain structures underlying this system, continue to develop during childhood till adolescence and young adulthood. With functional magnetic resonance imaging (fMRI) it is possible to investigate the organization and development of WM. The present thesis aimed to investigate, using behavioral and neuroimaging methods, whether mnemonic processing of spatial and nonspatial visual information is segregated in the developing and mature human brain. A further aim in this research was to investigate the organization and development of audiospatial and visuospatial information processing in WM. The behavioral results showed that spatial and nonspatial visual WM processing is segregated in the adult brain. The fMRI result in children suggested that memory load related processing of spatial and nonspatial visual information engages common cortical networks, whereas selective attention to either type of stimuli recruits partially segregated areas in the frontal, parietal and occipital cortices. Deactivation mechanisms that are important in the performance of WM tasks in adults are already operational in healthy school-aged children. Electrophysiological evidence suggested segregated mnemonic processing of visual and auditory location information. The results of the development of audiospatial and visuospatial WM demonstrate that WM performance improves with age, suggesting functional maturation of underlying cognitive processes and brain areas. The development of the performance of spatial WM tasks follows a different time course in boys and girls indicating a larger degree of immaturity in the male than female WM systems. Furthermore, the differences in mastering auditory and visual WM tasks may indicate that visual WM reaches functional maturity earlier than the corresponding auditory system. Spatial WM deficits may underlie some learning difficulties and behavioral problems related to impulsivity, difficulties in concentration, and hyperactivity. Alternatively, anxiety or depressive symptoms may affect WM function and the ability to concentrate, being thus the primary cause of poor academic achievement in children.