基于截止期的可推测实时数据库事务并发控制

在实时数据库应用环境中,最大的并发数或者吞吐量不再作为性能的重要衡量尺度,而把在截止期之前完成的事务数量作为决定性的性能指标。因此,综合乐观并发控制(OCC)和悲观并发控制(PCC)的方法,提出了基于截止期的两阶段可推测并发控制技术(PSCC)以提高事务满足时间限制的可能性。首先,基于事务的截止期对潜在的可能带来数据不一致性的威胁进行推测,尽早地重启那些变为现实的威胁可能性较大的冲突事务,允许变为现实可能性较小的冲突事务继续执行。其次,在校验阶段采用广播式的提交技术控制未违背提交一致性的事务的提交,保证了数据库一致性,同时暂时阻塞违背提交一致性的事务并利用优先级升级技术减少被阻塞事务的不必要的重启。最后,给出了PSCC的行为规则及算法描述。性能测试结果分析表明,PSCC比OCC-BC和HPA有更低的失败率的重启率。

基于eXtremeDB和主动式B/S模式的实时监控系统

eXtremeDB内存式实时数据库是为实时系统及嵌入式系统而特别设计的数据库。为满足多用户实时监控火箭发射的状态变化,本文设计了基于eXtremeDB实时数据库和主动式B/S模式的遥测数据实时监控系统。它与一般的监控系统不同,实现了多用户通过Web对实时数据进行监控和查询的功能,其客户端采用ActiveX和WinInet技术实现对服务器数据的实时显示,并增加数字签名验证功能以保证其安全性,具有响应时间短、查询速度快、丢包率低、界面友好等特点。

一种改进的基于交通网络的移动对象索引方法

通过对基于交通网络(简称网络)移动对象索引方法FNR-Tree的分析,提出了一种改进的TNR-Tree方法。该方法充分利用网络信息,增大空间索引粒度,使用更合理的时间间隔,加强对轨迹的索引。性能分析说明了TNR-Tree方法较大程度地减少数据存储量和索引尺寸,提高了插入性能,并能有效地进行轨迹索引。

Nested Transaction Concurrency Control in Parallel Real-Time Dat-abases

An integrated method for concurrency control in parallel real-time databases has been proposed in this paper. The nested transaction model has been investigated to offer more atomic execution units and finer grained control within in a transaction. Based on the classical nested locking protocol and the speculative concurrency control approach, a two-shadow adaptive concurrency control protocol, which combines the Sacrifice based Optimistic Concurrency Control (OPT-Sacrifice) and High Priority two-phase locking (HP2PL) algorithms together to support both optimistic and pessimistic shadow of each sub-transaction, has been proposed to increase the likelihood of successful timely commitment and to avoid unnecessary replication overload.

Real-Time Temperature Control for High Arch Dam Based on Decision Support System

It is important and difficult to control the temperature of mass concrete structure during high arch dam construction.A new method with decision support system is presented for temperature control and crack prevention.It is a database system with functions of data storage,information inquiry,data analysis,early warning and resource sharing.Monitoring information during construction can be digitized via this system,and the intelligent analysis and dynamic control of concrete temperature can be conducted.This method has been applied in the construction of the Dagangshan Arch Dam in China and has proven to be very convenient.Based on the decision support of this system and the dynamic adjustment of construction measures,the concrete temperature of this project is well-controlled.

Comparisons of three data storage models in parametric temporal databases

The parametric temporal data model captures a real world entity in a single tuple, which reduces query language complexity. Such a data model, however, is difficult to be implemented on top of conventional databases because of its unfixed attribute sizes. XML is a matured technology and can be an elegant solution for such challenge. Representing data in XML trigger a question about storage efficiency. The goal of this work is to provide a straightforward answer to such a question. To this end, we compare three different storage models for the parametric temporal data model and show that XML is not worse than any other approaches. Furthermore, XML outperforms the other storages under certain conditions. Therefore, our simulation results provide a positive indication that the myth about XML is not true in the parametric temporal data model.

Improved Pattern Tree for Incremental Frequent-Pattern Mining

By analyzing the existing prefix-tree data structure, an improved pattern tree was introduced for processing new transactions. It firstly stored transactions in a lexicographic order tree and then restructured the tree by sorting each path in a frequency-descending order. While updating the improved pattern tree, there was no need to rescan the entire new database or reconstruct a new tree for incremental updating. A test was performed on synthetic dataset T1014D100K with 100 000 transactions and 870 items. Experimental results show that the smaller the minimum sup- port threshold, the faster the improved pattern tree achieves over CanTree for all datasets. As the minimum support threshold increased from 2% to 3.5%, the runtime decreased from 452.71 s to 186.26 s. Meanwhile, the runtime re- quired by CanTree decreased from 1 367.03 s to 432.19 s. When the database was updated, the execution time of im- proved pattern tree consisted of construction of original improved pattern trees and reconstruction of initial tree. The experiment results showed that the runtime was saved by about 15% compared with that of CanTree. As the number of transactions increased, the runtime of improved pattern tree was about 25% shorter than that of FP-tree. The improved pattern tree also required less memory than CanTree.

Tunnel personnel positioning method based on TOA and modified location-fingerprint positioning

To position personnel in mines, the study discussed in this paper built on the tunnel personnel positioning method on the basis of both TOA and location-finger print(LFP) positioning. Given non-line of sight(NLOS) time delay in signal transmission caused by facilities and equipment shielding in tunnels and TOA measurement errors in both LFP database data and real-time data, this paper puts forth a database data de-noising algorithm based on distance threshold limitation and modified mean filtering(MMF), as well as a real-time data suppression algorithm based on speed threshold limitation and MMF.On this basis, a nearest neighboring data matching algorithm based on historical location and the speed threshold limitation is used to estimate personnel location and realize accurate personnel positioning.The results from both simulation and the experiment suggest that: compared with the basic LFP positioning method and the method that only suppresses real-time data error, the tunnel personnel positioning methods based on TOA and modified LFP positioning permits effectively eliminating error in TOA measurement, making the measured data close to the true positional data, and dropping the positioning error:the maximal positioning error in measurements from experiment drops by 9 and 3 m, respectively, and the positioning accuracy of 3 m is achievable in the condition used in the experiment.

A Real-time Data Model Based on Temporal Data

Real-time database systems contain not only transaction timing constraints, but also data timing constraints. This paper discusses the temporal characteristics of data in real-time databases and offers a definition of absolute and relative temporal consistency. In real-time database systems, it is often the case that the policies of transaction schedules only consider the deadline of real-time transactions, making it insufficient to ensure temporal correctness of transactions. A policy is given by considering both the deadlines of transactions and the “data deadline” to schedule real-time transactions. A real-time relational data model and a real-time relational algebra based on the characteristics of temporal data are also proposed. In this model, the temporal data has not only corresponding values, but also validity intervals corresponding to the data values. At the same time, this model is able to keep historical data values. When validity interval of a relation is [NOW, NOW], real-time relational algebra will transform to traditional relational algebra.

Quasi Serializable Concurrency Control in Distributed Real-Time Database Systems

This paper formally defines and analyses the new notion of correctness called quasi serializability, and then outlines corresponding concurrency control protocol QDHP for distributed real-time databases. Finally, through a series of simulation studies, it shows that using the new concurrency control protocol the performance of distributed real-time databases can be much improved.

Spatio-temporal Data Model Based on Relational Database System

In this paper,the entity_relation data model for integrating spatio_temporal data is designed.In the design,spatio_temporal data can be effectively stored and spatiao_temporal analysis can be easily realized.

A public Cloud-based China's Landslide Inventory Database(Cs LID): development, zone, and spatiotemporal analysis for significant historical events, 1949-2011

Landslide inventory plays an important role in recording landslide events and showing their temporal-spatial distribution. This paper describes the development, visualization, and analysis of a China's Landslide Inventory Database(Cs LID) by utilizing Google's public cloud computing platform. Firstly, Cs LID(Landslide Inventory Database) compiles a total of 1221 historical landslide events spanning the years 1949-2011 from relevant data sources. Secondly, the Cs LID is further broken down into six zones for characterizing landslide cause-effect, spatiotemporal distribution, fatalities, and socioeconomic impacts based on the geological environment and terrain. The results show that among all the six zones, zone V, located in Qinba and Southwest Mountainous Area is the most active landslide hotspot with the highest landslide hazard in China. Additionally, the Google public cloud computing platform enables the Cs LID to be easily accessible, visually interactive, and with the capability of allowing new data input to dynamically augment the database. This work developed a cyber-landslide inventory and used it to analyze the landslide temporal-spatial distribution in China.

Similarity based mixed transaction concurrency control protocol

Due to the various performance requirements and data access restrictions of different types of real-time transactions, concurrency control protocols which had been designed for the systems with single type of transactions are not sufficient for mixed real-time database systems (MRTDBS), where different types of real-time transactions coexist in the systems concurrently. In this paper, a new concurrency control protocol MRTT_CC for mixed real-time transactions is proposed. The new strategy integrates with different concurrency control protocols to meet the deadline requirements of different types of real-time transactions. The data similarity concept is also explored in the new protocol to reduce the blocking time of soft real-time transactions, which increases their chances to meet the deadlines. Simulation experiments show that the new protocol has gained good performance.

Applicability of Waterside Corrosion Models in Range of IFPE Database

Fuel rod cladding waterside corrosion is one of the phenomena that limit the life time of nuclear fuel. Corrosion performance depends on the cladding material properties as well as operating conditions during the irradiation of the fuel. As a function of temperature, power history, water chemistry, time, etc., waterside corrosion is of great concern in fuel performance evaluation, especially for high burnup fuels. This paper is dedicated to the study of the waterside corrosion phenomenon using the IFPE database by COPERNIC, which is developed for the analysis of fuel rod behaviors in normal operation and transient conditions. Different models, MATPRO, FRAMATOME and EPRI models, for example, are adopted in the simulations. The results derived from the models are compared and the unconformities are analyzed. Based on the comparative analysis, reasonable models are chosen to simulate certain irradiated fuel rods. Our analyses indicate that potential affecting factors which are not considered in COPERNIC code, such as water chemistry and alloy composition, should be responsible for discrepancies of certain rod predictions.

Meteorological Data Generation for the Numerical Simulation of Stratified Flow in the Joumine Reservoir, Tunisia

Dynamic numerical simulation of water conditions is useful for reservoir management. In remote semi-arid areas, however, meteorological and hydrological time-series data needed for computation are not frequently measured and must be obtained using other information. This paper presents a case study of data generation for the computation of thermal conditions in the Joumine Reservoir, Tunisia. Data from the Wind Finder web site and daily sunshine duration at the nearest weather stations were utilized to generate cloud cover and solar radiation data based on meteorological correlations obtained in Japan, which is located at the same latitude as Tunisia. A time series of inflow water temperature was estimated from air temperature using a numerical filter expressed as a linear second-order differential equation. A numerical simulation using a vertical 2-D （two-dimensional） turbulent flow model for a stratified water body with generated data successfully reproduced seasonal thermal conditions in the reservoir, which were monitored using a thermistor chain.

Spinal fractures resulting from traumatic injuries

Objective： To illustrate mechanisms of spine fractures and the pattern of spinal injuries characterized by the major mechanisms in urban population of Iran. Methods： Data regarding spinal injuries including demographics, mechanism and level of spinal injury, abbreviated injury score, associated injuries and final fate of the patients were extracted from the Iranian national trauma registry database from 1999 to 2004. Results： A total of 619 patients with traumatic spine fractures were identified, of whom 68.5% were males. The peak frequency of these injuries occurred in the 21-40 year age-group. Accidental falls and road traffic crashes （RTCs） were the most common mechanisms of spinal fractures （47.2% and 44.1%, respectively）. RTCs tended to occur in younger patients compared with accidental falls. The most common spinal region for spinal fracture was the lumbar spine （53.63%）. Cervical spine fractures were significantly more common in RTCs, while lumbar spine fractures were more common in accidental falls （P〈0.001）. A total of 171 （27.6%）patients had associated non-spinal injuries, of whom 127 had associated extremity injuries, and 55 had head injuries. Thirty-six （5.6%） patients had spinal cord injury （SCI）.The injury severity score of the RTC group was significantly higher than that of accidental falls （P=-0.002）. Fifteen （4%） patients died of traumatic injuries. The rate of death was significantly higher in RTCs compared with accidental falls （5.1% vs 2.1%, P=0.039）. Conclusions： The patterns of spinal fractures are similar to those reported from developed countries. RTCs tend to affect the younger age population and are associated with a higher degree of associated injuries and mortality than accidental falls. Therefore preventive strategies should be based on reduction of the number and severity of RTCs.