An Application of a Multi-Tier Data Warehouse in Oil and Gas Drilling Information Management

Expenditure on wells constitute a significant part of the operational costs for a petroleum enterprise, where most of the cost results from drilling. This has prompted drilling departments to continuously look for ways to reduce their drilling costs and be as efficient as possible. A system called the Drilling Comprehensive Information Management and Application System (DCIMAS) is developed and presented here, with an aim at collecting, storing and making full use of the valuable well data and information relating to all drilling activities and operations. The DCIMAS comprises three main parts, including a data collection and transmission system, a data warehouse (DW) management system, and an integrated platform of core applications. With the support of the application platform, the DW management system is introduced, whereby the operation data are captured at well sites and transmitted electronically to a data warehouse via transmission equipment and ETL (extract, transformation and load) tools. With the high quality of the data guaranteed, our central task is to make the best use of the operation data and information for drilling analysis and to provide further information to guide later production stages. Applications have been developed and integrated on a uniform platform to interface directly with different layers of the multi-tier DW. Now, engineers in every department spend less time on data handling and more time on applying technology in their real work with the system.

Multi-Tier数据库应用程序及在Delphi中的实现

介绍了多层数据库应用程序的基本原理及其在Delphi中的实现技术,并以其在学分制教务管理系统开发的程序为原型,通过实例讲述在Delphi中实现Multi-Tier技术的步骤和要点。

Delphi中Multi-Tier结构的应用浅析

Multi Tier结构是目前分布式系统的主要应用结构,本文首先对传统的Two Tier结构数据库和Multi Tier结构数据库系统进行了比较,然后以三层数据库应用系统为例介绍Multi Tier结构应用的构建过程,并以一个实例加以说明。

使用Multi-Tier技术架构Web应用系统

Web系统目前被广泛应用于Internet/Intranet,随着网络的发展,传统的CGI/ISAPI标准结构已不能满足需要,本文介绍了Delphi的InternetExpress和DatabasePooling等Multi Tier技术,通过对CGI/ISAPI结构与InternetExpress结构的比较,介绍使用InternetExpress技术结合MST(MicrosoftTransactionServer)构建基于Web的三层结构系统的架构过程。并以开发实例加以说明。

Seismic assessment of two multi-tiered pagodas damaged by the 2015 Nepal earthquake

A seismic assessment of two multi-tier pagodas by numerical analysis is presented herein.The Changu Narayan temple and the Kumbeshwar temple in Nepal are used as the case studies.Both pagodas are built of brick masonry in earthen mortar,with timber columns and crossbeams.The Changu Narayan temple is a two-tier pagoda,and was seriously damaged during the 2015 Gorkha earthquake.The Kumbeshwar temple is a five-tier pagoda,and its top-tier collapsed due to the Gorkha earthquake.A seismic assessment was carried out using finite element(FE)analysis.The FE models were prepared,and dynamic identification tests and penetrometer tests were conducted.Pushover analysis and nonlinear dynamic analysis were performed as part of the seismic assessment.The main shock of the 2015 Gorkha earthquake was considered as the input accelerograms.The behavior between the two pagodas was compared with the collapse mechanisms and damage patterns observed in the actual structures.The comparison suggested common structural features of multi-tier pagodas.This study is dedicated to providing a better understanding of the seismic behavior of multi-tier pagoda-type structures and provides suggestions for their effective analysis.

Storage Assignment Optimization in a Multi-tier Shuttle Warehousing System

The current mathematical models for the storage assignment problem are generally established based on the traveling salesman problem（TSP）,which has been widely applied in the conventional automated storage and retrieval system（AS/RS）.However,the previous mathematical models in conventional AS/RS do not match multi-tier shuttle warehousing systems（MSWS） because the characteristics of parallel retrieval in multiple tiers and progressive vertical movement destroy the foundation of TSP.In this study,a two-stage open queuing network model in which shuttles and a lift are regarded as servers at different stages is proposed to analyze system performance in the terms of shuttle waiting period（SWP） and lift idle period（LIP） during transaction cycle time.A mean arrival time difference matrix for pairwise stock keeping units（SKUs） is presented to determine the mean waiting time and queue length to optimize the storage assignment problem on the basis of SKU correlation.The decomposition method is applied to analyze the interactions among outbound task time,SWP,and LIP.The ant colony clustering algorithm is designed to determine storage partitions using clustering items.In addition,goods are assigned for storage according to the rearranging permutation and the combination of storage partitions in a 2D plane.This combination is derived based on the analysis results of the queuing network model and on three basic principles.The storage assignment method and its entire optimization algorithm method as applied in a MSWS are verified through a practical engineering project conducted in the tobacco industry.The applying results show that the total SWP and LIP can be reduced effectively to improve the utilization rates of all devices and to increase the throughput of the distribution center.

Delphi与Multi-tiered应用开发

概述了数据库应用技术的发展历程。介绍了三层应用的结构及优点。以开发工具Delphi为例阐述了三层应用的工作原理与开发。

The competition between Bidens pilosa and Setaria viridis alters soil microbial composition and soil ecological function

Bidens pilosa is recognized as one of the major invasive plants in China.Its invasion has been associated with significant losses in agriculture,forestry,husbandry,and biodiversity.Soil ecosystems play an important role in alien plant invasion.Microorganisms within the soil act as intermediaries between plants and soil ecological functions,playing a role in regulating soil enzyme activities and nutrient dynamics.Understanding the interactions between invasive plants,soil microorganisms,and soil ecological processes is vital for managing and mitigating the impacts of invasive species on the environment.In this study,we conducted a systematic analysis focusing on B.pilosa and Setaria viridis,a common native companion plant in the invaded area.To simulate the invasion process of B.pilosa,we constructed homogeneous plots consisting of B.pilosa and S.viridis grown separately as monocultures,as well as in mixtures.The rhizosphere and bulk soils were collected from the alien plant B.pilosa and the native plant S.viridis.In order to focus on the soil ecological functional mechanisms that contribute to the successful invasion of B.pilosa,we analyzed the effects of B.pilosa on the composition of soil microbial communities and soil ecological functions.The results showed that the biomass of B.pilosa increased by 27.51% and that of S.viridis was significantly reduced by 66.56%.The organic matter contents in the bulk and rhizosphere soils of B.pilosa were approximately 1.30 times those in the native plant soils.The TN and NO_(3)^(-)contents in the rhizosphere soil of B.pilosa were 1.30 to 2.71 times those in the native plant soils.The activities of acid phosphatase,alkaline phosphatase,and urease in the rhizosphere soil of B.pilosa were 1.98-2.25 times higher than in the native plant soils.Using high-throughput sequencing of the16S rRNA gene,we found that B.pilosa altered the composition of the soil microbial community.Specifically,many genera in Actinobacteria and Proteobacteria were enriched in B.pilosa soils.Further correlation analyses verified that these genera had significantly positive relationships with soil nutrients and enzyme activities.Plant biomass,soil p H,and the contents of organic matter,TN,NO_(3)^(-),TP,AP,TK,and AK were the main factors affecting soil microbial communities.This study showed that the invasion of B.pilosa led to significant alterations in the composition of the soil microbial communities.These changes were closely linked to modifications in plant traits as well as soil physical and chemical properties.Some microbial species related to C,N and P cycling were enriched in the soil invaded by B.pilosa.These findings provide additional support for the hypothesis of soil-microbe feedback in the successful invasion of alien plants.They also offer insights into the ecological mechanism by which soil microbes contribute to the successful invasion of B.pilosa.Overall,our research contributes to a better understanding of the complex interactions between invasive plants,soil microbial communities,and ecosystem dynamics.

Biochar Decreases Soil Cadmium(Cd) Availability and Regulates Expression Levels of Cd Uptake/Transport-Related Genes to Reduce Cd Translocation in Rice

Biochar has been used as a soil amendment for heavy metal-contaminated soils, and it has the potential to mitigate Cd accumulation in plants. In this study, we used rice straw biochar(RSB) and kitchen waste biochar(KWB) to clarify the effect of biochar on Cd-contaminated neutral soil, the physiological responses to biochar application, and the gene regulatory networks in a rice genotype.

Subsoil tillage enhances wheat productivity,soil organic carbon and available nutrient status in dryland fields

Tillage practices during the fallow period benefit water storage and yield in dryland wheat crops.However,there is currently no clarity on the responses of soil organic carbon(SOC),total nitrogen(TN),and available nutrients to tillage practices within the growing season.This study evaluated the effects of three tillage practices(NT,no tillage;SS,subsoil tillage;DT,deep tillage)over five years on soil physicochemical properties.Soil samples at harvest stage from the fifth year were analyzed to determine the soil aggregate and aggregate-associated C and N fractions.The results indicated that SS and DT improved grain yield,straw biomass and straw carbon return of wheat compared with NT.In contrast to DT and NT,SS favored SOC and TN concentrations and stocks by increasing the soil organic carbon sequestration rate(SOCSR)and soil nitrogen sequestration rate(TNSR)in the 0-40 cm layer.Higher SOC levels under SS and NT were associated with greater aggregate-associated C fractions,while TN was positively associated with soluble organic nitrogen(SON).Compared with DT,the NT and SS treatments improved soil available nutrients in the 0-20 cm layer.These findings suggest that SS is an excellent practice for increasing soil carbon,nitrogen and nutrient availability in dryland wheat fields in North China.

A dynamic soil freezing characteristic curve model for frozen soil

The soil freezing characteristic curve(SFCC)plays a fundamental role in comprehending thermohydraulic behavior and numerical simulation of frozen soil.This study proposes a dynamic model to uniformly express SFCCs amidst varying total water contents throughout the freezing-thawing process.Firstly,a general model is proposed,wherein the unfrozen water content at arbitrary temperature is determined as the lesser of the current total water content and the reference value derived from saturated SFCC.The dynamic performance of this model is verified through test data.Subsequently,in accordance with electric double layer(EDL)theory,the theoretical residual and minimum temperatures in SFCC are calculated to be-14.5℃to-20℃for clay particles and-260℃,respectively.To ensure that the SFCC curve ends at minimum temperature,a correction function is introduced into the general model.Furthermore,a simplified dynamic model is proposed and investigated,necessitating only three parameters inherited from the general model.Additionally,both general and simplified models are evaluated based on a test database and proven to fit the test data exactly across the entire temperature range.Typical recommended parameter values for various types of soils are summarized.Overall,this study provides not only a theoretical basis for most empirical equations but also proposes a new and more general equation to describe the SFCC.

Straw return increases crop production by improving soil organic carbon sequestration and soil aggregation in a long-term wheat-cotton cropping system

Straw return is a promising strategy for managing soil organic carbon(SOC)and improving yield stability.However,the optimal straw return strategy for sustainable crop production in the wheat(Triticum aestivum L.)-cotton(Gossypium hirsutum L.)cropping system remains uncertain.The objective of this study was to quantify the long-term(10 years)impact of carbon(C)input on SOC sequestration,soil aggregation and crop yields in a wheat-cotton cropping system in the Yangtze River Valley,China.Five treatments were arranged with a single-factor randomized design as follows:no straw return(Control),return of wheat straw only(Wt),return of cotton straw only(Ct),return of 50%wheat and 50%cotton straw(Wh-Ch)and return of 100%wheat and 100%cotton straw(Wt-Ct).In comparison to the Control,the SOC content increased by 8.4 to 20.2%under straw return.A significant linear positive correlation between SOC sequestration and C input(1.42-7.19 Mg ha^(−1)yr^(−1))(P<0.05)was detected.The percentages of aggregates of sizes>2 and 1-2 mm at the 0-20 cm soil depth were also significantly elevated under straw return,with the greatest increase of the aggregate stability in the Wt-Ct treatment(28.1%).The average wheat yields increased by 12.4-36.0%and cotton yields increased by 29.4-73.7%,and significantly linear positive correlations were also detected between C input and the yields of wheat and cotton.The average sustainable yield index(SYI)reached a maximum value of 0.69 when the C input was 7.08 Mg ha^(−1)yr^(−1),which was close to the maximum value(SYI of 0.69,C input of 7.19 Mg ha^(−1)yr^(-1))in the Wt-Ct treatment.Overall,the return of both wheat and cotton straw was the best strategy for improving SOC sequestration,soil aggregation,yields and their sustainability in the wheat-cotton rotation system.

Assessment of soil erosion in the Irga watershed on the eastern edge of the Chota Nagpur Plateau,India

Human activities to improve the quality of life have accelerated the natural rate of soil erosion.In turn,these natural disasters have taken a great impact on humans.Human activities,particularly the conversion of vegetated land into agricultural land and built-up area,stand out as primary contributors to soil erosion.The present study investigated the risk of soil erosion in the Irga watershed located on the eastern fringe of the Chota Nagpur Plateau in Jharkhand,India,which is dominated by sandy loam and sandy clay loam soil with low soil organic carbon(SOC)content.The study used the Revised Universal Soil Loss Equation(RUSLE)and Geographical Information System(GIS)technique to determine the rate of soil erosion.The five parameters(rainfall-runoff erosivity(R)factor,soil erodibility(K)factor,slope length and steepness(LS)factor,cover-management(C)factor,and support practice(P)factor)of the RUSLE were applied to present a more accurate distribution characteristic of soil erosion in the Irga watershed.The result shows that the R factor is positively correlated with rainfall and follows the same distribution pattern as the rainfall.The K factor values in the northern part of the study area are relatively low,while they are relatively high in the southern part.The mean value of the LS factor is 2.74,which is low due to the flat terrain of the Irga watershed.There is a negative linear correlation between Normalized Difference Vegetation Index(NDVI)and the C factor,and the high values of the C factor are observed in places with low NDVI.The mean value of the P factor is 0.210,with a range from 0.000 to 1.000.After calculating all parameters,we obtained the average soil erosion rate of 1.43 t/(hm^(2)•a),with the highest rate reaching as high as 32.71 t/(hm^(2)•a).Therefore,the study area faces a low risk of soil erosion.However,preventative measures are essential to avoid future damage to productive and constructive activities caused by soil erosion.This study also identifies the spatial distribution of soil erosion rate,which will help policy-makers to implement targeted soil erosion control measures.

Three-year field study on grass growth and soil hydrological properties in biochar-amended soil

Field monitoring was conducted to investigate and quantify the long-term effects of peanut shell biochar on soil-grass interaction over three years.Three 10 m5 m grassed plots were constructed in completely decomposed granitic soil.Two of them were amended,respectively,with 5%and 10%biochar contents(m^(3)/m^(3))for grass growth,while the third was without biochar amendment.During the threeyear monitoring,plant characteristics,saturated water permeability(k_(s))of grassed soil and soil suction were measured.The monitored results show that the grass leaf area index(LAI)and root length density(RLD)with biochar amendment were improved by 38%and 200%,respectively.In the grassed plot without biochar,a threshold RLD existed with a value of 1.7 cm/cm^(3),beyond which k_(s) raised pronouncedly.The threshold RLD increased by 52%when biochar content increased from 0%to 10%.This implies that biochar may restrict the increase in k_(s) of grassed soil due to the rise in the threshold RLD.The presence of biochar and grass can retain over 100%higher suction after heavy rainfalls,while 54%lower peak suction under evapotranspiration(ET)compared with the non-amended plot.Biochar can alleviate the negative effects on hydraulic properties caused by plant growth and reduce ET-induced excessive water loss.A 5%peanut shell biochar content is recommended for the long-term management of vegetated earthen infrastructures.

Manure substitution improves maize yield by promoting soil fertility and mediating the microbial community in lime concretion black soil

Synthetic nitrogen(N)fertilizer has made a great contribution to the improvement of soil fertility and productivity,but excessive application of synthetic N fertilizer may cause agroecosystem risks,such as soil acidification,groundwater contamination and biodiversity reduction.Meanwhile,organic substitution has received increasing attention for its ecologically and environmentally friendly and productivity benefits.However,the linkages between manure substitution,crop yield and the underlying microbial mechanisms remain uncertain.To bridge this gap,a three-year field experiment was conducted with five fertilization regimes:i)Control,non-fertilization;CF,conventional synthetic fertilizer application;CF_(1/2)M_(1/2),1/2 N input via synthetic fertilizer and 1/2 N input via manure;CF_(1/4)M_(3/4),1/4 N input synthetic fertilizer and 3/4 N input via manure;M,manure application.All fertilization treatments were designed to have equal N input.Our results showed that all manure substituted treatments achieved high soil fertility indexes(SFI)and productivities by increasing the soil organic carbon(SOC),total N(TN)and available phosphorus(AP)concentrations,and by altering the bacterial community diversity and composition compared with CF.SOC,AP,and the soil C:N ratio were mainly responsible for microbial community variations.The co-occurrence network revealed that SOC and AP had strong positive associations with Rhodospirillales and Burkholderiales,while TN and C:N ratio had positive and negative associations with Micromonosporaceae,respectively.These specific taxa are implicated in soil macroelement turnover.Random Forest analysis predicted that both biotic(bacterial composition and Micromonosporaceae)and abiotic(AP,SOC,SFI,and TN)factors had significant effects on crop yield.The present work strengthens our understanding of the effects of manure substitution on crop yield and provides theoretical support for optimizing fertilization strategies.

Enhancing Deep Learning Soil Moisture Forecasting Models by Integrating Physics-based Models

Accurate soil moisture(SM)prediction is critical for understanding hydrological processes.Physics-based(PB)models exhibit large uncertainties in SM predictions arising from uncertain parameterizations and insufficient representation of land-surface processes.In addition to PB models,deep learning(DL)models have been widely used in SM predictions recently.However,few pure DL models have notably high success rates due to lacking physical information.Thus,we developed hybrid models to effectively integrate the outputs of PB models into DL models to improve SM predictions.To this end,we first developed a hybrid model based on the attention mechanism to take advantage of PB models at each forecast time scale(attention model).We further built an ensemble model that combined the advantages of different hybrid schemes(ensemble model).We utilized SM forecasts from the Global Forecast System to enhance the convolutional long short-term memory(ConvLSTM)model for 1–16 days of SM predictions.The performances of the proposed hybrid models were investigated and compared with two existing hybrid models.The results showed that the attention model could leverage benefits of PB models and achieved the best predictability of drought events among the different hybrid models.Moreover,the ensemble model performed best among all hybrid models at all forecast time scales and different soil conditions.It is highlighted that the ensemble model outperformed the pure DL model over 79.5%of in situ stations for 16-day predictions.These findings suggest that our proposed hybrid models can adequately exploit the benefits of PB model outputs to aid DL models in making SM predictions.

Plastic mulch increases dryland wheat yield and water-use productivity,while straw mulch increases soil water storage

Amplifying drought stress and high precipitation variability impair dryland wheat production.These problems can potentially be minimized by using plastic mulch(PM)or straw mulch(SM).Therefore,wheat grain yield,soil water storage,soil temperature and water-use productivity of PM and SM treatments were compared with no mulch(CK)treatment on dryland wheat over a period of eight seasons.Compared to the CK treatment,PM and SM treatments on average significantly increased grain yield by 12.6 and 10.5%,respectively.Compared to the CK treatment,SM treatment significantly decreased soil daily temperature by 0.57,0.60 and 0.48℃ for the whole seasons,growing periods and summer fallow periods,respectively.In contrast,compared to the CK treatment,PM treatment increased soil daily temperature by 0.44,0.51 and 0.27℃ for the whole seasons,growing periods and summer fallow periods,respectively.Lower soil temperature under SM allowed greater soil water storage than under PM.Soil water storage pre-seeding was 17%greater under the SM than under the PM treatment.Soil water storage post-harvest was similar for the PM and SM treatments,but evapotranspiration was 4.5%higher in the SM than in the PM treatment.Consequently,water-use productivity was 6.6%greater under PM than under the SM treatment.Therefore,PM treatment increased dryland wheat yield and water-use productivity,while straw mulch increased soil water storage.

Quantitatively characterizing sandy soil structure altered by MICP using multi-level thresholding segmentation algorithm

The influences of biological,chemical,and flow processes on soil structure through microbially induced carbonate precipitation(MICP)are not yet fully understood.In this study,we use a multi-level thresholding segmentation algorithm,genetic algorithm(GA)enhanced Kapur entropy(KE)(GAE-KE),to accomplish quantitative characterization of sandy soil structure altered by MICP cementation.A sandy soil sample was treated using MICP method and scanned by the synchrotron radiation(SR)micro-CT with a resolution of 6.5 mm.After validation,tri-level thresholding segmentation using GAE-KE successfully separated the precipitated calcium carbonate crystals from sand particles and pores.The spatial distributions of porosity,pore structure parameters,and flow characteristics were calculated for quantitative characterization.The results offer pore-scale insights into the MICP treatment effect,and the quantitative understanding confirms the feasibility of the GAE-KE multi-level thresholding segmentation algorithm.

Time-lagged Effects of the Spring Atmospheric Heat Source over the Tibetan Plateau on Summer Precipitation in Northeast China during 1961–2020:Role of Soil Moisture

The spring atmospheric heat source(AHS)over the Tibetan Plateau(TP)has been suggested to affect the Asian summer monsoon and summer precipitation over South China.However,its influence on the summer precipitation in Northeast China(NEC)remains unknown.The connection between spring TP AHS and subsequent summer precipitation over NEC from 1961 to 2020 is analyzed in this study.Results illustrate that stronger spring TP AHS can enhance subsequent summer NEC precipitation,and higher soil moisture in the Yellow River Valley-North China region(YRVNC)acts as a bridge.During spring,the strong TP AHS could strengthen the transportation of water vapor to East China and lead to excessive rainfall in the YRVNC.Thus,soil moisture increases,which regulates local thermal conditions by decreasing local surface skin temperature and sensible heat.Owing to the memory of soil moisture,the lower spring sensible heat over the YRVNC can last until mid-summer,decrease the land–sea thermal contrast,and weaken the southerly winds over the East Asia–western Pacific region and convective activities over the South China Sea and tropical western Pacific.This modulates the East Asia–Pacific teleconnection pattern,which leads to a cyclonic anomaly and excessive summer precipitation over NEC.

Performance Evaluation Approach for Multi-Tier Cloud Applications

Complex multi-tier applications deployed in cloud computing environments can experience rapid changes in their workloads. To ensure market readiness of such applications, adequate resources need to be provisioned so that the applications can meet the demands of specified workload levels and at the same time ensure that service level agreements are met. Multi-tier cloud applications can have complex deployment configurations with load balancers, web servers, application servers and database servers. Complex dependencies may exist between servers in various tiers. To support provisioning and capacity planning decisions, performance testing approaches with synthetic workloads are used. Accuracy of a performance testing approach is determined by how closely the generated synthetic workloads mimic the realistic workloads. Since multi-tier applications can have varied deployment configurations and characteristic workloads, there is a need for a generic performance testing methodology that allows accurately modeling the performance of applications. We propose a methodology for performance testing of complex multi-tier applications. The workloads of multi-tier cloud applications are captured in two different models-benchmark application and workload models. An architecture model captures the deployment configurations of multi-tier applications. We propose a rapid deployment prototyping methodology that can help in choosing the best and most cost effective deployments for multi-tier applications that meet the specified performance requirements. We also describe a system bottleneck detection approach based on experimental evaluation of multi-tier applications.