JSRs: Java Specification Requests
JSR 69: Java OLAP Interface (JOLAP)
This JSR has been Withdrawn
Section 1. Identification
Submitting Participant: Hyperion Solutions Corporation
Name of Contact Person: John D. Poole
E-Mail Address: firstname.lastname@example.org
Telephone Number: +1 203 703 4359
Fax Number: +1 203 329 6729
List of other Participants who endorse this JSR:
Daniel T. Chang
Projected expert group will include experts from:
Section 2: Request
2.1 Please describe the proposed Specification:
The JOLAP specification will address the need for a pure Java API that supports the creation, storage, access and maintenance of data and metadata in OLAP servers and multidimensional databases (referred to generically as "OLAP systems" throughout the rest of this document).
2.2 What is the target Java platform? (i.e., desktop, server, personal, embedded, card, etc.)
JOLAP is targeted for the JavaTM 2 Platform, Enterprise Edition (J2EETM).
2.3 What need of the Java community will be addressed by the proposed specification?
The Java community needs a standard way to create, store, access and maintain data and metadata in OLAP systems serving J2EE-compliant application servers. Currently, there is no widely-agreed upon, standard API for doing this. By using JOLAP, implementors of OLAP systems can expose a single, standard API that will be understood by a wide variety of client applications and components running on the J2EE Platform. Similarly, OLAP clients can be coded against a single API that is independent of the underlying data resource (e.g., native multidimensional database versus relational star-schema). The ultimate goal of JOLAP is to provide for OLAP systems what JDBC did for relational databases.
2.4 Why isn't this need met by existing specifications?
Currently, no existing Java platform specification provides a standard API for OLAP systems. Existing APIs are generally vendor-proprietary. The only standard that comes close is the OLAP Council's MD-API, but this is a query-only interface that does not support database updates and, being an earlier standard, is not J2EE compatible.
2.5 Please give a short description of the underlying technology or technologies:
JOLAP will be based on a highly-generalized, object-oriented, OLAP conceptual model. This model will support three conceptual areas that are generally of key interest to users of OLAP systems: Metadata, Data, and Query. Metadata and Data provide interfaces supporting OLAP metadata and data manipulation, respectively. Query defines interfaces supporting general OLAP queries (both metadata and data) and management and manipulation of result sets. The object model provides a core layer of services and interfaces that are available to all clients. Clients consistently see the same interfaces and semantics and are coded to these interfaces. A particular deployment of the object model may not necessarily support all interfaces and services defined by JOLAP. However, JOLAP will provide mechanisms for client discovery of supported interfaces, capabilities, and constraints.
It is up to each vendor to decide how to implement JOLAP. Some vendors might decide to implement JOLAP as the native API of their product. Others may opt to develop a driver/adapter that mediates between a core JOLAP layer and multiple vendor products. The JOLAP specification does not prescribe any particular implementation strategy.
To ensure J2EE compatibility and eliminate duplication of effort, JOLAP will leverage existing specifications. In particular, JOLAP will rely on the Java Connection Architecture (JSR-000016) to provide resource management, transaction management, security, and record mapping and result set management. JOLAP will also leverage the forthcoming Java Metadata Interface (JSR-000040) for core metadata management (i.e., JOLAP metadata interfaces will most likely extend core JMI interfaces to represent OLAP metadata concepts, such as dimension and hierarchy).
2.6 Is there a proposed package name for the API Specification? (i.e., javapi.something, org.something, etc.)
The following are proposed as JOLAP standard extension packages:javax.olap
2.7 Does the proposed specification have any dependencies on specific operating systems, CPUs, or I/O devices that you know of?
JOLAP has no specific operating system or hardware dependencies.
2.8 Are there any security issues that cannot be addressed by the current security model?
JOLAP will exploit the existing security mechanisms of both J2EE (JSR-000016 in particular) and those of the underlying OLAP systems.
2.9 Are there any internationalization or localization issues?
JOLAP uses the I18N support in the JavaTM 2 Platform, Standard Edition (J2SE)
2.10 Are there any existing specifications that might be rendered obsolete, deprecated, or in need of revision as a result of this work?
There are no existing specifications or specification requests pending that would be rendered obsolete by the JOLAP specification. There are no existing specifications that would require revision as a result of JOLAP.
Section 3: Contributions
3.1 Please list any existing documents, specifications, or implementations that describe the technology. Please include links to the documents if they are publicly available.
The following specifications serve (in part) as design references for JOLAP:
3.2 Explanation of how these items might be used as a starting point for the work.
The above sources generally serve (in part) as design references for JOLAP.
Section 4: Additional Information
4.1 This section contains any additional information that the submitting Participant wishes to include in the JSR.
The availability of a J2EE-compliant OLAP API will provide great benefit to both vendors and users of tools and applications in the areas of business intelligence/business analytics, OLAP systems, and data warehousing. It will provide a standard API for creating, storing, accessing, and managing all metadata and data related to OLAP systems, and greatly simplify client logic by providing a common OLAP interface. Clients coded to these interfaces will be capable of connecting to a diverse set of OLAP systems provided by different vendors. Similarly, OLAP systems supporting JOLAP will be capable of offering their services to a wide range of clients that can immediately connect to them without re-coding or using adapters.
Furthermore, JOLAP's close alignment with JSR-000040 and the CWM Multidimensional and OLAP metamodels means that it directly supports the constuction and deployment of data warehousing and business intelligence applications, tools, and platforms based on OMG open standards for metadata and system specification (i.e., MOF, UML, XMI, CWM) and the forthcoming Java metadata standard (JSR-000040).