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.

Leveraging Lean Production Philosophy for Rationalising a Non-Linear Representation of Construction Specifications

This paper presents an approach, based on Lean production philosophy, for rationalising the processes involved in the production of specification documents for construction projects. Current construction literature erroneously depicts the process for the creation of construction specifications as a linear one. This traditional understanding of the specification process often culminates in process-wastes. On the contrary, the evidence suggests that though generalised, the activities involved in producing specification documents are nonlinear. Drawing on the outcome of participant observation, this paper presents an optimised approach for representing construction specifications. Consequently, the actors typically involved in producing specification documents are identified, the processes suitable for automation are highlighted and the central role of tacit knowledge is integrated into a conceptual template of construction specifications. By applying the transformation, flow, value (TFV) theory of Lean production the paper argues that value creation can be realised by eliminating the wastes associated with the traditional preparation of specification documents with a view to integrating specifications in digital models such as Building Information Models (BIM). Therefore, the paper presents an approach for rationalising the TFV theory as a method for optimising current approaches for generating construction specifications based on a revised specification writing model.

Towards the development of a Cavendish banana resistant to race 4 of fusarium wilt: gamma irradiation of micropropagated Dwarf Parfitt (Musa spp., AAA group, Cavendish subgroup)

'Dwarf parfitt', an extra-dwarf Cavendish cultivar with resistance to subtropical race 4 fusarium oxysporum f. sp. cubense 9Foc), was gamma irradiated at a dose of 20 Gy and putative mutants were recovered with improved agronomic characteristics. Further screening of putative mutants for improved yield and fruit size, as well as a degree of resistence to fusarium wilt, led to the selection of a line (DPM25) with improved productivity when grown on soils infested with subtropical race 4 Foc. DPM25 was equal to the industry standard, 'Williams', in every agronomic trait measured and it consistently showed a lower incidence of fusarium wilt. Further improvement of field resistance to race 4 Foc is needed in DPM25 and further cycles of mutation induction and selction is an option discussed.

Linear time geometrical design rule checker based on quadtree representation of VLSI mask layouts

An efficient geometrical design rule checker is proposed, based on operations on quadtrees, which represent VLSI mask layouts. The time complexity of the design rule checker is O(N), where N is the number of polygons in the mask. A pseudoPascal description is provided of all the important algorithms for geometrical design rule verification.

Gauge theory of a group of diffeomorphisms. I. General principles

Any (N+M)-parameter Lie group G with an N-parameter subgroup H can be realized as a global group of diffeomorphisms on an M-dimensional base space B, with representations in terms of transformation laws of fields on B belonging to linear representations of H. The gauged generalization of the global diffeomorphisms consists of general diffeomorphisms (or coordinate transformations) on a base space together with a local action of H on the fields. The particular applications of the scheme to space-time symmetries is discussed in terms of Lagrangians, field equations, currents, and source identities. Journal of Mathematical Physics is copyrighted by The American Institute of Physics.

Grower group case study on new farming practices in the Herbert region, Australia

Growers working together have proven to be a successful method for improving the utilization of farm resources and accelerating the adoption of the Sugar Yield Decline Joint Venture principles (SYDJV). The Pinnacle Precision Farming Group was formed in 2004 with the aim to bring together the ideas, knowledge and resources of growers in the Herbert region. Along with their common interest in controlled traffic, minimal tillage and crop rotations, the grower group utilize a farm machinery contractor to provide some of their major farming operations. This paper provides an insight into the changes made by the Pinnacle Precision Farming Group and their journey to adopt the new farming system practices. This paper also details the changes made by the group machinery contractor and a comparison of the old and new farming systems used by a group member. A focus point of the document is the impact of the new farming system on the economic, social and environmental components of the farming business. Analysis of the new farming system with a legume crop rotation revealed an increase in the farm gross margin by AU$22 024 and, in addition, a reduction in tractor operation time by 38% across the whole farm. This represents a return on marginal capital of 14.68 times the original capital outlay required by the group member. Using the new farming system without a legume crop will still improve the group members whole of farm gross margin by AU$6 839 and reduce tractor operation time by 43% across the whole farm. The Pinnacle Precision Farming group recognize the need to continually improve their farming businesses and believe that the new farming system principles are critical for the long term viability of the industry. [U$1 = AU$1.19].

Topochemical photodimerization of 7-acetoxycoumarin: the acetoxy group as a steering agent

Among the various substituted coumarins investigated only 7-acetoxycoumarin is observed to photodimerize topochemically in the crystalline state and this observation may be of importance in the context of "crystal engineering".

Truckies and workplace health promotion: Targeting a hard-to-reach group

- Introduction Research identifies truck drivers as being at high risk of chronic disease. For most truck drivers their workplace is their vehicle. Truck drivers’ health is impacted by the limitations of this unique working environment, including reduced opportunities for physical activity and the intake of healthy foods. Workplaces are widely recognised as effective platforms for health promotion. However, the effectiveness of traditional and contemporary health promotion interventions in truck drivers’ novel workplace is unknown. - Methods This project worked with six transport industry workplaces in Queensland, Australia over a two-year period. Researchers used Participatory Action Research (PAR) processes to engage truck drivers and workplace managers in the implementation and evaluation of six workplace health promotion interventions. These interventions were designed to support truck drivers to increase their physical activity and access to healthy foods at work. They included traditional health promotion interventions such as a free fruit initiative, a ten thousand steps challenge, personal health messages and workplace posters, and a contemporary social media intervention. Participants were engaged via focus groups, interviews and mixed-methods surveys. - Results The project achieved positive changes in truck drivers’ health knowledge and health behaviours, particularly related to nutrition. There were positive changes in truck drivers’ self-reported health rating, body mass index (BMI) and readiness to make health-related lifestyle changes. There were also positive changes in truck drivers reporting their workplace as a key source of health information. These changes were underpinned by a positive shift in the culture of participating workplaces. Truck drivers’ perceptions of their workplace valuing, encouraging, modelling and facilitating healthy nutrition and physical activity behaviours improved. PAR processes enabled researchers to develop relationships with workplace managers, contextualise interventions and deliver rigorous outcomes. Despite the novelty of truck drivers’ mobile workplace, traditional health promotion interventions were more effective than contemporary ones. - Conclusion In this workplace health promotion project targeting a ‘hard-to-reach’ group of truck drivers, a combination of well-designed traditional workplace interventions and the PAR process resulted in positive health outcomes.

Optimized group replacement scheduling for water pipeline network

Replacement of deteriorated water pipes is a capital-intensive activity for utility companies. Replacement planning aims to minimize total costs while maintaining a satisfactory level of service and is usually conducted for individual pipes. Scheduling replacement in groups is seen to be a better method and has the potential to provide benefits such as the reduction of maintenance costs and service interruptions. However, developing group replacement schedules is a complex task and often beyond the ability of a human expert, especially when multiple or conflicting objectives need to be catered for, such as minimization of total costs and service interruptions. This paper describes the development of a novel replacement decision optimization model for group scheduling (RDOM-GS), which enables multiple group-scheduling criteria by integrating new cost functions, a service interruption model, and optimization algorithms into a unified procedure. An industry case study demonstrates that RDOM-GS can improve replacement planning significantly and reduce costs and service interruptions.

Reflexive Incidence Matrx (RIM) Representation of Petr Nets

Although incidence matrix representation has been used to analyze the Petri net based models of a system, it has the limitation that it does not preserve reflexive properties (i.e., the presence of selfloops) of Petri nets. But in many practical applications self-loops play very important roles. This paper proposes a new representation scheme for general Petri nets. This scheme defines a matrix called "reflexive incidence matrix (RIM) c which is a combination of two matrices, a "base matrix Cb,,, and a "power matrix CP." This scheme preserves the reflexive and other properties of the Petri nets. Through a detailed analysis it is shown that the proposed scheme requires less memory space and less processing time for answering commonly encountered net queries compared to other schemes. Algorithms to generate the RIM from the given net description and to decompose RIM into input and output function matrices are also given. The proposed Petri net representation scheme is very useful to model and analyze the systems having shared resources, chemical processes, network protocols, etc., and to evaluate the performance of asynchronous concurrent systems.

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.

Linalyl Acetate Is Metabolized by Pseudomonas incognita with the Acetoxy Group Intact

Metabolism of linalyl acetate by Pseudomonas incognita isolated by enrichment culture on the acyclic monoterpene alcohol linalool was studied. Biodegradation of linalyl acetate by this strain resulted in the formation of linalool, linalool- 8-carboxylic acid, oleuropeic acid, and A5-4-acetoxy-4-methyl hexenoic acid. Cells adapted to linalyl acetate metabolized linalyl acetate-8-aldehyde to linalool- 8-carboxylic acid, linalyl acetate-8-carboxylic acid, A5-4-acetoxy-4-methyl hexenoic acid, and geraniol-8-carboxylic acid. Resting cell suspensions previously grown with linalyl acetate oxidized linalyl acetate-8-aldehyde to linalyl acetate-8- carboxylic acid, A5-4-acetoxy-4-methyl hexenoic acid, and pyruvic acid. The crude cell-free extract (10,000 g of supernatant), obtained from the sonicate of linalyl acetate-grown cells, was shown to contain enzyme systems responsible for the formation of linalyl acetate-8-carboxylic acid and linalool-8-carboxylic acid from linalyl acetate. The same supernatant contained NAD-linked alcohol and aldehyde dehydrogenases involved in the formation of linalyl acetate-8-aldehyde and linalyl acetate-8-carboxylic acid, respectively. On the basis of various metabolites isolated from the culture medium, resting cell experiments, growth and manometric studies carried out with the isolated metabolites as well as related synthetic analogs, and the preliminary enzymatic studies performed with the cellfree extract, a probable pathway for the microbial degradation of linalyl acetate with the acetoxy group intact is suggested.

Concepts and Object-Oriented Knowledge Representation

Tutkielma käsittelee nykyisiä kognitiotieteen teorioita käsitteistä ja niiden mallintamista oliokeskeisillä tietämyksen esittämisen menetelmillä. Käsiteteorioista käsitellään klassinen, määritelmäteoria, prototyyppiteoria, duaaliteoriat, uusklassinen teoria, teoria-teoria ja atomistinen teoria. Oliokeskeiset menetelmät ovat viime aikoina jakautuneet kahden tyyppisiin kieliin: oliopohjaisiin ja luokkapohjaisiin. Uudet olio-pohjaiset olio-ohjelmointikielet antavat käsitteiden representointiin mahdollisuuksia, jotka puuttuvat aikaisemmista luokka-pohjaisista kielistä ja myös kehysmenetelmistä. Tutkielma osoittaa, että oliopohjaisten kielten uudet piirteet tarjoavat keinoja, joilla käsitteitä voidaan esittää symbolisessa muodossa paremmin kuin perinteisillä menetelmillä. Niillä pystytään simuloimaan kaikkea mitä luokkapohjaisilla kielillä voidaan, mutta ne pystyvät lisäksi simuloimaan perheyhtäläisyyskäsitteitä ja mahdollistavat olioiden dynaamisen muuttamisen ilman, että siinä rikotaan psykologisen essentialismin periaatetta. Tutkielma osoittaa lisäksi vakavia puutteitta, jotka koskevat koko oliokeskeistä menetelmää. Avainsanat: käsitteet, käsiteteoriat, tekoäly, komputationaalinen psykologia, olio-ohjelmointi, tiedon esittäminen