Issues and Architecture for Supporting Data Warehouse Queries in Web Portals

Authors: Minsoo Lee, Yoon-kyung Lee, Hyejung Yoon, Soo-kyung Song, Sujeong Cheong

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.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1075434

References:

[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.