Database technology for real-time analysis and control

Database technology for real-time analysis and control

Large-scale plants for the production, sewage treatment and power are necessary to increase the visibility of the greatest influence, that a better and faster decision making offers to process higher productivity and lower costs of a sustainable competitive advantage. The key factors and criteria that companies consider for the management, measurement and control of production processes and costs may be important to be stored in a database for analysis. The technological process historian based protocol huge connectivity and application of intelligent analysis are very important for decision-industrial complexes. Larger systems have the need for large amounts of data and business processes to save. Different databases often have to work together. Discover the differences between the databases helps you make the best database for you.

Limited computer memory has become a bottleneck in the system. The information revolution has led a lot more data now than in the past. Systems are large databases generate a flood of new data all the time. With the growth of computer memory capacity, there is a tendency to store data permanently types. For more information, see purchased and further information can be stored. At the beginning of the revolution in the security systems business information is often stored only the final details of the transaction. Discard old information and writing about the assigned space. Now most companies tend to save that which is to every transaction, every call, every click on a website and stored in the communication of any changes. Due to this development, large amounts of computer memory is getting used to. In the enterprise-level applications, the cost of mass data storage often surprising.

Relational databases are often used in commercial applications such as customer relationship management systems used. Business applications often require a number of areas to be saved as customer name, company name, address, telephone number and e-mail. Industrial applications often require simple and fields, as the name of a label, a label reading and atime are stored. Production data is relatively much easier, however, the number of points is usually very large. In real time and historical data processing, the processing power surpasses that of a relational database. A major advantage of the database is a process, data historian simple mass production and the generation of historical data.

A database-comparison study was conducted by Wellintech, Inc., in a system of data protection for environmental management. They transformed the data from one system to the Oracle database process historian relational database. The database has about 90 percent of the systems hard drive. The system has been in operation for three years. The database contains a large amount of data and is based on a geographic information system, the GPS information, maps, places, time stamps, information about the spatial map, locations and stores. The database was also carried out a large amount of management information system for monitoring the environment. The database has been replaced to reduce by the historian database and procedures by the historian database compression to save storage space by 25 percent. The application of the basic room was occupied and was reduced much faster with the basic process of the historian.

Databases through a process historian data compression algorithm compresses more. Changes in the production of data in the field of industrial processes, often with the laws of the waveform. Only a small portion of the label variables change the frequency. The values ​​of other labels Ery slowly changing, and the user can verify the loss of data within a certain range. Data compression in the process of database technology is real-time/historical very important to speed because they can save large amounts of disk space and can request help.

CHANGE (0) compression algorithm for each type of variable compression. Only detects the compression detection and timing verif same value. It is stored in a variable has changed value. Do not store Varial if nothing had changed. For each type of compression algorithm is the first step to check the time stamp of quality.

The beginning of the dead zone compression algorithm is very simple. Saves data if the change in the exchange value reaches a certain threshold. For many variables that change slowly in the process of actual production, which can significantly reduce the amount of stored data.

The compression algorithm of the swinging door, was it first proposed by OSI Soft PI. S algorithm is relatively simple and complete algorithm for PI to the public. Now, almost all foundations of this process of compression algorithm historians have assumed, and added new technologies to make it optimally. The principle of the algorithm judges the door swings when a data item is stored. Draw a straight line between the previously recorded data on the next point P N. Check the data of absolute bias of data points (including A) between two points (P, N) and the data points on the line corresponds to the time stamp. If there is one operating point, which is the means of compression of point A must be saved.

These compression technologies can help improve saving space, the speed of retrieval of data. A large amount of data in the industrial base of the measuring and control equipment collected. Many industrial communication protocols are used in many different industries. BACnet and LonWorks are often used in HVAC systems, 102 CENTRAL Modbus protocol and process control. Lot connectivity, data acquisition is very important in intelligent information systems.

Intelligent analysis of efficiency in all sectors need equipment data acquisition, data storage in a database and converts the data into useful information for decision making. The data can be information about tools database analysis process, that the historian, you can calculate things like the number of tons of treated water to be converted into a sewage treatment plant effluent in a week. The tool of analysis of historical data to predict future events, or an uncertain estimate of past events.

Relational databases are ideal for commercial systems or less. Istory process databases are ideal for industrial applications that change at which the measured data can not be over time or need a reference speed of large data sets.