On the Production of Anorexic Plan Diagrams

A "plan diagram" is a pictorial enumeration of the execution plan choices of a database query optimizer over the relational selectivity space. We have shown recently that, for industrial-strength database engines, these diagrams are often remarkably complex and dense, with a large number of plans covering the space. However, they can often be reduced to much simpler pictures, featuring significantly fewer plans, without materially affecting the query processing quality. Plan reduction has useful implications for the design and usage of query optimizers, including quantifying redundancy in the plan search space, enhancing useability of parametric query optimization, identifying error-resistant and least-expected-cost plans, and minimizing the overheads of multi-plan approaches. We investigate here the plan reduction issue from theoretical, statistical and empirical perspectives. Our analysis shows that optimal plan reduction, w.r.t. minimizing the number of plans, is an NP-hard problem in general, and remains so even for a storage-constrained variant. We then present a greedy reduction algorithm with tight and optimal performance guarantees, whose complexity scales linearly with the number of plans in the diagram for a given resolution. Next, we devise fast estimators for locating the best tradeoff between the reduction in plan cardinality and the impact on query processing quality. Finally, extensive experimentation with a suite of multi-dimensional TPCH-based query templates on industrial-strength optimizers demonstrates that complex plan diagrams easily reduce to "anorexic" (small absolute number of plans) levels incurring only marginal increases in the estimated query processing costs.

Changing resonator geometry to boost sound power decouples size and song frequency in a small insect

Despite their small size, some insects, such as crickets, can produce high amplitude mating songs by rubbing their wings together. By exploiting structural resonance for sound radiation, crickets broadcast species-specific songs at a sharply tuned frequency. Such songs enhance the range of signal transmission, contain information about the signaler's quality, and allow mate choice. The production of pure tones requires elaborate structural mechanisms that control and sustain resonance at the species-specific frequency. Tree crickets differ sharply from this scheme. Although they use a resonant system to produce sound, tree crickets can produce high amplitude songs at different frequencies, varying by as much as an octave. Based on an investigation of the driving mechanism and the resonant system, using laser Doppler vibrometry and finite element modeling, we show that it is the distinctive geometry of the crickets' forewings (the resonant system) that is responsible for their capacity to vary frequency. The long, enlarged wings enable the production of high amplitude songs; however, as a mechanical consequence of the high aspect ratio, the resonant structures have multiple resonant modes that are similar in frequency. The drive produced by the singing apparatus cannot, therefore, be locked to a single frequency, and different resonant modes can easily be engaged, allowing individual males to vary the carrier frequency of their songs. Such flexibility in sound production, decoupling body size and song frequency, has important implications for conventional views of mate choice, and offers inspiration for the design of miniature, multifrequency, resonant acoustic radiators.

Dynamics of Cricket Sound Production

The clever designs of natural transducers are a great source of inspiration for man-made systems. At small length scales, there are many transducers in nature that we are now beginning to understand and learn from. Here, we present an example of such a transducer that is used by field crickets to produce their characteristic song. This transducer uses two distinct components-a file of discrete teeth and a plectrum that engages intermittently to produce a series of impulses forming the loading, and an approximately triangular membrane, called the harp, that acts as a resonator and vibrates in response to the impulse-train loading. The file-and-plectrum act as a frequency multiplier taking the low wing beat frequency as the input and converting it into an impulse-train of sufficiently high frequency close to the resonant frequency of the harp. The forced vibration response results in beats producing the characteristic sound of the cricket song. With careful measurements of the harp geometry and experimental measurements of its mechanical properties (Young's modulus determined from nanoindentation tests), we construct a finite element (FE) model of the harp and carry out modal analysis to determine its natural frequency. We fine tune the model with appropriate elastic boundary conditions to match the natural frequency of the harp of a particular species-Gryllus bimaculatus. We model impulsive loading based on a loading scheme reported in literature and predict the transient response of the harp. We show that the harp indeed produces beats and its frequency content matches closely that of the recorded song. Subsequently, we use our FE model to show that the natural design is quite robust to perturbations in the file. The characteristic song frequency produced is unaffected by variations in the spacing of file-teeth and even by larger gaps. Based on the understanding of how this natural transducer works, one can design and fabricate efficient microscale acoustic devices such as microelectromechanical systems (MEMS) loudspeakers.

Design of a manual press for the production of compacted stabilized soil blocks

In this paper, we discuss the design of a manually operated soil compaction machine that is being used to manufacture stabilized soil blocks (SSB). A case study of manufacturing more than three million blocks in a housing project using manually operated machines is illustrated. The paper is focussed on the design, development, and evaluation of a manually operated soil compaction machine for the production of SSB. It also details the machine design philosophy, compaction characteristics of soils, employment generation potential of small-scale stabilized soil block productions systems, and embodied energy. Static compaction of partially saturated soils was performed to generate force-displacement curves in a confined compaction process were generated. Based on the soil compaction data engineering design aspects of a toggle press are illustrated. The results of time and motion study on block production operations using manual machines are discussed. Critical path network diagrams were used for small-scale SSB production systems. Such production systems generate employment at a very low capital cost.

Effect of Cattail (Typha domingensis) Extracts, Leachates, and Selected Phenolic Compounds on Rates of Oxygen Production by Salvinia (Salvinia minima)

Salvinia (Salvinia minima Willd.) is a water fern found in Florida waters, usually associated with Lemna and other small free-floating species. Due to its buoyancy and mat-forming abilities, it is spread by moving waters. In 1994, salvinia was reported to be present in 247 water bodies in the state (out of 451 surveyed public waters, Schardt 1997). It is a small, rapidly growing species that can become a nuisance due to its explosive growth rates and its ability to shade underwater life (Oliver 1993). Any efforts toward management of salvinia populations must consider that, in reasonable amounts, its presence is desirable since it plays an important role in the overall ecosystem balance. New management alternatives need to be explored besides the conventional herbicide treatments; for example, it has been shown that the growth of S. molesta can be inhibited by extracts of the tropical weed parthenium (Parthenium hysterophorus) and its purified toxin parthenin (Pande 1994, 1996). We believe that cattail, Typha spp. may be a candidate for control of S. minima infestations. Cattail is an aggressive aquatic plant, and has the ability to expand over areas that weren't previously occupied by other species (Gallardo et al. 1998a and references cited there). In South Florida, T. domingensis is a natural component of the Everglades ecosystem, but in many cases it has become the dominant marsh species, outcompeting other native plants. In Florida public waters, this cattail species is the most dominant emergent species of aquatic plants (Schardt 1997). Several factors enable it to accomplish opportunistic expansion, including size, growth habits, adaptability to changes in the surroundings, and the release of compounds that can prevent the growth and development of other species. We have been concerned in the past with the inhibitory effects of the T. domingensis extracts, and the phenolic compounds mentioned before, towards the growth and propagation of S. minima (Gallardo et al. 1998b). This investigation deals with the impact of cattail materials on the rates of oxygen production of salvinia, as determined through a series of Warburg experiments (Martin et al. 1987, Prindle and Martin 1996).

Enhancing fishery productivity in small reservoir in India: technical manual

This document is part of a series of 5 technical manuals produced by the Challenge Program Project CP34 “Improved fisheries productivity and management in tropical reservoirs”. Inland capture fisheries in India have declined in recent years, leaving thousands of fishers to sink deeper into poverty. Freshwater aquaculture in small water bodies like ponds now contributes 80% of the country¡¯s inland fish production. This manual outlines the use of small reservoir for freshwater aquacultureas a means of providing rural areas with food and livelihoods and protecting aquatic ecosystems, in particular by facilitating the conservation of indigenous fish species. (PDF contains 22 pages)

Control of bacterial disease in small scale fresh-water aquaculture: Project R0754. Project completion report December 1998 - May 1999

The work presented here represents an 18-month study to examine the relationship between environmental conditions, bacterial load in the water and bacteria levels in tissue macrophages of a range of clinically healthy freshwater fish species, farmed in a range of culture systems in Thailand and Vietnam. Preliminary assessment was made of the clinical significance of the macrophage bacterial load. The aim of this work was to improve production in fresh-water aquaculture through the control of clinical bacterial disease and subclinical infection, and to identify management practices most effective in promoting fish health. [PDF contains 37 pages]

The use of locally available materials in fish feed production

In Nigeria, the culture of fish is gaining importance, but local fish farmers face a set back because of the stoppage on importation of fish feed. Locally available raw materials such as yam, plantain, banana, cowpeas, macuna, maize, cassava, millet, sorghum, groundnut, sunnhemp seed and brewery wastes are considered as potential materials for fish feed. These have been examined on their minimum protein contributions since this is the most expensive part of the fish feed. Alternative sources to animal proteins are also examined. Plant protein from groundnut, melon, mucuna and others compare favourably with bloodmeal mixture and thus can be used to replace the more expensive animal proteins. Pellet feed can be produced on a small scale or commercial basis from the locally available raw materials and the fish farmer is advised to seek assistance from qualified fisheries personnel

Small-scale fisheries development in Nigeria: Status, prospects, constraints/recommended solutions

The small-scale fisheries sector has been contributing immensely towards domestic fish production in Nigeria. Despite considerable contributions by the small-scale fisherman of Nigeria, with few exceptions, they continue to live at the margin of subsistence. This paper attempts to review the sector and propose strategies of integrated approach towards small-scale fisheries development in order to ensure that efforts at improving the rural fisheries succeed in over-coming identified constraints which include socio-cultural, political, economic, technological and other barriers

Sustainable management of water bodies for small-scale fisheries resorces research and development

Abstract The rapid growth of both formal and informal high density urban settlements around major water resources has led to increased pollution of streams, rivers, lakes and estuaries, due to contaminated runoff from these developments. The paper identified major contaminants to be : organic waste (sewage), industrial effluent, pesticides and litter. Pollutant loads vary depending on the hydrology of the urban area, local topography and soil conditions. In some instances, severe pollution of neighbouring and downstream water courses has been observed. The management of catchment land uses, riparian zones, in stream habitat, as well as in stream water flow patterns and quality are necessary in order to sustain the integrity and "health" of water resources, for fisheries and other developments. As such, attempts to ensure a certain level of water quality without attention to other aspects will not automatically ensure a "healthy" ecosystem even as fish habitat. Proper management leads to better water quality and conducive environment for increased fish production

Design, operation and economics of a small-scale hatchery for the larval rearing of sugpo, Penaeus monodon Fab.

One of the major problems in the mass production of sugpo is how to obtain a constant supply of fry. Since ultimately it is the private sector which should produce the sugpo fry to fill the needs of the industry, the Barangay Hatchery Project under the Prawn Program of the Aquaculture Department of SEAFDEC has scaled down the hatchery technology from large tanks to a level which can be adopted by the private sector, especially in the villages, with a minimum of financial and technical inputs. This guide to small-scale hatchery operations is expected to generate more enthusiasm among fish farmers interested in venturing into sugpo culture.

Assessment of inland waters fisheries in Nigeria with implications for improved freshwater fish production, poverty alleviation and food security

Rapid Appraisals of the current fisheries situations of some selected inland water bodies in Nigeria were carried out within the framework of Aquaculture and Inland Fisheries Project (AIFP) Annex II of the National Special Programme for Food Security (NSPFS). This paper presents the results of the fishery assessment of one of the selected inland water bodies (Sabke Lake) in Nigeria with a view to optimizing the fish yield through the adoption of improved culture based fishery techniques and community-based fisheries management. The lake is unmanaged and the fishing pressure was found to be very high. Also a number of fishermen were found using small mesh size nets to crop the juveniles of highly valued fish species for an optimum catch. About 14 fishermen ought to have been engaged in full time fishing activities if the fisheries of this lake is to be managed on a sustainable basis. However, a surplus of over 100 fishermen was recorded actively fishing during the period of the study. The results further revealed that Fisheries Rules and Regulations were not established for the national exploitation and proper management of the fisheries of many inland water bodies including Sabke Lake. All these have a depilatory effect on the abundance and sizes of fish harvested from the nigerian inland water bodies especially Sabke Lake. A community based management system that establishes a participatory involvement of fishermen in the conservation and national exploitation of fisheries resources for their own well being is recommended for Sabke Lake and other inland water bodies in Nigeria

Financial analysis of small-scale fish farming enterprises to alleviate poverty in homestead

This paper focuses on the financial analysis involved in setting up of fish farming on a small-scale in a homestead. About 0.5 acres of land was used for the construction of pond which as a stock of Clarias spp/ Heterobranchus spp and Tilapia spp at the ratio of one to three for a period of 12 months. The land/land development cost is N26,500.00, pond construction cost, N35,700.00, equipment cost, N2,650.00 and stock/Input requirement cost N155,727.00 while the revenue from sales is N376,000.00. A cash flow analysis is also calculated for the fish farm, which is N155,423.00 for first year cash flow, and appropriate profit/mosses were calculated for five-year production cycle of N1,036,515.00 million. At the end appreciable profit is realized from the enterprises. This type of enterprises is viable for small-scale farmers to practices and adopted for financial support for their family

Fish distribution in a small domestic water supply reservoir: a case study of Kangimi Reservoir, Kaduna, Nigeria

A study of the composition and distribution of fish populations in the inshore, surface and bottom water habitats of Kangimi Reservoir showed that the most abundant family was the Cichlidae followed in order of abundance by the familiesCyprinidae, Schilbeidae, Mormyridae, Mochokidae, Characidae, centropomidae and Bagridae. Though the overall composition of families caught inn the three habitats did not vary significantly (P>0.05) only family Cichlidae showed habitat preference: there was a preponderance of Cichlidae in the inshore water habitat (P<0.05). The families Bagridae and Centropomidae were caught only in the inshore and bottom water habitats while the other families were caught from all habitats and showed no habitat preference. The dominance of primary and secondary consumers indicates high fish production potential under adequate management

The basque ecological debt: global socioecological impacts of a small open economy

4 p.