This article contains content that is written like an advertisement. Please help improve it by removing promotional content and inappropriate external links, and by adding encyclopedic content written from a neutral point of view.(February 2023) (Learn how and when to remove this message)
Essbase
Original author(s)
Arbor Software Corporation
Stable release
21.5
/ June 2023; 11 months ago (2023-06)
Operating system
Windows, Linux, IBM AIX, HP-UX, Solaris
Type
Multidimensional database
License
Proprietary
Website
www.oracle.com/business-analytics/essbase.html
Essbase is a multidimensional database management system (MDBMS) that provides a platform upon which to build analytic applications. Essbase began as a product from Arbor Software, which merged with Hyperion Software in 1998. Oracle Corporation acquired Hyperion Solutions Corporation in 2007. Until late 2005 IBM also marketed an OEM version of Essbase as DB2 OLAP Server.[1]
The database researcher E. F. Codd coined the term "on-line analytical processing" (OLAP) in a whitepaper[2]
that set out twelve rules for analytic systems (an allusion to his earlier famous set of twelve rules defining the relational model). This whitepaper, published by Computerworld, was somewhat explicit in its reference to Essbase features, and when it was later discovered that Codd had been sponsored by Arbor Software, Computerworld withdrew the paper.[3]
In contrast to "on-line transaction processing" (OLTP), OLAP defines a database technology optimized for processing human queries rather than transactions. The results of this orientation were that multidimensional databases oriented their performance requirements around a different set of benchmarks (Analytic Performance Benchmark, APB-1) than that of RDBMS (Transaction Processing Performance Council [TPC]).
Hyperion renamed many of its products in 2005, giving Essbase an official name of Hyperion System 9 BI+ Analytic Services, but the new name was largely ignored by practitioners. The Essbase brand was later returned to the official product name for marketing purposes, but the server software still carried the "Analytic Services" title until it was incorporated into Oracle's Business Intelligence Foundation Suite (BIFS) product.[4]
In August 2005, Information Age magazine named Essbase as one of the 10 most influential technology innovations of the previous 10 years,[5] along with Netscape, the BlackBerry, Google, virtualization, Voice Over IP (VOIP), Linux, XML, the Pentium processor, and ADSL. Editor Kenny MacIver said: "Hyperion Essbase was the multi-dimensional database technology that put online analytical processing on the business intelligence map. It has spurred the creation of scores of rival OLAP products – and billions of OLAP cubes".[6]
^"DB2 OLAP Server". Archived from the original on 2006-12-05. IBM DB2 OLAP Server goes out of support January 31, 2007.
^
Codd, E. F.; S B Codd; C T Salley (1993-07-26). "Providing OLAP to User-Analysts: An IT Mandate" (PDF). Computerworld. Archived from the original (PDF) on 2017-08-08.
^Whitehorn, Mark (26 Jan 2007). "OLAP and the need for SPEED: In another dimension". The Register.
^"Essbase | Business Intelligence". Oracle.
^Rossi, Ben (2006-02-25). "Ten-year top tens". Information Age. Retrieved 2024-01-27.
^"News Release - Hyperion" (Press release). 16 August 2005. Archived from the original on 2007-09-27.
Essbase is a multidimensional database management system (MDBMS) that provides a platform upon which to build analytic applications. Essbase began as a...
Control' called 'Hyperion' 1992 - Arbor Software ships first version of Essbase Online Analytical processing OLAP software 1995 - Due to the success of...
which features in-memory database operations Oracle Essbase, which continues the Hyperion Essbase tradition of multi-dimensional database management MySQL...
product, Essbase, a year earlier. As a result, Codd's "twelve laws of online analytical processing" were explicit in their reference to Essbase. There was...
intelligence, big data discovery, big data preparation, data visualization, and essbase. Security: The Oracle Cloud Platform provides identity and security applications...
to supplement the "Enterprise Edition" of its database. (Oracle offers Essbase for customers without the Oracle Database or who require multiple data-sources...
Global Information