engleski

Developing a General Purpose OLAP Client Prototype Using XML for Analysis

Data warehouse is a copy of transaction data specifically structured for query and analysis [1]. Within data warehouse, data is usually stored in a dimensional model. On-Line Analytical Processing (OLAP) is an approach to analysis and reporting that enables a user to easily and selectively extract and view data from different points of view based on a multidimensional data structure called a cube [2]. There are numerous data warehousing platforms available on the market. Exhaustive data warehousing platform comprises of data warehouse server, OLAP server and some data mining functionality. There are no present standards to support interoperability between different OLAP systems. In this article, two major initiatives towards standardization are examined: XMLA and JOLAP. Web service is a piece of business logic, located somewhere on the Internet, that is accessible through standard-based Internet protocols such as HTTP or SMTP [3]. Web services are neither language nor platformspecific. Using Java programming language, general purpose client tool prototype for standardized OLAP data access is developed. Client communicates with OLAP data source through web service and is based on XMLA 1.1. specification. It is concluded that the client encompasses satisfactory set of functionalities.

OLAP; XMLA; MDX; Data Warehouse

nije evidentirano