Issues and Architecture for Supporting Data Warehouse Queries in Web Portals
Data Warehousing tools have become very popular and currently many of them have moved to Web-based user interfaces to make it easier to access and use the tools. The next step is to enable these tools to be used within a portal framework. The portal framework consists of pages having several small windows that contain individual data warehouse query results. There are several issues that need to be considered when designing the architecture for a portal enabled data warehouse query tool. Some issues need special techniques that can overcome the limitations that are imposed by the nature of data warehouse queries. Issues such as single sign-on, query result caching and sharing, customization, scheduling and authorization need to be considered. This paper discusses such issues and suggests an architecture to support data warehouse queries within Web portal frameworks.
[1] Brio, http://www.brio.com/products/overview.html
[2] Business Objects, http://www.businessobjects.com/products/bobj/
[3] Cognos,PowerPlay,http://www.cognos.com/products/powerplay/index.ht
ml
[4] Oracle, Discoverer,
http://otn.oracle.com/products/discoverer/content.html
[5] Plumtree, http://www.plumtree.com
[6] Microsoft, Sharepoint
Server,http://www.microsoft.com/sharepoint/server/ default.asp
[7] Oracle,Oracle9iASPortal,http://portalcenter.oracle.com/servlet/page?_pa
geid=356&_dad=ops&_schema=OPSTUDIO
[8] IBM,Websphere,http://www-3.ibm.com/software/info1/websphere/index
.jsp?tab=products/portaltoolkit&S_TACT=103BGW01&S_CMP=camp
aign
[9] On Personalizing the Catalogs of Web Portals, N. Spyratos, Y. Tzitzikas,
V. Christophides, Special Track on Semantic Web at the 15th
International FLAIRS'02 Conference, Florida, May 14-16, 2002.
[10] Times-Ten Team, Mid-tier caching: the TimesTen approach. Proceedings
of ACM SIGMOD conference, p. 588-593, Madison, Wisconsin, June 3-6,
2002.
[11] Haifeng Liu, Wee Keong Ng, Ee-Peng Lim, Query Integration for
Refreshing Web Views. Proceedings of DEXA conference, p. 557-566,
Munich, Germany, 2001.
[12] Kurt Stockinger, Kesheng Wu, Arie Shoshani, Strategies for processing
ad hoc queries on large data warehouses. Proceedings of ACM Fifth
International Workshop on Data Warehousing and OLAP, p.72-79,
November 8, 2002, McLean, VA, 2002.
[13] Alexander Kuckelberg, Ralph Krieger, Efficient Structure Oriented
Storage of XML Documents Using ORDBMS. Proceedings of Efficiency
and Effectiveness of XML Tools and Techniques and Data Integration
over the Web, VLDB 2002 Workshop EEXTT and CAiSE 2002
Workshop DTWeb, p. 131-143, Hong Kong, China, 2002.
[14] Dieter Gawlick, Infrasturucture for Web-based Application Integration.
Proceedings of the 17th International Conference on Data Engineering, p.
473-476, Heidelberg, Germany, April 2-6, 2001.
[15] Christian Zirpins, Harald Weinreich, Andreas Bartelt, Winfried
Lamersdorf: Advanced Concepts for Next Generation Portals. WBC -
First International Workshop on Web Based Collaboration (Workshop
with DEXA), p. 501-506, Munich, Germany, 2001.
[16] Arne Koschel: Base Technologies for iPortal development: IONA's
iPortal Suite. Engineering Federated Information Systems, Proceedings of
the 3rd Workshop EFIS 2000, p. 102-105, Dublin, Ireland, June 19-20,
2000.
[17] Charu C. Aggarwal, Philip S. Yu, An Automated System for Web Portal
Personalization, Proceedings of VLDB conference, p. 1031-1040, Hong
Kong, China, 2002.
[18] Christian Wege, Portal Server Technology. IEEE Internet Computing, vol.
6 no. 1, p. 73-77, 2002.
[19] Wen-Syan Li, K. Selçuk Candan, Wang-Pin Hsiung, Oliver Po,
Divyakant Agrawal, Qiong Luo, Wei-Kuang Waine Huang, Yusuf Akca,
Cemal Yilmaz, Cache Portal: Technology for Accelerating
Database-driven e-commerce Web Sites. VLDB 2001, Proceedings of
27th International Conference on Very Large Data Bases, p. 699-700,
September 11-14, 2001, Roma, Italy.
[20] Peter H. Aiken, Kathi Hogshead Davis: Metadata Engineering for
Corporate Portals Using XML. Conceptual Modeling - ER 2000, 19th
International Conference on Conceptual Modeling, p. 572-573, Salt Lake
City, Utah, USA, October 9-12, 2000.
[1] Brio, http://www.brio.com/products/overview.html
[2] Business Objects, http://www.businessobjects.com/products/bobj/
[3] Cognos,PowerPlay,http://www.cognos.com/products/powerplay/index.ht
ml
[4] Oracle, Discoverer,
http://otn.oracle.com/products/discoverer/content.html
[5] Plumtree, http://www.plumtree.com
[6] Microsoft, Sharepoint
Server,http://www.microsoft.com/sharepoint/server/ default.asp
[7] Oracle,Oracle9iASPortal,http://portalcenter.oracle.com/servlet/page?_pa
geid=356&_dad=ops&_schema=OPSTUDIO
[8] IBM,Websphere,http://www-3.ibm.com/software/info1/websphere/index
.jsp?tab=products/portaltoolkit&S_TACT=103BGW01&S_CMP=camp
aign
[9] On Personalizing the Catalogs of Web Portals, N. Spyratos, Y. Tzitzikas,
V. Christophides, Special Track on Semantic Web at the 15th
International FLAIRS'02 Conference, Florida, May 14-16, 2002.
[10] Times-Ten Team, Mid-tier caching: the TimesTen approach. Proceedings
of ACM SIGMOD conference, p. 588-593, Madison, Wisconsin, June 3-6,
2002.
[11] Haifeng Liu, Wee Keong Ng, Ee-Peng Lim, Query Integration for
Refreshing Web Views. Proceedings of DEXA conference, p. 557-566,
Munich, Germany, 2001.
[12] Kurt Stockinger, Kesheng Wu, Arie Shoshani, Strategies for processing
ad hoc queries on large data warehouses. Proceedings of ACM Fifth
International Workshop on Data Warehousing and OLAP, p.72-79,
November 8, 2002, McLean, VA, 2002.
[13] Alexander Kuckelberg, Ralph Krieger, Efficient Structure Oriented
Storage of XML Documents Using ORDBMS. Proceedings of Efficiency
and Effectiveness of XML Tools and Techniques and Data Integration
over the Web, VLDB 2002 Workshop EEXTT and CAiSE 2002
Workshop DTWeb, p. 131-143, Hong Kong, China, 2002.
[14] Dieter Gawlick, Infrasturucture for Web-based Application Integration.
Proceedings of the 17th International Conference on Data Engineering, p.
473-476, Heidelberg, Germany, April 2-6, 2001.
[15] Christian Zirpins, Harald Weinreich, Andreas Bartelt, Winfried
Lamersdorf: Advanced Concepts for Next Generation Portals. WBC -
First International Workshop on Web Based Collaboration (Workshop
with DEXA), p. 501-506, Munich, Germany, 2001.
[16] Arne Koschel: Base Technologies for iPortal development: IONA's
iPortal Suite. Engineering Federated Information Systems, Proceedings of
the 3rd Workshop EFIS 2000, p. 102-105, Dublin, Ireland, June 19-20,
2000.
[17] Charu C. Aggarwal, Philip S. Yu, An Automated System for Web Portal
Personalization, Proceedings of VLDB conference, p. 1031-1040, Hong
Kong, China, 2002.
[18] Christian Wege, Portal Server Technology. IEEE Internet Computing, vol.
6 no. 1, p. 73-77, 2002.
[19] Wen-Syan Li, K. Selçuk Candan, Wang-Pin Hsiung, Oliver Po,
Divyakant Agrawal, Qiong Luo, Wei-Kuang Waine Huang, Yusuf Akca,
Cemal Yilmaz, Cache Portal: Technology for Accelerating
Database-driven e-commerce Web Sites. VLDB 2001, Proceedings of
27th International Conference on Very Large Data Bases, p. 699-700,
September 11-14, 2001, Roma, Italy.
[20] Peter H. Aiken, Kathi Hogshead Davis: Metadata Engineering for
Corporate Portals Using XML. Conceptual Modeling - ER 2000, 19th
International Conference on Conceptual Modeling, p. 572-573, Salt Lake
City, Utah, USA, October 9-12, 2000.
@article{"International Journal of Information, Control and Computer Sciences:59596", author = "Minsoo Lee and Yoon-kyung Lee and Hyejung Yoon and Soo-kyung Song and Sujeong Cheong", title = "Issues and Architecture for Supporting Data Warehouse Queries in Web Portals", abstract = "Data Warehousing tools have become very popular and currently many of them have moved to Web-based user interfaces to make it easier to access and use the tools. The next step is to enable these tools to be used within a portal framework. The portal framework consists of pages having several small windows that contain individual data warehouse query results. There are several issues that need to be considered when designing the architecture for a portal enabled data warehouse query tool. Some issues need special techniques that can overcome the limitations that are imposed by the nature of data warehouse queries. Issues such as single sign-on, query result caching and sharing, customization, scheduling and authorization need to be considered. This paper discusses such issues and suggests an architecture to support data warehouse queries within Web portal frameworks.
", keywords = "Data Warehousing tools, data warehousing queries, web portal frameworks.", volume = "1", number = "7", pages = "2134-6", }
