采用OLAP技术的在线监测监控系统智能报表的研究(Ⅱ)--系统设计、源代码组成和查询命令

OLAP的功能是面向数据的查询、分析、归纳和总结,用于决策支持和知识发现。本研究组开发的智能报表系统实现了类似OLAP的数据分析和查询功能,总称为SAP系统。SAP采用C／S模式。智能报表系统允许用户按自身需求定制报表,按报表要求对数据进行查询和分析,提供数据的格式化输出和多风格的打印。系统支持MDX(多维表达式)查询,对多个维度的数据的访问更为简单和直观。     

采用OLAP技术的在线监测监控系统智能报表的研究(Ⅰ)--系统架构和用户用例分析

OLAP(On-Line Analysis Processing)的功能是面向数据的查询、分析、归纳和总结,用于决策支持和知识发现。本研究组开发的智能报表系统实现了类似OLAP的数据分析和查询功能,总称为SAP系统。SAP采用C／S模式。智能报表系统允许用户按自身需求定制报表,按报表要求对数据进行查询和分析,提供数据的格式化输出和多风格的打印。系统支持MDX(多维表达式)查询,对多个维度的数据的访问更为简单和直观。     

大型企业报表引擎的优化设计与实现

报表是企业级应用系统的重要组成部分,优秀的报表可以对基础数据进行过滤、合并、统计、分析,提供直观的表达形式,并为决策提供良好的依据。目前大型企业基于B/S的报表系统开发模式相对不成熟,开发人员大都是根据实际需求直接写代码实现数据的分析、处理、展现功能,这样的实现方式会做很多重复工作,比如很多项目中都需要通过报表数据和图表来展现业务趋势,至于展现的时间粒度、地域粒度、数据纬度和指标却各不相同,结果是不同的。项目中类似的功能需要重复开发,总结起来就是可重用性低、可扩展性差、可维护性差、开发成本高。为解决以上问题,本文提出对业务需求进行高层次的抽象,实现一个能够统一分析数据、处理数据、展现信息的优化报表引擎,该报表引擎专注于业务逻辑的实现,与具体的业务分离,能帮助开发人员快速稳定地构建报表应用系统。基于该报表引擎开发的报表系统已应用于某省级电信运营商,从实际的运行情况看,系统运行稳定,并表现出良好的可扩展性,经过多用户并发查询、大数据量查询的测试,性能表现良好。     

大型企业报表引擎的优化设计与实现

报表是企业级应用系统的重要组成部分,优秀的报表可以对基础数据进行过滤、合并、统计、分析,提供直观的表达形式,并为决策提供良好的依据。目前大型企业基于B/S的报表系统开发模式相对不成熟,开发人员大都是根据实际需求直接写代码实现数据的分析、处理、展现功能,这样的实现方式会做很多重复工作,比如很多项目中都需要通过报表数据和图表来展现业务趋势,至于展现的时间粒度、地域粒度、数据纬度和指标却各不相同,结果是不同的。项目中类似的功能需要重复开发,总结起来就是可重用性低、可扩展性差、可维护性差、开发成本高。为解决以上问题,文中提出对业务需求进行高层次的抽象,实现一个能够统一分析数据、处理数据、展现信息的优化报表引擎,该报表引擎专注于业务逻辑的实现,与具体的业务分离,能帮助开发人员快速稳定地构建报表应用系统。基于该报表引擎开发的报表系统已应用于某省级电信运营商,从实际的运行情况看,系统运行稳定,并表现出良好的可扩展性,经过多用户并发查询、大数据量查询的测试,性能表现良好。     

利用ASP建立基于Web的MIS系统技术实现方法

主要提出了基于Web的ASP网页制作技术建立MIS系统的技术实现思路和方法，给出了实现数据维护、浏览查询、报表生成、统计图形分析系统实现方法和实现过程。     

利用信息化技术提升质量数据统计应用水平

前言2008年6月-8月,应质量管理处要求,信息中心实施开发了《烟支物检数据分析处理系统》。该系统能够将卷包车间的烟支物理检测实验室数据自动分析提取、生成相关复杂报表,以供相关人员操作、查询。系统操作简单,报表查询快捷、功能齐全、界面友好。该系统的实施,很大程度上减轻了工作人员劳动强度,提高了质量数据统计效率。     

城市供水调度管理一体化信息平台设计与实现

城市供水调度管理一体化信息平台由主控中心站、二级控制中心站、中继站和管网终端站四部分组成,系统共分五个功能模块。数据采集模块完成指定数据的自动采集及处理,人机接口模块录入人工数据和输入调度管理指令,通讯模块通过超短波、局域网、GPRS三种通讯方式建立主控中心站、二级控制中心站和管网终端站的通讯,实现指令分发,各级调度作业和管理人员使用监控模块对系统运行过程进行全方位监控,分析统计模块提供报警查询、历史数据查询以及分类统计,生成统计分析曲线、历史趋势回放曲线和相关报表,系统配置模块完成系统配置和管理。该文给出系统总体结构,分析了系统主要功能,设计了系统用例,完成了系统实现,城市供水调度管理一体化信息平台已成功应用于一大型自来水公司城市给水计算机辅助调度。     

集输管理信息系统的设计与实现

在分析了用户需求的基础上,结合Asp.net和Oracle 9i数据库,开发了集输管理信息系统。该系统主要用于数据的录入、处理、查询、显示、监控、报警等,同时可以实现报表的生成以及生产状态的直观显示,具有在网络上实现各种数据的录入、查询,并浏览各种监控曲线、流程图等功能。该系统和油田生产实际结合紧密,并巧妙地将数据统计和报表结合起来,系统安全可靠,具有较大的推广价值。     

多维分析应用中的模糊查询算法研究

本文利用c#实现了一种改进的Edit Distance算法,并嵌入到基于SQL Server Reporting Services开发的多维报表展现平台中,实现了多维数据集的模糊查询.多个系统的实际运行表明,将模糊查询算法与多维数据库应用结合,提高了系统的是实用性,改进了用户体验.     

管理信息系统中特定条件报表打印功能的实现

在管理信息系统的开发过程中,经常需要根据特定的需求实现数据报表的打印.本文以VB开发语言为例,介绍一种特定条件下报表打印功能的实现方法.在该方法中,采用Excel模板文件,在程序界面中进行特定数据的查询和筛选,并将查询结果输出到Excel模板文件中,实现特定条件下报表的打印功能.     

TIREDDX: an integrated intelligent defects diagnostic system for tire production and service

Tire manufacturing is a complicated process due to the number of processing variables involved, dealing with more than 80 raw materials undergoing six main processing steps. Accordingly, the quality of a tire and its efficiency in use depend highly on the raw materials quality and the processing variables. Consequently, in order to properly diagnose a defect (quality parameter) in a tire, the manufacturing history data of that particular tire is essential, with the raw materials inspection results, as the starting point, and going through all manufacturing steps, to the final inspection results and customer claims.This study presents an integrated tire defects diagnostic expert system (TIREDDX) that can be applied during production and service. The main objective of developing a diagnostic integrated expert system is to achieve an integrated diagnostic procedure. The developed system is able to diagnose the probable cause(s) of the defect by tracing the acquired quality and production information at the various steps of tire manufacturing processes, starting from the serial number the defected tire. Implementing such a system significantly reduces the time consumed in tire defect diagnosis, increases the consistency of diagnosing decision-making, and better utilizes the company's management information system. Moreover, it can be regarded as an advisory tool to those having much technical experience and as a training tool for less-experienced personnel those who seek guidance and advice.TIREDDX comprises two main modules: manufacturing history databases and diagnostic expert system. The system was developed and implemented in one of the leading truck tires production companies in Egypt, where satisfactory results were achieved.     

Knowledge-based approach to quality control assurance using bar code identification systems

A knowledge-based approach to quality assurance using bar code identification systems can be carried out in three different stages. In the first stage, a complete study of the manufacturing processes, raw materials, and procedures of inspection has to be conducted. Data collection forms are prepared and potential trouble areas located to get more information on the types of problems occurring. In the second stage, inspection procedures are established for in-coming raw material. Acceptance Sampling plans have to be agreed upon to facilitate inspection of raw materials. The procedures are based on Acceptance Sampling Military Standards (MIL-STD 105 E and MIL-STD 414). In the last stage an expert system can be developed and integrated with automatic identification of the in-coming raw material packages for acceptance sampling, and with inprocess goods for establishing and monitoring statistical process control.     

基于不确定性信息的水泥生料配料过程智能优化系统

针对水泥生料配料过程原料质量不稳定和检测环节大滞后所引入的诸多信息不确定性,结合目前广泛应用的干法水泥生产工艺,提出了一种生料配料过程两级智能优化系统,即首先对生料配料过程进行率值的优化控制,一定程度地减弱不确定信息对生料质量的影响,然后采用改进性遗传算法求解生料最优调配方案,配制出优质水泥生料,以此达到生料质量的优化...     

Computer-aided visual inspection for integrated quality control

This paper first briefly introduces the fundamentals of automated inspection techniques, followed by a categorization of typical applications. At its focus the paper elaborates on issues relating to the need for, the approach to and the benefits of integrating automatic inspection systems within the context of computer integrated PCB manufacturing. It argues that automatic inspection systems should assume the role of not only quality inspection systems but also important quality information generators on the shop floor. In particular, integrated quality control will be realized through an integration of inspection systems with process/quality control systems such as statistical process control (SPC).     

低碳驱动下考虑废钢质量的钢铁制造供应链稳定性分析

钢铁行业作为最大的碳排放主体,面对日益增大的环保压力,亟待改进工艺流程,提升以废钢为原材料的绿色清洁生产比例.对此,运用博弈论和混沌理论研究环保压力和废钢质量水平对供应链各博弈主体的影响.研究结果表明,外部环保压力的增大会促使钢铁企业逐步向以废钢为主要原料的清洁炼钢模式过渡,逐步提高废钢原料的质量才能使得废钢供应商和钢铁企业达到最优利润.然而,提高废钢原料的质量水平并不利于增强系统的稳定性.当前以铁矿石为主要原材料的钢铁冶炼模式应平稳渐进地向以废钢为原料的清洁生产模式过渡,并通过大数据等信息化技术加强钢铁市场的价格监管,引导企业自律,遵守市场规律调节原材料的价格;否则,价格调整参数超出阈值会导致整个钢铁市场动荡,甚至可能出现经济混沌以及钢铁企业破产.     

Web报表的设计与实现

报表是管理信息系统的重要的组成部分。结合资产管理信息系统Web报表的开发与设计,实现了在ASP．NET的repeater控件申报表的数据导出Excel过程中避免样式发生的变形和精确打印数据的步骤和方法,从而能够实现符合用户需要的复杂Web报表.     

High-resolution eddy current sensor system for quality assessment of carbon fiber materials

Carbon fiber materials become more and more important for many applications. Unlike metal the technological parameters and certificated quality control mechanisms for raw carbon fiber materials (RCF) have not been developed yet. There is no efficient and reliable testing system for an inline inspection and a consecutive manual inspection of the RCF and the post laminated carbon fiber reinforced plastics (CFRP). Based upon the multi-frequency eddy current device developed at Fraunhofer IZFP structural and hidden defects such as missing carbon fiber bundles, lanes, suspensions, fringes, missing sewing threads and angle errors can be detected. Due to the help of an optimized sensor array and an intelligent image pre-processing algorithm the complex impedance signal can be allocated to different carbon fiber layers. This technique enables the detection of defects in the depth up to five layers including the option of free scale measuring resolution and testing frequency. Appropriate parameter lists for an optimal error classification are available. The dimensions of the smallest detectable defects are in the range of a few millimeters. A prototype of a special single sensor and an eddy-current sensor array have been successfully developed thus the way to transfer the prototype into an industrial application is open.     

基于综合监控的设备状态修方案研究

随着工业控制领域的不断发展,综合监控系统已经日趋成熟并于工业现场运行较长时间。而基于综合监控系统获取的大量历史数据的分析和实时数据的使用并没有开展深入的探讨。本方案提出了一种基于综合监控系统的状态修方案,把综合监控系统的历史数据经过一定的清洗,建模导入到大数据平台,通过相应的算法分析,从而改善维修决策模型并建立设备评价体系;把实时数据实时的传递到设备状态页面,减轻了传统巡检工作,保证了设备检查效果;把设备报警数据通过分类,分项,直接派生检修工单,实现了设备维修的自动化。     

基于“互联网+”和“大数据”的输电交互式巡检安全质量管控体系的探索和实践

跟随我国电力体制的深入改革,输电线路的构建规模持续扩大,经济的高速发展、社会的不断进步和人民生活水平的逐步提高都对电力系统运行的安全性提出了更高要求,为了跟上当前这种形式,满足全社会不断提高的用电需求,供电企业必须增强对输电线路安全质量的管控。国网龙岩供电公司以“一六八”新时代发展战略体系为核心,基于“互联网+”和“大数据”技术的发展,以完善传统巡检模式的不足为导向,以推动输电交互式巡检安全质量管控为引领,构建以“过程管控”为目的的输电交互巡检管控模式,搭建“工学一体”的信息交流平台,形成“全程记录”巡检数据库体系,全方位提升巡检工作安全质量及效率。该管控体系应用后,确实能确保巡检数据完整性,减少缺陷隐患漏报率,缩短现场紧急事件响应时间、新人培训上岗时间、常用报表统计时间等,能全面提升巡检安全质量。     

Event-based receding horizon control for two-stage multi-product production plants

In this paper a receding horizon control approach for multi-product production plants is presented. Specifically two-stage plants are considered. In the first stage, a set of parallel production lines generates intermediate products from raw materials. In the second stage, the intermediate products are assembled into final products. A set of buffers for the intermediate products connects the production lines and the assembly line thus allowing a continuous production flow.

The focus is on plants where the switch between product types is less frequent than in the assembly line. The latter is mostly dictated by the external demand, while the first one is the main scheduling variable. A systematic event-based control approach using receding horizon control (RHC) techniques is proposed; specifically the production line flow is controlled in order to satisfy the time-varying request from the assembly line while minimizing the intermediate products storage and processing time. Experimental results underline the benefits resulting from the application of the proposed approach to a car engine manufacturing process.