etl system 中文意思是什麼
-
This system is operated on the platform of unix ( ibm aix ), using powerdesigner as the modeling tool, based on the db storage of oracle9i, carried out etl works with datastage, built multi - dimension cube and laid out the result upfront by cognos. design and research of the whole dw system was deeply and particularly set forth here, this may make help to unicorn ' s dw project period 2 on theory
本系統以unix （ ibmaix ）操作系統為開發平臺，使用powerdesigner為建模工具，基於oracle9i的數據庫存儲，以datastage進行etl操作，以cognos作為多維立方體生成及前端展示工具，對整個數據倉庫系統的設計和研究做了深入的分析和詳細的闡述，為數據倉庫二期工作提出了理論上的幫助和建議。 -
The multidimensional data model of the sample database is designed as star schema. the etl tool is implemented curtly and the tool is independence on structure in order to make the multidimensional query analysis be independent of data source, thereby, the expansibility of system is enhanced
以星型模式設計了實例數據庫的多維數據模型，並簡單地實現了數據的提取與轉換工具，該工具獨立於查詢分析系統，使得查詢分析與數據來源無關，增強了系統的可擴展性。 -
He implements the system in three layers : first, in the semantic definition layer, it establishes the data structure construct and semantic model ; second, in the data processing layer, it integrates the financial data and the other business data into the convenience analysis form according to etl ( extract transform loading ) action ; finally, in the presentation layer it implements slice, rotation and drill down / up action. so it meets the requirement of financial analysis and financial management for enterprise
在語義定義層完成企業數據結構的搭建和語義建模工作；在數據處理層通過一系列的etl （析取、轉換、加載）操作，實現了對企業財務數據及相關業務數據的有效整合，並且最終形成便於分析的多維數據體系：進而在數據表現層實現了對目標數據的切片、旋轉、鉆取等多種手段的分析操作，以滿足企業財務分析、財務管理以及決策支持工作的需要。 -
This paper introduced the development and related theory of data warehouse, discussed the securities industry solution of data warehouse application ; according to the characteristic and business demands of securities companies, the paper presented an architecture of securities data warehouse system, and introduced the function of each component ; after describing the task of database structure design, this paper brought forward an example of database design around the object of stock quotation analysis ; moreover, as an emphasis, the interface of operational system and data warehouse environment, the etl technology, was deeply discussed. an example of data transfer by dts was presented
本文介紹了數據倉庫技術的發展現狀和基本原理，討論了數據倉庫技術在證券公司的應用意義；根據證券公司的數據特點和業務需求，提出證券公司數據倉庫系統的總體框架；圍繞股票行情數據分析這個主題，構建了一個數據倉庫設計的實例，探索證券公司數據倉庫的目標數據庫結構的設計方法；深層次討論了業務系統數據到數據倉庫環境的etl技術，並完成了一個利用dts工具進行源數據導入的實例。 -
Based on the actual background of jinhua electric power and the application level of business intelligence ( bi ) technology, the construction objective supplementary decision system of operational analysis in jinhua electric power is determined. the useful data acquired by etl tools will be concentrated in data warehouse or data markets. decision proposal will be made on electric equipments maintenance, reactive power control, electric line operational analysis, equipment defect prevention and control and electric power fault diagnosis by adopting dw, olap and dm technologies
針對金華電網運行生產的實際情況，結合當今業務智能技術（ bi ）的應用水平，金華電網運行分析輔助決策系統的建設目標是：在全局數據中心集中存儲和管理經過清洗、抽取后各種有用信息，並在數據集中的基礎上，採用數據倉庫（ dw ） 、聯機事務分析（ olap ）和數據挖掘（ dm ）等技術對大量的數據和信息進行分析和挖掘，提出有益於電力設備檢修、電壓無功優化、線路運行分析、缺陷預控和故障診斷等的決策建議。 -
Redesign and realize the clear up and upfront work of data source according to new demands is unbearable on waste of time and manpower. the article described development and analysis status of ubisp ( united business information service platform ) system, analyzed the extract strategy and optimized algorithm of etl rules, discussed the data capacity and granularity selection in dw modeling, raised an idea of how to sub divide dimension table and fact table ' s granularity by compound primary key aimed at above question
本論文介紹了該電信公司經營分析數據倉庫系統的開發與研究現狀，分析了etl規則的抽取策略和優化演算法，討論了數據倉庫建模中的數據量估算和粒度選擇，並針對上面的問題提出了利用復合主鍵和橫表縱表之間的轉換實現維表和事實表粒度向下細分的思想，即在不修改源數據提供系統的情況下，最大限度的利用已有的數據實現新的需求。
分享友人