Find an example of an actual data warehouse. For this example, describe the cont

Question

Find an example of an actual data warehouse. For this example, describe the content, purpose, user access methods, and sources of data (what on-line transaction processing [OLTP] databases feed data into the data warehouse) - (make sure that your example is not just a normalized OLTP database that someone has mistakenly misnamed a data warehouse or data mart, or just a vendor's advertisement/description of their product). In addition to answering the question above, to get full credit on this assignment your data warehouse should be publically accessible so that the rest of the class and I can experience it.

Explanation / Answer

Let take an example of SAP BW/4HANA

1. It is the only data wareshouse designed for realtime OLTP and OLAP environments.
2. Data wareouse is a system with a database.
3. Data warehouse architecutre and free up more time for line of business requirements.
4. Easily handle growing volume of data and new business opportunities.
5. It adavantages of simple, open and flexible database warehouse3 tools.
6. SAP BW is used for flowing data, storing data and reporting on that data
7. It has robust capability for connecting to any data sources.
8. It handle data loads
9. Implement physical database partitioning and database compression.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.