넳 넲

数据库归档

World-wide competition, increasing energy costs, scarce raw materials and high demands to product quality – companies from the process industry face many challenges. Specific optimization in view of process excellence and profitability are a must.

Task

Historic data from the company is a key to increase productivity. In order to make this enormous amount of data accessible for plant optimization, a powerful archive and report system is required.

The following requirements should be fulfilled:

availability and security of data

aggregation of information that is relevant to process control due to cross-company production report systems
central archiving of process data, tags, alarms and batch data from SIMATIC BATCH in realtime and without requiring additional energy as well as seamless, long-term and reliable data capture

identification and memorizing added and modified data as audit trail information

task-specific reporting and visualization of data

powerful data export to Microsoft Excel

flexible creating and adjusting report templates

standard reporting systems, in order to be able to use already available expert knowledge

Solution

This application describes the basics and the principle of operation of the Process Historian (PH) and of the Information Server (IS). It will be explained in detail how you can create individual reports in order to be able to read out data promptly from the Process Historian database. Furthermore, you will learn how to work with the Process Historian database.

Core contents of this application example:

explanation of the basics and of the function principle of the Process Historian

description of the Report Builder (tool for creating reports)

correct working with the PH database

explanation of the Stored Procedures of the Process Historian

prepared and described report templates for download

全球竞争，能源成本增加，原材料稀缺以及对产品质量的高要求–加工行业的公司面临许多挑战。鉴于流程的卓越性和获利能力，必须进行特定的优化。

任务

公司的历史数据是提高生产率的关键。为了使大量数据可用于工厂优化，需要强大的存档和报告系统。

应满足以下要求：

数据的可用性和安全性

跨公司生产报告系统的过程控制相关信息的汇总

从SIMATIC BATCH实时集中归档过程数据，标签，警报和批处理数据，而无需额外的能量以及无缝，长期和可靠的数据捕获

识别和存储已添加和已修改的数据作为审核跟踪信息

特定于任务的报告和数据可视化

强大的数据导出到Microsoft Excel

灵活地创建和调整报告模板

标准报告系统，以便能够使用已经可用的专家知识

解

此应用程序描述了Process Historian（PH）和Information Server（IS）的基本知识和操作原理。将详细说明如何创建单个报表，以便能够从Process Historian数据库中快速读取数据。此外，您还将学习如何使用Process Historian数据库。

此应用程序示例的核心内容：

对过程历史学家的基本知识和功能原理的解释

报表生成器的描述（用于创建报表的工具）

正确使用PH数据库

过程历史学家存储过程的说明