Web warehousing: Web technology meets data warehousing Technology in Society 252003 131148 Xin Tan,

1
Web warehousing Web technology meets data
warehousing Technology in Society 25(2003)
131-148Xin Tan, David C. Yen,Xiang

• ????? 2003.12.18

2
Outline

• Introduction
• Web warehousing an overview
• Contributing factors and driving forces
• Web warehousing applications
• Evaluating Web warehousing application
• Integrating IT and business functions
• Proposing Web warehousing to top management
• Implementing Web warehousing
• Implications for the future
• Conclusion

3
Defining Web warehousing

• Web warehousing is defined as a combination of
  data warehouse technology and Web technology
• Web warehousing is an architecture that defines a
  set of tools and processes for building useful
  data warehouse systems based on Web technology
• Web warehouse includes not only text and numbers,
  but graphics, video, and other forms
• Web warehouses are not on-line transaction
  processing systems
• Web warehouses organize and manage the stored
  items, but do not collect them

4
Characteristics of Web warehouses
5
The evolution of Web warehousing
6
Contributing factors from data warehousing

• Data warehousing provided many applications that
  run within the Web warehousing environment.
• Data warehousing contributes organizational
  principles and objectives.

7
Contributing factors from Web technology

• Web technology make use of nondata-based
  information just as they can with data-based
  information
• Web technology enables business users to
  manipulate different information and objects
• Web technology making information much easier to
  transfer or retrieve

8
The forces driving Web warehousing

• Web warehousing is driven primarily by technology
  advancement coupled with a paradigm shift in
  technology and business
• Web technology HTML, Java, XML
• Database technology RDBMS, SQL
• The widespread adoption of the Internet
  represents a shift technology and business to an
  open system

9
Web warehousing applications

• Business application
• Data warehousing on the Web
• Knowledge delivery
• Collaborative work groups
• Analysis of massive amounts of input
• Closed-feedback-loop business system
• Consumer application
• Information warehouses
• Support for traditional e-commerce
• Tracking services

10
Evaluating Web warehousing applications

• Web-based query and reporting
• Web-based OLAP
• Web-based statistical analysis
• Web-based data mining/discovery
• Web-based graphical information system

11
Integrating IT and business function

• Sales and marketing
• Production
• Engineering and manufacturing
• retail

12
Proposing Web warehousing to top management

• Cost advantage
• Value-added advantage
• Focus advantage
• Speed advantage
• adaptability advantage

13
Implementing Web warehousing

• Policies/procedures
• Place
• Partner
• People
• Promotion
• Product
• price

14
Web warehousing stages of adoption

• First-order effect simple substitution of the
  new technology for the old.
• Second-order effect increased demand for the
  function(s) provided by the technologies.
• Third-order effect the rise of new
  technology-intensive structures

15
Conclusion

• Only combination of data warehouses, analytical
  applications, and Internet technologies will the
  power of the Web be truly exposed