Luculent real-time history database TrendDB is the large universal distributed real-time database management software independently developed by Luculent, featured with independence, reliability, controllability and superior cost performance. TrendDB controls the core data related to the company production and acts as the bridge between the group real-time production data and its management data so as to construct the common data platform of the advanced application software for the company management staff and analysts and resolve the original information island problem.
The company can construct the plant-level monitoring, manufacturing and energy management systems etc. through real-time data acquisition and application of TrendDB, so TrendDB is widely used in the fields of electric power, petrifaction, metallurgy, coal mining, equipment, transportation and environment and taken as one of the cores for big data in the smart city.
Linking to the industrial sensor network, it establishes the real-time data center and construct the big data platform for the company;
After big data analysis on the real-time data, it can provide data supports to assist the company in making decisions;
Its visualized development tools in the real-time database can be used to rapidly set up applications.
Luculent real-time history database TrendDB contains the complete real-time history database system and the software package required for application development: management tools, development tools, analysis application and external interfaces. TrendDB provides the function of overall real-time data processing in addition to overall supports for application development.
1) The visualized tool software with complete functions efficiently supports rapid construction of the real-time monitoring applications.
The plant-level monitoring application comes true in three steps.
It highlights the flexible configuration designs
“Strong” data acquisition interface.
The complete data interfaces of the mainstream system shaped upon the long-time accumulation support connection with over 300 aggregate data systems and data sources and provide the plug-in development supports to flexibly load the new interface protocol.
It boasts the interface visualization management, monitors the real-time interface status and sends the fault link alarm notices. And the link faults are automatically cached with breakpoint resumed. And the system can be recovered automatically from malfunction.
2) it can implement multi-dimensional management on the real-time data and provide the open interfaces to fully support development of the advanced applications.
Statistical analysis of real-time data which provides data supports to assist the management layer in making decision.
It carries out multi-dimensional real-time statistical analysis for numerous production data of which the whole process is traceable.
It has the efficient engine for statistical analyses to keep data real-time, complete and accurate in such analyses.
Through the process modeling, it can improve the supporting capability for the analyzing applications.
The SDK development package with complete functions can be used to realize the high development efficiency.
3) It can provide rich application package for all-dimensional data management.
It provides the basic applications such as trend analysis, history playback and alarm services, realizes overall data analysis and supports advanced application expansion.
The combination of management and development tools with abundant functions can realize overall management over real-time data and support the database operation and maintenance.
4) Key technology innovation of the real-time database can get high performance and superior efficiency to expand and analyze advanced applications.
The professional multilevel cache data compression technology can be used to realize the real-time storage of numerous data short of maintenance.
The powerful distribution technology can realize the infinite point expansion of the system.
Efficient computation engine technology of dynamic linkage can facilitate real-time computation featured with high performance.
The elaborate digital modeling technology can strongly support the advanced analyzing applications.
1) System services
Real-time data service
Real-time data service is one of the core services provided by TrendDB and it is mainly responsible for processing real-time data, including the following functions: it coordinates real-time data processing with the read-write operation used to process real-time data and completes the lossy compression over the real-time data at the same time with the cache mechanism which keeps the data flowing orderly and effectively; the measured spot sheet related to the spot management and maintenance data can be used to ensure uniqueness of the measured spot; meanwhile, the user request treatment mainly includes user linkage management and the user request treatment of measured spot data.
History archiving service
The history archiving service is one of the core services provided by TrendDB and it is mainly used to complete the management tasks of history data, including the following functions: for history data storage, it carries out lossless compression of the data cached, keeps the data compressed in the file system and generates the data index to facilitate data inquiry in the future; for history data maintenance, it handles the history data request and provides the functions of history data inquiry, modification and deletion.
Interface platform service
It realizes the centralized management of the data collected and integrates the acquisition applications originally scattered of different networks into the same platform so as to realize the interface development and the management standardization. And its interface configuration function can screen out the differences between different interface protocols and simplify the configuration operation. The data cache can automatically upload the cached data after recovery from malfunction; its interface monitoring function can deal with the problems, such as data transmission network troubleshooting and management confusion, and facilitate interface maintenance by the system administrator; and the plug-in development supports the customized interface development, dynamic expansion and plug-and-play.
2) System application
The real-time monitoring can take real-time image configuration as required by the user and keep the system production analog diagrams consistent with the monitoring images of each production control system. It displays the real-time information of each plant production system in the Web manner for the production management staff, with its call-out time <1s and its refresh rate ≤1s, so the analysts can use such real-time information. And finally it shows such information in the visual modes of analog diagram, trend chart, bar graph, tables and text for the user terminals.
Select a suitable data point and provide the relevant inquiry conditions to inquire all historic data of the point within a certain period. It supports an inquiry with combined conditions, that is, the user can give one or more inquiry conditions and all data compliant are shown according to the conditions given, for example, the user can inquiry the historic data at each point depending on time, partition, interval etc. and export such historic data in the Excel format.
The history playback combines the historic data and the monitoring images in full consistence with DCS to show the historic unit conditions (all parameters and states), while the user can switch the images conveniently, maintain the parameter consistency and even randomly invoke the image playback within any period of the historic data cycle kept by the real-time database; moreover, the data playback function supports speed-up or slow-down by multiple speed times and data playback within any period and provides evidences for review and analysis of a fault or an accident.
It can real-time monitor the alarm data points set in the DCS and the important data points set in other systems. It realizes the alarming function by use of different colors; and the data points return to normal as shown after the alarm is eliminated.
3) Management tools
The control center is the system entrance where it is possible to control on or off of all modules in the system and monitor the whole system running status; and the system administrator can easily maintain the system by use of the control center.
The performance monitoring module can be used to review the overall resource utilization of each station in the TrendDB distributed system and in-depth check up the station resources distributed and used among specific modules; moreover, with the performance monitoring module, the administrator can rapidly pinpoint the unbalanced use of the system resources and timely adjust the system operation strategies.
The user management module can monitor all users linked currently, monitor and record the operation traces of each user and enable authority distribution and configuration among the users.
Measured point management
The measured point management tool can be used to add, delete, change and check up the measured points in the system and support import and export in batches; moreover, it can inquire and monitor real-time data in batch and customize the inquiries for the historic data at the measured point.
Through the configuration backup strategy, the backup service can enable historic data file backup; and the administrator can select the different backup strategies according to the specific system utilization so as to keep the system data complete and safe.
4) Development tools
The configuration tools are used to draw the production process configuration diagram and they support gallery design, script preparation, vector diagrams etc.; the graphic elements can be bound to the measured points in the database so as to realize real-time monitoring during the production.
During the system business analysis, many data used have no original acquisition points and such data can be acquired only after several arithmetical operations of the existing measured points; in such case, TrendDB computation tools have the data computation function and its operation formulas support VBScript, C# and other languages; in addition, it also integrates the existing computation models such as arithmetical library and steam library.
The real-time object library modeling tools can be used to create and maintain the business models and reflect the logical relationship among all devices of the business with the tree structure, for example, the tree structure between the plant system and the devices; meanwhile, the real-time object library modeling tools can convert the business models abstracted into the object model in order to maximize the relationship among all devices of the business and provide the basic supports for subsequent statistics, analyses and decisions made.
The statistical tools have the functions including out-of-limit, alarm and data statistics etc. so as to conduct real-time statistics and history analysis for data.
SDK development package
After the user installs SDK, he can access the real-time database system in the API mode which is equipped with the complete development instruction files in several versions of C/C++, .NET, JAVA etc. for the use by different development groups; OPC supports the standard OPC data communication protocol free of the development cost for data access, while it facilitates data integration with all kinds of industrial control software; WebService forestage exhibit layer can be used to easily access the real-time history data through WebService and it betters the real-time data accessibility by the upper layer applications.
Tongliao Power Plant – SIS at the Heat-Engine Plant Level
The plant-level supervisory information system (SIS) of Tongliao Power Plant contains the functions of real-time data acquisition, plant-level production process monitoring and management, plant-level performance computation and analysis, consumption difference analysis, equipment status monitoring and analysis, parameter out-of-limit and statistics, event alarming, production statistic statement, small index evaluation etc. And this project applies Luculent real-time history database scale of 100,000 points in combination of the modeling technology platform to greatly shorten the project implementation cycle and ensure superior project quality at the same time. And the digital modeling technology not only provides visualized modeling tools, uniform access interfaces and open model maintenance frame but also directly gets sample data, work condition library and knowledge base from the similar electric power plants and units and shares resources, so digital modeling technology brings about a huge reform for the project implementation process.
The plant-level monitoring information system is constructed to collect, categorize and statistically analyze the real-time production data all over the plant and the conditions are clear in each section of the production process. Moreover, this project takes the advanced process modeling technology and eliminates the original problem of difficult SIS change and modification, and the parameters of the SIS system can take overall custom adjustment so that the system perfectly works with various units and the data accuracy gets improved greatly; therefore, it has important guiding effects on optimal adjustment and reformation of the subsequent production.