CN207319235U - ETL data warehousing and storage systems - Google Patents
ETL data warehousing and storage systems Download PDFInfo
- Publication number
- CN207319235U CN207319235U CN201721012693.1U CN201721012693U CN207319235U CN 207319235 U CN207319235 U CN 207319235U CN 201721012693 U CN201721012693 U CN 201721012693U CN 207319235 U CN207319235 U CN 207319235U
- Authority
- CN
- China
- Prior art keywords
- processor
- etl
- storage systems
- distributor
- data warehousing
- 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.)
- Active
Links
Abstract
The utility model discloses a kind of ETL data warehousing and storage systems, it is characterised in that：Including ETL equipment, the network interface being connected with the ETL equipment, the collector being connected with the network interface, the processor being connected with the collector, the distributor being connected with the processor and the memory being connected with the distributor, the ETL data warehousing and storage systems further include the display device for the printer being connected with the processor, the processor and the information bidirectional intercommunication of the distributor and the information bidirectional intercommunication of the distributor and the memory, the ETL data warehousing and storage systems can establish unified data warehouse, realize distribution disparate databases standardization, it is unitized.
Description
Technical field
It the utility model is related to environmental monitoring technology field, and in particular to a kind of ETL data warehousing and storage systems.
Background technology
Data warehouse (Data Warehouse, DW) is a subject-oriented, integrated, metastable, reflection is gone through
The data acquisition system of history change, for supporting administrative decision.Data warehouse is an independent data environment, and data pick-up, turn
It is the important ring for building data warehouse to change and load (Extraction-Transformation-Loading, ETL).
ETL is used for by distribution, in heterogeneous data source data (for example, relation data, flat data file etc.) and extracts
Cleaned, changed and integrated after to interim intermediate layer, finally according to the data warehouse model pre-defined, data are loaded
Into data warehouse, the data warehouse of structure is set to become the basis of on-line analytical processing and data mining.Technically, ETL master
It is related to associating, changes, increment, several aspect such as scheduling and monitoring.In general, the data in data warehouse do not require with it is online
Real time data synchronization in transacter, therefore, ETL can be carried out periodically, but the operating time of multiple ETL, order and
Success or failure have vital influence to the validity of Data Warehouse, so as to directly influence on-line analytical processing result
With the quality of data mining results.
Since environmental protection industry (epi) monitoring field early pre-exists the skimble-scamble present situation of equipment, system, database, cause the currently monitored
Equipment is difficult to share there are various environmental monitoring resource datas, data format disunity, data deficiency authenticity and reliability etc.
Problem, so that have impact on the later stage carries out secondary application to data.
Utility model content
Unified data warehouse is established the purpose of this utility model is to provide a kind of, realizes distribution disparate databases
Standardization, unitized ETL data warehousing and storage systems.
To achieve the above object, the utility model provides following technical solution：A kind of ETL data warehousing and storage systems, its feature
It is：The network interface that is connected including ETL equipment, with the ETL equipment, the collector being connected with the network interface and institute
Processor, the distributor being connected with the processor and the memory being connected with the distributor of collector connection are stated, it is described
ETL data warehousing and storage systems further include the display device for the printer being connected with the processor, the processor and the distribution
The information bidirectional intercommunication of device and the information bidirectional intercommunication of the distributor and the memory.
Preferably, the memory is information memory cell, for storing terminal support program, and stores relevant configuration text
Part and terminal operation daily record.
Preferably, the ETL equipment JA(junction ambient) monitoring device, for the data connection through enviromental monitoring equipment to described
Memory.
Preferably, the distributor is allocated the data in the processor.
Preferably, the display device is the one or more in display screen, printer, mobile terminal.
Preferably, the mobile terminal is mobile phone or tablet computer.
Preferably, the mobile terminal can carry out two-way intercommunication with the processor and send signal to processor.
Preferably, the processor is able to carry out the signal that mobile terminal is sent, and passes through printer and/or display screen
The signal content to display that display mobile terminal is sent.
Preferably, the printer and display screen can only receive the signal that processor is sent and cannot send and believe to processor
Number.
Compared with prior art, the beneficial effect of the utility model ETL data warehousing and storage systems is：A kind of ETL data
Warehousing system includes ETL equipment, processor, memory and display device, the ETL equipment JA(junction ambient) monitoring device, and incites somebody to action
The data sending that enviromental monitoring equipment monitors is stored to processor after distributor is allocated data, display dress
The data for putting display are shown after processor processing and distributor distribution, can not only establish unified data warehouse,
And it can realize the standardization of distribution disparate databases, unitize.
Brief description of the drawings
Fig. 1 is the schematic diagram of the utility model ETL data warehousing and storage systems.
Embodiment
The following is a combination of the drawings in the embodiments of the present utility model, and the technical scheme in the embodiment of the utility model is carried out
Clearly and completely describe, it is clear that the described embodiments are only a part of the embodiments of the utility model, rather than whole
Embodiment.Based on the embodiment in the utility model, those of ordinary skill in the art are without making creative work
All other embodiments obtained, shall fall within the protection scope of the present invention.
A kind of referring to Fig. 1, ETL data warehousing and storage systems provided by the utility model, it is characterised in that：Including ETL equipment,
The network interface that is connected with the ETL equipment, the collector being connected with the network interface, the processing being connected with the collector
Device, the distributor being connected with the processor and the memory being connected with the distributor, the ETL data warehousing and storage systems also wrap
Include the display device for the printer being connected with the processor, information bidirectional intercommunication and institute of the processor with the distributor
State the information bidirectional intercommunication of distributor and the memory.
Memory is information memory cell, for storing terminal support program, and stores associated profile and terminal
Operation log.The ETL equipment JA(junction ambient) monitoring device, for the data connection through enviromental monitoring equipment to the storage
Device.The distributor is allocated the data in the processor.The display device is display screen, printer, moves eventually
One or more in end.The mobile terminal is mobile phone or tablet computer.The mobile terminal can with the processor into
The two-way intercommunication of row simultaneously sends signal to processor.The processor is able to carry out the signal that mobile terminal is sent, and by beating
Print machine and/or display screen show the signal content to display that mobile terminal is sent.The printer and display screen can only connect
Signal cannot be sent by the signal that processor is sent to processor.
A kind of ETL data warehousing and storage systems of the utility model include ETL equipment, processor, memory and display device, institute
ETL equipment JA(junction ambient) monitoring devices are stated, and by the data sending that enviromental monitoring equipment monitors to processor, and by distribution
Device stores after being allocated to data, and the data that display device is shown are shown after processor processing and distributor distribution, no
Unified data warehouse can be only established, and can realize the standardization of distribution disparate databases, unitize.
The advantages of basic principle and main feature and the utility model of the utility model has been shown and described above.One's own profession
The technical staff of industry is it should be appreciated that the present utility model is not limited to the above embodiments, described in above embodiments and description
Simply illustrate the utility model principle, on the premise of not departing from the spirit and scope of the utility model, the utility model is also
Various changes and modifications are had, these various changes and improvements fall within the scope of the claimed invention.The utility model
Claimed scope is defined by the appending claims and its equivalent thereof.
Claims (6)
- A kind of 1. ETL data warehousing and storage systems, it is characterised in that：The network interface that is connected including ETL equipment, with the ETL equipment, The collector that is connected with the network interface, the processor being connected with the collector, the distributor being connected with the processor And the memory being connected with the distributor, the ETL data warehousing and storage systems further include the printer being connected with the processor Display device, the information bidirectional intercommunication of the processor and the distributor and the information of the distributor and the memory Two-way intercommunication；The memory is information memory cell, for storing terminal support program, and store associated profile and Terminal operation daily record；The ETL equipment JA(junction ambient) monitoring device, is deposited for the data connection through enviromental monitoring equipment to described Reservoir；The distributor is allocated the data in the processor.
- A kind of 2. ETL data warehousing and storage systems according to claim 1, it is characterised in that：The display device for display screen, One or more in printer, mobile terminal.
- A kind of 3. ETL data warehousing and storage systems according to claim 2, it is characterised in that：The mobile terminal for mobile phone or Tablet computer.
- A kind of 4. ETL data warehousing and storage systems according to claim 3, it is characterised in that：The mobile terminal can be with institute Processor is stated to carry out two-way intercommunication and send signal to processor.
- A kind of 5. ETL data warehousing and storage systems according to claim 4, it is characterised in that：The processor is able to carry out moving The signal that dynamic terminal is sent, and show that the signal that mobile terminal is sent is to display interior by printer and/or display screen Hold.
- A kind of 6. ETL data warehousing and storage systems according to claim 5, it is characterised in that：The printer and display screen are only It can receive the signal that processor is sent and signal cannot be sent to processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201721012693.1U CN207319235U (en) | 2017-08-14 | 2017-08-14 | ETL data warehousing and storage systems |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201721012693.1U CN207319235U (en) | 2017-08-14 | 2017-08-14 | ETL data warehousing and storage systems |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN207319235U true CN207319235U (en) | 2018-05-04 |
Family
ID=62431423
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201721012693.1U Active CN207319235U (en) | 2017-08-14 | 2017-08-14 | ETL data warehousing and storage systems |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN207319235U (en) |
-
2017
- 2017-08-14 CN CN201721012693.1U patent/CN207319235U/en active Active
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104252536B (en) | A kind of internet log data query method and device based on hbase | |
| CN204883802U (en) | Automatic stock statistical system of thing networking of weight inductor and applied this inductor | |
| CN104104738A (en) | FTP-based (file transfer protocol-based) data exchange system | |
| CN103095819A (en) | Data information pushing method and data information pushing system | |
| CN103747084A (en) | Off-line access method and system for advanced enterprise mobile application platform | |
| CN103246963B (en) | Based on the staffs training system of Internet of Things | |
| CN106161644A (en) | The distributed system of data process and data processing method thereof | |
| CN110837423A (en) | Method and device for automatically acquiring data of guided transport vehicle | |
| CN102937984B (en) | A kind of collect the system of data, client and method | |
| CN105183299A (en) | Human-computer interface service processing system and method | |
| CN102916987A (en) | Data acquisition and management system based on cloud computing framework | |
| CN108877188A (en) | A kind of environment protection digital concurrently acquires and Multi net voting dissemination method and device | |
| CN103345486A (en) | Method for obtaining and showing picture file by client side under remote browsing environment | |
| CN207319235U (en) | ETL data warehousing and storage systems | |
| CN203773297U (en) | ESB bus-based waste paper warehouse management system structure | |
| CN103633736B (en) | From the on-line monitoring communication means of power transformation substation to main website | |
| CN102902593B (en) | Agreement distributing and processing system based on caching mechanism | |
| CN105162837A (en) | Method and system for improving I/O throughput rate in massive data storage environment | |
| CN204046648U (en) | Based on the inn management platform of cloud computing | |
| CN115936302A (en) | Cost sharing method and device, storage medium and computer equipment | |
| CN115794804A (en) | Engineering internal control data visualization processing system and method based on big data technology | |
| CN107609038A (en) | Data clearing method and device | |
| CN204759502U (en) | Storage management system based on RFID technique | |
| CN103679565A (en) | Intelligent community electricity consumption information collecting server system and data processing method | |
| CN107276821A (en) | User behavior monitoring system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| GR01 | Patent grant | ||
| GR01 | Patent grant |