CN201021997Y - Data warehouse and business analysis device - Google Patents
Data warehouse and business analysis device Download PDFInfo
- Publication number
- CN201021997Y CN201021997Y CNU2007200064973U CN200720006497U CN201021997Y CN 201021997 Y CN201021997 Y CN 201021997Y CN U2007200064973 U CNU2007200064973 U CN U2007200064973U CN 200720006497 U CN200720006497 U CN 200720006497U CN 201021997 Y CN201021997 Y CN 201021997Y
- Authority
- CN
- China
- Prior art keywords
- server
- data
- etl
- product
- data warehouse
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Fee Related
Links
Images
Abstract
The utility model relates to the telegraphy and information technical field, is a data warehouse and management analysis equipment, comprising a magnetic tape archives, a SAN (Storage Area Network) switch, a DW (Data Warehouse) server, an ETL (Extract, Transform and Load) server, an OLAP (On Line Analysis Process) server, a report forms server, a data mining server, a system management server, a Web server, wherein the magnetic tape archives is connected to the DW server and the ETL server through the SAN (Storage Area Network) switch, the SAN switch is connected to an interface machine with a DCN (Data Communication Network) net, and the DW (Data Warehouse) server, the ETL (Extract, Transform and Load) server, the OLAP (On Line Analysis Process) server, the report forms server, the data mining server, the system management server and the WEB server are connected to each terminal server through the DCN (Data Communication Network) net. The product is optimized a lot to the client interface to assure the operation convenience for the user. The diversity of the function of the product exceeds that of the most like products of the prior market. The product covers all the telecommunications service at present, and is perfected as the service developing. The data veracity and consistency of the product are ensured through the interior ETL (Extract, Transform and Load) management.
Description
[technical field]
The utility model relates to the telecom information technical field, is a kind of data warehouse and performance analysis device.
[background technology]
Telecom operators are through after a while development, and existing basic data is abundant gradually, but situation about will face jointly of ubiquity, the data that are exactly these basic data source are relatively independent, and relevance is little.Because professional system of China Telecom is various, product in the market can't accomplish to cover the whole province's telecommunication service, and the data bore in different operation systems can't be unified, and causes at the report data that obtains from different system inconsistent.
[summary of the invention]
Technical problem to be solved in the utility model is to provide a kind of barrier of breaking Data Source, and the different pieces of information that derives from a plurality of operation systems is integrated, and builds " data warehouse " performance analysis device that covers the whole province's telecommunication service.
The utility model is by the following technical solutions:
Data warehouse and performance analysis device, comprise tape library, SAN (storage area network) switch, DW (data warehouse) server, ETL (data cleansing, conversion, loading) server, OLAP (on-line analytical processing) server, report server, data mining server, system management server, WEB (World Wide Web) server, wherein tape library links to each other with the ETL server with the DW server by the SAN switch, and this SAN switch links to each other with interface message processor (IMP) by DCN (data backbone network) net; DW server wherein, the ETL server, olap server, report server, data mining server, system management server, the WEB server links to each other with each terminal server by the DCN net.
Characteristics and advantage such as that the utility model mainly has is easy and simple to handle, application is various, information is comprehensive, data are accurate.This product has carried out a large amount of optimizations at customer interface, guarantees the convenience that the user operates.This product surpasses the most of like product of existing market on functional diversity.This product has covered present all telecommunication services substantially, and constantly perfect along with business development.This product has been guaranteed the accuracy and the consistance of data by inner ETL management.
[description of drawings]
In conjunction with the embodiments the utility model is described in further detail with reference to the accompanying drawings.
Fig. 1 is the utility model data warehouse and performance analysis device physical connection layout.
Fig. 2 is the utility model data warehouse and performance analysis system structure of device figure.
[embodiment]
As shown in Figure 1, data warehouse and performance analysis device comprise tape library, the SAN switch, the DW server, ETL server, olap server, report server, data mining server, system management server, WEB server, wherein tape library links to each other with the ETL server with the DW server by the SAN switch, and this SAN switch links to each other with interface message processor (IMP) by the DCN net; DW server wherein, the ETL server, olap server, report server, data mining server, system management server, the WEB server links to each other with each terminal server network by the DCN net.
As shown in Figure 2, be the utility model data warehouse and performance analysis system structure of device figure, software section is made up of with system management module, target customer's administration module, ETL console module, application management module, application display module, data-mining module, ETL platform application module integrated.Integrated and system management module: comprise system management module, authority management module, parameter management module, system monitoring module, mainly have performance powerful, safeguard characteristics such as simple.Target customer's administration module: design automatically by inner ETL, make daily peek working interfaceization, intellectuality, can operate, effectively reduce the product maintenance cost.ETL console module:, support data internal conversion and monitoring management as the product nucleus module.Application management module: be responsible for the configuration of product systems parameter, guarantee the stable operation of system.Use display module: the interface of being responsible for product and user interface.Data-mining module: excavate functional promotion product surcharge by external data.ETL platform application module:,, guarantee the applicability of product in conjunction with the secondary development that the localised users demand is carried out based on the ETL console module.
Each module mutual relationship explanation:
1, integrated and system management module is finished the integration of software and hardware as the basis of other modules;
2, application management module is as the system required basis that runs well, and realizes user self-defined to product demand by parameter configuration.
3, the ETL console module is the nucleus module of product, mainly operates on the ETL server, provides various scheduling modes to realize data are extracted, clean, load, change and merge.
4, ETL platform application module is based on the localized adaptive development work on the ETL console module, comprises realizing that KPI data processing, multidimensional analysis processing and data mining need data designated processing, form and extemporaneous data query to handle.
5, use display module be at ETL console module, ETL platform application module to after the finishing dealing with of data, by the systematic parameter that the application management module is provided with, realize users' interfaces is showed.System general user is by the Web server Analysis Service that using system provides (comprising summary of operations analysis, product operational analysis, visitor/customer analysis, competition Analyzing, client's specific analysis and marketing specific analysis) that conducts interviews.
6, target customer's administration module is the User Defined management platform of carrying out on ETL console module basis, and the user of appointment can realize target customer result is showed visit by Web server.
7, data-mining module is in the function of using deep excavation additional on the display module and lifting data value, and data mining server is selected to handle to the data (utilizing ETL corresponding in the ETL platform application module to dispose in advance) that are stored in the DW server in concrete reality.
Operating process: carry out the installation of product software and hardware by integrated with system management module earlier; According to user's requirement, carry out the self-defined setting of product parameters by the application management module; The ETL console module is installed, the release product standard interface; At local individual demand, exploitation ETL platform application module; Application deployment display module after finishing ETL is realized user-accessible; According to user's request and investment, increase the deployment and the exploitation of target customer's administration module and data-mining module.
The utility model is to the foundation of data warehouse and operation analysis system and further perfect, can be according to the essential characteristic of business datum, organize the operation information data model from analytic angle, and precipitation and produce various operation information from business datum progressively, to each level management organization provide unified, real-time, accurately, for the management data of analyzing use.
System's construction will be broken the barrier of Data Source, the different pieces of information that derives from a plurality of operation systems is integrated, set up the data warehouse of " big concentrating ", structure " unified view of customers " truly, allow leader and analyst can grasp telecom client, user's comprehensive information conscientiously, for decision-making provides complete foundation.
The utility model is concluded processing by every telecommunication service information being carried out profound level, adopt data warehouse, OLAP (online) analysis, ETL multiple BI (business intelligence) technology such as (data cleansing, conversion, loadings), introduce analysis patterns such as multidimensional analysis, data mining, forecast assessment, business is carried out multi-angle intellectual analysis and decision analysis, for telecommunications decision-making level with market management work provides in time, science decision foundation accurately.
Claims (1)
1. data warehouse and operation analysis system, it is characterized in that: comprise tape library, the storage area network switch, data warehouse server, data cleansing, conversion, load server, the on-line analytical processing server, report server, data mining server, system management server, www server, wherein tape library links to each other with data cleansing, conversion, load server with data warehouse server by the storage area network switch, and this storage area network switch links to each other with interface message processor (IMP) by the data backbone network; Data warehouse server wherein, data cleansing, conversion, load server, the on-line analytical processing server, report server, data mining server, system management server, www server links to each other with each terminal server by the data backbone network.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNU2007200064973U CN201021997Y (en) | 2007-03-09 | 2007-03-09 | Data warehouse and business analysis device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNU2007200064973U CN201021997Y (en) | 2007-03-09 | 2007-03-09 | Data warehouse and business analysis device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN201021997Y true CN201021997Y (en) | 2008-02-13 |
Family
ID=39089409
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNU2007200064973U Expired - Fee Related CN201021997Y (en) | 2007-03-09 | 2007-03-09 | Data warehouse and business analysis device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN201021997Y (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101587477B (en) * | 2008-05-23 | 2012-10-31 | 阿里巴巴集团控股有限公司 | Method and system for automatically maintaining ETL modules |
| CN103136335A (en) * | 2013-01-31 | 2013-06-05 | 北京千分点信息科技有限公司 | Data control method based on data platforms |
| CN103679309A (en) * | 2012-09-13 | 2014-03-26 | 余明阳 | Intelligent statistical analysis method for power data warehouse services |
| CN105787059A (en) * | 2016-02-29 | 2016-07-20 | 四川长虹电器股份有限公司 | Data warehouse based financial data integration method |
| CN109614448A (en) * | 2018-11-09 | 2019-04-12 | 南京软智信息技术有限公司 | A kind of data warehouse management system |
| CN113190630A (en) * | 2021-05-31 | 2021-07-30 | 深圳金石创新科技有限公司 | Data integration method and system for constructing enterprise data warehouse |
-
2007
- 2007-03-09 CN CNU2007200064973U patent/CN201021997Y/en not_active Expired - Fee Related
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101587477B (en) * | 2008-05-23 | 2012-10-31 | 阿里巴巴集团控股有限公司 | Method and system for automatically maintaining ETL modules |
| CN103679309A (en) * | 2012-09-13 | 2014-03-26 | 余明阳 | Intelligent statistical analysis method for power data warehouse services |
| CN103679309B (en) * | 2012-09-13 | 2017-11-03 | 国网湖北省电力公司 | A kind of electric power data warehouse business intelligence statistical analysis technique |
| CN103136335A (en) * | 2013-01-31 | 2013-06-05 | 北京千分点信息科技有限公司 | Data control method based on data platforms |
| CN103136335B (en) * | 2013-01-31 | 2016-06-29 | 北京百分点信息科技有限公司 | A kind of data control method based on data platform |
| CN105787059A (en) * | 2016-02-29 | 2016-07-20 | 四川长虹电器股份有限公司 | Data warehouse based financial data integration method |
| CN109614448A (en) * | 2018-11-09 | 2019-04-12 | 南京软智信息技术有限公司 | A kind of data warehouse management system |
| CN113190630A (en) * | 2021-05-31 | 2021-07-30 | 深圳金石创新科技有限公司 | Data integration method and system for constructing enterprise data warehouse |
| CN113190630B (en) * | 2021-05-31 | 2022-02-01 | 深圳金石创新科技有限公司 | Data integration method and system for constructing enterprise data warehouse |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN201021997Y (en) | Data warehouse and business analysis device | |
| CN109710678B (en) | Real-time data system for industrial big data monitoring management and operation method | |
| CN103514514A (en) | On-line monitoring method for electricity marketing business data | |
| CN106651633A (en) | Power utilization information acquisition system and method based on big data technology | |
| CN102739420A (en) | Distributed complex giant system based on digital drainage network operation management and maintenance | |
| CN103559562A (en) | Power grid intelligent operation system and achieving method thereof | |
| CN102722764A (en) | Integrated power grid optimization auxiliary decision analysis system | |
| CN101854652A (en) | Telecommunications network service performance monitoring system | |
| CN103473639A (en) | Method and system for intelligent supervision of coal mine safety production | |
| CN103593804A (en) | Electric power information communication scheduling and monitoring platform | |
| CN102932447A (en) | Distribution room remote data acquisition and analysis system | |
| CN102082826B (en) | Electric energy data cloud collection system and method | |
| CN102013056A (en) | Configurable power report management system and operating method thereof | |
| CN101141370A (en) | Gridding service based electric power enterprise real-time data processing method | |
| CN102111285A (en) | Method and system for managing log information | |
| CN103793204A (en) | Data analysis system (SRC) based on cloud computing | |
| CN109636307B (en) | River chang APP system | |
| CN106597901A (en) | Distributed integral energy consumption management and analysis method and system based on cloud service | |
| CN105930511A (en) | Answer big data subscription platform | |
| CN201536370U (en) | Mobile attendance processing device on attendance record line | |
| CN105139253A (en) | Cloud optimization method for self-service tax handling | |
| CN109002901A (en) | A kind of province ground county's integration electric network information total management system and device | |
| CN102523357A (en) | Provincial-concentrated power customer service system | |
| CN102646119B (en) | Method for realizing integration of standardized system and information system | |
| CN1750038A (en) | Computer managing system for large scale telecommunication enterprise |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20080213 Termination date: 20150309 |
|
| EXPY | Termination of patent right or utility model |