WW's InSQL is the world's first high-performance real-time relational database for factories. It integrates the function and flexibility of relational database with the high speed and compressibility of real-time database into the same product, and is suitable for factory production management. InSQL integrates Microsoft's MS SQL Server and extends it, so that it not only has real-time database performance such as high-speed data acquisition, efficient data compression and data storage, but also integrates factory data such as events, summary, production and configuration which are generally stored in relational databases. Hundreds of client applications can access all the factory information, which makes it have the best openness and flexibility in the field of industrial software. WW has the best graphic control software InTouch and I/O server in the world, which makes it more closely related to factory automation system.
Structure and technology of human body system
operating system
PI currently supports multiple operating system platforms. The server can run on DECVMS, IBM's AIX, HP-UX, Sun Solaris, Windows NT and Windows2000 servers, and the client software can run on Windows.
3. 1, 95, 98 and Windows NT.
InSQL server runs on Windows NT and Windows2000 Server, and the client software can run on Windows 3. 1, 95, 98 and Windows NT.
database technology
PI stores all data in a proprietary database, and its client software can extract data from the database and use it for display and analysis. If you use other databases or tools to analyze the data in the PI database, you need an ODBC interface or API. For the number of processes
According to the storage mode of, each point user can only define 6 fields.
The functions of InSQL, such as data collection, data compression, production dynamic browsing and historical data archiving, constitute a complete real-time database system, and both real-time data and historical data are saved with special files. The database server is embedded with Microsoft's ms.
SQL Server has the characteristics of relational database, enhanced the replication function, and integrated mail and Internet. It is the first real-time relational database that can meet the requirements of the factory for data acquisition speed and storage capacity, and it is better than the conventional database.
The data acquisition speed and storage capacity of the system database are hundreds of times. InSQL extends SQL statements to make them time-specific. Wonderware's resource tracking system InTrack, recipe management system InBach and statistical quality analysis SPCPro.
And other application systems can be used together with InSQL database, thus providing real contact transaction processing (OLTP) for manufacturing industry.
system performance
Each PI server can accommodate 6.5438+0.5 million points (high-end servers). At present, the accurate speed of storing these points has not been tested, but PI's customers think that PI's high-end product server can handle 654.38+0.5 million points of data per second. In the client software
On the ProcessBook, you can get the data of 1000 points with a history of 2 or 3 years in a few seconds. There is a spreadsheet on the OSI website that can help you calculate the required configuration in detail.
The running performance of InSQL is related to the hardware system used. It can acquire or store 60,000 points (peak value) in 65,438+0 seconds. This speed has nothing to do with the data storage mode, it is periodically stored (at a fixed number of milliseconds) or increased.
Quantity storage (once when the data changes more than a set percentage). InSQL can store 30,000 points per second (average) or 2,000 points of data every 65,438+000 milliseconds. The main obstacle to improve the speed of data acquisition is that most data sources (PLC or DCS) provide data.
The speed can't keep up with the speed of InSQL fetching. The minimum resolution of InSQL is 3.3 milliseconds.
A typical large factory with 40,000 process control points has different acquisition frequency requirements for different data. Suppose that the frequency requirements of logarithmic acquisition in this factory are: 500 points every 500ms, 1500 points every 5s, and 15 points every 5s.
Collect 5000 points per second, 1000 points every 30 seconds, 1 000 points every minute, and 13000 points every 5 minutes. It collects 2 177 data per second on average, or stores188 billion data every day. This is actually just
Is a small part of the ability to use InSQL.
Testability and distributed operation
A single PI server can support remote data access, and its structure is two-tier. The client directly connects to the database server using PI-API.
InSQL provides accurate browsing, reporting or analysis for end users, and uses their application development platform to develop personalized application software. Its open data model and standard SQL or ODBC application programming interface provide users with standard streams.
Line development environment. This database is easy to add tables, book programs and browse the required information. End users can create their own probes and use external programs or standard SQL to extend and customize the application system.
At the same time, users can choose from hundreds of client applications to meet their needs. Microsoft SQL Server embedded in InSQL enables it to have e-mail interface, IIS for publishing data through the Internet, replication of SQL Server and other functions.
Application data sending service based on SQL Server or Oracle database.
Core functions and characteristics
data acquisition
PI server includes a data acquisition engine and adopts its patented data compression algorithm. It is only responsible for collecting data and does not write back to the control system to confirm the collected data.
In InSQL, both analog values and switching values can be stored incrementally or periodically, and compressed according to the redundancy of factory data. The data storage space is only 2% of the traditional relational database, and it has extremely fast production data acquisition speed and data.
Storage capacity, and check the correctness of the data at the same time of data acquisition. It integrates MS SQL Server, supports standard SQL statements, breaks through the limitation of SQL language, increases data time characteristics, and integrates factory events, summary, production and.
Configuration and other data.
Support analysis tools
PI has Datalink to support reading PI data in Excel, and can also obtain compressed data through ODBC. All data in the database can be used in analysis tools. ProcessBook for trend analysis and ActiveView for web browsing.
InSQL supports various client application tools in industrial automation environment:
FactoryFactory: including trends, Excel/World, WEB reports and ActiveX controls that get data from InSQL.
Application software developed by third parties: including dynamic analysis tools, general report tools, analog display tools, navigation tools, browser-based application tools, historical playback tools, management report tools and general trend, graphics and charts tools.
Compatible application tools of SQL, ODBC and OLEDB: Crystal Reports and SQL Access in FactorySuite.
Customer personalized application: You can use VB/Delphi, PB, C++ and other tools to develop personalized application software.
Device interface support
OSI has more than 100 kinds of standard device interface software for connecting different control devices, which can support OPC data acquisition.
WW can directly communicate with more than 700 kinds of control equipment, and can integrate information such as data configuration, alarm, event, summary, dynamic data, batch data, resource data and related production data.
Charts and trends
OSI's ProceBook is a good selling point, which provides a very flexible process data analysis tool for end users.
InSQL has a complete set of charts and trend tools, including charts, trends, standard quality statistical charts and so on.
Data analysis tool
Both PI and InSQL can provide the most commonly used analysis tools, including: average, moving average, geometric average, standard deviation, cumulative value and so on.
Customer data analysis
PI provides end users with all kinds of mathematical analysis needed by VBA. In addition, you can purchase a complete set of flow tables for static data tables.
InSQL users can choose a variety of tools to customize data analysis. Common development tools are VB, Delphi, PowerBuilder and C++. At the same time, ActiveX controls can be used flexibly in InTouch or any ActiveX container.
Extract the data of InSQL.
Online SPC
PI provides the option of processing input data and SPC calculation, and records the calculation results (including alarm and control limits) in the data table. The data can then be analyzed with standard analysis tools.
InSQL can use its client software tools to perform routine SPC operations on data obtained from the server. Wonderware's products include SPC Pro components of InTouch, and QIAnalyst can provide online SPC alarm.
report to the police
PI alarm subsystem can define the monitoring of high alarm, low alarm and ROC alarm at any specified point. You can also monitor data sources for interruptions. All monitoring conditions can be upgraded to alarm conditions. Alarm conditions (conditions) are stored in the PI event log.
And can be viewed by standard analysis tools.
The InSQL event system allows users to set the detection of events (conditions) and set the corresponding actions when these events (conditions) occur. When the system detects the occurrence of this event, it will trigger the corresponding operation. The event system can also be set to check regularly.
Check. You can also use InTouch and SCADA real-time alarm to trigger a customized operation.
Off-line archiving
PI provides a method to move online compressed files to offline storage system, but it has nothing to do with archived data.
InSQL stores data in block file format, and the server directly stores a large number of long-term data on disk, and can play back the stored data at high speed through the network system. The long-term storage file format for backing up historical data blocks is DAT type.
Data management tools
PI does not provide data management and summary tools.
InSQL client software and many third-party software provide data management functions. All tools with MS SQL and ODBC interfaces can access InSQL data.
Batch analysis
PI can choose to provide batch analysis tools to evaluate process data according to batch events and actual time related to events. This is very useful for comparing one batch process with another batch (or gold batch data).
InSQL integrates batch historical data from InBatch as a standard data source, and can also manage batch data by event.
Market positioning and sales strategy
Company situation
Founded in the early 1980s, OSI has been focusing on the research and development of real-time data software and services, with more than 65,438+000 employees. Is an independent non-listed company, and its products have a large number of users at home and abroad. There is no office in China, which is handled by six agents.
Business in China. The software is not available in Chinese.
Wonderware Company was established in the early 1990s, providing industrial control software, real-time database software, equipment management software, resource tracking management system and other industrial production process applications, with nearly 1000 employees, belonging to the third largest automatic control system in the world.
The supplier Invesco Group is a listed company. China has two representative offices in Beijing and Shanghai. The main client software has been released in Chinese.
market strategy
OSI focuses on selling big projects, selling them to higher-level managers and focusing on the benefits generated. Therefore, at the manufacturing exhibition in March 2000, OSI positioned PI as an enterprise integration platform for process manufacturing.
InSQL is positioned to support applications of any size, which do not require SQL knowledge. The system can transfer the configuration files stored in InTouch to InSQL within a few minutes, which protects the engineering investment of users in InTouch. Closely integrated with InTouch
Dense, Tag only needs to be defined once, and the database is more complete. InSQL is designed as a zero management database environment. Standard MS BackOffice tools can be used to plan data backup. There are hundreds of client tools to choose from, which is completely satisfactory.
User's functional requirements and usage habits.
Major differences
Proteasome inhibitor
Market: Most installed users are satisfied.
Sales strategy: For many years, OSI only sells one product (recently acquired data integration software) and is used to selling products to high-level institutions at high prices. In recent years, under the pressure of InSQL, some price adjustments have been made.
Positioning: OSI positioned PI as an enterprise integration platform. It has R3 interface approved by SAP.
Advanced analysis tools: There is a good set of process industry analysis tools.
Process book: PB is its main analysis tool, and it is an ActiveX container with embedded VBA scripts. In contrast, WonderWare's FactorySuite has better overall functions.
InSQL
Market: users include all types such as process industry, discrete industry and mixed industry; InSQL won the award of Control Engineering magazine, and WonderWare was recognized by Microsoft as the largest SQL distributor in the industrial field (Microsoft MS SQL embedded in InSQL), and has sold more than 65,438+00,000 sets of software.
Price: Both low-end products and high-end products have strong price competitiveness.
Flexibility: Users can choose from hundreds of easy-to-use client applications to meet different needs. InSQL provides the most commonly used method for reading production information, the most commonly used platform for production application development, and the most convenient interface for connecting management systems. InSQL makes full use of the advantages of multiprocessor and fractional computer environment. InSQL's architecture separates data collection from data query, which enables it to provide solutions for small factories as small as hundreds of points to large factories as large as hundreds of thousands of points with the same software.
Technical openness: support standard database technology. Microsoft's embedded MS SQL Server makes it possible to integrate event, summary, production and configuration data in factory data. Integrate FactorySuite and MaintenanceSuite and apply them to
All levels of the factory.