The Research & Implement Of Real Time Database Based On OPC

Abstract: The theory and technology of Database is developing very rapidly,in today's information society,it's omnipresent,but the application of database is extending from traditional fields to new fields, especially,in process control field,the application is very different to traditional application, their facility and character, both database and real-time handling must be different,it not only need database to support sharing of large data for maintaining accordance but also need real-time handling to support it's transactions and data's timer bound.so real-time database technology now become a spickandspan direction, through RTDB we can well bring data management, data exchange and data sharing of process control supervise system into effect.Through making a study of present real-time DB technology and OPC technology, which is most popular industrial standard interface, we make a preliminary design of a RTDBMS based on OPC,lastly a RTDBMS have been accomplished,which is designed based on electric network supervise system, then all the application developer can use the RTDB control to create any system which need support of real-time database.After the test of RTDBMS which we have realized,without trigger,it only need 80ms to insert 1000 records, 20ms to select 1000 records from the table,100ms to update 1000 records,as against MySQL and other relation DBMS,our's RTDBMS has hundredfold quick reaction,in the application environment in which many fields need be triggerd,it also has quick reaction which the other relation DBMS is beyond comparison.