Browse Prior Art Database

Reporting System for WCS V5.1

IP.com Disclosure Number: IPCOM000015129D
Original Publication Date: 2002-Apr-01
Included in the Prior Art Database: 2003-Jun-20
Document File: 3 page(s) / 163K

Publishing Venue

IBM

Abstract

Disclosed is a Reporting System Framework and Recursive Reporting Framework for e-commerce server. The Reporting System Framework aims to provide a reporting infrastructure to support both on-line and off-line commerce report. The Recursive Reporting Framework is built based on the Reporting System Framework and attempts to resolve complicated and computational intensive recursive reports found in e-commerce applications.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 52% of the total text.

Page 1 of 3

Reporting System for WCS V5.1

  Disclosed is a Reporting System Framework and Recursive Reporting Framework for e-commerce server. The Reporting System Framework aims to provide a reporting infrastructure to support both on-line and off-line commerce report. The Recursive Reporting Framework is built based on the Reporting System Framework and attempts to resolve complicated and computational intensive recursive reports found in e-commerce applications.

Reporting Framework

1.0 Overview

Reporting Framework receives a request from either a Java Servlet (JSP) or a Java Server command. It retrieves queries needed to be run and then execute them. The result data will be sent out to report renderer and let the renderer do proper formatting on the output data. There are two channels in the reporting framework and they are on-line reporting channel and off-line reporting channel. All on-line reports use on-line report channel and all off-line reports use off-line report channel. Once the request is passed into the reporting framework, activities of the request are controlled and managed by a central place called 'Report Control Center'.The query string for this report or the extended report object is loaded from reporting.xml file and managed by 'Report Control Center'.

1.1 Reporting Framework Layer

1

Page 2 of 3

Recursive Reporting Framework
2.0 Overview

Some of the most complicated and computational intensive reports found in E-commerce applications are recursive in nature. One typical example is the revenue report on the product catalog for a store. In order to find the revenue for every category level of the product catalog, the revenue of all the products under that category have to be aggregated, along the tree structure of the catalog. One way of implementation this type of reports is to employ recursive SQL queries. The recursive SQL queries are powerful tools to solve this tree-like data structure reports. However, they pose some serious problems:

Recursive SQL queries are not supported in most popular DBMS, such as ORACLE and IBM DB2 AS400 versions. The recursive SQL queries are too complicated to understand and therefore, difficult to maintain.

It is difficult to c...