Analyzing Clickstreams

Jesper Andersen, Anders Giversen, Allan H. Jensen, Rune S Larsen, Torben Bach Pedersen, Janne Skyt

Research output: Book/ReportBookResearch

548 Downloads (Pure)

Abstract

On-Line Analytical Processing (OLAP) enables analysts to gain insight into data through fast and interactive access to a variety of possible views on information, organized in a dimensional model. The demand for data integration is rapidly becoming larger as more and more information sources appear in modern enterprises. In the data warehousing pproach, selected information is extracted in advance and stored in a repository. This approach is used because of its high performance. However, in many situations a logical (rather than physical) integration of data is preferable. Previous web-based data integration efforts have focused almost exclusively on the logical level of data models, creating a need for techniques focused on the conceptual level. Also, previous integration techniques for web-based data have not addresses the special needs of OLAP tools such as handling dimensions with hierarchies. Extensible Markup Language (XML) is fast becoming the new standard for data representation and exchange on the World Wide Web. The rapid emergence of XML data on the web, e.g., business-to-business (B2B) ecommerce, is making it necessary for OLAP and other data analysis tools to handleXML data as well as traditional data formats.. Based on a real-world case study, this paper presents an approach to the conceptual specification of OLAP DBs based on web data. Unlike previous work, this approach takes special OLAP issues such as dimension hierarchies and correct aggregation of data into account. Additionally, an integration architecture that allows the logical integration of XML and relational data sources for use by OLAP tools is presented.
Original languageEnglish
Place of PublicationDepartment of Computer Science
PublisherAalborg Universitetsforlag
Number of pages19
Publication statusPublished - 2000
SeriesTechnical Report
Number00-5001

Fingerprint

XML
Processing
Data integration
Industry
Data warehouses
World Wide Web
Data structures
Agglomeration
Specifications

Cite this

Andersen, J., Giversen, A., Jensen, A. H., Larsen, R. S., Pedersen, T. B., & Skyt, J. (2000). Analyzing Clickstreams. Department of Computer Science: Aalborg Universitetsforlag. Technical Report, No. 00-5001
Andersen, Jesper ; Giversen, Anders ; Jensen, Allan H. ; Larsen, Rune S ; Pedersen, Torben Bach ; Skyt, Janne. / Analyzing Clickstreams. Department of Computer Science : Aalborg Universitetsforlag, 2000. 19 p. (Technical Report; No. 00-5001).
@book{07f7c4d0b4cb11da9c71000ea68e967b,
title = "Analyzing Clickstreams",
abstract = "On-Line Analytical Processing (OLAP) enables analysts to gain insight into data through fast and interactive access to a variety of possible views on information, organized in a dimensional model. The demand for data integration is rapidly becoming larger as more and more information sources appear in modern enterprises. In the data warehousing pproach, selected information is extracted in advance and stored in a repository. This approach is used because of its high performance. However, in many situations a logical (rather than physical) integration of data is preferable. Previous web-based data integration efforts have focused almost exclusively on the logical level of data models, creating a need for techniques focused on the conceptual level. Also, previous integration techniques for web-based data have not addresses the special needs of OLAP tools such as handling dimensions with hierarchies. Extensible Markup Language (XML) is fast becoming the new standard for data representation and exchange on the World Wide Web. The rapid emergence of XML data on the web, e.g., business-to-business (B2B) ecommerce, is making it necessary for OLAP and other data analysis tools to handleXML data as well as traditional data formats.. Based on a real-world case study, this paper presents an approach to the conceptual specification of OLAP DBs based on web data. Unlike previous work, this approach takes special OLAP issues such as dimension hierarchies and correct aggregation of data into account. Additionally, an integration architecture that allows the logical integration of XML and relational data sources for use by OLAP tools is presented.",
author = "Jesper Andersen and Anders Giversen and Jensen, {Allan H.} and Larsen, {Rune S} and Pedersen, {Torben Bach} and Janne Skyt",
year = "2000",
language = "English",
series = "Technical Report",
number = "00-5001",
publisher = "Aalborg Universitetsforlag",

}

Andersen, J, Giversen, A, Jensen, AH, Larsen, RS, Pedersen, TB & Skyt, J 2000, Analyzing Clickstreams. Technical Report, no. 00-5001, Aalborg Universitetsforlag, Department of Computer Science.

Analyzing Clickstreams. / Andersen, Jesper; Giversen, Anders; Jensen, Allan H.; Larsen, Rune S; Pedersen, Torben Bach; Skyt, Janne.

Department of Computer Science : Aalborg Universitetsforlag, 2000. 19 p. (Technical Report; No. 00-5001).

Research output: Book/ReportBookResearch

TY - BOOK

T1 - Analyzing Clickstreams

AU - Andersen, Jesper

AU - Giversen, Anders

AU - Jensen, Allan H.

AU - Larsen, Rune S

AU - Pedersen, Torben Bach

AU - Skyt, Janne

PY - 2000

Y1 - 2000

N2 - On-Line Analytical Processing (OLAP) enables analysts to gain insight into data through fast and interactive access to a variety of possible views on information, organized in a dimensional model. The demand for data integration is rapidly becoming larger as more and more information sources appear in modern enterprises. In the data warehousing pproach, selected information is extracted in advance and stored in a repository. This approach is used because of its high performance. However, in many situations a logical (rather than physical) integration of data is preferable. Previous web-based data integration efforts have focused almost exclusively on the logical level of data models, creating a need for techniques focused on the conceptual level. Also, previous integration techniques for web-based data have not addresses the special needs of OLAP tools such as handling dimensions with hierarchies. Extensible Markup Language (XML) is fast becoming the new standard for data representation and exchange on the World Wide Web. The rapid emergence of XML data on the web, e.g., business-to-business (B2B) ecommerce, is making it necessary for OLAP and other data analysis tools to handleXML data as well as traditional data formats.. Based on a real-world case study, this paper presents an approach to the conceptual specification of OLAP DBs based on web data. Unlike previous work, this approach takes special OLAP issues such as dimension hierarchies and correct aggregation of data into account. Additionally, an integration architecture that allows the logical integration of XML and relational data sources for use by OLAP tools is presented.

AB - On-Line Analytical Processing (OLAP) enables analysts to gain insight into data through fast and interactive access to a variety of possible views on information, organized in a dimensional model. The demand for data integration is rapidly becoming larger as more and more information sources appear in modern enterprises. In the data warehousing pproach, selected information is extracted in advance and stored in a repository. This approach is used because of its high performance. However, in many situations a logical (rather than physical) integration of data is preferable. Previous web-based data integration efforts have focused almost exclusively on the logical level of data models, creating a need for techniques focused on the conceptual level. Also, previous integration techniques for web-based data have not addresses the special needs of OLAP tools such as handling dimensions with hierarchies. Extensible Markup Language (XML) is fast becoming the new standard for data representation and exchange on the World Wide Web. The rapid emergence of XML data on the web, e.g., business-to-business (B2B) ecommerce, is making it necessary for OLAP and other data analysis tools to handleXML data as well as traditional data formats.. Based on a real-world case study, this paper presents an approach to the conceptual specification of OLAP DBs based on web data. Unlike previous work, this approach takes special OLAP issues such as dimension hierarchies and correct aggregation of data into account. Additionally, an integration architecture that allows the logical integration of XML and relational data sources for use by OLAP tools is presented.

M3 - Book

T3 - Technical Report

BT - Analyzing Clickstreams

PB - Aalborg Universitetsforlag

CY - Department of Computer Science

ER -

Andersen J, Giversen A, Jensen AH, Larsen RS, Pedersen TB, Skyt J. Analyzing Clickstreams. Department of Computer Science: Aalborg Universitetsforlag, 2000. 19 p. (Technical Report; No. 00-5001).