GRDB: A general purpose relational database system

This article discusses the design and development of GRDB (General Purpose Relational Data Base System) which has been implemented on a DEC-1090 system in Pascal. GRDB is a general purpose database system designed to be completely independent of the nature of data to be handled, since it is not tailored to the specific requirements of any particular enterprise. It can handle different types of data such as variable length records and textual data. Apart from the usual database facilities such as data definition and data manipulation, GRDB supports User Definition Language (UDL) and Security definition language. These facilities are provided through a SEQUEL-like General Purpose Query Language (GQL). GRDB provides adequate protection facilities up to the relation level. The concept of “security matrix” has been made use of to provide database protection. The concept of Unique IDentification number (UID) and Password is made use of to ensure user identification and authentication. The concept of static integrity constraints has been used to ensure data integrity. Considerable efforts have been made to improve the response time through indexing on the data files and query optimisation. GRDB is designed for an interactive use but alternate provision has been made for its use through batch mode also. A typical Air Force application (consisting of data about personnel, inventory control, and maintenance planning) has been used to test GRDB and it has been found to perform satisfactorily.

“We have to work within the system!”: Staff perceptions of organizational barriers to decision making for older adults with dementia in Australian aged care facilities

The current study explored the perceptions of direct care staff working in Australian residential aged care facilities (RACFs) regarding the organizational barriers that they believe prevent them from facilitating decision making for individuals with dementia. Normalization process theory (NPT) was used to interpret the findings to understand these barriers in a broader context. The qualitative study involved semi-structured interviews (N = 41) and focus groups (N = 8) with 80 direct care staff members of all levels working in Australian RACFs. Data collection and analysis were conducted in parallel and followed a systematic, inductive approach in line with grounded theory. The perceptions of participants regarding the organizational barriers to facilitating decision making for individuals with dementia can be described by the core category, Working Within the System, and three sub-themes: (a) finding time, (b) competing rights, and (c)not knowing. Examining the views of direct care staff through the lens of NPT allows possible areas for improvement to be identified at an organizational level and the perceived barriers to be understood in the context of promoting normalization of decision making for individuals with dementia.

Limb-loss in pond-reared blue swimmer crabs Portunus pelagicus (L.): Effect on growth in an indoor shedding system

Limb-loss in crustaceans can reduce moult increment and delay or advance the timing of moulting, both aspects that are likely to impact upon soft-shell crab production. Pond-reared blue swimmer crabs Portunus pelagicus were harvested and maintained in a crab shedding system. The wet weight, carapace width (CW) and the occurrence of limb-loss were assessed before stocking in the shedding system and after each of the next three moults. Many of the crabs were initially missing one or two limbs and these did not grow as much as the crabs that were intact at the start of the trial. Despite its strong correlation with wet weight, CW changes proved to be misleading. Limb-loss reduced the %CW increment but not the per cent weight increment (where the later is calculated from the actual pre-moult weight). Pre-moult weight explained much of the variation in post-moult weight, with crabs moulting to approximately double their weight. Limb-loss reduced 'growth' and production from the pond because it reduced pre-moult weight but limb-loss did not alter the weight change on shedding a given weight of crabs, although some of that change now included regeneration of limbs. One can hypothesize that much of the size variation seen in pond-reared crabs may be due to accumulated effects of repeated limb-loss, rather than genetic variation.