Desenvolvimento de um sistema de Data Warehousing para a consolidação da informação num grupo empresarial

Pretende-se desenvolver um Data Warehouse para um grupo empresarial constituído por quatro empresas, tendo como objectivo primordial a consolidação de informação. A consolidação da informação é de extrema utilidade, uma vez que as empresas podem ter dados comuns, tais como, produtos ou clientes. O principal objectivo dos sistemas analíticos é permitir analisar os dados dos sistemas transacionais da organização, fazendo com que os utilizadores que nada percebem destes sistemas consigam ter apoio nas tomadas decisão de uma forma simples e eficaz. A utilização do Data Warehouse é útil no apoio a decisões, uma vez que torna os utilizadores autónomos na realização de análises. Os utilizadores deixam de estar dependentes de especialistas em informática para efectuar as suas consultas e passam a ser eles próprios a realizá-las. Por conseguinte, o tempo de execução de uma consulta através do Data Warehouse é de poucos segundos, ao contrário das consultas criadas anteriormente pelos especialistas que por vezes demoravam horas a ser executadas. __ ABSTRACT: lt is intended to develop a Data Warehouse for a business related group of four companies, having by main goal the information consolidation. This information consolidation is of extreme usefulness since the companies can have common data, such as products or customers. The main goal of the analytical systems is to allow analyze data from the organization transactional systems, making that the users that do not understand anything of these systems may have support in a simple and effective way in every process of taking decisions. Using the Data Warehouse is useful to support decisions, once it will allow users to become autonomous in carrying out analysis. Users will no longer depend on computer experts to make their own queries and they can do it themselves. Therefore, the time of a query through the Data Warehouse takes only a few seconds, unlike the earlier queries created previously by experts that sometimes took hours to run.

Applicazione di strumenti di Lean Warehousing per il miglioramento di processi di magazzino: il caso studio di Dorelan B&T S.p.A.

La filosofia del lean thinking ha dimostrato in numerose occasioni, dalla sua nascita ad oggi, di poter apportare reali e consistenti benefici all’interno degli ambienti aziendali rivoluzionando a volte non solo il modo di produrre delle aziende ma anche quello di pensare, generando un profondo cambiamento culturale. La filosofia lean nasce come esigenza di riadattamento del sistema produttivo in contrapposizione a quello della mass production per questo molti dei testi di riferimento storici sul lean thinking citano prassi e casi aziendali che toccano esclusivamente l’ambito della produzione, tuttavia tale ambito rappresenta solamente uno dei tanti che si possono osservare in ambito aziendale. Successivamente si è compreso come il lean thinking rappresenti in realtà un sistema, composto da: principi, tecniche, metodi e strumenti in grado di garantire il miglioramento dei processi. Si tratta di fatto di un framework adattabile alle diverse funzioni aziendali e che per massimizzare la propria efficacia deve essere assimilato dall’intera organizzazione e non solo dall’ambiente produttivo. Negli anni infatti l’aggettivo “lean” è stato accostato agli ambiti più vari: lean sales, lean accounting, lean services, lean managment, lean organization, lean enterprise, lean office e molti altri. Tuttavia raramente ci si imbatte nel termine “lean warehousing” e ancora più raramente ci si imbatte in casi di applicazioni di strumenti lean in ambito logistico o a testi di riferimento che trattino l’argomento. In un mercato sempre più̀ competitivo è fondamentale per qualsiasi azienda avere una logistica efficiente e flessibile che consenta di offrire un alto livello di servizio per il cliente. Il magazzino rappresenta il punto di arrivo e di partenza per ogni flusso logistico e data la rilevanza che ancora oggi la sua funzione detiene per le aziende risulta fondamentale per il successo dell’interno sistema implementare anche in questa divisione la filosofia lean.

Assessing the effects of early silvicultural management on long-term site productivity of fast-growing eucalypt plantations: the Brazilian experience

Eucalyptus is the dominant and most productive planted forest in Brazil, covering around 3.4 million ha for the production of charcoal, pulp, sawtimber, timber plates, wood foils, plywood and for building purposes. At the early establishment of the forest plantations, during the second half of the 1960s, the eucalypt yield was 10 m(3) ha(-1) y(-1). Now, as a result of investments in research and technology, the average productivity is 38 m3 ha(-1) y(-1). The productivity restrictions are related to the following environmental factors, in order of importance: water deficits > nutrient deficiency > soil depth and strength. The clonal forests have been fundamental in sites with larger water and nutrient restrictions, where they out-perform those established from traditional seed-based planting stock. When the environmental limitations are small the productivities of plantations based on clones or seeds appear to be similar. In the long term there are risks to sustainability, because of the low fertility and low reserves of primary minerals in the soils, which are, commonly, loamy and clayey oxisols and ultisols. Usually, a decline of soil quality is caused by management that does not conserve soil and site resources, damages soil physical and chemical characteristics, and insufficient or unbalanced fertiliser management. The problem is more serious when fast-growing genotypes are planted, which have a high nutrient demand and uptake capacity, and therefore high nutrient output through harvesting. The need to mobilise less soil by providing more cover and protection, reduce the nutrient and organic matter losses, preserve crucial physical properties as permeability ( root growth, infiltration and aeration), improve weed control and reduce costs has led to a progressive increase in the use of minimum cultivation practices during the last 20 years, which has been accepted as a good alternative to keep or increase site quality in the long term. In this paper we provide a synthesis and critical appraisal of the research results and practical implications of early silvicultural management on long-term site productivity of fast-growing eucalypt plantations arising from the Brazilian context.

The development and production of leaves and tillers by Marandu palisadegrass fertilised with nitrogen and sulphur

The effects of combined nitrogen and sulphur fertilisation on the dynamics of leaf and tiller appearance in Marandu palisadegrass (Brachiaria brizantha cv. Marandu) and its impact on dry matter production were evaluated in a greenhouse study. Grass seedlings were grown in pots filled with a soil classified as an Entisol and were harvested after 43 days, a further 35 days and finally after 48 more days. Five rates of N (0, 100, 200, 300 and 400 mg/dm(3)) and 5 rates of S (0, 10, 20, 30 and 40 mg/dm(3)) were tested in an incomplete factorial design with 4 replications. Leaf and tiller development were monitored every 3 days by counting the appearance of recently expanded leaves and new basal tillers. The phyllochron and thermal time between appearance of tillers decreased as N and S fertiliser levels increased to about 300 and 25 mg/dm(3), respectively, then tended to increase. In contrast, leaf and tiller appearance rates increased with the supply of these nutrients to similar levels, then tended to decline. Leaf and tiller production and dry matter yields were affected by both N and S levels, with the role of S increasing as the growth phases increased.

Increasing the efficiency of solute leaching: impacts of flow interruption with drainage of the "preferential flow paths"

Most soils contain preferential flow paths that can impact on solute mobility. Solutes can move rapidly down the preferential flow paths with high pore-water velocities, but can be held in the less permeable region of the soil matrix with low pore-water velocities, thereby reducing the efficiency of leaching. In this study, we conducted leaching experiments with interruption of the flow and drainage of the main flow paths to assess the efficiency of this type of leaching. We compared our experimental results to a simple analytical model, which predicts the influence of the variations in concentration gradients within a single spherical aggregate (SSA) surrounded by preferential flow paths on leaching. We used large (length: 300 mm, diameter: 216 mm) undisturbed field soil cores from two contrasting soil types. To carry out intermittent leaching experiments, the field soil cores were first saturated with tracer solution (CaBr2), and background solution (CaCl2) was applied to mimic a leaching event. The cores were then drained at 25- to 30-cm suction to empty the main flow paths to mimic a dry period during which solutes could redistribute within the undrained region. We also conducted continuous leaching experiments to assess the impact of the dry periods on the efficiency of leaching. The flow interruptions with drainage enhanced leaching by 10-20% for our soils, which was consistent with the model's prediction, given an optimised equivalent aggregate radius for each soil. This parameter quantifies the time scales that characterise diffusion within the undrained region of the soil, and allows us to calculate the duration of the leaching events and interruption periods that would lead to more efficient leaching. Application of these methodologies will aid development of strategies for improving management of chemicals in soils, needed in managing salts in soils, in improving fertiliser efficiency, and in reclaiming contaminated soils. (C) 2000 Elsevier Science B.V. All rights reserved.

Environmental control of potential yield of sunflower in the subtropics

A simple framework was used to analyse the determinants of potential yield of sunflower (Helianthus annuus L.) in a subtropical environment. The aim was to investigate the stability of the determinants crop duration, canopy light interception, radiation use efficiency (RUE), and harvest index (HI) at 2 sowing times and with 3 genotypes differing in crop maturity and stature. Crop growth, phenology, light interception, yield, prevailing temperature, and radiation were recorded and measured throughout the crop cycle. Significant differences in grain yield were found between the 2 sowings, but not among genotypes within each sowing. Mean yields (0% moisture) were 6 . 02 and 2 . 17 t/ha for the first sowing, on 13 September (S1), and the second sowing, on 5 March (S2), respectively. Exceptionally high yields in S1 were due to high biomass assimilation associated with the high radiation environment, high light interception owing to a greater leaf area index, and high RUE (1 . 47-1 . 62 g/MJ) across genotypes. It is proposed that the high RUE was caused by high levels of available nitrogen maintained during crop growth by frequent applications of fertiliser and sewage effluent as irrigation. In addition to differences in the radiation environment, the assimilate partitioned to grain was reduced in S2 associated with a reduction in the duration of grain-filling. Harvest index was 0 . 40 in S1 and 0 . 25 in S2. It is hypothesised that low minimum temperatures experienced in S2 reduced assimilate production and partitioning, causing premature maturation.

Responses of sugarcane, maize, and soybean to phosphorus and vesicular-arbuscular mycorrhizal fungi

The presence of vesicular-arbuscular mycorrhizal (VAM) fungi in long-term cane-growing fields associated with yield decline led to the supposition that VAM fungi may be responsible for the poor yields. A glasshouse trial was established to test the effectiveness of a species of VAM fungi, Glomus clarum, extracted from one of these North Queensland fields on the growth of sugarcane (Saccharum interspecific hybrid), maize (Zea mays), and soybean (Glycine max) for 6 phosphorus (P) rates (0, 2.7, 8.2, 25, 74, 222 mg/kg). For maize and soybean plants that received VAM (+ VAM), root colonisation was associated with enhanced P uptake, improved dry weight (DW) production, and higher index tissue-P concentrations than those without VAM (-VAM). By comparing DW responses of maize and soybean for different P rates, savings in fertiliser P of up to 160 and 213 kg/ha, respectively, were realised. Sugarcane plants were generally less responsive. Apart from a 30% DW increase with VAM when 2.7 mg P/kg was added, DW of +VAM plants was equivalent to, or worse than in the case of 222 mg P/kg, DW of -VAM plants. For all 3 host species, colonisation was least at the highest P application, presumably from excessive P within the plant tissue. Critical P concentrations for the 3 host species were below those reported elsewhere, and for soybean and sugarcane, the critical concentration for +VAM plants was lower than that of -VAM plants. There are 3 implications that arise from this study. First, VAM fungi present in cane-growing soils can promote the growth of maize and soybean, which are potential rotation crops, over a range of P levels. Second, the mycorrhizal strain taken from this site did not generally contribute to a yield decline in sugarcane plants. Third, application of P fertiliser is not necessary for sugarcane when acid-extractable P is

Liveweight gains of steers at different stocking rates on monospecific Gatton panic and Estrella grass pastures in the Chaco Central region of Paraguay

A grazing trial to study the effect of stocking rate on animal production and botanical composition of Gallon panic (Panicum maximum) and Estrella grass (Cynodon nlemfuensis) was conducted in the central region of the Paraguayan Chaco between 1992 and 1998. The experiment included 6 stocking rates (0.5, 0.8. 1.1, 1.4. 1.7 and 2.0 AU/ha) on individual 4-ha paddocks. The pasture treatments were continuously grazed by yearling steers. replaced annually, over a 4-year grazing period. No fertiliser was used. Botanical composition was recorded annually in autumn from 1992 to 1998 while animal production data were recorded monthly from 1992 to 1996. Relationships between animal productivity and stocking rates were determined by regression analysis. Gallon panic produced greater liveweight gains per head than Estrella grass at low and intermediate stocking rates. However, the slope of the linear relationship between liveweight gain per head and stocking rate increased each year in Gallon panic indicating that the productivity of this grass progressively declined at higher stocking rates over the period of observation. Estrella grass showed less sensitivity to stocking rate but was affected severely by periods of low rainfall.

Genotype-by-management interactions for grain yield and grain protein concentration of wheat

The magnitude of genotype-by-management (G x M) interactions for grain yield and grain protein concentration was examined in a multi-environment trial (MET) involving a diverse set of 272 advanced breeding lines from the Queensland wheat breeding program. The MET was structured as a series of management-regimes imposed at 3 sites for 2 years. The management-regimes were generated at each site-year as separate trials in which planting time, N fertiliser application rate, cropping history, and irrigation were manipulated. irrigation was used to simulate different rainfall regimes. From the combined analysis of variance, the G x M interaction variance components were found to be the largest source of G x E interaction variation for both grain yield (0.117 +/- 0.005 t(2) ha(-2); 49% of total G x E 0.238 +/- 0.028 t(2) ha(-2)) and grain protein concentration (0.445 +/- 0.020%(2); 82% of total G x E 0.546 +/- 0.057%(2)), and in both cases this source of variation was larger than the genotypic variance component (grain yield 0.068 +/- 0.014 t(2) ha(-2) and grain protein 0.203 +/- 0.026%(2)). The genotypic correlation between the traits varied considerably with management-regime, ranging from -0.98 to -0.31, with an estimate of 0.0 for one trial. Pattern analysis identified advanced breeding lines with improved grain yield and grain protein concentration relative to the cultivars Hartog, Sunco and Meteor. It is likely that a large component of the previously documented G x E interactions for grain yield of wheat in the northern grains region are in part a result of G x M interactions. The implications of the strong influence of G x M interactions for the conduct of wheat breeding METs in the northern region are discussed. (C) 2001 Elsevier Science B.V. All rights reserved.

Significance of gaseous nitrogen loss from a tropical dairy pasture fertilised with urea

This paper reports a study in the wet tropics of Queensland on the fate of urea applied to a dairy pasture in the absence of grazing animals. A nitrogen balance was conducted in cylindrical plots with N-15-labelled urea, and ammonia volatilisation was determined using a mass balance micrometeorological method. The pasture plants took up 42% of the applied nitrogen in the 98 days between fertiliser application and harvest. At harvest 18% of the applied nitrogen was found in the soil, and 40% was lost from the plant-soil system. The micrometeorological study showed that 20% of the unrecovered nitrogen was lost by ammonia volatilisation. As there was no evidence for leaching or runoff losses it was concluded that the remaining 20% of the applied nitrogen was lost by denitrification. It is evident from these results that fertiliser nitrogen is not being used efficiently on dairy pastures, and that practices need to be changed to conserve fertiliser nitrogen and reduce contamination of the environment.

Technical, allocative, cost and scale efficiencies in Bangladesh rice cultivation: A non-parametric approach

Applying programming techniques to detailed data for 406 rice farms in 21 villages, for 1997, produces inefficiency measures, which differ substantially from the results of simple yield and unit cost measures. For the Boro (dry) season, mean technical efficiency was efficiency was 56.2 per cent and 69.4 per cent, allocative efficiency was 81.3 per cent, cost efficiency was 56.2 per cent and scale efficiency 94.9 per cent. The Aman (wet) season results are similar, but a few points lower. Allocative inefficiency is due to overuse of labour, suggesting population pressure, and of fertiliser, where recommended rates may warrant revision. Second-stage regressions show that large families are more inefficient, whereas farmers with better access to input markets, and those who do less off-farm work, tend to be more efficient. The information on the sources of inter-farm performance differentials could be used by the extension agents to help inefficient farmers. There is little excuse for such sub-optimal use of survey data, which are often collected at substantial costs.

Factors affecting the establishment and dispersal of nymphs of Pristhesancus plagipennis Walker (Hemiptera : Reduviidae) when released onto soybean, cotton and sunflower crops

A problem with augmenting predatory bugs through mass release is the logistical difficulty of delivering nymphs onto the foliage of field crops. In this paper we examine postrelease establishment and dispersal of the nymphs of the predatory bug Pristhesancus plagipennis on soybean, cotton and sunflower in an effort to devise an appropriate strategy for field release. The effects of predator stadia and release rates on field establishment and within-crop-canopy dispersal after hand release were recorded in soybean, cotton and sunflower. Field establishment improved with the release of more-developed nymphs, with third instars providing the most appropriate compromise between field hardiness and rearing cost. Increased nymphal density at the point of release had little effect on nymphal dispersal throughout the crop canopy. The patterns of nymphal dispersal observed on the three crops suggest that crop-canopy architecture may have an effect on the ability of nymphs to spread out postrelease, as nymphs dispersed poorly in cotton and sunflower compared to soybean. To overcome poor dispersal of nymphs after release, a mechanical release method, where nymphs were mixed with vermiculite and delivered onto a target crop through a spinning disk fertiliser spreader, was tested, and provided similar nymph establishment rates and dispersal patterns as releasing nymphs individually by hand. The implications of nymph dispersal and field hardiness in regard to inundative field release techniques are discussed.

The interaction of water flow and nutrients on aquatic plant growth

A long-term experiment was conducted to compare the effects of flowing and still water on growth, and the relationship between water flow and nutrients, in Aponogeton elongatus, a submerged aquatic macrophyte. A. elongatus plants were grown for 23 weeks with three levels of nutrition (0, 0.5 and 1g Osmocote Plus(R) fertiliser pot(-1)) in aquaria containing stirred or unstirred water. Fertilized plants grew much better than non-fertilized. The highest fertilizer level produced 29% wider leaves and 58% higher total dry weight in stirred water. Stirred water increased leaf area by 40% and tuber size by 81%, but only with the highest level of nutrition. These results suggest that this plant depends on its roots for mineral uptake, rather than from the open water, and the major limitation to growth in still water is the supply of dissolved inorganic carbon. It was the combined effects of nutrient availability and stirring that produced the strongest response in plant growth, morphology and composition. This study provides some explanation for the observations of others that these plants grow best in creeks or river systems with permanently flowing water.

Nitrogen cycling in degraded Leucaena leucocephala-Brachiaria decumbens pastures on an acid infertile soil in south-east Queensland, Australia

A grazing trial was conducted to quantify N cycling in degraded Leucaena leucocephala (leucaena)-Brachiaria decumbens (signal grass) pastures grown on an acid, infertile, podzolic soil in south-east Queensland. Nitrogen accumulation and cycling in leucaena-signal grass pastures were evaluated for 9 weeks until all of the leucaena on offer (mean 600 kg edible dry matter (EDM)/ha, 28% of total pasture EDM) was consumed. Nitrogen pools in the grass, leucaena, soil, cattle liveweight, faeces and urine were estimated. The podzolic soil (pH 4.8-5.9) was found to be deficient in P, Ca and K. Leucaena leaf tissues contained deficient levels of N, P and Ca. Grass tissues were deficient in N and P. Grazing was found to cycle 65% of N on offer in pasture herbage. However, due to the effect of the plant nutrient imbalances described above, biological N fixation by leucaena contributed only 15 kg/ha N to the pasture system over the 9-month regrowth period, of which 13 kg/ha N was cycled. Cattle retained 1.8 kg/ha N (8% of total N consumed) in body tissue and the remainder was excreted in dung and urine in approximately equal proportions. Mineral soil N concentrations did not change significantly (-3.5 kg/ha N) over the trial period. The ramifications of grazing and fertiliser management strategies, and implications for pasture rundown and sustainability are discussed.