需要ETL数据仓库的帮助 [英] Need help for ETL data warehouse
问题描述
大家好，
出于学习目的，我需要您提供以下书面问题的帮助。如果你可以帮助我，请私信给我。
Hi Guys,
I need your help for below written problem for study purposes. If you can help me then please private message me.
"Smart ETL Tool"
It is a desktop application which enables the user to map multiple databases to a DWH in a DBMS. Extract, Transform and Load (ETL) is a process used in Data Warehouse. This process Extracts the data from multiple sources, Transforms the data for storing it in proper format/structure and then Load in to DWH.
Requirements:
1. The user will first select the database/databases and DWH for mapping.
2. The software will show the summery to the user regarding the structure and metadata of the databases as well as of the DWH.
3. The software will provide the facility to the user to map the different tables and columns of database (s) to the tables and columns of DWH.
4. The software should provide the facility to extract the data from multiple databases.
4.1. Extraction can be of the following types.
4.1.1. Full Extraction
4.1.2. Incremental Extraction
5. The software should provide the facility to transform the data.
5.1. The user can select any type of transformation from the following (one or more)
5.1.1. Splitting/Joining
5.1.2. Conversion
5.1.3. Summarization
5.1.4. Enrichment
6. The software should provide the facility to load the data in to DWH.
6.1. The user can select any type of loading from the following
6.1.1. Full data refresh
6.1.2. Incremental data refresh
6.1.3. Trickle/continuous feed
Tools: Java/net Framework And Sql server
我有什么试过：
这是一个桌面应用程序，它允许用户将多个数据库映射到DBMS中的DWH。提取，转换和加载（ETL）是数据仓库中使用的过程。此过程从多个源中提取数据，转换数据以便以适当的格式/结构存储它，然后加载到DWH。
What I have tried:
It is a desktop application which enables the user to map multiple databases to a DWH in a DBMS. Extract, Transform and Load (ETL) is a process used in Data Warehouse. This process Extracts the data from multiple sources, Transforms the data for storing it in proper format/structure and then Load in to DWH.
推荐答案
这不是一个简单的过程。如果这是作业并且你迷路了我会建议你回到你的导师那里寻求他们的帮助。
你究竟需要什么帮助？您是否需要帮助连接数据库，帮助提取数据库对象的元数据等？
This is not a trivial process. If this is homework and you are lost I would suggest you return to your instructor and ask for help from them.
And what exactly do you need help with? Do you need help connecting to a DB, help with extraction of meta data for the DB objects, etc?
出于学习目的，我需要您提供以下书面问题的帮助。
I need your help for below written problem for study purposes.
这是您的HomeWork，所以不要指望本网站有人为您做HomeWork。我们只帮助显示失败代码的程序员进行更正。
您的项目非常庞大，远远超出了快速回答的范围。
如果你无法入门，可以尝试和你的同学合作，或者向你的老师报告。
我想这是一个分析方法不会受到伤害（我知道，需要时间掌握，但最终，它付出）：
- 掌握一些分析方法， Dijkstra自上而下方法是一个好的开始。
https://en.wikipedia.org/wiki/Top -down_and_bottom-up_design [ ^ ]
https://en.wikipedia.org/wiki/Structured_programming [ ^ ]
https://en.wikipedia.org/wiki/Edsger_W._Dijkstra [ ^ ]
https://www.cs.utexas.edu/users/EWD/ewd03xx/EWD316.PDF [ ^ ]
This is your HomeWork, so don't expect someone in this site to do your HomeWork for you. We only help programmers that show failing code, for corrections.
Your project is huge and far out of scope of a quick answer.
If you can't get started, try to team with your classmates, or report to your teacher.
I guess that an analyze method wouldn't harm (I know, it takes time to master, but in the end, it pays):
- Master some analyse methods, Dijkstra Top-Down method is a good start.
https://en.wikipedia.org/wiki/Top-down_and_bottom-up_design[^]
https://en.wikipedia.org/wiki/Structured_programming[^]
https://en.wikipedia.org/wiki/Edsger_W._Dijkstra[^]
https://www.cs.utexas.edu/users/EWD/ewd03xx/EWD316.PDF[^]
这篇关于需要ETL数据仓库的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
