制造业的故障分析涉及众多复杂因素和海量数据,传统的故障分析方法已经不能满足需求。利用数据仓库和联机分析处理(OLAP)技术解决电视制造业中的故障分析问题。首先介绍数据仓库和OLAP的基本概念和相关技术,然后在实际应用中利用SQL Ser...制造业的故障分析涉及众多复杂因素和海量数据,传统的故障分析方法已经不能满足需求。利用数据仓库和联机分析处理(OLAP)技术解决电视制造业中的故障分析问题。首先介绍数据仓库和OLAP的基本概念和相关技术,然后在实际应用中利用SQL Server 2000提供的数据转换服务(DTS)来完成数据仓库的构建,并用SQL Server 2000提供的专门用于数据分析的软件Analysis Service完成OLAP分析,最终实现故障分析系统。这一解决方案能够实现传统的信息管理系统向信息分析决策系统的转变。展开更多
Method for data conversion of heterogeneous DBMS's in the integrated network environment is introduced. The technical approach used can perform data conversion of heterogeneous databases located on different nodes...Method for data conversion of heterogeneous DBMS's in the integrated network environment is introduced. The technical approach used can perform data conversion of heterogeneous databases located on different nodes of the network, such as Oracle, Sybase, Informix, MS SQL Server, SQL Anywhere and Foxpro. The conversion system adopts the Client/Server architecture and provides visual integrated interface for users.展开更多
文摘制造业的故障分析涉及众多复杂因素和海量数据,传统的故障分析方法已经不能满足需求。利用数据仓库和联机分析处理(OLAP)技术解决电视制造业中的故障分析问题。首先介绍数据仓库和OLAP的基本概念和相关技术,然后在实际应用中利用SQL Server 2000提供的数据转换服务(DTS)来完成数据仓库的构建,并用SQL Server 2000提供的专门用于数据分析的软件Analysis Service完成OLAP分析,最终实现故障分析系统。这一解决方案能够实现传统的信息管理系统向信息分析决策系统的转变。
文摘Method for data conversion of heterogeneous DBMS's in the integrated network environment is introduced. The technical approach used can perform data conversion of heterogeneous databases located on different nodes of the network, such as Oracle, Sybase, Informix, MS SQL Server, SQL Anywhere and Foxpro. The conversion system adopts the Client/Server architecture and provides visual integrated interface for users.
