Design and Realization of ETL System for Telecoms Data Warehouse

刘强,翁惠玉

DOI: https://doi.org/10.3969/j.issn.1000-3428.2004.z1.014

2004-01-01

Abstract:This paper discusses the design and realization of the ETL system for telecoms data warehouse. The design can be refered to build data warehouse of other fields.

What problem does this paper attempt to address?

Design and Implementation of Time Series Forecast System in Telecom Enterprises

温长洋,姚敏,沈斌

DOI: https://doi.org/10.3321/j.issn:1000-6788.2003.04.019

2003-01-01

Abstract:Forecast analysis plays an important role in knowledge management system of telecom enterprises. With the advantage of great amount storage of database warehouse, we use algorithms of regression analysis, gray prediction and neural network to organize and compute various data in telecom enterprises, so that help the predictors to make decisions. This paper discusses the structure of time series forecast system, algorithm design and analytic method of results.
Design of data management for real-time database in processing industry

王成光,苏宏业,褚健

DOI: https://doi.org/10.3785/j.issn.1008-973X.2003.02.002

2003-01-01

Abstract:The data model theory of real-time database and data characteristics of the processing industry is studied. Then by employing the latest information technology, a new design method for data management of the processing industry's real-time database is presented for the processing enterprises' application of real-time database. In the data model, data from the processing enterprise is organized by tag mapping technology. The model has a fast query system with multi-layer indexing structure by using STL (standard template library). In addition, the data model support distributed computation in the processing enterprises by adopting COM/DCOM (distributed component object model) technology. The validity and feasibility of the presented design method were proved by the method's successful application in the real-time database software of APC-iSYS.
Design and Implementation of a Data Warehouse ETL Tray Program

Zhi Gang Yang,Li Sun,Xiao Yang Yu

DOI: https://doi.org/10.4028/www.scientific.net/amm.385-386.1684

2013-01-01

Applied Mechanics and Materials

Abstract:This paper presents an ETL system for a data warehouse designed for a PVC profile manufacturing enterprise. The system implements the data extraction, data transformation and load from the data sources of ERP system, CRM system and production line operation data collection system. The ETL requirements are discussed. The system design and implementation methods, including system structure, functions, data processing methods as well as tray program implementation are addressed.
Architecture Design of Wide-area Distributed Real-time Database in Grid Dispatching Control System

Wang Zhihua,Liu Jin,Su Fan,Sun Mingyang,Fan Jing,Zhuang Weijin

DOI: https://doi.org/10.2991/iccte-16.2016.159

2016-01-01

Abstract:Power grid in future will develop into an extra-large interconnected grid with larger transmission capacity and more complex running characteristics. The trend of grid dispatching control system must be global wide-area and dynamic integrated necessarily. In this situation, it makes higher demand for real-time data to support grid supervisory and analysis. However, the existing real-time database with a centralized architecture commonly had the limits of scalability and performance, and it could hardly support a large number of concurrent data access. This paper proposed an architecture design of wide-area distributed real-time database (WDRTDB). WDRTDB divided all the real-time data into parts, and stored them on several servers. In addition, WDRTDB introduced a novel kind of data dictionary to index all data to provide a unified data access service for whole grid. Through experiments, we proved that WDRTDB had a better performance in real-time data processing than existing real-time database system.
Design and Realization of the Sales Analysis System Based on Data Warehouse

李静,陆菊康,汤艳艳,章铭

DOI: https://doi.org/10.3969/j.issn.1000-3428.2003.07.070

2003-01-01

Abstract:This paper introduces the basic character and the general framework of data warehouse. Giving an instance of the big mall's sales analysis system prototype based on data warehouse which are being searched on, the authors visualize and embody the abstract theory. Finally it brings up the necessary trend and the final aim of data warehouse.
Design and Realization of Application Interface Between Real-Time Database and Industrial Process Control System

GAO Feng,WAN Li,LIU Yu-ming,WU Jun-qiang,WANG Xiao-yong,LIANG Jun,WANG Wen-qing,LIU Zhi-peng

DOI: https://doi.org/10.3969/j.issn.1671-7147.2007.01.002

2007-01-01

Abstract:For the application of real-time database in a petrochemical plant,the article put forwards to a new concept to resolve the communication among real-time database and DCS,control software,and Web-based user interface.The scheme is developed based on Windows 2000 Server using the technique of multe-threading,anolymous pipe and WinSock,etc.The results of long industrial running of this scheme show that it is more effective and feasible for industrial process.
The Design and Implement of a Purchase , Sales and Inventory System Based on Data Warehouse Technology

Wei Li,Wanzhou Li

DOI: https://doi.org/10.3321/j.issn:1002-8331.2001.10.032

2001-01-01

Abstract:This paper discusses how to design and implement a purchase,sales and inventory system based on data warehouse technology. An example is also given to describe the methods and steps to build a data warehouse system.
ETL-based Solution for Integrating Data in Financial Domain

苌程,李善平

2010-01-01

Abstract:In order to integrate the distributed data frequently with high performance, an ETL (extract-transform-load) based data integration model is proposed. Business rule has been studied and integrate into this model to get business rule as plug-in transform solution. On demand request and Meta data mapping can shield the difference between the structured data and un-structured data. Performance issue has been analyzed and the incremental integration is introduced to extract data source in an incremental way. Based on practical project, traditional point to point integration is compared to this model to illustrate this model can have high performance and easy to be implemented.
Design Of Distributed Data Warehouse For Sales Decision Of Large-Scale Clothing Enterprise

Ye Zheng,Yang Chunjie,Song Zhihuan

DOI: https://doi.org/10.1109/CHICC.2006.280649

2006-01-01

Abstract:As a result of geographical location and management model, large-scale clothing corporations have expressed their requirements for distributed data management and multi-hierarchy decision support. Based on large-scale clothing corporations, the paper proposes a model of distributed data warehouse for sales decision support system in clothing industry, and illustrates some key techniques in designing data warehouse. The paper also proposes a solution for data transmission from local data warehouse to main data warehouse using the technology of Web Service, and gives an actualization of Web-oriented OLAP.
Research on Customer Relationship Management System Based on Data Warehouse

黄彬,唐任仲

DOI: https://doi.org/10.3969/j.issn.1000-2243.2004.01.007

2004-01-01

Abstract:The concept and structure of data warehouse are briefly introduced. In this paper, demands of customer relationship management system for data warehouse are analyzed, then data modeling techniques for data warehouse are discussed and star-snowflake schema of customer subject is built in the customer relationship management system. In the end, a data warehouse-based solution to the customer relationship management system is provided.
Web-based Data Warehouse System for Process Industry

陈义,宋执环,李平

DOI: https://doi.org/10.3969/j.issn.1006-5911.2003.06.015

2003-01-01

Computer Integrated Manufacturing Systems

Abstract:Based on the information system of large-scale papermaking corporation, this paper analyzes the information flow in process industry, which is consist of three layers such as Business Plan System (BPS), Manufacturing Executive System (MES) and Process Control System (PCS). Comparing the differences of three layers data among the Computer Integrated Production System (CIPS), we present the structure and method of web-based data warehouse.
Application of Data Warehouse in CIPS of Flow Enterprise

吴国良,宋执环,李平

DOI: https://doi.org/10.3969/j.issn.1001-3695.2002.05.037

2002-01-01

Abstract:The paper introduces the application of data warehouse in CIPS ,basing on data warehouse in papermaking corporation.
Application of data warehousing in intelligent public transit system

Da-yi QU,De-yong GUAN,Dian-hai WANG,Feng-yuan WANG

DOI: https://doi.org/10.3969/j.issn.1673-4602.2007.04.023

2007-01-01

Abstract:This paper utilizes data warehouse and data mining technology to analyze GPS positioning data uploaded by intelligent public transit on-board terminal.It helps to improve public transit intelligent level.The analyzed result provides a reliable reference for public transit industry operation and management.It organizes and guides public transit operation process and can assure the city public transit of completing task plan.It ensures that the daily operation management is highly-efficient,planning is scientific,and schedule benefits decision analysis.
DESIGN AND IMPLEMENTATION OF THE TELECOMMUNICATION LINE SYSTEM

Zhi Jin

1997-01-01

Abstract:Telecommunication Line System is used in the management of telecommunication lines in China. The system suits to the three level management:telecommunication bureau general/province/city. The background of the system,the design of DDB and the implementation model of three level DDB,as well as the design and implementation of telecommunication software are described.
Database Design of Communication Station by Using PowerDesigner

井小沛,武斌,蒋东星,赵明

DOI: https://doi.org/10.16208/j.issn1000-7024.2008.08.049

2008-01-01

Abstract:The design process of communication station database is introduced.By the understanding to the business process of com-munication guarantee,combine the communication station organization structure characteristics,and the function in the communication guarantee system,after the analysis of system actual need,the entity object and relation for involve is summarized.Then make use of the mold tool PowerDesigner to build up concept data model and physical data model.The end,a database is successfully established by linking the physical model with SQL Server 2000.
Application of Data Warehouse to Power System

Bin YE,Wei-min ZENG,Zhi-hua XIAO,Chuang-xin GUO,Cheng-zhi ZHU,Yi-jia CAO

DOI: https://doi.org/10.3969/j.issn.1003-8930.2005.03.003

2005-01-01

Abstract:Based on the research on the problems existing in power information construction, an enterprise-wide data warehouse is proposed to acts as the data center.Firstly,this paper describes a possible architecture of the future power utility information system based on the data warehousing strategies.Secondly,to tackle the problem of extracting the data from different systems,a data staging approach based on CIM/XML is designed.Finally,the concrete scheme of the dimensional model design in power utility is proposed,and an application instance is illustrated.
Design and Implementation Based on the.Net Telecom Workers Single Business Systems

Hu Jun,Zhou Yanyan,Zeng Fanxing

DOI: https://doi.org/10.3969/j.issn.1671-4792.2010.07.024

2010-01-01

Abstract:This paper puts forward the design and application of the overall system design ideas solutions.Based on the telecommunications network management system structure,network management in telecom telecom work areas around the design thought,system of telecommunication business work sheet.
To Realize Data Exchange Among Multiple Systems

Yongqin Yang,Zhijun He

DOI: https://doi.org/10.3321/j.issn:1002-8331.2001.02.023

2001-01-01

Abstract:A common method is presented for data exchange among the existing application systems of enterprises.With the method,the problem of inconsistency of table data structure among systems is effectively solved,and which data tables can be exchanged is also not limited.
APPLICATION OF DATA WAREHOUSE AND DATA MINING TECHNIQUES TO POWER SYSTEMS

路广,张伯明,孙宏斌

DOI: https://doi.org/10.3321/j.issn:1000-3673.2001.08.013

2001-01-01

Abstract:A data warehouse is a decision supporting, sub- ject-oriented, assemble, stable and time-dependent collection of data, comparing with data warehouse a data mart is a smaller and centralized one. Data Mining is a data-analyzing and knowledge-acquiring procedure by use of artificial intelli- gence. These new database technologies are introduced in this paper, their application achievements in electric power enter- prises are analyzed, and the current situation and prospect of applying data warehouse and data mart to electric power en- terprises are discussed.
Design and implementation of the Customer Experience Data Mart in the Telecommunication Industry: Application Order-To-Payment end to end process

Mounire Benhima,John P. Reilly,Zaineb Naamane,Meriam Kharbat,Mohammed Issam Kabbaj,Oussama Esqalli

DOI: https://doi.org/10.48550/arXiv.1401.0534

2013-12-31

Abstract:Facing the new market challenges, service providers are looking for solutions to improve three major business areas namely the Customer Experience, The Operational Efficiency and Revenue and Margin. To meet the business requiements related to these areas, service providers are going through three major transformation programs namely the Business Support Systems transformation program for Customer related aspects, the Operations Support System transformation program for mainly service Fulfillment and Assurance and Resource, Fulfillment and Assurance, and Time To Market Transformation program for Products ans Services development and management. These transformations are about making a transition from a current situation with all its views to a desired one. The information view transformation is about reorganizing and reengineering the existing information to be used for the day to day activities and reporting to support decision making. For reporting purpose, service providers have to invest in Business Intelligence solutions. For which the main purpose is to provide the right information in a timely manner to efficiently support the decision making. One of the key BI challenges is to model an information structure where to host all the information coming from multiple sources. The purpose of this paper is to suggest a step by step methodology to design a Telco Data Mart, one of the fundamental BI components. Order-To-Payment, an end to end customer process, will be used as an application for this methodology. Our methodology consists on bringing together the concepts of business intelligence and the telecom business frameworks developed by the TM Forum: the Business Process Framework, the Information Framework, and the Business Metrics. The advantage of this solution is its ability to adapt to any telecom enterprise architecture since it's built around the business standards.

Other Computer Science

Design and Realization of ETL System for Telecoms Data Warehouse

Design and Implementation of Time Series Forecast System in Telecom Enterprises

Design of data management for real-time database in processing industry

Design and Implementation of a Data Warehouse ETL Tray Program

Architecture Design of Wide-area Distributed Real-time Database in Grid Dispatching Control System

Design and Realization of the Sales Analysis System Based on Data Warehouse

Design and Realization of Application Interface Between Real-Time Database and Industrial Process Control System

The Design and Implement of a Purchase , Sales and Inventory System Based on Data Warehouse Technology

ETL-based Solution for Integrating Data in Financial Domain

Design Of Distributed Data Warehouse For Sales Decision Of Large-Scale Clothing Enterprise

Research on Customer Relationship Management System Based on Data Warehouse

Web-based Data Warehouse System for Process Industry

Application of Data Warehouse in CIPS of Flow Enterprise

Application of data warehousing in intelligent public transit system

DESIGN AND IMPLEMENTATION OF THE TELECOMMUNICATION LINE SYSTEM

Database Design of Communication Station by Using PowerDesigner

Application of Data Warehouse to Power System

Design and Implementation Based on the.Net Telecom Workers Single Business Systems

To Realize Data Exchange Among Multiple Systems

APPLICATION OF DATA WAREHOUSE AND DATA MINING TECHNIQUES TO POWER SYSTEMS

Design and implementation of the Customer Experience Data Mart in the Telecommunication Industry: Application Order-To-Payment end to end process