基于最终用户开发的表格数据分析关键技术研究

“最终用户开发（End-User Development，EUD）”研究如何使作为非专业软件开发者的软件系统用户，在一定程度上开发或修改软件。EUD的研究主要有三类，即EUD的理论研究、通用的EUD技术研究和面向领域的EUD技术研究。作为一个面向领域的EUD研究，本文以电子政务中常见的表格数据分析问题为背景，研究表格数据分析的EUD方法和技术。 表格数据分析是一种广泛存在的日常应用问题，除了各种业务系统中的表格分析系统，工业界也引入了EUD，比如“电子表格（Spreadsheet）”，但无论专用分析系统，还是Spreadsheet，都不足以应对表格数据分析问题在规模和复杂度方面的迅速增长。 本文在对表格数据分析问题进行建模的基础上，提出一种基于EUD的表格数据分析方法（Methodology of EUD-Enabled Tabular-data Analysis，META），并就META方法的应用和所需的关键支撑技术开展了研究，其贡献包括以下七个方面： 1）在Spreadsheet模型的基础上，对大规模表格数据分析问题进行了建模，该模型以数据层、逻辑层和表示层的分离为特征，对表格数据、表格展示和表格数据分析计算的表达能力，都超过已有的各种模型。 2）提出一种以EUD为核心的表格数据分析方法（META），该方法有三种应用模式，分别适用于不同的用户熟练程度和需求复杂度，既适用于简单的表格数据生成问题，也能支持复杂的EUD生命周期过程。 3）在对表格数据分析问题进行建模的基础上，通过扩展传统Spreadsheet语言，设计了一种支持最终用户开发的表格数据分析语言ESL（EUD-Enabled Spreadsheet Language），该语言继承了Spreadsheet语言的最终用户可编程性，同时，在表格数据分析方面的表达能力优于已有的其他语言。 4）在将ESL公式依赖关系建模的基础上，深入研究了影响Spreadsheet计算性能的各种因素。提出了基于拓扑排序的重算消减算法，解决了传统算法中存在的重算问题；以拓扑排序算法为基础，提出了ESL语言的并行计算方法；针对大规模表格数据访问，实现了能够显著降低SQL数据访问代价的缓存机制。这些研究，经实验验证，提高了ESL语言的执行效率。 5）为降低EUD中SQL编程的复杂度，通过引入领域语义和上下文（Context）配置的方法，解决了SQL自动生成中连接选择的二义性问题，实现了精确查询的SQL自动生成。其结果也可用于其他访问关系数据库的EUD系统。 6）有效性是ESL编程中的重要问题，由于缺乏合适的研究对象和用户群体，EUD有效性研究受到限制。在社会关系网络上开发Web插件，是一种典型的EUD活动，其中的“发行前错误”问题是一种重要的风险来源。本文提出的Release-Waiting Farm（RWF）技术，能够有效地引导最终用户对Web插件进行测试，并规范最终用户的开发过程。 7）本文总结了RWF技术在社会关系网络中得以成功的关键因素，基于RWF技术，为META方法设计了支持最终用户开发的协作环境和测试环境，并在全国组织系统软件框架开发项目中进行了实现和验证。

Studies on lignan constituents from Schisandra chinensis (Turcz.) Baill. fruits using high-performance liquid chromatography/electrospray ionization multiple-stage tandem mass spectrometry

A reversed-phase high-performance liquid chromatography-diode array detector-electrospray ionization multiple-stage tandem mass spectrometry (RP-HPLC-DAD-ESl-MSn) method has been developed for the detection and analysis of lignan constituents in the methanol extract from the fruits of Schisandra chinensis (Turcz.) Baill. RP-HPLC-DAD-ESI-MSn and electrospray ionization Fourier transform ion cyclotron resonance multiple-stage tandem mass spectrometry (ESI-FT-TCR-MSn) have been applied to investigate the characteristic product ions of four lignan reference compounds. Then, the logical fragmentation pathways of the lignans have been proposed. By comparing the retention time (t(R)) of HPLC, the ESI-MSn data and the structures of analyzed compounds with the data of reference compounds and in the literature, 11 peaks in HPLC have been unambiguously identified and another 5 peaks have been tentatively identified or deduced. Also, in the present paper, the extracted ion chromatograms (EIC) have been used to analyze the lignan isomers. The experimental results demonstrate that RP-HPLC-DAD-ESI-MSn is a specific and useful method for the identification of the lignan constituents and their isomers.

Polydispersity of ethylene sequence length in metallocene ethylene/alpha-olefin copolymers. I. Characterized by thermal-fractionation technique

In this article, the polydispersity of the ethylene sequence length (ESL) in ethylene/alpha-olefin copolymers was studied by atomic force microscopy (AFM) and the thermal-fractionation technique. The crystal morphology observation by AFM showed that morphology changed gradually with decreasing average ESL from complete lamellae over shorter and more curved lamellae to a granular-like morphology, and the mixed morphology was observed after stepwise crystallization from phase-separated melt. This result indicated that the ethylene sequence with different lengths crystallized into a crystalline phase with a different size and stability at the copolymer systems. The thermal-fractionation technique was used to characterize the polydispersity of ESL. Three of the following statistical terms were introduced to describe the distribution of ESL and the lamellar thickness: the arithmetic mean (L) over bar (n), the weight mean (L) over bar (w), and the broadness index I = (L) over bar (w)/(L) over bar (n). It was concluded that the polydispersity of ESL could be quantitatively characterized by the thermal-fractionation technique. The effects of temperature range, temperature-dependent specific heat capacity C-p of copolymer, and the molecular weight on the results of thermal fractionation were discussed,

孤北洼陷沙三-沙四段隐蔽油藏形成机制及其预测

Based on the study of sequence stratigraphy, modern sedimentary, basin analysis, and petroleum system in Gubei depression, this paper builds high resolution sequence stratigraphic structure, sedimentary system, sandbody distribution, the effect of tectonic in sequence and sedimentary system evolution and model of tectonic-lithofacies. The pool formation mechanism of subtle trap is developed. There are some conclusions and views as follows. 1.With the synthetic sequence analysis of drilling, seismic, and well log, the highly resolution sequence structure is build in Gubei depression. They are divided two secondary sequences and seven three-order sequences in Shahejie formation. They are include 4 kinds of system traces and 7 kinds of sedimentary systems which are alluvial fan, under water fan, alluvial fan and fan-delta, fan-delta, lacustrine-fan, fluvial-delta-turbidite, lakeshore beach and bar, and deep lake system. Sandbody distribution is show base on third order sequence. 2.Based on a lot of experiment and well log, it is point out that there are many types of pore in reservoir with the styles of corrosion pore, weak cementing, matrix cementing, impure filling, and 7 kinds of diagenetic facies. These reservoirs are evaluated by lateral and profile characteristics of diagenetic facies and reservoir properties. 3.The effect of simultaneous faulting on sediment process is analyzed from abrupt slope, gentle slope, and hollow zone. The 4 kinds of tectonic lithofacies models are developed in several periods in Gubei depression; the regional distribution of subtle trap is predicted by hydro accumulation characteristics of different tectonic lithofacies. 4.There are 4 types of compacting process, which are normal compaction, abnormal high pressure, abnormal low pressure and complex abnormal pressure. The domain type is normal compaction that locates any area of depression, but normal high pressure is located only deep hollow zone (depth more than 3000m), abnormal low pressures are located gentle slope and faulted abrupt slope (depth between 1200~2500m). 5.Two types dynamic systems of pool formation (enclosed and partly enclosed system) are recognized. They are composed by which source rocks are from Es3 and Es4, cap rocks are deep lacustrine shale of Esl and Es3, and sandstone reservoirs are 7 kinds of sedimentary system in Es3 and Es4. According to theory of petroleum system, two petroleum systems are divided in Es3 and Es4 of Gubei depression, which are high or normal pressure self-source system and normal or low pressure external-source system. 6.There are 3 kinds of combination model of pool formation, the first is litholgical pool of inner depression (high or normal pressure self-source type), the second is fault block or fault nose pool in marginal of depression (normal type), the third is fault block-lithological pool of central low lifted block (high or normal pressure type). The lithological pool is located central of depression, other pool are located gentle or abrupt slope that are controlled by lithological, faulting, unconfirmed. 7.This paper raise a new technique and process of exploration subtle trap which include geological modeling, coring description and logging recognition, and well log constrained inversion. These are composed to method and theory of predicting subtle trap. Application these methods and techniques, 6 hydro objects are predicted in three zone of depression.

东营凹陷岩性油气藏成藏动力学机制和预测

This paper is belonging to Chinese Petrochemical Industry Corporation's key project. Although it is very difficult, it has important theoretical and practical value. Its targets is to make lithological petroleum pool exploration great breakthrough in Dongying sag, by applying advanced theories, the last-minute methods and technology in highly explored zones. By using synthetically multi- discipline theories, methods and technology such as petroleum geology, sedimentology, structure geology, rock mechanics, dynamics of petroleum pool formation, geochemistry, geophysics and so on, and by making full use of computer , the process of petroleum pool forming and distribution rules of lithological petroleum pools have been thoroughly investigated and analyzed in sharp-slope, gentle-slope as well as low-lying region of Dongying sag including dynamic and static. With the study of tectonic stress field, fluid potential field and pressure field, we revealed dynamics condition, distribution rule, control factors and petroleum forming mechanism of lithological pool, and established the forming mode of lithological pool of Dongying sag. The main conclusion as follow: Strata framework, structure framework and sedimentary system of Dongying sag have been established which were the basis of petroleum prediction. There are three kinds of oil source which were from Es4,Es3 and mixed type, also three petroleum forming phases which were the telophase of Dongying stage, Guantao stage and Minghuazhen group, which occur in different geological environment. By using of most advanced numerical modeling software, the space distribution and time evolve of stress field and fluid potential field have been revealed from Esl up to the present. The region with low earth stress and low fluid potential were enrichment region of lithological petroleum pool and fault-block pool. The dynamics mechanism of Lithological petroleum pool in Dongying sag was collocating seal box, abnormity pressure, index number of petroleum forming and static factors on time and space, which was the most important factor of controlling petroleum pool forming, distribution and enrichment. The multi phase active and evolve of seal and unseal about different order fault were main factors of controlling petroleum pool forming of Dongying sag, which have important value for predicting lithological petroleum pool. It is revealed the lithological petroleum pool forming mode that included respective character, forming mechanism and distribution rule in four structural belt, which was a base for lithological petroleum pool prediction. The theories, technology and methods of studying, description, characterize and prediction lithological petroleum pool were established, which have important popularization value. Several lithological pool have been predicted in stress transform, zone, abrupt slope zone, fractured surface changed zone, tosional stress growth zone and abnormity pressure zone with noticeable economic benefit after exploration.