An Efficient Crash Recovery Technique for Real-Time Main Memory Database

This paper presents an efficient recovery scheme suitable for real-time mainmemory database. In the recovery scheme, log records are stored in non-volatile RAM which is dividedinto four different partitions based on transaction types. Similarly, a main memory database isdivided into four partitions based data types. When the using ratio of log store area exceeds thethreshold value, checkpoint procedure is triggered. During executing checkpoint procedure, someuseless log records are deleted. During restart recovery after a crash, partition reloading policyis adopted to assure that critical data are reloaded and restored in advance, so that the databasesystem can be brought up before the entire database is reloaded into main memory. Therefore downtime is obvionsly reduced. Simulation experiments show our recovery scheme obviously improves thesystem performance, and does a favor to meet the dtadlints of real-time transactions.

Scheduling transactions in mobile distributed real-time database systems

A DMVOCC-MVDA （distributed multiversion optimistic concurrency control with multiversion dynamic adjustment） protocol was presented to process mobile distributed real-time transaction in mobile broadcast environments. At the mobile hosts, all transactions perform local pre-validation. The local pre-validation process is carried out against the committed transactions at the server in the last broadcast cycle. Transactions that survive in local pre-validation must be submitted to the server for local final validation. The new protocol eliminates conflicts between mobile read-only and mobile update transactions, and resolves data conflicts flexibly by using multiversion dynamic adjustment of serialization order to avoid unnecessary restarts of transactions. Mobile read-only transactions can be committed with no-blocking, and respond time of mobile read-only transactions is greatly shortened. The tolerance of mobile transactions of disconnections from the broadcast channel is increased. In global validation mobile distributed transactions have to do check to ensure distributed serializability in all participants. The simulation results show that the new concurrency control protocol proposed offers better performance than other protocols in terms of miss rate, restart rate, commit rate. Under high work load （think time is ls） the miss rate of DMVOCC-MVDA is only 14.6%, is significantly lower than that of other protocols. The restart rate of DMVOCC-MVDA is only 32.3%, showing that DMVOCC-MVDA can effectively reduce the restart rate of mobile transactions. And the commit rate of DMVOCC-MVDA is up to 61.2%, which is obviously higher than that of other protocols.

Validation concurrency control protocol in parallel real-time database systems

In parallel real-time database systems, concurrency control protocols must satisfy time constraints as well as the integrity constraints. The authors present a validation concurrency control(VCC) protocol, which can enhance the performance of real-time concurrency control mechanism by reducing the number of transactions that might miss their deadlines, and compare the performance of validation concurrency control protocol with that of HP2PL(High priority two phase locking) protocol and OCC-TI-WAIT-50(Optimistic concurrency control-time interval-wait-50) protocol under shared-disk architecture by simulation. The simulation results reveal that the protocol the author presented can effectively reduce the number of transactions restarting which might miss their deadlines and performs better than HP2PL and OCC-TI-WAIT-50. It works well when arrival rate of transaction is lesser than threshold. However, due to resource contention the percentage of missing deadline increases sharply when arrival rate is greater than the threshold.

A dynamic crash recovery scheme for distributed real-time database systems

Recovery performance in the event of failures is very important for distributed real-time database systems. This paper presents a time-cognizant logging-based crash recovery scheme （TCLCRS） that aims at distributed real-time databases, which adopts a main memory database as its ground support. In our scheme, each site maintains a real-time log for local transactions and the subtransactions, which execute at the site, and execte local checkpointing independently. Log records are stored in non-volatile high- speed store, which is divided into four different partitions based on transaction classes. During restart recovery after a site crash, partitioned crash recovery strategy is adopted to ensure that the site can be brought up before the entire local secondary database is reloaded in main memory. The partitioned crash recovery strategy not only guarantees the internal consistency to be recovered, but also guarantee the temporal consistency and recovery of the sates of physical world influenced by uncommitted transactions. Combined with two- phase commit protocol, TCLCRS can guarantee failure atomicity of distributed real-time transactions.

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.

Real-Time Memory Data Optimization Mechanism of Edge IoT Agent

With the full development of disk-resident databases(DRDB)in recent years,it is widely used in business and transactional applications.In long-term use,some problems of disk databases are gradually exposed.For applications with high real-time requirements,the performance of using disk database is not satisfactory.In the context of the booming development of the Internet of things,domestic real-time databases have also gradually developed.Still,most of them only support the storage,processing,and analysis of data values with fewer data types,which can not fully meet the current industrial process control system data types,complex sources,fast update speed,and other needs.Facing the business needs of efficient data collection and storage of the Internet of things,this paper optimizes the transaction processing efficiency and data storage performance of the memory database,constructs a lightweight real-time memory database transaction processing and data storage model,realizes a lightweight real-time memory database transaction processing and data storage model,and improves the reliability and efficiency of the database.Through simulation,we proved that the cache hit rate of the cache replacement algorithm proposed in this paper is higher than the traditional LRU(Least Recently Used)algorithm.Using the cache replacement algorithm proposed in this paper can improve the performance of the system cache.

A sensor transaction scheduling algorithm for maintaining real-time data temporal validity

A new scheduling algorithm called deferrable scheduling with time slice exchange (DS-EXC) was proposed to maintain the temporal validity of real-time data. In DS-EXC, the time slice exchange method was designed to further defer the release time of transaction instances derived by the deferrable scheduling algorithm (DS-FP). In this way, more CPU time would be left for lower priority transactions and other transactions. In order to minimize the scheduling overhead, an off-line scheme was designed. In particular, the schedule for a transaction set is generated off-line until a repeating pattern is found, and then the pattern is used to construct the schedule on-line. The performance of DS-EXC was evaluated by sets of experiments. The results show that DS-EXC outperforms DS-FP in terms of increasing schedulable ratio. It also provides better performance under mixed workloads.

An Efficient Secure Real-Time Concurrency Control Protocol

Secure real-time databases must simultaneously satisfy two requirements in guaranteeing data security and minimizing the missing deadlines ratio of transactions. However, these two requirements can conflict with each other and achieve one requirement is to sacrifice the other. This paper presents a secure real-time concurrency control protocol based on optimistic method. The concurrency control protocol incorporates security constraints in a real-time optimistic concurrency control protocol and makes a suitable tradeoff between security and real-time requirements by introducing secure influence factor and real-time influence factor. The experimental results show the concurrency control protocol achieves data security without degrading real-time perform ance significantly.

Research on Real-time Data Sharing in Power Integrated Automation System

The Power Integrated Automation System has a large amount of the real-time data, it needs to achieve data sharing in different modules in its own system, sometimes even needs to be shared with the other systems. The thesis discusses the characteristics and the ways of the real-time data sharing in the first place. Then, it compares the merits and drawbacks in different ways. Besides, it gives a viable resolution in different aspects, such as the design of the real-time database, the framework of the communication system and the design of the communication software, as well as the real-time data sharing in different systems.

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.

Research and Application of Synchronization Update of Distributed Heterogeneous Database

According to the different equipment, different system and heterogeneous database have be information ＂isolated island＂ problem, and the data of equipments can be updated in real time on the business node. The paper proposes a program of data synchronization platform based on J2EE （JMS） and XML, and detailed analysis and description of the workflow system, its frame structure and the key technology. Practice shows that this scheme has the advantages of convenient and real-time etc..

The Multi-level Recovery of Main-memory Real-time Database Systems with ECBH

Storing the whole database in the main-memory is a common method to processreal-time transaction in real-time database systems. The recovery mechanism of Main-memory Real-timeDatabase Systems (MMRTDBS) should reflect the characteristics of the main-memory database andreal-time database because their structures are quite different from other conventional databasesystems. In this paper, therefore, we propose a multi-level recovery mechanism for main-memoryreal-time database systems with Extendable Chained Bucket Hashing (ECBH). Owing to the occurrence ofreal-time data in real-time systems, we should also consider it in our recovery mechanism .According to our performance test, this mechanism can improve the transaction concurrency, reducingtransactions ' deadline missing rate.

An IoT-Based Aquaculture Monitoring System Using Firebase

Indonesia is a producer in the fisheries sector,with production reaching 14.8 million tons in 2022.The production potential of the fisheries sector can be optimally optimized through aquaculture management.One of the most important issues in aquaculture management is how to efficiently control the fish pond water conditions.IoT technology can be applied to support a fish pond aquaculture monitoring system,especially for catfish species(Siluriformes),in real-time and remotely.One of the technologies that can provide this convenience is the IoT.The problem of this study is how to integrate IoT devices with Firebase’s cloud data system to provide reliable and precise data,which makes it easy for fish cultivators to monitor fishpond conditions in real time and remotely.The IoT aquaculture fishpond monitoring use 3 parameters:(1)water temperature;(2)pHwater level;and(3)turbidity level of pond water.IoT devices use temperature sensors,pH sensors,and turbidity sensors,which are integrated with a microcontroller and Wi-Fi module.Data from sensor readings are sent to the Firebase cloud via theWi-Fi module so that it can be accessed in real time by end users with an Androidbased mobile app.The findings are(1)the IoT-based aquaculture monitoring system device has a low error rate in measuring temprature,pH,and turbidity with a percentage of 1.75%,1.94% and 9.78%,respectively.Overall,the total average error of the three components is 4.49%;(2)in cost analysis,IoT-based has a cost-effectiveness of 94.21% compared to labor costs.An IoT-based aquaculture monitoring system using Firebase can be effectively used as a technology for monitoring fish pond conditions in real-time and remotely for fish cultivators that contribute to providing an IoT-based aquaculture monitoring system that produces valid data,is precise,is easy to implement,and is a low-cost system.

基于海迅数据库的电网运行监控分析及预警系统

随着智能电网的发展及调控一体化进程进一步深入,对电网的平稳运行及优质可靠供电的要求也越来越高。针对现有监控系统在电网稳定监视及辅助分析等方面的不足,提出并开发了基于海讯实时数据库的电网运行状态监控、分析及预警系统,详细介绍了系统的基本架构、设计思路和主要功能。

节能减排监管系统中数据统计服务的实现与应用

在电力行业节能减排监管系统中,从发电厂接入的大量实时数据,通常需要经过计算统计。为解决计算统计工作繁琐、计算量大、浪费人力等问题,设计开发了数据统计系统,通过建立自动计算,缩短计算时间,提高计算结果准确度,使接入的实时测点能在业务应用中充分发挥作用。介绍了数据统计系统的功能及实现。

2种实时数据库跨不同安全区的数据迁移工具实现与应用

电力行业节能减排监管系统的数据源种类多、地点分散,数据库的类型和版本、数据的命名格式也不尽相同,且处在不同的电力安全区,因此需要由数据迁移工具将这些数据实时、准确地上送到数据中心,供节能减排监管系统统计分析。为此设计开发了PI实时数据库到海迅实时数据库的实时数据迁移工具PItoHS,详细介绍了迁移工具的实现与应用。

基于海迅实时数据库的配电线路运行监视软件

从调控值班员、主站维护员的配电线路运行监视状况及现有运行监视软件等方面,分析了目前线路运行监视中面临的问题。设计开发了基于海讯实时数据库的线路运行监视软件,详细介绍了软件的设计思路、主要功能。软件的应用丰富了现有的监视手段,取得了很好的应用效果。

基于海迅数据库的应用开发方法的研究

针对电网企业实时应用开发模式不统一的问题,对标准的应用开发方法进行了研究。通过了解Prism框架,以Prism框架为根据,将基于海迅数据库的应用作为框架的一个功能模块,根据标准将应用封装为符合框架要求的应用模块,并利用关系数据库存储这些应用模块的配置信息,利用框架读取模块信息动态加载显示模块,从而形成一套基于海迅实时数据库的应用开发管理方案。研究成果可以实现应用的统一开发和管理,有利于提高管理应用的效率。

基于海迅实时数据库的有序用电辅助决策系统

利用海迅数据库提供的实时和历史数据并根据有序用电序位表,开发了有序用电监视及辅助决策系统。将实时监视、智能分析筛选、准确记录等各项功能集为一体,系统投运后极大地提高了有序用电拉限电执行的快速性、合理性和有效性。

基于海迅实时数据库的变电站设备温度在线监测系统

针对目前变电站设备温度检测存在的问题,利用无线通信、网络通信及海迅实时数据库技术,开发了变电站设备温度在线检测系统,解决了测温数据采集、传输、存储和发布3个关键问题,可迅速实时检测定位故障设备,提高了供电可靠性。