Oracle 8i Data Warehousing (chapter 1, 2). Data Warehousing Lab. 석사1학기 HyunSuk Jung. Chapter 1 - Warehouse: What is it, Who needs it, and Why?.
Data Warehousing Lab.
석사1학기 HyunSuk Jung
: Can I get to my information when I need it?
: How long after transactions occur do I get my information?
: What kind of reports can I get?
: Can I believe the data I get? Is it accurate?
“subject-oriented, integrated, nonvolatile, time-variant collection of data in support of management decisions.”
: data warehousing is not about technology. data warehousing is about solving business problems
“How can I deliver results to a query that summarizes 10 million rows in a reasonable amount of time”
: to provide for faster query throughput.
: Oracle Open Gateway technology
: for moving and transforming data from source systems and it to the data warehouse or data mart.