ORACLE中对大数据量表的处理方法

本文阐述了在ORACLE数据库应用系统中使用分区技术处理大数据量表的原理和方法,并给出实现的例子。

国内语言景观研究现状、热点及趋势——基于数据量表和知识图谱的分析

运用图形制作与数据分析软件Microsoft Excel 2016和信息可视化工具CiteSpaceV对1997-2018年间CNKI期刊网络出版总库、人大复印资料全文数据库和万方期刊数据库所收录的语言景观文献从计量文献学角度进行了统计分析。数据量表和知识图谱互为补充,共同展现了国内语言景观研究的现状、热点及趋势。国内语言景观的论文年度发表量总体呈上升趋势,其中超过半数的研究为共时实证类调查,且标牌为主要研究对象。从高频关键词和关键词共现知识图谱来看,国内语言景观的热点主要集中于多语语言景观、语言景观与语言政策、语言景观与英语全球化、语言景观与少数民族语言等四个方面。未来国内语言景观研究的趋势主要表现在多语语言景观研究不断深入、语言景观的边界不断扩大、跨学科性不断增强等方面。

MS SQL Server中大数据量表的查询优化

在MS SQL Server中如何处理记录条数2000万以上且每日增加20万条的数据表,相信是很多开发人员面临的难题。本文以实际案例描述了此问题的解决方法及其存在的问题。在SQL Server 2000中,可以通过分区视图的定义来支持大数据量表的水平拆分和查询时的数据合并,且查询引擎提供的优化机制,使得SQL Server在大数据量条件下的查询性能得到了明显改进。最后,指出了本解决方法所带来的问题及其适用范围。

电网大数据量表设计优化技术及应用

阐述了在数据库设计阶段实施大数据量表设计优化工作的必要性.介绍了电网大数据量表的概念及产生原因,并针对因大数据量表而引发的数据库性能问题,提出了大数据量表设计优化相关的关键技术.在设备状态检修系统的数据库设计阶段,以设备状态评价功能为例进行实践应用.仿真实验表明对大数据量表实施设计优化后系统性能得到了显著提升.为后续系统稳定运行提供保障,也为类似的大数据量表设计优化应用提供了参考.

MS SQL Server2000中大数据量表的拆分与实现

在MS SQL Server的使用过程中,经常会遇到数据记录个数达几百万甚至上千万,每日新增数万、数十万条记录的表。以实际案例描述以时间的递增而记录数均匀递增的表的产生及解决过程,通过引入时间切片的观点,将此类表以时间的自然节点及查询要求进行拆分,以增加表的数量,减小表的记录个数,达到优化表的读写性能的目的。

浅议呼吸系统影像学专家诊断系统标准化数据量表的研究

知识来源本文提出的数据来源于以下三个方面：(1)临床资料。(2)影像医师读片所得：主观意识。(3)计算机图象识别信息：客观数据资料。

Improved Correlation for the Volume of Bubble Formed in Air-Water System

In order to address the bubble formation and movement in air-water two-phase flow,single bubble rising in stagnant water is experimentally studied by digital image processing.Bubbles are released individually from the submerged orifices with different diameters(1.81 mm,2.07 mm,2.98 mm,3.92 mm)at different detachment frequency.Images are recorded by a high-speed video camera and processed by digital image processing technique. The factors impacting the formed volume of bubble are discussed.The experimental results showed that a threshold of gas flow rate(400 mm 3 ·s- 1)divides the bubble formation into two regimes:the constant volume regime and the growing volume regime.Especially for the growing volume regime,the surface tension is taken into account.The bubble volume is consisted of two parts:the surface tension impacting part and the gas volume flow rate impacting part.An improved correlation for bubble volume prediction is developed for the two regimes and better coincidence with the experiment data than the previous models is obtained.

Processing of measurement while drilling data for rock mass characterization

The information extracted from monitoring of rotary blasthole drills helps to optimize the overall mining operation. Rock hardness, drillability, blastability and specific energy of drilling are examples of parameters that have been estimated in the past using measurement while drilling techniques. In order to be able to properly utilize measurement while drilling techniques, it is important to properly collect, analyze and interpret extracted data. This paper deals with processing of measurement while drilling data such as rate of penetration, rotary speed, rotary torque and pulldown force collected from rotary blasthole drills.Different methods are discussed to calculate a true rate of penetration which is the most important monitored drill variable for use in rock mass characterization. Then specific energy of drilling is defined and calculated based on electrical and mechanical inputs and the results are compared. The results show that specific energy of drilling can be estimated using the drill's primary drive systems' electrical responses with good accuracy when compared to values based on mechanical inputs.

Local anesthesia with ropivacaine for patients undergoing laparoscopic cholecystectomy

AIM:To investigate the effect of pain relief after infu-sion of ropivacaine at port sites at the end of surgery.METHODS:From October 2006 to September 2007,72 patients undergoing laparoscopic cholecystectomy(LC) were randomized into two groups of 36 patients.One group received ropivacaine infusion at the port sites at the end of LC and the other received normal saline.A visual analog scale was used to assess postoperative pain when the patient awakened in the operating room,6 and 24 h after surgery,and before discharge.The amount of analgesics use was also recorded.The demographics,laboratory data,hospital stay,and perioperative complications were compared between the two groups.RESULTS:There was no difference between the two groups preoperatively in terms of demographic and lab-oratory data.After surgery,similar operation time,blood loss,and no postoperative morbidity and mortality were observed in the two groups.However,a significantly lower pain score was observed in the patients undergo-ing LC with local anesthesia infusion at 1 h after LC and at discharge.Regarding analgesic use,the amount of meperidine used 1 h after LC and the total used during admission were lower in patients undergoing LC with local anesthesia infusion.This group also had a shorter hospital stay.CONCLUSION:Local anesthesia with ropivacaine at the port site in LC patients signif icantly decreased post-operative pain immediately.This explains the lower meperidine use and earlier discharge for these patients.

Analysis of Wind Power Assessment Based on the WRF Model

Assessing wind energy is a key step in selecting a site for a wind farm. The accuracy of the assessment is essential for the future operation of the wind farm. There are two main methods for assessing wind power: one is based on observational data and the other relies on mesoscale numerical weather prediction(NWP). In this study, the wind power of the Liaoning coastal wind farm was evaluated using observations from an anemometer tower and simulations by the Weather Research and Forecasting(WRF) model, to see whether the WRF model can produce a valid assessment of the wind power and whether the downscaling process can provide a better evaluation. The paper presents long-term wind data analysis in terms of annual, seasonal, and diurnal variations at the wind farm, which is located on the east coast of Liaoning Province. The results showed that, in spring and summer, the wind speed, wind direction, wind power density, and other main indicators were consistent between the two methods. However, the values of these parameters from the WRF model were significantly higher than the observations from the anemometer tower. Therefore, the causes of the differences between the two methods were further analyzed. There was much more deviation in the original material, National Centers for Environmental Prediction(NCEP) final(FNL) Operational Global Analysis data, in autumn and winter than in spring and summer. As the region is vulnerable to cold-air outbreaks and windy weather in autumn and winter, and the model usually forecasted stronger high or low systems with a longer duration, the predicted wind speed from the WRF model was too large.

WZ Sagittae Space WeathermGIobal Warming

The planet responds thermally to the impacts of nova WZ Sagittae debris by heating and cooling. The result in the first 19 years of the nova WZ Sagittae cycle is global warming that is hemi-spherically dependent and is detectable in South America ice core data and Antarctica surface mass balance data. Planetary thermal data are correlated in the past by calculating the debris impact times from the super outbursts times of nova WZ Sagittae. The shape of the arctic ice cap is dependent on the 220 degree path of the debris and does not exist southward between the western extension and eastern termini of nova WZ Sagittae that define the Arctic heating path. Future global heating from nova WZ Sagittae will begin in 2020-2021. The increase of 6 to 8 magnitude unusual earthquakes in recent years is the results of nova WZ Sagittae and SN 1054 debris impact. Unusual occurrences in the biosphere indicate the starting time of impacting supernova debris streams. The Antarctic sea ice distribution in November of 2016 defines the termini of maximum particle concentration impact from supernova 1006 in the southern hemisphere. The killing heat in India of the northern hemisphere is associated with the western terminus of this supernova. Novas and supernovas times of impact correlate with plague outbreaks in the western USA marking the particles in the debris streams as the cause of the disease.

Risk Communication： Survey on Quality of Safety Data Sheets of Agricultural Substances

Manufacturers of chemicals are responsible for setting up a list of tools, including labels and safety data sheets, in order to provide adequate information about dangerous properties being labels and safety data sheets the main instruments for the immediate advice about dangerous substances and preparations for general public and workers. While correct labelling gives the possibility to general public to recognise the risks arising from handling and use of dangerous chemicals, safety data sheets are provided for professionals in order to allow safe handling and storage of dangerous chemicals in work places. Information contained in safety data sheets are also designed to suggest safety measures to be taken for the protection of workers as well as precaution measures and adequate actions to be taken in the case of accident. This project has critically revised the information contained in a list of safety data sheets of active ingredients provided for plant protection products, in order to assess the quality and the consistency of the data contained. Reported data have been then compared to published data. Considerable deficiencies/mistakes/inconsistencies have been found in the data reported along the safety data sheets of the examined substances, showing an urgent need of improving the enforcement related to a systematic recognition in this field as well as training of people involved in compilation of safety data sheets by producer side.

Gender Differences in Quality of Attachment to God, Forgiveness, Altruism, and Mental Health in College and Seminary School Students

The aim of the current study was to investigate gender differences in quality of attachment to God, forgiveness, altruism and mental health in college and seminary school students as well. To fulfil the stated goal 993 individuals were selected by means of stratified sampling procedures and the following measures were distributed among them： Muslim-Spiritual Attachment Scale, Kin Altruism, Reciprocal Altruism Enright Forgiveness Inventory, and Symptom Checklist-90 Revised. Analysis of data using t test revealed significant differences between male and female students （/9 〈 0.01）. Moreover, data indicated that interpersonal sensitivity was higher in male students while somatization complains was higher among female students. Analysis of data showed that quality of secure attachment in female students were higher than male students （P 〈 0.01）. Moreover, female students were higher in altruism, especially in domain of compassion （P 〈 0.05）. In addition female students were higher in perceiving God as a Safe Haven and providing them with comfort and tranquility. Moreover, females students were higher in altruism （p 〈 0.05）, and forgiveness （p 〈 0.01）. The analysis of data revealed that female students were higher in the secure attachment to God, sympathy toward others and they scored higher in somatization complain while male students were higher in the interpersonal sensitivity. Theoretical implication and practical application of findings have been discussed in the original paper. Findings in this project were consistent with body of research findings. Theoretical implication and practical usage of the current study was described in the original paper. Data revealed that female student were higher in secure attachment to God, altruism and forgiveness. Showing emotional stability and higher spirituality.

Intercomparison of Surface Radiative Fluxes in the Arctic Ocean

Recent satellite data analysis has provided improved data sets relevant to the surface energy budget in the Arctic Ocean. In this paper, surface radiation properties in the Arctic Ocean obtained from the Surface Radiation Budget（SRB3.0） and the International Satellite Cloud Climatology Project（ISCCP-FD） during 1984– 2007 are analyzed and compared. Our analysis suggests that these datasets show encouraging agreement in basin-wide averaged seasonal cycle and spatial distribution of surface albedo; net surface shortwave and all-wave radiative fluxes; and shortwave, longwave, and all-wave cloud radiative forcings. However, a systematic large discrepancy is detected for the net surface longwave radiative flux between the two data sets at a magnitude of ~ 23 W m–2, which is primarily attributed to significant differences in surface temperature, particularly from April to June. Moreover, the largest difference in surface shortwave and all-wave cloud radiative forcings between the two data sets is apparent in early June at a magnitude of 30 W m–2.

Time-Dependent Sediment Transport Subjected to Downward Seepage

Experiments were conducted using cohesionless sand particles with median diameter of 0.48 mm to investigate the time variation of sediment transport rate under the influence of local downward seepage.The experimental results show that the bedload transport rate in terms of volumetric sediment transport rate per unit width increased rapidly with time in the presence of suction,eventually reaching a peak beyond which it started to decrease.The trend of reduction was significantly reduced beyond 8 400 s after the test started.The analytical expression was derived in terms of dimensionless sediment transport rate and dimensionless time.The hypothesized relationships were compared with the experimental data,indicating a good agreement with each other.

A dual-pass data assimilation scheme for estimating surface fluxes with FY3A-VIRR land surface temperature

In this work, a dual-pass data assimilation scheme is developed to improve predictions of surface flux. Pass 1 of the dual-pass data assimilation scheme optimizes the model vegetation parameters at the weekly temporal scale, and Pass 2 optimizes the soil moisture at the daily temporal scale. Based on ensemble Kalman filter(EnKF), the land surface temperature(LST) data derived from the new generation of Chinese meteorology satellite(FY3A-VIRR) are assimilated into common land model(CoLM) for the first time. Six sites, Daman, Guantao, Arou, BJ, Miyun and Jiyuan, are selected for the data assimilation experiments and include different climatological conditions. The results are compared with those from a dataset generated by a multi-scale surface flux observation system that includes an automatic weather station(AWS), eddy covariance(EC) and large aperture scintillometer(LAS). The results indicate that the dual-pass data assimilation scheme is able to reduce model uncertainties and improve predictions of surface flux with the assimilation of FY3A-VIRR LST data.